The details of purchases made from composite dealers is captured in Annexure-6.
The transactions that fulfill the following prerequisites will be displayed in Annexure-6:
● The Nature of Transaction selected is Purchase From Composition Dealer.
● In party ledger master,
o The State selected is Tamil Nadu.
o The Type of Dealer selected is Composition and TIN is of 11 digits starting with 33.
● Commodity Code is predefined for the stock item.
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 6
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 6.
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-6: 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 - 6 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. |
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. |
The details of exempt purchases made from registered and unregistered dealers is captured in Annexure-7.
The transactions that fulfill the following prerequisites will be displayed in Annexure-7:
● The Nature of Transaction selected is Purchase Exempt and Purchase From Unregistered Dealer.
● In party ledger master,
o The State selected is Tamil Nadu.
o The Type of Dealer selected is Composition, and the TIN is 11 digits long and it starts with 33.
o The Type of Exemption selected is Notification.
● 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 7
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 7.
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-7: 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 - 7 Worksheet |
|
Type of Seller |
Displays the type of seller predefined in the VAT Details screen of the party ledger. |
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. |
Invoice Date |
Displays the supplier invoice date entered in the purchase invoice. |
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. |
Exemption Type |
Displays the exemption type predefined for the party ledger selected in the invoice. |
The details of interstate purchases is captured in Annexure-8.
The transactions that fulfill the following prerequisites will be displayed in Annexure 8:
● The Nature of Transaction considered are Interstate Purchase - Against Form C, Interstate Purchase - E1, Interstate Purchase - E2, Interstate Purchase Deemed Export, Interstate Purchase - Zero Rated and Interstate Purchase - 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.
● Commodity Code is defined at the stock item or stock group master, or at the ledgers masters.
● Tax rate is predefined either in the stock item or purchase ledger.
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 8
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 8.
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-8: 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 - 8 Worksheet |
|
Seller TIN |
Displays the VAT TIN predefined for the party ledger selected in the invoice. TIN is 11 digits long but it does not start with 33. |
Name of Seller |
Displays the name of the party selected at the invoice. |
Seller Address |
Displays the address entered in the party ledger creation screen or in the Party Details screen of the invoice. |
Seller State |
Displays the state entered in the party ledger creation screen or in the Party Details screen of the invoice.. |
Invoice/Delivery Note |
Displays the number entered in the Supplier Invoice No. field of the purchase invoice. |
Invoice/Delivery Date |
Displays the supplier invoice date entered in the purchase invoice. |
Purchase Order No. |
Displays the order number entered in the Purchase Order No. field of the Party Details screen in the invoice. |
Purchase Order Date |
Displays the date of purchase entered in the Party Details screen of the invoice. |
Commodity Code |
Displays the Commodity Code predefined in the VAT Details screen. |
Quantity/Weight |
Displays the quantity entered for each stock item in the invoice. |
Unit |
Displays the unit of measure predefined for the stock item selected in the invoice. |
If others, please specify |
Displays the specified unit of measurement other than the unit of measurements from the template and the reasons for specifying the same. |
Purchase Value (Rs.) |
Displays the assessable value of each commodity in the purchase invoice. |
CST Tax (Rs.) |
Displays the amount of CST
paid for each commodity is displayed here. The value is arrived
sing the formula given below: |
Form Type |
Displays the declaration form selected in Form to issue field in Statutory Details screen of purchase invoice. |
Purpose of Purchase |
Displays the Purpose of Purchase selected in Statutory Details screen of purchase invoice. The Purpose of Purchase list is displayed based on the form type selected. |
Name of Transport Company |
Displays the Name of transporter entered in the Statutory Details screen of purchase invoice. |
Means of Transport |
Displays the selected Means of Transport when the form type selected is Form H in the invoice. The three options available are listed in the drop down, the respective mode of transport can be selected. |
No. of Air Consignment Note/Bill of Lading/Railway Receipt/Lorry Receipt/Postal Receipt/other document : |
Displays the Air Consignment/RR/LR No. entered in the Statutory Details screen of the purchase invoice. |
Date of Railway Receipt/Lorry Receipt/Postal Receipt or any other document indicating the means of transport: |
Displays the date entered in the Statutory Details screen of purchase invoice. |
Agreement Order No. |
Displays the information entered in Agreement Order No. field, which appears on selecting Form H in Statutory Details screen of purchase invoice. |
Agreement Order Date |
Displays the information entered in Agreement Order Date field, which appears on selecting Form H in Statutory Details screen of purchase invoice. |
Details of Total Purchase Value |
Displays the details of the purchase value categorized based on the forms. |
The details of interstate purchase returns is captured in Annexure-9.
The transactions that fulfill the following prerequisites will be captured in Annexure 9:
● The Nature of Transaction selected is Interstate Purchase - Against Form C, Interstate Purchase - E1, Interstate Purchase - E2, Interstate Purchase Deemed Export, Interstate Purchase - Zero Rated and Interstate Purchase - 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.
● Commodity Code is defined at the stock item or stock group master, or at the ledgers masters.
● Tax rate is predefined either in the stock item or purchase ledger.
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 9
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 9.
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-9: 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 - 9 Worksheet |
|
Seller TIN |
Displays the VAT TIN predefined for the party ledger selected in the invoice is displayed here. TIN is of 11 digits and it starts with 33. |
Name of Seller |
Displays the name of the party ledger selected in the invoice. |
Seller Address |
Displays the address predefined in the party ledger creation screen or entered in the Party Details screen of purchase invoice. |
Seller State |
Displays the state predefined in the party ledger creation screen or selected in the Party Details screen of the purchase invoice. |
Invoice No. |
Displays the number entered in Original Invoice No. field of the debit note. |
Invoice Date |
Displays the original invoice date entered in the debit note. |
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. |
Date of Purchase Return |
Displays the voucher or invoice date of debit note. |
Value of Goods Returned (Rs.) |
Displays the purchase return/assessable value of each commodity in the debit note. |
CST Tax (Rs.) |
Displays the CST amount entered in the debit note. |
Debit/Credit Note No. |
Displays the voucher number of the debit note. |
Debit/Credit Note Date |
Displays the date on which the debit or credit note was recorded. |
Type of Form |
Displays the declaration form selected in Form to issue field in Statutory Details screen of purchase invoice . |
Online Form No. If Generated |
Displays the form number entered for the selected Type of Form. |
Details of Total Returned Value of Goods |
|
Displays the details of the returned value of goods categorized based on the forms. |
|
The details of stock received from a branch or supplier on consignment basis from outside the state are displayed in Annexure-10.
The transactions that fulfill the following prerequisites will be captured in Annexure 10:
● The Nature of Transaction selected is Interstate Branch Transfer Inward and Interstate Consignment Transfer Inward.
● 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.
● Commodity Code is defined at the stock item or stock group master, or at the ledgers masters.
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 10
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > e-C TAX > Annexure Ready.
2. Select Annexure 10.
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-10: 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 - 10 Worksheet |
|
Type of Transfer |
Displays the type of transfer based on the Nature of Transaction selected in the invoice. |
Transferor TIN |
Displays the VAT TIN predefined for the party ledger selected in the invoice is displayed here. |
Name of Transferor |
Displays the name of the party ledger selected in the invoice. |
Transferor Address |
Displays the address predefined in the party ledger creation screen or entered in the Party Details screen of purchase invoice. |
Transferor State |
Displays the state predefined in the party ledger creation screen or selected in the Party Details screen of the purchase invoice. |
Transferor Note No. |
Displays the number entered in Supplier Invoice No. field of the purchase invoice. |
Transferor Note Date |
Displays the transferring date entered in Statutory Details of the purchase invoice. |
Commodity Code |
Displays the Commodity Code entered in the stock item or stock group masters, or in the ledgers masters. |
Quantity/Weight |
Displays the quantity entered for each stock item in the invoice. |
Unit |
Displays the unit of measure predefined for the stock item selected in the invoice. |
If Others |
Displays Others if another unit of measurement different from the template is specified and the reasons for specifying the same. |
Value of Goods Transfer (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. It also displays the total value goods inward transferred by Branch Transfer, total value of goods inward transferred by consignment transfer and total value of goods inward transferred if F form is required. |
Mode of Transport |
Displays the mode of transport selected from the options displayed in the drop down list in the invoice. |
Name of Transporter |
Displays the information entered in Name of Transporter field in Statutory Details screen of purchase invoice. |
Dispatching Location |
Displays the information provided in the Destination field in Party Details screen of purchase invoice. |
Consignment Note/Lorry Receipt |
Displays the information entered in Consignment/LR No. field in Statutory Details screen of purchase invoice. |
Consignment Note/Lorry Receipt Date |
Displays the date entered in Consignment/LR Date field in Statutory Details screen of purchase invoice. |
Goods Receipt Date |
Displays the date entered in Goods received on field in Statutory Details screen of purchase invoice. |
