To generate a downloadable file:
A: Inward is for goods coming in (supplier to you). Outward is for goods going out (customer delivery or scrap). Do not mix them.
Add a new sheet with:
Date: [Select Date]
Total Inward Entries: [COUNT of Gate Pass No.]
Total Vehicles: [COUNT unique Vehicle No.]
By Material:
- Steel: XX entries
- Cement: XX entries
In cell A2, enter: ="IGP-"&TEXT(TODAY(),"YYYYMMDD")&"-"&ROW(A1) – This creates a unique number based on today’s date. inward gate pass format in excel download
Protect sheet after setup to prevent accidental header changes
(Best for a website download page or an article)
Title: Free Inward Gate Pass Format in Excel (Download Now) To generate a downloadable file: A: Inward is
Managing the inflow of materials is a critical operation for any business. Without a proper gate entry system, tracking incoming inventory becomes a nightmare. If you are looking for a simple solution to record incoming goods, you need a standard Inward Gate Pass Format in Excel.
What is an Inward Gate Pass? An Inward Gate Pass (IGP) is a document used by the security guard or gatekeeper to record the details of materials entering the premises. It acts as proof of receipt and is later matched with the Purchase Order (PO) and the Supplier's Challan/Invoice.
Why Use Our Excel Format? Our template is designed to be print-friendly and calculation-ready. Protect sheet after setup to prevent accidental header
[DOWNLOAD BUTTON: Inward Gate Pass Excel Template]
How to Use:
| K | L | M | N | O | P | Q | |---|---|---|---|---|---|---| | PO/DO No. | Challan No. | Expected Time | In-Time | Out-Time | Security Remark | Authorized By | | PO-101 | CH-202 | 10:00 AM | 10:15 AM | 11:30 AM | Verified | Ramesh |
| Field | Formula Example |
|-------|----------------|
| Gate Pass No. | ="GP/IN/"&TEXT(ROW(A2)-1,"000") |
| Date (auto) | =TODAY() |
| In Time (auto) | =NOW() (Ctrl+Shift+; for static) |
| Out Time | Manual entry when leaving |