GUIDE

How to do stock taking in a small shop, with an example

Stock taking means counting what is on your shelves and comparing it with what your records say should be there. The difference shows you what was sold without being written, spoiled, or taken.

Updated 7 October 2026

Before you count

  • Choose a quiet time: before opening or after closing.
  • Have your last count, the goods you bought since, and your sales records ready.
  • Count one shelf at a time, left to right, and write as you go.

The calculation

For each product: opening stock, plus what you bought since, minus what you sold, is the stock you expect. Then count what is really there. Expected minus counted is the shortfall.

A worked example

Product
Opening
Bought
Sold
Expected
Counted
Short
Sugar 1 kg
20
30
41
9
9
0
Cooking oil 1 L
12
24
30
6
4
2
Bar soap
40
0
22
18
18
0
Bread
15
60
68
7
5
2
Matchboxes
100
0
35
65
60
5

Sugar and soap match. Two bottles of oil and two loaves of bread are missing, and five matchboxes are short, which often means small sales were not written. Oil is the costly one: find out whether those two bottles were sold without a record, given on credit and not written, or taken.

A stock count sheet with columns for opening stock, bought, sold, expected, counted and short, for five products
The same count on paper: the short column is where to look first.

How often to count

Count fast-moving and costly goods every week, and everything once a month. A count you can trust tells you how much to buy, because you stop buying what does not sell.

Doing it with an app

An app that counts stock down as you sell gives you the expected figure without the sums, so you only count and compare. Our comparison of shop record apps shows which apps keep a stock count and warn when an item runs low.

Questions shop owners ask

The record of each product's stock: what came in, what went out and what is left. A stock count checks the stock book against the shelf.

Count the quantities first. To know what your stock is worth, multiply each quantity by what you paid for it.

Check first that every sale and every credit sale is written. Most shortfalls in small shops are unwritten sales.