The reason most shops take stock once a year, if at all, is that it means locking the door for a day. A day closed is a day's sales gone, so the count keeps getting moved to next month.
You don't have to close. Count the shop in pieces, one section at a time, while it stays open. A provision store split into six sections is fully counted in a week at about half an hour a day.
Before you count
Divide the shop into sections that one person can count in 30 to 40 minutes. Go by where things physically sit, not by category: left wall top shelves, left wall bottom shelves, the counter display, the fridge, the store room. Give each section a name and write the list down. The same sections get used every time.
Then rule your count sheet. One sheet per section.
| Item | Unit | Counted | Book balance | Difference | Note |
|---|
Fill in the Item and Unit columns before you start, in the order the goods sit on the shelf. Leave the Book balance column empty for now. That's deliberate, and it matters.
The count
- Pick a quiet time. For most shops that's the first hour after opening or the slow stretch in mid-afternoon.
- Tidy the section first. Pull forward anything pushed to the back, and bring out cartons of the same item from under the shelf so they are counted together.
- Count from one end to the other, top shelf to bottom. Write each figure down the moment you have it.
- Count in the unit on the sheet. If the sheet says tins, open cartons get counted as tins. A sealed carton of 24 is 24.
- Put a small sticker or chalk mark on each shelf as you finish it, so nothing is counted twice or skipped.
- Only when the section is done, copy in the book balance for each item and work out the difference.
The person counting should not know the book balance in advance. Someone who knows the book says 48 tends to find 48. That's the reason the column stays empty until the end, and the reason the best counter is someone who doesn't sell from that section.
Sales made while you are counting
This is what puts people off counting during opening hours, and it has a simple answer.
Keep a scrap of paper in the section. If a customer buys something from a shelf you have already counted, write it down: item and quantity. If they buy from a shelf you haven't reached, do nothing, because the count will pick it up.
At the end, subtract the noted sales from your counted figures before you compare with the book. Three tins sold from a counted shelf means the shelf figure you compare is three lower.
Reading the result
Here is part of a sheet from an imaginary provision store.
| Item | Unit | Counted | Book balance | Difference | Note |
|---|---|---|---|---|---|
| Tin milk 400g | tin | 46 | 48 | 2 short | |
| Malt drink can | can | 18 | 24 | 6 short | Check deliveries |
| Sardine 125g | tin | 61 | 60 | 1 over | |
| Bath soap 150g | bar | 23 | 23 | 0 |
Small differences in both directions are usually recording mistakes. One over on sardines probably means a sale was written against the wrong item.
Six cans short is different. Before deciding what it means, check three things. Was the last delivery really the quantity on the invoice? Is there a carton in the store room that wasn't counted? Were any given out on credit and not written down? If all three come back clean, you have a real shortage, and it is worth reading about how stock and money leave a shop.
Put a value on it either way. Six cans at a cost of ₦700 is ₦4,200. Shortages feel different once they are in naira.
After the count
Correct the book to match the shelf. In your stock record book, write a line that says "Counted on shelf" with the date and the real figure, so the book starts the next week telling the truth. Don't quietly change the old balance. The correction is part of the record.
Keep the count sheets in a file. After three months they show you things a single count can't: which items are short again and again, and which section they sit in.
How often
There isn't one right answer, but this works for most small shops. Count your 20 most valuable or fastest items every week, on a day that changes. Count the whole shop, section by section, once a month. Do one full count on a single day at the end of the year, when you want a clean figure for your accounts.
A weekly count of 20 items takes 15 minutes. It's the cheapest protection a shop has.