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.
How do I sync Stripe and QuickBooks, including refunds, fees and payouts?
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
- How do I sync QuickBooks Online invoices and payment status back into HubSpot deals automatically?
- What does it cost to build an internal dashboard that pulls from HubSpot, QuickBooks and Stripe?
- Why does my HubSpot to QuickBooks sync create duplicate customers and invoices?
- All answers about AI-driven operations
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.