To export data to CST template
1. Copy the excel template to the Tally.ERP 9 installed folder.
2. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form 1V.
3. Press Ctrl+E to view the Export Report screen. In the Export Report screen, press Backspace to provide the relevant details.
4. Select the Type of Return.
5. Set the options provided in the Enclosures section to Yes or No, as required.
6. Press Enter to export the data to template.
The description of Form VAT 1V is given below:
Field Name | Description |
TIN |
Displays the TIN entered in the Company VAT Details screen of Statutory & Taxation features. |
CST NO |
Displays the Inter-state Sales Tax Number entered in the Company VAT Details screen of Statutory & Taxation features. |
Financial Year |
Displays the year based on the period of Form VAT 1V report. |
Period From and To |
Displays the dates of Form VAT 1V report period. |
Return Type |
Displays the type based on the Type of Return selected in the Export Report screen of Form VAT 1V. |
Filing Date |
Displays the system date. |
1. Gross amount received and receivable by the dealer during the period in respect of sales of goods |
Displays: ● Gross value of taxable sales made within and outside the state. |
Deduct -- |
|
(i) Sales of goods outside the State (as defined in Section 4 of the Act) |
This field is currently blank. |
(ii) Sale of goods in the course of export outside or import into India (as defined in Section 5 of the act) |
Displays the net value of sales recorded with the following nature of transactions: ● Exports ● Sales High Seas ● Deemed Export ● Interstate Deemed Export |
Total (i & ii) |
Displays auto calculated value. |
2. Balance-turnover of inter-state sales and sales with the state |
Displays auto calculated value. |
Deduct -- Turnover of sales within the State |
Displays: |
3. Balance turnover of inter-state sales |
Displays auto calculated value. |
Deduct -- |
|
(i) Cost of freight of delivery or the cost of installation where such cost is separately charged on inter-state sales |
Displays the values of additional ledgers selected in the sales invoice recorded with the following nature of transactions: ● Interstate Sales - Works contract ● Interstate Sales - E1 ● Interstate Sales - Against Form C ● Interstate Sales - Taxable |
(ii) Sums allowed as cash discount of turnover is considered inclusive of the same sums |
Displays the values of discount ledger selected in the sales invoice recorded with the following nature of transactions: ● Interstate Sales - Works contract ● Interstate Sales - E1 ● Interstate Sales - Against Form C ● Interstate Sales - Taxable |
(iii) Sale price of goods returned by the purchaser within the prescribed period |
Displays the assessable value of credit note recorded within six months of the original invoice date, with the following nature of transactions: ● Interstate Sales - Works contract ● Interstate Sales - E1 ● Interstate Sales - Against Form C ● Interstate Sales - Taxable All the Nature of Return provided in Statutory Details screen of the invoice are considered here. |
Total (i, ii & iii) |
Displays auto calculated value. |
4. Balance -- Total turnover of inter_state sales |
Displays auto calculated value. |
Deduct -- |
|
(i) Subsequent sales not taxable under section 6(2) of the Act |
Displays the net assessable value of sales recorded with the following nature of transactions: ● Interstate Sales Exempt - E1 ● Interstate Sales - E2 |
(ii) Sales not taxable under section 8(2A) of the Act |
Displays the net assessable value of sales recorded with the nature of transaction Interstate Sales - Exempt. |
Total (i & ii) |
Displays auto calculated value. |
5. Balance -- Total taxable turnover of inter-state sales |
Displays auto calculated value. |
6. Goodswise break-up of the above taxable turn-over and the tax payable thereon |
|
(i) Sales of declared goods at |
Displays the details of interstate sales with the highest net assessable value, recorded by selecting: The tax rate appears in Rate% column. The net assessable value appears in Taxable Sales Amt. column. |
(ii) Sales to registered dealers at |
Displays the details of interstate sales recorded by selecting: Transaction details are displayed in decreasing order of net assessable value. The transaction with the highest net assessable value appears here. The tax rate appears in Rate% column. The net assessable value appears in Taxable Sales Amt. column. |
(iii) Sales to the Government at |
Displays the details of interstate sales with the highest net assessable value, recorded by selecting: The tax rate appears in Rate% column. The net assessable value appears in Taxable Sales Amt. column. |
(iv) Sales to persons at |
Displays the net assessable value of interstate sales recorded by selecting composition or unregistered dealer |
(v) Sales of goods (sub-section (5) of Section 8) at |
Displays the net assessable value of sales recorded by selecting: |
(vi) Other Sales 1 at |
Displays the details of second highest transaction (net assessable value) made to registered dealer. |
(vii) Other Sales 2 at |
Displays the details of third highest transaction (net assessable value) made to registered dealer. |
Total (i to vii) |
Displays auto calculated value. |
Tax paid |
Displays the amount from Amount column of CST Payments section of Form VAT 1V. |
Input Tax Credit |
|
Tax Payable |
Displays the CST amount due captured in Form CST 1V report. |
25% of Tax (NPV) |
Displays auto calculated value (25% of Tax Payable value). |
Enclosures |
|
(i) List of inter-state sales with particulars thereof under Rule(5) |
Displays these options in Export Report screen with the provision to set it to Yes or No. |
(ii) List of inter-state sales with particulars thereof under Rule(6) |
|
(iii) List of inter-state sales wherein no concessional rate of tax is claimed under Rule(8) |
|
(iv) List of subsequent sales under Rule(7) |
|
CST Payments |
|
Challan No |
Displays the Challan/Instrument No. entered for payment voucher, in the Stat Payment Details screen of Tax Payment Reconciliation report. |
Challan Date |
Displays the Challan Date entered for payment voucher, in the Stat Payment Details screen of Tax Payment Reconciliation report. |
Period From |
Displays the Period From date displayed for payment voucher, in the Stat Payment Details screen of Tax Payment Reconciliation report. |
Period To |
Displays the Period To date displayed for payment voucher, in the Stat Payment Details screen of Tax Payment Reconciliation report. |
Amount |
Displays the amount entered in CST payment voucher. |