Reconciliation guide

How to reconcile Stripe payouts in QuickBooks Online

Stripe pays you one net amount for many charges. The reliable way to reconcile it in QuickBooks Online is to run Stripe activity through a clearing account, so sales stay gross, fees are visible, and each payout is just a transfer to the bank.

By BillVerge · Updated · 9 min read · General accounting practice, not advice for your specific situation.

Why the deposit never matches your sales

A Stripe payout is the net of everything that moved through your Stripe balance since the last payout: charges, minus refunds, minus Stripe’s fees, minus disputes and any other adjustments. The bank feed in QuickBooks shows that single net deposit. Your invoices and sales receipts, on the other hand, are recorded at their gross amounts.

If you record the net deposit as income, revenue is understated and Stripe fees disappear from your expenses. If you record gross sales and add the deposit as income, revenue is counted twice. A clearing account avoids both.

Set up a Stripe clearing account

In your chart of accounts, create an account named something like Stripe Clearing. Most bookkeepers use a Bank account type for it, because it behaves like a bank account: money comes in from customers, fees and refunds go out, and payouts move the balance to your real bank account. A bank-type account also lets you use QuickBooks’ reconcile tool on it later.

If you settle Stripe in more than one currency, use one clearing account per currency. Note that once multicurrency is turned on in QuickBooks Online, it cannot be turned off, so decide that deliberately.

You will also want an expense account for Stripe fees (for example Merchant fees or Payment processing fees) if you do not already have one.

Record sales, refunds and fees through the clearing account

  • Invoice payments. When a customer pays an invoice through Stripe, record the payment against the invoice with Stripe Clearing as the deposit-to account, for the gross amount the customer paid.
  • Sales without an invoice. Use a sales receipt deposited to Stripe Clearing, or a daily summary entry if you have many small charges.
  • Refunds. Record them as paid out of Stripe Clearing, for example with a refund receipt or a credit memo and refund, so they reduce the clearing balance.
  • Fees. Record Stripe’s fees as an expense paid from Stripe Clearing. A single entry per payout, using the fee total from Stripe, is usually enough.
  • Disputes. When a dispute is opened, Stripe withdraws the disputed amount and a dispute fee from your balance. Record both out of Stripe Clearing. If you later win and the amount is returned, record that coming back in.

Many teams use a connector app to post these entries automatically. That is fine; the structure is the same. What matters is that every Stripe movement lands in the clearing account, at gross, before the payout leaves it.

Record each payout as a transfer, then match the bank feed

When Stripe sends a payout, record a transfer from Stripe Clearing to your operating bank account for the payout amount. When the deposit appears in the bank feed, match it to that transfer rather than adding it as a new deposit or as income.

To know what each payout contains, use Stripe’s payout reconciliation report (available for automatic payouts). Its itemized export lists every balance transaction included in each payout, with gross, fee and net amounts and a reporting category such as charge, refund or dispute. If you use manual payouts, Stripe’s balance report gives you the same activity by period instead.

Worked example

One payout of $9,431.40 covers $9,800.00 of charges, one $120.00 refund and $248.60 of Stripe fees. (Example data.)

Example entries for one payout. Account names are examples; use your own chart of accounts.
EntryDebitCreditAmount
Customer payments, grossStripe ClearingAccounts receivable or Sales$9,800.00
RefundSales refunds (or Sales)Stripe Clearing$120.00
Stripe feesMerchant feesStripe Clearing$248.60
Payout to bankOperating bankStripe Clearing$9,431.40
Stripe Clearing after the payout: 9,800.00 − 120.00 − 248.60 − 9,431.40$0.00

Revenue shows $9,800.00 gross, fees show $248.60, and the bank deposit of $9,431.40 matches the transfer exactly.

Tie out at month end

At the end of the period, the balance of Stripe Clearing should equal your Stripe balance on the same date, as shown in Stripe’s balance report. Two things commonly create a timing difference:

  • Payouts in transit. Stripe takes a payout out of your Stripe balance when it is created, but it may arrive in the bank a day or more later. If you date the transfer when the bank receives it, the clearing account will be higher than Stripe’s balance by any payouts still in transit at month end. Either date transfers by the payout date or list in-transit payouts as a reconciling item.
  • Pending funds. Recent charges sit in Stripe’s pending balance before they are paid out. They belong in the clearing balance, because the money is yours, just not in the bank yet.

Anything else left in the clearing account is something that was recorded in one place and not the other. Work through it payout by payout; see why a payout does not match the bank deposit for the usual causes.

Common mistakes

  • Adding the bank deposit as income when sales were already recorded, which doubles revenue.
  • Recording only net deposits, which hides Stripe fees and understates revenue.
  • Depositing Stripe payments straight to the operating bank account instead of the clearing account, which leaves the bank register showing deposits that never arrive individually.
  • Ignoring disputes until the dispute closes, so the clearing account drifts for weeks.
  • Mixing currencies in one clearing account.
Where BillVerge fits

BV Recon does the payout-to-charges matching and the bank match for you and explains any residual. The free Payout Reconciler runs that check on up to three payouts a month.

Check a real payout in a minute

Upload a Stripe payout report and your bank CSV to the free Payout Reconciler and get a line-by-line gap report. Up to three payouts a month, no sign-up.