HDFC Bank statement analyser: Excel in, ITR-ready report out

HDFC Bank narrations are dense but disciplined: most digital transactions arrive as hyphen-separated segments, so a UPI payment typically reads like UPI-RAMESH TRADERS-ramesh@okhdfc-HDFC0000123-512345678901-GROCERY. Everything a CA needs — mode, party, VPA, reference — is in there somewhere; the work is pulling each piece out of thousands of rows. Greenote Lite does that split for you and hands back an audit-ready workbook with every party named.

Works with Excel and CSV statements from netbanking. Got a PDF? That is coming to the full Greenote desktop app.

How to export your HDFC Bank statement as Excel or CSV

1. 1Log in to HDFC NetBanking and open your account statement — in most versions it sits under the Enquire or Accounts menu.
2. 2Pick the account and the period you want to analyse. Many portal versions cap a single download at a few months, so a full year may need two or three files.
3. 3Choose the Excel or Delimited download format rather than PDF. Greenote Lite reads .xls, .xlsx and .csv.
4. 4Upload the file exactly as downloaded — no cleanup needed, and password-protected files are fine.

Menu names shift between netbanking versions, so treat the steps above as a guide — the constant is the format: take the Excel, XLS or CSV download, not the PDF. Greenote Lite does not read PDF statements; the full Greenote desktop app does, and is available now.

What Greenote Lite does with an HDFC statement

HDFC's hyphen-delimited style is one of the friendliest formats for automated analysis, and the engine takes full advantage of it:

• UPI narrations are split on their hyphen segments, so the payer or payee name and VPA are lifted out cleanly — fifty payments to the same kirana shop roll up as one party with one total in the party ledger.
• NEFT and RTGS rows typically embed an IFSC and the counterparty name mid-string; the engine strips the codes and reference numbers and keeps the name.
• POS and e-commerce rows carry the merchant after the masked card number; they are grouped by merchant and tagged as card spends.
• HDFC's Excel export usually wraps the transaction table in account-holder headers and a closing summary block. The table is detected automatically, so you never delete rows before uploading.
• Withdrawal and deposit amounts come as separate columns and map directly to debits and credits — no sign confusion.

The download is a four-sheet Excel workbook: a party ledger of who paid whom, every transaction categorised and named, a category summary, and an ITR summary with AIS/SFT flags. See why the party ledger comes first or the full statement-to-ITR workflow.

HDFC statement questions