How to Convert a Bank Statement PDF to Xero — 3 Steps
1
Upload PDF
Upload your bank statement PDF — any UK or global bank
2
Download CSV
Get a clean CSV with date, description, and amount columns in Xero's required format
3
Import into Xero
Go to Accounting → Bank Accounts → Import a Statement and upload the CSV
Why Can't Xero Import PDF Bank Statements Directly?
Xero is a cloud-based accounting platform that processes structured financial data. PDF files are a visual format — they present information for human reading but do not expose the underlying structure of individual transactions to software systems.
Xero's import engine expects each transaction to be a row in a table with defined columns: at minimum a date, a description and an amount. PDFs encode text and numbers as positioned elements on a page, not as structured data rows that Xero can parse.
The solution is to convert the PDF to CSV first. Our converter extracts all transactions from the PDF, organises them into clean columns, and produces a CSV file formatted to Xero's exact import specifications.
Step-by-Step: Import Bank Statement CSV into Xero
1
Convert your PDF at bankstatementengine.comUpload your bank statement PDF and download the CSV file. If the PDF is password-protected, enter the password when prompted — common for Barclays, HSBC and Lloyds business account PDFs.
2
Go to Accounting → Bank Accounts in XeroLog in to Xero and navigate to Accounting in the top menu. Click Bank Accounts to see all your connected and manual bank accounts.
3
Select the account and click Import a StatementClick on the bank account that matches the statement you are importing. On the account screen, look for the Import a Statement button or link. Select CSV as the file type.
4
Upload the CSV fileClick Browse, navigate to the CSV file downloaded from our converter, and click Open. Xero will preview the raw data from the file.
5
Map the column fieldsXero will ask you to identify which column is the date, which is the payee/description, and which is the amount (or Spent/Received). Match these to the corresponding columns in our CSV. Xero saves your column mapping for future imports from the same format.
6
Review and importXero shows a summary of transactions to be imported. Confirm the count matches your PDF statement and click Import. Transactions appear in the account's reconciliation screen where bank rules apply automatically.
Xero CSV Format Requirements
Xero's bank statement import accepts CSV files with the following columns. Our converter produces output in this exact format:
- Date — DD/MM/YYYY for UK accounts, MM/DD/YYYY for US accounts. Xero automatically detects the format based on your organisation's settings.
- Description — Full transaction narration including payee, reference and any transaction codes from the bank.
- Amount — A single column where money in is positive and money out is negative. Alternatively, separate Spent and Received columns — Xero accepts both formats.
- Reference (optional) — Additional reference text. Can be the cheque number or payment reference from the bank statement.
Supported UK and Global Banks
Our converter works with statements from all UK banks — both high street and challenger banks — as well as Australian, New Zealand, US and international banks used by global Xero customers:
UK Banks
Barclays
HSBC
Lloyds
NatWest
Santander UK
Halifax
Monzo
Starling Bank
Revolut
Metro Bank
TSB
Co-op Bank
Australia & New Zealand Banks
ANZ
Commonwealth Bank
NAB
Westpac
BNZ
ASB Bank
Kiwibank
Does the CSV Work with Xero Bank Rules?
Yes. When you import a CSV statement into Xero, the transactions are treated identically to transactions that arrive through Xero's automatic bank feed. All your existing bank rules — which automatically assign accounts, tax rates and contacts to transactions based on description patterns — apply to imported CSV transactions during reconciliation. This means a well-configured Xero setup with bank rules will reconcile your imported CSV transactions just as quickly as an automatic feed.
Frequently Asked Questions
Can Xero import PDF bank statements directly?
No. Xero cannot import PDF files. It accepts CSV and OFX/QIF format. Convert your PDF to CSV using our free converter, then import the CSV into Xero via Accounting → Bank Accounts → Import a Statement.
What CSV format does Xero need for bank statement import?
Xero needs: Date (DD/MM/YYYY for UK), Description, and either a single Amount column (positive for money in, negative for money out) or separate Spent and Received columns. Our converter produces output in exactly this format.
How do I import a CSV into Xero?
Go to Accounting → Bank Accounts → select your account → Import a Statement → choose CSV → upload file → map Date, Description, and Amount columns → click Import. Transactions appear in the reconciliation screen.
Does it work with Xero bank rules?
Yes. Transactions imported via CSV are treated identically to automatic bank feed transactions in Xero. All your bank rules, auto-categorisation and contact matching apply during reconciliation.
Which UK banks are supported?
All UK banks: Barclays, HSBC, Lloyds, NatWest, Santander, Halifax, Monzo, Starling, Revolut, Metro Bank, TSB, Co-operative Bank and all others. Works with personal and business account statements.
Does it work for Australian and New Zealand banks using Xero?
Yes. Works with ANZ, Commonwealth Bank, NAB, Westpac, BNZ, ASB and all other ANZ-region banks. The CSV output is formatted to Xero's requirements for your region.