A nnexure - LS10A captures invoice wise and dealer wise details of sales return of goods (including capital goods).
To view and export Annexure - LS10A
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > select Form VAT R1 .
2. Select Annexure Ready and press Enter .
3. Select Annexure - LS10A and press Enter . The Annexure - LS10A 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.
N ote: T he Excel file should be imported into the return filing utility provided by the government.
T he value of LS10A is captured in:
o Form VAT R1 - 2D (b)(i) Increase/Decrease in sales turnover as effect of return of goods & (de-)/ escalation as per LS-10 .
o 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 |
D isplays 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. I f commodity name provided is other than those provided by the department, Others is displayed. |
Other name of commodity sold |
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 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. |