Gate Pass Format in Excel (Free) – Returnable & Non-returnable with Register

Returnable gate pass format in Excel with items, vehicle and signatures

Advertisement

Quick answer: A material gate pass is the slip security checks before goods leave the gate. It shows:

  • the pass number, date and time
  • whether the material is returnable (job work, repair, calibration) or non-returnable (sale, scrap, transfer)
  • who it goes to, the purpose, the vehicle and who is carrying it
  • each item with its quantity and unit
  • signatures from stores, the approver, security and the receiver

Download a free gate pass format in Excel below. It comes with a register that tracks returnable material until it comes back.

Key takeaways

  • Gate pass with up to 8 items, units from a list and four signature boxes.
  • A return-by date for returnable passes, with a warning if it is missing.
  • Register for up to 500 passes: quantity out, quantity back, pending and status.
  • Overdue warning with days late, against today’s date.
  • Counts of material still out, overdue passes and passes this month.

↓ Jump to the free download

FOR DISPATCH DESKSKnow where every consignment is.XploreShip tracks expected delivery, e-way bill validity, late shipments and missing PODs.See XploreShip — from ₹699 →⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceXploreShip

Returnable gate pass format in Excel with items, vehicle and signatures
Flanges going out for job work, with the wooden pallet that has to come back too.

Returnable gate pass register

Returnable gate pass register in Excel with pending quantity and overdue status
Three passes are overdue. One has 40 brackets still at the galvaniser.

How to use the template

  1. Gate Pass: type your company name once. For each pass, fill in the number, type, return-by date, party, vehicle and items. Print it in two copies, one for security.
  2. Register: add one line per pass. When returnable material comes back, enter the quantity back and the date.
  3. Check the overdue count every morning and call those parties.

Tips for stores and security

  • Number passes in sequence and never reuse a number.
  • Pallets, crates and drums are returnable too. Put them on the pass.
  • Security should count, not just sign. A gate pass is only useful if the count is checked at the gate.
Outgrown the free sheet? Here’s what XploreShip adds

Free sheetXploreShip
In-transit board and POD pending list—✓
Transporter on-time % and freight balance—✓
Transporter on-time report—✓
Claims register—✓
Dispatch advice—✓
Fill-in forms & one-click PDF (macro edition)—✓

⚡ Instant download · ♾️ Lifetime access · 💳 Pay onceGet XploreShip — from ₹699 →

Download the free Gate Pass Format

There are two sheets: Gate Pass and Register. Fill in the yellow cells; everything else is worked out.

Get updates and new free templates

Your download below doesn’t need this. Leave your WhatsApp number or email and I’ll send you fixes for this file and new free templates. No spam, unsubscribe anytime.

Was this template useful?

FAQs

Is a gate pass the same as a delivery challan?

No. A gate pass is an internal security document. Goods sent for job work or sale usually also need a delivery challan or invoice, and an e-way bill where it applies.

Advertisement

Can schools or offices use it?

Yes. It works for laptops, projectors or furniture going out for repair.

What does Days late count?

For overdue passes, it counts days from the return-by date to today. For returned passes, it shows how many days late they came back.

More free templates

Advertisement

Amanpreet Kaur Bharaj
I'm Amanpreet Kaur Bharaj from Hoshiarpur, Punjab. I've worked in Excel for about 12 years, and since 2022 I've run my own ethnic-wear boutique, Punjabi Libas, on Excel files I built myself. XplorExcel is where I share those files: free templates for everyday business work, and ready-made Excel software for shops, boutiques, clinics, dairies, mandis and offices. Every file comes with a filled-in sample so you can see how it works. Stuck with one? Message me and I'll help.