Type search words and press enter
A new GSTR-2B API is applicable from 14th Nov 2024, which affects auto-reconciliation of GSTR-2B for Oct-24. Stay tuned for our upcoming release, TallyPrime 5.1, which supports this and makes reconciliation even smoother.
https://help.tallysolutions.com/docs/te9rel65/Tax_India/VAT/Tamil_Nadu/TN_Annexure-5.htm

e-VAT Annexure-5 (Tamil Nadu)

The details of purchase returns made to local registered dealers is captured in Annexure-5 . Increase in purchase price for goods already recorded will be captured. It can be generated for a month/quarter.

The transactions that fulfill the following prerequisites will be captured in Annexure 5 :

The Nature of Transaction selected is Purchase Taxable 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 11 digits long 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 or export Annexure 5

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

2. Click A : Annexures .

3. Select Annexure 5 .

4. Press Ctrl+E to export.

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

In case of excel template, the data is posted 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-5: 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 - 5  Worksheet

Seller TIN

Displays the VAT TIN predefined for the party ledger selected in the invoice. TIN is 11 digits long and it starts with 33.

Name of Seller

Displays the name of the party selected at the invoice.

Purchase Invoice Number

Displays the number entered in Supplier Invoice No. field of the purchase invoice.

Purchase Invoice Date

Displays the supplier invoice date entered in the purchase invoice. The date is captured in DD/MM/YYYY format.

Commodity Code

Displays the Commodity Code predefined in the VAT Details screen.

Purchase Value (Rs.)

Displays the assessable value of each commodity in the purchase invoice.

Rate of Tax (%)

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

Tax Paid (Rs.)

Displays the amount of purchase tax paid for each commodity. The formula used here is  Value = (Purchase value of commodity * rate of tax)/100

Total Value (Rs.)

Displays the sum of assessable value and purchase tax paid.

Date of Purchase Return

Displays the voucher/invoice date of debit note.

Debit/Credit Note Date

Displays the date on which debit/credit note is recorded.

Value of Goods Returned

Displays the purchase return/assessable value of each commodity in the debit note. This will include all expenses which are directly related to cost of purchase return.

In case purchase date is beyond 6 months from the date of return, the sum of assessable value and tax amount is displayed as value of goods returned.

Amount of tax to be Reversed (Rs.)

Displays the VAT amount entered in debit note.

In case purchase date is beyond 6 months from the date of return, the tax amount is updated a 0. Since, tax amount is added to value of goods returned.

Details of Total Purchase Value

Displays the details of the purchase value and tax paid categorized based on the rate.