Importing Standard Cost / Price data into Tally 9

When we import the Stock-Item Masters with Standard Cost /Price data into Tally 9, the existing Standard Cost / Price data gets overwritten.

For more information, please refer :-
Tally 9 Bug: Importing Stock Masters with Standard Cost / Price

UDIMagic v3.0 Release 1.50 comes with new functionality that allows you to import Stock Item Masters (with Standard Cost / Price data) into Tally 9 without overwriting the existing data.

---

Introducing UDI Magic [Light] version

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)

For Cost details, please refer www.rtslink.com/buy.html

For other terms and conditions, please refer www.rtslink.com/orderinfo.html

For learning "How to write XML tags ?", please refer www.learn-tally-xml-tags.blogspot.com

---

Purchase Vouchers with multiple VAT rates

Here's a sample Excel file that contains "Purchase" Vouchers with multiple VAT rates which are to be imported into Tally.

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

1) As macro file is used, you must enable the feature "Trust Access to Visual basic Project". Refer the FAQ: Trust Access to Visual basic Project

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 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) purchase-vouchers-with-multiple-vat-rates.xls (Excel sheet)
2) purchase-vouchers-with-multiple-vat-rates-xml-tags.xml (XML tags file)
3) purchase-vouchers-with-multiple-vat-rates-macro.txt (contains macros)

Shares Sales/Purchase transactions

Here's a sample Excel file that contains "Shares sale and purchase" transactions 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.
Though you can keep these files in any folder, the Macro-file must always be kept in the "c:\udi-magic" folder.

2) As macro file is used, you must enable the feature "Trust Access to Visual basic Project". Refer the FAQ: Trust Access to Visual basic Project

3) Start the Tally software and create/open a Dummy Company.
4) Minimize Tally Software
5) 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.

ZIP file contents
1) shares-sales-purchase-transactions.xls (Excel sheet)
2) shares-sales-purchase-transactions-xml-tags.xml (XML tags file)
3) shares-sales-purchase-transactions-macro.txt (contains macros)

Remarks:-

1) The following settings / options have been kept for Stock-Item masters:-
a) COSTING METHOD: FIFO
b) MARKET VALUATION METHOD: Avg. Cost
This can be changed as per requirement.

2) The Shares (per unit) cost is computed as follows:-
Purchase Price + Brokerage + ServiceTax + STT

3) The Shares (per unit) net Sales-realization value is computed as follows:-
Sales Price - Brokerage - ServiceTax - STT

4) The Firm-name (Share Broker-firm name) can be changed as per requirement.

---

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)

Learn Tally XML tags

Want to learn Tally XML tags and import Excel data into Tally...

Here's our new blog Learn Tally XML tags that attempts to teach you write XML tags to import data into Tally Software.

Sales Vouchers with multiple VAT rates

Here's a sample Excel file that contains "Sales" Vouchers with multiple VAT rates which are to be imported into Tally.

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

1) As macro file is used, you must enable the feature "Trust Access to Visual basic Project". Refer the FAQ: Trust Access to Visual basic Project

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 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-multiple-vat-rates.xls (Excel sheet)
2) sales-vouchers-with-multiple-vat-rates-xml-tags.xml (XML tags file)
3) sales-vouchers-with-multiple-vat-rates-macro.txt (contains macros)