How to import a PDF bank statement into QuickBooks Online

QuickBooks Online uploads bank transactions from CSV, QBO, QFX and OFX files, but not from a PDF. If your bank only gives you PDF statements, or the months you need are older than your bank feed reaches, you have to convert the statement first. Here is how to do that so the import works the first time and nothing is missing.

1. Choose the file type: CSV or .qbo

CSV is the simplest. QuickBooks asks you which column is the date, the description and the amount when you upload it.
.qbo (Web Connect) carries a transaction ID on every line, so QuickBooks can recognise a transaction it has already imported. It also works with QuickBooks Desktop, whose bank feeds take Web Connect files rather than CSV. The file has to contain an Intuit bank ID. Already have a CSV? Our free CSV to QBO converter turns it into a .qbo in your browser.

2. Get the CSV columns right

QuickBooks Online accepts two layouts:

Layout	Columns
3 columns	Date, Description, Amount – money out written as a negative number
4 columns	Date, Description, Credit, Debit – money in and money out in separate columns

A few rules trip people up:

One date format for the whole file. Pick the one that matches your QuickBooks region – 12/06/2026 in the US, 06/12/2026 in the UK and Australia. Mixed formats are the usual reason for transactions landing in the wrong month.
No balance rows. Remove "Opening balance", "Balance brought forward" and total lines – QuickBooks would import them as transactions.
One line per transaction. Descriptions that wrap onto a second line in the PDF must stay in one cell, otherwise the second line becomes a separate transaction with no amount.
Keep files small. Stay under 1,000 rows per file. A busy account over a full year may need two or three files.
Check the signs. In the 3-column layout, a payment that shows as positive will be recorded as a deposit. Spot-check a few known payments before you upload.

3. Check the conversion before you upload

This is the step most people skip, and it is where catch-up work goes wrong. Converters – including copy and paste – silently drop a line at a page break or misread a digit, and you only find out at reconciliation.

The test is simple: opening balance + money in − money out must equal the closing balance printed on the statement, to the cent. If the statement prints a running balance next to each line, each of those should match too. Here is how to run that check in Excel.

If you are importing several months, also check that each statement's closing balance equals the next one's opening balance. If they don't match, a statement is probably missing.

4. Upload the file

In QuickBooks Online, go to Transactions › Bank transactions (in some versions Banking).
Choose Upload transactions – it is usually under the arrow next to Link account. Menu names move around between QuickBooks versions.
Select your file, pick the QuickBooks account it belongs to, and for a CSV map the columns and the date format.
The transactions arrive in For review. Nothing is added to your books until you categorise or match them.

Uploaded the wrong file? Select its transactions in For review and choose Exclude, then upload the right one.

Doing it with BalancedProof

Drop the PDFs (or scans) on the converter. Each statement is checked against its printed balances, and any row where the balance stops matching is shown next to the original line so you can fix it in a few seconds. Then choose QuickBooks Online CSV or QuickBooks Web Connect (.qbo) and the date format, and download. The files follow the 3-column layout, contain no balance rows, and are split at 1,000 rows. Upload a whole year at once and transactions that appear in two overlapping statements are imported only once.