Recording Stripe payouts in QuickBooks: Fees, refunds and timing
The short answer
A Stripe payout is a net bank deposit: many charges, minus fees, refunds, disputes, and adjustments, often spanning several days of activity. It isn't a single sale. In QuickBooks, book gross customer payments, usually into a Stripe clearing account, fees as expense, refunds against revenue or as refunds, and the payout itself as a transfer from clearing to the bank. Coding the deposit straight as income understates revenue and hides the fees entirely.
Accounts to set up once
Account | Type | Role |
|---|---|---|
Stripe clearing | Bank, or a clearable asset used like a bank | Holds customer money after payment, before the payout |
Operating bank | Bank | Where Stripe deposits actually land |
Sales / service income | Income | Gross charges, or invoice payments |
Stripe / merchant fees | Expense | Processing fees |
Refunds (or sales returns) | Contra-income or refunds | Customer refunds |
Dispute / chargeback expense | Expense | Lost disputes and dispute fees |
Use one method consistently. Integrations can automate the same pattern; the underlying economics never change regardless of how automated the posting is.
The correct flow
1. Customer pays (charge succeeds) If invoiced in QuickBooks: Receive Payment for the full invoice amount, deposited to Stripe clearing. If not invoiced: a Sales Receipt, or a deposit line to income, deposited to Stripe clearing at the gross amount.
2. Fees Record Stripe fees from the payout summary or balance transactions as an expense, paid from Stripe clearing, or as negative lines directly on the payout deposit.
3. Refunds and disputes Refunds reduce clearing and reduce revenue, through a refund receipt or credit, for the gross refund amount. Dispute losses and dispute fees also leave clearing; don't bury them only inside a "net deposit income" figure.
4. Payout hits the bank A transfer or bank deposit moves Stripe clearing to the operating bank for exactly the payout amount. Match the bank feed to that transfer or deposit. Don't "add" the feed directly as sales income.
After a clean cycle, clearing should match the Stripe available or pending balance still expected, not a growing, unexplained mystery.
Timing: why the deposit never matches "today's sales"
Stripe concept | Bookkeeping impact |
|---|---|
Charge date | Revenue or AR relief happens when the payment is actually recorded |
Available on / payout schedule | Money sits in clearing until it's actually paid out |
Payout date | Only a transfer from clearing to bank, nothing more |
A refund landing in a later payout window | May net against newer charges inside one single deposit |
A Monday bank deposit often settles the prior week's charges, net of mid-week refunds. Comparing that deposit directly to Monday's invoices will always fail, no matter how carefully it's done.
Worked example
One payout summary:
Line item | Amount |
|---|---|
Charges (gross) | $12,000 |
Stripe fees | $378 |
Refunds | $500 |
Payout to bank | $11,122 |
Correct treatment: income, or payments on invoices, of $12,000 into clearing; fee expense of $378 out of clearing; refunds of $500 out of clearing; a transfer to the bank of $11,122; and the bank feed matched to that exact $11,122.
Incorrect treatment books the $11,122 bank deposit directly as income. Revenue ends up short by $878, there's no fee expense anywhere, and the refunds become completely invisible in the books.
Negative payouts
When refunds and fees exceed new charges, Stripe may debit the bank instead of crediting it. That's still a clearing-to-bank movement, just in the opposite direction, not negative revenue on its own. Revenue and refunds should already be sitting correctly on the books from the underlying transactions regardless of which direction the net payout moves.
Month-end proof
Stripe's own documentation is specific about this, and worth getting right rather than treating as generic advice: Stripe actually publishes two different reconciliation reports built for two different setups, and pulling the wrong one is a common, avoidable source of confusion at close.
The Payout reconciliation report is for firms on automatic payouts specifically. Stripe's own docs describe it as helping "match the payouts you receive in your bank account with the batches of payments and other transactions that they relate to" (Stripe); it's only available with automatic payouts enabled, and an Ending balance reconciliation section within it covers whatever hadn't settled yet as of the report's end date, exactly the figure that should explain a lingering clearing balance.
The Balance report is for firms on manual payouts, or for anyone who prefers to treat Stripe like a bank account and reconcile the whole balance at month-end rather than payout by payout. Stripe's own description: "the Balance report is similar to a bank statement... most useful if you treat Stripe like a bank account for accounting purposes, reconciling the balance at the end of each month," covering every transaction except payouts themselves, charges, refunds, disputes, other adjustments, and fees (Stripe).
With the right report in hand:
The Stripe payout list for the month equals the sum of bank deposits labeled Stripe, adjusted for any negative payouts.
Gross charges in Stripe reconcile to payments or sales receipts posted into clearing.
Fee expense approximates Stripe's own fees for the period.
Refund totals align with Stripe's own refund figures.
The Stripe clearing balance explains the unpaid Stripe balance, pending plus available but not yet paid out, using the Ending balance reconciliation detail if automatic payouts are in use.
Service-firm notes
Connect payments to invoices whenever the firm bills in QuickBooks, so AR actually ages correctly.
Deposits that include sales tax or tips need those components split out; don't dump the full charge into pure service income.
App fees (Stripe Connect) need their own mapping, so platform fees never get mistaken for ordinary processing fees.
How Numetix handles Stripe
We work in QuickBooks Online with Stripe-heavy service firms. AI helps with residual bank coding; a CPA-overseen team ties payouts to clearing, fees, and refunds, so net deposits never quietly substitute for gross revenue.
A practical first step: send us one Stripe payout detail page and the matching bank deposit. We'll show you the split, and any clearing balance left unexplained. Book 30 minutes with our team. More on how Numetix serves founder-led service firms.
Frequently asked questions
Can we book net deposits as income and just ignore fees? It understates revenue and expenses by roughly the same fee amount, and breaks any gross comparison, 1099-K included. Avoid it.
Is a clearing account actually required? It's the cleanest approach. Some teams use a single bank deposit with gross positive lines and negative fee or refund lines instead; clearing still helps whenever payouts lag the underlying charges.
Where do we actually get the fee total from? Stripe's own payout detail or balance transaction reports, confirmed directly as Stripe's recommended source for building custom reconciliation workflows, not the bank memo alone.
What about Stripe Instant Payout fees specifically? Extra fee expense, same clearing logic applies. One real limitation worth knowing: Stripe's own documentation notes that with instant or manual payouts, the firm controls timing and amount directly, so Stripe can't identify which specific transactions are included in any one payout the way it can with automatic payouts, which is exactly why the Balance report, not the Payout reconciliation report, is the right tool on that setup.
Should every charge be its own separate QuickBooks sales receipt? Ideal for detail, but high-volume firms often batch by day and still settle each payout gross-to-net correctly. AR control stays tighter when payments actually hit invoices directly.
Numetix is an AI-first accounting firm. AI runs the bookkeeping, tax, payroll, and reporting workflow. Industry experts handle the judgment, month-end close, review, and advisory. We serve founder-led service firms across law, consulting, IT, healthcare, creative, and nonprofit. Headquartered in California, serving clients nationwide.
Suggested Readings
Unbilled revenue tracking: The money your service firm has earned but has not invoiced yet
Why tracked hours never reach the invoice: The billing workflow gaps most service firms do not see
Bill.com and Ramp for service firms: Approval workflows your bookkeeper can reconcile
Pilot alternatives for law, healthcare and property firms
QuickBooks Desktop to QuickBooks Online migration for service firms
Recording Gusto payroll in QuickBooks Online correctly
See what Numetix can do for you
Learn how the Numetix Portal streamlines communication, offers valuable insights, and saves you time so you can focus on growing your business.