The details of transactions recorded for sale of goods (of Schedule 1) to registered dealers within the state is displayed in Annexure-15.
The transactions that fulfill the following prerequisites will be displayed in Annexure 15:
● 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.
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 15
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 15.
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-15: This sheet will record the transaction details for the period.
Field Name |
Description |
Basic Details Worksheet |
|
Dealer TIN |
Displays VAT TIN (Regular) 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 - 15 Worksheet |
|
Buyer 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 Buyer |
Displays the name of the party ledger selected in the invoice. |
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. |
The details of transactions recorded for sale of goods as agent to registered dealers within the state is displayed in Annexure-16.
The transactions that fulfill the following prerequisites will be displayed in Annexure 16:
● In the sales ledger,
o The Nature of Transaction selected is Sales - Taxable.
o The Company Nature of Business selected is Agent.
● In party ledger master,
o The State selected is Tamil Nadu.
o The VAT TIN is of 11 digits and starts with 33.
o The Type of Dealer selected is Regular.
● In the stock item master,
o Type of Goods is set to Not Applicable (This option will appear when Allow type of goods is enabled in F12: Configuration of VAT Details screen of 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
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 16
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 16.
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 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-16: This sheet will record the transaction details for the period.
Field Name |
Description |
Basic Details Worksheet |
|
Dealer TIN |
Displays VAT TIN (Regular) 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 - 16 Worksheet |
|
Buyer 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 Buyer |
Displays the name of the party ledger selected in the invoice. |
Invoice No./Delivery Note 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/Delivery Note 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 Total Sale Value |
|
Displays the total sale value which are filled automatically filled by information recorded in Annexure-16. |
|
The details of transactions recorded for sale of goods as agent to registered dealers within the state is displayed in Annexure-17.
The transactions that fulfill the following prerequisites will be displayed in Annexure 17:
● In the sales ledger,
o The Nature of Transaction selected is Sales - Taxable.
o The Company Nature of Business selected is Agent.
● 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, Type of Goods is selected as Is Principal Account Declared Goods (This option will appear when Allow type of goods is enabled in F12: Configuration of VAT Details screen of 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.
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 17
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 17.
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 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-17: This sheet will record the transaction details for the period.
Field Name |
Description |
Basic Details Worksheet |
|
Dealer TIN |
Displays VAT TIN (Regular) 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 - 17 Worksheet |
|
TIN of Agent |
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 Agents |
Displays the name of the party ledger selected in the 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 and Paid by Agents (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 Total Sale Value |
Displays the total sale value which are filled automatically filled by information recorded in Annexure-17. |
The details of transactions recorded for sale of goods except sugarcane, to registered and unregistered dealers within the state is displayed in Annexure-18.
The transactions that fulfill the following prerequisites will be displayed in Annexure 18:
● In the sales ledger,
o The Nature of Transaction selected is Sales - Taxable.
o The Company Nature of Business is set to Not Applicable.
● In party ledger master,
o The State selected is Tamil Nadu.
o The VAT TIN is of 11 digits and starts with 33 for registered dealer.
o The VAT TIN is blank in case of unregistered dealer.
o The Type of Dealer selected is Regular.
● In the stock item master,
o Type of Goods is selected as Is Principal Account or Industrial Inputs (This option will appear when Allow type of goods is enabled in F12: Configuration of VAT Details screen of stock item master).
o Commodity Code is defined.
o Second Schedule is selected in the Schedule option.
● Stock items selected in the invoice attract 4%, 5%, 14.5%, 20%, 23.43%, 25%, 29%, 30%, 38%, 58%, 60% and 73% tax rates.
● In the sales invoice, the Point of Sale option is set to,
o Other than the taxable point when the stock items selected attract zero percent tax rate.
o First, Second or Third when the stock items selected attract 4%, 5%, 14.5%, 20%, 23.43%, 25%, 29%, 30%, 38%, 58%, 60% and 73% tax rate.
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 18
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 18.
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-18: This sheet will record the transaction details for the period.
Field Name |
Description |
Basic Details Worksheet |
|
Dealer TIN |
Displays VAT TIN (Regular) 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 - 18 Worksheet |
|
Type of Dealer |
Displays the Type of Dealer selected for the party ledger in the Party Details screen of the sales invoice. If the Type of Dealer is Unregistered, the Buyer TIN field will be blank. |
Buyer 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 Buyer |
Displays the name of the buyer entered either in the party ledger or in the Party Details screen of the sales invoice. |
Commodity Code |
Displays the Commodity Code predefined in the VAT Details screen. |
Point of Sale |
Displays the Point of Sale selected in the sales invoice. |
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. |
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. It also displays the total value of second schedule goods sold to registered dealer and unregistered dealer, and total value of second schedule goods sold in their respective fields. |
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. It also displays the tax charged from the sale of second schedule goods to registered dealer and unregistered dealer, and from the total value of second schedule goods sold in their respective fields. |
Total Value (Rs.) |
Displays the sum of assessable value and tax charged |
Details of Total Sale Value |
Displays the total sale value which are filled automatically filled by information recorded in Annexure-18. |
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 > Annexure Ready.
2. Select Annexure 19.
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 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.
Field Name |
Description |
Basic Details Worksheet |
|
Dealer TIN |
Displays VAT TIN (Regular) 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. |
Amount of Tax Refunded (Rs.) |
Displays the amount of tax entered in the credit note. |
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. |
Details of Total Sale Value |
Displays the total sale value which are filled automatically filled by information recorded in Annexure-19. |
The details of transactions recorded for sale of goods (listed under Schedule 5) to special economic zones (SEZ) is displayed in Annexure-20.
The transactions that fulfill the following prerequisites will be displayed in Annexure 20:
● The Nature of Transaction selected is Sales Zero Rated.
● 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.
o The Type of Exemption selected is SEZ.
o SEZ registration number is specified.
● In the stock item master,
o Commodity Code is defined.
o Fifth Schedule is selected in the Schedule option.
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 20
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 20.
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 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-20: This sheet will record the transaction details for the period.
Field Name |
Description |
Basic Details Worksheet |
|
Dealer TIN |
Displays VAT TIN (Regular) 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 - 20 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. |
IE code |
Displays the Import/Export Code predefined for the party ledger selected in the invoice. |
SEZ registration No. |
The registration number of the SEZ zone, predefined for the party ledger selected in the invoice is displayed here.. |
Name of the SEZ dealer / International Organization |
Displays the name of the party ledger selected in the invoice. |
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. |