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/te9rel54/Tax_India/VAT/Tamil_Nadu/TN_Annexure-19.htm

Annexure-19 (Tamil Nadu)

The details of transactions recorded for sale returns of goods listed under Schedule 1, made to registered dealers within the state is displayed in Annexure-19.

The transactions that fulfill the following prerequisites will be displayed in Annexure 19:

●      The Nature of Transaction selected is Sales - Taxable and Sales - Works Contract.

●      In party ledger master,

o      The State selected is Tamil Nadu.

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

o      The Type of Dealer selected is Regular.

●      In the stock item master,

o      Commodity Code is defined.

o      First Schedule is selected in the Schedule option.

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

●      Transaction is recorded in credit note.

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 19

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

2.     Click A: Annexures.

3.     Select Annexure 19.

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-19: 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 - 19 Worksheet

Purchaser 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 Purchaser

Displays the name of the party ledger selected in the credit note.

Invoice No.

Displays the invoice or voucher number of the sales invoice. This is not the number entered in the Ref field of the invoice.

Invoice Date

Displays the invoice or voucher date of the sales invoice.

Commodity Code

Displays the Commodity Code predefined in the VAT Details screen.

Sales Value (Rs.)

Displays the assessable value of each commodity in the invoice. This includes all other expenses like freight, discount and so on which affect the sale value.

Rate of Tax (%)

Displays the tax rate  predefined in the VAT Details screen.

Tax Charged (Rs.)

Displays the amount of tax charged in the invoice. The value is arrived using the formula given below: Value = (Sales value of commodity * rate of tax)/100.

Total Value (Rs.)

Displays the sum of assessable value and tax charged.

Details of Sales Return

Displays the voucher date of credit note.

Value of Goods Returned (Rs.)

Displays the assessable value (commodity-wise) of credit note.

In case sale 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 Refunded (Rs.)

Displays the amount of tax entered in the credit note.

In case sale 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.

Debit/Credit note No.

Displays the invoice or voucher number of credit note.

Debit/Credit note Date

Displays the invoice or voucher date of credit note. The date should be within 6 months of the invoice date.

Details of Total Sale Value

Displays the total sale value which are filled automatically filled by information recorded in Annexure-19.

 

Mail this article