StatementToCSV · UK bank statements, checked to the penny
Convert your bank statement PDF to CSV, Excel, Xero or QuickBooks
Works with most UK bank PDFs. Tested on HSBC, NatWest and Starling; others in beta. Every balance checked. Your file never leaves your computer.
or drop it here
Read in this browser. Your file is never uploaded.
Rows wrong or missing?
Send us the shape of this statement, not its contents. The report below is made in this browser. It keeps where text sits, dates and column headings. Every name, amount, reference and account number is replaced with x and 1, as you can see. Nothing is sent until you send it.
Then email the report to support@statementtocsv.co.uk and say which bank it is from. We’ll add the layout and let you know.
| Date | Description | Paid in | Paid out | Balance |
|---|
| Check | Result | What we found |
|---|
Statements
| Period | File | Opening | Closing | Rows | Used as |
|---|
| Date | Description | Paid in | Paid out | Balance | From |
|---|
Works with text PDFs that have Date, Description, Paid in / Paid out (or Amount) and Balance columns. Scanned or photographed statements are not supported yet. The samples are fictional test data.
How it works
- Step 1
Choose your PDF
Use the statement PDF from online banking or your banking app. Add one, or a whole year at once.
- Step 2
We check every balance
Each row’s balance is recalculated. If a row is missing or misread, you see exactly which one and by how much.
- Step 3
Download your CSV
Get a CSV for Excel, or a file laid out for Xero or QuickBooks. It is made in your browser and saved straight to your computer.
The whole-year check
Year-end work rarely means one statement. It means twelve, from a client, with no guarantee they are all there. Add every statement at once and StatementToCSV checks them against each other:
- Missing months. A gap between one statement’s end and the next one’s start.
- Duplicates. The same statement saved twice, counted once.
- Overlapping periods. An interim statement that repeats rows from the monthly ones, counted once.
- Broken carry-over. A closing balance that doesn’t match the next opening balance.
- Every penny explained. The difference for the year is broken down into what the checks found, down to £0.00 unexplained.
Then download one combined CSV with a source-file column on every row. Read how the whole-year check works.
Your file never leaves your computer
Read in your browser
The converter runs on this page, on your device. Statements are not uploaded, stored or seen by anyone, including us.
Blocked by design
The site’s security policy tells your browser to block connections to any other site, so the page cannot send your file elsewhere. The one exception is Cloudflare’s cookieless analytics, which only counts page views.
No accounts, no cookies
No sign-up for the free converter, no tracking cookies. We count visits with Cloudflare’s cookieless analytics, never what you convert.
Exports for Excel, Xero and QuickBooks
Excel and Google Sheets
Date, Description, Paid in, Paid out, Balance. UK dates, amounts as plain numbers, ready to sort, filter and total.
Xero
Date, Amount, Payee, Description, Reference with one signed amount column, the layout Xero’s bank statement import expects.
QuickBooks
The three-column Date, Description, Amount file that QuickBooks Online accepts when you upload a bank file.
UK banks
Tested on real statements: HSBC, NatWest and Starling. In beta: Barclays, Lloyds, Santander, Nationwide, Monzo, Halifax and the other UK banks we read. Beta means we haven’t yet tested a real statement from that bank. The balance check still tells you if anything was missed, and one click sends us an anonymised layout report so we can add it.
Frequently asked questions
Is my bank statement uploaded anywhere?
No. The PDF is opened and read by your own browser, on your own computer. It is never sent to our server or anyone else’s, and nothing about it is stored. You can check this yourself: convert a statement, then disconnect from the internet and convert another one. It still works.
Which banks does it work with?
It reads statements by their columns (date, description, paid in, paid out, balance), not by a template for each bank. It has been tested on real HSBC, NatWest and Starling statements. Statements from Barclays, Lloyds, Santander, Monzo, Nationwide and other UK banks are in beta: some may already convert, and the balance check tells you straight away if anything was missed. See the full list of banks.
What does “checked to the penny” mean?
Every row’s printed balance is compared with the balance worked out from the row before it. If a single payment is missing or misread, the check shows the row and the exact amount. The opening balance plus money in, minus money out, must also equal the printed closing balance. If everything agrees, you see a difference of £0.00.
Can it convert a whole year of statements at once?
Yes. Choose “Several statements” and add all the PDFs. The whole-year check puts them in date order and looks for missing months, duplicate files, overlapping periods and balances that don’t carry over from one statement to the next, then exports one combined CSV. How the whole-year check works.
Does it work with scanned or photographed statements?
Not yet. It needs the PDF you download from online banking, which contains real text. A scan or a photo is just a picture of text and would need OCR, which isn’t supported yet.
Is it free?
Converting single statements to CSV for Excel, with the balance check, is free and unlimited. Pro adds the whole-year check, the combined CSV, Xero and QuickBooks files and edited-statement detection. During the beta, every feature is free for everyone. See pricing.
My statement PDF has a password. Can I still convert it?
Yes. Enter the password when asked. It is used by your browser to open the file and goes nowhere else.
Are you connected to my bank?
No. StatementToCSV is an independent tool. It is not affiliated with or endorsed by any bank, and it never connects to your bank account. It only reads the PDF you choose.
Pricing
Free
- Single statements, unlimited
- CSV for Excel
- Every balance checked
Pro
or £150 a year
- Whole-year multi-statement check
- One combined CSV
- Xero and QuickBooks CSV
- Edited-statement detection
During the beta, every Pro feature is free for everyone. No sign-up needed.