Skip to main content
To find your balance at the end of a given month, export the transactions that were both captured in that month and paid out. Summing those transactions gives you the closing balance.
This only works for months where all transactions have already been paid out. If any captures from the target month are still pending payout, the export will not reflect the full balance.

​
Export the transactions

The logic is: captured in month X, paid out in month X+1. You apply both filters together so the export contains only settled transactions from your target month. Example: To find the balance for October, filter by capture date in October and payout date in November.
1

Filter by capture date

In Backoffice, go to Payments > Transactions. Click More, select Capture date, and set the date range to cover the entire target month. Apply the filter.
2

Add a payout date filter

Click More again, select Payout date, and set the date range to the month immediately after your target month. This limits the results to transactions that have been paid out.With both filters applied, you see only the transactions captured in your target month that have a payout date in the following month.
3

Export as CSV

Click Export, select CSV format with Custom date range, and confirm.

​
Calculate the balance

Open the CSV in Excel or a similar tool and sum the transaction amount column. That total is your end-of-month balance.
Last modified on June 18, 2026