Annexure LS-9 Table A captures dealer wise and rate wise details of goods sold at full rate of tax to registered dealers within the state.
To view and export Annexure LS-9 Table A
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > select Form VAT R1.
2. Select Annexure Ready and press Enter.
3. Select Annexure LS-9 Table A and press Enter. The Annexure LS-9 Table A screen appears.
4. Click E: Export.
5. Press Enter to export data.
The exported data appears in the TEMPLATE-VAT-RETURN-R1-LS9A1-LIST_SHOWING_SALE_OF_GOODS.xls file.
Note: The Excel file should be imported into the return filing utility provided by the government.
The value of LS-9 Table A is captured in Form VAT R1 - 2C(1) Taxable turnover of sales as per 2A(b)-2B(10)(b).
The description of the information displayed in each field of the Excel sheet is given below:
Field Name |
Description |
Serial No. |
Displays the serial number of the rows in the annexure. |
Name of the registered dealer to whom goods sold* |
Displays the name of the purchaser to whom the sale is made (as predefined in the party ledger or entered in the Party Details screen while recording sales invoice). |
TIN/Registration Application No. * |
Displays the TIN or application number of the purchaser to whom the sale is made (as entered in the Statutory Details screen while recording sales invoice). |
Name of major commodity sold * |
Displays the commodity name predefined for the stock item selected in the sales transaction. The major commodities are listed as per the list provided by the department. If commodity name provided is other than those provided by the department, Others is displayed. |
Other name of commodity sold |
If commodity name provided by the department is not selected in the Name of major commodity sold * field, then the commodity name provided in the stock masters is displayed. |
Unit of measurement |
Displays the unit of measurement for the stock item selected in the sales transaction. The unit of measurement is listed as per the list provided by the department. |
Quantity |
Displays the quantity of the stock items sold as per the invoice. |
Rate of Tax* |
Displays the rate at which the goods are sold in the State of Haryana. |
Turnover* |
Displays the net assessable value of sales with Nature of Transaction selected as Sales Taxable (with and without surcharge @ 5%) and Sales Works Contract (with and without surcharge @ 5%). |
Tax (including surcharge, if applicable) |
Displays the tax value. |