Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Help for owners

My Stripe payouts never match what is in my accounting

Short answer

A Stripe payout is a batch of payments, refunds, disputes and fees paid out together, so it rarely equals any single sale. Reconcile by payout, not by sale: Stripe's payout reconciliation report lists every transaction inside each payout, and matches them by their estimated arrival date.

  • Written for business owners
  • Updated
  • By Maaz Zindani, Senior Software Engineer

Does this sound like your situation?

  • The deposit in my bank is lower than the sales my books show for that day.
  • I cannot tell which sales belong to which Stripe deposit.
  • Refunds, disputes and fees are missing or booked in the wrong month.
  • My books and Stripe agree on totals one month and not the next.
  • Instant payouts and normal payouts are mixed together and I cannot separate them.

Why does this happen?

  1. One payout is a batch, not one sale

    The payout reconciliation report matches each payout you receive in your bank with the batch of payments and other transactions it relates to. Payments, refunds, disputes and fees are all balance transactions inside that batch, which is why a deposit never equals one invoice.

  2. The report only works for automatic payouts

    Stripe states the payout reconciliation report is available for accounts with automatic payouts enabled. With manual payouts it points you to the Balance report, which tracks the Stripe balance like a bank account.

  3. Instant payouts cannot be matched automatically

    You control the timing and amount of instant payouts, so Stripe cannot say which transactions each one contains. Stripe says you are responsible for reconciling instant payouts against your transaction history.

  4. Dates differ between Stripe, the bank and the books

    The report groups a payout by the estimated arrival date on the Payouts page, not the date the bank posts the deposit. Weekends, holidays and bank processing can move the real arrival, and report data follows its own schedule, so a payout can arrive before its data is ready.

  5. Failed payouts and unsettled transactions sit in separate sections

    The report has a section for failed automatic payouts and an ending balance section for transactions not yet settled at the report's end date. If a sync tool reads only paid payouts, those amounts look like a difference.

What can I do about it today?

  1. Pick one payout and trace itOpen Stripe's Payout reconciliation report, choose a date range that includes the payout's estimated arrival date (widen it if unsure), and download the Itemized CSV for that payout.
  2. Compare it to your books line by lineYour books should hold the gross sales, the refunds, the disputes and the fees from that file, with the net equal to the deposit. The first line that differs is your real problem.
  3. Check which payout type you useIn Stripe's payout settings, see whether payouts are automatic or manual, and whether you also take instant payouts. This decides which report applies.
  4. Look at failed payoutsIf the report shows a failed payouts section, note those amounts and ask your bank whether anything arrived.
  5. Do not edit or delete books to force a matchEntries you remove to make a total agree are hard to put back. Add notes and corrections instead, and ask your accountant before changing closed periods.
  6. Write down what is on each sideA short list of what your tool imports (sales only, or fees and refunds too) saves a lot of time later.

When should I bring someone in?

  • A tool or script moves Stripe data into your books and you do not know which fields it reads.
  • Refunds, disputes or fees are missing from the books and nobody can say why.
  • Month-end takes days because the matching is done by hand every time.

How do I handle it?

  1. Reconcile one payout by hand firstI take a single payout, build its full list of transactions from the itemized report and prove the arithmetic to the deposit. That fixes the target.
  2. Read the import stepI read the documentation of whatever moves data into your accounting software and check, with real examples, which Stripe transaction types and which dates it uses.
  3. Carry your own reference throughStripe's itemized CSV can include your custom metadata, so I use an order or invoice reference to tie Stripe lines to your system records.
  4. Test on a copyAny change to the sync is tried against a copy of the books or a test account before it touches live data, and I keep the old output for comparison.
  5. Document the ruleI leave a one-page note describing how a payout becomes bookkeeping entries, so month-end is repeatable.

The price depends on what I find, so I quote in writing after a short discovery call. Tell me what is happening and I reply within 24 hours.

What do owners ask about this?

Why does the payout never equal my sales total?

Because a payout also contains refunds, disputes and fees, and its date is not the sale date. The itemized payout report lists each of those lines.

Can I match payouts if I use manual payouts?

The payout reconciliation report is for automatic payouts. For manual payouts Stripe suggests the Balance report, which treats your Stripe balance like a bank account.

Can I carry my invoice number into the report?

For CSV exports, Stripe says you can include custom metadata to match its transactions with records in your accounting system, so the reference has to be written into the payment when it is created.

Is the report data available the same day?

Not always. Stripe says report data follows a separate processing schedule, so a payout can arrive before its reconciliation data is ready.

Sources

How was this page made?

I drafted this page with AI assistance from the official documents listed under Sources. Found a mistake? Tell me.

Next step

Want this off your desk?

Send me a few lines on where things stand. I reply within 24 hours.