Every Stripe payout that lands in your bank account is a bundle: gross sales, minus processing fees, minus refunds, sometimes minus chargebacks, all netted into a single deposit. Stripe payout reconciliation is the routine that untangles that bundle, proving that each payout in Stripe matches a deposit in your books and in your bank account. Without it, small differences accumulate silently until month-end, when the bank reconciliation fails and nobody can say which payout went wrong.
This guide walks through a file-based routine you control end to end: export the payout data from Stripe, convert it to a file QuickBooks Online can import, match each payout to its bank deposit, and resolve the differences that remain. Be clear about what this is: our tools are file-based converters, not a live Stripe-to-QuickBooks connection. Nothing posts to your books without your review, and that review is exactly what catches the errors a silent sync would bury.
Stripe Payout Reconciliation, Step by Step
Start with one payout period at a time, never a whole quarter at once. In Stripe, open the payout and export its transactions: the gross charges, the fees, the refunds, and any adjustments that belong to that payout. Convert the export to a QBO file with a Stripe to QuickBooks converter, then import it into QuickBooks Online and review every row before accepting it. Each charge should appear at its gross amount, each fee as its own expense line, and each refund as a reduction of the original sale.
Next, record the payout itself as a transfer, not as income. The payout is money moving from Stripe to your bank account; the income was already recorded when the sales imported. In QuickBooks, match the transfer to the deposit your bank feed shows, allowing one or two business days for the bank to post it. When the amounts agree to the cent, that payout is reconciled. When they do not, stop and find the difference before moving to the next payout: reconciling out of order turns one small error into a month of them.
Stripe Payout Reconciliation When Payouts Split or Fail
Not every payout behaves neatly. A large payout can split across two bank deposits if it crosses a bank cutoff, and a failed payout can be retried days later with a different date. When a payout does not match, check three things in order: a split deposit, a payout that includes a reserve release or an adjustment from an earlier period, and a timezone or cutoff difference that pushed part of the payout into the next day. Most mismatches are one of those three, and each has a clean fix once identified.
Refunds and chargebacks deserve special care, because they often arrive in a different payout period than the original sale. A refund issued this week against a sale from last month belongs to this week's payout bundle, and recording it against last month's sales distorts both months. The same applies to chargebacks and disputes: record them in the period Stripe actually deducts them, with a note pointing back to the original charge. For the fee side of the same workflow, see our guide on how to record Stripe fees in QuickBooks, and for the sales side, how to record Stripe payments in QuickBooks.
Handling Fees, Refunds, and Multi-Currency Payouts
Fees are the most commonly mishandled line in Stripe bookkeeping. Stripe deducts its fee before the payout, so the deposit is always smaller than gross sales, and sellers who record only the deposit understate both revenue and expenses. Record the fee as a separate expense, ideally in its own account, so the profit and loss report shows true revenue and true processing cost. At tax time, that separation is what lets you or your preparer see the real margins without reconstructing them from payout totals.
Multi-currency payouts add one more layer: Stripe converts foreign-currency sales and charges a conversion fee, and the payout arrives in your settlement currency at Stripe's rate. Reconcile the payout in the settlement currency, and keep the original currency amounts in a note or a custom field for reference. Do not re-convert at your own rate, or the payout will never match the bank deposit. If currency swings are large for your business, reconcile weekly rather than monthly, so conversion differences are caught while the payout details are still fresh.
Build a Weekly Routine That Holds at Scale
Small sellers can run this routine monthly in under an hour: export, convert, import, match, done. Sellers with daily volume should run it weekly, because a month of unreviewed Stripe activity is where duplicates and missed refunds hide. Whatever the frequency, keep three disciplines constant: never import overlapping payout periods, never record a payout as income on top of the sales, and never net fees against sales. Those three rules prevent nearly every Stripe bookkeeping problem, from understated revenue to a bank reconciliation that never balances.
Keep a simple payout log outside QuickBooks as well: payout date, Stripe payout ID, gross sales, fees, refunds, net payout, and the bank deposit date and amount. When a question arises months later, that log answers it in seconds, without digging through Stripe or your books. The log also makes handover easy: an accountant or bookkeeper can pick up the routine mid-year and see exactly where the last reconciled payout ends.