Why is a PDF different from a Xero transaction import?

A PDF is source evidence rather than structured transaction data. Check Xero's current accepted formats and import instructions before preparing a working file.

How do I prepare a PDF statement for Xero?

Type the data, use a suitable bank export or prepare a working file with an AI-assisted tool. Verify every row against the source and adapt it to Xero's current column rules.

Can I prepare older statements when a bank feed is incomplete?

Yes, where Xero supports a suitable import format. Confirm the feed dates, avoid overlap and follow Xero's current import instructions.

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

You have your own business statement PDF, but Xero needs structured import data rather than the PDF itself.

A feed can help with ongoing transactions, but its available history and bank coverage may not include the period you need. Older evidence may therefore need conversion, careful review and a controlled import.

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 a supported PDF to an AI-assisted statement converter, then compare the generated working file with the source before adapting it to Xero's current import rules.

Review: Check multi-line entries, transaction codes, dates, amounts and running balances.
Best for: Reducing repetitive retyping while preserving a source-led review.

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-format tip: layouts can use DR/CR indicators, separate money-in and money-out columns or type codes. Check how the destination expects signs and columns, and verify the generated file against the statement.

What About Bank Feeds?

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

Available history: Varies by bank, account, consent and provider
Coverage: Check whether your account and required period are available
Your preference: You may choose not to connect an account to another service

For a period the feed misses, a reviewed working file may provide a controlled fallback. Preserve the source and avoid overlapping dates.

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. Xero import steps verified against Xero's current interface. Xero is a trademark of Xero Limited.