How to import a PDF bank statement into QuickBooks Online

QuickBooks Online cannot read a PDF. If your bank feed doesn't go back far enough — or your bank isn't supported — the route is PDF → CSV → Banking → Upload transactions. This guide gives you the exact CSV layout QuickBooks accepts and the mistakes that produce the dreaded "We can't read this file" error.

The CSV formats QuickBooks Online accepts

QuickBooks accepts two layouts. Pick one and stick to it for the whole file.

3-column (recommended — fewer things to get wrong):

Date,Description,Amount
01/15/2026,PAYROLL ACME CORP,2400.00
01/16/2026,RENT JANUARY,-1250.00

4-column:

Date,Description,Credit,Debit
01/15/2026,PAYROLL ACME CORP,2400.00,
01/16/2026,RENT JANUARY,,1250.00

Rules that matter:

• Dates: one format for the whole file. QuickBooks asks you which format during upload (MM/DD/YYYY for US accounts, DD/MM/YYYY for UK/AU/CA). Mixed formats fail silently — some rows import with the wrong month.
• Amounts: plain numbers. No currency symbols, no thousands separators (1,250.00 inside a CSV becomes two columns unless quoted). Negative for money out in the 3-column layout.
• Header row: exactly one, at the top.
• No totals, no opening/closing balance rows, no blank lines in the middle.
• Encoding: UTF-8 or plain ASCII. Files exported from some tools in UTF-16 are rejected.
• Size: under 350 KB, roughly 1,000 transactions. Split larger files by month.

Step 1 — Get the CSV from the PDF

Three options, in order of effort:

1. A converter that outputs the QuickBooks format directly. Rowvert has a "QuickBooks" download that produces the 3-column file above (MM/DD/YYYY, negative amounts for money out, descriptions quoted) after reconciling the statement against its closing balance. 1 page a day is free.
2. Excel → Save as CSV. If you already have the transactions in Excel (see how to convert a bank statement PDF to Excel), keep only three columns, format the date column as text in the right pattern, remove totals, and Save As → CSV UTF-8.
3. By hand. Feasible for a dozen transactions; not for a year.

Step 2 — Upload into QuickBooks Online

1. Transactions → Bank transactions (older accounts: Banking).
2. Click the ▾ next to Link account and choose Upload from file.
3. Drag the CSV in, click Continue.
4. Choose the QuickBooks account the transactions belong to (the bank or credit-card account in your chart of accounts). If it doesn't exist yet, create it first.
5. Map the columns: tell QuickBooks which column is Date, Description and Amount, and pick the date format. For the 3-column layout, choose "1 column: both positive and negative numbers".
6. Review the preview. Uncheck anything that shouldn't import (a duplicate of a transaction the bank feed already brought in, for example).
7. Continue → Yes to import.

The transactions land in the For review tab like any bank-feed transaction. Categorise, match or add them as usual.

Errors and what causes them

A note on QBO/OFX files

If your bank offers a .qbo (Web Connect) download, use it — it carries transaction IDs, so QuickBooks de-duplicates automatically. Most banks only offer it for the last 90 days, which is exactly why the CSV route exists for the older months.

Before you upload: reconcile once

The one check that prevents hours of clean-up later: the sum of the CSV's amounts must equal closing balance − opening balance on the statement. If it doesn't, find the missing or doubled row now, not after you've categorised 300 transactions.

Related: Bank statement to Xero · Rowvert for bookkeepers · QuickBooks CSV export.