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:
Serial No.
Displays the serial numbers, incremental by 1, for the purchase transactions captured in this section.
Form Type
Displays the form type J, as selected in the Form to issue field in Statutory Details screen of the transaction.
Purchased By
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.
Purchaser Description
Displays a brief description about the purchaser. This field is currently left blank.
Purchaser Type
Displays the type of the purchaser from the drop down, as selected in the Purchaser Type field in Statutory Details screen of the transaction.
Purchaser Type Description
Displays the description for the selected purchaser type, as recorded in the Purchase Type Description field in Statutory Details screen of the transaction.
Name of the country
Displays the country name selected in the ledger master of the supplier.
Designation of the Purchaser
Displays the name recorded in the Designation of Purchases field in Statutory Details screen of the transaction.
Official Address of the purchaser
Displays the address recorded in the Address field of the supplier’s ledger master.
E-mail ID of the purchaser
Displays the mail Id recorded in E-mail field in the ledger master of the supplier.
Tel. No. of the purchaser
Displays the number recorded in Telephone no. field in the ledger master of the supplier.
Fax No. of the purchaser
Displays the number recorded in Fax no. field in the ledger master of the supplier.
Purchaser Order No.
Displays the number as recorded in the Purchase Order No. field in Statutory Details screen of the transaction.
Purchase Order Date
Displays the date recorded in the Date field against Purchase Order No. in Statutory Details screen of the transaction.
Invoice No.
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.
Invoice Date
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.
Invoice Amount
Displays total value in invoice with Interstate Purchase – Zero Rated as nature of transaction, excluding tax amount.
Challan No.
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.
Challan Date
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.
