Guide
QuickBooks' Stripe connector imports payouts, not fees. Here is what that does to your books
The free connector is convenient and it is wrong in a specific, predictable way. It records the deposit. It does not record what the deposit is made of.
What the connector actually records
One line per payout, for the net amount Stripe sent to your bank. If Stripe collected $5,000 and paid you $4,812.33, QuickBooks sees $4,812.33 and nothing else.
What goes missing
The $150.00 of processing fees, which should be an expense. The $37.67 refund, which should reduce revenue. Any dispute and its fee. Any reserve. Over a year on $300,000 of sales, that is roughly $9,000 of fees that never appear as an expense, and revenue that is understated by the same amount.
Why it matters at tax time
Understated revenue and missing expenses net to the same profit, so the tax bill is close. The problem is everything else: gross revenue on a loan application, the margin a buyer or investor sees, the sales tax base in states that look at gross, and the reconciliation your accountant has to redo by hand because the deposit does not match any invoice.
The fix is not more syncing
Tools that push every charge into QuickBooks fix the fee problem and create a new one: entries in closed periods, duplicates after a re-sync, and a clearing account nobody understands. The lighter fix is to keep the connector and verify the deposits: know what each payout is made of, and give your bookkeeper the fee and refund totals per payout so the adjusting entry is a two-minute job instead of an afternoon.
A quick test on your own books
Open last month in QuickBooks and find the deposits from Stripe. Add them up. Now open Stripe, set the date range to the same month and read the gross volume and the fee total. If the deposits in your books equal Stripe's net and nowhere in the books is there a line equal to Stripe's fee total, the connector has done exactly what it does, and your bookkeeper has an adjusting entry to make before the month closes.
What Conciliq does instead
It never writes to QuickBooks. It reads Stripe, rebuilds every payout into charges, fees, refunds and disputes, and tells you each morning whether the deposit is matched, carrying timing items, or needs a look. The monthly close report lists fees and refunds per payout so the books can be corrected once, correctly.
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
- Does the QuickBooks Stripe connector record fees anywhere?
- Newer versions of the connector can record refunds and fees for some account types, but one Stripe account per company and a delay of about two hours still apply. Check one payout in your books against the same payout in Stripe to see what yours does.
- Can I keep the free connector and still get fees right?
- Yes. Keep the connector for the deposits and add the fee and refund totals per payout from a verifier. Your bookkeeper posts one adjusting entry per month.
- Is Conciliq a replacement for the connector?
- No. It is the check on top of it. It reads Stripe, never writes to QuickBooks.
More guides
- Why your Stripe payout doesn't match your sales (and how to check it)
- 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 record Stripe payouts and fees in QuickBooks Online by hand: the clearing account method, step by step
- 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