Get..Tally.ERP9 Book + GST Assignment @ 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..Tally.ERP9 Book + GST Assignment @ Rs. 550
 
 

Get..Tally.ERP9 Book + GST Assignment @ `. 550 !

15 Chapters in Tally.ERP9 Book + 21 Chapters in GST Practical Assignment on GST in Tally.ERP9 & All features are described with Practical Problems with Solutions.

Buy Now


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

Trademark :
Tally,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.
SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738

© 2019 : www.tallyerp9book.com

Tally.ERP9 Book CONTENT Tally.ERP9 Book ORDER