udi-Magic v8.0 Release 3.5

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  

Map excel and import in Tally ERP 9

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

1. Start udi-Magic converter
2. Select the option Excel to Tally > Create a Custom template
3. Select the files :
   • udi-Magic Standard Excel template
   • Your Excel file
4. Map the columns
5. Save the Mapping file

Steps to Import data into Tally

1. Start Tally ERP 9 and Open a Company.
2. Start udi-Magic software.
3. Select the option Excel to Tally > Import data into Tally.
4. Select the files
   • Your Excel file
   • Xml file (Mapping file generated in the mapping process)
5. Click the Start button.

udi-Magic v8.0 Release 3.4

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. This option comes under "Other Settings"
b. You must use the EnableDisableFeatures sheet to show / display the columns for "Other Settings"

2. Vouchers-V8-Sales-horizontal-format-without-stockitems.xls
The following new fields/features have been added in this template :

• Buyer Name
• Addr Line1
• Addr Line2
• Addr Line3
• State
• Place of Supply
• GST Regn Type
• GSTIN

3. Vouchers-V8-Purchase-horizontal-format-without-stockitems.xls

The following new fields/features have been added in this template :

• Supplier Name
• Addr Line1
• Addr Line2
• Addr Line3
• State
• Place of Supply
• GST Regn Type
• GSTIN

4. Vouchers-V8-Journal-with-multiple-references.xls

This template now supports 10 ledgers with references. Earlier there was provision to specify 5 ledgers only.

Old template Name : Vouchers-V7-Journal-with-multiple-references.xls

New template Name : Vouchers-V8-Journal-with-multiple-references.xls