How to import HDFC Bank Excel statement directly to Tally Prime or ERP 9 using Synergy Automation. No XML needed.
How to Download HDFC Bank Statement as Excel
Where to find it: Net Banking → My Accounts → Account Statement → Excel format
File format: HDFC Bank net banking exports statements as .xlsx files. Columns: Date, Narration, Value Dat, Debit Amount, Credit Amount, Chq/Ref Number, Closing Balance.
Step-by-Step: HDFC Bank Statement to Tally
- Download your HDFC Bank statement
Go to Net Banking → My Accounts → Account Statement → Excel format. Select your date range and download as Excel (.xlsx or .xls). - Open Synergy Automation
Make sure Tally is open with the correct company. Make sure the Synergy Connector is running on the same PC. - Upload the Excel file
Drag and drop your HDFC Bank Excel file into Synergy Automation. The system auto-detects the format. You will see all transactions parsed and listed. - Review every entry
Check narrations, amounts, dates. Assign Tally ledger accounts. Skip any entries you do not want in Tally. - Post to Tally
Click Post. Entries appear instantly in your open Tally company as bank payment and receipt vouchers. No XML, no file, no import dialog.
HDFC Bank-Specific Notes
- HDFC uses "Value Dat" (not "Value Date") as the column name — Synergy handles this automatically
- Narrations include UPI IDs, NEFT reference numbers, and branch codes — edit in the review table before posting if needed
- Credit card payment entries appear as "CC PAY" in narration — assign to your credit card liability ledger
- EMI debits appear as "EMI AMT" — assign to the relevant loan account ledger
Common Ledger Assignments for HDFC Bank Transactions
| Narration Contains | Suggested Tally Ledger |
|---|---|
UPI | Assign to the specific party or UPI Expenses |
NEFT/RTGS | Assign to the party name in the narration |
ATM | Cash Account |
INTEREST | Bank Interest Received or Bank Charges |
CHG | Bank Charges |
Use these as a reference when assigning ledgers in the review table before posting to Tally.
Frequently Asked Questions
Q: Does Synergy Automation work with HDFC Bank statement format?
Yes. Synergy Automation automatically detects the HDFC Bank Excel statement format and parses columns correctly. No manual column mapping needed.
Q: Do I need to convert HDFC Bank statement to XML before importing to Tally?
No. Synergy Automation posts entries directly from Excel to Tally — no XML file is created or needed. This is faster and simpler than traditional XML import methods.
Q: Is this free for HDFC Bank statements?
Yes. Synergy Automation is free to use. No limits on banks, entries, or companies.