e-CST Form F is a quarterly form to be submitted by registered dealers. The details of purchases recorded by selecting the Nature of Transaction Interstate Consignment Transfer Inward and Interstate Branch Transfer Inward are captured in this form.
To export Form F
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > CST Form 1 > Annexure Ready .
2. Press Enter .
3. Select Form F , and press Enter .
4. Click E : Export . Ensure the excel template CST-Form F.xls is copied to the export location.
5. Specify the period and press Enter to export the data.
The data exported to excel template can be validated and converted to .csv format. The different fields in the excel template are described below:
Displays the serial numbers, incremental by 1, for the purchase transactions captured in this section.
Displays the form type F selected from the drop down list, as selected in the Form to issue field in Statutory Details screen of the purchase transaction recorded for Interstate Consignment Transfer Inward or Interstate Branch Transfer Inward .
Displays the TIN number recorded in the TIN/Sales Tax No. field of VAT Details screen in ledger master of the dealer in the transfer inward transaction.
Displays the name of the consigner in the stock transfer/ consignment transfer, as the name recorded in the ledger master of the party in the purchase transaction.
Displays the address recorded in the Address field of the ledger master of the selected supplier.
Displays the name of state in which the supplier is registered based on the Consigner TIN number field. Based on the first two digits of the TIN no., the state name is fetched and filled in the field automatically.
Displays the number recorded in the Supplier Invoice No. field in the purchase transaction.
Displays the date recorded in the Date field against Supplier Invoice No . in the transaction.
Displays the Commodity Name assigned to the item master selected in respective inter-state transfer inward. If there are multiple commodities in a transaction, each is captured in different row.
Displays the description for the commodity, if and only if Others is selected in the field Commodity Name . This field is currently left blank.
Quantity or Weight of Goods
Displays the quantity or weight of commodity selected in the specified transaction.
Displays the unit of quantity or weight entered in the previous column from the list of units given in the drop down, as the unit selected for the commodity in Commodity Name column.
Displays a value only if Others is selected in the Units column. Unit of measurement other than the drop down list provided in Unit column.
Value of Goods
Displays the value of commodity in the transaction with Interstate Consignment Transfer Inward / Interstate Branch Transfer Inward as nature of transaction, excluding tax amount.
Type of transport
Displays the option selected in the Mode of Transport field in Statutory Details screen of the transaction.
Displays the name recorded in the Name of transporter field in Statutory Details screen of the transaction.
Type of Receipt
Displays the type of the receipt document from the given drop down list, as selected in the Name of Document field in Statutory Details screen of the transaction.
Any other Receipt
Displays any other proof document other than railway receipt or tripsheet of lorry, as recorded in the Other Documents screen. Only when the value in the Name of Document field is Other Documents , this field is enabled for manual entry.
Displays the number of the receipt given by the dealer, as recorded in the Goods Receipt No. field in Statutory Details screen of the transaction.
Date of Receipt
Displays the date of the receipt given by the dealer, as recorded in the Goods Receipt Date field in Statutory Details screen of the transaction.
Displays the date on which the stock / consignment goods got delivered at the destination, as recorded in the Delivery Date field in Statutory Details screen of the transaction.
Click this button to validate the information captured in the annexure. After validating errors found in the information captured are shown in the eCST-Form-F Format sheet. If no errors are found, .csv file which can be directly uploaded to the commercial tax department portal is generated.