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

Annexure LP-7 Table D captures invoice wise and rate wise details of goods purchased as exempted goods, purchased from unregistered dealers and zero rated purchases.

To view and export Annexure LP-7 Table D

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 D and press Enter. The Annexure LP-7 Table D is displayed.

4.     Click E: Export.

5.     Press Enter to export data.

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

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

The value of LP-7 Table D is captured in Form VAT R1 - 3A (7)(ii)(a) Other purchases in the State.

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 person/dealer from whom goods purchased/Type of Purchase *

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/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).

Invoice No. *

Displays the seller’s invoice number (as entered in the Party Details screen while recording purchase transaction).

Invoice Dated *

Displays the seller’s invoice date (as entered in the Party Details screen while recording purchase transaction).

Name of 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 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 as applicable under HVAT Act, 2003 on the commodity in the State of Haryana *

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 purchase with Nature of Transaction selected as Purchase exempt, Purchase from Unregistered Dealers, Purchase - Zero Rated and Interstate Purchase - Zero Rated.

Whether goods classified as capital goods

This field is enabled when Nature of Transaction is selected as Purchase taxable - Capital goods in VAT Details screen while recording purchase transaction.