Get.. Tally.ERP9 Book @ Rs.550 and TallyPrime Book @ Rs.600


TallyPrime Book @ Rs.600
Tally.ERP9 Book @ Rs.550



'Export and Import Data & Vouchers'@ Tally.ERP 9

We will now learn about Tally.ERP 9s export and import capabilities, which enables Tally.ERP 9 to interact globally. Statements and data from Tally.ERP 9 can be exported to other programs like spreadsheets and databases. Only data from Tally.ERP 9 can be imported and not data from other systems. Importing from other systems involves the usage of ‘Tally.ERP 9’s Definition Language’ TDL and this is outside the scope of this training.


1. Export of Data


You might need to export information for different purposes, viz:


To re-import data into another company run on Tally.ERP 9.

To export data out to be used by other programs.


 2. Exporting Masters


Step 1:


Go to Gateway of Tally.ERP 9 > Display > List of Accounts > click on Export.


Tally.ERP 9 first asks for the export format. The different formats are, ASCII, EXCEL, HTML and XML. The filename extension will take the default format.

For example, since we have selected XML, the filename displayed will be Master.xml

Type of Masters – Any of the mentioned master types can be exported. Select All Mas- ters and accept it to Export.


 3. Exporting Data for Re-import into another Company


Step 1: Exporting Daybook


Go to Gateway of Tally > Multi Account Printing > Daybook > click on Export.


Tally.ERP 9 first asks for the language. Select Default (All Languages), then convert it into the export format. The different formats are: ASCII, EXCEL, HTML and XML. The filename extension will take the default format. For example: Selecting ASCII, results in the filename being displayed as Daybook.txt.


Accept to export, Data exported from a company can be imported into another.


 4. Import of Data [ Importing Master ]


Step 1: Importing Masters

Return to the Gateway of Tally.

Shut National Traders and load Indus Enterprises (Ensure that it has the same financial year as the current company National Traders).

Select Import of Data > Masters

Type in the file name. The name and path of the source file should match. In this case the current directory is in use, hence you do not need to give the path.


The opening balance can be modified from the exported source file. Carefully select, Modify with new data.



Verify that the import is completed successfully.

Note :


Data can be imported from the previous version, provided the Import filename is in the XML format, since Tally.ERP 9 supports only the XML Format.

5. Import of Data [Importing Vouchers]


Return to the Gateway of Tally.

Select Import of Data > Vouchers.

Give the filename Daybook.xml.

Check the statistics after import.


 6. Export to Excel


Tally.ERP 9 now comes with the functionality, wherein all reports can be exported to Microsoft Excel spreadsheet. This feature enables you to export any report generated by Tally.ERP 9 into Excel.


To export the Trial Balance,


Go to Gateway of Tally > Display > Trial Balance


Click on Export.

Select Restricted (ASCII only).

Select Excel (Spreadsheet) in Format.

Type the name of file for Output File Name as required.

Specify other details.

Click Yes for Export.

By default, the exported report in Excel format is saved in the Tally.ERP 9 folder. Open

this file using MS-Excel to view the report.


Get.. TallyPrime-3.* Book (Advanced Usage)

Get.. TallyPrime Book (Advanced Usage) @ Rs. 600

Get..Tally.ERP9 Book (Advanced Usage) @ Rs. 550



Get..TallyPrime 4.1 Book (Advanced Usage)
@ Rs. 800 !

Covering... 25 Chapters + 53 Practical Assignment

Buy Now

Get.. TallyPrime 4.0 Book (Advanced Usage) @ Rs. 800

Get..TallyPrime-2.1 Book (Advanced Usage)
@ Rs. 600 !

17 Chapters in TallyPrime Book + 45 Practical Assignment with GST in TallyPrime & All features are described with Practical Problems with Solutions.

Buy Now

Get.. TallyPrime Book (Advanced Usage) @ Rs. 600

Disclaimer :
The names of Companies and persons used in this Website have been used for illustrative purposes only.
The visitors may visit , the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademark :
Tally,TallyPrime,Tally GST,TallyERP9 GST, Tally9, Tally.ERP, Tally.ERP –9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners. This Website is not associated with any product or vendor mentioned in this Website.
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID :
Web :
Mob : 09437264738

| About | Privacy Policy | Tally.ERP 9 Book ORDER | TallyPrime 4.0 Book ORDER | TallyPrime-2.1 Book ORDER |
© 2023 :