Annexure LP-8 Table A captures invoice wise and dealer wise details of purchase return of goods (including capital goods).
To view and export Annexure LP-8 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 LP-8 Table A and press Enter. The Annexure LP-8 Table A appears.
4. Click E: Export.
5. Press Enter to export data.
The exported data appears in the TEMPLATE-VAT-RETURN-R1-LP8A-LIST_OF_RETURN_OF_GOODS_PURCHASED-EXCEL.xls file.
Note: The Excel file should be imported into the return filing utility provided by the government.
The value of LP-8 Table A is captured in
● Form VAT R1 - 3B (b)(i) Increase/Decrease in Purchases turnover as effect of return of goods & (de-)/ escalation as per LP-8.
● Form VAT R1 - 3B (b)(ii) Increase/Decrease in Tax Paid as effect of return of goods & (de-)/ escalation as per LP-8.
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 Purchase* |
Displays the nature of purchase as per the Nature of Transaction selected. |
Name of the seller/person to whom DDN issued as the case may be * |
Displays the name of the seller to whom the goods are returned. The Debit Note is issued to this seller. |
TIN/Registration Application No.* |
Displays the TIN or application number of the seller to whom the goods are returned. |
DDN No. * |
Displays the debit note number. |
DDN Date * |
Displays the debit note date. |
DDN Amount * |
Displays the total value of the debit note. |
Original Sale Invoice No. * |
Displays the seller’s invoice number (as entered in the Statutory Details screen while recording debit note). |
Original Sale Invoice Date * |
Displays the seller’s invoice date (as entered in the Statutory Details screen while recording debit note). |
Total Value of the Original Invoice (Amount in) * |
Displays the seller’s invoice value (as entered in the Statutory Details screen while recording debit note). |
Name of major commodity purchased |
Displays the commodity name predefined for the stock item selected in the debit 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 purchased |
If commodity name provided by the department is not selected in the Name of major commodity purchased 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 purchase 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 debit 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 with Nature of Transaction selected as: ● Purchase Deemed Export ● Interstate Purchase Deemed Export ● Interstate Purchase Exempt - E1 ● Interstate Purchase - E2 ● Interstate Purchase - E1 ● Interstate Purchase - Against Form C ● Interstate Purchase - Zero Rated ● Interstate Purchase Exempt ● Interstate Purchase - Taxable ● Purchase High Seas ● Imports |
Reduction in Tax Paid on Purchases (including surcharge) |
Displays the tax value. |
Whether goods classified as capital goods |
This field is enabled when Purchase taxable - Capital goods is selected as the Nature of Transaction in VAT Details screen while recording ledger master. |