How to Do a Stock Count: A Practical Guide
Your records say you have 40 units. The shelf says 32. That gap, between what the paperwork claims and what’s physically there, is where money quietly disappears, through miscounts, damage, unrecorded usage, or theft. A Stock Count Sheet is the tool for measuring that gap honestly: a structured form for recording what you actually find, shelf by shelf, and comparing it against what the records say.
It applies to any physical stock you track, office supplies, retail goods, spare parts, raw materials. It’s the physical verification step behind the Office Supply Inventory Sheet and the Reorder Register: those tell you what should be there; the count tells you what is.
When to Use This
Count on a schedule, not when something feels off. By the time a stockout tells you the records were wrong, the trail is cold. High-value or fast-moving items deserve monthly counts; everything else can be quarterly or half-yearly. Many businesses also count before year-end for the accounts, and after any event that disrupts stock, a move, a system change, a change of the person in charge.
A full count of everything (a “wall-to-wall” count) is thorough but disruptive; counting a rotating subset each time (“cycle counting”) keeps records accurate year-round with less pain. Either way, the sheet is the same, what changes is how much of the stock you cover in one session.
How to Fill It Out
Section 1: Count details. Record the date, the location or zone being counted, and the names of the counters. If you’re doing a partial count, note exactly which categories or shelves are covered so the next session picks up where this one stopped. Count in a defined, uninterrupted block, a count spread across three interrupted afternoons invites errors.
Section 2: Item identification. List each item by name and code, exactly as it appears in your inventory records. Pre-fill this column from the system before the count starts, it keeps naming consistent and stops counters inventing their own descriptions. But keep the expected quantity column hidden or separate (see Common Mistakes below).
Section 3: Expected quantity. The figure from your records, what the system thinks should be on the shelf. Fill this in before or after the physical count, but don’t show it to the people doing the counting. It’s the baseline the count will be measured against.
Section 4: Counted quantity. What the counters physically found, in the same unit of measure as the records. Count twice, either two people counting independently or one person counting and a second verifying. Write the figure down immediately; counting a shelf and “remembering” the number until later is how errors are born.
Section 5: Variance and reason. The difference between expected and counted, calculated on the sheet, not in someone’s head. Then the important part: the reason. Investigate every significant variance the same day, check for unrecorded issues, items in the wrong location, deliveries not yet booked in, or data entry errors. “Unknown” is an acceptable interim answer, but it must trigger a follow-up, not close the matter.
Common Mistakes
1. Counters seeing the expected figures. If the counter knows the system says 40, human nature nudges them toward counting 40, recounting until the numbers agree, or just writing down 40. Keep expected quantities off the count sheet during the physical count. Compare afterwards; that’s when discrepancies are supposed to surface.
2. Counting alone. One person counting, with nobody verifying, means errors go in unchallenged, and it removes the basic control against dishonesty. Always count in pairs or have a second person verify a sample. It’s a control, not an accusation; frame it that way.
3. Not investigating variances. Writing down the difference and filing the sheet achieves nothing. Every significant variance needs a same-day investigation while memories and paperwork are fresh: check nearby shelves, recent deliveries, and the issue log. Variances with investigated, documented causes improve the system; unexplained ones just repeat.
4. Counting in the wrong unit. Records in boxes, shelf in individual units, counter writes down the unit figure against the box row, and suddenly you’re “missing” hundreds of items. Confirm the unit of measure for every item before counting starts, and put the unit on the sheet next to each item name.
Who Needs to Sign Off
The counters sign their sections of the sheet to confirm what they physically found. A supervisor, the stock controller, office manager, or department head, reviews the variances, signs off on the investigation findings, and approves any adjustments to the records. Large or unexplained variances should be escalated to management before the books are adjusted, not after.
How Often to Review and Update
Reconcile every count against the records within a day or two, while the evidence is fresh. Adjust the records only after variances are investigated and approved, never to make the numbers match without understanding why. Review your counting frequency twice a year: items with persistent variances need counting more often, and consistently accurate categories can be counted less. The goal is records you can trust, not counts for their own sake.
Download the free Stock Count Sheet template.