QuickBooks Online vs Desktop for Bank Imports

Convert a PDF bank statement to a QuickBooks file

Drop in a PDF statement and get a QBO (Web Connect) or IIF file you can import into QuickBooks Online or Desktop.

Short answer

QuickBooks Online can read a PDF statement directly with its built-in AI upload. QuickBooks Desktop cannot, so on Desktop you convert the PDF to a QBO (Web Connect) or IIF file first, then import that file. Online leans on live bank feeds and the AI upload; Desktop leans on Web Connect and IIF imports. Pick based on which version you run and how much you want to review before transactions post.

If you keep your books in QuickBooks, getting a month of bank transactions in should be the easy part. It usually is not, because QuickBooks Online and QuickBooks Desktop handle bank imports in genuinely different ways. What works in one does not exist in the other. This guide walks through how each version brings in a statement, what the PDF options are, and which file format you need, so you stop fighting the import and get back to the books.

QuickBooks Online vs Desktop: how bank imports differ

The headline difference is the PDF reader. In 2024 Intuit added an AI upload to QuickBooks Online that reads a PDF or image statement and posts the transactions for you, though that upload often fails on larger statements. QuickBooks Desktop, including Pro, Premier, Enterprise, and Accountant, has no equivalent. Everything else follows from that one gap: Online users have three ways to get a statement in, while Desktop users have two, and both Desktop routes start with converting the PDF.

Bank import method QuickBooks Online QuickBooks Desktop
Live bank feedYesYes, Bank Feeds
AI PDF or image uploadYesNo
QBO (Web Connect) file importYes, upload from fileYes, Web Connect import
IIF file importNoYes
Review lines before they postFeed and file: yes; AI upload: noYes

QuickBooks features change often. Confirm current behavior on Intuit's own help pages. Last checked June 2026.

Can QuickBooks Online import a PDF bank statement?

Yes. QuickBooks Online can read a PDF or image statement directly through its AI upload, then post the transactions to the matching account. It is the fastest option when it fits, but it has limits worth knowing: each file is capped at 1,000 transactions and roughly 350 KB, and the transactions post without a review step. For a heavy account, several months of catch up, or a statement you want to check first, converting the PDF to a QBO file and uploading that gives you the same result with a chance to review every line. Our PDF bank statement to QuickBooks converter handles that path for Online, and the steps to import the QBO file are the same on either version.

Can QuickBooks Desktop import a PDF bank statement?

Not directly. QuickBooks Desktop cannot open a PDF and pull out the transactions, and the AI upload that does is Online only. To get a PDF statement into Desktop, you first convert it to a QBO (Web Connect) or IIF file, then import that file through the File menu. It is one extra step, but it comes with a built-in benefit: you review the transactions before they reach the register. The full walkthrough is on our PDF bank statement to QuickBooks Desktop page, including how to handle an account that still has a live feed attached.

QBO file or IIF file: which format for each version?

The format you need depends on the version and the import route. In QuickBooks Online, you use a QBO (Web Connect) file through the upload from file option; Online does not read IIF for bank transactions. In QuickBooks Desktop, you have a choice. A QBO Web Connect file flows through the Bank Feeds center, so QuickBooks matches transactions and applies your renaming rules. An IIF file posts straight to the register without that matching step, which helps when an account is not set up for bank feeds. We break the formats down in detail in QBO vs IIF: which QuickBooks import file do you need, and you can produce either with the PDF to IIF converter.

Which QuickBooks version is better for bank imports?

Neither is strictly better; they suit different situations. QuickBooks Online wins on speed and convenience when accounts have reliable live feeds and you are comfortable with the AI upload posting transactions for you. QuickBooks Desktop wins when you want to review everything before it posts, when you manage many client files, or when an account has no working feed. Many accountants run both across their clients. The practical takeaway: do not switch versions to fix an import problem. Whatever version you are on, a converted QBO or IIF file gives you a reliable way to bring a statement in.

What about the bank feed in each version?

Both versions support a live bank feed, and both share the same weaknesses. Feeds usually reach back only about 90 days, so they cannot help with older periods. They also drop without warning, often after a bank changes its login or security, and then stop pulling new transactions until someone reconnects them. When that happens in either version, the PDF statement is the complete record, and converting it keeps your books current while the feed is down. For accounts you only need in a spreadsheet rather than in QuickBooks at all, you can convert the same statement to Excel or CSV with a bank statement to Excel converter instead.

Beyond bank statements: the rest of the books

Bank transactions are only part of monthly bookkeeping. The vendor invoices behind those payments often arrive as PDFs too, and pulling their line items into a spreadsheet is its own chore; an invoice to Excel extractor handles that the way a statement converter handles bank lines. Teams that process a high volume of vendor bills, rather than a handful, usually move that work off spreadsheets entirely with accounts payable automation. Both sit naturally alongside whichever QuickBooks version you use for the bank side.

The bottom line

QuickBooks Online can read a PDF statement on its own; QuickBooks Desktop needs the PDF converted to a QBO or IIF file first. Online runs on feeds and the AI upload, Desktop on Web Connect and IIF imports, and both still rely on bank feeds that age out at 90 days and break often. Whichever version you run, a converted file is the dependable fallback. Upload a statement with the converter at the top of this page and you will have an import ready file in about a minute, with every line in front of you before it touches your books.

Z tej samej rodziny narzędzi