Stock taking for small shops: a simple weekly method
Stock taking sounds like big-company work. It is not. It is simply counting what is on your shelf and comparing it with what should be there. Done every week, it tells you what is selling, what is finishing and what is missing.
Why count your stock at all?
Your stock is your money in another form. A shelf full of goods might be worth ₦500,000. If goods go missing, expire or are sold without being recorded, that money disappears and you will not know where.
Counting also stops two common problems: running out of fast-selling goods (and sending customers to the next shop), and buying too much of slow goods that just sit there.
The simple weekly method
1. Pick a fixed day and time
Choose a quiet time, like Sunday evening or Monday morning before customers come. Same day every week, so it becomes a habit.
2. Start with your top 20 products
You do not need to count every pin and sweet every week. Count the products that bring the most money, or that go missing often. Count everything else once a month.
3. Count, then compare
For each product, write what is on the shelf. Then work out what should be there:
Should be there = last count + what you bought − what you sold
Example: last Sunday you had 30 tins of Peak Milk. You bought 48 on Wednesday. Your records show you sold 50. So there should be 28 tins. If you count 24, then 4 tins are missing. At ₦450 each, that is ₦1,800 gone in one week, from one product.
4. Find out why
A difference does not always mean theft. Check these first:
- A sale that was not recorded
- Goods taken for the house
- Damaged or expired goods thrown away
- Supplier delivered fewer than you paid for
- A counting mistake (count again)
If the same product keeps going missing, watch it closely. See our guide on how to stop money and goods going missing.
Know when to restock
For each fast-selling product, set a “low level”: the number at which you must buy more. If you sell about 10 Coke a day and your supplier takes two days to deliver, your low level is at least 20. When you count 20 or less, order.
This one habit stops you from telling customers “e don finish”.
Check expiry dates while you count
Food, drinks and medicines expire. While counting, move older goods to the front so they sell first. Anything close to expiry, sell at a small discount instead of throwing it away.
Make it faster with your phone
Handlam keeps the “should be there” number for you, because every sale takes from your stock as you sell. It warns you when a product reaches its low level. When you do your weekly count, open Count my stock, type what is on the shelf, and Handlam shows what is missing and how much it is worth in naira.
In short
- Count your top products every week, everything else monthly.
- Should be there = last count + bought − sold.
- Look for simple reasons first, then watch products that keep going missing.
- Set a low level for every fast-selling product, and restock before it finishes.