How the converter reads a bank statement
A PDF bank statement looks like a table, but inside the file there is no table at all — just thousands of pieces of text, each placed at an x/y position on the page. Copying and pasting from the PDF loses that structure, which is why pasted statements turn into one long column of jumbled text.
This bank statement converter rebuilds the table from those positions:
- Lines. Text sitting at the same height on the page is grouped into one line, and pieces that touch are joined into cells.
- Columns. The header row (words like Date, Description, Withdrawals, Deposits, Paid in, Amount, Balance) tells it where each column sits. Without a header it groups amounts by where they line up.
- Transactions. A line that starts with a date and contains an amount becomes a row. Lines underneath with no date — the second and third lines of a long description — are attached to the transaction above.
- Amounts. Values like
1,234.56,-45.00,(45.00),45.00-and45.00 DRare all recognised, so debits come out negative no matter how the bank prints them. - Check. Opening balance plus every transaction should equal the closing balance. The converter does that sum for you and also walks the running balance line by line.
Convert a bank statement PDF to Excel, step by step
- Download the PDF from your bank. In online banking, open Statements and save the PDF. A downloaded statement contains real text; a scan or a phone photo does not.
- Drop it onto the converter above. Reading happens in this browser tab. Large multi-page statements take a few seconds.
- Review the preview. Look at the reconciliation box first. A green tick means every transaction adds up to the closing balance. If it does not, the highlighted row is where the running balance first goes wrong.
- Fix anything odd. Click a cell to edit it, use × to delete a line you do not want (for example a summary row), or Flip signs if charges came out positive.
- Export. Choose Download Excel for a ready-to-use workbook, Download CSV for import into other software, or Copy to clipboard to paste straight into an open spreadsheet.
Supported statement formats
Layouts
- Separate debit and credit (withdrawal / deposit, paid out / paid in) columns
- One signed amount column
- With or without a running balance
- Two date columns (transaction and posting date)
- Descriptions that wrap onto several lines
- Multi-page statements with repeated headers
Dates
03/15/2024,15/03/2024,3-15-242024-03-1515 Mar 2024,Mar 15, 2024,15-Mar-2403/15with the year taken from the statement period
Amounts
1,234.56and1.234,56-45.00,(45.00),45.00-45.00 CR/45.00 DR- Currency symbols such as $, £, €
Not supported yet
- Scanned or photographed statements (needs OCR)
- Statements where several accounts share one table
- Layouts where the date is not on the first line of a transaction
Why a converter that never uploads your statement matters
A bank statement is one of the most sensitive documents you own: account number, address, salary, rent, medical payments, who you send money to. Most online converters work by uploading the PDF to their server, processing it there and sending a spreadsheet back. Even with good intentions, that means a copy of your statement exists on someone else's computer, under their retention policy.
This converter takes a different approach. The page includes its own PDF reader, and all of the work — reading the PDF, rebuilding the table, writing the Excel or CSV file — happens in your browser's memory. The page's security policy only allows connections back to the site it came from, and the converter does not make any to send your data. You can check it yourself:
- Open your browser's developer tools, go to the Network tab, then convert a statement. No request carries your file.
- Or load the page, switch off Wi-Fi, and convert a statement. It still works.
Closing the tab discards everything. Nothing is saved between visits.
Bank statement to CSV or to Excel?
| Excel (.xlsx) | CSV | |
|---|---|---|
| Best for | Reviewing, sorting, totals, pivot tables, sharing with an accountant | Importing into accounting, budgeting or tax software, databases and scripts |
| Dates | Real date cells you can sort and filter | Plain text in YYYY-MM-DD form, which import tools read unambiguously |
| Amounts | Real numbers with two decimals; negatives in red | Plain numbers, no thousands separators, minus sign for debits |
| Extras | Frozen header row and filters already on | Opens in any tool; tiny file size |
Both exports have the same columns: Date, Description, Debit/Withdrawal, Credit/Deposit, Amount (signed: money out is negative) and Balance when the statement shows one. Keep the separate debit and credit columns if your bookkeeping needs them, or use the single Amount column for quick sums.
Frequently asked questions
Is my bank statement uploaded anywhere?
No. The converter runs in your browser. The PDF is read with a PDF library bundled with the page, the table is built on your device, and the Excel or CSV file is created on your device. No part of the statement is sent to a server. You can disconnect from the internet after the page loads and it still works.
Which banks does it work with?
It is not built around a list of banks. It reads the layout of the page: lines that start with a date and contain amounts. That covers most statements that have a date column, a description and either one amount column or separate debit and credit columns, with or without a running balance. Unusual layouts can still need manual fixes in the preview.
Can it convert a scanned bank statement?
Not yet. A scan or a photo is an image with no text inside it, and reading it needs OCR, which this version does not include. The converter tells you when a PDF has no text. Most banks let you download the original PDF or a CSV export from online banking, which works better than a scan anyway.
Should I choose Excel or CSV?
Choose Excel (.xlsx) if you will work in Excel, Numbers or Google Sheets: dates and amounts arrive as real dates and numbers with a frozen header row and filters. Choose CSV if the file is going into accounting or budgeting software, a database or a script, because nearly every import screen accepts CSV.
How do I know the conversion is correct?
When the statement shows an opening and closing balance, or a running balance on each line, the converter adds every transaction to the opening balance and compares the result with the closing balance. It also checks the running balance row by row and highlights the first rows where it breaks, so a missed or mis-signed transaction is easy to find.
My statement is password-protected. Can I still convert it?
Yes. If the PDF needs a password to open, the converter asks for it. The password is used on your device to open the file and is not stored or sent anywhere.
Why are my debits shown as positive numbers?
Some statements, credit card statements in particular, print charges as positive amounts. When a running balance is available the converter uses it to work out which way each amount moved. If the signs still come out reversed, use Flip signs to invert every amount in one step.
Does it handle dates without a year, or day/month order?
Yes. Dates such as 12/18 take their year from the statement period, including statements that run from December into January. Day/month versus month/day order is detected from dates like 15/07, and you can override it if a statement only contains ambiguous dates.