Can I import PDF bank statements directly into QuickBooks Online?

No. QuickBooks Online does not accept PDF files for bank statement imports. You must convert the PDF to CSV or Excel first. QBO accepts CSV, QBO, QFX, and OFX file formats for bank transaction imports.

How do I convert a bank statement to CSV for QuickBooks?

You can either manually copy-paste transactions (slow and error-prone), use Adobe Acrobat's export feature (moderate accuracy), or use an AI-powered converter like BankScan AI which extracts transactions in seconds with correct formatting for QBO import.

How to Import Bank Statements into QuickBooks Online — Complete Guide

You've got client bank statements to import into QuickBooks Online. But QBO won't accept the PDF files your clients send you. This is the most common frustration we hear from UK bookkeepers using QuickBooks — and the fix is simpler than you might think.

QuickBooks Online accepts these formats: CSV, QBO (QuickBooks format), QFX (Quicken), and OFX (Open Financial Exchange). It does not accept PDF files. You need to convert PDF statements to CSV or Excel before importing.

Method 1: Import via QBO Banking (CSV Upload)

Go to Transactions → Banking (left sidebar)
Click the Upload transactions button (top right)
Click Browse and select your CSV file
Select the bank account to import into
QBO will show a preview — map your columns (Date, Description, Amount)
Click Upload

Method 2: Import via Chart of Accounts

Go to Accounting → Chart of Accounts
Find the bank account and click View register
Click the dropdown arrow next to the balance → Import
Select your CSV file and map columns

Converting Your Bank Statement PDF to CSV

Since QBO won't touch PDFs, you need a CSV file first. Three options:

Manual copy-paste: Open PDF, copy transactions, paste into Excel, save as CSV. 15-30 min per statement. Error-prone with multi-line entries.
Adobe Acrobat export: Export PDF to Excel, clean up, save as CSV. 5-10 min. Often misaligns columns on UK bank formats.
AI-powered converter: Upload to BankScan AI, download formatted Excel/CSV. Under 30 seconds. Handles HSBC multi-line, NatWest references, Lloyds type codes automatically.

Common QBO Import Errors and Fixes

"We couldn't recognise your file format"

Your file isn't in CSV, QBO, QFX, or OFX format. Make sure you've saved as CSV (not Excel) and the file extension is .csv.

"Some transactions couldn't be imported"

Usually caused by: dates in the wrong format (QBO expects DD/MM/YYYY for UK), currency symbols in the amount column, or text mixed with numbers. Clean the file and retry.

"Duplicate transactions detected"

QBO found transactions matching ones already in the register. Review carefully — this prevents double-counting but can also block legitimate imports if the matching logic is too aggressive.

UK bank format tip: If your bank statement uses separate Debit and Credit columns (like Barclays), combine them into a single Amount column with negative values for debits. If it uses DR/CR indicators (like HSBC), convert DR amounts to negative.

Convert Any UK Bank Statement for QuickBooks in Seconds

Upload your PDF, get a QBO-ready CSV or Excel file. No signup required.

Try Free Now →

Last updated: 8 May 2026. QuickBooks and QuickBooks Online are trademarks of Intuit Inc.