Skip to Article Skip to Youtube

How to transfer Masters from a Company to another one in Tally ERP 9


When business people start accounting in a new Company in Tally ERP 9, they can import the Masters like Ledgers, Stock Items etc if they have already done last year accounting in Tally Accounting Software, instead of creating all the Masters from the scratch.

How to Export Masters like Ledgers, Groups, Stock Items in Tally ERP 9
Exporting all the Masters like Ledgers, Groups, Stock Items etc., in XML format in Tally ERP 9

It can be done with the help of Export and Import of Data features available in the Tally software.

How to export Masters (Accounting, and Inventory) in Tally ERP 9

Before we import the Masters into the new Company we must extract the Masters from the old Company using the Export option. In Gateway of Tally screen

  1. Choose Display option.
  2. List of Accounts
  3. Press Alt + E Keys or click on E : Export button laid in the Horizontal Button Bar.
  4. In the Export Report screen press Backspace Key.
  5. As Tally ERP 9 supports XML file format for data interchange, choose XML (Data Interchange) from the list of formats in Format field to export the masters.
  6. Specify the Disk Drive Path where the xml file to be created in the Export Location field.
  7. Choose All Masters in Type of Masters field.
  8. Set Yes for Export Closing Balances as Opening field.
  9. And enter the date upto what date the closing balances to be take for the Masters in To Date field e.g. Financial Year end date 31-3-14.

Accept the screen to create the xml file which is known as the exported file.

How to Import Masters in new Company in Tally ERP 9

After exporting process is completed come back to the Tally ERP 9 and switch to the new Company in which company you want to import the Masters. In Gateway of Tally

How to import Masters like Ledgers, Groups, Stock Items in Tally ERP 9
Importing Masters like Ledgers, Groups, Stock Items etc., from XML format in Tally ERP 9
  1. Select Import of Data.
  2. And go with Masters.
  3. You will see a screen where you need to provide the file name of your exported XML file name in Import File Name (XML) field. e.g. filename.xml.
  4. And select the option as per your requirement for the Treatment of entries already existing.
  5. Choose any one of the following Behaviour options for Treatment of entries already existing.
    • Combine Opening Balance option will enable to import data of different branches and consolidate the opening balances. You can also select this option when the opening balances of existing masters are Zero and need to be overwritten by the balances in the data being imported.
    • Ignore Duplicates option imports all the Masters without considering the duplicates Masters are available in the importing company.
    • Modify with New Data option is to replace the existing balances with those existing in the data imported and also overrides the other options available in Behaviour list.

So, as the final output you can see the number of all the Ledgers in your new company without creating them from scratch and using Transfer method by XML Export and Import options available in Tally ERP 9 form one company to another company.

Labels:
is the founder of AccountsGuy.Net with the view of providing Accounting and Technical support using Accounting package Tally ERP 9, and Office Tools to the people. I write articles on Accounts, Blogging, Computer Operating, and technical issues and some of my experiences on them for students, beginners. Follow our Networks or sing-up for the email newsletter below for your daily dose of Tips and Tricks.
Subscribe To Newsletters

{ 11 Comments... read them below or add one }

Anonymous said...

sir, i am not able to carry my closing balances to the new company as i am not getting the option of carrying forward the balances. pls help

Venkateswarlu Kake said...

Dear Visitor, Happy to answer your query please login before commenting. And You need to check your Tally Release. In old releases you can't get such option. So, Update your Tally Software with new one.

Anonymous said...

Dear Sir,
I exported & imported all masters such as groups, ledgers, stock items, stock groups, cost centres & cost categories etc from old Company to New Company.
I succeed to import all the above masters excecpt Ledgers, only some ledgers are imported. What is the problem. Would you like to suggest and help me?
Thanks & Regards

Venkkatesh K said...

If you are created Custom Group in your New Company, which you have created in the Old Company then you can't import that particular ledger/s in your new company.

jyoti malvi said...

i wntd to import the entries made in one ledger of the co to new co?

i m nt able to do so? y ?

jyoti malvi said...

I have solved my query on my own... and hav understood the difference between importing the master and a voucher.. thanks newys

Venkkatesh K said...

Really that is great!

Sugandha Kapila said...

Dear sir,
i want to transfer only the stock items from one company to another using above method, which i am unable to do. What can be the reason ?

Venkkatesh K said...

Dear Sugandha Kapila,

Choose List of Accounts from Display Menu. Try to export and choose "Stock Items" for Type of Masters field.

Ravikumar R said...

Dear Sir,

How to transfer a particular month of sales / purchase from one company to another company pls help

Venkkatesh K said...

Dear Ravinkumar R,

First load the 2 companies.
Open the already created Voucher entry in Alteration mode.
Press F3 function key and chose another Company.
And Save the Voucher Entry.

Do this process for every Voucher Entry for the particular month.

Post a Comment

How do you feel about this Blog Post.