How to convert a bank statement to Excel
A practical workflow for turning statement PDFs into rows you can review and analyse.
Start with the original PDF
Download the original statement from your bank when possible. Text-based PDFs preserve character positions and generally extract more reliably than scans.
Choose your date order
For dates such as 03/04/2026, select day-first or month-first according to your statement. Enter the statement year if transaction rows omit it.
Check the extracted rows
Compare opening and closing balances, transaction counts and debit/credit totals with the source. Correct highlighted rows, and check transactions that wrap onto several lines.
Download your workbook
Choose Excel to get a worksheet with separate debit and credit columns. Keep the original PDF with your records for future reconciliation.