Tuesday, June 3, 2008

Sales vouchers with Multi-currency and Cost Category / centres

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 9
a) F11 -> Accounting Features -> Allow Multi-Currency
b) F11 -> Accounting Features -> Maintain Cost Centres
c) F11 -> Accounting Features -> More than ONE Payroll / Cost Category

4) Minimize Tally Software
5) 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.

ZIP file contents
1) sales-vouchers-with-multi-currency.xls (Excel sheet)
2) sales-vouchers-with-multi-currency-xml-tags.xml (XML tags file)

No comments: