Free template · Excel · Worked example

Goods Received Note Format: Free Excel Template + Example

A goods received note (GRN) format is the record you fill when supplier material reaches your factory. It lists the GRN number and date, supplier and GSTIN, PO number, and supplier invoice and e-way bill numbers. For each item, it shows the quantity ordered, received, accepted and rejected, with the reason. Stores and quality sign it, and accounts pays only for the accepted quantity.

Download the Excel template

What is a goods received note?

A goods received note is your factory's own record that supplier material has arrived. Stores makes it at the receiving site, after counting and checking the material.

It does three jobs. It adds the accepted quantity to stock. It tells accounts what to pay. And it builds a record of how each supplier delivers.

A GRN is not a purchase order. The PO is what you asked for. The GRN is what actually came in, and what you kept.

The GRN number is the unique number on each note. Keep one running series per site, and never reuse a number.

GRN vs delivery challan vs purchase order vs invoice

Four papers travel with every purchase, and each proves something different. For the outward side, see our guide on delivery challan vs invoice.

DocumentWho makes itWhenWhat it proves
Purchase orderYou (purchase)Before the supplier shipsWhat you ordered, at what rate
Delivery challanSupplierTravels with the goodsWhat the supplier says it sent
Tax invoiceSupplierWith or before the goodsWhat the supplier bills, with GST
Goods received noteYou (stores)After counting and checkingWhat arrived and what you accepted

What each column in the GRN format means

The template has three parts: header fields, item lines and sign-off.

Header fields

  • GRN no.: the next number in your running series. Never skip or reuse one.
  • GRN date: the day the material reached you, not the day you typed it.
  • Receiving store or site: where it was unloaded, if you have more than one store.
  • Supplier name and GSTIN: copy the GSTIN from the invoice and check it matches the PO.
  • PO no. and date: the order this delivery belongs to.
  • Supplier invoice or challan no. and date: from the paper that came with the vehicle.
  • E-way bill no.: from the supplier's e-way bill, so your papers match theirs.
  • Vehicle no. and transporter or LR no.: helps you trace a short or damaged delivery.

Item columns

  • Item (with code): as on your PO, with your item code, not the supplier's name for it.
  • HSN: from the invoice. It should match your PO and item master.
  • Unit: kg, nos, metres or litres. Use the same unit as the PO.
  • PO qty: what you ordered on this line.
  • Invoice/challan qty: what the supplier says it sent.
  • Received qty: what you counted or weighed. Never copy the invoice figure.
  • Accepted qty: what passed your check and goes into stock.
  • Rejected qty: what failed your check. Write 0 if nothing was rejected.
  • Reason/remark: one short reason, such as "rusted". Note shortages and part deliveries here too.
  • Batch/heat no.: for material you must trace later, like steel heats or chemical batches.
  • Rate ex-GST: the PO rate in ₹, before GST.
  • Accepted value (₹): accepted qty × rate. This is what accounts pays, before GST.

A quick check on every line: accepted plus rejected must equal received. If it doesn't, someone miscounted.

Sign-off

Leave four boxes at the bottom: received by (stores), inspected by, approved by, and accounts. Each person signs and dates the note.

How to fill a GRN, step by step

Fill the GRN at the gate, on the day the truck arrives.

[[IMAGE {"type":"steps","title":"How to fill a GRN at the gate","items":["Match invoice and e-way bill to vehicle","Count or weigh; write your own figure","Check item and quantity against the PO","Inspect, then split accepted and rejected","Sign, update stock, send to accounts"]}]]

Yes, you can run all of this in Excel; download the template above. Making the parts list as well? Use our bill of materials format.

Worked example: steel and hardware received at a fabrication unit

A fabrication unit ordered steel and fasteners on one PO. One truck arrived with one invoice. All numbers below are illustrative.

Table 1 (Example): GRN header

FieldExample value
GRN no. and dateGRN/26-27/0418, 12 Nov 2026
Receiving storeMain store
Supplier name and GSTINExample Steel Traders, 27AAAAA0000A1Z5
PO no. and datePO/26-27/0392, 3 Nov 2026
Supplier invoice no. and dateEST/1187, 11 Nov 2026
E-way bill no.1612 3456 7890
Vehicle no. and LR no.MH 12 AB 1234, LR 5521

Table 2 (Example): item lines

ItemInvoice qtyReceived / accepted / rejectedRemark
MS plate 10 mm (kg)2,0001,985 / 1,985 / 0Short 15 kg on weighbridge
MS angle 50×50×5 (kg)1,5001,500 / 1,440 / 6060 kg bent, returned
Hex bolt M12×50 (nos)3,000 of 5,000 ordered3,000 / 3,000 / 0Part delivery, 2,000 pending
Plain washer M12 (nos)5,0005,000 / 4,900 / 100100 rusted, returned

Table 3 (Example): what accounts pays and what goes back

LineInvoice value (₹)Accepted value (₹)Difference (₹)
MS plate @ ₹62/kg1,24,0001,23,070930 (short)
MS angle @ ₹64/kg96,00092,1603,840 (rejected)
Hex bolt @ ₹7.5022,50022,5000
Plain washer @ ₹1.206,0005,880120 (rejected)
Total, before GST2,48,5002,43,6104,890

Accounts pays ₹2,43,610 plus GST on that value. The ₹4,890 gap is settled with a debit note to the supplier.

The 60 kg of angle and 100 washers go back with a challan. The 2,000 bolts stay open on the PO for the next GRN. Our purchase return guide covers the return.

Book a demo →

GRN and GST: why the receipt date matters

Under Section 16(2)(b) of the CGST Act, 2017, you can claim input tax credit only after you receive the goods. A dated, signed GRN is your proof of that receipt.

If goods on one invoice arrive in lots, credit is available only when the last lot arrives. So make one GRN per delivery, and date each one correctly.

GST law does not prescribe a GRN format; the GRN is an internal record. Still, add the supplier's invoice and e-way bill numbers. Our e-way bill format shows what that document holds.

Confirm the treatment for your business with your CA.

Three-way match: PO, GRN and invoice

Three-way matching means comparing the PO, the GRN and the invoice before you pay a supplier.

Check four things on each line: item, quantity, rate and supplier GSTIN. Pay only for the accepted quantity at the PO rate. Our purchase invoice format shows the invoice side.

The GRN sits in the middle. Without it, accounts can compare the order with the bill, but not with what reached the store.

Common GRN mistakes

  • Writing the invoice quantity instead of the counted quantity.
  • No rejected column, so rejected material quietly enters stock.
  • A rejection with no reason, which leaves nothing to raise with the supplier.
  • A GRN with no PO number, so nobody can check the rate.
  • One GRN for two deliveries, which blurs the receipt dates.
  • Filling the GRN days later, so the receipt date is wrong.

Where the GRN sits in TranZact

Most of these mistakes come from retyping. The PO sits in one file, the GRN in another, and the bill in Tally.

TranZact is manufacturing AI software used by 10,000+ manufacturers. In TranZact, the GRN is one step in a single purchase flow: MRP report → indent → RFQ → PO → GRN → payment.

The PO, the GRN and stock in sit on one system.

Entries sync one way to Tally, with no double entry.

Limits to know: TranZact does not replace your accounting software. Batch-wise stock and quality control sit on higher plans, as the table shows. Check Pricing for the plan that includes MRP and indent. Live in 2–3 weeks.

TranZact GRN and purchase facts (plans as listed on Pricing, 22 Oct 2026)

FactPlanSource
Purchase flow: MRP report → indent → RFQ → PO → GRN → paymentSee Pricing for Planning (MRP + indent)Purchase management, Pricing
Stock in, bin card, issue, multi-store, reorder, AI stock alertsStock tracking is on Grow and above; see Pricing for the restInventory management, Pricing
Batch-wise stock trackingScale+ and DominatePricing
Quality control (raw material and finished goods)DominatePricing
Store-level permissionsDominatePricing
E-way bill and e-invoice (IRN) from the GST invoiceAll plansConfirmed by TranZact, 6 Oct 2026
Tally and Zoho Books sync (one way); Busy integrationGrow and abovePricing

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

Born in India. Building for the world.

Book a demo →

Frequently asked questions

Is a GRN required under GST?

GST law does not prescribe a GRN format. But you can claim input tax credit only after you receive the goods, so a dated, signed GRN is your proof of receipt. Confirm treatment with your CA.

Material came in two lots against one invoice. When do I record it?

Make one GRN for each delivery, linked to the same PO and invoice. Under GST, credit on that invoice is available only when the last lot arrives.

Should the GRN show the rate and value?

Yes. Rate times accepted quantity tells accounts exactly what to pay and gives a value for stock. Keep the rate before GST, as in the template.

What do I do with rejected material?

Write the rejected quantity and reason on the GRN. Send the material back with a challan. Tell accounts to pay only the accepted quantity, or raise a debit note.

Can I keep GRNs in Excel and accounts in Tally?

Yes, many factories start that way. The risk is retyping the same numbers into each file. In TranZact, the PO, GRN and stock sit on one system. Entries sync one way to Tally, with no double entry.

Is the template free, and in what format?

Yes. It is a free .xlsx file with no sign-up: a blank GRN format and a filled example. It opens in Google Sheets too.

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

Book a demo

Born in India. Building for the world.