All Columns in Excel File  are Mandatory

  Data Entry in Excel File::
a TIN: Enter TIN Number

b

Form Type: Select Form type from the list

c

Form No: Enter correct Prefix and Leaf No

d

Consignee TIN: Enter Consignee TIN

e

Consignee Name: Enter Consignee Name

f

Consignee Address: Enter Consignee Address

g

Vehicle No.: Enter Vehicle Number

h

Transport Name: Enter Transporter name

i

Invoice No.: Enter Invoice number

j

Invoice Date: Enter Invoice Date - e.g., dd-mm-yyyy (EX. 01-05-2007)

k

Commodity: Select from list . If many Goods under same invoice, use ‘Multiple Goods’ as Commodity Classification.

l

Quantity: Enter quantity. If Commodity selected is ‘Multiple Goods’, enter 1 in Quantity field.

m

Unit of Measurement: Select unit from list like MTS, Quintals, KGs. In case of ‘Multiple Goods’, use NA as Unit of measurement.

n

Value: Enter value of Goods in Rs

o

Form Utilised Date: Enter Utillised Date - e.g., dd-mm-yyyy (EX. 01-05-2007)

  Uploading File:

p

Go to Transactions Menu ---->Select Upload Excel Sheet  Note: While uploading, Close the Excel File.

q

Browse the Excel file and Click Upload button

r

Verify the uploaded data in the grid which is shown in the screen, if you feel to make changes or delete the records, click concern Edit button or Delete button.  Note: you can't modify the Invoice No, Invoice Date and Form Utilization date.

s

Click Submit button.  Once Submit Utilization is clicked, no more Invoices can be added to same Form.

t

Click Exit button to exit from the screen.

 
Sample Filled Excel Sheet
p1
p2