You have your own business statement PDF, but QuickBooks Online needs structured import data. Convert it carefully, keep the original statement and check the imported rows for gaps or duplicates.
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: Gives you control but becomes repetitive and is vulnerable to missed or shifted rows.
- Bank or PDF export: Use a suitable export when available, then check dates, descriptions and amounts against the source.
- AI-assisted conversion: BankScan AI can prepare an Excel or CSV working file from supported formats. Review every row and adapt it to QuickBooks Online's current import rules.
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 Your Own Business Statements
The £3.99/month Sole Trader plan is for one UK sole trader or owner-operated small business that keeps sole-trader records. AI usage follows the monthly allowance shown in the app.
Start 7-day trial →Last updated: 8 May 2026. QuickBooks and QuickBooks Online are trademarks of Intuit Inc.