How to Import Stripe Transactions into QuickBooks

Short answer: The Stripe connector syncs into QuickBooks Online and imports historical transactions from a start date you choose, up to about two years back. Stripe's own exports are CSV reports, plus an IIF file in Legacy Exports that only QuickBooks Desktop reads and that Stripe's documentation says cannot be imported into QuickBooks Online. For anything older than two years, for a closed account, or for a clean Desktop import, convert the Stripe report to a Web Connect .QBO file. Stripe never produces a .QBO of its own.

Stripe is the checkout for a large share of US SaaS companies, agencies, marketplaces, and subscription businesses. It records every charge, fee, refund, and dispute in detail, and then deposits a single batched number that tells your bank almost nothing. Getting that detail into QuickBooks correctly is most of ecommerce and SaaS bookkeeping.

Can you import Stripe transactions into QuickBooks?

Yes, through three routes, and they are not equivalent. The Stripe connector for QuickBooks Online syncs live. Stripe's legacy IIF export works only in QuickBooks Desktop, and only as a journal-style import. And a converted Stripe report produces a Web Connect .QBO file that either version of QuickBooks imports as a proper bank feed, for any period. They differ in how much history they reach and in whether the transactions ever hit the For Review queue.

Route 1: the Stripe connector for QuickBooks Online

Install the app from inside QuickBooks Online, connect your Stripe account, choose the date you want it to start importing from, and sync. From there it keeps charges, fees, refunds, and payouts flowing into your books on its own.

The limit is the start date: it reaches back about two years, no further. That covers most cleanups, which is exactly why the ones it does not cover are so frustrating. A three-year rebuild, or a Stripe account you closed when the business changed shape, is outside what the app will import. The connector is also QuickBooks Online only. There is no Stripe app for QuickBooks Desktop.

Route 2: Stripe's CSV reports and the legacy IIF

From the Stripe Dashboard you can export reports as CSV: payments, payouts, balance changes, and more. The payouts report is the useful one for accounting, because it carries the gross, the fee, and the net together.

Stripe also offers an IIF file, downloadable from Legacy Exports in the Dashboard, containing payments, refunds, fees, and payouts. It is tempting, because IIF is an Intuit format and it looks like it should be the answer. It is not. Stripe's own documentation states directly that you cannot import IIF files into QuickBooks Online, and points users to third-party integrations instead.

Even in QuickBooks Desktop, where an IIF does work, it is not a bank feed. The entries post straight into the register rather than arriving in the For Review queue, which means your bank rules never fire, nothing is matched against transactions you already have, and QuickBooks never runs its duplicate check. It files transactions. It does not import a feed.

Route 3: convert the report to a QBO file

This is the route with no history limit and no version limit. Upload the Stripe payout report, balance report, or statement to the Stripe statement to QBO converter, pick QBO as the output format, and you get a real Web Connect file.

Import it the way you would a bank download:

• QuickBooks Online: Transactions, then Bank transactions, then Upload from file. Select your Stripe clearing account.
• QuickBooks Desktop: File, Utilities, Import, Web Connect Files. Select the Stripe account.

The transactions land in For Review, your rules run, and the duplicate check protects you. This is the same mechanism a bank feed uses, which is the whole point of producing a QBO rather than a journal import.

How far back can Stripe sync to QuickBooks?

About two years. You pick a start date when you set the connector up, and roughly 24 months is the ceiling on historical transactions. Anything older comes in as a file. That is a more generous window than most payment platforms give you, and it is still not enough for a business that has let three years slide, or for one reconstructing books after an acquisition or an audit request.

Does Stripe have a QBO file?

No. Stripe exports its reports as CSV and offers an IIF for QuickBooks Desktop under Legacy Exports. There is no Web Connect option anywhere in the Dashboard. Since QuickBooks Desktop imports bank activity through Web Connect files and QuickBooks Online treats a QBO upload as the cleanest file it accepts, the format QuickBooks most wants is precisely the one Stripe does not make. That is why conversion exists here.

Should Stripe be a bank account in QuickBooks?

Yes, as a clearing account of the bank type. Charges and fees post into it, payouts leave it, and each payout then matches the deposit on your real bank feed as a transfer between two accounts. That structure also makes the Stripe balance mean something, because money customers have paid but Stripe has not yet released sits in the clearing account rather than being invisible until it lands.

Posting the bank deposit straight to sales income instead is the single most common Stripe bookkeeping error. It records the net as revenue, loses the processing fee completely, and leaves you unable to tie any deposit back to the charges behind it.

Why does my Stripe payout not match my sales?

Because Stripe nets everything out before it pays. A payout is gross charges, minus the per-transaction processing fee, minus refunds issued in that window, minus disputes and dispute fees. Ten thousand dollars of charges might deposit around 9,660. If you book the deposit as revenue, income is understated by the fee and the processing cost never appears on the profit and loss, which quietly distorts margin all year.

Import the payout detail instead of the deposit, and the arithmetic resolves itself: the gross posts to income, the fee posts to merchant fees, and the net matches the bank. The full worked version is in why ecommerce sales never match the bank deposit.

How do I record Stripe fees in QuickBooks?

Book the charge at gross and the Stripe fee as a separate merchant fee expense. Do not post the net. The gross belongs in income, the fee belongs in an expense account, and the difference is what shows up in the bank. A converted report keeps the charge and the fee on separate lines, which is most of the reason to convert rather than retype a spreadsheet.

Subscriptions, prorations, and failed payments

Stripe's subscription billing produces transaction types a bank statement never has: prorations when a customer upgrades mid-cycle, retries after a failed payment, and credits that reduce the next invoice rather than refunding the last one. All of them affect the payout. If your books only ever see the deposit, none of these events exist, and revenue recognition on a SaaS business quietly becomes fiction. Importing the charge-level detail is what keeps monthly recurring revenue tied to something real.

Avoiding duplicates when you backfill

Duplicates appear when a live sync and a converted file overlap. Load history behind the sync, never on top of it. Open the Stripe clearing account register, find the oldest transaction the connector brought in, and end your converted file the day before that date.

Check the row count too. A QuickBooks Online file upload caps at 1,000 transactions, and a year of charges on a busy Stripe account clears that easily, so split the period into monthly files. The specifics are in how many transactions you can import into QuickBooks at once.

A practical order of operations

For an account with more than two years of untouched books: set up the Stripe clearing account, connect the app so the current period keeps itself current, then work backwards with converted payout reports month by month. Reconcile each month against the Stripe payout report as you go, rather than saving the reconciliation for the end and discovering in April that February never balanced.

If the expense side of the cleanup is just as far behind, it is usually worth extracting the data from the supporting documents in bulk at the same time, since contracts, bills, and vendor statements are where the second half of a catch-up disappears.

The short version

The Stripe connector handles the current period and about two years behind it, in QuickBooks Online only. Stripe's IIF is a Desktop-only relic that Online cannot open and that skips the review queue even where it works. Stripe has no QBO. So for older periods, closed accounts, and Desktop shops, converting the report to a Web Connect file is the route that actually reaches. Set Stripe up as a clearing account, import the charge and fee detail rather than the deposit, and the payout will finally match the bank.