Why doesn’t my Stripe payout match my sales?
The bank shows one deposit a day or so, and it is smaller than your sales. That is because Stripe pays out a net figure: the charges in that batch, minus Stripe’s fees, minus refunds, disputes and adjustments. Your bank never sees the gross sales at all.
This is an illustrative setup, not a customer story. A café has 12 card charges totalling $1,250.00 in one payout period. A customer gets a $50.00 refund. Assuming a fee of 2.9% + 30¢ per charge (an assumption for this example only, not a Stripe rate), fees are $39.85. The payout is $1,250.00 − $50.00 − $39.85 = $1,160.15. The bank shows $1,160.15 and nothing else.
Two timing gaps make this harder:
- Charge date and arrival date differ. The bank date is when the payout lands. The charges inside it can be from earlier days, or from last month.
- Payouts can straddle month end. Part of a month’s sales may sit in Stripe’s balance on the last day, waiting to be paid out.
If you record the $1,160.15 as income, your sales look $89.85 too low and your fees and refunds disappear. Your margin and your sales tax both come out wrong.
How do I record Stripe payments in QuickBooks, step by step?
Set up once. Create these accounts:
- Stripe Clearing (Other Current Asset). This holds money that Stripe owes you but has not yet paid out.
- Merchant fees (Expense).
- Refunds (contra-income, or an income reduction).
- Chargebacks and disputes (Expense or contra-income).
- Exchange gain or loss (only if you take payments in foreign currencies).
Step 1: record sales at gross. Enter each sale as a sales receipt or invoice payment. Deposit it to Stripe Clearing, not to Undeposited Funds or your bank. Split the charge into sales, Sales Tax Payable and, for a café, Tips Payable. Tax and tips are inside the Stripe charge amount, so a receipt that books the whole charge to Sales overstates income.
Step 2: record fees. Enter the fees as an expense paid from Stripe Clearing to Merchant fees. Take the totals from Stripe’s reports, either daily or per payout. Be consistent: pick one rhythm and keep it.
Step 3: record refunds. Enter each refund as a refund receipt or credit memo paid out of Stripe Clearing, with the tax portion included.
Step 4: record the payout. Enter it as a transfer from Stripe Clearing to your bank for the net amount. Then match it to the bank-feed line. Do not use Add to create income from the deposit.
For the café example, the clearing account now shows: $1,250.00 in, $39.85 fees out, $50.00 refund out, and a $1,160.15 transfer to the bank. The balance is zero for that payout.
| Stripe line | QuickBooks entry | Accounts affected | Watch for |
|---|---|---|---|
| Charge (gross) | Sales receipt or invoice payment | Stripe Clearing (debit); Sales, Sales Tax Payable, Tips Payable (credit) | Tax and tips are inside the charge |
| Processing fee | Expense paid from clearing | Merchant fees (debit); Stripe Clearing (credit) | Fee is not returned on refunds (at the time of writing) |
| Refund | Refund receipt or credit memo | Refunds or Sales, Sales Tax Payable (debit); Stripe Clearing (credit) | Refund the tax proportionally |
| Dispute and dispute fee | Expense paid from clearing | Chargebacks and disputes (debit); Stripe Clearing (credit) | Reverse if you win |
| Payout | Transfer | Bank (debit); Stripe Clearing (credit) | Match to the bank line, never add as income |
| Currency difference | Journal entry | Exchange gain or loss | Bank amount differs from charge amount |
What about fees, refunds, disputes and foreign currency?
- Fees stay after refunds. Stripe generally does not return the processing fee on a refunded charge (at the time of writing). A refund-heavy month shows a higher effective fee rate. That is expected, so do not reverse fees to make the percentage look right.
- Partial refunds. Refund the tax portion in proportion, or Sales Tax Payable will stay overstated.
- Disputes come as several movements. The disputed amount leaves your balance, a dispute fee may follow, and the funds return if you win. Book each one to Chargebacks and disputes. Use Stripe’s balance transaction list as the source, because a payout-only view hides them.
- Failed or negative payouts. If refunds exceed the balance, the payout can be reduced or the bank debited. A failed payout returns to the Stripe balance, so it should not appear as a transfer to your bank.
- Multi-currency. The bank amount differs from the charge amount by the exchange rate. Either post the difference to Exchange gain or loss, or use QuickBooks multicurrency. Multicurrency cannot be turned off once it is enabled in QuickBooks Online, so decide with your bookkeeper first. For a few foreign-currency orders, recording settled home-currency amounts is often simpler.
How do I reconcile Stripe payments in QuickBooks at month end?
The clearing account is your check. At month end, its balance should equal Stripe’s balance on that date, which is available plus pending. It should not be zero. Money still waiting in Stripe is a legitimate balance.
- Run Stripe’s Balance summary report for the month. Under Reports in the Dashboard (at the time of writing), it shows the start balance, activity, payouts and end balance.
- Compare the end balance with the Stripe Clearing balance in QuickBooks on the same date.
- For any payout that doesn’t match the bank, open the itemized Payout reconciliation report. Compare its lines with the clearing entries.
- Reconcile the bank account. Each payout should match one transfer.
When the numbers differ, the usual causes are:
- A payout in transit across month end.
- A missed dispute fee or a refund booked in the wrong month.
- Tax or tips lumped into sales.
- A bank-feed rule that categorized the deposit as income, which double-counts revenue.
This takes about 15 minutes a month if each payout was recorded correctly during the month. Check with your bookkeeper or accountant on how tax should be treated for your business. This guide describes bookkeeping mechanics, not tax advice.
Can I automate recording Stripe in QuickBooks?
There are a few routes, and each has trade-offs.
- QuickBooks Payments takes card payments inside QuickBooks. It may suit you if you have not chosen a processor yet. Read the Stripe vs QuickBooks Payments comparison before you decide.
- Stripe and third-party connectors from app listings can push payouts or transactions into QuickBooks. Check what each one posts at the time you look: gross or net, fees, refunds, disputes and tax. Then check what it leaves to you. Do not assume a connector handles everything.
- Confusion about official routes. Users in QuickBooks community threads report that help articles point to a Stripe integration page that they cannot find. Check the current listings before you rely on any route.
Pandaflow sets up the Stripe sync on request. It is not self-serve today. Here is how it works:
- Request setup.
- A short call about what you sell and how your books are kept.
- Pandaflow builds the sync and tests it on real records.
- Go live.
- The agent keeps it running, and repairs the sync if Stripe or QuickBooks changes.
Once it runs, you should see sales recorded at gross and split into tax and tips, fees posted as an expense, refunds and disputes recorded, and one transfer per payout that matches the bank line. You can read more on the QuickBooks and Stripe integration page. Pandaflow is free to start; plans are Lite $79, Silver $299 and Gold $499 a month, and it can be deployed in Pandaflow’s cloud or yours. See pricing for the current details.
What can go wrong?
- Double-counted revenue. A bank-feed rule or an Add action on the payout books the deposit as sales on top of the receipts.
- A clearing balance that never matches Stripe. The usual cause is a missed refund, dispute or fee.
- Fees booked inconsistently. Once per payout in one month and once per day in another makes months hard to compare.
- Changing the payout schedule mid-month. That changes what each payout contains, so check the clearing account after the change.
- Turning on multicurrency without a plan. It cannot be reversed in QuickBooks Online once enabled.