Why doesn't Xero accept PDF bank statements?

Xero is cloud accounting software that processes structured data. PDFs are unstructured documents — Xero can't reliably extract transaction data from them. Xero accepts CSV, QIF, OFX, and Excel files for bank statement imports because these formats contain structured, machine-readable data.

How do I convert a PDF bank statement to import into Xero?

You need to convert the PDF to CSV or Excel first. You can either: (1) manually copy-paste transactions from the PDF into a spreadsheet (15-30 min per statement), (2) use Adobe Acrobat's export feature (5-10 min but often misaligns columns), or (3) use an AI-powered converter like BankScan AI that extracts transactions in under 30 seconds with correct column formatting.

Can I import bank statements into Xero without a bank feed?

Yes. Under the bank account in Xero, click 'Manage Account' then 'Import a Bank Statement'. You can upload a CSV or Excel file with your transactions. This is particularly useful for historical statements older than 90 days that aren't covered by the Open Banking bank feed.

Xero Won't Accept PDF Bank Statements? Here's How to Import Them

You've got a client's bank statement PDF. You need it in Xero. But Xero refuses to accept it. Sound familiar?

This is one of the most common frustrations for UK accountants using Xero. Bank feeds are great for day-to-day transactions, but they only go back 90 days and only work with connected bank accounts. For everything else — historical statements, clients who won't connect their bank, accounts at banks Xero doesn't support — you're stuck with PDFs. And Xero won't touch them.

Why Xero rejects PDFs: Xero processes structured data. CSV and Excel files contain rows and columns that Xero can read directly. A PDF is an image of a document — Xero can't reliably extract transaction amounts, dates, and descriptions from it. You need to bridge that gap.

The 3 Ways to Get a Bank Statement PDF into Xero

Method 1: Manual Copy-Paste (The Hard Way)

Open the PDF, highlight each transaction row, copy, paste into Excel, fix the formatting, save as CSV, import to Xero.

Time: 15–30 minutes per statement
Accuracy: Low — easy to misalign columns, miss transactions split across pages, or copy the running balance as a transaction
Best for: Desperate situations with 1–2 short statements

Method 2: Adobe Acrobat Export (The OK Way)

Open the PDF in Adobe Acrobat Pro, use the Export PDF tool to convert to Excel, clean up the formatting, save as CSV, import to Xero.

Time: 5–10 minutes per statement
Accuracy: Medium — Acrobat often misaligns columns, splits multi-line transactions, and loses formatting on scanned PDFs
Best for: Clean, modern PDF statements from digital-first banks like Monzo or Starling

Method 3: AI-Powered Conversion (The Fast Way)

Upload the PDF to an AI-powered bank statement converter. Download a formatted Excel file. Import directly into Xero.

Time: Under 30 seconds per statement
Accuracy: High — AI handles multi-line entries, transaction codes, running balances, and bank-specific quirks
Best for: Regular use, especially with tricky UK bank formats like HSBC and NatWest

Step-by-Step: Import a Bank Statement into Xero

Once you have your CSV or Excel file ready, here's how to get it into Xero:

Log into Xero and go to Accounts → Bank Accounts
Click on the bank account you want to import transactions into
Click Manage Account (top right) → Import a Bank Statement
Click Browse and select your CSV or Excel file
Xero will show a preview — map the columns: Date, Description (Payee), Amount
Click Import
Xero will attempt to match imported transactions against existing ones to avoid duplicates

Pro tip: Before importing, make sure your spreadsheet has clear column headers. Xero needs at minimum: Date, Description/Payee, and Amount columns. If your bank statement has separate Debit and Credit columns, combine them into a single Amount column with negative values for debits.

Common Xero Import Problems (and Fixes)

"File format not recognised"

Xero accepts CSV, QIF, OFX, and Excel files. If you're getting this error, check that your file is actually in one of these formats — not a renamed PDF or TXT file.

"Column mapping failed"

Xero couldn't identify which column is Date, Description, or Amount. Make sure your headers are clear single words (Date, Description, Amount) and that the data underneath matches.

"Duplicate transactions detected"

Xero found transactions that match ones already in the system. This is actually a feature — it prevents double-counting. Review the flagged duplicates carefully.

Amount column shows errors

Check for: currency symbols (£, $) in the amount column, commas in numbers (convert to plain numbers), or text mixed in with amounts (like "£50.00 CR"). Remove all formatting and keep only numbers.

UK bank-specific tip: HSBC statements use a single Amount column with DR/CR indicators — you'll need to make debits negative. Barclays uses separate Money In/Money Out columns — combine them. Lloyds uses a Payment/Receipt column with type codes — strip the codes. An AI converter handles all of this automatically.

What About Bank Feeds?

Xero's bank feed (via Open Banking) is excellent for ongoing transactions — but it has limitations:

90-day history limit: Only pulls the last 90 days of transactions
Not all banks supported: Some smaller banks and international accounts aren't covered
Client reluctance: Some clients refuse to connect their bank accounts to third-party services

For everything the bank feed misses, PDF-to-Excel conversion is your fallback. And if you're doing it regularly, an AI converter pays for itself within the first month.

Convert Any UK Bank Statement PDF for Xero in Seconds

Upload your PDF, get a clean Xero-ready Excel file. No signup required — try it free with one statement and one receipt.

Try Free Now →

Last updated: 8 May 2026. Xero import steps verified against Xero's current interface. Xero is a trademark of Xero Limited.