Monday, March 31, 2008

Import Purchase Vouchers data from Excel into Tally

UDIMagic || Excel to Tally

Here's a sample Excel-sheet that contains Purchase Vouchers with VAT and Discount. 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) Minimize Tally Software
4) Run UDIMagic utility, select option "Excel to Tally -> Voucher".
5) Next, select the Excel sheet.
Remarks:- The XML tags in this case have been written in the Excel-sheet itself. Hence, you must uncheck the option "Use separate file for XML tags" while using UDI-Magic.
6) Next, follow the instructions given in the wizard-screen to import data into Tally.

No comments: