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.