PDF to Excel, built for statements
Bank statement PDF to Excel
Get a real .xlsx workbook from a PDF bank statement, not a renamed CSV. Amounts are numbers, dates are dates, and a second sheet records how the statement reconciled.
- Numeric amounts in accounting format
- Real Excel dates, not text
- Reconciliation sheet included
- Frozen header and autofilter
| Date | Description | Debit | Credit | Balance |
| Mar 02, 2026 | ACH DEPOSIT STRIPE PAYOUT | 4,210.00 | 16,690.55 | |
| Mar 03, 2026 | POS AMAZON MKTPLACE | 86.43 | 16,604.12 | |
| Mar 05, 2026 | CHECK #1042 | 1,250.00 | 15,354.12 | |
| Mar 08, 2026 | ZELLE FROM J MORALES | 640.00 | 15,994.12 |
The short answer
How to convert a bank statement PDF to Excel
To convert a bank statement PDF to Excel, upload the PDF, let the converter rebuild the transaction table and check it against the statement's balances, then download the .xlsx. You get every transaction on one Transactions sheet, with amounts as real numbers and dates as real Excel dates, plus a Reconciliation sheet that shows whether the figures tie to the statement.
This is more than a format detail. A spreadsheet built by copying from a PDF, or by a CSV opened in Excel, often holds amounts as text: SUM returns zero, sorting puts 1,000 before 200, and dates sort alphabetically. Fixing that by hand takes longer than the conversion itself. A proper .xlsx stores the cell type, so the workbook works the moment you open it.
Before you download, every row has been checked against the running balance and every total against the printed figures. If a digit was misread, you see the row and the highlighted line on the PDF it came from.
Step by step
From PDF statement to a finished workbook
- 1Upload the statementSign in and upload the PDF from your online banking, or a scan of a paper statement. Several digital statements can go up together. Scans go one at a time. A password-protected PDF asks for its password, which is used in your browser only.
- 2Review the extracted rowsThe table is rebuilt from the page layout, with wrapped descriptions joined and brought-forward lines treated as balances. Anything that breaks the running balance is flagged on its row.
- 3Fix or confirm flagged rowsClick a flagged row to open the page with that line highlighted, and compare it with what was read. Rows can be flipped between debit and credit, merged or excluded before export; the checks describe the statement as the bank printed it.
- 4Download the .xlsxChoose Excel. The file opens with the header row frozen and an autofilter on, so you can filter by description or amount right away.
- 5Work with it in Excel or Google SheetsSUM, SUMIF, pivot tables and sorting work immediately because amounts are numbers and dates are dates. The same file opens in Google Sheets (File → Import) and LibreOffice.
Why it works
What makes this Excel output different
Numbers that add up
Amounts are numeric cells in accounting format, so negatives show in red parentheses and SUM works with no clean-up.
Dates Excel understands
Dates are real date values, so they sort and filter by date. The day-first or month-first order is settled once per statement before writing.
Reconciliation sheet
A second sheet records which checks ran, which passed, and the exact difference where one failed, which is useful when the workbook goes to someone else.
Debit, credit and signed amount
Separate Debit and Credit columns for reading, plus a signed Amount column for formulas. Use whichever your workflow needs.
Scans too
Paper statements that were scanned convert to the same workbook, read with OCR and checked the same way.
Checked before export
A misread digit is caught on its own row
Every conversion is tested against the statement: the running balance on every row, page subtotals, opening plus movement against closing, the printed credit and debit totals, and the transaction count. When a number does not add up, VouchRow names the row and highlights the line it came from on the PDF.
Arithmetic only: it verifies amounts, balances and totals, not descriptions or dates, and two errors that cancel out would pass. The source-line link covers the rest.
How the checks workRunning balance check
- POS AMAZON MKTPLACE−86.4316,604.12
- CHECK #1042−1,250.0015,354.12
- ZELLE FROM J MORALES+640.0015,994.12
Every row agrees with the balance printed beside it.
The workbook
What's inside the Excel file
Each converted statement becomes one workbook with two sheets. Transactions from every page go onto one sheet, in statement order, so a 9-page statement isn't split into nine tables.
| Column | Contents |
|---|---|
| Date | A real Excel date, so it sorts and filters as a date |
| Description | The full description, with wrapped lines joined |
| Payee | The payee, where it can be separated from the description |
| Reference | Cheque number or reference, where printed |
| Debit / Credit | Money out and money in, as positive numbers in separate columns |
| Amount | The signed amount: negative out, positive in |
| Balance | The running balance as printed, where the statement has one |
| Type | The transaction type, such as debit, credit, cheque, fee or interest |
| Check | Whether the row passed the running-balance check |
The Reconciliation sheet
The second sheet is the audit trail: opening and closing balance, total credits and debits, which of the checks ran, which passed, and the exact difference for any that failed. When a workbook goes to a lender, a reviewing partner or the other side in a dispute, this sheet answers "how do we know these figures are complete?" before anyone asks.
The scope is stated on the sheet too: the checks are arithmetic only. They confirm that amounts, balances and totals agree. They don't verify descriptions or dates, and two errors that cancel each other out would pass.
Why not CSV
Why a real .xlsx beats a CSV opened in Excel
A CSV holds text and nothing else. When Excel opens one, it guesses each column's type, and the guesses depend on your computer's regional settings. On a machine set to a European locale, "1,234.56" is read as text and every SUM over it returns zero. On a US machine, 03/04/2026 becomes 4 March for a UK statement. Leading zeros on reference numbers disappear.
An .xlsx file stores the type with the value. The amount is a number, the date is a date, and nothing depends on who opens the file or where. If you need to import into accounting software, CSV is still the right choice. For working in a spreadsheet, use Excel.
Other methods
Other ways to get a bank statement into Excel
There are three common alternatives, and each has its place.
- Your bank's own export. If the bank offers CSV or Excel for the period you need, use it. The limits are history (exports often cover recent months only), closed accounts, and statements that arrive as PDFs from a client.
- Excel Power Query (Data → Get Data → From File → From PDF). It comes with Excel and is fine for a simple one-page table. It works on digital PDFs only, splits wrapped descriptions into separate rows, and treats brought-forward lines as data. Nothing checks the result against the balances.
- Copy and paste. Workable for ten rows. Over a multi-page statement it usually mixes page headers into the data and pastes amounts as text.
Accuracy
Catching the errors a spreadsheet hides
The dangerous conversion errors are the quiet ones: one misread digit in a 300-row statement, a transaction lost at a page break, or a sign flipped on a refund. A spreadsheet doesn't complain about any of them.
Before export, each row is checked against the printed running balance, each page against its subtotal where the bank prints one, and the statement against its opening and closing balances and printed totals. A misread amount breaks the running balance on exactly the row where it happened, and the Check column in the workbook records it.
Side by side
Excel or CSV for bank statement data?
| Excel (.xlsx) | CSV | |
|---|---|---|
| Amounts | Numeric, accounting format | Text until the importer interprets it |
| Dates | Real dates | Text in ISO order (YYYY-MM-DD) |
| Reconciliation | Separate sheet with full results | Column and summary lines (full preset) |
| Best for | Analysis, review, sending to people | Importing into accounting software |
| Character set | Full Unicode | UTF-8 |
| Opens in | Excel, Google Sheets, LibreOffice, Numbers | Anything |
Who uses it
What people use the Excel output for
Loan and mortgage files
Underwriters and brokers want months of deposits and withdrawals in a sheet they can total and filter. The reconciliation sheet shows the figures tie to each statement.
Family law and forensic work
Spending analysis and asset tracing start from a spreadsheet, and every row traces back to a highlighted line on the source statement.
Budgeting and tax records
Sort a year of spending by merchant, label rows in bulk before export, and build a pivot table without fixing data types first.
Preparing data for Tally or another ledger
Some teams review and label rows in Excel before entering them. A clean workbook makes that review faster.
FAQ
Bank statement PDF to Excel: questions
How do I convert a bank statement PDF to Excel?
Upload the PDF, review the extracted rows (anything that breaks the running balance is flagged), then download the .xlsx. The workbook has a Transactions sheet and a Reconciliation sheet, with amounts as numbers and dates as dates.
Why not just use CSV?
In many locales Excel reads "1,234.56" from a CSV as text, and every SUM over that column returns zero. An .xlsx file stores the cell type, so amounts are numeric the moment you open it. CSV is still the better choice for importing into accounting software.
What's in the workbook?
Two sheets. Transactions has date, description, payee, reference, separate debit and credit columns, a signed amount, the running balance, type and a check column, with a frozen header row and autofilter. Reconciliation has the audit trail: which checks ran, which passed, and the exact difference where one failed.
Do negative amounts show properly?
Yes. The accounting number format shows negatives in red parentheses, the way a bookkeeper expects, while the cell still holds a negative number for formulas.
Can I convert a scanned bank statement to Excel?
Yes. Scanned pages are read with OCR on our servers and checked against the balances like a digital statement. Scans convert one statement at a time.
Are all pages put on one sheet?
Yes, all the transactions from one statement go on a single Transactions sheet in order. Each statement produces its own workbook. Combining several months into one sheet is a copy-and-paste step in Excel.
Can Excel convert a PDF bank statement by itself?
Excel's Power Query can import tables from a digital PDF. It doesn't join wrapped descriptions, handle brought-forward balance lines, read scans, or check the result against the statement, so expect to tidy and verify the output by hand.
Does it work with Google Sheets?
Yes. Open or import the .xlsx in Google Sheets and the numbers and dates come across as values.
Keep going
Related guides and converters
Other formats
Turn a PDF statement into a workbook you can use
Create an account, upload a statement and download an .xlsx with the reconciliation already done. Starter is $15 a month for 300 pages, and paying annually costs the same as ten months.