QuickBooksHow to Reconcile Stripe Payouts in QuickBooks Online, Step by Step

Here's the scene. Your Stripe dashboard says you sold $12,400 last week. Your bank says Stripe deposited $11,962.18. Your QuickBooks says something else again, and nobody can explain the $437.82 gap.

Nobody stole anything. Stripe just doesn't pay you what you sold. It pays you what you sold, minus its fees, minus refunds, minus any customer disputes, sometimes days later, often in one lump for several days of sales. If your bookkeeper records that lump as "Sales", your revenue is understated, your fees are invisible, and your books will never tie out to Stripe.

This guide shows the fix: a clearing account. It's the method accountants use for every payment processor, and once it's set up, reconciling Stripe becomes a 15-minute monthly job.

Why Stripe deposits never match your sales

Every Stripe payout is a bundle of different things. A single deposit might include:

Stripe's own documentation describes the Payout reconciliation report as matching each bank payout to the batch of transactions it settles, grouped by category [1]. That report is your best friend for everything below.

If you record only the net deposit, you lose the breakdown. Your sales look lower than they were, your fees vanish into the gap, and the next time a lender asks for gross revenue you'll be rebuilding it from scratch.

Step 1: Create a Stripe clearing account

A clearing account is a temporary holding account. Money comes in (sales), money goes out (fees, refunds, payouts), and the balance left at any moment should equal what Stripe is holding for you.

1. In QuickBooks Online, go to Chart of accounts and click New.
2. Choose account type Bank (some accountants use Other Current Asset; Bank makes it easier to reconcile).
3. Name it Stripe Clearing.
4. Leave the opening balance at zero, or enter your Stripe balance on the start date if you're starting mid-stream.
5. Save.

Also check you have a Merchant Fees expense account (or "Payment Processing Fees"). If not, create it under Expenses.

Step 2: Download the right Stripe report

In the Stripe Dashboard, open Reports, then Payout reconciliation. Pick the month. You'll see each payout with its parts: charges, refunds, fees, disputes and any adjustments. Download the itemized version if you need line-by-line detail, or the summary for monthly entries [1].

Payout reconciliation is available when automatic payouts are turned on in Stripe. If you pay out manually, use the Balance report instead [2].

Step 3: Record gross sales into the clearing account

How you do this depends on how you bill.

If you send invoices from QuickBooks and customers pay by card through Stripe: when you receive the payment in QuickBooks, deposit it to Stripe Clearing, not to your bank. The invoice closes, and the money sits in clearing until Stripe pays it out.

If customers pay on your website or app: record a daily or weekly sales receipt (or one journal entry) for gross sales, with "Deposit to" set to Stripe Clearing. One entry per payout or per day is plenty. You don't need every single charge in QuickBooks; Stripe keeps that detail.

If you use a sync app: apps exist that post Stripe transactions into QuickBooks automatically. They can save a lot of time at higher volumes. Set them to post into a clearing account, not straight to the bank, and check their first month line by line before you trust them. For a list of tools, see our roundup of e-commerce accounting tools.

Watch out for Undeposited Funds. If payments sit in Undeposited Funds and never get matched, sales get counted twice when the bank feed also records the deposit. Our guide to Undeposited Funds in QuickBooks shows how to spot and clear that.

Step 4: Record fees, refunds and disputes from the clearing account

Using the payout reconciliation report, record the month's (or each payout's) deductions:

1. Fees: an expense entry from Stripe Clearing to Merchant Fees for the total Stripe fees.
2. Refunds: a refund receipt or journal entry from Stripe Clearing that reduces sales (many businesses use a "Refunds and Returns" contra-revenue account so refunds stay visible).
3. Disputes: the disputed amount reduces sales, and the dispute fee goes to Merchant Fees. If you win the dispute later, reverse it when Stripe returns the money.

Step 5: Record each payout as a transfer

When Stripe's payout lands in your bank, it shows up in your bank feed. Don't categorize it as income. Record it as a transfer from Stripe Clearing to your checking account.

In the bank feed, choose the deposit, pick Record transfer, and set the other account to Stripe Clearing. If you already entered the transfer by hand, Match it instead so you don't count it twice.

You can create a bank rule for this, since every Stripe payout description looks similar. Our QuickBooks bank rules guide explains how to set a rule that records Stripe deposits as transfers automatically.

Step 6: Reconcile the clearing account to your Stripe balance

At month end:

1. Open Reconcile in QuickBooks and choose Stripe Clearing.
2. For the ending balance, use Stripe's balance at month end (from the Balance report or the ending balance section of the payout reconciliation report).
3. Tick off the entries. They should tie to the penny.

If they don't, the difference is almost always one of these: a payout recorded as income instead of a transfer, a month of fees not entered, a refund entered twice, or a payout that was in transit on the last day of the month (Stripe sent it, your bank hadn't received it yet). Payouts in transit are normal; they show up in the next month's bank statement.

Then reconcile your bank account as usual. Our bank reconciliation process guide covers that part.

A worked example

Say one week of Stripe activity looks like this:

Your P&L now shows $12,400 of sales, $55 of refunds and $382.82 of fees. That's what actually happened, and it's what a lender, investor or buyer expects to see. (The figures here are made up for the example.)

How often should you do this?

• Low volume (a handful of payouts a month): once a month, using the summary report.
• Higher volume or several processors: weekly, or let a sync app post daily and review weekly.
• Always: reconcile the clearing account as part of month-end. Put it on your month-end close checklist.

If you also sell through Shopify or Amazon, the method is the same: one clearing account per processor. Our Shopify payouts reconciliation guide walks through that version.

Common mistakes

• Recording payouts as sales. Revenue is understated by the fees, and you can't see what processing costs you.
• Skipping the clearing account. Nothing ties out, and every month-end becomes detective work.
• Letting the sync app post straight to the bank. Deposits get counted twice when the bank feed also records them.
• Forgetting disputes. A chargeback quietly reduces the payout and nobody records why.
• Ignoring currency conversion. If you sell in other currencies, Stripe converts before paying out, and the conversion difference needs its own line.

When to hand this off

If you take payments through Stripe, Shopify, PayPal and a marketplace or two, the clearing accounts multiply quickly, and so do the places for small errors to hide. Reconciling every processor monthly is part of ABFI's bookkeeping and payroll work for e-commerce and startup clients.

Keep reading

• Shopify payouts reconciliation
• Undeposited Funds in QuickBooks, explained
• E-commerce accounting basics

Sources

1. Stripe Docs, "Payout reconciliation report", docs.stripe.com/reports/payout-reconciliation. Checked November 6, 2026.
2. Stripe Docs, "Reporting and reconciliation", docs.stripe.com/plan-integration/get-started/reporting-reconciliation. Checked November 6, 2026.