Check your own payouts free. Every Stripe payout in the last 90 days, matched to the cent. Nothing stored. Run the check →

Guide

How to read Stripe's payout reconciliation report: what each section means, which download to use, and how to tie every deposit to your books

A payout for $4,812.33 landed on Tuesday and you want to know what is in it. The Payouts page shows the total. The payout reconciliation report shows the charges, fees, refunds and disputes that total was built from, one line each, and it is the report Stripe itself points to for matching deposits to your books. It is also easy to misread: it files a payout under the day Stripe expected the money to arrive, not the day your bank posted it, and it says nothing at all about manual or instant payouts. Here is how to read it so the numbers you take from it are the right ones.

Where it is, and who can use it

In the Stripe Dashboard open Reports, then Payout reconciliation. Stripe's documentation is explicit that the report is only available to accounts with automatic payouts enabled (or a platform on manual payouts whose connected accounts pay out automatically). If your payouts are manual, Stripe sends you to the Balance report instead, which works like a bank statement and does not tie any payout to the payments inside it. Instant payouts are not in the report either: because you choose the timing and the amount, Stripe cannot say which transactions an instant payout carried, and its docs say you reconcile those against your transaction history yourself. So the first decision is upstream of the report. If you want Stripe to tell you what is in every deposit, keep the account on an automatic schedule, daily, weekly or monthly.

Pick the date range by estimated arrival date, not by your bank statement

The report groups each payout under the estimated arrival date shown on the Payouts page, not the date your bank posted the deposit. Weekends, holidays and your bank's own processing can push the deposit a day or two later than Stripe estimated, so if you set the range to the dates on your bank statement, the payout you are looking for can fall just outside it. Stripe's own advice: if you are not sure of the date, widen the range. Two more timing rules. Report data follows its own processing schedule, so a payout can reach your bank before its reconciliation rows are ready; and Dashboard reports always cover complete days, so a payout that arrived today appears tomorrow at the earliest. Finally, set the time zone control to the one your books use and never change it, because the date on every line moves with it.

The four sections, and what each one is for

Balance summary shows your starting balance, your activity (the net of every transaction except payouts), your total payouts and your ending balance for the range. Payout reconciliation lists each automatic payout in the range with the transactions inside it grouped by reporting category: charges, refunds, disputes, fees and so on, each with a count, a gross, a fee and a net. Failed payouts appears only if a payout failed in the range, and shows the money that came back to your balance. Ending balance reconciliation lists the transactions that had not yet been paid out on the last day of the range: everything still pending or available. That last section is the one most people scroll past, and it is the one that proves the month-end, as the last section below explains.

Summary or itemized: which download answers which question

Each section has a Download button with two formats. Summary gives you the totals you can see on screen: for each payout, one row per reporting category with count, gross, fee and net. For the routine clearing-account entries that is enough, because what you post is the gross sales, the fee total, the refund total and the net transfer. Itemized gives you every balance transaction behind those totals: the balance transaction id, when it was created, when its funds became available, the id and expected date of the payout that carried it, gross, fee, net, reporting category and description, plus optional columns such as customer email, charge id, invoice number, the amount and currency the customer actually paid, dispute reason and card brand. Reach for itemized when a payout carries a refund or dispute from an earlier period and you need to know whose it was. You can hover over one category and download just that category, CSV is available to every account, and where PDF is offered the itemized PDF stops at 5,000 rows. If your charges carry metadata such as your own order id, the CSV can include those columns, which is how you match Stripe rows to records in your own system.

Reading one payout: gross, fee, net, and the category column

Every row has a gross, a fee and a net, and net is gross minus fee. On a charge, gross is what the customer paid, fee is Stripe's processing fee and net is what reached your balance. On a refund, gross is negative, fee is normally zero because Stripe keeps the original processing fee, so net is simply the amount handed back. On a dispute, gross is the disputed amount, negative, and fee is the dispute fee; if you win, a dispute reversal row brings the amount back and whatever part of the fee Stripe returns on a win. Fees Stripe bills separately from any charge appear as their own fee rows. Add up the net column for every row in one payout and you get the payout amount, to the cent, because that is how Stripe built the report. Use the reporting category column rather than the older type column: Stripe's reporting category puts card charges and other payment methods together as charge, splits what type calls an adjustment into dispute, dispute reversal and failed refund, renames stripe_fee to fee, and labels held money as reserved funds.

From the report to QuickBooks or Xero

The report gives you, per payout, exactly the numbers the clearing-account method needs. Post the gross charges as revenue into your Stripe clearing account on their own dates. Post the fee total out of clearing as Stripe fees, the refund total out of clearing as refunds, and any dispute out of clearing as a dispute, each with Stripe as the payee. Then move the net amount from clearing to your bank as a transfer dated the day the money landed, and match the bank feed line to that transfer instead of adding it as income. Do that for every payout in the range and the clearing account has absorbed every row of the report. The summary download is enough for the postings; keep the itemized file for the month in case a customer or your accountant asks which refund went where.

The month-end check the ending balance section makes possible

On the last day of the month, the balance of your Stripe clearing account should equal the ending balance in the Balance summary section of this report, and the Ending balance reconciliation section lists the transactions that make up that number: paid-for charges still pending, and available money not yet paid out. Do your books match Stripe? If the two figures agree, yes, and you can forward the report and the clearing account to your accountant as-is. If they do not, the gap between Stripe and your books is one of a short list: a payout booked under the bank's date in a different month from Stripe's estimated date, a refund or dispute row that was never posted, a separate fee row that was missed, or a manual or instant payout that this report does not cover. Work the list in that order; the first one explains most gaps.

What the report can't tell you, and what reads it for you

The report is a list, not a judgement. A refund from last quarter, a dispute fee and a reserve release all look the same on the page: a row with a category and a net. It will not tell you which payouts are routine and which one needs a look this morning, and it will not tell you anything until you open it. Conciliq reads the same balance transactions with a read-only key every morning, rebuilds every automatic payout from them and classifies each one as Matched (sums to the cent, nothing but charges and fees), Timing (sums, but carries refunds or disputes from earlier sales) or Unexplained (adjustments, reserves, transfers, or a payout that does not sum). One email a day, including the days everything matched. We can see your data, never touch it, and it never writes to QuickBooks or Xero.

Check yours

Does the money Stripe paid you match your books?

Upload a Stripe export or paste a read-only key. Every payout in the last 90 days, matched to the cent, usually in under a minute. Nothing stored.

Run the free audit →

Questions people ask

Why can't I find my payout in Stripe's payout reconciliation report?
Three usual reasons. The report files each payout under its estimated arrival date, so widen the date range if you searched by the bank's posting date. The report's data is processed on its own schedule and always in complete days, so a payout that arrived today shows tomorrow at the earliest. And the report only covers automatic payouts: manual and instant payouts never appear in it.
What is the difference between the payout reconciliation report and the balance report?
The balance report is a bank statement for your Stripe balance: every transaction and payout in the period, with payouts shown as plain transfers that are not tied to any payments. The payout reconciliation report is organised by payout: for each automatic payout it lists the transactions inside it, including transactions from before the period if the payout that carried them arrived during the period. Stripe recommends the first if you treat Stripe like a bank account in your books and the second if you use a clearing account.
Should the itemized rows add up to the payout amount?
Yes, exactly. The net column of every row carrying the same payout id sums to the payout amount to the cent, because Stripe builds the report from the balance transactions that settled in that payout. If your sum is off, you are missing rows: a category downloaded on its own, a different time zone from the one you used last time, or a date range that cut the payout in half.

More guides