The details of transactions recorded for sale of exempt goods (listed under Schedule 4) to special economic zones (SEZ) is displayed in Annexure-21.
The transactions that fulfill the following prerequisites will be displayed in Annexure 21:
● The Nature of Transaction selected is Sales Exempt.
● 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 Notification.
o Notification number is specified.
● In the stock item master,
o Commodity Code is defined.
o Fourth 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 21
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 21.
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-21: 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 - 21 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. |
Type of Transaction |
Displays based on the Nature of Transaction, the type of transaction is displayed here. If the transaction is recorded in: ● Sales invoice, the type of transaction appears as Sales. ● Credit note, the type of transaction appears as Sales Returns. |
Exemption Type |
Displays the reason for exemption viz., 4th Schedule, By notification for Goods or Notification for seller. |
The details of transactions recorded for interstate sale of goods (listed under Schedule 1 and 2) is displayed in Annexure-22.
The transactions that fulfill the following prerequisites will be displayed in Annexure 22:
● The Nature of Transaction selected is Interstate Sales - Against Form C and Interstate Sales - Taxable.
● In party ledger master,
o The State selected is other than Tamil Nadu.
o The VAT TIN is of 11 digits and it does not start with 33.
o The Type of Dealer selected is Regular.
● In the stock item master,
o Commodity Code is defined.
o First Schedule or Second Schedule is selected in the Schedule option.
To view Annexure 22
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > VAT Form I(New) > Annexure Ready.
2. Select Annexure 22.
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-22: 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 - 22 Worksheet |
|
Schedule |
Displays the schedule number based on the Schedule predefined in the stock item or sales ledger. |
Type |
Displays the Type based on the Nature of Transaction selected in the sales invoice. On selecting the Nature of Transaction, ● Interstate Sales - Against Form C, the Type appears as Against Form C. ● Interstate Sales - Taxable, the Type appears as Without Form C. |
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. |
Buyer Address |
Displays the address predefined in the party ledger master or entered in the Party Details screen of sales invoice. |
Buyer State |
Displays the state predefined in the party ledger or selected in the Party Details screen of the sales invoice. |
Seller Invoice/Delivery Note |
Displays the invoice or voucher number of the sales 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 net of CST (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. |
CST Tax Rate (%) |
Displays the Tax Rate predefined in the VAT Details screen. |
CST Tax Due (Rs.) |
Displays the amount of tax charged in the invoice is displayed here. The value is arrived using the formula given below: ● Value = (Sales value of commodity * rate of tax)/100. |
Details of Total Sale Value |
Displays the total sale value which are filled automatically filled by information recorded in Annexure-22. |
The details of transactions recorded for interstate sales returns of goods (listed under Schedule 1 and 2) is displayed in Annexure-23.
The transactions that fulfill the following prerequisites will be displayed in Annexure 23:
● The Nature of Transaction selected is Interstate Sales - Against Form C and Interstate Sales - Taxable.
● In party ledger master,
o The State selected is other than Tamil Nadu.
o The VAT TIN is 11 digits long and it does not start with 33.
o The Type of Dealer selected is Regular.
● In the stock item master,
o Commodity Code is defined.
o First Schedule or Second Schedule is selected in the Schedule option.
● Transactions are 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 23
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 23.
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-23: 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 at the To (blank for end) field of Export Report screen. |
Annexure - 23 Worksheet |
|
Schedule |
Displays the schedule number based on the Schedule predefined in the stock item or sales ledger. |
Type |
Displays the Type based on the Nature of Transaction selected in the sales invoice. On selecting the Nature of Transaction, ● Interstate Sales - Against Form C, the Type appears as Against Form C. ● Interstate Sales - Taxable, the Type appears as Without Form C. |
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. |
Buyer Address |
Displays the address predefined in the party ledger master or entered in the Party Details screen of credit note. |
Buyer State |
Displays the state predefined in the party ledger or selected in the Party Details screen of the credit note. |
Seller Invoice No. |
Displays the invoice or voucher number of the credit note. |
Seller Invoice Date |
Displays the invoice or voucher date of the credit note. |
Commodity Code |
Displays the Commodity Code predefined in the VAT Details screen. |
Sales Value net of CST (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. |
CST Tax Rate (%) |
Displays the Tax Rate predefined in the VAT Details screen. |
CST Tax Paid (Rs.) |
Displays the CST amount entered for each commodity in the original sales invoice. |
Date of Return |
Displays the voucher/invoice date of credit note. |
Value of Goods Returned (Rs.) |
Displays the assessable value of each commodity in the credit note. |
Tax amount refunded (Rs.) |
Displays the tax amount entered in the credit note. |
Credit/Debit Note No. |
Displays the voucher number of the credit/debit note transaction recorded for return of goods from the interstate buyer. |
Credit/Debit Note Date |
Displays the date of the credit/debit note transaction recorded for return of goods from the interstate buyer. |
Details of Total Sale Value of Schedule I and Schedule II for Against Form C |
Displays the invoice value of credit note recorded using Interstate Sales Against Form C as the Nature of Transaction with rate-wise breakup. |
Details of Total Sale Value of Schedule I and for Without Form C |
Displays the invoice value of credit note recorded by selecting stock items predefined as First Schedule goods using Interstate Sales Taxable as the Nature of Transaction with rate-wise breakup. |
Details of Total Sale Value of Schedule II for Without Form C |
Displays the invoice value of credit note recorded by selecting stock items predefined as Second Schedule goods using Interstate Sales Taxable as the Nature of Transaction. |
The details of transactions recorded for transfer of goods against Form F is displayed in Annexure-24.
The transactions that fulfill the following prerequisites will be displayed in Annexure 24:
● In the sales ledger,
o The Nature of Transaction selected is Interstate Branch Transfer Outward and Interstate Consignment Transfer Outward.
o The Company Nature of Business selected is Agent.
● In party ledger master,
o The State selected is other than Tamil Nadu.
o The VAT TIN is of 11 digits and it does not start with 33.
o The Type of Dealer selected is Regular.
● In the stock item master,
o Commodity Code is defined.
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 24
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 24.
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-24: 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 at the To (blank for end) field of Export Report screen. |
Annexure - 24 Worksheet |
|
Type |
Displays the Type based on the Nature of Transaction selected in the sales invoice. On selecting the Nature of Transaction, ● Interstate Branch Transfer Outward, the Type appears as Branch Transfer. ● Interstate Consignment Transfer Outward, the Type appears as Transfer to Consignment Agent. |
Delivery Note/Stock Transfer Note/Memo/Challan No. |
Displays the invoice/voucher number of the sales invoice. |
Delivery Note/Stock Transfer Note/Memo/Challan Date |
Displays the invoice/voucher date of sales invoice. |
Mode of Transport |
Displays the Mode of Transport entered in the Statutory Details screen of sales invoice. |
Goods Vehicle No. |
Displays the Goods vehicle No. entered in the Statutory Details screen of sales invoice. |
Lorry Receipt/Railway Receipt/Transport document Number |
Displays the LR/RR no. entered in the Statutory Details screen of sales invoice. |
Lorry Receipt/Railway Receipt/Transport document Date |
Displays the Date entered for the LR/RR No. in the Statutory Details screen of sales invoice. |
Description of goods consigned |
Displays the name of stock item selected in the sales invoice. Each item is displayed in a separate row. |
Quantity |
Displays the quantity entered for each item (captured in the Description of goods consigned column) in the sales invoice. |
Approximate Value (in Rs.) |
Displays the value of each item selected in the sales invoice. |
Full Name of the Branch/Agent in other State |
Displays the name of the party ledger selected in the invoice. |
Full Address of the Branch/Agent in other State |
Displays the Address predefined in the party ledger master or entered in the Party Details screen of sales invoice. |
TIN of the Branch/Agent in other State |
Displays the VAT TIN predefined for the party ledger selected in the invoice. TIN is 11 digits long and it starts with 33. |
Form F Number if received |
Displays the Form no. entered in the Statutory Details screen of sales invoice. |
Goods Receipt Date |
Displays the date entered in Goods received on field in the Statutory Details screen of sales invoice. |
The details of transactions recorded by selecting the Nature of Transaction as Sales High Seas are displayed in Annexure 25:
To view Annexure 25
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 25.
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-25: 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 at the To (blank for end) field of Export Report screen. |
Annexure - 25 Worksheet |
|
Bill of lading No. |
Displays the Bill of Lading no. entered in the Statutory Details screen of sales invoice. |
Bill of lading Date |
Displays the Date entered for the Bill of Lading no. in the Statutory Details screen of sales invoice. |
Name of the commodity |
Displays the name of the commodity predefined in the VAT Details screen. |
Name of the foreign seller |
Displays the name entered in the Foreign Seller Details section in the Statutory Details screen of sales invoice. |
Address of the foreign seller |
Displays the Address entered in the Foreign Seller Details section in the Statutory Details screen of sales invoice. |
Value of the goods purchased (Rs.) |
Displays the amount entered as Goods Purchased Value in Purchase Details screen of sales invoice. |
Name of the ship |
Displays the Ship Name entered in the Shipping Details section in the Statutory Details screen of sales invoice. |
Name of the shipping agent |
Displays the Agent Name entered in the Shipping Details section in the Statutory Details screen of sales invoice . |
Address of the shipping agent |
Displays the Agent Address entered in the Shipping Details section in the Statutory Details screen of sales invoice. |
Date of endorsement of Bill of lading |
Displays the Date of Endorsement entered in the Statutory Details screen of sales invoice. |
Bill of entry no |
Displays the Bill of Entry No. entered in the Clearing Agent Details section in the Statutory Details screen of sales invoice. |
Bill of entry date |
Displays the Date entered for the Bill of Entry No. in the Clearing Agent Details section in the Statutory Details screen of sales invoice. |
Invoice no. of sales in the course of import |
Displays the Original inv. no. entered in the Statutory Details screen of sales invoice. |
Invoice date of sales in the course of import |
Displays the date entered for the Original inv. no. in the Statutory Details screen of sales invoice. |
Value of the goods sold (Rs.) |
Displays the value of sales invoice. |
Import/Export Code of the importer who clears the goods |
Displays the Export/Import Code predefined for the party ledger selected in the invoice. |
TIN of the buyer |
Displays the VAT TIN predefined for the party ledger selected in the invoice. |
Name of the buyer |
Displays the name of the party ledger selected in the invoice. |
Address of the buyer |
Displays the Address predefined in the party ledger master or entered in the Party Details screen of sales invoice. |
Name of the clearing agent |
Displays the Clearing Agent Name entered in the Statutory Details screen of sales invoice. |
Address of the clearing agent |
Displays the Clearing Agent Address entered in the Statutory Details screen of sales invoice. |
