Exporting Data to e-CST Form 1 (Punjab)

On exporting data to VAT-15 template, the relevant details are displayed in CST-1 worksheet.

The description of CST-1 worksheet is given be low:

Field Name	Description
1. Gross Amount Receivable by Dealer	Displays the: ● Gross assessable value of taxable sales. Displays the total of gross assessable value and separately charged expenses of sales recorded with the following nature of transactions: Expense or income ledger in which the option Include in assessable value calculation for? is set to Not Applicable. ● Interstate Sales - Works contract ● Sales - Works contract ● Sales Taxable ● Interstate Sales - E1 ● Interstate Sales - Against Form C ● Interstate Sales - Taxable ● Net assessable value of exempt sales. Displays the total of net assessable value and separately charged expenses recorded with the following nature of transactions: Expense or income ledger in which the option Include in assessable value calculation for? is set to Not Applicable. ● Interstate Deemed Export ● Interstate Sales High Seas ● Exports ● Interstate Branch Transfer Outward ● Interstate Consignment Transfer Outward ● Interstate Sales Exempt - E1 ● Interstate Sales - E2 ● Interstate Sales - Tax Free ● Interstate Sales - Zero Rated ● Interstate Sales Exempt - With Form C Also, the net assessable value of sales recorded with the following nature of transactions are displayed here: ● Deemed Export ● Sales High Seas ● Branch Transfer Outward ● Consignment Transfer Outward ● Sales - Tax Free ● Sales Zero Rated
Deduct:
(i) Sales of Goods Outside the State (as defined in Sec.4 of the Act)	Displays the credit value entered for sales ledger in journal voucher to account for sale of goods outside the state. To record the sale of goods outside the state 1. Go to Gateway of Tally > Accounting Vouchers > F7: Journal. 2. Click J: Stat Adjustment. o Select VAT as the Type of duty/tax. o Select Decrease in Sale as the Nature of Adjustment. 3. Debit the sales ledger with the nature of transaction Interstate Sales - Against Form C and enter the amount. 4. Debit the CST ledger and enter the amount. 5. Credit the sales ledger with the nature of transaction Interstate Sales - Tax Free. 6. Credit the ledger grouped under branch/division. 7. Press Ctrl+A to accept.
(ii) Sales of Goods Outside the State (as defined in Sec.5 of the Act)	Displays the net assessable value of sales recorded with the following nature of transactions: ● Exports ● Deemed Export ● Interstate Deemed Export ● Interstate Sales High Seas ● Sales High Seas
(iii) Turnover of Goods transferred outside State [as referred in Section 6-A(2)]	Displays the net assessable value of sales recorded with the following nature of transactions: ● Interstate Consignment Transfer Outward ● Interstate Branch Transfer Outward
2. Balance Turnover on Interstate Sale within the State	Displays auto calculated value.
Deduct:
Turnover of Sales within the State	Displays the: ● Gross assessable value of taxable sales. Displays the gross assessable value of sales recorded with the following nature of transactions: ● Sales - Works contract ● Sales Taxable ● Net assessable value of exempt sales. Displays the net assessable value of sales recorded with the following nature of transactions: ● Branch Transfer Outward ● Consignment Transfer Outward ● Sales - Tax Free ● Sales Zero Rated
3. Balance Turnover on Interstate Sales	Displays auto calculated value.
Deduct:
Cost or Freight Delivery or Installation when such cost is separately charged	Displays the value of separately charged expenses in sales. Displays the value of separately charged expenses of sales recorded with the following nature of transactions: Expense or income ledger in which the option Include in assessable value calculation for? is set to Not Applicable. ● Interstate Sales - Works contract ● Sales - Works contract ● Sales Taxable ● Interstate Sales - E1 ● Interstate Sales - Against Form C ● Interstate Sales - Taxable ● Interstate Deemed Export ● Interstate Sales High Seas ● Exports ● Interstate Branch Transfer Outward ● Interstate Consignment Transfer Outward ● Interstate Sales Exempt - E1 ● Interstate Sales - E2 ● Interstate Sales - Tax Free ● Interstate Sales - Zero Rated
4. Balance: Total Turnover on Interstate Sales	Displays auto calculated value.
Deduct:
(i) Turnover of Interstate Sale of Goods unconditionally exempt from Tax under the Punjab general Sale Tax Act 1948	Displays the net assessable value of sales recorded with the following nature of transactions: ● Interstate Sales - Zero Rated ● Interstate Sales - Tax Free
(ii) Turnover of Sale of Goods returned by the purchaser within a period of three months under rule 11(2)(b)of the Central Sales Tax(Registration & Turnover)Rule 1957	Displays the values of sales returns and adjustments whose invoice date is three months (maximum of three months) prior to the original invoice date: Value of sales returns entered in credit note.
(iii) Turnover in respect of subsequent sales falling under clause(a) and (b)of section 6(2)A of the Act	Displays the net assessable value of sales recorded with the following nature of transactions: ● Interstate Sales Exempt - E1 ● Interstate Sales - E2
5. Balance Taxable Turnover in respect of Interstate Sales	Displays auto calculated value.
6. GOODS WISE BREAKUP OF ABOVE
A. Declared Goods:
(i) Sold to registered dealers on prescribed declaration-vide declaration attached	Displays the assessable value of all inter-states taxable sales recorded with the following transaction details: Displays the value of inter-state sales recorded with the following nature of transactions: ● Interstate Sales - Against Form C ● Interstate Sales - E1 ● Interstate Sales - Taxable ● Interstate Sales - Works Contract ● Interstate Sales Exempt - With Form C ● Stock item is predefined as declared goods. In the VAT Details screen of stock item master, set the option Type of goods to Declared Goods. ● Party ledger is predefined as Registered dealer. In VAT Details screen of party ledger, the option Type of Dealer is set to Registered.
(ii) Sold Otherwise	Displays the assessable value of all inter-states taxable sales recorded with the following transaction details: Displays the value of inter-state sales recorded with the following nature of transactions: ● Interstate Sales - Against Form C ● Interstate Sales - E1 ● Interstate Sales - Taxable ● Interstate Sales - Works Contract ● Interstate Sales Exempt - With Form C ● Stock item is predefined as declared goods. In the VAT Details screen of stock item master, set the option Type of goods to Declared Goods. ● In party ledger, the Type of Dealer selected is other than Registered dealer.
B. Other Goods:
Sold to registered Dealers on prescribed declaration-vide declaration attached	Displays the assessable value of all inter-states taxable sales recorded with the following transaction details: Displays the value of inter-state sales recorded with the following nature of transactions: ● Interstate Sales - Against Form C ● Interstate Sales - E1 ● Interstate Sales - Taxable ● Interstate Sales - Works Contract ● Interstate Sales Exempt - With Form C ● Stock item is categorised as regular goods. In the VAT Details screen of stock item master, set the option Type of goods to Not Applicable. ● Party ledger is predefined as Registered dealer. In VAT Details screen of party ledger, the option Type of Dealer is set to Registered.
Sold Otherwise	Displays the assessable value of all inter-states taxable sales recorded with the following transaction details: Displays the value of inter-state sales recorded with the following nature of transactions: ● Interstate Sales - Against Form C ● Interstate Sales - E1 ● Interstate Sales - Taxable ● Interstate Sales - Works Contract ● Interstate Sales Exempt - With Form C ● Stock item is categorised as regular goods. In the VAT Details screen of stock item master, set the option Type of goods to Not Applicable. ● In party ledger, the Type of Dealer selected is other than Registered dealer.
Total :	Displays auto calculated value.
7. TAX WISE BREAKUP OF SALES
Taxable At %	Displays the rate of tax charged on sales recorded with the following nature of transactions: ● Interstate Sales - Works contract ● Interstate Sales - E1 ● Interstate Sales - Against Form C ● Interstate Sales - Taxable ● Interstate Sales Exempt - With Form C
On which Tax Amount To (Rs.)	Displays auto calculated value.
7A Add: Any other Tax amout(due to rounding off)	This field will be currently left blank.
8 TOTAL TAX PAYABLE ON Rs.	Displays auto calculated value.
AMOUNT OF Rs.	Displays auto calculated value.
9 TAX PAID IF ANY BY MEANS OF TREASURY CHALLAN/CHEQUE/ DRAFT	Displays the: ● CST amount entered in tax payment voucher. To create a payment voucher 1. Go to Gateway of Tally > Display > Statutory Reports > VAT > Form VAT III. 2. Click S: Stat Payment. In the Stat Payment Details screen, o Select CST in Tax Type. o Enter the dates in Period From and To fields. o Select the Type of Payment as Regular. o Press Enter to return to payment voucher. 3. Select the bank ledger. 4. Select the CST ledger and enter the amount. 5. Press Ctrl+A to accept. ● Challan/Instrument No., Deposit Date, Name of the Bank, and Name of the Branch entered for the CST payment voucher, in Stat Payment Details screen of Tax Payment Reconciliation report.
10 (i) BALANCE DUE, IF ANY	Displays auto calculated value.
10 (ii) EXCESS PAID, IF ANY	Displays auto calculated value.
Remarks (if any)	Displays the Remarks entered in the Export Report screen of Form CST 1 report.