Fill H-Form Utilisation Excel File (Telangana Sales Tax)

After Downloaded the H-Form Utilisation Excel File, Fill the Excel File as follows: 

> Enter Exporter/Purchaser ( Your Company ) TIN Number
> Select Quarter. (Quarter selection is based on Invoice/s date)

• April, May, June (1st Quarter)
• July, August, Sep (2nd Quarter)
• Oct, Nov, Dec (3rd Quarter)
• Jan, Feb, Mar (4th Quarter)

> Enter Purchase Invoice/s Year
Eg-1: If Invoice Date: 28-10-2014, Enter Year as 2014.
Eg-2: If Invoice Date: 05-01-2015, Enter Year as 2015.


> Enter Buyer Purchase order No / Letter of Credit (L.C) No / Any other agreement No.

• If not available Just Enter N/A

> Your must enter Purchase order Dt / Letter of Credit (L.C) Dt / Any other agreement Dt.

• Date must be (dd-mm-yyyy) Format. 
• This date must be before the Purchase Invoice/s Date.

> Column A: Enter Sl.No (Eg.1,2,3)
> Column B: Enter Seller TIN Number.
For Seller TIN or CST Number Verfication, please visit this: Click Here

> Column C: Enter Seller Name (Maximum: 100 Characters)
> Column D: Enter Seller Address (Maximum: 250 Characters)


> Column E: Enter Vehicle No.
If Vehicle number is not applicable when goods are transported through:

•  If by Parcel service mention: By Parcel
•  If goods are transported by train mention: By Train
•  If goods are transported by courier mention: By Courier

> Column F: Enter Courier or transporter name. Ex: By GATI, SRMT etc.,

• If Transporters name is not applicable mention By Train/ By Courier

> Column G: Enter Purchase Invoice No.
> Column H: Enter Purchase Invoice Date (Date Format (dd-mm-yyyy).

• The dates Should be within the Selected Quarter and Year
• Invoice date must be later the Agreement no.

> Column I: Select Commodity.

•  If Commodity not found in the list select, Others from the list.
•  If Multiple commodities are transported through single invoice select Multiple goods from the list.

> Column J: Enter Invoice total Qty.

• If Commodity selected is ‘Multiple Goods’, enter the total quantity number in Quantity field.

> Column K: Select unit from list like MTS, Quintals, KGs.

• In case of ‘Multiple Goods’, use NA as Unit of measurement.

> Column L: Enter value of Goods in Rupees without paise.

• Quarter selection is based on Invoice date. (Eg: Invoice dt is 05-10-2011. so you must select 3rd Quarter)
• Agreement Date : Enter Agreement Date in dd-mm-yyyy format (EX. 01-05-2007) and the Agreement date Should be Less than the Invoice dates.
• Column H: Invoice dt format (dd-mm-yyy). Eg: 01-10-2011. dont enter 01-8-2011 or 01.08.2011
• Don't use special characters in whole excel sheet. Eg: ", ', =, + etc.
• All Columns in Excel File are Mandatory.
• Don’t Leave empty rows between the data rows.
• Use one excel file for one supplier and one quarter