How to convert a PDF bank statement to QBO/OFX
QuickBooks can't import a PDF statement directly — you need the transactions in a structured file. Here's the manual route, and where it goes wrong.
The manual route
- Extract the transactions. Copy the date / description / amount rows out of the PDF into a spreadsheet. For text-based PDFs this is copy-paste; for scanned/image PDFs you'll need OCR, which introduces errors.
- Clean the data. Remove headers, page breaks, running balances and summary lines. Normalise dates and put amounts in one signed column.
- Save as CSV and either import the CSV into QuickBooks Online, or convert it to a
.qbo/OFX file for a cleaner import.
Why bother with QBO/OFX instead of CSV? Structured formats carry the transaction type, date and amount explicitly, so QuickBooks doesn't have to guess — fewer date/sign errors, and it handles multi-page statements better.
Where the manual method breaks down
- Scanned PDFs need OCR, and OCR misreads digits — every wrong amount is a reconciliation headache later.
- Multi-column or multi-account statements don't copy-paste cleanly.
- Once you have a CSV, you can still hit the INTU.BID “bank not authorized” error at the final import step.
PDF in, QuickBooks-ready file out
This is exactly what we're building: upload a PDF or CSV statement, get a QBO/OFX file designed to import into QuickBooks the first time. Private beta — join the list.
Join the early-access list →