Bank statement to Excel converter
Drop a PDF bank statement and get an Excel file with one row per transaction, real date cells and numbers you can sum. The PDF never leaves this browser.
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.
- Checked against the balance. Rows that don't add up to the printed balance turn red.
- 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
Drop the statement
Any text-based PDF statement from online banking, bank or credit card.
Fix anything red
Rows that don't add up to the printed balance are highlighted. Edit them in the table and the check reruns.
Download Excel
Dates are Excel dates and amounts are numbers, so formulas work straight away. A second sheet sums up each statement.
What the bank statement to Excel file contains
The Transactions sheet has Date, Description, Amount and, where the statement prints one, Balance. Money coming in is positive and money going out is negative, the same convention accounting software uses, so a SUM of the Amount column is the net change for the period.
The Summary sheet lists each statement's opening and closing balance, how many transactions were found and whether the balance check passed.
Why not copy the table out of the PDF?
Copying a PDF table straight into Excel usually puts each line in one cell, splits descriptions across columns or turns amounts into text. Reading the PDF by position avoids that: words are grouped into lines by their height on the page and into columns by where they sit, then each line is checked against the running balance.
That check is the part a copy and paste can't give you. If a line was missed or a debit was read as a credit, the balance stops adding up at that row and you see it before the file goes anywhere.
Statements from outside the US
Day-first dates, pounds, euros and Australian dollars are read too. There are separate notes for UK bank statements and Australian statements going into Xero. Need a plain text file instead? Use the bank statement to CSV converter.
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
Will Excel recognise the dates?
Yes. Dates are stored as Excel date cells formatted as yyyy-mm-dd, so you can change the format, sort and filter by date.
Why are withdrawals negative?
So that totals work: a SUM of the Amount column gives the net change for the period. It's also what QuickBooks, Xero and most budgeting apps expect when you import.
Can I convert a bank statement to Google Sheets?
Download the .xlsx or CSV file and open it in Google Sheets with File, Import.
Can I put several months in one workbook?
Merging several statements into one file is planned for Pro, which isn't on sale yet. For now, convert each statement and download it separately.
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.