Convert a bank statement PDF to Excel
One table of transactions you can sort, filter and sum, with real dates and numbers, and a check that every balance follows from the row before it.
- Keeps your layout
- Works on any device
- Deleted after processing
- Tables land in real cells
- One worksheet per page
- Column widths and borders kept
- Opens in Excel or LibreOffice
Add your bank statement PDF
Drag & drop file here
or choose a file from your device
PDF files only
On your computer? Get the Windows appOn your phone? Get the phone app
What it was tested on
Every row reconciled12 statements, 303 transactions, in the layouts banks in the UK, the US, Canada, Australia and the euro area use. Every transaction came out as one row, with the right date, amount and balance, and every balance followed from the one before it. These are test statements with made-up names and figures, not customers' statements.
| Statement | Pages | Rows |
|---|---|---|
| UK current account, date once per day, amount on the last line of each entry, balance at the end of each day | 3 | 30 |
| UK current account, money out / money in columns, start and end balance rows | 3 | 30 |
| UK app bank, one signed amount column in GBP, dd/mm/yyyy dates | 2 | 30 |
| US checking, mm/dd dates, one amount column with a minus for money out | 3 | 30 |
| US savings, withdrawals / deposits columns, $ balances, mm/dd/yy dates | 2 | 30 |
| Canadian chequing, a transaction-type column, "Sep 05" dates | 2 | 30 |
| Australian everyday account, debit / credit columns, balances marked CR | 2 | 30 |
| Euro account, 1.234,56 amounts, dd.mm.yyyy dates, € balances | 3 | 30 |
| UK current account mock with letter-spaced headings, published for testing statement converters | 2 | 9 |
| Three demo statements published for testing converters: a watermark across the table, the description starting above the date, the amount several lines below it | 6 | 54 |
- No rows merged or split; a wrapped description stays in one cell
- Dates as real dates, day first or month first as printed
- Amounts as numbers with their sign and two decimals
- Opening and closing balance, every page, page headers and footers left out
- £, $, € and accented letters as printed
How it works
Bank statement to Excel in three steps
Add your statement PDF
The PDF your bank lets you download from online banking, any number of pages.
Let it read the transactions
It finds the statement's own columns and reads every row under them, page after page, then checks each balance against the row before it.
Download the Excel file
Transactions first, then a Summary with the opening and closing balance and the check, then every page as it was printed.
What you get
A bank statement is a table that has been cut into pages, with headings, page numbers and carried-forward lines in between. The ordinary PDF to Excel keeps each page as it looks. This page puts the transactions back together: one sheet, one row per transaction, with the date filled in on every row even when the statement prints it once a day, and the balance after each row. A Summary sheet gives the opening and closing balance, the money in and out, and says whether every balance follows from the rows. The pages as printed come after it, so nothing on the statement is lost.
Getting the PDF from online banking
- Sign in to your bank's website, not the app: most apps share a statement as an image or a link, while the website gives you the PDF itself.
- Open the account, then Statements (some banks call it Documents or eStatements).
- Pick the month and choose Download or Save as PDF. Save the file the bank makes; printing the page to PDF yourself can lose the text the converter reads.
What it cannot do yet
- A scanned or photographed statement has no text to read, so its pages come across as pictures, not as a table.
- A password-protected PDF has to be opened first: Unlock PDF removes the password your bank set, then convert the unlocked copy.
- If a balance does not follow, the Summary sheet lists the rows to look at. Check those against the PDF before you rely on the totals.
Your statement stays private
A statement made only of text is converted in your browser and never leaves your device (a browser too old to do that sends it to our server instead). One that carries a picture, such as most bank logos, is sent over an encrypted connection to our server, converted in memory, and not kept once your Excel file is made. See how your files are handled.
Bank statement to Excel: questions
How do I convert a bank statement PDF to Excel?
Add the PDF above. The converter finds the statement's own column headings, reads every transaction under them, and gives you an Excel file whose first sheet, Transactions, has one row per transaction: date, description, paid out, paid in and balance. A Summary sheet follows, then each page of the PDF as it was printed.
Will the balances in Excel match my statement?
They are checked. Each balance the statement prints is compared with the balance before it plus the money in and minus the money out in between, and the closing balance with the last row. The Summary sheet says Yes when every one follows, or lists the rows to look at when one does not.
Why are the dates and amounts not text?
So you can work with them. Dates are real Excel dates shown the way your statement writes them (day first for UK, Irish, Australian and euro statements, month first for US ones), and amounts are numbers with two decimals, so SUM, filters and pivot tables work straight away.
What about a description that runs over two or three lines?
It stays in one cell, with its line breaks, next to the amount it belongs to. Lines are never split into rows of their own, and the date is filled in on every row even when the statement prints it once per day.
Are page headers, footers and "balance carried forward" lines included?
No. Headings repeated on each page, page numbers, footers, and the brought-forward and carried-forward lines are left out of the Transactions sheet. The opening and closing balances go on the Summary sheet instead.
Can I convert a scanned bank statement?
Not as a table yet. A scanned page has no text for the converter to read, so it comes across as a picture of the page. Download the statement from your online banking instead: banks make those PDFs with real text in them.
My statement PDF has a password. What can I do?
Remove it first with Unlock PDF, using the password your bank gave you, then convert the unlocked copy here.
Does it work with credit card statements?
It has only been checked on current, checking and savings account statements. A card statement can still be converted, but without a running balance there is nothing to check the rows against, and some card layouts are not read as a table yet; those come out page by page.
Other documents: PDF to Excel for any table, PDF to Word for letters and reports.
KovaPDF is not affiliated with, endorsed by or connected to any bank. Bank names are used only to say which statements the converter reads.