GRN Format in Excel — Goods Receipt Note for Construction (Free)
A GRN format in Excel (goods receipt note) for construction stores — record material received against the PO, with accepted, rejected and balance quantities. India-ready Excel + PDF. Free, editable, no sign-up.
Excel (with formulas) & print-ready PDF. Free & editable, no sign-up.
⬇ Download Excel (.xlsx) ⬇ Download PDFWhat is a GRN (Goods Receipt Note)?
A GRN records materials physically received at site against a purchase order — quantity ordered vs received vs accepted vs rejected. It is the middle leg of the 3-way match (PO → GRN → invoice) and the trigger to update stock and clear supplier payment.
GRN (Goods Receipt Note) format — sample
Rejected quantity is computed from received minus accepted:
| Sl | Material Description | Unit | PO Qty | Received Qty | Accepted Qty | Rejected Qty | Remarks |
|---|---|---|---|---|---|---|---|
| 1 | Cement OPC 53 Grade | Bag | 200 | 200 | 198 | 2 | |
| 2 | TMT Steel Fe 500D (12 mm) | MT | 8 | 8 | 8 | 0 | |
| 3 | AAC Blocks 600x200x150 | cum | 40 | 40 | 39 | 1 |
What to include
- GRN header — supplier, GRN number, PO reference, date, vehicle/challan, site.
- Material & unit — item received.
- PO / Received / Accepted Qty — ordered, delivered and accepted quantities.
- Rejected Qty — = received − accepted, auto-calculated.
- Approvals — received-by, store in-charge, inspected-by.
How to prepare it (step by step)
- Fill the supplier, GRN number, PO reference and challan.
- Enter each material's PO, received and accepted quantities.
- Rejected quantity calculates automatically.
- Get it signed by stores and inspection.
- Match against the PO and invoice before payment (3-way match).
Paper GRNs break the PO–GRN–invoice match and the stock ledger. ProjectsNext books GRNs against the PO, updates live stock, and 3-way-matches invoices automatically.
See procurement in ProjectsNext →Frequently asked questions
A goods receipt note layout recording material received against a PO, with accepted, rejected and balance quantities.
Matching the purchase order, the GRN (goods received) and the supplier invoice before paying.
Download the template, enter PO/received/accepted quantities; rejected calculates automatically.
Yes — Excel and PDF, free and editable, no sign-up.
More construction procurement formats: all templates · Comparative Statement · Purchase Order · RFQ · BOQ.