How to import old bank statements into Xero
Bank feeds and CSV exports usually only reach back a limited time. For older months, the statements are often only available as PDFs. Here's the route from PDF to reconciled transactions.
1. Download the PDF statements from online banking
Get every statement for the period you need, without gaps. Keep the original PDFs: they're your record.
2. Convert them to one CSV
Drop all of them in the converter above. It checks each statement's balances and warns you if a month is missing or if two statements overlap, before anything reaches Xero.
3. Import the CSV in Xero
In Xero, open the bank account, choose Manage Account then Import a Statement, and pick the CSV. Map the columns when Xero asks: Date, Amount, Payee, Description, Reference. Dates are day first (dd/mm/yyyy).
4. Reconcile
The imported lines appear in the account's reconciliation screen like bank feed lines. Because the CSV was balance-checked, the statement balance in Xero should match the PDF's closing balance.
Avoid duplicates
If a bank feed already covers part of the period, only import the months before the feed starts. Importing the same transactions twice creates duplicates that you'll have to delete one by one.
Your statements stay on your computer
The PDF is read by code running in this browser tab. Nothing is uploaded: there's no server that could receive it. You can check: load the page, turn off Wi‑Fi, and convert a statement.
We count anonymous events (a file was read, a check passed, a CSV was downloaded) to know what to improve. No file names, amounts or text from your statements are ever sent.