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
| Column | What to write | Example | Why it matters |
|---|---|---|---|
| 1. Inward No. | A running number, never reused. One number per document. | IN-0141 | Links a document's items. |
| 2. Date/Time | When the vehicle arrived, not the invoice date. | 16-Nov-2026 09:20 | Catches lines written hours later. |
| 3. Supplier/Vehicle | Supplier name as on the document, then the vehicle number. | Supplier A / MH-12-XX-0001 | Traces a disputed delivery. |
| 4. Document No. | Type and number: tax invoice, delivery challan or job-work challan. | Tax invoice INV-2231 | Accounts match the bill to it. |
| 5. PO No. | The PO or job-work order it is against, or "No PO". | PO-0567 | Proves someone ordered it. |
| 6. Item/Unit | Your item code, a short name with size or grade, and the PO's unit. | RM-101 MS round bar 25 mm, kg | One item, one name. |
| 7. Qty as per Document | What the supplier says they sent. | 1,500 | What the bill will claim. |
| 8. Qty Received | What you counted or weighed. | 1,462 | Only this goes into stock. |
| 9. Difference | Qty Received minus Qty as per Document. | -38 | A minus means short supply. |
| 10. Status | Accepted, Short supply, Sent to QC, Rejected at gate or On Hold - No PO. | Short supply | Shows the next action. |
| 11. GRN No. | Written once stores accepts the material. | GRN-0388 | Blank means still open. |
| 12. Remarks | Damage, shortfall reason or supplier follow-up. | 38 kg short, credit note asked | Gives 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
- Read the invoice or challan. Note the supplier, document number, items and quantities.
- Check that the PO or job-work order exists. If not, the line goes on hold.
- Count or weigh before unloading into stock.
- Write the line at the gate, not at shift end.
- Send it to stores or QC and set the status.
- 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.
Worked example: one day of receipts at an engineering unit
Illustrative numbers. The filled example sheet has all 12 columns.
| Line | What arrived | Document vs received | Status |
|---|---|---|---|
| IN-0141 | MS round bar 25 mm | 1,500 kg vs 1,462 kg (-38) | Short supply, GRN-0388 |
| IN-0142 | Bearings 6205, invoice INV-889 | 200 nos vs 200 nos | Accepted, GRN-0389 |
| IN-0142 | M10 bolts, same invoice | 1,000 nos vs 1,000 nos | Sent to QC |
| IN-0143 | Turned shafts back from a job worker | 500 nos vs 496 nos (-4) | Short supply, GRN-0390 |
| IN-0144 | Grey primer, leaking drums | 120 litre vs 120 litre | Rejected at gate |
| IN-0145 | Cutting oil on a delivery challan | 50 litre vs 50 litre | On 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
- Writing lines at shift end. Times and quantities get guessed.
- Copying the invoice quantity into Qty Received. Every short supply disappears.
- One row per invoice, not per item. You can't see which item was short.
- Never closing a line with a GRN No. Material sits in the plant, unbooked.
- Letting no-PO material into stock. Nobody can later say who ordered it.
- Not marking job-work returns. They get counted as purchases.
- 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.