Annexure LP-7 Table A of Form VAT R1 (Haryana)

Annexure LP-7 Table A captures dealer wise and rate wise details of goods purchased at full rate of tax (including capital goods) from registered dealers within the state.

To view and export Annexure LP-7 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 the Annexure LP-7 Table A and press Enter. The Annexure LP-7 Table A is displayed.

4. Click E: Export.

5. Press Enter to export data.

The exported data appears in the TEMPLATE-VAT-RETURN-R1-LP7A1-LIST_SHOWING_PURCHASE_OF_GOODS.xls file.

Note: The Excel file should be imported into the return filing utility provided by the government.

The value of LP-7 Table A is captured in Form VAT R1 - 3A (7)(i) Purchases from VAT dealers on tax invoice at full rate of tax.

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 VAT dealer from whom goods purchased*	Displays the name and address of the dealer from whom the goods are purchased (as predefined in the party ledger or entered in the Party Details screen while recording purchase transaction).
TIN/Registration Application No.*	Displays the TIN or application number of the dealer from whom the goods are purchased (as entered in the Party Details screen while recording purchase transaction).
Name of major commodity purchased	Displays the commodity name predefined for the stock item selected in the purchase transaction. 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) purchased as entered in the purchase transaction.
Rate of Tax*	Displays the tax rate prevailing for the commodity purchased in the State of Haryana (as entered in the Statutory Details screen while recording purchase transaction). The tax rate is listed as per the list provided by the department.
Turnover*	Displays the net assessable value of sales with Nature of Transaction selected as Purchase taxable (with and without Surcharge @ 5%), Purchase Capital Goods (with and without Surcharge @ 5%) and Purchase Works Contract (with and without Surcharge @ 5%).
Tax Paid (including surcharge, if applicable)	Displays the tax value.
Whether goods classified as capital goods	This field is enabled when Type of Goods is selected as Capital Goods in VAT Details screen while recording item master.