Old Statements

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.

Guides