Sunday, June 8, 2008

UDI Magic [Light] is light-weight version of UDI Magic [Standard] . It supports Import of MASTER's from MS-Excel into Tally Accounting Software.

UDI Magic [Light] is a low-priced utility which is particularly useful for Customers who wish to Import only Masters from MS-Excel into Tally. It is also useful for Tally Professionals who wish to provide solutions to end-users for importing Masters data from Excel into Tally. However, it does NOT support import of Vouchers from MS-Excel into Tally.

Features- Supports import of all Masters from MS-Excel into Tally Software- Supports user-defined-fields created using TDL- Supports VBA (Visual Basic for Applications)(a powerful feature that is useful for performing calculations and manipulating Excel data at runtime)

2) Download and unzip the files into "c:\udi-magic" folder.Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder.

3) Start the Tally software and create/open a Dummy Company.4) Minimize Tally Software5) Run UDIMagic utility, select option "Excel to Tally -> Voucher".6) Next, select the Excel sheet and the XML-tags file when prompted.Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.

7) Next, follow the instructions given in the wizard-screen to import data into Tally.

3) Start the Tally software and create/open a Dummy Company.4) Minimize Tally Software5) Run UDIMagic utility, select option "Excel to Tally >> Voucher".6) Next, select the XML-tags file and the Excel sheet when prompted.Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.

7) Next, follow the instructions given in the wizard-screen to import data into Tally.

Tuesday, June 3, 2008

Here's a sample Excel file that contains "Sales" Vouchers with Multi-currency ; Cost Category and Cost Centres which are to be imported into Tally.

Follow these steps to Import the Excel sheet data into Tally Software.

1) Download and unzip the files into "c:\udi-magic" folder.2) Start the Tally software and create/open a Dummy Company.3) Enable the following features in Tally 9a) F11 -> Accounting Features -> Allow Multi-Currencyb) F11 -> Accounting Features -> Maintain Cost Centresc) F11 -> Accounting Features -> More than ONE Payroll / Cost Category

4) Minimize Tally Software5) Run UDIMagic utility, select option "Excel to Tally -> Voucher".6) Next, select the Excel sheet and the XML-tags file when prompted.Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.

7) Next, follow the instructions given in the wizard-screen to import data into Tally.

2) Download and unzip the files into "c:\udi-magic" folder.Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder.

3) Start the Tally software and create/open a Dummy Company.4) Minimize Tally Software5) Run UDIMagic utility, select option "Excel to Tally -> Voucher".6) Next, select the Excel sheet and the XML-tags file when prompted.Note that the XML-tags file is to be selected in the same screen in which you are prompted to select the Excel-sheet.

7) Next, follow the instructions given in the wizard-screen to import data into Tally.