udiMagic Release Notes

We recently evaluated the udi-Magic Software by importing bulk records from Excel into Tally ERP 9 . For your reference, here are the results of uploading a sample Excel sheet with 5200 Voucher records : Excel to Tally ERP 9 performance evaluation udi-Magic Release Excel and Tally Release  Time to upload (5200 Voucher records) v8.0 R3.4  Excel 2016; Tally ERP 9 Release 6.1.1 6 min 53 secs v8.0 R3.5 Excel 2016; Tally ERP 9 Release 6.1.1 3 min 24 secs As it can be seen from the above results, udi-Magic v8.0 r3.5 saves considerable time as compared to the previous udi-Magic Release. Those using udi-Magic v8.0 can upgrade to the latest release of udi-Magic Software. Download link for udi-Magic v8.0 Release 3.5   

How to map your excel file and import it into Tally ERP 9? Here's a video on how to  map excel file and import it in Tally ERP 9 For reference, the steps are given underneath : Steps to Map your Excel file Start udi-Magic converter Select the option Excel to Tally > Create a Custom template Select the files : udi-Magic Standard Excel template Your Excel file Map the columns Save the Mapping file Steps to Import data into Tally Start Tally ERP 9 and Open a Company. Start udi-Magic software. Select the option Excel to Tally > Import data into Tally. Select the files Your Excel file Xml file (Mapping file generated in the mapping process) Click the Start button.

Excel to Tally templates Applicable to : udi-Magic v8.0 Release 3.4 Description : Compatible with Tally ERP 9 Release 6.1.1 NEW FEATURES udi-Magic v8.0 Release 3.4  now supports Trade Discount  feature which allows you to specify the discount value for each item in the invoice, and the discount value is considered as part of the assessable value of an item. The Trade discount feature is available in the following Excel formats : a. Vouchers-V8-Sales-Purchase-Basic.xls b. Vouchers-V8-Sales-Purchase.xls In addition to the Trade discount  feature, some modifications are done in other templates as shown underneath. TEMPLATEs  (Modifications) 1. Vouchers-V8-Sales-Purchase.xls The following new fields/features have been added in this template : Field : IsAlternateUnitApplicable Desc : This is useful when you are using alternate units in Tally ERP 9. You must specify Yes  to use alternate units. Values : Yes or No Default Value : No Remarks: a. Th...