The Reconciliation report provides an itemized breakdown of your payouts including processing fees, refunds, and adjustments. This is particularly useful for:
Reconciling your bank deposits against your Pool Brain payment activity
Understanding your processing fees
Generating merchant statements
You can export the reconciliation report for a specific date range to share with your accountant or bookkeeper.
How to Access the Reconciliation Report
Navigate to Reports --> View Stripe Reports, then select the Reconciliation tab.
Which Section Should I Use?
The report has three sections, each answering a different question:
Balance Summary: what changed in my Stripe balance overall?
Payout Reconciliation: what made up the deposits sent to my bank?
Ending Balance Reconciliation: what activity hasn't been included in a payout yet?
Balance Summary
Shows the starting and ending Stripe balance for the period, along with a high-level summary of activity:
Starting balance: the balance at the start of the period
Activity:
Account activity before fees
Fees
Net balance change from activity: activity minus fees
Total payouts: payouts sent out during the period
Ending balance: what's left after payouts
Payout Reconciliation
Breaks down the payouts received in your bank account during the period, grouping the transactions in each payout batch into:
Charges (with a count of how many)
Fees taken from those charges
Refunds (with a count)
Total paid out: the resulting payout amount
If any automatic payouts failed during the period, a "Failed payouts" section appears with the same breakdown. It's hidden entirely when there are none. š See Payment Settlement & Payouts for more on how payouts themselves work.
ā
Ending Balance Reconciliation
Shows the transactions that hadn't been included in a payout yet as of the report's end date, along with the resulting "Ending balance" still sitting in the account.
ā
Downloading the Reports
Each section has its own "Download" button next to its heading.
ā
Balance Summary
The Balance Summary export includes more detail than what's shown on screen. On screen, "Total payouts" is a single line, but the export breaks it into Payouts to bank (the gross amount) and Payout fees, which net together to match the on-screen total.
ā
Payout Reconciliation and Ending Balance Reconciliation
Summary: downloads the totals exactly as shown on screen
Itemized: downloads every individual transaction behind those totals, useful for matching specific charges or refunds line by line
ā