How to convert a bank statement PDF to Excel
Three methods, from free to fastest, plus the 30-second check that tells you whether any transactions went missing.
1. Download a CSV from your bank (free, best if available)
Most banks let you download recent transactions as CSV, Excel or QFX from online banking, usually under Activity or Statements & Documents, with a Download or Export button. The catch: many banks only offer the last 90 days to 24 months this way, and closed accounts or older years are often PDF-only.
2. Excel's built-in PDF import (free, works for simple layouts)
In Excel for Microsoft 365 on Windows: Data → Get Data → From File → From PDF, pick the statement, and choose the transaction table in the Navigator. It works well on clean, single-table statements. Expect cleanup when descriptions wrap onto two lines, when debits and credits are in separate columns, or when tables continue across pages. Scanned PDFs won't work.
3. A converter (fastest for many statements or messy layouts)
Tools like PennyProof read any layout, including scans, and output a clean table. Whatever you use, do the check below before you rely on the result.
The check that catches missing transactions
Opening balance + SUM(all amounts) should equal the closing balance printed on the statement, to the cent. If it doesn't, something was dropped, duplicated or misread. Look for the row where the running balance stops following. PennyProof runs this check automatically and highlights the row.
Questions
Why don't the amounts add up after copy-pasting from the PDF?
Copying from PDFs often splits or merges lines, drops minus signs, or picks up subtotal rows. Use the balance check to find out where.
Which method is best for taxes or a loan application?
If your bank offers CSV downloads for the months you need, use that. For older statements, closed accounts or many PDFs, use a converter, and keep the verification sheet as your proof that the numbers match.