How to Import a Bank Statement PDF into QuickBooks

QuickBooks won't take a PDF. How to turn a statement into a QBO file it imports directly, or a CSV in its layout, and what to check before accepting.

QuickBooks can connect directly to most banks, but that doesn't help when you need historical transactions from before the connection existed, when the bank feed has a gap, or when the account is closed. In those cases you're importing a file — and QuickBooks does not accept PDFs.

The formats QuickBooks accepts

QBO — Web Connect format, sometimes downloadable from your bank directly, and read with no column mapping
CSV — flexible, but you map the columns yourself
OFX / QFX — older interchange formats, still supported

The bank statement PDF to QBO converter writes a Web Connect file from your statement: every transaction with a YYYYMMDD date, one signed amount, and a FITID of its own, so two identical payments on the same day stay two. The direction of each amount comes from the column the bank printed it in, as the running balance confirms.

The CSV layout QuickBooks expects

QuickBooks accepts either a 3-column or a 4-column CSV. The 3-column form uses a single signed amount; the 4-column form uses separate debit and credit columns.

Format	Columns
3-column	Date, Description, Amount (negative for money out)
4-column	Date, Description, Credit, Debit

Step by step

Convert your statement PDF to QBO Use the converter below. Choose CSV instead only if you would rather map the columns yourself.
Check the date format if you chose CSV QuickBooks asks you to specify it during import. Get this wrong and every date before the 13th of a month lands in the wrong month. A QBO skips this question: it writes every date as YYYYMMDD, taking the day-month order from the statement's own dates. On a statement where no day is past the 12th, check a few dates after importing.
In QuickBooks, go to Transactions → Bank transactions → Upload from file Select your QBO or CSV and the account it belongs to.
Map the columns, for a CSV QuickBooks shows a preview. Confirm date, description and amount columns are mapped correctly before continuing.
Review before accepting Imported transactions land in the For Review queue, not straight into your books. Check the count against the statement.

Common import errors

Error	Cause
"Invalid date format"	Date column is text, or the format doesn't match what you selected
Amounts import as zero	Currency symbols or thousands separators left in the amount column
Everything imports as a deposit	Debits not marked negative in the 3-column format
Duplicate transactions	Overlapping date range with an existing bank feed

Reviewing before you accept

Imported transactions land in the For Review queue rather than going straight into your books, which is a genuine safety net worth using properly.

Check the count in the queue Against the row count in your converted file. A shortfall means rows were rejected.
Spot-check the dates Particularly any below the 13th, where format confusion hides.
Check the direction Sort by amount — the largest deposits should be things you recognise as income.
Then categorise and accept QuickBooks will suggest categories once it has seen a few similar transactions.

Frequently asked questions

How far back can I import?

QuickBooks doesn't limit the date range on file imports, so you can load several years of history.

Will this create duplicates with my bank feed?

It can, if the date ranges overlap. Import only the period your feed doesn't already cover.

What happens if I import the same QBO twice?

Each transaction's FITID is derived from its date, narration, amount and position, so it is the same every time the same statement is converted, and QuickBooks skips a FITID it has already imported.

Convert a statement now

Bank Statement PDF to QBO, or see every format. More in the guides.