Stripe to QuickBooks integration

A Stripe to QuickBooks integration works when every Stripe payout in QuickBooks Online matches the deposit that landed in your bank, to the cent, with fees, refunds and disputes posted to the accounts your accountant chose. Moving charges across is the easy part. Making the deposit match is where most setups fail, and where the month-end hours go.

Connects to

  • Stripe
  • QuickBooks
  • Xero
  • NetSuite
  • Excel
StripeQuickBooks
1,640.00INV-2291
Aug 15 reminderNever sent
INV-2291Paid

Why Stripe deposits never match the QuickBooks sales total

  • Payouts are net, sales are gross

  • Invoices stay open after payment

  • Refunds and disputes land late

  • Duplicates from two pipes

  • One payout bundles many days

The full guide

5 min read

The usual symptom: QuickBooks shows a day of sales, the bank shows one smaller deposit two days later, and someone spends the close matching the two by hand. This page covers the three posting models, fees, refunds, disputes and currencies, automatic invoices, and when a connector app is enough.

Benian builds the sync and the checks; your accountant sets the posting policy, and nothing here is accounting or tax advice.

Three ways to post Stripe activity into QuickBooks Online

Every Stripe QBO integration uses one of three posting models. The right one depends on volume, whether customers need records in QuickBooks, and what your accountant wants to see.

Per charge posting creates a sales receipt or invoice payment for each charge, with the customer attached. It suits service firms with fewer, larger transactions. At high volume it fills QuickBooks with thousands of entries nobody reads.

Per payout summary posting creates one entry per payout: gross sales, fees, refunds and the net deposit. It suits e-commerce with many small orders, where order detail already lives in Stripe or the store.

A payout clearing account is often the cleanest model for reconciliation. Charges post into a Stripe clearing account, fees and refunds post against it, and each payout moves the net amount to the bank. When the payout matches the deposit, clearing returns to zero. Any leftover balance is a specific, findable error.

From one entry per charge to a clearing that checks itself

Fees, refunds, disputes and multiple currencies

Stripe records every balance movement as a balance transaction tied to the payout that settled it. For any payout you can list exactly which charges, fees, refunds and adjustments it contains, so a sync built on payouts inherits that accuracy.

Fees should post as an expense to the account your accountant names, never netted silently out of revenue. Refunds reduce sales or post to a returns account, attached to the customer where one exists. Disputes need the withdrawn amount and any dispute fee when Stripe takes the money, and a reversal if you win. A dispute still under review is not booked as a loss until Stripe takes the money.

  • Fee account, and whether fees post per charge or per payout.
  • Refund account, and whether partial refunds attach to the original sale.
  • How dispute withdrawals, dispute fees and won disputes post.
  • For several currencies: QuickBooks multicurrency set up, and the settled amount Stripe reports used, so the conversion difference is recorded once.
Four deductions stand between the sales and the deposit

QuickBooks invoice automation: creating and closing invoices from Stripe payments

There are two directions, and mixing them is how duplicates start. In the first, the invoice lives in QuickBooks, the customer pays through a Stripe payment link, and the sync records a payment against that exact invoice so it closes. The match key is the QuickBooks invoice number stored in Stripe metadata, not the customer name or amount, which repeat.

In the second, the sale starts in Stripe, a subscription renewal or a checkout, and the sync creates the QuickBooks invoice or sales receipt and applies the payment in one step. This is what most people mean by auto invoice QuickBooks. It works when product and tax codes are mapped once and the sync refuses to post an item it cannot map.

Pick one direction per revenue stream, and have the sync check for an existing record before it creates one.

Connector apps versus a custom Stripe QuickBooks sync

Start with a connector app. Several apps on the QuickBooks app marketplace connect Stripe and QuickBooks Online. Check how each one posts payouts, fees and refunds. If one supports your accountant's posting model and your payouts reconcile for two months in a row, stop there. Do not hire anyone, including Benian.

A custom sync, meaning QuickBooks workflows built to your rules, earns its place when the connector cannot follow them: invoices must close by a number in metadata, revenue must split by location or class, Stripe is one of several payment sources, refunds route differently by product, or you need a reconciliation report the app does not produce. General automation platforms price per task or per execution; a self-hostable tool such as n8n can run the same logic in an account you own.

The reconciliation check that proves the integration works

A sync that posts without errors is not proof. The proof is a report, run after each payout or daily, that compares three numbers: the payout total Stripe reports, the deposit QuickBooks recorded for that payout, and the bank deposit from the bank feed. All three should match. The clearing account, if you use one, should be zero after each payout settles.

When they do not match, the report says why in terms a bookkeeper can act on: which balance transaction is missing, which refund posted twice, which charge mapped to no product. The mismatch goes to a named person with the payout ID attached. The sync flags errors; it does not fix the books by itself.

  • Share of payouts matched to the bank deposit with no manual edits.
  • Clearing account balance at month end: zero or fully explained.
  • Invoices paid in Stripe but still open in QuickBooks: none.
  • Bookkeeper hours on Stripe at close, before and after.
Three totals per payout; a gap names its cause

What can go wrong with QuickBooks automation, and the guards against it

Most failures are quiet. A token expires and posting stops unnoticed until close. A new Stripe product has no QuickBooks item. A retry after a timeout creates a duplicate. A bank feed rule matches a deposit to the wrong transaction.

The guards: every posting carries the Stripe ID so a retry finds the existing record. Unmapped items stop and alert instead of posting to a catch-all account. A daily heartbeat flags a missing expected payout. Only one path, the sync or the bank feed, creates deposits from Stripe money.

What Benian builds and what your accountant still owns

Benian builds the sync, the invoice matching and the reconciliation report from the posting rules your accountant writes down, in accounts your business owns, with credentials you hold. History is backfilled only after a test month reconciles. You keep the workflows and the documentation.

Your accountant owns the chart of accounts, posting policy, tax treatment and the close. Benian does not do bookkeeping. Cost depends on the number of revenue streams and payment sources, the posting model, invoice matching rules, multicurrency, and how much history to backfill. Every engagement is scoped after the free Opportunity Map or a 30‑minute call.

How a Stripe integration with QuickBooks Online gets built

  1. Write down the posting rules

  2. Audit one month of payouts

  3. Map customers, items and invoices

  4. Run a test month in a sandbox

  5. Go live with the reconciliation report

Questions we get asked

How do I set up a Stripe QuickBooks integration?

Choose a posting model first: per charge, per payout summary, or a payout clearing account. Then use a connector app or custom sync that posts on that model and links each entry to its Stripe payout. Test on one month of real payouts before going live.

Why does my Stripe payout not match QuickBooks?

Usually because QuickBooks records gross sales while Stripe deposits the net amount after fees, refunds and disputes, and one payout covers several days. Post fees and adjustments per payout, or use a clearing account, and the difference becomes a specific line you can find.

How should Stripe fees be recorded in QuickBooks?

As an expense in the account your accountant chooses, posted per payout or per charge, rather than netted out of sales. Ask your accountant for the account and the timing; Benian builds to that rule and does not set it.

Can QuickBooks invoices be created automatically from Stripe payments?

Yes. A sync can create the invoice or sales receipt from a Stripe charge and apply the payment, or record a Stripe payment against an existing QuickBooks invoice so it closes. The second case needs the invoice number stored on the Stripe payment, so the match does not rely on names or amounts.

More questions
Do I need a connector app or a custom integration?

Try a connector app first. If it supports your posting model and payouts reconcile for two months without manual edits, keep it. Go custom for invoice matching by metadata, revenue split by class or location, several payment sources, or a reconciliation report the app lacks.

How are refunds and disputes handled?

A refund reduces the payout it is paid from and posts to the sales or returns account your accountant picks. A dispute posts the withdrawn amount and any dispute fee when Stripe takes the money, and a reversal if you win.

Stop matching Stripe deposits by hand.

A free 30-minute call about your business, your systems and what you want to build.