Free template · Stores and dispatch

Gate Pass Format: Free Excel Template with Filled Example

A gate pass is a numbered, signed slip for goods leaving or entering your factory. Download the free Excel format for returnable and non-returnable passes, with every column explained and a filled auto-parts example. No sign-up.

Download the Excel template

A gate pass is a numbered slip, approved by a manager and checked by security, for goods or vehicles leaving or entering a factory. A standard gate pass format has the pass number, date and time, and type (returnable or non-returnable). It also has the party, the linked invoice or delivery challan number, the vehicle number, item lines with quantity, and signatures. It is an internal control: it does not replace the GST invoice, delivery challan or e-way bill the movement may need.

What is a gate pass?

A material gate pass is written permission for goods to cross your gate. Stores raises it, a manager signs it, and security checks it at the gate.

Types of gate pass

Gate passes split by direction (inward or outward) and by return. A returnable gate pass (RGP) is for goods that must come back. A non-returnable gate pass (NRGP) is for goods that leave for good.

TypeWhen to use itFields that become required
NRGP (outward)Sale, scrap, transfer to another siteInvoice or challan number, vehicle number, e-way bill number where needed
RGP (outward)Repair, calibration, loan, trial, job workPurpose, party, challan number, expected return date
Inward against an RGPYour own goods coming backOriginal RGP number, quantity, date, condition
Inward (new material)Supplier deliveriesSupplier invoice or challan number, PO number; then a GRN
Vehicle passTrucks, tempos, visitor vehiclesVehicle number, driver, time in and out

What each column in the gate pass format means

The Excel file has 12 columns, one row per item line.

ColumnWhat to writeRequired?
Pass no.A serial that never repeats, such as GP/26-27/0412Required
DateDate the pass is issuedRequired
TypeRGP or NRGP, and In or OutRequired
Party (purpose)Who gets the goods, and why: sale, repair, job work, scrapRequired
Document no.Invoice or delivery challan number, plus the e-way bill number if neededRequired for goods leaving
Vehicle no.Truck or tempo number, or "Hand-carried"Required
Item (unit)Item name or code, with Nos, kg or metresRequired
Qty outQuantity counted at the gateRequired
Return byDate the goods must be backRequired for RGP
Qty backQuantity returned, with the dateRGP only
PendingQty out minus qty back, and days overdueRGP only
Signed byManager's signature; guard's name, time out and "count OK"Required

Need it in Word? Use the same fields, with the item lines in a table and two signatures at the bottom.

How to fill a gate pass, step by step

  1. Raise: stores fills the type, party, purpose, items and quantity, plus the return date for an RGP.
  2. Approve: the manager signs before the goods reach the gate.
  3. Link: write the invoice or challan number, and the e-way bill number if there is one.
  4. Check out: security counts the goods, notes the vehicle and time, and signs. The driver carries a copy.
  5. Check in and close: security logs returned RGP goods. Stores closes the pass only when the full quantity is back.

[[IMAGE {"type":"checklist","title":"What security checks before goods leave","items":["Signed pass with a unique number","Invoice or challan number on the pass","E-way bill number, where needed","Count matches the pass","Vehicle number and time out","Return date on every RGP"]}]]

Worked example: three gate passes at an auto-parts factory (illustrative numbers)

An auto-parts maker near Pune sends out three loads in one fortnight.

Example: a sale, a repair and a job-work pass

PassType and purposeDocumentsItems out
GP/26-27/0412, 10 NovNRGP: sale to a tractor maker, NashikINV/26-27/1187; EWB 3412 0098 7612400 brake drums, 250 hub flanges
GP/26-27/0398, 27 OctRGP: motor rewinding, Bhosari; due 10 NovDC/26-27/0076; no EWB (₹38,000, below ₹50,000)1 motor, 7.5 kW
GP/26-27/0405, 3 NovRGP: zinc plating job work, Chakan; due 17 NovDC/26-27/0081; EWB 3412 0101 4588 (₹1,80,000)2,000 MB-12 brackets

Example: RGP register on 25 Nov 2026, what is still outside and overdue

Pass and itemOut and backPendingStatus on 25 Nov
GP/26-27/0391, vernier calipers (calibration)6 out, 6 back on 29 Oct (due 30 Oct)0Closed
GP/26-27/0398, 7.5 kW motor (rewinding)1 out, 0 back (due 10 Nov)115 days overdue
GP/26-27/0405, MB-12 brackets (plating)2,000 out, 1,500 back on 15 Nov (due 17 Nov)5008 days overdue

That morning, stores calls the rewinding shop and the plater. Sale pass 0412 is an NRGP, so it never appears in this register.

See how your invoices, e-way bills, GRNs and job-work records line up in one place.

Book a demo →

Gate pass vs delivery challan vs e-way bill

These three often travel together but do different jobs. The gate pass is your own record; the other two are GST documents.

DocumentWhat it doesWhen you need it
Gate passRecords that goods crossed your gate, who approved it, and whether they returnEvery gate movement. It never replaces a GST document.
Delivery challan (Rule 55, CGST Rules)Goes with goods moved without an invoiceJob work, or moves other than supply. Serially numbered, up to 16 characters.
E-way billRecords the goods movement for GSTInter-state job work: always, whatever the value. Other moves: usually above ₹50,000.

Check with your accountant which documents each movement needs. See our delivery challan format and e-way bill format.

Common gate pass mistakes

MistakeWhat goes wrongFix
No return date on an RGPNobody knows when the goods are lateMake the date required on every RGP
Re-dating an overdue passThe delay disappears from the registerKeep the first date; note any agreed extension beside it
No invoice or challan numberGoods leave without their GST documentSecurity releases nothing without the number
Closing on a partial returnPending items drop off the listClose only when the full quantity is back
Handwritten numbers that repeatTwo passes share a numberUse pre-printed or system serial numbers

Sample authorisation letter for a gate pass request

Some sites ask for a letter when someone outside stores collects goods:

To: The Security In-charge, [Factory name]. Date: 3 Nov 2026.

Subject: Authorisation to take out material on RGP GP/26-27/0405

I authorise Mr Sunil Jadhav, driver of MH 14 GH 2290, to collect 2,000 Nos of mounting bracket MB-12. They go to our job worker in Chakan for zinc plating, under challan DC/26-27/0081. They must come back by 17 Nov 2026. Please release them after checking the count against the gate pass.

Signed: [Name], Stores Manager, [Phone]

Where TranZact fills these details for you

Every gate pass points to another record: an invoice, an e-way bill, a GRN or a stock movement. When those sit across Tally, Excel and WhatsApp, stores retypes each number by hand. That is where mismatches start.

TranZact's manufacturing AI software, used by 10,000+ manufacturers, keeps those records in one place:

  • E-way bill: generated from the GST invoice, with the e-invoice (IRN) in the same flow, on all plans.
  • Dispatch: part of the sales flow, with enquiry, quotation, order timeline, e-invoicing and payment.
  • Inward goods: purchase management runs MRP report, indent, RFQ, PO, GRN and payment. See our GRN format too.
  • Job work: sub-contracting is part of production management.
  • Stock: inventory management covers stock in, issue, transfer, bin card and multi-store. See our material transfer note format.
  • Accounts: accounting stays in Tally, with one-way sync and no double entry. Busy and Zoho Books work too.

The honest limit: the gate pass slip itself stays with your security desk. TranZact's live product pages don't list a gate pass or RGP document. What changes is that stores copies each number from one system. Teams go live in 2–3 weeks, with no consultants and no IT team.

TranZact facts (as of 17 Nov 2026)

FactPlanSource
E-way bill generated from the GST invoice, with e-invoice (IRN) in the same flowAll plansTranZact
Routing and sub-contractingGrow, Scale+ and Dominateletstranzact.ai/pricing
Tally, Busy and Zoho Books integration; accounting stays in TallyGrow, Scale+ and Dominateletstranzact.ai/pricing
Live in 2–3 weeks—TranZact

Don't be the bottleneck. Become the AI-Run Factory.

Your gate register should tell you what is outside and what is late, without a round of phone calls. Bring last month's RGP list to the demo. We'll show where each invoice, e-way bill, GRN and job-work record sits in TranZact.

Born in India. Building for the world.

Book a demo →

Frequently asked questions

Is a gate pass mandatory under GST?

No. A gate pass is an internal control for your gate. GST asks for the tax invoice, a delivery challan (for example for job work) and an e-way bill where the rules require it. The gate pass simply records their numbers.

What is the difference between a gate pass and a delivery challan?

A delivery challan is a GST document under Rule 55 that goes with goods moved without an invoice, such as job work. A gate pass is your own record that the goods passed the gate, who approved it and whether they must come back.

Do goods sent on a returnable gate pass for job work need an e-way bill?

For inter-state job work, yes, whatever the value. For other movements the usual ₹50,000 threshold applies. Confirm with your accountant for your case.

How long can job-work material stay outside on an RGP?

Under Section 143, inputs must come back within one year and capital goods within three years. Moulds, dies, jigs, fixtures and tools have no limit. Put the expected return date on every RGP so the register flags overdue items early.

Can I keep my gate pass register in Excel?

Yes. The free file has a pending and days-overdue column for your RGP register. With many passes a day, keeping each number right gets harder. It is easier when invoices, GRNs and stock movement sit in one system.

Don’t be the bottleneck.
Become the AI-Run Factory.

Book a demo

Born in India. Building for the world.