1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX.
2. Click A: Annexures.
3. Select Annexure - 1 and press Enter.
4. Press Ctrl+E to display the Export Report screen. Ensure the excel template is available in the Export Location.
|
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 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.
|
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. |
|
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. |
The details of the stock received from principal (registered dealer) on consignment basis within the state are displayed in Annexure 2. This annexure has to be filed on monthly basis in the predefined XML format.
The transactions that fulfill the following prerequisites will be captured in Annexure 2:
● The Nature of Transaction selected is Consignment Transfer Inward.
● 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 export Annexure 2
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX.
2. Click A: Annexures.
3. Select Annexure 2.
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-2: This sheet will record the transaction details for the period.
|
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 - 2 Worksheet |
|
|
Principal TIN |
Displays the VAT TIN predefined for the party ledger selected in the invoice is displayed here. TIN is 11 digits long and it starts with 33. |
|
Name of Principal |
Displays the name of the party ledger selected in the invoice. |
|
Stock Transfer Note No |
Displays the number entered in Supplier Invoice No. field of the purchase invoice. |
|
Stock Transfer Note 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. |
|
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. |
|
Details of Total Purchase Value & Tax Paid |
Displays the details of the purchase value and tax paid categorized based on the rate. |
The details of purchases made from unregistered dealers (including exempt goods) and dealers whose turnover is below the prescribed threshold limit will be displayed in Annexure 3.
The transactions that fulfill the following prerequisites will be captured in Annexure 3:
● The Nature of Transaction selected is Purchase From Unregistered Dealer and Purchase Taxable (additionally purpose of purchase is selected in the transaction)
● In party ledger master,
o The State selected is Tamil Nadu.
o The Type of Dealer selected is Unregistered.
● 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 0%, 1%, 2%, 5% and 14.5% tax rates.
The xml file generated with transaction details can be successfully uploaded to the department website, only if all the aforementioned prerequisites are fulfilled. XML file can be generated directly from Tally.ERP 9 or the exported excel template.
The tax paid on goods purchased from unregistered dealers attracts purchase tax. Annexure 3 displays details of purchases made from unregistered dealers and purchase tax liability from these transactions. This annexure has to be filed every month in the given XML format.
To view or export Annexure 3
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX.
2. Click A: Annexures.
3. Select Annexure 3.
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 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-3: This sheet will record the transaction details for the period.
|
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 - 3 Worksheet |
|
|
Purchased for the Purpose of |
Displays the Purpose of Purchase entered in the Statutory Details screen of the purchase invoice. |
|
Schedule |
Displays the schedule mapped to the item selected in the transaction. |
|
TIN |
Displays the VAT TIN predefined for the party ledger selected in the invoice. TIN is 11 digits long and it starts with 33. For unregistered party, this field is blank. |
|
Name of Seller |
Displays the name of the party selected at the invoice. |
|
Invoice No. |
Displays the number entered in Supplier Invoice No. field of 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. |
|
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. Displays 0% as rate of tax when Other than Section 12 is selected in Purchased for the Purpose of column. The option Other than Section 12 is selected in transaction recorded for purchase of exempt goods from unregistered dealer. |
|
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. |
|
Details of Total Purchase Value & Tax Paid |
Displays the details of the rate, purchase value, and tax paid categorized based on the rate. |
The details of local purchases and returns of taxable items made from registered dealers is displayed in Annexure 4. It has to be filed monthly/quarterly in required xml format.
The transactions that fulfill the following prerequisites will be captured in Annexure 4:
● The Nature of Transaction selected is Purchase Taxable.
● 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 Second 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 4%, 5%, 14.5%, 20%, 23.43%, 25%, 29%, 30%, 38%, 58%, 60% and 73% 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 4
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX.
2. Click A: Annexures.
3. Select Annexure 4.
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 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-4: This sheet will record the transaction details for the period.
|
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 - 4 Worksheet |
|
|
Type of dealer |
Displays the dealer type of the party, as selected in ledger master of the party. |
|
Transaction type |
Displays the transaction type - purchase or purchase return, based on transaction recorded in purchase voucher or debit note. |
|
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. |
|
Invoice No. |
Displays the number entered in Supplier Invoice No. field of the purchase invoice or Original invoice no. field of debit note. |
|
Invoice Date |
Displays the supplier invoice date entered in the purchase invoice or debit note. |
|
Commodity Code |
Displays the Commodity Code predefined in the VAT Details screen. |
|
Point of Purchase |
Displays the point of purchase of the transaction (first/second/third) within the state. |
|
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. |
|
Debit/Credit Note Date |
Displays the date of debit note/credit note transaction recorded for purchase returns. |
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.
|
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. |
Last updated for Release 5.4.5