UK bank statement to Excel
Convert a PDF statement from a UK current account or credit card into Excel or CSV. Dates are read day first, Paid out and Paid in columns are kept apart, and every row is checked against the balance.
Converted in this browser. The PDF is never uploaded. Check it yourself
- Stays on your device. The PDF is read in your browser and never uploaded.
- Day-first dates. 03/04/2026 is read as 3 April when the statement shows £ or a sort code.
- Free for 5 pages a day. Excel and CSV, no account.
Download
QBO, OFX and Xero settings
QuickBooks Desktop matches the bank ID against its list of banks; if it refuses the file, enter your bank's ID. Credit card statements are exported as credit card accounts automatically. Xero reads CSV dates in your organisation's regional order, so pick the order your Xero organisation uses.
How it works
Download the PDF
From your bank's online banking, open statements and save the month you need as a PDF.
Drop it here
The statement is read in this browser. Balance brought forward becomes the opening balance and balance carried forward the closing one.
Check and download
Rows that break the running balance turn red. Excel and CSV are free.
UK bank statement to Excel: the layouts it reads
These are the layouts our tests cover: automated tests that run on every change, plus the public sample statements we ran through the converter in October 2026.
- Paid out / Paid in / Balance and Money out / Money in / Balance columns, including headers split over two lines.
- Balance brought forward and balance carried forward lines (also written b/f and c/f), used as the opening and closing balance.
- Dates like 3 Apr, 1 February, 1st November 2018 and 03/04/2026. When every date could be either way round, the £ sign or a sort code on the statement means day first.
- Several lines on the same day where the date is printed only once.
- Amounts in brackets, with CR or DR after them, or with a £ sign.
We test layouts, not banks. The tests use statements we generated and public sample statements (university and training examples). None of them is a real statement from a named UK bank, so we can't promise that your bank's statement reads cleanly. The balance check is there for that: if a row was missed or misread, the totals stop adding up and you see where.
Can Xero import a PDF statement in the UK?
Not at the moment, as far as we can tell. Xero's PDF statement import is for US and Canadian organisations: Xero's own feature sheet for it is titled "PDF Statement Import US and CA" and covers statements "from supported banks". On Xero's product ideas board, a request titled "Ability to import PDF in other regions (exc. US and CA)" was opened in April 2026. Until that changes, a UK organisation without a bank feed imports a CSV.
The Xero CSV layout here writes dates as DD/MM/YYYY on this page, because Xero reads CSV dates in your organisation's regional order. It is part of Pro, which isn't on sale yet. The free CSV and Excel files have the same transactions; Xero's import screen lets you assign columns yourself. We haven't tested an import in a live UK Xero organisation, so check the preview Xero shows before you finish.
Check that nothing is uploaded
You don't have to take our word for it. Two ways to see for yourself:
- Go offline. Once this page has loaded, turn off Wi-Fi or switch on airplane mode, then drop a statement in. It still converts, because the converter runs in your browser and the page keeps a copy of itself for offline use.
- Watch the network. Open your browser's developer tools (F12, or Cmd+Option+I on a Mac), choose the Network tab, then convert a file. You'll see no request carrying your PDF.
The one exception is AI repair, which you have to switch on yourself for a statement our parser couldn't read cleanly. It sends the text we extracted from the PDF (not the file) to our server, and only after you tick a box agreeing to it. Details are on the privacy page.
Free now, Pro coming soon
Everything in the Free column works today. Pro isn't on sale yet; this is what it will include.
| Free | Pro | |
|---|---|---|
| Pages converted in your browser | 5 a day | Unlimited |
| Balance check and editing | Yes | Yes |
| Excel and CSV | Yes | Yes |
| QBO, OFX, QuickBooks CSV, Xero CSV | No | Yes |
| Merge several statements into one file | No | Yes |
| AI repair (opt-in) | 2 pages a day | 500 pages a month |
| Account needed | No | A license key, sent by email |
Questions
Does it work with my bank?
It isn't built for a list of banks. It reads the dates, descriptions and amounts on the page and works out the columns. We haven't tested real statements from named UK banks, so look at the balance check: green means the rows add up from the opening to the closing balance.
Why are my dates the wrong way round?
If every date on a statement is ambiguous (like 03/04/2026) and there's no £ sign or sort code on it, the converter can't tell. Fix the dates in the table, or tell us which bank it was so we can add the clue it needs.
Can I import the result into Xero?
Yes, as a CSV. Xero's PDF import is for US and Canadian organisations, so UK organisations use the bank statement import with a CSV file. The ready-made Xero layout is part of Pro (coming soon); the free CSV can be mapped in Xero's import screen.
Is my statement uploaded?
No. The PDF is opened and read by your browser, on your device. The only time anything leaves your device is AI repair, which you switch on yourself; it sends the extracted text, not the file, and we don't store it.
Does it work with scanned statements?
Not yet. The converter reads the text inside a PDF. A scan or a photo of a statement is an image with no text in it, so nothing comes out. Most statements downloaded from online banking are text-based.