Excel To Tally ERP 9, Excel to Tally Import, Excel to Tally, udiMagic Excel to Tally

How to ?

Merge data in Tally.ERP 9

How to merge data in Tally.ERP 9 ?

Assuming, you have two companies viz Company No 1 and Company No 2 and you wish to transfer all the data of Company No 1 into Company No 2.

Steps :-

  1. Open Company No 1 and Export data from Tally ERP 9 in XML format including dependent masters
    a) Use option “Gateway of Tally >> Display >> Daybook”
    b) Set the period using Alt+F2
    c) Next, press Alt+E to export the Tally.ERP 9 data into XML format including dependent masters.
    d) This will generate a file named “daybook.xml” in the Tally folder.
  2. Open Company No 2 and Import data into Tally.ERP 9 in Company No 2
    a) Use option “Gateway of Tally >> Import of data >> Vouchers”
    b) Specify the file-name as “daybook.xml” and press enter to import data into Tally.ERP 9

Remarks:-
a) Take backup of your Tally Companies before merging for safety purpose.
b) After merge, the Company No 2 contains the data of Company No 1
c) The above has been tested with Tally.ERP 9 Release 3.0 with some test-data.

Merging in Tally.ERP 9 vs Tally 9

Tally.ERP 9 Release 3.0 provides an option to export vouchers along with the dependent masters. Hence, there is no need to separately export the masters as it was required previously.

Related Posts :-
How to copy / paste entries from one company into another by ApniTally

Free Tally tools

Export Tally data to Excel | Free tool

How can I export Tally data into Excel ?

You can use Tally ODBC feature supported by Tally Accounting software to get data from Tally into Excel. Alternatively, you can use this FREE Tally to Excel utility to get Tally data into Excel.

Supported Tally versions : Tally.ERP 9, Tally 9, Tally 8.1, Tally 7.2, Tally 6.3

Remarks:-
Tally ODBC does not expose all the fields of all tables / objects in Tally. Hence, you will be able to retrieve only the first level fields (limited fields) from Tally database tables / objects.

FAQs

Tally Server Port 9000

What is Tally Server Port 9000 ?

Just as you give your mobile number to others so that they can contact you, similarly to programmatically communicate with Tally, a Port Number (memory area) is required.

The default Port is 9000 which can be changed either using the option “Gateway of Tally > F12 > Advanced Configuration” or you can set it directly in the Tally.ini file using ServerPort=9000 option

How to ?

Merge two Stock Items in Tally.ERP 9

How to merge two Stock Items in Tally.ERP ?

Merging two Stock Items in Tally.ERP 9

It is assumed that you have two Stock Items viz “Item 1” and “Item 2” and you need to merge the “Item 2” into “Item 1” such that all the Vouchers having “Item 2” would show “Item 1” after the merge-process.

PS:
a) Take backup of your Tally data for safety purpose before trying out the underneath steps.
b) We have tested Merging of two stock items with Tally.ERP 9 Release 3.0 only

Step-by-step instructions:-

  1. Change Tally.ERP 9 configuration settings
    a) Select option “Gateway of Tally >> F12 >> General”
    b) Set the option “Overwrite Vouchers during Import” to Yes
  2. Set the period in Tally.ERP 9
    Select option “Gateway of Tally >> Alt+F2” and set the period. Example if you have vouchers for three years, set the period accordingly so that the whole data is accessible.
  3. Export Tally.ERP 9 data in XML
    a) Select option “Gateway of Tally >> Display >> Daybook >> Alt+F2” and set the full-period
    b) Next, export Tally.ERP 9 data using “Alt+E” in XML format.
  4. Make changes in XML data
    a) Open the file “Daybook.xml” in Notepad and find/replace all occurrences of the “Item 2” with “Item 1”.
    Remarks: The file daybook.xml is created in step-3 on exporting data  using Alt+E
    b) Save the Daybook.xml file
  5. Import data in Tally.ERP 9
    a) Select option “Gateway of Tally >> Import of Data >> Vouchers”.
    b) Specify the file-name (ex: daybook.xml) and press enter to import it.
  6. Verify the Vouchers in Tally.ERP 9
    Select option “Gateway of Tally >> Display >> Daybook” and check vouchers to verify the merging-process.
tally.erp

Tally.ERP – Master Name and Alias

Master Name and Alias both must be unique in Tally.ERP.Those shifting from other software to Tally.ERP find this to grasp. Here are some common issues faced while migrating data from other softwares into Tally.ERP

Automobile Industry
In Automobile Industries, the Part Numbers are unique but the Stock-Item Name i.e. Part-Name may be duplicate. Example :-

Part Number   Part Name
1001             O-Ring
1002             O-Ring

Solution
To import such Master data into Tally, a work-around is to concatenate the “Name – PartNumber” as shown below :-

Part Number      Part Name
1001             O-Ring - 1001
1002             O-Ring - 1002

However, there are lot many other things that need to be taken care-of else you may spend lot of pulling your hair. Consider the following Stock Item Names :-

Part Name
Oil Can 1.5 Ltrs
Oil Can 15 ltrs

Are the aforesaid two Stock Items same ? No. The first is “1.5 ltrs” can whereas the second is “15 ltrs“. However, Tally ERP considers both as same. Try creating the above two Stock Items in Tally.ERP and you get message “Duplicate Entry” while trying to enter the second item.

In brief, there are several characters like dot (.), hash (-) , spaces which are ignored by Tally.ERP in Master Names and Alias. This is applicable to all Masters including Stock Item Masters.

How to ?

Changing Ledger Allocation details for Stock-Items in Tally ERP

How can I change the Ledger Allocation details for multiple Stock Items in Tally ERP ?

Brief description of the Query
I am using POS Sales for invoicing. I have created a Voucher class (incl VAT), so that in the Invoice the rates are inclusive of all the taxes. When creating Stock-Items, I use the option “Set/Modify Default Ledgers for Invoicing” to specify the Ledger allocation for Sales Invoice as follows :-

Sales @ 13.5% == 88.1057

Output VAT @ 13.5% ==11.8943

Now as the VAT rates changed from 13.5% to 14%, I will have to manually alter each and every Stock-Item.  Around 6000 SKU’s comprising both items at 5% & 13.5% Vat rates.

Is there any solution to update the Ledger allocations details for multiple stock-items  together in  Tally.ERP ?

Solution
1) Take back up of Tally data (for safety purpose)
2) Use the option “Gateway of  Tally >> Display >> List of Accounts >> Alt+E” to export the STOCKITEM Masters in XML format.

Remarks: This will create a file named Master.xml. in Tally folder

3) Next, open the Master.xml file in Notepad and search/replace 88.1057 (whatever old rate is) with  New Rate. After this save, the Master.xml file

4) Next, import the Master.xml file into Tally using option “Gateway of Tally >> Import of Data >> Masters”
How to ?

VAT Classifications in Tally

How can I create a new VAT Classification in Tally ERP 9 ?

Though VAT classifications can be viewed using “Gateway of Tally >> Display >> Statutory Info >> VAT Classifications”, Tally ERP does not provide any user-interface or menu-option to create VAT Class.

A work-around is to create VAT Class using “Gateway of Tally >> Import of Data >> Masters” option.

Steps :-

1) Download and unzip the XML tags for creating VAT Class
2) Next, select option “Gateway of Tally >> Import of Data >> Masters”
3) Select the file VAT-CLASS.XML (which you have downloaded in step 1) to import it in Tally

Here’s the XML code to create VAT class for “Output VAT @ 14%” for Karnataka State.

<ENVELOPE>
 <HEADER>
 <TALLYREQUEST>Import Data</TALLYREQUEST>
 </HEADER>
 <BODY>
 <IMPORTDATA>
 <REQUESTDESC>
 <REPORTNAME>All Masters</REPORTNAME>
 <STATICVARIABLES>
 <IMPORTDUPS>Modify with New Data</IMPORTDUPS>
 </STATICVARIABLES>
 </REQUESTDESC>
 <REQUESTDATA>
 <TALLYMESSAGE xmlns:UDF="TallyUDF">
 <TAXCLASSIFICATION NAME="Output VAT @ 14%">
 <NAME.LIST TYPE="String">
 <NAME>Output VAT @ 14%</NAME>
 <NAME>Sales @ 14%</NAME>
 </NAME.LIST>
 <TAXTYPE>VAT</TAXTYPE>
 <SUBTAXTYPE />
 <MARKFORDELETION>No</MARKFORDELETION>
 <CLASSIFICATIONISSALES>Yes</CLASSIFICATIONISSALES>
 <ISCOMPOSITECLASSIFICATION>No</ISCOMPOSITECLASSIFICATION>
 <RATEOFVAT>14</RATEOFVAT>
 <!-- Add your State here-->
 <TAXCLASSIFICATIONSTATE.LIST>
 <STATENAME>Karnataka</STATENAME>
 <TAXCLASSIFSTATEPERIOD.LIST>
 <PERIODFROM>20110401</PERIODFROM>
 </TAXCLASSIFSTATEPERIOD.LIST>
 </TAXCLASSIFICATIONSTATE.LIST>
 </TALLYMESSAGE>
 </REQUESTDATA>
 </IMPORTDATA>
 </BODY>
</ENVELOPE>

 

Remarks :-
1) You can use “Gateway of Tally >> Display >> List of Accounts >> Alt + E” to export All Statutory Masters in XML format. This gives you the XML format supported by Tally. Modify it and you can create Statutory Masters as required.


How to ?

Load multiple companies on Tally Start-up

To load one or more companies when you start Tally, you must specify the Company Number in the Tally.ini file

Steps :-

1) Close Tally if it is running.

2) Next, open the Tally.ini file (from Tally folder) in Notepad.

3) Next, set the following :-

Default Companies=Yes
Load=10000
Load=10001

 

 

excel to tally

Excel to Tally

UDIMagic is a software utility which allows you to Import data into Tally Accounting Software.

It supports Import of data from various sources like Excel, SQL-Server, MySQL, Access, DBase, Foxpro, Visual Foxpro DBF’s and several other database formats.

It is simple to use, yet very powerful.

Works with all Tally versions (ver 6.3 onwards) including the latest release of Tally 9 and Tally ERP 9.

UDIMagic Versions

UDIMagic Light – To Upload Masters from Excel to Tally

UDIMagic Standard – To Upload Masters and Vouchers both from Excel to Tally

UDIMagic Professional – to upload Masters and Vouchers both from SQL Server into Tally, Access into Tally, Oracle into Tally etc.