e-CST Export Form captures export sales. It is submitted on quarterly basis. The details of sales recorded with the nature of transaction Export are displayed here.
To export the Form
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > CST Form 1 > Annexure Ready .
2. Press Enter .
3. Select Form Export and press Enter . Ensure the excel template ExportForm.xls is copied to the export location.
4. Click E : Export .
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 CST Form-H or VAT Form-15 . The option CST Form-H is displayed when seller from whom the exported goods were purchased is from a different State. VAT Form-15 is displayed if the original seller is from the same state. The form type are inferred based on the TIN/State of the party and there is no provision to select the form type in the transaction manually.
Displays the purchase order no. for the purchase of item recorded preceding the export sales, as recorded in the Purchase Order No. field in the Purchase Details screen of the item while recording export sales.
Displays the date on which the purchase order was raised, as recorded in the Purchase Order Date field in the Purchase Details screen of the item while recording export sales.
Displays the bill no. or cash memo no. or challan no. given by the selling dealer, as recorded in the Invoice No. field in the Purchase Details screen of the item while recording export sales.
Displays the date in which the bill / cash memo / challan is given by the selling dealer, as recorded in the Date field in the Purchase Details screen of the item while recording export sales.
Displays the selling dealer's TIN number, as recorded in the Seller TIN field in the Purchase Details screen of the item while recording export sales.
Displays the name of state in which the selling dealer is registered based on the TIN No. provided in the Seller TIN field. Based on the first two digits of the TIN no. entered in the Seller TIN field, the state name is fetched and filled in this field automatically.
Displays the name of the selling dealer in the purchase transaction, as recorded in the ledger master of the dealer selected in the Supplier field in the Purchase Details screen of the item while recording sales export transaction.
Displays the Commodity Name assigned to the stock item selected in export sales. 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.
Displays the quantity or weight of it recorded in the Quantity field in Purchase Details screen of the item while recording export transaction.
Displays the unit of quantity or weight entered in the previous column from the list of units given in the drop down, as selected in the Quantity field in Purchase Details screen of the item while recording export transaction.
Displays a value only if Others is selected in the Units column, as recorded in New Unit screen of Purchase Details .
Displays the value recorded in the Purchase Value field in Purchase Details screen of the item while recording the export sale.
Displays the number of times exported against the mentioned invoice, as selected in the export transaction.
Displays the transport type through which items are exported, as selected in the Type of Export Transport field in Statutory Details screen of the transaction.
Displays the name of the airport, seaport or land customs according to the value selected in the previous column Type of Export transport , as recorded in the Name of Airport/seaport field in Statutory Details screen of the transaction.
Displays the name recorded in the Name of Airline/ship field in Statutory Details screen of the transaction.
Displays the number of consignment through which the goods are exported, as recorded in the Number of consignment field in Statutory Details screen of the transaction.
Displays the date in which the consignment is sent by the dealer, as recorded in the Date field against Number of consignment in Statutory Details screen of the transaction.
Display the commodity name assigned to the item exported.
Displays the value recorded in the Quantity field of Stock Item Allocations screen of the item while recording export transaction, against the respective commodity along with the unit of measure.
Displays the unit of quantity or weight for value entered in the previous column from the list of units. The option Others is captured in this field, if the unit of measure is locally defined for the item.
Displays the value of goods exported by the dealer through mentioned consignment. It is the value of each commodity in the export sale transaction.
Click this button to validate the information captured in the annexure. After validating errors found in the information captured are shown in the Error Sheet. If no errors are found, .csv file which can be directly uploaded to the commercial tax department portal is generated.
