Balance accounting and payout preparation in Telegram
A tool for partner balances, holds and payout requests, with Excel reports and payout files.
The task
Put balance operations and payout preparation into a controlled workflow with separate staff permissions.
What I built
- Credits, debits and held balance tracking.
- Manual payout requests and currency-specific rules.
- Transaction and balance reports, including a balance on a chosen date.
- Excel payout files based on rules and available funds.
How it works
- A staff member records a transaction in the bot.
- The system calculates the available balance after holds.
- An admin generates a report or payout file.
Outcome
Transactions, available balances and exports are managed in one tool. Payout rules are applied when generating the file.
Note
The bot prepares the payout file. The actual transfers are made separately.