Annexure-17C displays the invoice-wise details of purchases and purchase returns made against Form C, E1 and E2.
● The Nature of Transaction must be selected as Interstate Purchase - Against Form C , Interstate Purchase - E1 , Interstate Purchase - E2 , Interstate Purchase Exempt - E1 , and Interstate Purchase Exempt - With Form C .
To add the required number of rows to the template for exporting data
1. Copy the excel template Offline_Return_version_1.5 to the Tally.ERP 9 installation folder.
2. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form VAT III .
3. Press Ctrl+E to view the Export Report screen. Based on the Form VAT III report period, the quarter for which the return is being filed is displayed.
4. Select the Type of Return as Original or Revised . The type of return selected here gets considered for all annexures.
5. Set the option Show number of rows to add to Yes and press Enter to view the Form VAT III Excel Template Validations screen.
o Add the number of rows, as shown in this screen, for Annexure 17C, to capture the details in the template while exporting data.
o Press Ctrl+A to accept.
6. Press Enter to export data to the template. The relevant details are captured in Annexure 17C sheet of the template.
To export data only to Annexure 17C sheet of the template
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form VAT III .
2. Click A : Annexures .
3. Select Annexure-17C and press Enter .
4. Click E : Export to view the Export Report screen. Based on the Form VAT III report period, the From and To dates are displayed here. These dates can be changed from the e-VAT Annexures report, if required. Ensure that the required number of rows are added to the template before exporting data.
5. Press Enter to export data.
The description of the fields in Annexure 17C is given below:
|
Field |
Description |
|
Sl. NO |
Displays the serial number of transactions. |
|
TIN / RC number of the Seller |
Displays the VAT TIN predefined for the party ledger or as entered in the Party Details screen of the invoice. |
|
Name of the Seller |
Displays the mailing name entered in the party ledger or in the Party Details screen of the invoice. |
|
Address of the Seller |
Displays the address entered in the party ledger or in the Party Details screen of the invoice. |
|
State of the seller |
Displays the State selected in party ledger or in Party Details screen of the invoice. |
|
Purchase Order No. |
Displays the Purchase Order No. entered in Statutory Details screen (displayed on enabling the option Provide VAT details ) of the invoice. |
|
Date of order |
Displays the purchase order Date entered in Statutory Details screen (displayed on enabling the option Provide VAT details ) of 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. |
|
Date on which purchase accounted (if the invoice date falls before the tax period). |
Displays the invoice date on which the transaction is recorded. |
|
Name of Goods as per invoice |
Displays the Commodity name predefined for the stock item selected in the invoice. If the stock items selected in a single invoice are predefined with: ● Different commodities, then each stock item appears in a separate row. ● Same commodity, then the values are consolidated and displayed in a single row. |
|
Purpose |
Displays the Purpose code selected in the Statutory Details screen (displayed on enabling the option Provide VAT details ) of the purchase invoice. |
|
Amount Excluding Tax |
Displays the assessable value of the stock items selected in the invoice. |
|
Tax Amount |
Displays the CST value of each transaction. |
|
Other charges |
Displays value of additional expense ledger (when the option Include in assessable value calculation for is set to No in the expense ledger master) entered in the invoice. |
|
Sale amount |
Displays auto calculated value. |