Receiving Checklist Template (Free Excel Spreadsheet)

Receiving is where inventory accuracy starts or falls apart. The Warehousing Education and Research Council (WERC) puts receiving errors at roughly 25% of all downstream inventory discrepancies. A wrong count or missed label at the dock ripples through picking, packing, and shipping. By that point, it costs 3-5x more to fix than catching it at intake.

This receiving checklist template locks down a repeatable inbound process so nothing slips through. It pairs with the ecommerce receiving process guide for the full method behind each step.

Get Excel Template

Shipment header: 5 fields to capture first

Before unloading a single carton, fill in these 5 fields at the top of the checklist. They establish the audit trail for every line item that follows.

Field	Purpose	Example
Date	Shipment arrival date	2026-03-07
PO number	Purchase order reference for this inbound	PO-1044
Supplier	Vendor name	Northline Goods
Receiver	Person processing this shipment	Jordan
Dock lane	Receiving dock assignment	2

One checklist per PO. If a shipment contains multiple POs, split them. Keeping it one-per-PO keeps your variance tracking clean and makes it obvious which supplier shorted you. Teams that combine multiple POs on one sheet lose 15-20 minutes per incident untangling which variance belongs to which order.

Line checklist: 7 columns per SKU

What are the 4 steps in receiving inventory?

Each row represents one SKU line from the purchase order. The 7-column structure walks the receiver through verification in a fixed sequence, so there is no temptation to skip steps when the dock is busy.

Column	Type	Purpose
SKU	Pre-filled from PO	Product variant expected on this PO line
Expected qty	Pre-filled from PO	Units ordered on this line
Received qty	Manual	Units actually counted during unloading
Condition pass?	Manual (Yes/No)	Visual and packaging inspection result
Variance code	Dropdown	Only filled if received qty differs from expected or condition fails
Putaway bin	Manual	Assigned storage location after receiving
Completed by	Manual	Person who completed putaway for this line

The 4-step check per line works as follows:

1. Verify SKU matches the label — scanning GS1 barcodes beats eyeballing part numbers. Barcode scanning reduces SKU misidentification by up to 67% compared to manual label reading.
2. Count quantity — count every unit, not just carton count. A carton labeled “24 units” that actually contains 22 is a shortage you will not catch until a picker comes up empty.
3. Inspect condition — check for dents, tears, moisture damage, or broken seals. Damaged product that reaches the shelf turns into a pick exception, a customer complaint, or both.
4. Confirm putaway bin — record the exact bin location where the unit is staged or shelved. Without this step, product is physically in the warehouse but invisible to your system.

5 variance codes for receiving exceptions

Shortages represent 60-70% of all inbound receiving discrepancies

Every receiving discrepancy gets a standardized code. Consistency matters because this data feeds supplier scorecards and purchasing decisions.

Code	Meaning	Action
SHORT	Received fewer units than PO states	Log shortage, notify purchasing, update PO
OVER	Received more units than PO states	Verify against PO, accept or refuse overage
WRONG	Wrong SKU received (label does not match PO)	Quarantine, contact supplier for replacement
DMG	Items damaged in transit	Quarantine, photograph, file supplier claim
MISSLBL	Missing or unreadable labels	Relabel from master SKU list before putaway

Shortages (SHORT) are the most common receiving variance, typically 60-70% of all inbound discrepancies. Track shortage frequency by supplier. If the same vendor shorts you on more than 5% of PO lines over 90 days, that is a conversation for your next vendor review, not something to shrug off.

If you are dealing with MISSLBL frequently, it may be worth requiring suppliers to follow the GS1 Logistic Label Guideline. Standardized carton labels cut relabeling time by 80% or more and reduce the risk of a mislabel reaching the pick shelf.

4 end-of-shift checks

Before anyone clocks out, run through these four items. Takes about 10 minutes and prevents problems from piling up overnight.

• All variances logged with codes and assigned to someone who will actually follow up within 24 hours
• All bins confirmed in the inventory system — not just physically placed on the shelf, but recorded with correct quantities
• Open PO statuses updated (partial receipt, complete, or discrepancy flagged)
• Escalations sent for anything unresolved past the SLA (typically 24 hours for standard variances, 4 hours for wrong-SKU or damage claims)

WERC keeps flagging the same root cause in receiving breakdowns: stock that is physically on the shelf but never entered in the system. That gap causes phantom stockouts and overselling. In a 2024 WERC survey, warehouses with a formal receiving checklist hit 99.2% putaway confirmation rates versus 91.4% without one.

Matching the checklist to your receiving workflow

This template works for both small operations processing 10-15 POs per week and mid-size warehouses handling 50 or more. Adapt it to your scale:

• Under 20 POs per week: print the checklist, fill by hand, file physically. Review variance totals weekly.
• 20-50 POs per week: use the Excel version with dropdown validation for variance codes. Run a weekly pivot table on variance frequency by supplier.
• Over 50 POs per week: the spreadsheet still works for the process, but you will spend more time on data entry than on actual receiving. At that volume, teams maintaining strong inventory accuracy typically move to inventory management tools for small business that posts receiving data directly into their inventory system.

Regardless of volume, the checklist enforces the same 4-step sequence. The hard part is not the template — it is getting every person on every shift to follow it the same way. Post the 4-step sequence on the dock wall, and audit 2-3 completed checklists per week to catch process drift early.

Common receiving mistakes this checklist prevents

Barcode scanning reduces SKU misidentification by up to 67%

Teams that skip a formal checklist keep hitting the same 5 failure modes:

• Skipping the condition check: happens on 30-40% of lines when the dock is backed up, leading to damaged goods entering saleable inventory
• Eyeballing SKUs instead of scanning: causes 1-3 wrong-SKU putaways per 100 lines on average
• Combining POs on one sheet: makes it impossible to attribute variances to specific suppliers
• Delaying putaway confirmation: creates a gap between physical and system inventory that cascades into pick errors
• Not closing out variances daily: small discrepancies that sit for a week become permanent inventory drift

Teams that follow the warehouse receiving best practices outlined in the academy guide typically see measurable accuracy improvements within 2-4 weeks of adopting a structured checklist.

Quick Reference

• Shipment header captures 5 fields: date, PO number, supplier, receiver, dock lane.
• Line checklist has 7 columns per SKU with a 4-step verification sequence.
• Use 5 variance codes: SHORT, OVER, WRONG, DMG, MISSLBL.
• Complete 4 end-of-shift checks to close out each receiving session in roughly 10 minutes.
• One checklist per PO — never combine multiple POs on one sheet.
• Shortages represent 60-70% of all inbound discrepancies.
• Formal checklists achieve 99.2% putaway confirmation rates vs. 91.4% without (WERC, 2024).

Metric	Target	Red flag threshold
Receiving accuracy (qty match)	99%+	under 95%
Putaway confirmation rate	100%	under 90%
Variance resolution SLA	under 24 hours	over 48 hours
Condition check completion	100%	under 85%
Supplier shortage rate	under 2% per PO	over 5%