Export of Vouchers Data

Select the option Display from the Gateway of Tally, then select Day Book. Press F2 to enter the period, during which the voucher entries passed will be exported. After entering the period press Alt + E or Export. It will take you to the export screen where you have to press Esc if you want to edit the default settings. Then there you have to enter the following details :

Format : Here you have to select the format of the data from the given list in which you want the report to be exported.

Output File name : In this option you have to enter the path of the file name where you want the data to be exported or stored.

At Report Configuration make the necessary changes as per your need.

"Select the Vouchers to show" : At this option select whether you want to export only Accounting entries or only Inventory related entry or both.

Export of Masters Data

Select the option Display from the Gateway of Tally, then select List of Accounts. Click on Export or press Alt + E. Then it will take you to the export screen where you have to press Esc if you want to edit the default settings. There you have to enter the following details :

Format : Here you have to select the format of the data from the given list in which you want the report to be exported.

Output File name : In this option you have to enter the path of the file name where you want the data to be exported or stored.

Type of Masters : Select from the given list the type of master you want to export.

Export of Report Data

In order to export report data open Tally, go to masters then select the report you want to get, that is balance sheet or profit and loss account etc. and then there you can either click on the Export Button or press Alt + E. It will take you to the export screen where you have to press Esc if you want to edit the default settings. There you have to enter the following details :

Format : Here you have to select the format of the data from the given list in which you want the report to be exported.

HTML Format resolution : If you select HTML in the above option then select a appropriate resolution for display of the report.

Output File name : In this option you have to enter the path of the file name where you want the data to be exported or stored.

Raw Data and Report Data

Report Data : It is a processed data from Masters and Vouchers of Tally. It helps in transferring the data of the vouchers that is Purchase voucher, sales voucher etc. and data from masters that is data of balance sheet, profit and loss account etc. It helps in transferring reports in electronic form.

Raw Data : It refers to the basic data from Masters and vouchers. Unlike Report Data it can be imported to Tally.

Export of Data

Export of Data : It means transferring of data of Tally from one machine to another or from Tally software to other application software. The uses of Export of data in Tally ar as under:

• Transferring the data to the companies Head Office or other branch.
• To get reports in Spreadsheet format.
• Tally helps in transferring the data to other application software in standard forms like SDF, XML etc. as Tally cannot be used in other software.

The formats used to transfer data in Tally are

1. SDF
2. ASCII
3. HTML
4. XML
   

Transferring data from Tally to MS-Excel

First open Tally 9 and select the company from which you want the data to be transferred. Then minimize Tally and open MS-Excel and click on Data as shown in the picture and then click on Import External Data.















Then click on New Database Query as shown in the picture.

















As you click on New Database Query it will ask you to Choose Data Source. There you have to select TallyODBC.

















Then select the column you want to include in the query.


Click Next after the selection is done. The data will be transferred to MS-Excel.

Procedure for using ODBC software for transferring data

Start Tally and select the company from where you want the data to be extracted. Minimize Tally and open ODBC compliant software.
Here I will explain it using MS-Excel.
Open MS-Excel and select the menu 'Data' at the MS-Excel window, then select 'Get external Data' then select 'New Database Query'. Then select "TallyODBC" of Database tab.
Tally then connects to data source and displays the 'Query Wizard'. Select the column you want to include.
Excel displays all the columns as the columns are selected.

Tally Open Database Connectivity(ODBC)

Tally data can be embedded into other ODBC compliant software like MS-Excel, MS-Word, Visual Basic, etc by installing Tally ODBC driver. Tally data driver can be made available to external applications. Tally Data can be viewed too.

Open Database Connectivity - ODBC

Any program like MS-Excel, Oracle, etc. that is ODBC compliant can use data from Tally as Tally is ODBC compliant. Any changes in Tally will be reflected in the ODBC compliant software as the data connectivity here in Tally is dynamic in nature. Through this facility data can be extracted from Tally and the report extracted can be designed as per the users requirement.