Skip to content
Agent Admin Guide

Daily Cash Summary

What it does

Section titled “What it does”

The Daily Cash Summary replaces a hand-kept reconciliation sheet. For any range of days it shows:

  • Credit balance - your opening balance, every movement in the range (player deposits and withdrawals, bonus, cashback, rebate and referral grants, adjustments, company transfers, promotion budget), and your closing balance. A green banner confirms the figures tie: opening plus every movement equals the closing balance, and the closing balance plus everything booked since equals the balance in the top bar now.
  • Bank accounts and payment gateways - for each of your receiving accounts and each gateway: opening, deposits, fees, withdrawals and closing in our books, the actual balance you entered from your bank statement, and the difference.
  • Deposits and withdrawals by status - how many were created in the range, and for how much, by their status now (pending, approved, completed, rejected, disbursed and so on).

Days follow your brand’s timezone, and amounts are in your brand’s currency - both shown under the title. Pick the days with the From / To range below the title; the page opens on today.

Where to find it

Section titled “Where to find it”

Reports -> Finance -> Daily Cash Summary

How the figures are worked out

Section titled “How the figures are worked out”
  • A deposit or withdrawal counts on the day its money moved - when the deposit was credited or the payout was paid - not the day it was created.
  • Deposits are what the player paid in. Fees are what a payment gateway kept from deposits. A manual deposit’s fee stays in your bank, so it is not a fee here.
  • Withdrawals are what actually left the account: the amount minus your withdrawal fee, minus anything a gateway refunded to the player.
  • When a gateway paid part of a withdrawal and you paid the rest from your own bank, each part is counted on the account that paid it.
  • A bank account’s opening balance in our books starts from its first recorded transaction. Money that was already in the account, or that moved without going through the panel, is not in our books - that is what the difference column shows once you enter the real balance.

Record the actual bank balance

Section titled “Record the actual bank balance”

Click the pencil next to an account or gateway and enter the balance on your statement at the end of the last day of the range. The difference column shows actual minus our books. Each entry records who saved it and when, and every change is kept in the Activity Log.

This needs the record actual bank balance permission.

Download

Section titled “Download”

EXPORT DATA (top right) offers Excel or CSV. Either downloads the whole summary as one sheet, one line per account, movement and status.

API

Section titled “API”

The same summary is available as JSON, so your own tools - Claude Desktop, or a script that fills your reconciliation sheet - can read it without anyone copying figures by hand.

Access

Section titled “Access”
  • Use an MCP key from Security & Access -> MCP Access (see MCP Access). A key acts as the staff member who created it, so it reads this report only while they hold the Daily Cash Summary menu.
  • Calls must come from an IP address on your IP allowlist, the same as the panel. A script running on a cloud service (for example Google Apps Script) calls from that service’s addresses, which are not on your allowlist - run it from a machine on an allowed IP.

Request

Section titled “Request”
GET https://<your panel API host>/v1/agent/reports/cash-summary?from=YYYY-MM-DD&to=YYYY-MM-DD
Authorization: Bearer <MCP key>

The MCP Access page shows the API URL for your brand. from and to are days in your brand’s timezone, both included, up to 366 days apart.

Response

Section titled “Response”

The same figures as the page. At the top: currency, time_zone, from, to, the window as UTC instants (window_start, window_end, end excluded) and generated_at. Then:

  • float - the Agent Balance: opening, movements (each with entry_type, source_table, count, amount), net_movement, closing, movements_since (booked after the range), panel_balance (the live balance), and tied (closing + movements_since = panel_balance).
  • rails - one entry per account or gateway: rail_kind, rail_id, label, account, opening, deposits, deposit_count, fees, withdrawals, withdrawal_count, closing, actual_balance, difference, actual_recorded_at, actual_recorded_by; and rails_total.
  • status_counts - side (deposit or withdrawal), status, count, amount.

Amounts are strings with four decimals, for example "215659.4162", so they add up exactly.

Errors

Section titled “Errors”

The MCP Access page lists what each error means. Specific to this report: 403 forbidden_permission when the key’s creator does not hold the Daily Cash Summary menu, and 400 when from / to is missing, not a real date, the wrong way round, or more than 366 days apart.