Tue Nov 03 2026 00:00:00 GMT+0000 (Coordinated Universal Time)

How to reconcile Stripe payouts in QuickBooks Online

Turn one Stripe bank deposit into a journal entry whose lines add up to the amount on the statement.

A Stripe payout lands in the bank as a single amount. QuickBooks Online will not match that deposit to a pile of individual charges unless you also record the fees, refunds, and other amounts that Stripe already netted out.

What the deposit is made of

For one payout, the useful split is:

• Gross sales, the charges included in that payout
• Stripe fees, including processing fees and separate fee rows such as Radar or currency conversion
• Refunds, including partial refunds
• Disputes, the disputed principal rather than the dispute fee
• Anything else, such as a manual adjustment

Those signed amounts add up to the payout. The bank line in the journal is that payout, so the statement line has something to match.

A workable sequence

1. In the Stripe Dashboard, open the payout reconciliation report and download the itemized CSV for a date range that includes the payout arrival date. The summary file does not list the transactions inside each payout.
2. Upload that CSV in PayoutPair and open the business the payout belongs to.
3. Map Gross sales, Fees, Refunds, Disputes, Other adjustments, and the bank account to names that already exist in the QuickBooks chart of accounts. The import matches names, not a guessed account.
4. Download the QuickBooks journal for that payout. There is one journal number per payout.
5. In QuickBooks Online, import the journal entries. If a name in the file is not in the chart of accounts, the import stops on that line. Fix the mapping and download again rather than editing the CSV by hand.

How the lines are signed

A positive category, usually gross sales, is a credit. A negative category, such as a fee or a refund, is a debit. The bank deposit is a debit when money arrived. Debits equal credits, including when a refund returned part of a fee.

If PayoutPair marks the payout as a mismatch, the difference is posted to the adjustments account so the bank line can still equal the payout amount in the file. Read that difference before you import. It usually means the CSV was missing rows, or a row did not satisfy net = gross − fee.

What this does not do

This records the payout as a summary journal. It does not create an invoice per charge, and it does not apply sales tax codes. If you need that, a sync tool that connects to Stripe is a different product. PayoutPair only reads the CSV you export.

Stripe is a trademark of Stripe, Inc. QuickBooks is a trademark of Intuit Inc. Xero is a trademark of Xero Limited. PayoutPair is not affiliated with, endorsed by, or sponsored by Stripe, Intuit, or Xero.