Bank statement → Xero
Convert a PDF statement into what Xero imports: OFX, or a CSV with exactly the columns it asks for — Date, Amount, Payee, Description, Reference — and money out already signed negative.
- An Excel file where the amounts are numbers you can sum — not text that looks like numbers.
- A category on every row, and foreign spend converted at the rate on the day you spent it.
- Or the file your software wants: OFX, a Xero or QuickBooks CSV, UBL XML for an ERP.
The PDF your bank sends
NORTHBANK PLC
Statement · 01–31 March 2026 · GBP
03/03/26SALARY - ACME LTD4,250.00
04/03/26RENT - MARCH1,200.00
05/03/26TESCO STORES 447187.35
07/03/26SHELL FUEL LONDON62.10
11/03/26AWS EMEA214.88
22/03/26VODAFONE LTD42.00
The Excel you get back
| Date | Description | Category | GBP | EUR |
|---|---|---|---|---|
| 2026-03-03 | SALARY - ACME LTD | Salary | +4,250.00 | 4,875.60 |
| 2026-03-04 | RENT - MARCH | Rent | −1,200.00 | 1,378.56 |
| 2026-03-05 | TESCO STORES 4471 | Groceries | −87.35 | 100.46 |
| 2026-03-07 | SHELL FUEL LONDON | Fuel | −62.10 | 71.63 |
| 2026-03-11 | AWS EMEA | Software | −214.88 | 248.81 |
| 2026-03-22 | VODAFONE LTD | Telecoms | −42.00 | 48.59 |
Category filled in for you. EUR converted at the rate on each transaction's own date — not today's.
Drop your bank statement PDF
PDF · photo · iPhone HEIC · scan · zip · Word — mix them freely, no sign-up to try
Free to try, no sign-up. Pay $9 for a batch, or sign in for 10 free pages.
How it works
- 1
Drop the statements
Any bank, any layout, as many months as you like.
- 2
It reads them
Every line transcribed as printed, with the merchant separated from the rest of the memo.
- 3
Import into Xero
Statement Import takes the CSV or the OFX directly. No mapping step.
The exact columns Xero asks for
Date, Amount, Payee, Description, Reference. Not close enough to fix by hand — the file Xero takes on the first attempt.
Payee is a contact, not a memo
The merchant goes in Payee so Xero can match it to a contact; the full bank line goes in Description. Put the whole line in Payee and you get a new contact for every transaction and a contact list you cannot use.
Statements Xero cannot fetch
Bank feeds cover the accounts your bank connects. This covers the rest: closed accounts, foreign banks, and the twelve months of history a new client hands you as PDFs.
Questions people ask
- Can it read a scanned or photographed document?
- Yes. Scans and phone photos are read the way a person reads them — a crumpled receipt or a skewed scan still works, and there is no template to configure for each bank.
- What if one PDF holds many receipts?
- It splits them apart. Fifty receipts scanned into a single PDF become fifty rows; a twelve-page statement stays one document.
- Are the amounts real numbers in Excel?
- Yes. Amounts and balances arrive as numeric cells, so a column sums the moment you open the file.
- How are foreign currencies handled?
- Each amount is converted at the published rate for the date of that transaction — not today's rate. The rate and its date sit beside the figure so you can check it.
- Do I need an account?
- No. Convert a batch, pay once, download it. An account is only for a monthly page allowance.
- Does it work with QuickBooks and Xero?
- Yes. Alongside Excel, you can download a statement as OFX — the standard bank-data format both read — or as a ready-made CSV laid out the way each one expects: Date, Amount, Payee, Description, Reference for Xero, and the three-column Date, Description, Amount for QuickBooks, with money out already signed negative. Invoices and receipts can also come out as UBL XML for an ERP or an e-invoicing system.