A nnexure - LP8A 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 - LP8A and press Enter . The Annexure - LP8A 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.xls file.
N ote: T he Excel file should be imported into the return filing utility provided by the government.
T he value of LP8A is captured in
o Form VAT R1 - 3B (b)(i) Increase/Decrease in Purchases turnover as effect of return of goods & (de-)/ escalation as per LP-8 .
o 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 |
D isplays 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. 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 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: ● P urchase 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 ● Interstate Purchase Exempt - With Form C |
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. |