udiMagic Release Notes

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 Start Tally and open a Company Start udiMagic Select option "Excel to Tally" Select option "Import data into Tally" Click the Browse button and select the Excel file "Vouchers-Bank-Statement-ICICI-Current.xls" Select the XML file "Vouchers-Bank-Statement-ICICI-Current-XML-tags.xml" 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 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 cr...

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 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.

The following features are now supported in udiMagic Limited Edition also : 1. Debugging 2. Undo Entries

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 "...

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 Ne...