Tuesday, October 16, 2018

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.

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

Thursday, October 11, 2018

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.