Skip to content

How-to guide

How to import bank statements into QuickBooks Online

Updated June 28, 2026 · 6 min read

QuickBooks Online connects to most banks directly, but that feed usually only reaches back 90 days. To bring in older history — or any statement the feed won't fetch — you import a file. QuickBooks accepts QBO (Web Connect) and CSV, not PDF, so the job is producing one of those and uploading it correctly.

Step 1: Produce a QBO or CSV file

If your bank offers a Web Connect (.qbo) download for the date range you need, use it. Otherwise convert your statement PDF to QBO or CSV with a converter, reviewing the transactions first so nothing is misread before it ever reaches your books.

QBO gets QuickBooks to recognize the account and match automatically; CSV is the simplest, most universal route and works on every plan. If you're unsure, start with CSV.

Step 2: Upload it in QuickBooks Online

Go to Transactions → Bank transactions (older accounts show this as Banking). Select the account, then choose Link account → Upload from file (or the Upload icon). Pick your QBO or CSV file.

For CSV, QuickBooks asks you to map columns — tell it which columns are Date, Description, and Amount (or separate Credit/Debit). Match the date format to your file (e.g. MM/DD/YYYY) so dates don't shift.

Step 3: Review and accept

Imported rows land in the For review tab — they are not in your books yet. Categorize each, confirm QuickBooks' suggested matches, then Add or Match. Nothing posts to your ledger until you accept it, so this is your last checkpoint.

Common errors and fixes

"This bank isn't supported" on a QBO import: the file's INTU.BID (the Intuit bank identifier) is missing or unrecognized. Set your bank's INTU.BID before exporting, or fall back to CSV, which doesn't use it.

Duplicate transactions: usually the imported range overlaps the live bank feed. Narrow the date range of your file to the gap you actually need.

Amounts with the wrong sign: confirm your file uses a single signed Amount column, or correctly separated Credit and Debit columns — mixing the two conventions flips deposits and withdrawals.

Ready to convert a statement?

Upload a PDF, review every row, and export in seconds.

Convert a statement
Can I import a PDF bank statement directly into QuickBooks Online?

No. QuickBooks Online imports QBO (Web Connect) and CSV files only. Convert the PDF to one of those first, then upload it under Transactions → Bank transactions → Upload from file.

How far back can I import transactions?

There's no hard limit on file imports — you can bring in years of history via QBO or CSV. The live bank feed is what's typically capped at around 90 days, which is why older history needs a file.

QBO or CSV for QuickBooks Online?

QBO if you want QuickBooks to recognize the account and auto-match transactions; CSV if you want the simplest import that works on every plan and avoids the INTU.BID bank-recognition issue.

Related

Convert a bank statement to QuickBooksOFX → QBO converterWhat is a QBO file?