Wednesday, March 5, 2008

Import multiple user-defined Receipt Vouchers from Excel to Tally

UDIMagic || Excel to Tally

This is in continuation of my previous post wherein we had provided a sample Excel sheet with Receipt Vouchers.

Herein, a sample Excel-sheet containing multiple user-defined Receipt Vouchers is being provided. Follow these steps to import data from this Excel-sheet into Tally Software.

1) Download the Excel sheet and copy it to "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". Next, select the Excel sheet when prompted.
5) Next, follow the instructions given in the UDIMagic wizard-screen to import data into Tally.

The XML tags are written in cell A1 (comments section) of the Excel sheet. Alternatively, we can write the XML tags in a separate file also.

No comments: