Excel receiving report
Record the delivery, compare quantities with the purchase order and check dispositions.
Download ExcelPreview the workbookUse this Excel receiving report template to record deliveries against a purchase order. Print the dock checklist for inspections and log damage, shortages or holds in the workbook.
Free downloads. No email or account required.
See the worked exampleGRN-0042 · PO-1048 · ASN-0317
Harbor Supply · Miami · Dock 03
CT-200 · Lot CT-2611-A
Record the delivery, compare quantities with the purchase order and check dispositions.
Download ExcelPreview the workbookA US Letter inspection sheet with Pass, Issue and N/A responses.
Download dock checklistPreview the PDFTrack each exception by receipt, evidence, owner and due date. Included in the Excel workbook.
Preview the discrepancy logUse one line per SKU, purchase order line and tracked lot. Work in the unit on the purchase order.
GRN, purchase order, line number, supplier, site, owner, ASN, SKU, lot and PO unit.
Enter ordered quantity, prior arrivals, dock count, accepted, held and rejected quantities. Record condition, sign-off, actual putaway bin and time.
GRN-0042 · PO-1048 · ASN-0317
Harbor Supply · Miami · Dock 03
CT-200 · Lot CT-2611-A
Receipt / GRN · Date and time · PO / ASN · Supplier · Site / dock · Receiver
| Check | Pass | Issue | N/A |
|---|---|---|---|
| Match the delivery | □ | □ | □ |
| Check the shipment | □ | □ | □ |
| Count against the PO | □ | □ | □ |
| Inspect and document | □ | □ | □ |
| Separate held stock | □ | □ | □ |
| Sign and hand off | □ | □ | □ |
Receiver signature __________ · Reviewed by __________
Print at actual size on US Letter. Attach the checklist, delivery slip and any photos to the receiving record. Link them using the same GRN.
Download dock checklistOpen the Discrepancy log tab in the receiving workbook. Give each exception an ID and record the SKU, quantity, evidence, status and next action.
GRN-0042 · 5 cases · Held at QA-01
Evidence: Photos 01–03
Quality lead: Inspect and record disposition by Nov 12.
GRN-0042 · 20 cases · Open
Evidence: Count and delivery slip
Purchasing: Confirm the next delivery by Nov 12.
Check the purchase order or ASN, supplier, site and owner. Assign the delivery a GRN.
Record the physical count in the PO unit, adding a separate line for each tracked lot. Record accepted, held and rejected quantities.
Compare original order quantity with prior arrivals plus the current count. Flag excess separately and record the next action on each open exception.
Record the actual destination bin and time for accepted stock and preserve evidence for held or rejected goods.
Harbor Supply delivers 80 of 100 ordered cases under PO-1048. There were no prior arrivals.
GRN-0042 · PO-1048 · ASN-0317
Harbor Supply · Miami · Dock 03
CT-200 · Lot CT-2611-A
20 cases still to arrive. 100 ordered − (0 prior arrivals + 80 counted) = 20 cases. Purchasing follows up on the balance.
5 cases on hold. 75 accepted + 5 held + 0 rejected = 80 at the dock. The quality lead records the disposition before releasing held stock.
Both exceptions use GRN-0042. Review supplier credits, cancellations and replacements as separate decisions.
A goods received note (GRN) records the quantity and condition of a specific delivery. It links to the purchase order, receiving location, exceptions and sign-off.
Keep the original order quantity. Create a new GRN for each delivery, enter the prior arrivals and current physical count, and follow up on the balance still to arrive.
Yes, when they arrived and were counted. Record their disposition separately so that physical arrivals and accepted stock can both be reconciled.
Record the actual dock count and flag the excess as an overage. Confirm whether the additional stock will be accepted or returned.
Open the Discrepancy log tab in the Excel download. Use the GRN to connect shortages, damage, holds and evidence to the delivery.