QuickBooks Online vs Desktop: Importing Bank Statements

Short answer: for getting bank statements into QuickBooks, Online is the easier choice for most people, and Desktop is fine if you already run it and keep it current. Both need a bank-supported file such as .qbo, .qfx, or .ofx, and neither one reads a raw PDF bank statement. The real difference is the import path: Online lets you upload a file (or CSV) from the Banking screen, while Desktop only accepts .qbo through Web Connect and refuses files aimed at versions more than three years old. A converter that turns your PDF into a .qbo file bridges both, so the version you use matters less than the file you feed it.

How importing bank statements works in QuickBooks Online

QuickBooks Online handles imports from one screen. Go to Transactions, then Bank transactions, click the dropdown next to Link account, and choose Upload from file. From there you pick the file, tell QuickBooks which bank or credit card account it belongs to, and the transactions drop into the For review tab where you categorize and match them.

Online accepts four file types for a manual upload: .qbo, .qfx, .ofx, and .csv. It does not accept PDF. There is also a size ceiling. Each upload is capped at roughly 350 KB, which works out to about 1,000 transaction lines per file, so a busy account or a full year of history usually has to be split into smaller files and uploaded one after another. CSV uploads add a step, since you map the date, description, and amount columns yourself, whereas a .qbo file carries the account identifiers and imports without any mapping.

The step-by-step version, including what to do once transactions hit the review queue, is in our guide to importing a bank statement into QuickBooks Online.

How importing bank statements works in QuickBooks Desktop

QuickBooks Desktop takes a narrower path. The import lives under File > Utilities > Import > Web Connect Files, and it accepts one format for this route: .qbo, the Web Connect file. There is no built-in CSV importer for bank feeds in Desktop the way there is in Online, so if all you have is a spreadsheet you either use a third-party tool or convert it to a supported format first.

Desktop also enforces a version rule that trips people up. Intuit shuts off connected services, including Web Connect imports, on Desktop versions that are about three years old. A 2023 install, for instance, lost bank feeds and related services on May 31, 2026. So a technically valid .qbo file will still be rejected if the copy of QuickBooks Desktop reading it has aged out. Keep Desktop current and the import behaves; let it lapse and you are stuck. Our walkthrough for converting a bank statement for QuickBooks Desktop covers the Web Connect steps in full.

One more piece of context worth knowing before you plan around Desktop: Intuit stopped selling new Pro Plus, Premier Plus, and Mac Plus subscriptions to US buyers in September 2024, and it raised Desktop prices again in February 2026. Existing subscribers can keep renewing, but new customers are steered to QuickBooks Online or Enterprise. Desktop is not dead, yet the direction of travel is clear, and that shapes which version most new bookkeeping setups land on.

QuickBooks Online vs Desktop for bank statements, side by side

So which is better for importing bank statements?

For the majority of small businesses and bookkeepers, QuickBooks Online is the more forgiving tool for getting bank statements in. It takes more file types, adds a CSV path when that is all you have, and never rejects an import because the software aged out. You lose the 350 KB ceiling as a small tax on convenience, and splitting a large history into a few files handles it.

QuickBooks Desktop still earns its place. Firms with heavy job costing, industry-specific Premier or Enterprise editions, or years of muscle memory in the desktop interface have good reasons to stay. If that is you, importing bank statements works cleanly as long as you keep the version inside Intuit's support window and feed it proper .qbo files. The trouble usually starts on an old install, not with the import itself.

Notice what neither version does: read a PDF. QuickBooks has never imported a PDF bank statement in either product, which is where most people get stuck when the bank only offers statements as PDFs or the download window has closed. The fix is the same regardless of which version you run.

The workaround that works in both versions

Turn the statement into a file QuickBooks accepts before you import. Upload your PDF statement in the converter at the top of this page and you get back a .qbo file whose transactions are checked against the opening balance, closing balance, and totals printed on the statement. That same .qbo file imports into Online through Upload from file and into Desktop through Web Connect, so you pick the version, not the file format.

1. Upload the statement at the top of this page. Digital PDFs, scans, phone photos, and password-protected files all work.
2. Review the reconciliation. The extracted transactions are summed and compared against the statement totals, so a misread figure surfaces now rather than at month-end.
3. Download the .qbo file and import it using the steps above for your version.

If a reviewer wants the line items in a grid before anything touches QuickBooks, you can export the same transactions to a spreadsheet and eyeball them there first. The converter here also produces XLSX and CSV copies alongside every .qbo file, so one upload covers the QuickBooks import and the workpaper. Background on the format itself is in our explainer on the .qbo file, and the dedicated tools live at the PDF to QBO converter and the QBO converter.

A note on history and download windows

Both versions will import whatever date range is inside the file you hand them. The limit is not QuickBooks, it is your bank. Most banks only let you export .qbo or .ofx files for recent activity, commonly 90 days to 24 months, and closed accounts often lose the export option entirely. Live bank feeds have the same short reach. Anything older still exists as a PDF statement, and converting those PDFs is the only way to load them into either version without retyping every line. Catch-up bookkeeping, prior-year cleanups, and reconstructing books for a new client all live in that gap.

Frequently asked questions

Can QuickBooks Online import a PDF bank statement?

No. QuickBooks Online accepts .qbo, .qfx, .ofx, and .csv files for a manual upload, but not PDF. To load a PDF statement, convert it to a .qbo file first, then upload that from Transactions, Bank transactions, and the Upload from file option. The converter on this page produces a .qbo file ready for exactly that step.

Does QuickBooks Desktop still support Web Connect imports?

Yes, on supported versions. Desktop imports .qbo files through File, Utilities, Import, Web Connect Files. The catch is Intuit's version rule: it disables connected services, including Web Connect, on Desktop installs about three years old. Keep Desktop current and the import works. An aged-out version will reject even a valid .qbo file.

Is QuickBooks Online better than Desktop for bank statements?

For most users, yes. Online takes more file formats, offers a CSV path, and never blocks an import over software age. Desktop imports cleanly too, but only .qbo through Web Connect and only on versions inside Intuit's support window. If you already run Desktop and keep it updated, either handles statements well.

How far back can you import bank transactions?

As far back as the file allows. QuickBooks imports any dates inside a .qbo, .qfx, .ofx, or CSV file in either version. The real limit is your bank, which usually exports only 90 days to 24 months of activity. For older periods, convert the PDF statements you already have and import those instead.

What file format does QuickBooks need to import a bank statement?

QuickBooks needs a bank data file, not a PDF. Online reads .qbo, .qfx, .ofx, and .csv; Desktop reads .qbo through Web Connect. The .qbo (Web Connect) format is the most reliable because it carries account identifiers and imports without column mapping. Convert your statement to .qbo and it works in both versions.

Convert your first statement and pick your version

The format matters more than the version. Upload a statement at the top of this page, check the reconciliation summary against the paper, and import the resulting .qbo file. The same file works whether you convert bank statements to QuickBooks Online or Desktop, so you can switch versions later without redoing the work.