How to Convert a Bank Statement PDF to Excel Accurately

Convert net-banking PDF statements to Excel with amounts as numbers, then verify the result with simple totals checks.

Bank statements downloaded from net banking are usually text-based PDFs, which means the numbers can be extracted directly into a spreadsheet. Scanned statements need one extra step.

Steps

If the statement is password-protected, remove the password with Unlock PDF (you need to know it).
Open PDF to Excel, select the statement and choose whether all pages should go to one sheet.
Download the .xlsx file. Debit, credit and balance amounts are stored as numbers; values marked Cr or Dr and bracketed amounts are converted to signed numbers.

Always tie the totals

Sum the debit and credit columns and compare with the statement summary.
Check that opening balance + credits - debits = closing balance.
Spot-check a few rows against the PDF, especially rows with long narrations.

Scanned statements

If the PDF is a scan, run OCR first to add a text layer, then convert. Check the result more carefully, because recognition can misread digits on poor scans.

Account numbers and long reference numbers are kept as text so no digits are lost.