Annexure - LS5 captures invoice wise details of sales of goods within the State to UNICEF, UNTAB, WHO, other prescribed UN bodies or foreign missions.
To view and export Annexure - LS5
1. Go to Gateway of Tally > Display > Statutory Reports > VAT > select Form VAT R1.
2. Select Annexure Ready and press Enter.
3. Select Annexure - LS5 and press Enter. The Annexure - LS5 screen appears.
4. Click E: Export.
5. Press Enter to export data.
The exported data appears in the TEMPLATE-VAT-RETURN-R1-LS5TAB-DETAIL_OF_SALE.xls file.
Note: The Excel file should be imported into the return filing utility provided by the government.
The value of LS5 is captured in Form VAT R1 - 2B (6) Sale of goods in the state to the prescribed UN agencies and foreign mission.
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. |
TIN/Registration Application No |
Displays the TIN or application number of the organisation to which the sale is made (as entered in the Statutory Details screen while recording sales invoice). |
Sale Invoice /Delivery Note No. * |
Displays the invoice number of the sales transaction. |
Sale Invoice /Delivery Note Dated * |
Displays the invoice date of the sales transaction. |
Name of major commodity sold * |
Displays the commodity name predefined for the stock item selected in the sales 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 sold |
If commodity name provided by the department is not selected in the Name of major commodity sold * 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 sales transaction. The unit of measurement is listed as per the list provided by the department. In case of an accounting invoice the field will be blank. |
Quantity |
Displays the total quantity of the stock items as per the invoice. In case of an accounting invoice the field will be blank. |
Value of Goods* |
Displays the net assessable value of sales with Nature of Transaction selected as Sales Zero Rated. |