Stripe Payout Reconciliation: A Step-by-Step Guide
Match every Stripe payout to the payments, refunds and fees behind it. A practical reconciliation routine for founders, using Stripe's own reports.
To reconcile a Stripe payout, you take the single amount that landed in your bank and break it back into the payments, refunds, disputes and fees that Stripe bundled into it. The fastest route is Stripe's Payout reconciliation report: pick the payout, download the itemized CSV, and check that the lines add up to the deposit.
If your books say you earned one number and your bank says another, this is where the gap usually hides.
Why does a Stripe payout never match a single sale?
Stripe does not send money sale by sale. It collects your balance and pays it out on a schedule. Each deposit is a bundle: charges, minus refunds, minus disputes, minus Stripe's fees, plus or minus adjustments.
So a $4,180 deposit might be 60 sales, three refunds and a fee line. Your accounting tool, which logs sales individually, will not show a $4,180 entry. That mismatch is normal. Reconciliation is the job of proving it is the right mismatch.
Which Stripe report should you use?
Stripe offers several reports, and picking the wrong one is the most common time sink. According to Stripe's reporting documentation, the choice depends on how your payouts are set up.
| Report | What it does | Use it when |
|---|---|---|
| Payout reconciliation | Links each payout to the transactions inside it | You use automatic payouts |
| Balance report | Shows balance movements over a period, but does not link payouts to payments | You use manual payouts or want a period total |
| Bank reconciliation | Matches payouts to bank deposits | You have a direct US account on an automatic payout schedule |
As of October 2026, Stripe's docs say the payout reconciliation report is only available with automatic payouts, and manual-payout users are pointed to the Balance report. Check your own dashboard, since availability can change.
How do you reconcile a payout step by step?
- Find the payout. In the Dashboard, open the reports section and choose Payout reconciliation. Set a date range that includes the payout's estimated arrival date. If you are unsure, widen it.
- Download the itemized CSV. It lists each payment, refund, dispute, fee and other balance transaction in the payout.
- Sum the lines. The total should equal the payout amount. If it does, the payout is explained.
- Match to the bank. Find the deposit on your bank statement and compare the amount and date.
- Record it. In your accounting tool, book gross sales, fees and refunds separately, then clear the payout against the bank line.
If a very recent payout is not in the report yet, check again later before you assume something is missing.
What about unsettled transactions?
The report also has an ending balance section that covers transactions not yet paid out as of the report's end date. This is useful at month end: money that Stripe still holds is real revenue, but it is not in your bank. Put it on your list so the month-end numbers make sense.
What if you use instant payouts?
Here you are on your own. Stripe's docs state that it cannot identify which transactions belong to an instant payout, so you reconcile those against your transaction history yourself. If you can, keep instant payouts rare so most of your volume stays easy to trace.
Can you automate Stripe reconciliation?
Yes, if you have a developer or a no-code tool. The Stripe API lets you list the balance transactions of a payout by passing the payout ID. Stripe recommends fetching payout data when your webhook handler receives the payout.paid or payout.reconciliation_completed event.
A simple setup:
- Listen for the webhook.
- Fetch the payout's balance transactions.
- Compare the sum to the payout amount.
- Flag any payout where the difference is not zero.
Most teams do not need more than that. Flagging exceptions beats building a full ledger.
Common reasons a payout looks wrong
- Refunds issued after the date range. They hit a later payout, not the one you are checking.
- Disputes and dispute fees. A chargeback pulls money back and can add its own fee.
- Currency conversion. If you sell in several currencies, the payout currency and sale currency differ, so compare in the payout currency.
- Different date logic. Your accounting tool may date a sale when the customer paid, while the payout covers it later. Compare by payout, not by sale date.
FAQ
How often should I reconcile Stripe?
Monthly is the minimum. If you process many payments, do it weekly so errors stay small and easy to trace.
Do I need accounting software for this?
Not to start. A spreadsheet and the itemized CSV are enough for a small business. Software helps once volume grows. You can browse options in the Woodander Discover directory.
Is this tax or accounting advice?
No. This is a general walkthrough. Ask a qualified accountant how to book fees and refunds in your country.
Next step
Pick your latest payout today, download the itemized CSV and tick it off against your bank. One clean reconciliation tells you more about your process than a month of staring at dashboards. More tools and guides live in the finance, fintech and investing hub, and you can see which finance tools other founders list on TOP.
