Inward Gate Pass (IGP) is a vital document for tracking goods, vehicles, and personnel entering a facility. A comprehensive Excel format should include the following core sections and data fields: 1. Header & General Information
| S.No. | Gate Pass No. | Date | Supplier Name | Vehicle No. | Driver Name | Driver Contact | Material | Quantity (Units) | Purpose | In Time | Out Time | Gate Entry By | Remarks | |------|--------------|------|--------------|-------------|-------------|----------------|----------|----------------|---------|---------|----------|---------------|---------| | 1 | GP/IN/001 | 23-Apr-2026 | ABC Traders | MH12AB1234 | Ramesh Kumar | 9876543210 | Steel Sheets | 500 kg | Material Delivery | 09:30 AM | 01:15 PM | Sanjay S. | OK | inward gate pass format in excel download
You can build your own template by setting up these standard columns in an Excel sheet: Key Fields to Include Basic Info Inward Number, Date, Time of Arrival Supplier Details Vendor Name, Supplier Address, Contact Person Document Links Inward Gate Pass (IGP) is a vital document
[Insert downloadable Excel file: Inward Gate Pass Format.xlsx] Supplier Name & Address Transporter Name Vehicle Number
Use Excel Data Validation (Data > Data Validation) on the "Unit" column to restrict entries to a dropdown list (Kg, Liters, Nos, Meters).