Convert a bank statement PDF for Xero
Xero imports bank statements as CSV. Get a file in Xero's own layout — date, amount, payee, description — from any PDF statement, ready for Import a statement.
- Checked every row against your balance
- Private read on your device first
- Excel & CSV plus QuickBooks, Xero and Quicken files
- Free no sign-up, no page limits
Import it into Xero
- Open Accounting › Bank accounts, choose the account and Manage account › Import a statement.
- Select the CSV. Xero recognises the columns because they use its own names.
- Check the statement dates Xero shows, then reconcile as usual.
Dates and signs
Dates are written day first (31/01/2025), the default for most Xero regions; pick 01/31/2025 above for a US organisation. Money out is negative, money in positive.
Other formats: bank statement PDF to Excel · bank statement PDF to CSV · credit card statement to Excel · bank statement PDF to QBO for QuickBooks · bank statement PDF to OFX · bank statement PDF to QIF · bank statement PDF to QFX for Quicken · bank statement PDF to IIF for QuickBooks Desktop · bank CSV to QBO for QuickBooks · bank CSV to OFX · Convert an OFX or QFX file to Excel · QIF file to Excel · Convert an MT940 bank statement to Excel
From PDF to spreadsheet in four steps
No account and no waiting in a queue. Most statements take a few seconds.
- 1
Upload
Drop one or more statements from online banking — a PDF, a photo, or a CSV or Excel export.
- 2
Read
Dates, descriptions and amounts are found automatically, in any language and number format.
- 3
Check
Every row is checked against the balance printed on your statement. Anything that does not add up is highlighted.
- 4
Download
Get Excel or CSV, or a file ready to import into QuickBooks, Xero or Quicken.
A spreadsheet you can use right away
- One row per transaction
- Money in and money out in separate columns
- Real dates and numbers that Excel can sort, filter and add up
- Extra sheets with monthly totals and a summary
| Date | Description | Money out | Money in | Balance | |
|---|---|---|---|---|---|
| 2 | 2025-03-03 | DD ELECTRIC CO BILL | 90.06 | 1,430.34 | |
| 3 | 2025-03-03 | CARD PAYMENT TESCO STORES | 42.18 | 1,388.16 | |
| 4 | 2025-03-05 | SALARY ACME LTD | 3,673.50 | 5,061.66 | |
| 5 | 2025-03-06 | RENT PAYMENT | 1,250.00 | 3,811.66 | |
| 6 | 2025-03-08 | UBER TRIP | 18.40 | 3,793.26 |
Made for bank statements
Generic PDF-to-Excel tools copy text into cells. StatementEasy understands what a statement is.
Private by design
Your statement is read by your own browser first. Only one it cannot read goes to our server. How we handle files
Real statement layouts
Descriptions over several lines, separate deposit and withdrawal sections, newest-first lists and statements with several accounts.
Banks from many countries
Any date and number format, and statements in English, French, Spanish, Portuguese, German, Dutch and more.
Scans and photos
A scanned or photographed statement is read with text recognition, and the balance check tells you how well it went.
Ready for your accounting
Excel, CSV, and import files for QuickBooks, Xero, Quicken, OFX and more.
Insights included
Monthly totals, spending by category, recurring payments and a summary for lenders — all from your statement.
Works with your bank
The converter reads the columns of almost any bank statement. These banks are tested on real statement layouts.
Questions
Is StatementEasy really free?
Yes. There is no sign-up, no page limit and no daily limit: convert as many statements as you need. Your own browser does most of the work, so a conversion costs us almost nothing.
Is my bank statement uploaded anywhere?
Usually not. Your browser opens and reads the statement on your device, and for most statements nothing is sent to us except anonymous counts such as "a 3-page statement was converted".
A statement goes to our server only when your browser cannot read it — for example a scan or a photo — and it is deleted after reading. If even our server cannot read it, we keep it encrypted for up to 14 days to add support for your bank, then delete it. Details in our privacy policy.
Which banks does it work with?
Any bank whose statement is a normal PDF with selectable text. The reader finds the date, description and amount columns on its own. Layouts from Chase, Bank of America, Barclays, Lloyds, CIH Bank and Attijariwafa bank are tested on real statement layouts, and the generic reader handles many others in English, French, Spanish, Portuguese, German, Dutch and Italian.
How do I know the numbers are right?
Most statements print a running balance. StatementEasy checks every row: the previous balance plus money in minus money out must equal the balance printed on that row. You see a green "Balances match" when everything adds up, or the exact rows to look at when it does not.
Statements without a running balance are checked on totals: opening balance + money in − money out = closing balance.
What if my statement is a scan or a photo?
A scanned or photographed statement is read with text recognition (OCR). You can read it on our server, which gives the best result, or on your device. Clear, straight scans work best, and the balance check shows how well it went.
Can I convert several statements at once?
Yes. Drop several PDFs together. Each gets its own tab, and "All files combined" gives one sheet with a File column, for example a full year of monthly statements.
Which format should I pick?
Pick Excel if you will work in the spreadsheet: dates and amounts are real values, so sorting, filtering and formulas work right away, and a Monthly sheet totals each month. For accounting software, More formats has QuickBooks (.qbo), Xero CSV, a QuickBooks Online CSV, OFX and QIF. Plain CSV works with Sage and almost everything else.
Something is wrong in my result. What can I do?
Click any cell to correct it, remove rows you do not want, or open "Columns look wrong? Fix them" to tell the reader which column is which. If a layout keeps failing, tell us the bank and we will add it.
Your next statement, in a spreadsheet
Free, no limits. No sign-up.