Reconciling a payment processor like Stripe or GoCardless against your accounting system trips people up for one specific reason: the money doesn't arrive the way it was collected. A processor gathers up dozens or hundreds of individual customer payments and deposits them into your bank as a single lump sum — a payout. Your accounting system, meanwhile, knows about the individual payments. Matching one bundled deposit back to many individual records is the whole challenge.
This guide explains how payouts are structured and how to reconcile them cleanly.
Why processor reconciliation is different
When a customer pays you £50 through Stripe, that £50 doesn't land in your bank account immediately or individually. Instead, Stripe holds it, groups it with other payments collected around the same time, deducts its fees, and transfers the net total to your bank a few days later.
So a single £2,340 payout hitting your bank might represent:
- 52 individual customer payments totalling £2,415 in gross charges,
- minus £75 in processing fees,
- equalling the £2,340 net that actually arrived.
Your bank statement shows one line: £2,340. Your sales records show 52 lines. Reconciliation means proving those two views agree.
You're reconciling a one-to-many relationship: one payout on the bank side maps to many payments on the sales side, with fees making the totals deliberately unequal.
The two things you need to match
There are really two reconciliations happening, and separating them makes life much easier:
- Gross payments to your sales records. Every individual charge the processor reports should correspond to a sale, invoice, or order in your system. This confirms you've recorded all your income.
- Net payout to your bank statement. The total transferred, after fees, should match the deposit that landed in your bank. This confirms the money actually arrived.
The bridge between the two is the fee. Gross charges minus fees equals net payout. If that equation holds, the payout reconciles.
Step-by-step reconciliation
- Export the payout breakdown. Both Stripe and GoCardless let you download a report showing every transaction included in a given payout, with the gross amount, fee, and net for each. This is the file that ties everything together.
- Export your sales records for the same period. From your accounting system or CRM, pull the invoices or payments that should correspond to those charges.
- Match on a shared reference. Both files should share something — a payment reference, invoice number, customer reference, or transaction ID. This is your matching key.
- Compare gross amounts. For each matched reference, check the gross charge in the processor report against the amount in your sales records. They should agree.
- Account for fees separately. Fees are a cost, not a discrepancy. Record them as an expense so your net figures line up without appearing as "missing" money.
- Confirm the payout total. The sum of net amounts in the payout report should equal the deposit on your bank statement.
Where it commonly goes wrong
Forgetting the fees
The single most common mistake is comparing gross sales directly to the net bank deposit and panicking that money is missing. It isn't — the gap is the processor's fee. Always reconcile gross-to-sales and net-to-bank as two separate checks, with fees explaining the difference.
Timing across periods
A payment collected on the 31st might not be paid out until the 3rd of the following month. At month-end, you'll have charges recorded that haven't yet appeared as a payout. This is a normal timing difference — the money is in transit, exactly like a deposit in transit in a standard bank reconciliation.
Refunds and chargebacks
A refund reduces a later payout, and a chargeback can appear as a separate deduction. These need matching back to the original transaction so they don't look like unexplained reductions.
Multiple payments under one reference
If a single customer reference covers several payments — say a subscription billed monthly — you'll have one reference appearing on multiple rows. Sum the rows sharing that reference before comparing totals, rather than trying to match line by line.
Match the payout export to your sales file
Upload the processor's transaction report and your sales export — ReconFiles matches them on a shared reference and shows what doesn't line up.
Try the reconciliation tool →The bottom line
Reconciling a Stripe or GoCardless payout feels hard only because the money arrives bundled and net of fees. Break it into two questions — do the gross charges match my sales, and does the net payout match my bank deposit — and the fee neatly explains the gap between them. Once you're thinking in those terms, a payout that looked like a mystery deposit becomes a straightforward match.