Free Excel template · Stores and purchase

Inward Register Format: Free Excel Template + Example

Free Excel for factories: a blank 12-column inward register and a filled example, with every column explained and how to fill it at the gate.

Download the Excel template

An inward register is a running log of every material that comes into your factory, one line per item, written when the vehicle arrives. A good inward register format records the inward number, date and time, supplier, invoice or challan number, PO number and vehicle number. It also records the item, quantity on the document, quantity actually received, the difference, status and the GRN number. Download the free Excel format on this page, with a blank sheet and a filled example.

What is an inward register?

It is the first record of a receipt, made before anything goes into stock. The gate writes the arrival line. Stores adds the counted quantity, the status and the GRN number.

Inward register vs GRN vs gate pass

  • Inward register: logs every receipt in order, even material rejected or put on hold.
  • GRN: confirms one accepted receipt for stock and purchase. See our goods received note format.
  • Gate pass: allows one movement through the gate, in or out.

So every GRN needs an inward line, but not every inward line becomes a GRN.

Inward register format: all 12 columns explained

ColumnWhat to writeExampleWhy it matters
1. Inward No.A running number, never reused. One number per document.IN-0141Links a document's items.
2. Date/TimeWhen the vehicle arrived, not the invoice date.16-Nov-2026 09:20Catches lines written hours later.
3. Supplier/VehicleSupplier name as on the document, then the vehicle number.Supplier A / MH-12-XX-0001Traces a disputed delivery.
4. Document No.Type and number: tax invoice, delivery challan or job-work challan.Tax invoice INV-2231Accounts match the bill to it.
5. PO No.The PO or job-work order it is against, or "No PO".PO-0567Proves someone ordered it.
6. Item/UnitYour item code, a short name with size or grade, and the PO's unit.RM-101 MS round bar 25 mm, kgOne item, one name.
7. Qty as per DocumentWhat the supplier says they sent.1,500What the bill will claim.
8. Qty ReceivedWhat you counted or weighed.1,462Only this goes into stock.
9. DifferenceQty Received minus Qty as per Document.-38A minus means short supply.
10. StatusAccepted, Short supply, Sent to QC, Rejected at gate or On Hold - No PO.Short supplyShows the next action.
11. GRN No.Written once stores accepts the material.GRN-0388Blank means still open.
12. RemarksDamage, shortfall reason or supplier follow-up.38 kg short, credit note askedGives purchase a reason to act.

[[IMAGE {"type":"checklist","title":"An inward line is complete when","items":["Arrival date and time written at the gate","PO number or No PO filled","Qty Received counted, not copied","One status picked from the list","GRN No. or a reason filled"]}]]

How to fill the inward register in 6 steps

  1. Read the invoice or challan. Note the supplier, document number, items and quantities.
  2. Check that the PO or job-work order exists. If not, the line goes on hold.
  3. Count or weigh before unloading into stock.
  4. Write the line at the gate, not at shift end.
  5. Send it to stores or QC and set the status.
  6. Write the GRN number back on the line and sign. Our GRN format guide covers the GRN itself.

Where TranZact fills this in for you

A register, a GRN book and Tally means writing each receipt three times. On a busy day, one of the three gets skipped. That is a software gap, not a team problem.

TranZact is manufacturing AI software, trusted by 10,000+ manufacturers. The receipt is recorded as a GRN against the PO, inside the purchase flow: MRP report, indent, RFQ, PO, GRN and payment. Stock in updates inventory and the bin card, so there is no separate book to copy into.

  • Inventory features: stock in, bin card, issue, batch tracking (Scale+ and above), multi-store, reorder and AI stock alerts.
  • Job-work: the sub-contracting feature in production.
  • Integrations: Tally, Busy, Zoho Books, Excel and Google Sheets. Accounting stays in Tally, with one-way sync and no double entry.

TranZact goes live in 2–3 weeks, with data stored in India on AWS servers in Mumbai. The Excel here is free; TranZact is paid, on the Grow, Scale+, Dominate and Enterprise plans. There is no free plan.

Book a demo →

Worked example: one day of receipts at an engineering unit

Illustrative numbers. The filled example sheet has all 12 columns.

LineWhat arrivedDocument vs receivedStatus
IN-0141MS round bar 25 mm1,500 kg vs 1,462 kg (-38)Short supply, GRN-0388
IN-0142Bearings 6205, invoice INV-889200 nos vs 200 nosAccepted, GRN-0389
IN-0142M10 bolts, same invoice1,000 nos vs 1,000 nosSent to QC
IN-0143Turned shafts back from a job worker500 nos vs 496 nos (-4)Short supply, GRN-0390
IN-0144Grey primer, leaking drums120 litre vs 120 litreRejected at gate
IN-0145Cutting oil on a delivery challan50 litre vs 50 litreOn Hold - No PO
  • IN-0141: GRN for 1,462 kg only.
  • IN-0142: one invoice, two items, two rows.
  • IN-0143: a job-work return.
  • IN-0144: rejected, so no GRN.
  • IN-0145: no PO, kept out of stock.

Special cases: short supply, job-work returns, rejection and no-PO material

Short supply: make the GRN for the received quantity only. Purchase asks for a credit note, or accounts raise a debit note.

Rejection at the gate: write the line anyway, with the reason in Remarks. Purchase needs it when the supplier bills.

Job-work returns and no-PO material: the FAQ below shows how to record each one.

7 common mistakes in the inward register

  1. Writing lines at shift end. Times and quantities get guessed.
  2. Copying the invoice quantity into Qty Received. Every short supply disappears.
  3. One row per invoice, not per item. You can't see which item was short.
  4. Never closing a line with a GRN No. Material sits in the plant, unbooked.
  5. Letting no-PO material into stock. Nobody can later say who ordered it.
  6. Not marking job-work returns. They get counted as purchases.
  7. Overwriting entries. Strike through, write the correct figure and sign.

How to match the inward register with stores, purchase and accounts

Match the register weekly with stores records and monthly with purchase bills. An inward line with no GRN means material may be unbooked. A GRN with no inward line means the gate was bypassed.

Both show up later as a stock mismatch. Our stock reconciliation guide covers the full match.

Download the free inward register format

The download has the blank sheet and the filled example above. Excel makes the weekly match easier. To print it as a book, see the FAQ.

How long to keep it? Section 36 of the CGST Act says GST accounts and records must be kept for 72 months. The 72 months run from the due date of that year's annual return. The inward register records goods received, so keep it at least that long. Your CA can confirm if a longer period applies to you, for example during an appeal.

Need another format? See our bill of materials format.

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

Want to see a receipt go from GRN to stock and into Tally without a second entry? Bring one of your own invoices and we'll walk it through with you.

Book a demo →

Frequently asked questions

Who should fill the inward register: security or stores?

Usually both. Security writes the arrival details (time, supplier, document, vehicle). Stores adds the counted quantity, the status and the GRN number. Give each column one owner so nothing is left blank.

One invoice has 10 items. Is that one row or 10?

10 rows, all with the same inward number. Then you can see a short supply on each item, and stores can match each item to its GRN line.

How do I record job-work material coming back from a job worker?

Write 'Job-work challan' and its number in the document column. Put the job-work order number in the PO column and compare the quantity with what you sent. Note any shortfall in Remarks so the job-work balance stays correct.

What should I do if material arrives without a PO?

Write the line, mark it 'On Hold - No PO' and keep the material out of stock until purchase confirms it. Do not make a GRN until then.

Can I print this Excel format as a register book?

Yes. Print the blank sheet in A4 landscape, number the pages and add a signature line at the foot, then bind them. Or keep filling it in Excel.

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

Book a demo

Born in India. Building for the world.