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.

udiMagic v9.0 Release 2.2

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

Fixes:
While importing data from Excel to Tally using udiMagic, if there is an invalid XML character in the Excel sheet, the whole batch / bunch of records is not uploaded into Tally. Also, udiMagic does not display any error message. This has now been rectified in udiMagic v9.0 r2.2 and an error message "Unable to to XML tags" is displayed if an invalid XML character is found in the Excel sheet. The xml details are written to "parse.err" file.

udiMagic v9.0 Release 2.1

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

TEMPLATEs (Modifications)

1. Vouchers-V9-Sales-Purchase.xls

Fixes:
The Round Off ledger amount is not displayed correctly in the Voucher modification screen in following cases:
a. Purchase with Items + Voucher Mode
b. Purchase without Items + Voucher Mode

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

Fixes:
The Round Off ledger amount is not displayed correctly in the Voucher modification screen in following cases:
a. Purchase with Items + Voucher Mode
b. Purchase without Items + Voucher Mode

3. Vouchers-Stock-Journal.xls

This format now supports Material IN and Material OUT vouchers also. A new column to specify the Party Ledger Name has been added in this template.

udiMagic Limited Edition

The following features are now supported in udiMagic Limited Edition also :

1. Debugging
2. Undo Entries

udiMagic v9.0 Release 2.0

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

TEMPLATEs (Modifications)

1. Vouchers-V9-Sales-Purchase.xls

a. New Columns added under "Despatch details"

- Bill of Lading/LR No

- Date

- Motor Vehicle No

b. New Columns added under "Other ledgers before Tax"

- Cost Category (for all ledgers)

- Cost Centre (for all ledgers)

c. New Columns added under "Other ledgers after Tax"

- Cost Category (for all ledgers)

- Cost Centre (for all ledgers)

d. New Column added under "Tax Classification details"

- Override Voucher

PS: This must be used only if you want to override the Tax Classification details at the Voucher level.

e. Additional Cess (i.e Cess based on Quantity)

Under the GST regime, some products attract "Additional Cess" based on quantity (in addition to Cess based on value). This is now supported by udiMagic Standard template. Kindly note that the "Additional Cess" has to be specified as RATE/per unit.

f. Point of Sale (POS) feature

The POS feature is now supported which allows you to specify the following details :

- Gift Voucher details

- Credit/Debit Card details

- Bank Ledger details

- Cash Ledger details

g. Fixes

The Round Off ledger amount is not displayed correctly in Voucher modification screen in following cases:

a. Sales with Items + Voucher Mode + Round Amount is Negative

b. Sales without Items + Voucher Mode + Round Amount is Negative

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

Fixes: 

The Round Off ledger amount is not displayed correctly in Voucher modification screen in following cases:

a. Sales with Items + Voucher Mode + Round Amount is Negative

b. Sales without Items + Voucher Mode + Round Amount is Negative

3. Vouchers-V9-Financial-Transactions-Advanced.xls

In this template, you can now specify "Multiple Cheques/Instruments" against a single Bank ledger.

4. Master-StockItemMaster.xls

a. New Column added

- Enable Cost tracking

- Rate per Unit (under Price levels)

b. Bill of Materials (BOM)

The BOM feature is now supported.

5. Vouchers-V9-Sales-Purchase-Horizontal-Basic-without-Stockitems.xls

Fixes: 

The Round Off ledger amount is not displayed correctly in Voucher modification screen in following cases:

a. Sales with Items + Invoice Mode + Round Amount is Negative

b. Sales without Items + Invoice Mode + Round Amount is Negative

6. Vouchers-V9-Sales-Purchase-Horizontal-Advanced-without-Stockitems.xls

Fixes: 

The Round Off ledger amount is not displayed correctly in Voucher modification screen in following cases:

a. Sales with Items + Invoice Mode + Round Amount is Negative

b. Sales without Items + Invoice Mode + Round Amount is Negative

udiMagic v9.0 Release 1.9

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

NEW TEMPLATEs

1. Vouchers-V9-Sales-Purchase-Horizontal-Basic-without-Stockitems.xls

You can use this template to import Sales, Purchase, Debit Notes, Credit Notes (all without StockItems).

The new feature in this template are as follows :
a. Invoice Mode : You can specify whether to import voucher as "Accounting Voucher" or "Invoice Voucher"
b. You can now map this Standard template to your Excel sheet.

This template replaces the old template named "Vouchers-V9-Sales-Horizontal-format-without-stockitems.xls" and "Vouchers-V9-Purchase-Horizontal-format-without-stockitems.xls" which did not support mapping.

2. Vouchers-V9-Sales-Purchase-Horizontal-Advanced-without-Stockitems.xls
This is the advanced version of the previous template. It additionally supports Cost Category, Cost Centre also.

TEMPLATEs  (Modifications)

1. Vouchers-V9-Sales-Purchase.xls
New Column added : A new column has been added to specify "Invoice Mode". i.e whether to import voucher in "Accounting Voucher" or "Invoice Voucher"

Fixes: While importing Sales/Purchase without Stockitems, the Cost Centre details were not imported / reflected in Tally. This has now been rectified.

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

New Columns added

a. Party Ledger Alias :  You can now specify the Party Code / Alias in this column.

b. Invoice Mode :  You can specify whether to import voucher as "Accounting Voucher" or "Invoice Voucher"

3. Vouchers-V9-Sales-Horizontal-format-without-Stockitems.xls

New Columns added

a. Nature of Return

b. Debit/Credit Note No

c. Date

d. URD-Original Sale Value

PS:

This template has now been moved to the folder c:\udiMagic\templates-discontinued". Kindly use the new template "Vouchers-V9-Sales-Purchase-Horizontal-Basic-without-Stockitems.xls" or "Vouchers-V9-Sales-Purchase-Horizontal-Advanced-without-Stockitems.xls".

4. Vouchers-V9-Purchase-Horizontal-format-without-Stockitems.xls

New Columns added

a. Nature of Return

b. Debit/Credit Note No

c. Date

d. URD-Original Sale Value

PS:

This template has now been moved to the folder c:\udiMagic\templates-discontinued". Kindly use the new template "Vouchers-V9-Sales-Purchase-Horizontal-Basic-without-Stockitems.xls" or "Vouchers-V9-Sales-Purchase-Horizontal-Advanced-without-Stockitems.xls".

5. Vouchers-V9-Financial-Transactions-Single-line-entry-Advanced.xls

Fixes : While mapping, error "Nesting of Formula too deep" appears. Now rectified.

6. Vouchers-V9-Financial-Transactions-Single-line-entry-Basic.xls

Fixes : While mapping, error "Nesting of Formula too deep" appears. Now rectified.

7. Master-LedgerMaster.xls

New Columns added

a. Mailing Name

b. Assessee of Other Territory

c. Consider Party as Deemed Exporter for Purchases

d. Is a transporter

8. Master-StockItemMaster.xls

Fixes : Incorrect formula / typo for GSTDETAILS. Rectified in v9.0 r1.8