Connect Stripe to QuickBooks Online: A Complete Guide

Last verified: June 2026

Stripe powers payments for a huge slice of e-commerce. It's fast, developer-friendly, and globally accepted. But connecting it cleanly to QuickBooks Online? That's where things get messy.

The problem is structural. Stripe deposits a net amount into your bank — gross revenue minus processing fees, refunds, and any other deductions — and that single lump-sum deposit needs to reconcile to a pile of individual transactions in QuickBooks. Get that wrong and your P&L is fiction.

The good news: there's a clear path forward. Multiple paths, actually, each suited to different volumes and team sizes. Whether you're processing a handful of Stripe payments a week or running a high-volume store where Stripe, Shopify Payments, and Amazon settlements all need to land cleanly in the same ledger (if so, see our guide on connecting Amazon Seller Central to QuickBooks), there's a method here that fits.

This guide covers every method: the native connector, a third-party connector tool, the manual CSV route, and the managed option via Ceendesis Accounting. We'll walk through each step by step, flag the common failure points, and tell you plainly which method to pick for your situation.

Before you start

• Active Stripe account
• Active QuickBooks Online account

Methods at a glance

Method 1: Native app — Stripe Connector by QuickBooks

The Stripe Connector by QuickBooks is a direct integration built by Intuit that pulls Stripe transactions into QuickBooks automatically. It's free for QuickBooks Online customers and takes about 20 minutes to configure.

That said, it has real limitations. It doesn't separate Stripe fees from gross sales, doesn't handle refunds cleanly, and doesn't generate the journal entries you'd need to reconcile net payouts to individual transactions. For a store doing a few dozen transactions a month with straightforward pricing, it's fine. For anything more complex, you'll feel those gaps quickly.

1. Open the QuickBooks App Store and search for "Stripe Connector by QuickBooks". Click Get app now.
   Expected result: You're redirected to an authorisation screen.
2. Authorise your QuickBooks Online account by signing in when prompted.
   Expected result: The app confirms it's connected to your QBO company file.
3. Connect your Stripe account by clicking Connect with Stripe and completing the OAuth flow in Stripe's interface.
   Expected result: The connector shows your Stripe account as linked. If you have multiple Stripe accounts, confirm you've selected the right one.
4. Set your sync start date — choose the date from which you want transactions imported. Don't set this earlier than your QuickBooks start date or you'll create duplicate entries for any period you've already manually reconciled.
   Expected result: The connector displays a confirmation of your chosen date range.
5. Map your Stripe income to a QuickBooks income account in the settings panel. If you haven't already, create a dedicated Stripe Fees expense account in QuickBooks (Chart of Accounts → New → Expense). Mapping fees to a dedicated account is critical for accurate P&L reporting.
   Expected result: Income and fee categories are mapped; the connector is ready to sync.
6. Run the initial sync by clicking Sync now.
   Expected result: Stripe transactions appear in your QuickBooks Banking tab under the connected account, ready for review and matching.

Method 2: Connector tool (third-party)

As transaction volume grows or your accounting setup gets more sophisticated — multiple currencies, subscription billing, high refund rates — the native connector starts to creak.

Third-party connector tools are built specifically for these scenarios. They typically implement the clearing account pattern automatically: gross revenue posts to your income account, processing fees post to a dedicated expense account, and the net payout matches to your bank feed. That structure is the accepted best practice for accurate Stripe reconciliation. These tools require a paid subscription, though free tiers are sometimes available for low volumes. Check the vendor's current pricing before committing — don't rely on anything quoted here.

1. Choose your connector tool and create an account. Look for one that explicitly supports a clearing account / journal entry model for Stripe payouts, handles refunds as separate line items, and lets you set your own timezone to avoid UTC mismatches.
   Expected result: You have an active account with your chosen tool.
2. Connect your Stripe account inside the tool using the OAuth flow it provides. Grant read access to transactions, payouts, and fees.
   Expected result: The tool shows your Stripe account status as connected and begins retrieving historical data.
3. Connect your QuickBooks Online account via the tool's QBO integration. Authorise it to create transactions in your company file.
   Expected result: Both platforms show as connected in the tool's dashboard.
4. Configure your account mapping: assign Stripe gross sales to an income account, Stripe fees to your dedicated expense account, and refunds to either a contra-revenue or separate expense account depending on your accountant's preference. Set a Stripe clearing account as the intermediary.
   Expected result: The mapping screen shows all transaction types assigned to specific QuickBooks accounts.
5. Set your timezone in the tool's settings to match QuickBooks' local time setting. Stripe exports use UTC by default; if your QBO company is set to US Eastern or UK time, a mismatch here will scatter transactions across the wrong accounting periods.
   Expected result: Transaction dates in the tool preview match the dates you'd expect in QuickBooks.
6. Run a test sync for a short historical period (one week works well). Review the resulting transactions in QuickBooks and confirm that gross revenue, fees, and net payouts all appear as separate line items.
   Expected result: Your clearing account shows a zero or near-zero balance after the payout matches the bank feed — that's the sign everything's working correctly.
7. Enable automatic syncing and set the sync frequency. Daily is sufficient for most stores; hourly is available in most paid tiers if you need near real-time visibility.
   Expected result: The tool runs on schedule without manual intervention.

Method 3: Manual export/import (CSV)

This is the no-tools option. It works, but it doesn't scale — each reconciliation period means repeating the full process from scratch. If you're doing a one-off historical catch-up, clearing a backlog before switching to an automated method, or genuinely processing fewer than a couple of dozen transactions a month, manual CSV is viable. For anything busier, the time cost adds up fast.

1. Log in to your Stripe Dashboard and go to Payments → All transactions. Click Export and select the date range you want to reconcile. Choose CSV format and include the columns for amount, fee, net, and payout date.
   Expected result: A CSV file downloads to your machine.
2. Open the CSV and review it before importing. Check that the date format is consistent and note that Stripe timestamps are in UTC — if your QuickBooks company uses a different timezone, adjust the dates in the file before importing to avoid posting transactions to the wrong period.
   Expected result: Your CSV has clean, consistent dates and no formatting anomalies.
3. Log in to QuickBooks Online and go to Banking → Upload transactions. Select your Stripe clearing account (create one first if it doesn't exist — Chart of Accounts → New → Bank account, name it "Stripe Clearing").
   Expected result: QBO's import wizard loads.
4. Map the CSV columns to QBO fields: Date, Description, Amount. QuickBooks will ask you to confirm which column maps to which field.
   Expected result: The preview shows transactions correctly formatted before you confirm the import.
5. Complete the import and go to the Banking tab. Match the imported Stripe transactions to your actual bank deposits. For each Stripe payout, create a journal entry that debits the Stripe clearing account and credits your bank account for the net payout amount.
   Expected result: The clearing account balance returns to zero; the bank account reflects the correct net deposit.
6. Record Stripe fees separately by creating expense transactions from the fee column in your CSV, posted to your Stripe Fees expense account.
   Expected result: Your P&L shows processing fees as a distinct line item, not hidden inside revenue.

Method 4: Ceendesis Accounting

Ceendesis Accounting is the managed option — the reconciliation setup, ongoing syncing, and account mapping are all handled for you. It's particularly useful when Stripe isn't your only payout channel: Ceendesis reconciles Amazon, Shopify, Walmart, and eBay settlements into QuickBooks and Xero alongside Stripe, with per-channel COGS tracking and a full settlement flat-file parser for Amazon's SP-API.

Worth knowing upfront: Ceendesis currently supports QuickBooks and Xero — no Sage integration yet. If you're on Sage, Methods 1–3 are your routes.

1. Contact the Ceendesis team at ceendesis.com/accounting to start onboarding. You'll be asked about your channel mix, transaction volumes, and current QuickBooks setup.
   Expected result: You receive a scoping confirmation and onboarding timeline.
2. Grant Stripe API access by providing a restricted API key with read permissions for charges, payouts, and refunds. Ceendesis will specify the exact permission set needed.
   Expected result: Ceendesis confirms Stripe data is accessible and the historical import scope is agreed.
3. Connect your QuickBooks Online account via the OAuth flow Ceendesis provides during onboarding.
   Expected result: Both connections are confirmed active in your Ceendesis dashboard.
4. Review the proposed account mapping — Ceendesis will present a draft mapping for gross revenue, processing fees, refunds, and net payouts against your existing QuickBooks chart of accounts. Approve or adjust in consultation with your accountant.
   Expected result: The agreed mapping is locked in; the clearing account structure is configured.
5. Approve the initial historical sync for your chosen backfill period. Ceendesis runs this and flags any anomalies for your review before finalising.
   Expected result: Historical Stripe transactions appear in QuickBooks correctly categorised; clearing account balances to zero.
6. Go live on automated syncing — from this point, Stripe payouts sync to QuickBooks on a regular cadence without manual input.
   Expected result: Your QuickBooks bank feed stays current; fees, refunds, and gross revenue reconcile to net payouts automatically.

Common errors and how to fix them

Net deposit doesn't match gross revenue in QuickBooks

This is the classic Stripe accounting problem. Stripe deposits a net amount — gross revenue minus fees and refunds — but your bank feed shows that net figure, not the original sale amounts. The fix is the clearing account pattern: post gross sales to your income account, fees to an expense account, and use the clearing account as the intermediary that settles to zero when the payout hits your bank. If you set this up correctly, the maths works out. If you skipped it and recorded the net deposit directly as revenue, your income is understated by every fee you've ever paid.

Transactions posting to the wrong date

Stripe exports use UTC timestamps. If your QuickBooks company is set to US Eastern or Pacific time, a Stripe transaction processed at 11pm ET will appear in Stripe's export as the following day. Multiply that across a month-end and you've got transactions bleeding between accounting periods. Fix this by adjusting your export timezone in Stripe's dashboard settings before pulling reports, or configure your connector tool's timezone setting to match QuickBooks' local time.

Lump-sum payout won't match individual transactions

Stripe bundles multiple transactions into a single payout — sometimes covering several days of sales. Trying to match that one deposit to one invoice in QuickBooks won't work; it'll never balance. The correct approach is to match the payout to the clearing account balance, not to individual transactions. Each transaction posts to the clearing account on its sale date; the payout sweeps the clearing account to zero when it lands in your bank. If you're using the native connector and it's not creating clearing account entries, you'll need to manage this step manually or switch to a connector tool that handles it automatically.

Duplicate or garbled transactions from a connector tool

Some connector tools import transactions in formats that QBO doesn't handle cleanly — creating duplicates, splitting single transactions into multiple line items, or importing metadata fields as transaction descriptions. Before enabling automatic syncing with any third-party tool, always run a test sync against a small historical window and review every imported transaction in QuickBooks. If you see duplicates, check whether the tool and the native connector are both active — running two integrations simultaneously is a common cause.

Frequently asked questions

How do I sync Stripe with QuickBooks Online?

The quickest route is the Stripe Connector by QuickBooks, available free from the QuickBooks App Store. Install it, authorise both accounts via OAuth, set your sync start date, and map your income and fee accounts. For higher volumes or more complex reconciliation, a third-party connector tool or a managed service like Ceendesis Accounting gives you better fee separation and payout matching.

Does Stripe integrate directly with QuickBooks Online?

Yes — Intuit built and maintains a native Stripe connector that connects directly to QuickBooks Online. It's free for QBO customers. The direct integration covers basic transaction syncing but has known limitations around fee separation, refund handling, and high-volume reconciliation.

How do I account for Stripe fees in QuickBooks Online?

Create a dedicated expense account in QuickBooks (Chart of Accounts → New → Expense, name it "Stripe Processing Fees" or similar). Then map all Stripe fee transactions to that account — either through your connector tool's settings or manually when importing CSVs. Keeping fees in their own account means your P&L shows the true cost of payment processing as a distinct line item, not buried in revenue.

How do I reconcile Stripe payouts in QuickBooks?

Use a Stripe clearing account as an intermediary. Gross sales post to your income account and debit the clearing account on the transaction date; when the payout hits your bank, it credits the clearing account for the net amount and debits your bank account. The clearing account should net to zero after each payout cycle. This approach — sometimes called the clearing account method — is the accepted best practice for accurate Stripe reconciliation and handles the gross vs. net mismatch that causes most errors. For more on reconciling marketplace payouts, our guide on reconciling Shopify payouts in Xero covers the same pattern applied to a different channel.

Which method should you pick?

Here's the honest summary.

If you're a low-volume store — say, under a hundred Stripe transactions a month — the free native connector is a reasonable starting point. Understand its limitations going in (no clean fee separation, no clearing account entries) and supplement with manual journal entries if needed.

If your volume is higher, your pricing is complex, or you're dealing with subscriptions and frequent refunds, a third-party connector tool that implements the clearing account pattern automatically will save you hours of monthly reconciliation work.

Manual CSV import is only worth it for historical catch-up work or very occasional use. The ongoing time cost is real — don't let it become a monthly ritual.

And if Stripe is one of several payout channels you're managing — alongside Amazon settlements, Shopify payouts, or others — Ceendesis Accounting handles all of them in one place, reconciling into QuickBooks or Xero without requiring you to run separate integrations per channel. That's where the managed approach earns its keep. For a broader view of how payment and operations tools fit together, our cross-border stack for US e-commerce is worth a read too.