How to Convert a PDF Bank Statement to QBO
You can't drop a PDF straight into QuickBooks, but you can drop it into QBO Maker. For text-based (digital) PDF statements, the converter extracts the transactions right in your browser (this is a beta feature) and builds a .QBO. Only scanned or photographed statements need an extra CSV step, because an image has no text to read.
Two kinds of PDF: text vs scanned
Whether you need one step or two comes down to what kind of PDF you have:
- Text-based (digital) PDF. Downloaded straight from online banking. You can select and copy the text. QBO Maker reads these directly: drop it in, review the rows, download your
.QBO. - Scanned or photographed PDF. An image of a statement (no selectable text). There is nothing for the parser to read, so you extract it to a CSV first (or use an OCR tool), then convert that CSV.
Not sure which you have? Open the PDF and try to highlight a transaction. If the text highlights, it is a text PDF and you can use it directly.
Text-based PDF: drop it straight in
This is the fast path and it stays entirely on your machine:
- Open the converter and drop your PDF in. QBO Maker extracts the date, description, and amount from each transaction line.
- Review the preview. PDF layouts vary, so check that dates and amounts landed in the right place. For statements with separate money-in and money-out columns, confirm the signs (use "Flip plus and minus signs" if withdrawals show as deposits).
- Enter your statement's opening and closing balance to run the built-in balance check, which catches any row the parser missed before you import.
- Choose
.QBO(or QFX / OFX) and download.
Because PDF parsing is beta and statement layouts differ, the preview and the balance check are your safety net. If the parse looks off, fall back to the CSV route below.
Scanned PDF: get the data into a CSV first
If your PDF is a scan or photo, get the transactions into a spreadsheet, fastest and cleanest first:
- Re-download from your bank. The best option when available. Look for a CSV, Excel, or even QBO/QFX export in online banking. A native CSV beats anything pulled from an image.
- Use an OCR / PDF-to-CSV extractor. Tools like DocuClipper or Able2Extract read scanned tables and output a CSV. They handle multi-page statements and OCR, which QBO Maker does not.
- Copy-paste into a spreadsheet. For a short statement, paste the table into Excel or Google Sheets, fix the columns, and save as CSV.
Aim for a sheet with at least a date, a description, and an amount column, then convert it like any other CSV.
Clean the data, then convert
Whether from a PDF or a CSV, give the data a quick check before importing:
- Amounts. Make sure debits and credits are on the right side and no decimals were dropped.
- Junk rows. Delete page numbers, running balances, and "Statement Period" lines (the converter skips most, but check).
- Dates. Confirm the date format, especially if your bank uses DD/MM/YYYY; set the Date format in the tool so months are not swapped.
Then convert and, if you like, run the file through our OFX/QBO validator before importing.
What QBO Maker does and doesn't do
To set expectations clearly:
- It does read text-based PDFs (beta), plus CSV and Excel, and build valid
.QBO,.QFX,.OFXand QuickBooks CSV, entirely in your browser. Nothing is uploaded. - It does let you map any bank's columns, and Pro saves that mapping as a reusable per-bank template and batch-converts many files at once.
- It does not run OCR on scanned images. For those, extract to CSV first using one of the options above.
The free tier converts one full statement with unlimited transactions, no signup, so you can test the whole flow end to end.
Frequently asked questions
Can QBO Maker convert a PDF directly to QBO?
Yes, for text-based (digital) PDFs, drop the PDF into the converter and it extracts the transactions in your browser (beta, so review the preview). Scanned or image PDFs have no text to read, so you extract those to a CSV first, then convert the CSV.
How do I tell if my PDF is text-based or scanned?
Open it and try to select/highlight a transaction line. If the text highlights, it is a text-based PDF and QBO Maker can read it directly. If you can only draw a box over an image, it is scanned and needs OCR or a CSV export first.
My PDF imported with wrong signs or a couple of missing rows. What do I do?
PDF layouts vary, so review the preview. For money-in / money-out statements, toggle "Flip plus and minus signs" if needed. Enter the opening and closing balance to run the balance check, which flags anything missing. If the layout is unusual, use your bank's CSV export instead.
Does my PDF or statement data get uploaded anywhere?
No. PDF text extraction and the conversion both run 100% in your browser, so your data never leaves your computer. (If you use a third-party OCR tool for a scanned PDF, check its own privacy policy.)
Will the resulting QBO import into both QuickBooks Online and Desktop?
Yes. A valid .QBO works with QuickBooks Online (Banking, Upload from file) and Desktop (Banking, Bank Feeds, Import Web Connect File). You can validate it first at /validate.html.