Import ICICI Bank Excel statement directly to Tally Prime or ERP 9 with Synergy Automation. No XML export needed.
How to Download ICICI Bank Statement as Excel
Where to find it: ICICI Internet Banking → My Accounts → Account Statement → Download (Excel)
File format: ICICI Bank exports as .xlsx. Columns: Transaction Date, Value Date, Transaction Remarks, Cheque Number, Withdrawal Amount (INR), Deposit Amount (INR), Balance (INR).
Step-by-Step: ICICI Bank Statement to Tally
- Download your ICICI Bank statement
Go to ICICI Internet Banking → My Accounts → Account Statement → Download (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 ICICI 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.
ICICI Bank-Specific Notes
- ICICI uses "Withdrawal Amount" and "Deposit Amount" instead of Debit/Credit
- Narrations include IMPS/NEFT/UPI reference numbers
- iMobile statement downloads may have a slightly different format — use net banking Excel for best results
- FD interest credit appears as "INT PD" in narrations
Common Ledger Assignments for ICICI Bank Transactions
| Narration Contains | Suggested Tally Ledger |
|---|---|
IMPS | Party ledger or IMPS Transfers |
UPI | Specific party or UPI Expenses |
INT PD | Interest on FD Received |
NACH | EMI / Loan Account |
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 ICICI Bank statement format?
Yes. Synergy Automation automatically detects the ICICI Bank Excel statement format and parses columns correctly. No manual column mapping needed.
Q: Do I need to convert ICICI 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 ICICI Bank statements?
Yes. Synergy Automation is free to use. No limits on banks, entries, or companies.