Annexure LP-7 Table B captures dealer wise and rate wise details of goods purchased at lower rate of tax (including capital goods) from registered dealers within the state.
To view and export Annexure LP-7 Table B
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 B and press Enter. The Annexure LP-7 Table B is displayed.
4. Click E: Export.
5. Press Enter to export data.
The exported data appears in the TEMPLATE-VAT-RETURN-R1-LP7B1-LIST_OF_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 B is captured in Form VAT R1 - 3A (7)(i)(a) Purchases from VAT dealers on tax invoice at lower 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 as applicable under HVAT Act, 2003 on the commodity in the State of Haryana * |
Displays the full tax rate prevailing for the commodity purchased in the state of Haryana. |
Rate of Tax applicable against D1 form* |
Displays the lower rate of tax at which the goods are purchased against D1 form (as entered in the Party Details screen while recording purchase transaction). |
Turnover* |
Displays the net assessable value of purchase 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 Nature of Transaction is selected as Purchase taxable - Capital goods in VAT Details screen while recording purchase transaction. |