Tuesday, March 4, 2008

Import Receipt Vouchers from Excel into Tally

UDIMagic || Excel to Tally

Here's a sample Excel-sheet that contains Receipt Vouchers of an Advertisement firm. Follow these steps to import Receipts Vouchers from this Excel-sheet in 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.

UDIMagic is a simple and robust utility. It allows you to import any data from Excel into Tally including both Masters and Vouchers.

How does UDIMagic work ?
You may have Excel-sheet format with any type of Vouchers or Masters. UDIMagic can process it and send it to Tally within seconds.

UDIMagic uses XML tags to identify and read the Excel sheet data. End-users who are not familiar with XML tags, can take assistance of our professionals who provide XML tags for any type of data that you may have in your Excel-sheet.

The XML tags basically tell UDIMagic what data you have in you Excel sheet and where is it stored ? To get more information on XML tags, refer topic Understanding UDIMagic XML tags

No comments: