Import IDFC First Bank Excel statement directly to Tally Prime or ERP 9 using Synergy Automation. No XML file needed.
How to Download IDFC First Bank Statement as Excel
Where to find it: Net Banking / IDFC FIRST Mobile app - Accounts - Statement - Download as Excel
File format: IDFC First net banking exports .xlsx statements. Columns: Transaction Date, Value Date, Particulars, Cheque/Ref No, Debit, Credit, Balance.
Step-by-Step: IDFC First Bank Statement to Tally
- Download your IDFC First Bank statement
Go to Net Banking / IDFC FIRST Mobile app - Accounts - Statement - Download as Excel. 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 IDFC First 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.
IDFC First Bank-Specific Notes
- IDFC First uses "Particulars" as the narration column - Synergy detects this automatically
- UPI narrations carry the full VPA (e.g. name@okhdfcbank) - shorten in the review table before posting if you prefer cleaner ledgers
- Interest credits post monthly on savings accounts - assign to Bank Interest Received
- IDFC First shows separate rows for GST on bank charges - assign those to Input GST, not Bank Charges
Common Ledger Assignments for IDFC First Bank Transactions
| Narration Contains | Suggested Tally Ledger |
|---|---|
UPI | Assign to the specific party or UPI Expenses |
NEFT/IMPS | Party ledger named in the narration |
INT PD | Bank Interest Received |
CHRG/FEE | Bank Charges |
GST | Input GST (not 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 IDFC First Bank statement format?
Yes. Synergy Automation automatically detects the IDFC First Bank Excel statement format and parses columns correctly. No manual column mapping needed.
Q: Do I need to convert IDFC First 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 IDFC First Bank statements?
Yes. Synergy Automation is free to use. No limits on banks, entries, or companies.