e-VAT Annexure-26 (Tamil Nadu)

The details of sales recorded by selecting the Nature of Transaction as Exports are displayed in Annexure 26 :

To view Annexure 26

1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX .

2. Click A : Annexures .

3. Select Annexure 26 .

4. Press Ctrl+E to export.

5. Specify the period and press Enter to export the data.

The XML file will be created in the Tally.ERP 9 application folder. In case of excel template, the data is exported to excel template and the xml is generated after validating the data. The different fields in the excel template are described below:

The excel template contains three worksheets:

Help : This sheet provides details on different elements of the excel sheet and do’s and don’ts.

Basic Details : This sheet will record the company and period information.

Annexure-26 : This sheet will record the transaction details for the period.

Legend

Indicates what is new in the form/annexure

Indicates what has changed in the form/annexure

Indicates what has been removed from the form/annexure

The fields in the annexure are described below:

Field Name

Description

Basic Details Worksheet

Dealer TIN

Displays TIN entered in Company VAT Details screen of Statutory & Taxation features.

Tax Period From

Displays the starting date of return period of the report which was entered in the From (blank for beginning) field of Export Report screen.

Tax Period To

Displays the ending date of return period of report which was entered in the To (blank for end) field of Export Report screen.

Annexure - 26  Worksheet

IE code of exporter

Displays the Export/Import Code predefined for the party ledger selected in the sales invoice.

Export Invoice No.

Displays the voucher/invoice number of sales invoice.

Export Invoice Date

Displays the voucher/invoice date of sales invoice.

Purchase Order No.

Displays the sales order number entered in the Statutory Details screen of sales invoice.

Purchase Order Date

Displays the date entered for Sales Order No field in the Statutory Details screen of sales invoice.

Letter of Credit No.

Displays the Letter of Credit entered in the Statutory Details screen of sales invoice .

Letter of Credit Date

Displays the date entered for Letter of Credit in the Statutory Details screen of sales invoice.

Quantity of Goods

Displays the quantity of goods  entered in the sales invoice.

Description of the commodity

Displays the name of stock item selected in the sales invoice.

Value of the goods exported

Displays the assessable value of each stock item selected in the sales invoice.

Bill of lading/Airway Bill No.

Displays the Bill of lading/Airway bill no. entered in the Statutory Details screen of sales invoice .

Bill of lading/Airway Bill Date

Displays the date entered for Bill of lading/Airway bill no. in the Statutory Details screen of sales invoice.

Name of the foreign Buyer

Displays the name of the party ledger selected in the invoice.

Country of export

Displays the Country predefined in the party ledger master or entered in the Party Details screen of sales invoice.

Customs Shipping Bill No.

Displays the Customs shipping bill No. entered in the Statutory Details screen of sales invoice.

Customs Shipping bill Date

Displays the date entered for Customs shipping bill No. in the Statutory Details screen of sales invoice.

Name of the Forwarding Agent

Displays the Name of forwarding Agent entered in the Statutory Details screen of sales invoice.