How to Reconcile Stripe Payouts in QuickBooks Online

Stripe sends one lump sum to your bank. QuickBooks Online (QBO) shows that lump sum in the bank feed, and it almost never equals your sales. In between are Stripe fees, refunds, disputes and the odd adjustment. If you categorize the whole deposit as "Sales", your revenue is understated, your fees never show up as an expense, and refunds disappear.

The fix is to record each payout as one balanced journal entry: gross sales on one side, and fees, refunds, disputes and the net bank deposit on the other. Then you match the bank-feed deposit to that entry. Below is how to do it by hand. It works on any QBO plan and needs no integration.

What you need

• Stripe Dashboard access, so you can download reports.
• A QBO chart of accounts with these accounts (create any that are missing):
  • Sales (or whatever income account you use for Stripe sales)
  • Stripe Fees (Expense, e.g. under "Bank charges & fees")
  • Refunds (a contra-income account, or Sales if you net refunds against revenue)
  • Chargebacks / Disputes (Expense or contra-income, as your accountant prefers)
  • Your bank account where Stripe payouts land

Step 1: Download the Stripe payout reconciliation report

In the Stripe Dashboard, go to Reports, then Payout reconciliation. Pick the date range that covers the payout. Under the report, click Download and choose the Itemized format. That gives you every balance transaction included in each payout, not just the summary you see on screen.

The itemized file has one row per balance transaction. These columns matter most:

• automatic_payout_id: the payout the row belongs to
• automatic_payout_effective_at: the date the payout is expected to arrive
• reporting_category: what the row is, for example charge, refund, dispute, fee
• gross, fee, net: amounts in the payout currency

(Stripe documents these under the "Payout reconciliation" report type, payout_reconciliation.itemized.)

Step 2: Filter to one payout

Open the CSV in Excel or Google Sheets and filter automatic_payout_id to the payout you're reconciling. Check the payout amount in the Stripe Dashboard (Balances → Payouts) so you know your target net number.

Step 3: Summarize by reporting category

Build a pivot table with reporting_category as rows and the sums of gross and fee as values. A typical small-business payout looks like this.

Worked example (illustrative numbers only)

Some things to know:

• Refunds are negative gross. By default Stripe doesn't return the original processing fee when you refund, so the fee on the refund row is usually zero.
• A dispute row takes the disputed amount out of your balance, and the dispute fee shows up in that row's fee column.
• The fee column is a positive number that gets subtracted. Net = gross − fee.

Net payout = 4,850.00 − 320.00 − 150.00 − 158.95 − 15.00 = 4,206.05. That should equal the deposit in your bank feed. If it doesn't, you've filtered the wrong payout or left a category out (look for other_adjustment, fee rows for Stripe billing, or transfer rows).

Step 4: Write the journal entry

Stripe Fees = 158.95 processing + 15.00 dispute fee. Debits equal credits, so the entry balances.

Enter it by hand

In QBO, click + New, then Journal entry. Set the journal date to the payout arrival date and type a memo such as "Stripe payout po_XXXX". Enter the five lines above and click Save and close.

Or import it from CSV

QBO can import journal entries. Go to Settings ⚙ → Import Data → Journal Entries. Your file needs the columns Journal No., Journal Date, Account Name, Journal/Description, Debits, Credits. All lines that share a Journal No. become one entry. Intuit's tips:

• Turn off account numbers before importing (Account and settings → Advanced → Chart of accounts), then turn them back on afterward.
• Sub-accounts must be written as Parent Account:Sub Account. Using only the sub-account name gives a "Line Account Invalid" error.
• Account names must match your chart of accounts exactly.
• Any new accounts must exist before you import.

Sample rows:

Journal No.,Journal Date,Account Name,Journal/Description,Debits,Credits
STR-0412,04/12/2026,Checking,Stripe payout po_XXXX,4206.05,
STR-0412,04/12/2026,Stripe Fees,Stripe payout po_XXXX,173.95,
STR-0412,04/12/2026,Refunds,Stripe payout po_XXXX,320.00,
STR-0412,04/12/2026,Chargebacks,Stripe payout po_XXXX,150.00,
STR-0412,04/12/2026,Sales,Stripe payout po_XXXX,,4850.00

Step 5: Match the bank deposit

In Banking (or Transactions → Bank transactions), find the 4,206.05 deposit. QBO should suggest the journal entry's bank line as a match. If it doesn't, open the transaction, choose Match or Find match, and select the journal entry. Don't use "Add" here, because that would record the money a second time.

At month-end, reconcile the bank account as usual (Settings ⚙ → Reconcile). Each Stripe deposit is already backed by a full entry.

Common mistakes

1. Categorizing the net deposit as Sales. Revenue ends up understated and fees are hidden.
2. Using the summary export instead of itemized. You lose the per-category detail.
3. Mixing payouts. One journal entry per payout keeps matching one-to-one.
4. Forgetting the dispute fee. It's in the fee column of the dispute row, not a separate charge.
5. Time zones. Stripe reports default to UTC unless you choose a time zone. A payout near midnight can land on a different date than your bank shows.
6. Sales tax. If you collect sales tax through Stripe, split it out of gross sales into your sales-tax liability. That depends on your setup, so check with your accountant.

Where PayoutPair saves time

Steps 2–4 (filter, pivot, build a balanced entry, format the import file) are the tedious part, and that's what PayoutPair does. Upload the Stripe payout reconciliation CSV and it builds one balanced journal entry with gross sales, Stripe fees, refunds, disputes, adjustments and net to bank. On the mapping screen you choose which QBO account each line goes to by name, and it exports a file for QuickBooks Online's journal-entry import.

It works from the CSV only. It doesn't connect to your Stripe account, and nothing syncs in the background. You can try one CSV without an account or use the free calculator to check your numbers. If you reconcile a handful of payouts a month, the free plan covers 5 payouts a month. If you do this weekly for several clients, look at the Solo and Bookkeeper plans.

If you'd rather have a fully automatic sync and don't mind a deeper integration, tools like Synder or A2X are reasonable options. If you want a clean, auditable entry per payout without connecting anything, the manual method above or PayoutPair will do it.