Check your own payouts free. Every Stripe payout in the last 90 days, matched to the cent. Nothing stored. Run the check →

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