Convert a Bank Statement to QBO
Convert a bank statement into a QuickBooks .qbo file. CSV and Excel statements work today, PDF is coming. Private: your statement stays in the browser.
Coming soon: Bank statement to QBO
Reading that format is still being built. The converter below already turns CSV and Excel statements into a QuickBooks .qbo file, which covers most of the same work.
Drop a CSV or Excel statement here
.csv, .txt, .xlsx and .xls — or choose a file
Your file never leaves your browser.
About Bank statement to QBO
Some accounts simply will not give you a download. Old accounts, closed accounts, foreign banks, business accounts where the online banking login belongs to someone who left the company — sooner or later a bookkeeper is handed a statement and told to get it into the books. Retyping is not a plan: a year of a busy checking account is a thousand lines and every one is a chance to fat-finger a decimal point.
Converting a bank statement to QBO builds the Web Connect file the bank never offered. Each line of the statement becomes a transaction with a date, a description, a signed amount and a stable id, wrapped in the OFX structure QuickBooks Online expects, with the right statement block for the account type. The result imports through the same Upload from file screen as a real bank download, and lands in the same review queue where you can categorise and match it.
Statements exported as CSV or Excel work today — that is the format most online banking sites offer behind the Download button, even when the Web Connect option is missing. PDF statements are the next piece: text-based PDFs will be read in the browser with pdf.js, with no page ever sent to a server, because a statement is exactly the kind of document you should not be posting to a stranger's API.
The converter is free, has no row limit, and highlights duplicate lines before you import rather than after.
How to convert Bank statement to QBO
- Export the statement from online banking as CSV or Excel. If you only have a PDF, keep it — PDF reading is coming.
- Drop the file into the converter. It is read locally; no upload happens.
- Let the converter detect your bank, or map the date, description and amount columns yourself.
- Choose the account type and check the preview: date range, totals, and any duplicate rows.
- Download the .qbo file, then in QuickBooks Online go to Transactions and use Upload from file.
Frequently asked questions
- Can you convert a PDF bank statement to QBO?
- Not yet. Text-based PDF statements are the next format being added, and they will be parsed in the browser like everything else. For now, export the same period as CSV or Excel.
- My bank only offers a PDF. What are my options?
- Most online banking sites hide a CSV or Excel export behind a date-range picker on the transactions screen rather than on the statements screen. That export is the one to use.
- How far back can I import?
- As far back as your statement goes. QuickBooks Online's 90-day limit applies to live bank feeds, not to files you upload yourself.
- What if my bank is not one of the built-in presets?
- Map the columns once in the mapper. Any layout with a date, a description and an amount — or separate debit and credit columns — converts fine.
- Will scanned or photographed statements work?
- Those need OCR, which is planned as a paid feature. A scan of a statement is an image, so there is no text to read until it has been recognised.
- Does the statement leave my computer?
- No. The file is read and converted by your browser; nothing is uploaded or stored.