e-VAT Annexure-1 (Tamil Nadu)

The details of monthly total local purchases made from registered dealers is displayed in Annexure 1. It has to be filed every month in the given XML format.

Transactions that fulfill the following prerequisites will be displayed in Annexure 1:

     The Nature of Transaction selected is Purchase Taxable, Non Creditable Purchase - Capital Goods, and Purchase - Works Contract.

     In party ledger master,

o     The State selected is Tamil Nadu.

o     The Type of Dealer selected is Regular.

o     The TIN is of 11 digits and it starts with 33.

     In the stock item master,

o     Commodity Code is defined.

o     First Schedule is selected in the Schedule option.

     Tax rate is predefined either in the stock item or purchase ledger.

     Stock items selected in the invoice attract only 1%, 2%, 5% and 14.5% tax rates.

The xml file can be uploaded successfully only if all the aforementioned prerequisites are fulfilled. XML file can be generated either from the annexure screen or from the exported excel template.

To view Annexure 1

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

2.    Select Annexure 1.

3.    Press Ctrl+E to export.

4.    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 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-1: 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 the 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 - 1  Worksheet

Seller TIN

Displays the VAT TIN entered at the party ledger or Party Details screen of the invoice. TIN is 11 digits long and it starts with 33.

Name of Seller

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

Invoice No

Displays the Supplier Invoice No. entered in the purchase invoice.

Invoice Date

Displays the supplier invoice Date entered in the purchase invoice. The date should be within in the financial year of the relevant tax period and is captured in DD/MM/YYYY format.

Note: In the returns filed for the first month of a financial year, the supplier invoice date from March month of the previous financial year is considered.

Commodity Code

Displays the Commodity code predefined in the VAT Details screen.

Purchase Value (Rs.)

Displays the assessable value of each commodity in the invoice. This will include all other expenses affecting the purchase cost such as freight, discount and so on.

In case of Non Creditable Purchase - Special Goods, the sum of assessable value and tax amount is displayed.

Rate of Tax (%)

Displays the rate of tax predefined in the VAT Details screen.

In case of Non Creditable Purchase - Special Goods, the tax rate options 1(Hotel), 2(Hotel), and so on, are displayed.

Tax Paid (Rs)

Displays the amount of input VAT paid for each commodity. This is auto-calculated value. The value is arrived using the formula given below:

     Value = (Purchase value of commodity * rate of tax)/100

In case of Non Creditable Purchase - Special Goods, tax paid amount is displayed as zero. The tax amount is added to assessable value and displayed in Purchase Value (Rs.) column.

Total Value (Rs)

Displays the sum of assessable value and tax paid.

Details of Total Purchase Value & Tax Paid

Displays the value in this table based on the details entered for Annexure 1. The purchase value and tax paid will be categorized based on the rate in this table.

Last updated in Release 5.5.8.