Import ICICI Bank statement from Excel to Tally

You can now directly import the ICICI [Current account] Bank Statement into Tally ERP using udiMagic Excel to Tally converter.

Download the Bank Statement Excel to Tally templates. 

Import ICICI Bank Statement from Excel to Tally

1. Start Tally and open a Company
2. Start udiMagic
3. Select option "Excel to Tally"
4. Select option "Import data into Tally"
5. Click the Browse button and select the Excel file "Vouchers-Bank-Statement-ICICI-Current.xls"
6. Select the XML file "Vouchers-Bank-Statement-ICICI-Current-XML-tags.xml"
7. Click the Start button

To view the data imported in Tally, use the option "Gateway of Tally | Display | Daybook"

If you do NOT have udiMagic Software installed in your computer, you must first download the udiMagic DEMO / Trial version. 

udiMagic v9.0 Release 2.3

udiMagic Excel to Tally Software
Applicable to : udiMagic v9.0 Release 2.3

NEW TEMPLATEs

1. Vouchers-Bank-statement-Single-Column-Dr-Cr.xls

This template is similar to the existing template Vouchers-Bank-statement.xls. The difference is that is contains only 1 column for Debit and Credit amounts.

2. Master-GSTClassifications.xls

This template allows you to create new GST Classifications in Tally ERP 9. To use the GST Classifications, you must first enable the GST feature and GST Classifications in Tally.

TEMPLATEs (Modifications)

1. Vouchers-Bank-statement.xls

Fixes: In some Bank statements, the amount greater than 1,00,000 has commas. This creates problem if you are using Excel 2007 or lower as the amount with commas is not converted to numeric value. In udiMagic v9.0 R2.3, we have this issue has been addressed and now even amounts with commas can be imported from Excel to Tally.

2. Vouchers-V9-Sales-Purchase-Basic.xls

Fixes: Discount ledger gets created even though the discount is not specified. This has now been resolved.

3. Vouchers-V9-Sales-Purchase.xls

Fixes: Discount ledger gets created even though the discount is not specified. This has now been resolved.