HDFC Bank statement into Tally. Without typing it.
HDFC puts the payment type right in the narration — NEFT DR, UPI, ACH D, CHQ PAID. We read those codes, suggest a ledger for each entry, and post to Tally once you approve.
What HDFC statements put you through
Typing a 40-page current account statement by hand
Upload once. Every line is read for you.
Reading long narrations that wrap over three lines
Wrapped lines are joined back to their entry.
Mixing up Date and Value Dt and breaking your reco
The posting date is used. Value date is kept aside.
Cheque numbers losing their leading zeros in Excel
Reference numbers are kept exactly as printed.
Sorting salary, EMI and cheque entries one by one
Same-type entries group together. Set them in one go.
Unlocking the statement HDFC emailed you
Type the password once at upload. Done.
How to import an HDFC Bank statement into Tally
Works with the statement you download and the one HDFC emails you.
Download it from HDFC
In NetBanking, open Accounts, then Account Statement. Pick your dates and download as PDF or Excel.
Upload it
Drop the file in. If it is locked, type the password — HDFC usually uses your customer ID, or your name and date of birth together.
You check the ledgers
Each transaction comes with a suggested ledger. Because HDFC labels the type in the narration, salary, EMI and cheque entries group together and can be set in one go.
Post to Tally
Download the clean Excel, then let Tally Connector — our free Windows app — import it into your open Tally company. Choose your HDFC bank ledger and the receipts, payments and contras are created for you. No XML file to build, and Undo Import reverses the whole batch. Or just keep the Excel.
What we do with each HDFC column
HDFC uses the same seven columns in both its PDF and Excel statements.
| HDFC column | What it becomes |
|---|---|
| Date | Voucher date |
| Narration | Narration, and picks the ledger |
| Chq./Ref.No. | Cheque number, kept exactly as printed |
| Value Dt | Kept for your reference |
| Withdrawal Amt. | A payment entry |
| Deposit Amt. | A receipt entry |
| Closing Balance | Used to double-check every row |
HDFC credit card and demat statements look different. Send us a sample and we will tell you honestly whether they work.
Common questions
How do I import an HDFC statement into Tally?
Download it from HDFC NetBanking as PDF or Excel, upload it to SmartXtract, check the ledger suggested for each transaction, and post the approved entries into your Tally company.
Does it work with the locked statement HDFC emails?
Yes. Type the password when you upload. HDFC usually uses your customer ID, or your name and date of birth together.
Does it understand the HDFC narration codes?
Yes. NEFT DR, NEFT CR, UPI, IMPS, ACH D and CHQ PAID are all recognised as payment types, and the name after the code is used to pick the ledger.
My current account statement is 40 pages. Is that a problem?
No. Long statements are read page by page and checked against the balance throughout, so page 40 is as accurate as page one. Pages count against your plan.
Can I use the HDFC Excel file instead of the PDF?
Yes. XLS, XLSX and CSV all work, and go through the same ledger matching as PDFs.
Does it handle scanned HDFC statements?
Yes. Pages that are just images are read too, and those rows are checked against the closing balance to catch mistakes.
What does the free trial include?
20 pages, no card needed. Enough to run a real monthly statement start to finish.