Annexure LS-10 Table A captures invoice wise and dealer wise details of sales return of goods (including capital goods).
To view and export Annexure LS-10 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-10 Table A and press Enter. The Annexure LS-10 Table A appears.
4. Click E: Export.
5. Press Enter to export data.
The exported data appears in the TEMPLATE-VAT-RETURN-R1-LS10A-LIST_OF_RETURN_OF_GOODS_SOLD.xls file.
Note: The Excel file should be imported into the return filing utility provided by the government.
The value of LS-10 Table A is captured in:
● Form VAT R1 - 2D (b)(i) Increase/Decrease in sales turnover as effect of return of goods & (de-)/ escalation as per LS-10.
● Form VAT R1 - 2D (b)(ii) Increase/Decrease in Tax as effect of return of goods & (de-)/ escalation as per LS-10.
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. |
Nature of Sale* |
Displays the nature of sales as per the Nature of Transaction selected. |
Name of the person issuing DDN* |
Displays the name of the purchaser to whom the goods were sold. The Credit Note is issued to this purchaser. |
TIN/Registration Application No.* |
Displays the TIN or application number of the purchaser by whom the goods are returned. |
DDN No. * |
Displays the credit note number. |
DDN Date * |
Displays the credit note date. |
DDN Amount * |
Displays the total value of the credit note. |
Original Sale Invoice No. * |
Displays the sales invoice number (as entered while recording credit note). |
Original Sale Invoice Date * |
Displays the sales invoice date (as entered while recording credit note). |
Total Value of the Original Invoice (Amount in) * |
Displays the sales invoice value (as entered while recording credit note). |
Name of major commodity sold |
Displays the commodity name predefined for the stock item selected in the credit note. 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 goods( major commodity) returned as entered in the credit note. |
Rate of Tax* |
Displays the tax rate prevailing for the commodity in the State of Haryana. The tax rate is listed as per the list provided by the department. |
Value of goods Returned* |
Displays the net assessable value of the goods returned. |
Reduction in Tax (including surcharge, if charged) |
Displays the tax value. |