Bank statement to CSV converter
Turn a PDF bank statement into a CSV file you can import into your accounting software. Every transaction is checked against the running balance the bank printed, so nothing is missed or misread. Your statement is read on your own computer and never uploaded.
You've used today's free statement. Come back tomorrow for another free one, or convert as many as you like for 30 days.
You've unlocked this on this device. Thank you!
Pay once, no subscription. Secure checkout by Stripe.
What's in the CSV
| Column | Example | Use it for |
|---|---|---|
| Date | 2026-03-01 | Transaction date, year first so day and month can't be swapped |
| Description | DD BRITISH GAS | The payee or reference as printed |
| Amount | -527.08 | One signed amount: money out is a minus (Xero uses this) |
| Money in | 1535.71 | For software that wants separate columns |
| Money out | 527.08 | For software that wants separate columns |
| Balance | 2915.40 | The running balance, to check against the statement |
Import it into Xero
- Download the CSV above.
- In Xero, go to Accounting, then Bank accounts, open the account and choose Import a statement.
- Choose the CSV. Xero matches Date, Description and Amount by itself.
- Leave Money in, Money out and Balance as No field, keep "Don't import the first line" ticked, and import.
Tested in Xero with a 70-transaction statement: all 70 lines imported, none duplicated, and the account balance moved by exactly the statement's net total.
Why the check matters
A CSV that's missing one row or has one misread figure will still import, and you won't find out until the bank reconciliation doesn't balance. This converter only says RECONCILED when every row follows from the balance before it and the totals take the opening balance exactly to the closing balance. If anything is out, it tells you which row. Need a spreadsheet instead? Use the bank statement to Excel converter.
Questions
How do I convert a PDF bank statement to CSV?
Choose your PDF statement above. The converter reads every transaction in your browser, checks each one against the running balance printed on the statement, and gives you a CSV file to download. Nothing is uploaded.
What columns are in the CSV?
Date (as YYYY-MM-DD), Description, Amount (money out as a minus), Money in, Money out and Balance. One row per transaction, oldest first, with no opening balance row, so it imports cleanly.
How do I import the CSV into Xero?
In Xero, open the bank account, choose Import a statement, and pick the CSV. Xero matches Date, Description and Amount by itself; leave Money in, Money out and Balance as No field, and keep "Don't import the first line" ticked. We tested this: a 70-transaction statement imported with every line and the balance moved by exactly the statement's total.
Will it import into QuickBooks, Sage or FreeAgent?
They all take a CSV with a date, a description and either one signed amount or separate money in and money out columns, which this file has. On their bank import screen, map Date, Description and Amount (or Money in and Money out). We have tested Xero ourselves; for the others, check the first few rows on their preview screen before you confirm.
Why does the date look different in Excel?
The CSV writes dates as YYYY-MM-DD so accounting software can't mix up day and month. Excel may show them in your own format when you open the file; the date itself is the same. If you want a formatted spreadsheet, use Download Excel instead.
Is it free?
Yes. There is no sign-up and nothing to install, and your statement stays on your computer.
Does it work with scanned statements?
Not yet. A scan is a picture with no text in it. Download the statement from your online banking as a PDF instead; those contain the text.