Go to Home Page
 
 

SEARCH

Advance Search


Tell A Friend

SEARCH

Category:

Sub Category:

Keyword:

HOW TO EXPORT AND IMPORT OF DATA in Tally.ERP 9

EXPORT AND IMPORT OF DATA

ArticlesTally9/16/2011Printable Version: 'HOW TO EXPORT AND IMPORT OF DATA in Tally.ERP 9'


EXPORT AND IMPORT OF DATA

Before exporting, the data from one company to another company follow the steps.
Take a data-backup of existing company (original company).
Then create a new company with the same similar name, with same financial year and Currency symbol.
Once the new company is created check both the companies F11 Features, it should be same( that is F1,F2 and F3)

Export and Import of Data from existing company to New Company.

From the Existing company Go to Gate of way of Tally-- Display--List of accounts and press enter

From the List of Accounts Screen, press Alt+E or Click on Export, option on the left hand side.

In the Exporting list of Ledgers press, back space key
Language--- Default (All Languages)
Format-----XML (data interchange)
Export Location:C:\Tally.ERP9 (1.82) or Tally folder path
Output File name---- Matster.xml
And Type of Maters select All masters.And Press enter to continue.

After exporting all the masters from the existing company, again come back to gateway of Tally.

From the Existing Company Go to Gate of way of Tally--Display--Day Book---Press Alt+F2 and give a period from starting to till date or the end of the year Date.
And Press Alt+E to export all the vouchers,

Language--- Default (All Languages)
Format-----XML (date interchange)
Export Location:C:\Tally.ERP9 (1.81) or Tally folder path
Output File name----daybook.xml
And select Vouchers to show =All Vouchers
You can set all other options in to yes.

Press enter to continue…
After exporting the vouchers from the Day book.

Go to gateway of Tally. And create a new company with similar Name with the same Financial year and F11 Features.

Select the both the companies. As shown above.
And New Company should be highlighted.
In the Gateway of Tally Press enter on import of Data-masters---.import file name will be master.xml.
And treatment entries already existing-Modify with new Data.

Once we press enter from the above screen, Tally will start importing all masters and Ledgers to new company, and it will take some time to import the data.

After 100% importing masters to new company.

From the Existing company Go to Gate of way of Tally-- Display--List of accounts and press enter and check the total Groups and Ledgers, It should be equal to the original company.

Then again, come back to gateway of Tally.

From the Existing new company Go to Gate of way of Tally-- import Of Data-- Vouchers--Press enter

In the Import of vouchers, Screen enter the file name as: daybook.xml

If the file name be daybook.xml. and press enter to continue
Tally will start importing all the vouchers to new company. So it will take some time to import.
Note: at the time of importing the vouchers to new company, you can check in the background the date is changing.

Once importing data is over you can check in the gateway of Tally, the date of last entry in both the companies should be same.
After Importing 100%.

Go to Display--statement of accounts---Statistics - press enter. And press alt+c and select the old company give a period from beginning to till date and check.
In the both the companies Vouchers types and maters should be Equal as shown bellow.

After this, you can check any other report like balance sheet, Trail balance, with parent company and the new company.
 

Related Tags for 'HOW TO EXPORT AND IMPORT OF DATA in Tally.ERP 9' Tally.ERP 9 Silver, Tally.ERP 9 Gold, Tally.ERP 9 Auditor Edition, Tally.ERP 9, Tally.ERP 9 Single User, Tally.ERP 9, Multi User, Tally.Net Subscription, Tally.ERP 9 Reseller in Delhi NCR, Tally Authorised Sales & Service Partner in Delhi NCR, What is the Price of Tally.ERP 9 Silver, Gold & Auditor Edtion