Stock is where a shop's money lives. A provision store with ₦3 million of goods on the shelves and ₦40,000 in the drawer has nearly all its wealth in tins and cartons. Yet most owners count the ₦40,000 every night and the ₦3 million once a year.
Stock control sounds like something for supermarkets with scanners. It isn't. At the size of a small shop it comes down to five habits, and all of them can run on a notebook.
1. Know what you sell
Write a list of every product, with the unit you count it in, what it costs you and what you sell it for.
It's dull work and it pays back immediately. Most owners doing it for the first time find items they forgot they had, items priced below what they now cost, and two or three products that take up a whole shelf and haven't sold since Easter.
Be exact about what counts as one product. A 400g tin and a 900g tin of the same milk are two products. So are the red and the black of the same phone case, if customers ask for them by colour.
2. Write down everything that comes in and goes out
Stock changes for only a few reasons: you received goods, you sold goods, or something else happened to them. Damage, expiry, a return to the supplier, an item taken for the house.
Each of those gets written down on the day. Sales go in a daily sales record book. Everything, including each day's sales total per item, goes on that item's page in a stock record book, which keeps a running balance of what should be on the shelf.
If you only do one thing from this guide, do this for your 30 most important items.
3. Count, and compare
A record nobody checks drifts away from the truth. The count is what pulls it back.
You don't need to close. Count a section a day, and count your most valuable items weekly on a day that changes. Compare each count with the book balance and write the difference down in naira. The full method, with a count sheet, is in how to take stock in a shop without closing for the day.
When the shelf and the book disagree, the cause is one of three things: a recording mistake, damage nobody reported, or theft. Regular counts are how you tell them apart. A random difference now and then is error. The same items short every week is a pattern, and this guide to staff theft covers what to do about it.
4. Reorder by numbers, not by feeling
Running out of a fast seller sends your customer to a competitor. Buying too much of a slow one locks up money you need for the fast one. Both come from ordering by eye.
For each important item, work out a reorder level: the balance at which you place the next order, based on how many you sell a day and how long your supplier takes. Write it at the top of the item's page. The arithmetic is in reorder level formula, with a worked naira example.
5. Deal with what isn't selling
Every shop has goods that have sat for months. They look like stock. In practice they are cash you can't spend, and some of them are getting closer to an expiry date.
Once a month, go through your stock pages and mark anything with no sale in 60 days. Then decide: move it, bundle it, discount it, return it or write it off. The options, and how to choose, are in slow-moving stock: what to do with goods that won't sell.
For anything with an expiry date, put new stock behind old stock every time you fill a shelf, so the oldest sells first.
Two things that sit alongside stock control
Pricing. Your records give you the true cost of each item, which is the only sound basis for a price. Many shops believe they make 20% and make less. See markup vs margin.
People. Records only work if the people handling goods and money keep them. Put initials on every entry, and make closing the day a fixed routine. If you want the shop to run without you in it, this is how.
A weekly rhythm
| When | What | Time |
|---|---|---|
| Every sale | Write it in the sales book | Seconds |
| Every evening | Close the day and post sales to the stock pages | 15 minutes |
| Every delivery | Check against the invoice, sign, enter | 10 minutes |
| Once a week | Count your 20 key items | 15 minutes |
| Once a month | Count the whole shop by section, review slow stock | A few hours, spread out |
When the notebook stops being enough
A notebook handles one shop, a few hundred products and two or three staff. It starts to strain when the product list grows past what one person can keep posted each evening, when you open a second branch, or when you sell in the shop and online from the same shelf.
The signs are easy to spot: the stock pages are a week behind, the count takes so long it gets skipped, and you no longer trust the balances.
That's the point where software earns its place, and it's what we are building Tabs for. It hasn't launched yet. Whenever you do move to a system, the five habits above are what make it work. A system given bad records only gets to the wrong answer faster.