e-CST Form C captures inter-state purchase details of the registered dealers. It is submitted by the registered dealer at the end of every quarter.
The details of purchases recorded by selecting the nature of transaction Interstate Purchase - Against Form C, are captured in this form.
To export Form C
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > CST Form 1 > Annexure Ready.
2. Press Enter.
3. Select Form C and press Enter. Ensure the excel template 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 option CST From C, based on the form type selected in the transaction.
Displays the purchase order number recorded in the Party Details screen or Item Allocations screen of the purchase transaction recorded for Interstate Purchase – Against Form C.
Displays the purchase order date recorded in the Party Details screen against the specified order number or due date in the Item Allocations screen of the purchase transaction recorded for Interstate Purchase – Against Form C.
Displays the number recorded in the Supplier Invoice No. field of the purchase transaction. In case Supplier Invoice No. is not recorded, the document number of the purchase invoice is captured in this field.
Displays the date recorded in Date field against Supplier Invoice No. in purchase transaction. In case supplier invoice date is not recorded, the document date of the purchase invoice is captured in this field.
Displays the TIN number recorded in the TIN/Sales Tax No. field of VAT Details screen in ledger master of the dealer in the respective inter-state purchase transaction.
Displays the name of the state based on the TIN No. provided in the ledger master of the party or in the Party Details screen. Based on the first two digits of the TIN no., State is fetched and filled in this field automatically.
Displays the name recorded in the ledger master of the dealers in the respective inter-state purchase transaction.
Displays the Commodity Name assigned to the item master selected in inter-state purchase. 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 from RVAT Act, 2003. This column is currently left blank.
Displays the option selected in the Purpose of purchase field in Statutory Details screen in the specified purchase transaction.
Displays the value of each commodity in the purchase transaction with Interstate Purchase – Against Form C as nature of transaction including CST amount.
Click this button to validate the information captured in the annexure. After validating errors found in the information captured are shown in the eCST-Annexure-Form-C Format sheet. If no errors are found, .csv file which can be directly uploaded to the commercial tax department portal is generated.
e-CST Form E1E2 captures purchases in transit done by the registered dealers. It is submitted on quarterly basis.
The details of purchases recorded by selecting the Nature of Transaction Interstate Purchase - E1, Interstate Purchase - E2 and Interstate Purchase Exempt - E1 are captured in this form.
To export Form EIEII
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > CST Form 1 > Annexure Ready.
2. Press Enter.
3. Select Form EIEII, and press Enter.
4. Click E: Export. Ensure the excel template CST-Form E1 and E2.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 selected as E1 or E2, it is the form selected in the Form to receive field in Statutory Details screen in the purchase transaction.
Displays the TIN number recorded in the TIN/Sales Tax No. field of VAT Details screen in ledger master of the dealer in the respective transaction.
Displays the name of the state captured based on the TIN No. provided in the ledger master of the party or in the Party Details screen. Based on the first two digits of the TIN no., the State is fetched, and filled in this field automatically.
Displays the name of the purchasing dealer in the E1E2 Sales done by the dealer, as recorded in the ledger master of the dealers in the respective purchase in transit transaction.
Displays the address of the purchasing dealer in the E1E2 sales, as recorded in the Address field of the ledger master of the dealer.
Displays the State name selected in the Name of State (Source) field in Statutory Details screen of the transaction.
Displays the name of the place in the above selected State from which the goods are commenced, as the name recorded in the Name of Place (Source) field in Statutory Details screen of the transaction.
Displays name of the State to which the goods are moved as per the sale from the drop down list provided, as the State name selected in the Name of State (Destination) field in Statutory Details screen of the transaction.
Displays the name of the place in the above selected State to which the goods are moved as per the sale, as the name recorded in the Name of Place (Destination) field in Statutory Details screen of the transaction.
Displays the number recorded in the Supplier Invoice No. field of the purchase transaction is captured in this field.
Invoice Date
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 inter-state transaction, 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 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 is captured in this field.
Displays the value of commodity in the transaction with Interstate Sale- EI/Interstate Purchase-E1 or Interstate sale-E2 or Interstate Purchase-E2 as nature of transaction, excluding tax amount.
Displays the C Form No. issued by the purchaser for this particular E1E2 sale, as recorded in Form no field against Form to issue in Statutory Details screen.
Displays the date on which the dealer has received the C Form from the purchaser, as recorded in Date field against Form to issue in Statutory Details screen of the transaction.
Displays the option selected in the Name of Document field in Statutory Details screen.
Displays any other proof document other than railway receipt or tripsheet of lorry, as the name 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 document no. of the proof document given by the dealer, as recorded in the Document No. field in Statutory Details screen of the transaction.
Displays the date recorded in the Document 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-E1E2 Format sheet. If no errors are found, .csv file which can be directly uploaded to the commercial tax department portal is generated.
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.
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.
Displays the value of commodity in the transaction with Interstate Consignment Transfer Inward/Interstate Branch Transfer Inward as nature of transaction, excluding tax amount.
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.
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.
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.
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.
e-CST Form I captures purchase from Special Economic Zones. It is submitted by the dealer on quarterly basis. The details of purchases recorded with the following settings are displayed here.
● The nature of transaction selected is Interstate Purchase - Zero Rated.
● In party ledger, the Exemption Type is set to SEZ.
To export Form I
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > CST Form 1 > Annexure Ready.
2. Press Enter.
3. Select Form I and press Enter.
4. Click E: Export. Ensure the excel template CST-Form I.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 I, as selected in the Form to issue field in Statutory Details screen of the transaction.
Displays the SEZ Certification No. issued to that particular region where the dealer is registered, as recorded in the Notification/SEZ Reg Number in VAT Details screen of supplier ledger master.
Displays the date of certification of Special Economic Zone (SEZ), as recorded in the Date field in VAT Details screen of supplier ledger master.
Displays the commodity name assigned to the item purchased from SEZ supplier. If there are multiple commodities in a transaction, each is captured in a different row.
Displays the TIN number recorded in the TIN/Sales Tax No. field of VAT Details screen in ledger master of the SEZ supplier in the purchase transaction.
Displays the name of the seller from whom the dealer has purchased goods, as recorded in the ledger master of the SEZ supplier in the purchase transaction.
Displays the address of the seller from whom the dealer has purchased goods for resale, as recorded in the Address field of the ledger master of the selected supplier.
Displays the name of the state in which the selling dealer is registered based on the Seller 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 Purchase Order No. field in Statutory Details screen of the transaction.
Displays the number recorded Purchase Order No. field in Statutory Details screen of the transaction.
Displays the invoice number which is issued by the SEZ dealer, to the dealer, as recorded in the Supplier Invoice No. field in the purchase transaction.
Displays the date in which the invoice has been raised against the dealer, as recorded in the Date field against Supplier Invoice No. in the transaction.
Displays the value of commodity in the transaction in SEZ purchase with Interstate Purchase – Zero Rated as nature of transaction, excluding tax amount.
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-I Format sheet. If no errors are found, .csv file which can be directly uploaded to the commercial tax department portal is generated.
e-CST Form J captures purchases of the registered dealers from NGOs, diplomatic missions and other government bodies. It is submitted on quarterly basis. The details of purchases recorded with the following settings are captured in this form.
● Nature of transaction selected is Interstate Purchase - Zero Rated
● In party ledger master, the Exemption Type is set to Diplomatic Missions & U.N.
To export Form J
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > CST Form 1 > Annexure Ready.
2. Press Enter.
3. Select Form J, and press Enter.
4. Click E: Export. Ensure the excel template CST-Form I.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 J, as selected in the Form to issue field in Statutory Details screen of the transaction.
Displays the organisation type to which the supplier is selling goods, as selected in the Purchase By field in Statutory Details screen of the transaction.
Displays a brief description about the purchaser. This field is currently left blank.
Displays the type of the purchaser from the drop down, as selected in the Purchaser Type field in Statutory Details screen of the transaction.
Displays the description for the selected purchaser type, as recorded in the Purchase Type Description field in Statutory Details screen of the transaction.
Displays the country name selected in the ledger master of the supplier.
Displays the name recorded in the Designation of Purchases field in Statutory Details screen of the transaction.
Displays the address recorded in the Address field of the supplier’s ledger master.
Displays the mail Id recorded in E-mail field in the ledger master of the supplier.
Displays the number recorded in Telephone no. field in the ledger master of the supplier.
Displays the number recorded in Fax no. field in the ledger master of the supplier.
Displays the number as recorded in the Purchase Order No. field in Statutory Details screen of the transaction.
Displays the date recorded in the Date field against Purchase Order No. in Statutory Details screen of the transaction.
Displays the invoice number which is issued by the dealer to the purchasing party, as recorded in the Supplier Invoice No. field in the purchase transaction.
Displays the date in which the invoice has been raised against the dealer, as recorded in the Date field against Supplier Invoice No. in the transaction.
Displays total value in invoice with Interstate Purchase – Zero Rated as nature of transaction, excluding tax amount.
Displays the Challan No. of the payment received from the purchasing party, as recorded in the Challan No field in Statutory Details screen of the transaction.
Displays the date of the Challan received by the dealer from the govt. body, as recorded in the Challan 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-J Format sheet. If no errors are found, .csv file which can be directly uploaded to the commercial tax department portal is generated.
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.
