Import Stock-Item master data from Excel into Tally

UDIMagic || Excel to Tally

Here's a sample Excel-sheet that contains Stock-Item Master data along with some advanced features as given below:-

a) Price List
Tally Software provides a feature called Price-list wherein users can define different price structures/level for different purposes, generally for different Group of Customers requiring different discounts. To enable this feature in Tally 9, use option:-

"Gateway of Tally -> F11 -> Inventory features -> Use Multiple Price Levels" and set it to YES.

This prompts you for "Company Price Levels" dialog-box. Create a PRICE-LEVEL called MRP, that will be used while importing data from Excel sheet. The sample Excel sheet provided herewith contains MRP (Column R) and Discount (Column Q) which is imported into the PRICE-LEVEL feature using UDI-Magic.

b) Specify default Ledger Allocation for Invoicing
This feature allows you to specify the default Ledger Allocation for each Stock-item along with the VAT-classification for it. The sample Excel sheet provided herewith contains the default Ledger-name (see Column D); VAT-class (see Column E) and Posting (see Column F).

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 -> Master".
5) 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.
6) Next, follow the instructions given in the wizard-screen to import data into Tally.

PS:
a) You must manually enable the features "Price-List" and "Specify default ledger allocation for Invoicing" as specified above.

b) The XML tags are provided in a separate file. While importing data into Tally using UDIMagic, you must select the XML tags file also in the same screen wherein you are prompted to select the Excel Sheet.

Unleash the power of UDIMagic
UDI-Magic is a simple yet powerful utility that allows you to Import any type of data into Tally Software that can be manually entered into Tally Software.

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.

Import Customers and Suppliers Masters from Excel into Tally

UDIMagic || Excel to Tally

Here's a sample Excel-sheet that contains Customer and Supplier Ledger Masters. 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 -> Master".
5) 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.
6) Next, follow the instructions given in the wizard-screen to import data into Tally.

PS:
The XML tags are provided in a separate file. While importing data into Tally using UDIMagic, you must select the XML tags file also in the same screen wherein you are prompted to select the Excel Sheet.

---

Import Credit Notes from Excel into Tally

UDI-Magic || Excel to Tally

Here's a sample Excel-sheet that contains Credit Note Vouchers of an Advertisement firm. 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 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.
6) Next, follow the instructions given in the wizard-screen to import data into Tally.

Remarks:-
The ZIP file contains 3 files viz:-
a) circulation-credit-notes.xls (Excel-sheet)
b) circulation-credit-notes-xml-tags.xml (XML-tags file)
c) circulation-credit-notes-macro.txt (Macro file)

XML-Tags
Normally, in the previous samples the XML tags were written in the Excel-sheet itself (i.e. in the comments section of cell A1). However, in this case the XML-tags are provided in a separate file, hence you must specify the XML-tags file when prompted in the UDIMagic wizard screen.

Macro-file
This sample contains a macro-file which does some calculations at run-time. This is required as the Voucher-totals are not manually added and are calculated at run-time. VBA (or Macros) is a very powerful feature in MS-Office applications that allows you to automate tasks. UDIMagic uses this feature to manipulate Excel-sheet data at run-time to perform calculations; add new columns etc.

---

Sales Vouchers with Salesman UDF

UDIMagic supports import of Masters and Vouchers data from Excel to Tally. It also supports UDF (user-defined fields) created using Tally Definition Language (TDL).

A sample Excel sheet "Vouchers - Sales Transactions with Salesman UDF" has been provided for evaluation. To use it, you must download both the Excel sheet and the TDL file. The links for downloading the Excel sheet; TDL file are given in my earlier post "Sales Vouchers with Salesman UDF".

Further, you need to enable the Salesman UDF using the F11 [features] key. For more details in this TDL (Salesman UDF), refer our blogsite tdlplayground.

---

Error: Programmatic access to visual basic project is not trusted

If you are using macros (VBA code) with UDIMagic, you may get the above error-message if you are using Office 2003 or above.

Here's how you can solve this issue:-

1. Open Excel
2. Goto Tools -> Macros ->Security
3. In the Security Window choose the Trusted Publisher Tab
4. Click "Trust Access to Visual basic Project" and enable it.
   
5. Click OK.
6. Close Excel.

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.

Remarks:-
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.

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