How to Import Bank Statements into QuickBooks (Online & Desktop, 2026)

If your bank feed is down, your bank doesn't connect to QuickBooks, or you're catching up on a year of statements at tax time, you'll need to import manually. Here's the workflow that actually works in 2026 — for QuickBooks Online, QuickBooks Desktop, and QuickBooks Self-Employed.

The short version

QuickBooks accepts three formats for manual imports:

CSV — universal, stable, the safest option. Use this 95% of the time.
QBO (Web Connect) — QuickBooks' own format. Banks publish them; tokens expire every 30–90 days.
OFX / QFX — older standard, increasingly deprecated by U.S. banks.

QuickBooks does not accept PDF directly. If you only have a PDF, convert it to CSV first — that's a 30-second job in the PDF to CSV converter or the dedicated PDF to QBO tool.

QuickBooks Online — step by step

1. Open QuickBooks Online and go to Banking (or Transactions → Bank transactions in newer versions). 2. Click Link account → Upload from file. 3. Pick the CSV file. 4. Map the columns — Date, Description, Amount (or Date, Description, Credit, Debit for the 4-column shape). 5. Choose the account to import into. Pick carefully — there is no undo. 6. Review the preview and click Import.

QuickBooks Online accepts up to 1,000 transactions per file. If your CSV is longer, split it with the CSV cleaner or import month by month.

QuickBooks Desktop — step by step

QuickBooks Desktop is fussier and has changed across versions.

For QBO / Web Connect files: 1. File → Utilities → Import → Web Connect Files 2. Pick the .qbo file 3. Choose the QuickBooks account to import into

For CSV files (the most common path in 2026): - Desktop 2019 and newer: use the Bank Feeds Center → Banking → Bank Feeds → Import Web Connect File. Some versions let you upload CSV directly; others need a free third-party mapping tool like CSV2QBO. - Desktop older than 2019: there is no native CSV import. Convert your CSV to QBO with a mapping utility, then import as Web Connect.

The cleanest workflow for Desktop in 2026: PDF → CSV → QBO mapping tool → Web Connect import. The CSV in the middle is the universal pivot — every step before and after assumes a clean, header-correct CSV.

QuickBooks Self-Employed

QuickBooks Self-Employed has the simplest import:

Transactions → Add transactions → Import.
Pick the CSV.
Map the columns and confirm.

Self-Employed only accepts CSV — no QBO, no OFX. The converter's default export shape works out of the box.

The CSV format QuickBooks actually expects

3-column (simplest, works everywhere):

Date,Description,Amount
06/03/2026,Whole Foods,-87.42
06/03/2026,Stripe payout,2410.00
06/04/2026,AWS,-312.55

4-column (separate credit and debit):

Date,Description,Credit,Debit
06/03/2026,Whole Foods,,87.42
06/03/2026,Stripe payout,2410.00,
06/04/2026,AWS,,312.55

Both work. Pick whichever your accountant or template prefers.

The four gotchas that waste an afternoon

1. Wrong date format. QuickBooks U.S. wants MM/DD/YYYY. U.K. / EU instances want DD/MM/YYYY. Set the locale in QuickBooks before importing. 2. Missing headers. QuickBooks silently rejects header-less CSVs. Always keep row 1 as the column names. 3. Duplicates. If part of the month is already in QuickBooks, the import will dupe. Use the merger tool to dedupe across overlapping CSVs first. 4. Wrong account. QuickBooks imports into whichever account you pick at upload. There is no undo — only delete-and-reimport.

Why CSV beats QBO for almost everyone

QBO files (Web Connect) auto-match payees, which sounds great. But:

The token embedded in the QBO file expires every 30–90 days. After that, QuickBooks rejects it.
Banks change their QBO export format without warning, breaking historical files.
You can't open a QBO file in Excel to fix a single bad row. With CSV you can.

CSV is the format that still works in five years. QBO is the format that breaks before your next quarterly close.

Converting PDF statements before importing

The fastest path for PDF-only banks (Chase historical, HSBC older than 90 days, Barclays, Monzo, Starling, Revolut, etc.):

Download the statement PDF from your bank portal.
Drop it into the bank statement to CSV converter — parses in your browser, nothing uploaded.
Download the CSV in the 3-column QuickBooks shape.
Import into QuickBooks using the steps above.

Total time per statement: under a minute. Per-bank step-by-step guides live in the bank directory.

Ready to import?

The free PDF to QBO converter exports the exact CSV shape QuickBooks accepts. Drop the PDF, download the CSV, import. Done.