Skip to main content

How do I sync Stripe and QuickBooks, including refunds, fees and payouts?

Use Stripe webhooks to create QuickBooks customers and payments, and post them to a Stripe clearing account. Record fees, refunds and disputes there, and book each payout as a transfer to your bank. A custom build like this costs $1,500–$6,000 at our rates and takes two to four weeks.

Why the simple version doesn't reconcile

Most first attempts post each Stripe charge as a QuickBooks Online payment straight to the bank account. Then the bank feed shows one deposit that matches none of them. A Stripe payout is a net number: gross charges, minus Stripe fees, minus refunds, minus disputes, plus or minus earlier adjustments, often over several days of activity.

So the books need a middle layer. You add a bank-type account in QuickBooks called Stripe Clearing. Every Stripe movement is posted to it, and each payout moves the net amount from it to your operating bank. Once a payout lands, the clearing balance should match the Stripe balance you haven’t been paid out yet. If it doesn’t, something was missed.

How the sync works, event by event

Stripe sends a webhook for every change. The integration listens for a short list of events and turns each one into a single QuickBooks transaction:

Stripe event What it creates in QuickBooks Account it hits
customer.created / customer.updated Customer record, matched on Stripe customer ID stored in a custom field or memo None
invoice.paid or charge.succeeded Sales receipt, or a payment applied to an existing invoice Stripe Clearing (gross)
Fee from the balance transaction Expense line to Merchant Fees Stripe Clearing
charge.refunded Refund receipt or credit memo plus refund Stripe Clearing
charge.dispute.created / closed Journal entry to a disputes account, reversed if you win Stripe Clearing
payout.paid Transfer to the operating bank for the net amount Clearing to bank

Fees deserve a note. Stripe doesn’t put the fee on the charge itself; it sits on the related balance transaction. The integration fetches that transaction and posts the fee as its own line. That way revenue stays gross and fees show up as an expense, which is what your accountant wants.

Payout reconciliation

When payout.paid arrives, the integration asks Stripe for every balance transaction in that payout. It checks that each one has already been posted, posts any that are missing, then books the transfer. If the totals don’t match to the cent, it stops and alerts someone rather than forcing the entry through.

A worked example with real numbers

Three customers each pay $100 by card. At Stripe’s standard US card rate of 2.9% plus 30 cents, each fee is $3.20. One customer is refunded in full the next day, and Stripe keeps the original fee.

Entry Stripe Clearing Running balance
3 sales receipts, $100 each +$300.00 $300.00
3 fee lines, $3.20 each −$9.60 $290.40
1 refund receipt −$100.00 $190.40
Payout transfer to bank −$190.40 $0.00

The bank feed shows a $190.40 deposit, which matches the transfer exactly. Revenue is $300, refunds are $100, fees are $9.60. Each customer’s history is correct, and the clearing account is back to zero.

Disputes work the same way. A $100 dispute moves $100 plus Stripe’s dispute fee out of clearing into a disputes account. If you win, the reversal moves it back.

The failure modes nobody mentions

  • Duplicate records. Stripe can send the same webhook more than once and retries failed deliveries for up to three days. Store each event ID and skip any you’ve already processed.
  • Events out of order. A payment can arrive before its customer exists in QuickBooks. The handler has to create the customer when it’s missing, or queue the payment and retry.
  • Customer matching. Matching on email merges two people who share a billing inbox and splits one person with two emails. Match on the Stripe customer ID and keep email as a fallback for a human to check.
  • Re-authentication. QuickBooks OAuth tokens expire and must be refreshed. If refresh fails silently, the sync stops and nobody notices until month-end.
  • Partial failures. The sales receipt posts but the fee line fails, and now clearing is off by $3.20. Write each event’s entries as a unit and log what was written.
  • Multi-currency and tax. Charges in other currencies, or tax collected through Stripe Tax, need mapping rules decided with your accountant up front.

Your options and what each costs

Option Upfront Monthly Who maintains it What breaks first
Manual entry from Stripe reports $0 A few staff hours per week Your bookkeeper Fee and refund lines skipped under time pressure
Off-the-shelf sync app Setup time Typically $20–$300+ depending on volume The vendor Customer matching and custom account mapping
Zapier or Make $0–$1,000 Task-based plan fees Whoever built it Payouts, which need a lookup across many transactions
Custom integration (our figures) $1,500–$6,000 Hosting, usually under $50 Us or your developer, with a runbook Rarely the logic; usually an upstream API change

The top of our range covers mixed invoice and one-off payments, multi-currency, Stripe Tax, dispute handling and a backfill of historical data. The bottom covers one currency, sales receipts only, and payouts reconciled from the go-live date. We bill $85 an hour for changes after launch.

We’ve done this before. A Stripe-to-Salesforce and Google Sheets finance sync we built has run for two years with very little maintenance, and it uses the same event-ID deduplication and logging pattern.

Which option to choose

  • Under about 100 charges a month, no refunds to speak of: do it by hand from the Stripe payout report. Don’t hire anyone.
  • Standard products, one currency, default accounts are fine: try an off-the-shelf sync app first, and check one full month of payouts against the bank before you trust it.
  • Invoices that originate in QuickBooks or a CRM, custom matching rules, disputes or multi-currency: build it in code, with deduplication, payout checks and alerting.
  • Your chart of accounts is still changing: settle it with your accountant first. Automating before then means building twice.

Frequently asked questions

Should Stripe payments go to Undeposited Funds or a clearing account in QuickBooks?
Use a dedicated Stripe clearing account set up as a bank-type account. Undeposited Funds works when you group payments into a deposit by hand, but it gets messy once fees and refunds are netted out of payouts. A clearing account zeroes out on every payout, so errors show up right away.

How do I record Stripe fees in QuickBooks?
Post the full sale as revenue, then post the fee from the Stripe balance transaction as a separate expense line, such as Merchant Fees, from the clearing account. Recording sales net of fees understates revenue and makes fees impossible to track. A sync should do this for every charge automatically.

How should Stripe refunds appear in QuickBooks?
Record a refund receipt, or a credit memo and refund if the original was an invoice, paid from the Stripe clearing account. Stripe usually doesn’t return the original processing fee, so the fee expense stays. That keeps the customer’s history and your refund totals accurate.

How long does a custom Stripe to QuickBooks integration take?
Two to four weeks for most builds, including testing against a QuickBooks sandbox and a month of real payouts. A historical backfill or multi-currency support pushes it toward the longer end. Anyone promising a reconciled sync in a few days is probably skipping payouts.

Can Zapier sync Stripe payouts to QuickBooks correctly?
Zapier handles single events well, like creating a customer or a sales receipt for each charge. Payouts are harder, because reconciling one means looking up and checking every balance transaction in it, which turns into long, fragile multi-step workflows. Many teams use Zapier for charges and reconcile payouts by hand.

Related answers

Want a scoped estimate for your Stripe and QuickBooks setup?

We’ll send you a free written scope, or book a free 20-minute call. Have ready your monthly charge count, whether you use Stripe invoices or one-off payments, and how you reconcile payouts today. Start a conversation.