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.

Excise Report

To view the Dealer Excise Report, go to Display from Gateway of Tally then go to statutory reports and then to Dealer Excise reports.
(Gateway of Tally -> Display -> statutory reports -> Dealer Excise reports)

There you can view two type of reports like Excise Stock Register and Form 2.

Form 2 is the return to be submitted by the dealer of excise duty every quarter.
Excise Stock Register shows the daily receipt and issue of excisable goods.

Excise invoice Printing

When the sales invoice has been made, you will require printout of the invoice from Tally. In order to print, press Alt + P at sales invoice screen. Then you will get the printing screen, you can find preview of excise invoice as per Rule 11 of the Central Excise Rule, 2002. Set the print configuration as desired. To select the excise duty break up and purchase details in Sales Invoice, you have to go to configure button(F12) and set the option "Print trader Supplier Info" to 'Yes'. The details of supplier, customer and manufacture are shown in the Sales invoice. The purchase and sales details of excise as well as the duty details are shown here.

Excise Details Entry in Invoice

Different type of invoice, like purchase, sales, Debit note and Credit note, can be created. First you have to select the Purchase voucher in Invoice mode. Then select the appropriate party account from the list, the party details screen will appear, enter the details there. Then you have to select the appropriate nature of purchase from the list. After that select the name of the item and enter the details in the excise details screen and accept the invoice.

Creation of Excise Voucher

You can create a new purchase voucher under the Purchase voucher and set the option "Use for Dealer Excise" to 'Yes'.

Similarly Sales,Debit note and Credit Note Vouchers can also be created.

Excise Duty Rate Entry in Stock item

As Excise Duty is charged on manufacture of goods, you have to mention the rate of duty while creating the stock item on which Excise Duty is applicable.
Go to Stock item Creation screen i.e. Gateway of Tally -> Inventory Info ->Stock Item -> Create. Set the option Excise Details to 'Yes'. The following details have to be entered in the screen:

Tariff classification : Here enter Tariff classification of the stock item. The Excise Duty authorities provide this code number for the concerned excisable stock.

Type of Duty : Here select the Duty from the list provided.

Rate of Duty : Here enter the rate of Duty applicable for the stock item .

Method of Calculation : Here select the appropriate method of calculation.

Ledger Account set up for Excise Duty Part 2

Additional Duty Ledger Account

If additional Excise Duty is applicable you have to create a new ledger account named Additional Excise Duty under the group Excise Duty. At the option 'Method of Calculation' field that appears on mentioning percentage of calculation, select Additional Duty. As already explained, other options are to be entered while creating excise duty ledger account. This duty is calculated as a percentage or part of the excise duty.

Creation of Supplier's/Customer's Ledger

A supplier and customer ledger account has to be created for Excise Duty transactions. The Excise Details option at the Tax Information portion of the ledger creation /alteration screen is to be set as 'yes'. The sub-screen will appear. There you have to enter the following details:

Excise Regn. No. - Here you have to enter the Excise Registration number of the supplier/customer.

Range - Here you have to enter the range under which the supplier/customer's company is registered.

Division - Here you have to enter the Division under which the supplier/customer's company is registered.

Commissionerate - Here you have to enter the name of the Commissionerate.

Nature of Purchase - Here you have to select the appropriate nature of purchase from the list provided.

Ledger Account set up for Excise Duty Part 1

Excise Duty Group and Excise Duty Ledger creation for additional Excise Duty is discussed here under:

Excise Duty Group
A sub-group named Excise Duty is to be created from Accounts Info under Duties and Taxes.

Excise Duty Ledger
Excise Duty ledger has to created under the group Excise Duty. As the Excise Rate vary for different items, it is better to create different ledgers for different rates like, Excise Duty 5%, Excise Duty 10%, etc. During Ledger creation Set the option "Inventory Values are affected" to 'No' as it is only required for sales and purchase entries. Write the rate in percentage in the field 'Percentage of Calculation'. Select "Tax based on Item Rate" from Type of Duty list in the 'Method of Calculation Field'.

Activation Features of Excise Duty

Press F11 and then press F3 to get the Statutory and Taxation menu. Set the options "Enable Dealer-Excise" and "Set /Alter Dealer-Excise Details". You will be forwarded to Excise Details screen. Enter the following details there:

ECC/PAN Based Regn/Code No. : Enter the Excise Control Code(ECC) or PAN number alloted to the organisation.

Commissionerate : Here enter the name of the commissionerate which controls the excise matters of the organisation.

Range Code : Here you have to enter the range code under which the organisation falls.

Range Name : Here you have to enter the range name under which the organisation falls.

Range Address : Enter the address of the range here.

Division Code : The Excise Division Code is to be entered here.

Division Name : The Excise Division Name is to be entered here.

Division Address : The Excise Division Address is to be entered here.

Excise Duty-Configuration Set Up

For Excise Duty configuration set up press F12 at Gateway of Tally. Set the options "Use Excise Format" and "Accept Supplementary Details" to 'Yes'.

Excise Duty

Another type of Indirect Tax is Excise Duty. It is charged on the manufacture of specified excisable goods at the time, when the goods leave the factory for sale. For Excise Duty, the taxable event is manufacture of goods. Under the Rules of Central Excise, organisations have to submit Excise Invoice under the Central Excise.