How to convert a HDFC Bank statement PDF to Excel

Step 1 — Download the statement from HDFC

Log in to HDFC NetBanking → Accounts → Enquire → Account Statement → choose the period → download as PDF. Choose the widest period you need — the analyzer handles a full financial year in one file, so there is no benefit to downloading month by month.

Step 2 — Have the password ready if the file is locked

Your customer ID followed by your date of birth in DDMMYY format (this is what HDFC net banking uses by default). You do not need to remove the password yourself: the analyzer has a built-in unlock step where you enter it once.

Step 3 — Upload it

Open the bank statement analyzer and drop in the PDF. The bank is detected automatically, so there is nothing to configure. CSV and Excel statements work too if that is what you were given.

Step 4 — Check the verification, then download

Before you download anything, look at the extraction summary: number of transactions found, total credits, total debits, and whether the balance chain verified. If the closing balance matches the statement, every row in between has been read correctly. Then generate the Excel workbook.

What you get

• Transactions — date, narration, cheque number, withdrawal, deposit, running balance, category
• Party-wise summary — counterparties with totals received and paid
• Monthly summary — credits, debits and net movement per month
• Cash transactions — deposits and withdrawals isolated
• High-value report — everything above a threshold you set

What usually goes wrong with HDFC statements

HDFC statements put the narration across two or three lines and use a separate cheque-number column. Generic converters split one transaction into several rows; the analyzer stitches the wrapped lines back into a single transaction before reading the amounts.

Frequently asked

Other banks

HDFC · SBI · ICICI · Axis · Federal Bank · Kotak