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.
Northbank
Current account · GB29 NWBK 6016 1331 9268 19
STATEMENT
| Date | Description | Out | In | Balance |
|---|---|---|---|---|
| 01/03 | SALARY — ACME LTD | 3,200.00 | 4,061.20 | |
| 03/03 | TESCO STORES 2841 | 84.30 | 3,976.90 | |
| 05/03 | SHELL FUEL BRISTOL | 61.75 | 3,915.15 | |
| 07/03 | RENT — HARBOUR LETTINGS | 1,150.00 | 2,765.15 |
The Excel you get back
| Date | Description | Out | In | Balance | Category |
|---|---|---|---|---|---|
| 01/03/2026 | Salary — Acme Ltd | 3,200.00 | 4,061.20 | Income | |
| 03/03/2026 | Tesco Stores 2841 | 84.30 | 3,976.90 | Groceries | |
| 05/03/2026 | Shell Fuel Bristol | 61.75 | 3,915.15 | Fuel | |
| 07/03/2026 | Rent — Harbour Lettings | 1,150.00 | 2,765.15 | Rent |
Drop your bank statement PDF
PDF · photo · iPhone HEIC · scan · zip · Word — mix them freely, no sign-up to try
Your first document converts free and the Excel downloads — no sign-up. $7 for a whole batch.
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. The first document converts free and you can download the Excel without an account. Pay $7 once for a whole batch; 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.