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.
How to export your HDFC Bank statement as Excel or CSV
- 1Log in to HDFC NetBanking and open your account statement — in most versions it sits under the Enquire or Accounts menu.
- 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.
- 3Choose the Excel or Delimited download format rather than PDF. Greenote Lite reads .xls, .xlsx and .csv.
- 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 (coming soon) will.
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
Yes. The delimited text/CSV download and the Excel download both work. Upload whichever NetBanking gives you — the parser detects the layout, including the header and summary rows HDFC typically adds around the table.
Yes — enter the password when you upload. The file is processed in memory and deleted immediately after the report is generated; the statement itself is never stored.
Not in Greenote Lite — it reads Excel and CSV only. Export the Excel or delimited version from NetBanking instead; it typically sits right next to the PDF option. PDF statements are planned for the full Greenote desktop app.
Try it on a real HDFC statement
Your first statement is free — the trial processes the first 50 transactions so you can judge the quality end to end. No card, no signup wall, and the file is deleted the moment your report is ready.