A nnexure - LS9C captures invoice wise and rate wise details of goods sold to unregistered dealers and consumers.
T o view and export Annexure LS-9 Table C
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > select Form VAT R1 .
2. Select Annexure Ready and press Enter .
3. Select Annexure - LS9C and press Enter . The Annexure - LS9C screen appears.
4. Click E : Export .
5. Press Enter to export data.
The exported data appears in the TEMPLATE-VAT-RETURN-R1-LS9C-LIST_SHOWING_SALE_OF_GOODS.xls file.
N ote: T he Excel file should be imported into the return filing utility provided by the government.
T he value of LS9C is captured in Form VAT R1 - 2C (2) Turnover Short taxed 2C(1)- 2C .
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 person 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). |
Description of Sales* |
Displays the description of the sales transaction. Sale of Goods at Full rate of tax transactions is displayed when Nature of Transaction is selected as Sales Taxable (Full rate of tax) in Statutory Details screen while recording a sales transaction. Sale of Goods at Lower rate of tax transactions is displayed when Nature of Transaction is selected as Sales Taxable (Lower rate of tax) in Statutory Details screen while recording a sales transaction. Sale Works Contract transactions is displayed when Nature of Transaction is selected as Sales works contract in Statutory Details screen while recording a sales transaction. |
Sale Invoice No. |
Displays the invoice number of the sales transaction. |
Invoice Dated |
Displays the invoice date of the sales transaction. |
Name of major commodity sold |
D isplays 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. I f commodity name provided is other than those provided by the department, Others is displayed. |
Other name of commodity purchased |
I f 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 as applicable under HVAT Act, 2003 on the commodity in the State of Haryana * |
Displays the actual rate of tax 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 including surcharges. |