Skip to content

How-to guide

How to convert bank statements to QuickBooks

Updated June 27, 2026 · 6 min read

QuickBooks imports transactions best when they arrive in a clean, structured file. Bank statement PDFs are the opposite — they're built for people to read, not for software to parse. This guide covers the three reliable ways to get a statement into QuickBooks and which to pick.

Option 1: Import a QBO (Web Connect) file

QBO is QuickBooks' native bank-import format. If you can produce a QBO file from your statement, QuickBooks recognizes the account and matches transactions automatically — no column mapping.

Convert your statement PDF (or an existing OFX/CSV export) to QBO, then in QuickBooks go to Banking → Upload from file and select the QBO. One catch: QBO files carry a bank ID (INTU.BID) that QuickBooks uses to recognize the institution. If the import warns about an unknown bank, set your bank's INTU.BID before exporting.

Option 2: Import a CSV

Every QuickBooks plan accepts a 3- or 4-column CSV (Date, Description, Amount — or Date, Description, Credit, Debit). This is the most universal route and avoids the INTU.BID issue entirely.

Export your statement to a QuickBooks-formatted CSV, then upload it under Banking → Upload from file and map the columns when prompted. Review the transactions before you accept them.

Option 3: Manual entry (only for a handful of lines)

If you have just a few transactions, manual entry is fine. For anything more than a page, converting the statement is faster and far less error-prone.

Recommended workflow

Upload the statement PDF, let it extract every transaction, then review the table — check dates, amounts, and that the running balance reconciles. Export to QBO if you want automatic account matching, or CSV if you want the simplest path. Either way, reviewing before import is what keeps your books clean.

Ready to convert a statement?

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

Convert a statement
Does QuickBooks accept PDF bank statements directly?

No. QuickBooks imports QBO, CSV, or QFX files — not PDFs. You convert the PDF to one of those formats first.

What is INTU.BID and do I need it?

INTU.BID is the Intuit bank identifier inside a QBO/QFX file. QuickBooks uses it to recognize your bank. If you import a QBO and get an 'unsupported bank' warning, set your bank's INTU.BID before exporting. CSV imports don't need it.

QBO or CSV — which should I use?

QBO if you want QuickBooks to auto-match the account and avoid column mapping; CSV if you want the simplest, most universal import that works on every plan.

Related

Convert a bank statement to QuickBooksOFX → QBO converterOFX vs QFX vs QBO explained