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

  1. Stop movements on the products being counted, or note the start time.
  2. Count without seeing the system quantity (a blind count), so the expected number does not influence the counter.
  3. Enter the counts, then work out the difference = counted − system.
  4. Recount products with large differences before approving.
  5. 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.

See the product Try it with sample data

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.