How to reconcile Stripe payouts in QuickBooks Online

The problem in one line

Your bank shows "STRIPE TRANSFER $970.00". Your sales for the day were $1,000. QuickBooks Online needs both numbers, and the $30 between them explained.

Why the deposit does not match the sales

A Stripe payout is the net of every balance transaction that became available since the previous payout:

• Charges, gross, including any sales tax collected.
• Less Stripe's processing fees on each charge.
• Less refunds. Stripe does not return the original processing fee on a standard refund.
• Less disputes and the dispute fee. Both are returned if you win.
• Plus or minus adjustments, reserve holds and releases, and transfers.

Matching the $970 deposit to a $1,000 sales receipt forces a $30 plug. Matching it to a $970 sales receipt understates revenue and hides the fee expense. Neither reconciles.

The clearing-account method

Create a current-asset account in QuickBooks Online called Stripe clearing (some firms call it Stripe balance or Undeposited funds: Stripe). It represents money Stripe is holding for you. Then book four things:

1. Sales. Debit Stripe clearing, credit revenue (and sales tax payable for any tax collected), for the gross charge. One summarised entry per month is enough for most books; one per charge if you need customer-level detail in QuickBooks Online.
2. Fees. Debit merchant processing fees, credit Stripe clearing.
3. Refunds and disputes. Debit revenue or a contra-revenue account (and sales tax payable for the tax portion), credit Stripe clearing. Dispute fees are a separate expense line.
4. Payouts. When a payout reaches the bank, record a transfer from Stripe clearing to the bank account for the payout amount. Match it to the bank feed line. It is never income.

After these four, the clearing account's balance on any date should equal Stripe's balance on that date: pending plus available, less payouts in transit. That is your reconciliation check.

Which exports to use

• Balance change from activity (Reports, then Balance). One row per balance transaction with type, gross, fee, net and available_on. This is the source for sales, fees, refunds and disputes.
• Payout reconciliation. The same transactions grouped by the payout that paid them. This is how you prove each payout's composition.
• Balance summary. Opening balance, activity, payouts, closing balance for the period. The month-end tie-out.

The month-end tie-out

Three checks, in order:

1. Activity. For each payout, gross charges less fees, refunds and disputes in the Payout reconciliation report equals the payout amount. If one payout does not tie, the difference is a specific transaction and the report names it.
2. Balance. Opening Stripe balance, plus net activity, less payouts, equals the closing balance Stripe reports. If activity ties and balance does not, something moved money without a transaction you booked: a reserve, a top-up, a transfer between accounts.
3. Bank. Every payout in the period appears on the bank statement, for the same amount, within a few days. Payouts dated in the last days of the month will land next month; list them as in transit rather than forcing them.

Where it goes wrong

• Timing. A charge on the 30th may become available on the 2nd and be paid out on the 3rd. Decide which date books the revenue (accrual: the charge date; cash basis: the date you choose as received) and apply it every month.
• Manual payouts. Stripe's reports do not itemise them; their transactions are attached to the next automatic payout. You have to reassemble them from available_on dates.
• Edits in QuickBooks Online. A synced sales receipt edited by hand drifts the clearing account without any Stripe event to explain it.
• Sales tax. Booked as revenue, it inflates sales and leaves the liability unrecorded. Refunds must reverse the tax in proportion.

Doing it every month

The method is sound. The cost is the time to pull three exports, build the entries, run the three checks and chase the differences, and it grows with volume. That is the job ClearDeposits does: it pulls the Stripe data daily, keeps the clearing account as a real subledger, runs the activity and balance checks, names each variance, and drafts the summarised entries for QuickBooks Online for you to review before you import them.