February 28, 2013
Help File for uploading Waybill Utilization
1. Download the Excel File template and save on your computer
2. No field in the excel sheet should be NULL
Guide lines for entering data into Excel sheet :
3. TIN : Enter TIN of the dealer who has issued the way bill
4. Select the type of way bill from the drop down menu. (VAT or CST)
5. Enter the prefix of the way bill(Example: I or G or L for VAT Waybills andCST forCST way bill
6. Enter the way bill leaf number
7. Enter consignee/buyer TIN/TOT number. If there is no TIN/ TOT for the buyer enterNIL. If it is self purchase, Stock/Branch transfer then enter TIN of the Waybill issuing dealer
8. Enter Buyer/Consignee name. This should not be blank. If it is self purchase or stock/branch transfer enter ‘SELF’.
9. Enter Buyer/Consignee address. This should not be blank.
10. Enter vehicle number. Ifno vehicle number is available (when sent through transport company etc) then enter ‘NIL’.
11. Enter Transporter Name. If not available enter ‘NIL’
12. Enter invoice number. If it is self purchase then enter Vr, No. If it is Stock/Branch transferthen enterD.C. No.
13. Enter invoice date. If it is self purchase then enter Vr, Date.. If it is Stock/Branch transfer then enter D.C .date. Date should be indd-mm-yyyy format only
14. Select commodity from the dropdown list. Do not enter manually
15. Enter quantity of the goods transported. Enter only numbers
16. Select units of measurement from the dropdown list. Do not enter manually.
17. Enter value of the goods transported. Do not enter paise.
18. Enter form utilized date (way bill date). This can be equal to or later than the way bill issue date from the AC/CTO’s office. It can not be before the way bill issue date from the AC/CTO’s Office.