Guide · 8 min read · November 18, 2026
Stripe reconciliation in QuickBooks Online: payouts to invoices
Your Stripe payout lands in the bank as one number, but your QuickBooks Online invoices were paid one at a time and Stripe kept its fees along the way. If you match deposits by eye, open invoices pile up, revenue gets booked twice and fees disappear. This guide is for SaaS and services companies that bill through Stripe: how to break each payout into the invoices behind it and record it so the books tie out every month.
What's inside
- · Why a Stripe payout never equals your invoice totals
- · The two ways to record Stripe payouts in QuickBooks Online
- · Pulling the right report from Stripe
- · Reconciling one payout to its invoices, with a worked example
- · Refunds, disputes and a monthly checklist
Why a Stripe payout never equals your invoice totals
Stripe doesn't send you each customer payment. It collects payments into your Stripe balance, takes out its processing fees, subtracts refunds and disputes, and pays out the net amount in batches. One bank deposit can cover a dozen invoices from several days, minus fees on every one of them, minus a refund to a customer from last month.
The fees alone make an exact match impossible. Stripe's standard US price for domestic cards is 2.9% + 30¢ per successful transaction, with an extra 1.5% for international cards and 1% more when currency conversion is needed. A dispute adds a $15 fee. Check Stripe's pricing page for the rates on your own account, since negotiated and payment-method pricing differ.
- Gross invoice payments are your revenue or collections against accounts receivable.
- Processing fees are an expense, usually merchant or payment processing fees.
- Refunds and disputes reduce what Stripe pays out and need their own entries.
- The payout is a transfer of cash you already earned, not new income.
If the books record only the net deposit, revenue is understated, fees never show up and your invoices stay open in accounts receivable. If the books record the invoices as paid and the deposit as income, revenue is counted twice.
Two ways to record Stripe payouts in QuickBooks Online
Both methods start with the same rule: mark each invoice paid in full for the gross amount the customer paid, then account for fees separately. Never shrink an invoice payment to make it match the deposit.
Undeposited Funds and a bank deposit
Receive each invoice payment into Undeposited Funds. When the payout arrives, create a Bank Deposit, tick the payments it covers and add the Stripe fees as a negative line to your fees expense account. Intuit documents this method. It works well for a handful of invoices a week.
A Stripe clearing account
Add a bank-type account named Stripe Clearing. Invoice payments, fees, refunds and disputes are recorded there, and each payout is a transfer from Stripe Clearing to your operating bank. The account's balance should equal the funds still sitting in Stripe. This scales better once volume grows.
Intuit's own guidance for third-party processors is to enter the fee as a negative amount on the Bank Deposit screen rather than editing the original payment, so the bank register matches the statement. A clearing account follows the same logic but keeps every Stripe movement in one place you can reconcile like a bank account. If you already run one for Shopify, the Shopify payouts guide shows the same structure on a different platform.
Pull the right report from Stripe
Stripe's Payout reconciliation report is built for this job. It matches each payout that reaches your bank to the transactions inside it, grouped by category such as charges, refunds and fees. Download the itemized CSV and you get every payment, refund, dispute and fee in each payout on its own line.
- 01
Open the report for the month
In the Stripe Dashboard, go to Reports and open Payout reconciliation. Set the date range to the month you're closing.
- 02
Choose your columns
Add invoice_number and customer_name. For Stripe Billing invoices, Stripe can include the invoice ID and number on charges, refunds and disputes, which is what lets you tie a line back to a QuickBooks invoice.
- 03
Use the matching invoice number
If you create invoices in QuickBooks and collect through Stripe, store the QuickBooks invoice number in the payment's metadata. The itemized CSV can include custom metadata columns for exactly this kind of match.
- 04
Export the itemized CSV
Keep the file with the month's close records. It's the support for every payout entry you make.
Reconcile one payout to its invoices, with a worked example
Say a SaaS company bills three customers through Stripe and also refunds $100 to a customer who paid last month. All three pay by domestic card at standard pricing, and Stripe batches everything into one payout.
| Line in the payout | Gross | Stripe fee | Effect on payout |
|---|---|---|---|
| Invoice 1041, Customer A | $1,200.00 | $35.10 | +$1,164.90 |
| Invoice 1042, Customer B | $800.00 | $23.50 | +$776.50 |
| Invoice 1043, Customer C | $500.00 | $14.80 | +$485.20 |
| Refund on invoice 1037 | -$100.00 | None | -$100.00 |
| Payout to bank | $2,400.00 | $73.40 | $2,326.60 |
Each fee is 2.9% of the invoice plus 30¢: $34.80 + $0.30 on the $1,200 invoice, for example. Here is how the payout goes into QuickBooks Online with a clearing account.
- 01
Receive the three payments
Record a payment on invoices 1041, 1042 and 1043 for the full $1,200, $800 and $500, deposited to Stripe Clearing. All three invoices close and accounts receivable drops by $2,500.
- 02
Record the fees
Enter one expense of $73.40 from Stripe Clearing to your merchant fees account, dated the payout date and referencing the payout ID.
- 03
Record the refund
Enter a $100 refund receipt or credit memo against the customer on invoice 1037, paid out of Stripe Clearing, so revenue and the customer record both reflect it.
- 04
Transfer the payout
Record a $2,326.60 transfer from Stripe Clearing to the operating bank account, then match it to the deposit in the bank feed.
- 05
Check the clearing balance
After this payout, Stripe Clearing should be back to the amount still pending in Stripe. In this example, that's $0.
With the Undeposited Funds method, steps 1 and 3 are the same but go to Undeposited Funds, and steps 2 and 4 happen together in one Bank Deposit: tick the three payments and the refund, add a -$73.40 line to merchant fees, and confirm the deposit total is $2,326.60.
Refunds, disputes and other exceptions
- Refunds come out of your Stripe balance, so they reduce a payout. Record them against the original customer and invoice, not as a fee or a negative deposit with no name on it.
- Disputes pull the disputed amount out of your balance and add Stripe's dispute fee. Record the withdrawn amount against the customer and the fee to merchant fees. If you win and the funds return, reverse the withdrawal in the month they come back.
- Payments in other currencies can carry extra fees and conversion. Book the converted amount that reached your Stripe balance and record the conversion cost with the other fees.
- Timing matters at month-end. Stripe groups a payout by its estimated arrival date, not the date your bank posts it, so a payout dated the 31st may hit the bank on the 1st. A clearing account handles this without fuss: the balance sits there until the transfer clears.
For SaaS and subscription businesses, matching cash is only half the job. Payments for annual plans also need to flow through deferred revenue so revenue is recognized over the service period, not the day Stripe collects it.
A monthly Stripe reconciliation checklist
- Every payout in the bank statement matches a payout in Stripe's Payout reconciliation report.
- Every Stripe invoice payment is recorded at its gross amount against the right QuickBooks invoice.
- Total Stripe fees for the month in QuickBooks equal the fee total in the report.
- Every refund and dispute is tied to a customer, with dispute fees in merchant fees.
- The Stripe Clearing balance, or Undeposited Funds, equals funds still pending in Stripe at month-end.
- Open invoices in accounts receivable don't include anything Stripe shows as paid.
- The itemized CSV is saved with the month's reconciliation records.
Frequently asked questions
- Should Stripe fees reduce revenue or be an expense?
- Most small businesses record invoice payments at the gross amount and book Stripe fees as a separate merchant fees expense. That keeps revenue matched to what customers were billed and makes the cost of collecting payments visible.
- Can I just match the Stripe deposit in the bank feed to income?
- Not if you invoice in QuickBooks. Doing so leaves invoices open in accounts receivable, and if you later mark them paid, revenue is counted twice. Match the deposit to the invoice payments and fees instead.

