What a HDFC Bank statement looks like
HDFC Bank does not issue a single statement format. These are the 2 layouts Greenote recognises, and the differences between them are exactly what a one-size converter gets wrong.
Standard retail statement
- Columns
- Date, Narration, Reference No, Value Date, Amount, Closing Balance
- Date format
- DD/MM/YY
NR and older pipe-delimited statement
- Columns
- Tran Date, Narration, Cheque No, Value Date, Debit Amount, Credit Amount, Balance
- Date format
- DD/MM/YY
Where HDFC statements trip up generic converters
These are the specific things that go wrong when a HDFC Bank statement is run through a general purpose PDF to Excel tool, or typed by hand at the end of a long day.
- 1
The standard retail PDF does not put a transaction on one line. The date and the first part of the narration sit on one row, the reference number and value date on the next, then the amount, then the closing balance, then any number of narration continuation lines.
- 2
Only one amount column is printed. Whether a transaction is a debit or a credit has to be inferred by comparing the closing balance against the previous row, which is exactly the step manual typing gets wrong on a long statement.
- 3
The account header block repeats on every page, and its address lines use the same colon-separated shape as a cheque deposit counterparty. Strip it carelessly and you lose the party name; keep it carelessly and it contaminates the narration.
- 4
Narrations run across page breaks, so the tail of a transaction on page 3 can appear at the top of page 4.
How Greenote turns it into Tally vouchers
If all you want is the spreadsheet, stop after step two and export it to Excel. That is a complete use of Greenote and plenty of people never go further.
- 1
Detect the HDFC layout
Greenote identifies the bank from the statement itself and picks the matching reader, so the right one of the layouts above is used without you selecting anything.
- 2
Rebuild every transaction
Dates, narration, debit, credit and running balance are reassembled into one row per transaction, including the multi-line and continuation cases listed above.
- 3
Classify and name the counterparty
Each line gets a category (what the transaction was) and, where the narration allows it, a party name (who it was with), bound to a ledger that already exists in your Tally company.
- 4
Post into Tally
Greenote builds the voucher XML for your Tally version and posts it into your local Tally. You review before anything is written.
Get a text PDF, not a scan. Download the statement straight from HDFC net banking as a PDF or Excel file. A text PDF contains the actual characters and can be read exactly. A scanned printout or a phone photo only contains a picture of the text, and every figure in it has to be guessed. How to tell the two apart in three seconds.
The HDFC statement never leaves your PC
Greenote processes the statement on your own machine and sends it nowhere. Your firm stays the data fiduciary for your client's bank data, which is the answer a client actually wants when they ask where their statement goes and who stores it. Greenote is a pass-through to Tally, not a place your client data lives.
7-day free trial, no card required. Works with Tally Prime and ERP 9.
HDFC statement to Tally: common questions
- Can I convert a HDFC statement PDF to Excel?
- Yes. Greenote exports a formatted Excel workbook from a HDFC Bank statement, containing the full transaction ledger plus category and party summaries, daily balances and separated sheets for cash, transfers and income. The conversion runs on your own PC and the statement is not uploaded anywhere. Posting the same data into Tally is a separate step you do not have to use.
- Can Greenote read a HDFC Bank statement PDF?
- Yes. Greenote has a reader tuned specifically to HDFC Bank statements and handles all 2 layouts currently in circulation. Give it the PDF you downloaded from net banking and it produces dated, signed transactions with the narration intact.
- Which HDFC statement format should I download?
- Download the statement as a PDF or Excel file directly from net banking. A text PDF carries the real characters, so it can be read exactly. A scan or a phone photo of a printout carries only an image of the text and has to be guessed at, which is where accuracy is lost.
- Does my client's HDFC statement get uploaded anywhere?
- No. Greenote runs on your Windows PC and processes the statement there. The file is not sent to Greenote servers or any third party, and the only thing Greenote talks to is your local Tally. That keeps your firm the data fiduciary for your client data under the DPDP Act.
- Does it work with Tally Prime and Tally ERP 9?
- Yes, both. Greenote builds the correct voucher XML for the version you are running and posts all seven voucher types, with GST handled where it applies.