Guide
How to record Stripe payouts and fees in QuickBooks Online by hand: the clearing account method, step by step
A Stripe payout lands in the bank feed as one line, for the net amount. If you click Add and call it income, revenue is understated by every fee Stripe took, refunds vanish, and nothing in the books ties to a Stripe report. The fix most bookkeepers use is a clearing account: a QuickBooks account that stands in for your Stripe balance. Sales go in gross, fees and refunds come out, and each payout is a transfer from that account to the bank. Set up once, it takes a few minutes per payout, and at month-end it tells you whether the books match Stripe. These steps are for QuickBooks Online; the idea is the same in Xero.
Why the deposit is the wrong starting point
Stripe sends you the net: charges, minus Stripe's fees, minus refunds, minus any dispute and its fee, over a window of days. The deposit is the end of a story, not the story. Book it as income and three things go wrong. Revenue is short by the fees, so margins and any report built on gross sales are wrong. Refunds never appear, so a refunded sale and a sale that never happened look the same. And when your accountant asks which sales a deposit covers, there is no answer in QuickBooks, only in Stripe. The clearing account fixes all three because it records what the deposit is made of, not just that it arrived.
Set up two QuickBooks accounts, once
In the chart of accounts add an account called Stripe clearing. Most bookkeepers give it the Bank type, so QuickBooks lets you deposit into it and transfer out of it exactly like a bank account; Other Current Asset also works but is harder to use in some screens. Do not connect it to a bank feed, there is nothing to connect. Then add an expense account called Stripe fees, under bank charges or merchant fees, and add Stripe as a vendor. If you also take refunds or get disputes, you will post those to the accounts you already use for refunds; no new account is needed.
Record the sales gross, into the clearing account
Every sale is recorded as revenue at the full amount the customer paid, never net of fees. If you send invoices from QuickBooks, receive the payment and set the deposit-to account to Stripe clearing. If Stripe takes the payments on its own, use a sales receipt with the deposit-to account set to Stripe clearing. At volume, one sales receipt per payout or per day with the gross total is fine: a summary line for product sales, a line for sales tax if you collect it, dated the day of the sales. Customer-level detail then lives in Stripe, which is where most founders look it up anyway. The clearing account balance now shows what Stripe is holding for you, before fees.
Take the fees, refunds and disputes out of the clearing account
Open the payout in Stripe and download the itemized payout reconciliation report for it; the summary groups the payout into charges, refunds, disputes and fees, and the itemized file lists every line. Then, in QuickBooks: one expense with Stripe as the payee, Stripe clearing as the payment account and Stripe fees as the category, for that payout's fee total. For each refund, a refund receipt with the refund-from account set to Stripe clearing, so revenue comes back down and the clearing balance drops by the amount Stripe returned. For a dispute, a refund receipt for the disputed amount plus an expense for the dispute fee. If you prefer fewer entries, you can instead add the fee as a negative line in the bank deposit in the next step; QuickBooks shows it as a positive expense on the profit and loss either way. Keep one method and stick to it.
Move the payout to the bank and match it
When the payout arrives, make a transfer from Stripe clearing to your checking account, dated the day it landed, for exactly the net amount Stripe sent. Then go to the bank feed and match the deposit to that transfer instead of adding it. The feed line is now explained, the bank reconciles, and nothing in revenue has moved. If the feed cannot find the match, the amount or the date is off: Stripe sends on the payout's arrival date, which is not the date of the sales inside it. Payouts that fall on a weekend arrive the next business day.
The month-end check that proves it
The clearing account balance at month-end should equal the balance Stripe is still holding: everything pending plus everything available that has not yet been paid out. Stripe shows that number as the ending balance on its balance report, and the ending balance section of the payout reconciliation report lists the transactions in it. If the two match, do your books match Stripe? Yes, and you can say so. If they do not, the gap between Stripe and your books is one of a short list: a payout recorded in the bank but never transferred out of clearing, a fee total typed wrong, a refund booked twice, or a sale recorded in both the clearing account and the bank. Work from the largest payout down; a gap that equals one payout's fee total is a skipped expense entry.
What the summary method gives up, and when to change
Summary sales receipts lose customer names and accounts receivable inside QuickBooks, so a customer's history lives in Stripe, not in the books. That is fine for a subscription business where Stripe already owns the customer record. It is not fine if you invoice from QuickBooks and need to see who still owes you; then record each payment against its invoice and the clearing method still holds. If you process hundreds of charges a day, a sync tool that posts per charge may save time, with the known cost of entries in closed periods and a clearing account nobody understands after a re-sync. The manual method is the one you can always explain.
Know the fee and refund totals before you open QuickBooks
Steps four and five need three numbers per payout: the fee total, the refund total and the net. Conciliq reads your payouts with a read-only key every morning, rebuilds each one from its charges, fees, refunds and disputes, and tells you whether the deposit is Matched, Timing or Unexplained. The monthly close report lists those totals per payout, so the QuickBooks entry is a copy, not a hunt. Forward it to your accountant as-is. We can see your data, never touch it.
Check yours
Does the money Stripe paid you match your books?
Upload a Stripe export or paste a read-only key. Every payout in the last 90 days, matched to the cent, usually in under a minute. Nothing stored.
Run the free audit →Questions people ask
- Should the Stripe clearing account be a Bank account or Other Current Asset in QuickBooks Online?
- Either works for the accounting. Bank type is easier day to day because QuickBooks offers it as a deposit-to account and in the transfer screen without extra steps. Whatever the type, never link it to a bank feed and never let its balance drift: it should always equal what Stripe is holding.
- Can I just record the net Stripe deposit as income and skip the clearing account?
- You can, and the profit is nearly right because missing fees and understated revenue cancel out. But gross revenue, refunds and sales tax bases are wrong, and no deposit can be traced to its sales. Most accountants will redo it at year-end. If volume is tiny, at least add the fee as a negative line in each deposit so the expense exists.
- I already use Intuit's Stripe connector. Does this method still apply?
- Yes, as the correction. The connector brings in deposits; it does not reliably bring in fees and refunds. Check one month: if the deposits in QuickBooks equal Stripe's net and no line equals Stripe's fee total, post the fee total per payout as an expense against the clearing account, or as a monthly adjustment, so the books carry the fees the connector dropped.
More guides
- Why your Stripe payout doesn't match your sales (and how to check it)
- QuickBooks' Stripe connector imports payouts, not fees. Here is what that does to your books
- Stripe payout breakdown: what every line inside a payout means
- Why a Stripe refund comes out of a later payout
- How a Stripe dispute hits your payout, and how to record it in your books
- A customer's card expires before their next Stripe renewal. What happens, and what to do
- Stripe debited your bank account. Why your balance went negative, and how to book it
- Stripe says the payout is Paid, but the money isn't in your bank. What each payout status means, and what to do
- How to reconcile Stripe payouts in Xero: what Xero matches on its own, and what it can't
- Stripe put a reserve on your account. What it does to your payouts, when the money comes back, and how to book it
- A Stripe renewal was declined. What do_not_honor, insufficient_funds and the other decline codes mean, and what to do about each
- You charged in euros or pounds and Stripe paid you in dollars. Where the conversion fee went, and how to reconcile it
- Your Stripe 1099-K is bigger than the money that hit your bank. Why, and how to tie it to your books
- When does Stripe pay you? The payout schedule, the first-payout wait, and what each setting does to your books
- How to read Stripe's payout reconciliation report: what each section means, which download to use, and how to tie every deposit to your books
- Your Stripe payout includes sales tax you owe. How to record it in QuickBooks, and why Stripe's tax report won't match your deposits
- A customer paid a year upfront through Stripe. How to record it in QuickBooks so one month doesn't look like a record
- Stripe sent an early fraud warning. Should you refund the charge or wait, and what each choice does to your payout
- Why your Stripe fees are more than 2.9% + 30¢, and how to find what each extra charge is
- A Stripe ACH payment looked paid, then failed days later. Why it happens, what it does to your payout, and how to book it
- A customer paid a Stripe invoice by check or bank transfer. How to mark it paid, why it never shows up in a payout, and how to book it
- You gave a customer a Stripe coupon. What it does to the charge, the fee and the payout, and how to record the discount in QuickBooks
- A Stripe refund failed. Where the money went, why your payout is suddenly bigger, and how to get the customer paid
- Hundreds of small Stripe payments failed overnight. What a card testing attack is, what to do first, and what it does to your payouts and books
- A customer downgraded or cancelled and Stripe gave them a credit, not a refund. Where the money is, why your next payout is smaller, and how to book it
- QuickBooks shows double your Stripe income. Why the sync app and the bank feed both recorded it, and how to fix it
- Stripe says a subscription is incomplete, past due, unpaid or paused. What each status means for the customer, your payouts and your books
- You took Stripe Capital financing and your payouts got smaller. How the repayment works, and how to record it in QuickBooks or Xero
- You took a Stripe Instant Payout and now nothing reconciles. How to match instant payouts, their fee and the smaller payouts after them
- Stripe fee calculator: what your payouts really cost