HDFC Bank statement to Excel

An HDFC Bank statement has seven columns — Date, Narration, Chq./Ref.No., Value Dt, Withdrawal Amt., Deposit Amt. and Closing Balance — and ends with a STATEMENT SUMMARY block. Copy it into Excel by hand and the 16-digit reference numbers turn into scientific notation, long UPI narrations split over two rows, and the summary lands in the middle of your data. StatementEasy gives you one row per transaction — date, value date, description with its reference, money out, money in, balance — and leaves the summary out.

Download the statement from HDFC NetBanking

1. Log in to HDFC Bank NetBanking. Use the customer ID and password you use for the account.
2. Open Accounts, then Enquire, then A/c Statement. Choose the account if you have more than one.
3. Choose the period and PDF as the format. For a full year, pick 1 April to 31 March.
4. Download the file and drop it here. If the PDF asks for a password, type it here too.

Statements HDFC sends by email are usually locked with your customer ID as the password. It is used in your browser to open the file and is only sent along with the file if our server has to read it.

What happens to each part of the statement

On the HDFC statement	In your sheet
Narration over two lines	One description, UPI ID or UTR kept
Chq./Ref.No. 0000412345678901	Added to the description, all 16 digits kept
Empty reference 0000000000000000	Left out
Value Dt	Its own date column
Withdrawal Amt. / Deposit Amt.	Money out / money in, as numbers
STATEMENT SUMMARY	Not added as a row

The summary checks the whole file

The summary at the end of an HDFC statement lists the opening balance, the number of debits and credits, their totals and the closing balance. StatementEasy reads every transaction and checks each Closing Balance against the previous one, from the opening balance to the last row. The totals of the result sit next to each other, so you can compare them with the summary’s Debits and Credits. If a single row is missing or misread, you see it before you export.

Which HDFC statement to download

HDFC gives you the same account in three forms. The NetBanking statement covers any period you choose and is the best file to convert. The monthly e-statement arrives by email as a password-protected PDF and covers one month. A statement printed at the branch and scanned is only an image: it is read with OCR (beta), which is slower and less exact. If you can, download from NetBanking — the PDF contains the text itself, so every digit is read as printed.

Common problems, and what to do

• The PDF asks for a password. For HDFC e-statements it is usually your customer ID. Type it when asked.
• Several accounts in one file. Each account’s rows are kept apart, with an Account column, so balances are checked per account.
• A year in one file. Long statements are fine: every page is read and the balance is followed across page breaks.
• A row is flagged. The result shows which row breaks the running balance; open it to see the original line. If the layout itself was misread, tell us.

Preparing your ITR with an HDFC statement

Download the statement for the financial year, 1 April to 31 March. In the spreadsheet, filter money in for INT.PD to total the savings interest, and look for credits that are not salary — rent, freelance payments, refunds — so nothing is left out of your return. Your Annual Information Statement (AIS) on the income tax portal lists the interest HDFC reported; the two totals should match.

Last tested October 2026. StatementEasy is not affiliated with HDFC Bank Limited.