Annexure-17F displays the invoice-wise details of consignment/branch transfer inwards made within and outside the state during the return period.
Pre-requisites
● In the invoice,
o The party selected must be predefined as Regular in party master.
o Form to issue must be selected as Form F in Statutory Details screen (displayed on enabling the option Provide VAT details in the invoice).
● The Nature of Transaction must be selected as Branch Transfer Inward , Consignment Transfer Inward , Interstate Branch Transfer Inward , and Interstate Consignment Transfer Inward .
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 17F, 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 17F sheet of the template.
Export data only to Annexure 17F sheet of the template
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form VAT III .
2. Click A : Annexures .
3. Select Annexure-17F 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 17F is given below:
|
Field Name |
Description |
|
Sr. No. |
Displays the serial number of transactions. |
|
Name of the Transferor |
Displays the mailing name entered in the party ledger or in the Party Details screen of the invoice. |
|
Address of the Transferor |
Displays the address entered in the party ledger or in the Party Details screen of the invoice. |
|
State of the transferor |
Displays the State selected in party ledger or in the Party Details screen of the invoice. |
|
TIN or RC number of the transferor |
Displays the VAT TIN predefined for the party ledger or as entered in the Party Details screen of the invoice. |
|
Description of the goods sent |
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. |
|
Quantity or Weight |
Displays the quantity entered for the stock item selected in the invoice. |
|
Unit |
Displays the Reporting unit of measure predefined for the commodity tagged to the stock item selected in the invoice. |
|
Value of Goods |
Displays the assessable value of the stock items selected in the invoice. |
|
Number of Invoice or challan or any other document under which goods were sent |
Displays the Supplier Invoice No. entered in the purchase invoice. |
|
Dated |
Displays the supplier invoice Date entered in the purchase invoice. |
|
Name of Railway, steamer or ferry Station or airport or post office or road transport company's office from where goods were dispatched |
Displays the information entered in Transport Company Name field of Statutory Details screen (displayed on enabling the option Provide VAT details in the invoice). |
|
Number of railway Receipt or postal Receipt or goods Receipt with trip sheet of lorry or any other document indicating the means of transport |
Displays the details entered in the fields Mode of Transport and LR/RR No. fields of Statutory Details screen (displayed on enabling the option Provide VAT details in the invoice). |
|
Dated |
Displays the Goods Despatch Date entered in Statutory Details screen (displayed on enabling the option Provide VAT details in the invoice). |
|
Date on which delivery was taken by the transferee |
Displays the Goods Delivery Date entered in Statutory Details screen (displayed on enabling the option Provide VAT details in the invoice). |