You don't need a laptop, a fast connection or a monthly subscription to know what is on your shelves. You need one habit: write down every item that comes in and every item that goes out. Do that consistently and you will always know what you have, what is selling and when to buy more.
Why tracking stock matters
Most small-shop operators rely on memory. The owner "just knows" that there are about ten packets of sugar left, or that a product was topped up on Monday. That works... until it doesn't. A customer asks for something you thought was in stock. A delivery arrives and you realise you already had plenty. Or the cash in the till doesn't match what you believe you sold, and you can't work out why.
Tracking your stock fixes these problems quietly. You stop running out of the products people buy most, you stop tying up money in things that sit unsold, and you can see where items are going missing. Even a very basic record gives you answers that memory cannot.
The only formula you need
Every method in this article comes down to the same simple sum. The stock you have left is what came in, minus what went out.
Say you prepare 10 cups of Kenyan tea for the afternoon and sell 3 of them.
That is the whole idea. "In" is anything added to your stock: a delivery from your supplier, something you prepared, or a customer return. "Out" is anything that leaves: a sale, a spoiled item, a free sample, or something you took home. If you record both sides honestly, the balance is always right.
Three ways to track stock offline
You can do this on paper, on a spreadsheet or in an app. None of them needs the internet to work. The right choice depends on how many products you sell and how much time you have.
1. Pen and paper
A hard-covered notebook is the cheapest place to start. Give each product its own page, and draw columns for the date, stock in, stock out and the balance. Every time something comes in or goes out, add a line and update the balance.
It works, and it costs almost nothing. The downside is that pages fill up, handwriting gets messy, and adding up totals by hand is slow and easy to get wrong. It suits a stall with a handful of products.
2. A spreadsheet
If you have a computer, a spreadsheet can do the arithmetic for you. Make one row per product, with columns for quantity in, quantity out and a formula that works out what is left. You can also add the cost price and let the sheet calculate your total stock value.
The catch is that you need to be at the computer to use it, which is not always possible in the middle of a busy shift. Backing up and sharing the file is also your responsibility.
3. An offline inventory app
An app on your phone goes everywhere you do, so you can record a sale as it happens. A good offline app keeps your data on your device, which means it keeps working with no signal, needs no account and does not upload your sales anywhere. It also does the sums automatically and can warn you when a product is running low.
| Method | Cost | Speed | Works offline |
|---|---|---|---|
| Notebook | Very low | Slow | Yes |
| Spreadsheet | Low | Medium | Yes, on a computer |
| Offline app | Free to low | Fast | Yes, on your phone |
The best system is the one you will actually keep up on a busy day.
How to set up your stock record in four steps
Whichever method you choose, the setup is the same.
- List your products. Write down everything you sell. Group similar items together, for example coffee in one group and teas in another, so the list is easy to scan.
- Count what you have today. Physically count each product and write the number down. This is your starting stock, and every later number builds on it.
- Add the prices. Note what each item costs you and, if you like, what you sell it for. You will need these later to work out the value of your stock and your profit.
- Record every movement. From now on, each time stock comes in or goes out, write it down with the date and the quantity.
The first count takes the longest. After that, the work is a few seconds each time something changes.
Habits that keep your numbers accurate
A record is only useful if it is right. These habits make the difference.
- Record at the moment it happens. Entries made on the spot are far more accurate than ones you try to remember at closing time.
- Keep one record, in one place. If two people write in two different notebooks, the numbers will never agree.
- Count the shelf once a week. Compare what is physically there with what your record says, and correct any gap. Small differences found early are easy to explain.
- Write down waste. Spoiled, expired, broken and given-away items still leave your stock. Record them as "out" so the balance stays honest.
- Keep personal use separate. If you take items home, record them too, even if it feels awkward. It is the quickest way to see where stock is really going.
Do your weekly count at the same time every week, such as Monday morning before you open. A fixed routine is much easier to stick to than "whenever I have time".
Common mistakes to avoid
Most stock records fail for the same few reasons. The first is starting without a proper count, so every number is built on a guess. The second is recording only sales and forgetting deliveries, which makes the balance drift further from reality each week. The third is making the system too complicated. If recording an item takes more than a few seconds, you will skip it when you are busy, and a record with gaps is nearly as bad as no record at all.
Start simple, and add detail only when the basics have become a habit.
Put your numbers to work
Once you are recording stock, the numbers start paying you back. Three free tools can help you use them:
- Work out what your shelves are worth with the stock value calculator.
- Find out when to order more of each product with the reorder point calculator.
- Give customers a clear record of each sale with the receipt generator.
Final thoughts
Tracking stock does not need expensive software or a reliable connection. It needs a clear starting count, a simple record of what comes in and goes out, and a habit of checking the shelf against the page. Choose the method that fits the way you work today, and you can always move to a more powerful one as your shop grows.
Key takeaways
- Stock left equals stock in, minus stock out.
- You can track stock without internet using a notebook, a spreadsheet or an offline app.
- Start with an honest count, then record every movement as it happens.
- Count the shelf weekly and write down waste, so your record stays accurate.
- Use your numbers to value your stock and decide when to reorder.
