The details of Input VAT Reversals for the purchases made within the state and tax paid on such purchases are displayed in Annexure-12.
The transactions that fulfill the following prerequisites will be displayed in Annexure-12:
● The following VAT Adjustments have to be selected in journal voucher to capture values in this annexure:
o Reversal of Input Tax - Used for Civil Structures
o Reversal of Input Tax - Utilised for Self Use
o Reversal of Input Tax - Purchase of Automobiles, Spare Parts
o Reversal of Input Tax - Purchase of Air Conditioners
o Reversal of Input Tax - Goods Given As Gift, Free Sample
o Reversal of Input Tax - Goods Lost on Theft, Loss, Etc.
o Reversal of Input Tax - Inputs Destroyed in Fire Or Lost
o Reversal of Input Tax - Inputs Damaged in Transit Or Destroyed Before Mfg.
o Reversal of Input Tax - Consignment Sales Without 'F' Form
o Reversal of Input Tax - Stock Transfer Without 'F' Form
o Reversal of Input Tax - Manufacturing of Exempt Goods
o Reversal of Input Tax - Others
● 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.
● Commodity Code is defined in the stock item master.
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 12
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX.
2. Click A: Annexures.
3. Select Annexure 12.
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 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-12: 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 - 12 Worksheet |
|||||||||||||||||||||||||||
Nature of Transactions |
Displays the VAT Adjustment selected in journal voucher and the relevant reason from the drop-down list provided in the template. The reasons which are populated in the template on selecting VAT flags in journal voucher are listed here.
|
||||||||||||||||||||||||||
Commodity Code |
Displays the Commodity Code predefined in the VAT Details screen. The VAT Details screen of: ● Stock item Stock Item Creation. ● Stock Item Alteration. ● Stock Group Creation. ● Stock Group Alteration. ● Leger Creation. ● Ledger Alteration. ● Ledger Group Creation. ● Ledger Group Alteration. ● Company Operations Alteration. |
||||||||||||||||||||||||||
Value of Goods Involved (Rs.) |
Displays the assessable value entered in the VAT Details screen on selecting input VAT ledger. |
||||||||||||||||||||||||||
Rate of Tax |
Displays the rate predefined in the VAT Details screen. The VAT Details screen of: ● Stock item Stock Item Creation. ● Stock Item Alteration. ● Stock Group Creation. ● Stock Group Alteration. ● Leger Creation. ● Ledger Alteration. ● Ledger Group Creation. ● Ledger Group Alteration. ● Company Operations Alteration. |
||||||||||||||||||||||||||
Amount of Input tax to be reversed (Rs.) |
Displays the input VAT amount entered in the journal voucher. |
||||||||||||||||||||||||||
Details of Total Purchase Value |
|||||||||||||||||||||||||||
Displays the details of the purchase value and tax paid categorized based on the rate. |
'e-VAT Annexure-12 (Tamil Nadu)' has been shared with