How to Run an Inventory Count (What a Count Sheet Needs)

A physical inventory count is only as accurate as the sheet used to record it. Here is what to include and how to keep the process reliable.

Item name plus a SKU or barcode

A name alone is not enough β€” it causes mismatches between similar products. Pairing the item name with its SKU or barcode removes that ambiguity.

A location field

Recording where an item was counted β€” aisle, bin, or shelf β€” matters most in warehouses where the same item is stored across multiple zones.

The unit of measure

Whether counting by each, case, box, or weight should always be labeled β€” mixing units without noting them is one of the most common sources of counting errors.

Counted quantity next to system quantity

A blank column for the physical count placed right next to the expected or system quantity makes any variance visible immediately, instead of requiring a second pass to compare.

The counter's initials and the date

Recording who counted each line and when supports accountability and makes it easy to spot a section that may need a recount.

Full count vs. cycle counting

A full physical count checks every item at once, usually once a year, and typically requires pausing normal operations. Cycle counting checks a rotating subset of inventory on a regular schedule β€” daily or weekly β€” so the entire inventory gets counted over time without a full shutdown, and discrepancies get caught sooner.

Reducing count errors

Having two people independently count high-value or frequently mis-counted items β€” a "blind count," where the counter does not see the expected system quantity β€” catches mistakes a single count would miss. Recording quantities immediately at the point of counting, rather than from memory afterward, also meaningfully reduces errors.

Frequently Asked Questions

How often should a business do a full inventory count?

Many businesses run one full count per year, often at fiscal year-end, supplemented by more frequent cycle counts throughout the year. The right cadence depends on inventory value, shrinkage risk, and how disruptive a discrepancy would be.

What causes counted quantity to differ from system quantity?

Common causes include unrecorded damage or spoilage, theft or shrinkage, receiving or shipping errors, simple miscounts, and items stored in an unexpected location that got missed or double-counted.