MSP
6 min read
October 12, 2026

How to connect Stripe and QuickBooks without a third-party bridge tool

Adfin team
Adfin team

Stripe pays out net lump sums that don't match any single invoice, and its own QuickBooks export only works with QuickBooks Desktop. For QuickBooks Online, the no-bridge route is recording each payout by hand from Stripe's payout reconciliation report. If you'd rather skip both the bridge and the manual work, take payments through a platform that pays out each invoice in full and matches it in QuickBooks for you.

In this article

The short version

  • Stripe takes its fee off each payment and pays one net amount about three business days later, which the QuickBooks bank feed can't match to any invoice.
  • Stripe's IIF export works only with QuickBooks Desktop, and for QuickBooks Online Stripe points you to a third-party integration.
  • Check Apps in your own QuickBooks file for a Stripe connection, and make sure it brings in gross payments, fees and payouts separately.
  • Record each payment at gross into a Stripe clearing account, post the fees to an expense account, then transfer the net payout to the bank.
  • Adfin pays out each payment in full with its fee invoiced separately, and matches it to the invoice in QuickBooks through a two-way sync.

Why Stripe payouts don't match your invoices

Stripe takes its fee off each payment, adds up everything it collected that day, and sends you one net amount about three business days later. Your QuickBooks bank feed sees that single line and has no invoice of that value to match it to.

Say three clients pay you by card on a Monday. One pays £1,200 on a business card, which Stripe charges at 2.8% + 20p, so £33.80. The other two pay £450 and £2,000 on personal cards at 1.5% + 20p, so £6.95 and £30.20. On Thursday, £3,579.05 lands in your bank.

To reconcile that one line, someone has to find the three invoices it covers, record each at its full amount, post £70.95 of fees to an expense account, and check the lot adds back to £3,579.05. With three payments that's quick. With forty in a payout, and two clients on the same monthly fee who paid on the same day, it becomes guesswork on amounts. A bridge tool does that matching for you, and many bridges charge by the number of transactions they sync, so the bill tends to grow as you do.

What QuickBooks and Stripe offer without a bridge

Stripe's IIF export, which brings payments, fees and payouts into your books in one file, only works with QuickBooks Desktop. For QuickBooks Online, Stripe's own guidance is to use a third-party integration, which is the bridge you're trying to avoid.

QuickBooks Online may list a Stripe connection of its own under Apps in your file. If you see one, check what it brings in before you plan month-end around it: you need each payment at its gross amount, the fees as an expense and the payout as one line that matches your bank feed.

If there's nothing suitable in your file, the no-bridge option left is doing it by hand from Stripe's payout reconciliation report.

How to record a Stripe payout by hand

This works if you take a handful of card payments a month.

  1. Keep Stripe on automatic payouts. The payout reconciliation report can't tell you which payments are in an instant payout.
  2. In QuickBooks, set up a "Stripe fees" expense account and a "Stripe clearing" account.
  3. When a payout hits your bank feed, open the report for it. It lists each payment with its gross amount, fee and net.
  4. Receive each payment against its invoice at the gross amount, into Stripe clearing, on the day the client paid.
  5. Post the total fees from Stripe clearing to Stripe fees.
  6. Transfer the net payout from Stripe clearing to your bank account and match it to the bank feed line.

At month end, the clearing balance should equal what Stripe is holding for you that hasn't paid out yet. If a payout doesn't agree to the penny, look for a refund or dispute in the report you haven't entered.

Most of the time goes on step 4. If your Stripe payments don't carry the invoice number, you're matching on amounts alone. And if you skip clearing and record one deposit per payout instead, your invoices stay open until the money lands, so your aged debtors report shows clients as owing money they've already paid, and you risk chasing them for it.

How to take payments that match invoices on their own

You only need a bridge because the money arrives as net lump sums, so the simpler fix is taking payments that don't arrive that way.

Adfin takes cards, Apple Pay, Google Pay, pay by bank, bank transfer and direct debit in one place, and pays out every weekday in full, with its fee invoiced to you separately. Every payment keeps its full invoiced value and is matched to that invoice in QuickBooks through a two-way sync, including part payments, overpayments and payments with a missing reference. Your contracted monthly fees can go on direct debit, where the percentage fee is capped at £4, and project work or hardware can go on card, all reconciled the same way. Business Visa and Mastercard cards are priced at 2% + 20p, against Stripe's 2.8% + 20p.

Because payment and chasing happen in the same place, Adfin's AI credit control can see which invoices are still unpaid and chase them over email, SMS or WhatsApp, on a schedule and within rules you approve.

Common questions

Does QuickBooks Online have a native Stripe integration in the UK? Check under Apps in your own file. If nothing there brings in gross payments, fees and payouts separately, Stripe's guidance for QuickBooks Online is a third-party integration.

Can I import Stripe's IIF file into QuickBooks Online? No. Stripe's IIF export only works with QuickBooks Desktop.

Why doesn't my Stripe payout match any invoice? Each payout is several payments added together with Stripe's fees taken off, so it won't equal any single invoice. Stripe's payout reconciliation report breaks it back into individual payments.

How should I record Stripe fees in QuickBooks? As an expense in one dedicated fees account, so your sales show the full amount clients paid and your card costs are in one place.

Do I need automatic payouts to reconcile Stripe? Yes, if you're using the payout reconciliation report, because it only covers automatic payouts.

Can I take cards and direct debit without Stripe and a bridge? Yes. Adfin takes both, pays out in full with fees invoiced separately, and matches every payment to its invoice in QuickBooks.

Sources

  • Stripe Docs - Integrate an accounting tool (accurate as of October 2026) https://docs.stripe.com/accounting-integrations
  • Stripe Docs - Receive payouts (accurate as of October 2026) https://docs.stripe.com/payouts
  • Stripe Docs - Payout reconciliation report (accurate as of October 2026) https://docs.stripe.com/reports/payout-reconciliation
  • Stripe - Pricing & fees (UK) (accurate as of October 2026) https://stripe.com/gb/pricing
  • Adfin - Pricing (accurate as of October 2026) https://www.adfin.com/pricing
Adfin team
Adfin team