Export Bank Statement — bank statement PDF to Excel
helpQuick answer

Can Xero Import PDF Bank Statements?

Not directly, no. Xero doesn't read a plain PDF and turn it into bank transactions — its Import a Statement tool only accepts CSV, OFX or QIF files. So the working answer to "can Xero import PDF bank statements?" is: convert the PDF into a Xero-ready CSV first, then import that. The format Xero needs is structured columns (date, description, amount), and a PDF doesn't give it that.

There's no live bank-feed API doing this in the background either. You're producing a file and feeding it in by hand, the same way a feed would deliver statement lines — just sourced from your own statements.

What Xero actually accepts

When you go to a bank account in Xero and choose Import a Statement, the upload box wants one of three things: a CSV, an OFX file, or a QIF. A PDF isn't on the list, and pasting one in does nothing useful. Banks hand out PDFs because they're tidy to read and print, not because they're easy to parse — the numbers sit in a layout, not in tidy columns.

Some people see Xero mention "upload a bank statement" and assume a PDF will do. The catch is that Xero still needs the underlying transactions as structured data. A scanned or exported PDF on its own carries no machine-readable rows for Xero to pick up. The data has to be pulled out and arranged into columns before it'll go anywhere.

The route that works: convert, then import

The reliable path is short:

  1. Convert the PDF statement to CSV. Export Bank Statement reads the PDF — including scanned or photographed ones, via OCR — and produces a clean file in Xero's native bank-import layout.
  2. Check the numbers reconcile. This is the part most tools skip. We verify every extracted transaction against the running balance: opening balance plus the transactions should equal the closing balance. If a line was misread or a page break dropped a row, the statement won't reconcile and you'll see it flagged before you import anything.
  3. Import the CSV into Xero through Import a Statement on the relevant bank account. Xero treats the rows as reconcilable bank statement lines, exactly as if a feed had delivered them.

Here's the mistake we see most: people retype a statement or copy-paste straight from the PDF, import the lot, and only find out weeks later that a transaction near a page break never made it in. By then it's reconciled and trusted, and unpicking it is a job. Catching it at the convert stage costs nothing.

Why "convert first" beats fighting the PDF

A CSV that already balances saves the awkward reconciliation hunt later in Xero. If the opening and closing figures agree with the transactions in between, you know nothing was lost in extraction. That's the whole point of the check — you're importing a month you can actually trust, not a month you hope is complete.

It also keeps things honest about what's automated. Export Bank Statement converts and verifies; Xero imports. There's no certified bank-feed push that shoves transactions straight into your ledger, so if a tool promises one-click API sync from a PDF, be sceptical. The dependable method is the file route, and it works for any UK bank — Barclays, HSBC, Lloyds, NatWest, Monzo, Starling and the rest.

Frequently asked questions

Can I upload a PDF straight into Xero?

No. Xero's Import a Statement tool only takes CSV, OFX or QIF. A PDF has to be converted to one of those formats first — a Xero-ready CSV is the simplest option.

Will Xero import a scanned or photographed statement?

Not as a PDF or image. Run it through OCR first to extract the transactions into a CSV. Export Bank Statement handles scanned and photographed statements, then checks the totals reconcile before you import.

Does Xero pull old transactions automatically?

No. Bank feeds only fetch recent activity, roughly the last 90 days. Anything older has to come in as a statement file you import yourself.

How do I know the converted file is complete?

Use the reconciliation check. If opening balance plus the transactions equals the closing balance, the statement reconciles and nothing was dropped. If it doesn't, the file is flagged so you can fix it before importing.

For the full walkthrough, see how to import PDF bank statements into Xero and the Xero CSV import format explained. More UK guidance lives on the UK hub and the Xero pillar.

CTA: Got a PDF statement to bring into Xero? Convert it to a reconciled, Xero-ready CSV and check the totals before you import.
verified

Try it on your own statement

Clean Excel/CSV, with every transaction checked to balance.

upload_fileConvert free
verifiedChecked to balance

Convert your bank statement — every transaction verified

Upload any PDF, get clean Excel or CSV ready for Xero & QuickBooks. Scanned statements too.

upload_fileConvert a statement free