Qees business tools › Lessons › Inventory & purchasing
How to do a stock count, step by step
A stock count compares what the system says with what is really on the shelves. Here is a method that makes the result reliable, and a ready Excel template, free.
Excel stock count template (free)
Columns: SKU, product, warehouse, system quantity, counted quantity, difference (formula), unit cost, value of the difference (formula) and reason.
Kinds of count
- Full: every product at once, usually at year end.
- Cycle: a group of products every week or month, so everything is counted over the year without stopping work.
- Spot: specific products when something looks wrong, or your high-value A items.
The steps
- Stop movements on the products being counted, or note the start time.
- Count without seeing the system quantity (a blind count), so the expected number does not influence the counter.
- Enter the counts, then work out the difference = counted − system.
- Recount products with large differences before approving.
- An authorised person approves the adjustment with a clear reason, and the before and after quantities stay in the log.
Example: the system says 120 units and you counted 117. The difference is −3 units × a cost of 11 = −33 of loss. You record an adjustment with the reason; you never just overwrite the balance.
Apply it to your stock. Qees Inventory & Procurement works out reorder points, suggested quantities, stock value and ABC classes from your real movements.
Frequently asked questions
How often should I count?
High-value (A) products monthly or weekly, the rest every 3–6 months, plus a full count once a year.
Why not just edit the quantity?
Because editing erases the trail. An adjustment with a reason, user and date leaves a log you can review, and shows when losses keep happening.