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
- Why your Stripe payout doesn't match your sales (and how to check it)
- QuickBooks' Stripe connector imports payouts, not fees. Here is what that does to your books
- Stripe payout breakdown: what every line inside a payout means
- Why a Stripe refund comes out of a later payout
- How a Stripe dispute hits your payout, and how to record it in your books
- A customer's card expires before their next Stripe renewal. What happens, and what to do
- Stripe debited your bank account. Why your balance went negative, and how to book it
- Stripe says the payout is Paid, but the money isn't in your bank. What each payout status means, and what to do
- How to reconcile Stripe payouts in Xero: what Xero matches on its own, and what it can't
- Stripe put a reserve on your account. What it does to your payouts, when the money comes back, and how to book it
- A Stripe renewal was declined. What do_not_honor, insufficient_funds and the other decline codes mean, and what to do about each
- You charged in euros or pounds and Stripe paid you in dollars. Where the conversion fee went, and how to reconcile it
- Your Stripe 1099-K is bigger than the money that hit your bank. Why, and how to tie it to your books
- When does Stripe pay you? The payout schedule, the first-payout wait, and what each setting does to your books
- How to record Stripe payouts and fees in QuickBooks Online by hand: the clearing account method, step by step
- Your Stripe payout includes sales tax you owe. How to record it in QuickBooks, and why Stripe's tax report won't match your deposits
- A customer paid a year upfront through Stripe. How to record it in QuickBooks so one month doesn't look like a record
- Stripe sent an early fraud warning. Should you refund the charge or wait, and what each choice does to your payout
- Why your Stripe fees are more than 2.9% + 30¢, and how to find what each extra charge is
- A Stripe ACH payment looked paid, then failed days later. Why it happens, what it does to your payout, and how to book it
- A customer paid a Stripe invoice by check or bank transfer. How to mark it paid, why it never shows up in a payout, and how to book it
- You gave a customer a Stripe coupon. What it does to the charge, the fee and the payout, and how to record the discount in QuickBooks
- A Stripe refund failed. Where the money went, why your payout is suddenly bigger, and how to get the customer paid
- Hundreds of small Stripe payments failed overnight. What a card testing attack is, what to do first, and what it does to your payouts and books
- A customer downgraded or cancelled and Stripe gave them a credit, not a refund. Where the money is, why your next payout is smaller, and how to book it
- QuickBooks shows double your Stripe income. Why the sync app and the bank feed both recorded it, and how to fix it
- Stripe says a subscription is incomplete, past due, unpaid or paused. What each status means for the customer, your payouts and your books
- You took Stripe Capital financing and your payouts got smaller. How the repayment works, and how to record it in QuickBooks or Xero
- You took a Stripe Instant Payout and now nothing reconciles. How to match instant payouts, their fee and the smaller payouts after them
- Stripe fee calculator: what your payouts really cost