Bank statement to QuickBooks
“QuickBooks” is two different programs that take two different files. Upload your statement, keep QuickBooks Online as the output, and the .qbo file imports through the bank feed; the section below covers what to do on Desktop.
Upload a file
What you get for QuickBooks
- QuickBooks Online: a .qbo file for the bank-feed import
- One transaction per line, in the order the statement prints them
- Debits and credits on the side the statement shows them
- QuickBooks Desktop is not served by this file — see below
QuickBooks Online vs QuickBooks Desktop
QuickBooks Online imports a .qbo file through its bank feed. That is what this page produces, and it is the file most people are looking for.
QuickBooks Desktop is a separate program and reads a separate format (IIF) or a bank-specific import. A .qbo file is refused by Desktop, so on Desktop convert to CSV or Excel and import that instead.
If your bank gave you a CSV export rather than a PDF, the CSV to QBO converter turns it into the .qbo QuickBooks Online imports, with no columns to map. The upload steps are in the QuickBooks import guide.
How to convert
Upload your statement
Drop in the PDF you downloaded from your bank, or a scan of a paper statement.
Check which QuickBooks you have
Online takes the .qbo file below; Desktop needs CSV or Excel.
Import the file
Bring the .qbo in through the bank feed in QuickBooks Online.
Statements it handles
Layouts differ from bank to bank, so nothing is matched against a fixed template. An unusual statement still produces a table you can check before exporting — which is what makes it usable for bookkeepers and accountants who receive statements from every client.
PDF statements and CSV exports
A statement downloaded from your bank, or the CSV your bank lets you export. Both arrive as the same clean table.
Multi-page statements, read as one table
A statement that runs over several pages — or several statements uploaded together — is read as one continuous table, not one file per page.
Amounts and dates kept as your bank prints them
Debit and credit signs, decimal places and date formats are left as printed, so the numbers still reconcile against the statement.
Scanned, image-only PDFs, read with OCR
A statement with no text layer is read with OCR and may need a quick review — the one case where a row can come out wrong.
- CSV
- Scan
Rows are read by what they are — a date, a description, an amount — not by where they sit on the page, so a wrapped description stays with its transaction and a closing balance never becomes one. Why OCR mangles bank statements
Frequently asked questions
Does this work with QuickBooks Online or QuickBooks Desktop?
QuickBooks Online: yes, the .qbo file is what its bank feed imports. QuickBooks Desktop: no — Desktop reads IIF or a bank-specific format, so convert to CSV or Excel for it.
What is the difference between the two QuickBooks?
They are separate products with separate import formats. Online runs in a browser and imports .qbo; Desktop is installed locally and imports IIF.
Can I convert a PDF bank statement for QuickBooks?
Yes. The input is a statement PDF or scan either way; only the output file differs.
Will my accounts be matched automatically?
No. The file carries the transactions; which account they land in is a decision you make during the import.
Is my statement kept after conversion?
No. The file is deleted when the conversion finishes; only the converted copy stays at your private link.
Do I need an account?
No. The converter works without signing up.