Why Your Shop's Stock Never Matches the Books, and How to Fix It

Why Your Shop's Stock Never Matches the Books, and How to Fix It

Every month-end the same thing happens in many Kenyan shops, hardware stores, pharmacies and mini-marts. The owner counts what is on the shelves, compares it with what the books say should be there, and the two numbers do not agree. Sometimes the gap is small. Sometimes it is big enough to wipe out the month's profit. Nobody can quite explain where the difference went.

This post explains why stock and records drift apart, why more spreadsheets rarely fix it, and what a well-designed point of sale and inventory system actually changes day to day.

Where the gap really comes from

Most owners assume missing stock means theft. Theft does happen, but in our experience it is usually only part of the story. The gap tends to build up from many small, ordinary problems.

Sales that never get recorded properly

A customer pays by M-Pesa while the counter is busy. The attendant hands over the goods, meaning to write it down later, and forgets. Or a sale is recorded in the receipt book but under the wrong item. Each slip is minor. Over weeks they add up.

Deliveries that are not checked in

A supplier drops off goods while the owner is away. The delivery note goes into a drawer. Some items were short, some were damaged, and the invoice is paid in full anyway. The books now show stock that never arrived.

Units that do not match

You buy cooking oil by the carton and sell it by the bottle. You buy cement by the lorry and sell it by the bag. If the conversion is done by hand, mistakes creep in and nobody notices until stock-take.

Expiry, breakage and internal use

Expired medicine is thrown away. A bag of flour splits. Staff take sugar for tea. None of this is recorded, so the system believes the goods are still for sale.

Several branches, one set of guesses

Once a business opens a second or third location, stock starts moving between branches. Without a shared record, transfers are noted on paper, if at all, and each branch's numbers become unreliable.

Why another spreadsheet does not solve it

Spreadsheets are a good first step and many businesses run on them for years. The trouble is that a spreadsheet only knows what someone types into it, usually after the fact. It cannot stop a sale being skipped, check a delivery against the order, or confirm that an M-Pesa payment matches a recorded sale. It also depends on one or two people who understand the file, and it breaks quietly when someone sorts the wrong column.

The real fix is to capture information at the moment things happen, by the person doing the work, in a way that is quicker than not recording it.

What a good point of sale and inventory system changes

A point of sale system is not just a till that prints receipts. Done properly, it becomes the single place where every item that enters or leaves the business is counted.

Every sale moves stock automatically

When an attendant scans a barcode or taps a product, the sale is recorded and the stock level drops at the same moment. There is no separate step to forget. Unit conversions, such as cartons to pieces, are set up once and handled by the system from then on.

M-Pesa payments tied to sales

With M-Pesa integration, a till or paybill payment can be linked directly to the sale it belongs to. At the end of the day the system shows which sales were paid by cash, which by M-Pesa, and whether anything does not match. Reconciliation stops being an evening of scrolling through SMS messages.

Deliveries received against orders

Purchase orders are created in the system, and when goods arrive the person receiving them confirms quantities item by item. Shortfalls and damages are flagged before the supplier is paid, and stock levels go up only by what actually arrived.

Write-offs with a reason

Expired, damaged or internally used items are recorded with a reason and the name of the person recording them. This does two things: the books stay accurate, and patterns become visible. If one branch writes off far more than the others, you will see it.

Branch transfers that both sides confirm

When stock moves from one branch to another, the sending branch records it and the receiving branch confirms it. Goods in transit are visible, and nothing disappears between locations without someone noticing.

User roles and an audit trail

Each staff member logs in with their own account. Attendants can sell; supervisors can approve discounts and returns; only the owner or manager can adjust stock levels. Every change is logged, so questions can be answered with facts rather than suspicion.

The reports that actually matter

Once data is captured reliably, useful reports follow naturally. The ones owners tend to value most are:

  • Low-stock alerts, so you reorder fast-moving items before customers walk away empty-handed.
  • Slow-moving stock, so you stop tying up cash in goods that sit on shelves for months.
  • Profit by item and by branch, showing what genuinely earns money rather than what simply sells a lot.
  • Expected versus counted stock, so stock-takes become a quick check rather than a crisis.
  • Sales by attendant and by hour, helping with staffing and spotting unusual activity.

Where it suits the business, alerts can also go out by bulk SMS, for example notifying the owner when stock of a key item falls below a set level, or when a large discount is approved.

Making the switch without disrupting the shop

The biggest worry we hear is that changing systems will slow down the counter or confuse staff. A sensible rollout keeps that risk low:

  1. Clean up the product list first. Agree names, units and prices before anything goes live.
  2. Do an opening stock-take. The system can only be as accurate as its starting point.
  3. Start with one branch or one counter. Iron out issues before rolling out further.
  4. Train on real tasks. Attendants learn fastest by making sales, not by reading manuals.
  5. Review the first few weeks closely. Early discrepancies usually point to a setup issue that is easy to fix.

It also helps to choose a system that works on hardware you can source locally, keeps working when the internet drops and syncs once the connection returns, and can grow with the business, whether that means adding branches, an online store or tax-compliant invoicing as requirements change.

Ready-made or built for you?

Many shops are well served by a ready-made point of sale and inventory platform with M-Pesa and SMS already built in. Businesses with unusual workflows, such as fuel stations, wholesalers selling on credit, or pharmacies tracking batches and expiry dates, may need something adapted or built around how they actually operate. The right answer depends on your stock, your branches and how your staff work.

Let's look at your stock problem together

If your month-end counts keep surprising you, or you are spending more time reconciling than running the business, talk to Glomex. We will listen to how your shop or branches work today, show you where the gaps are likely coming from, and recommend whether our ready-made Point of Sale and Inventory Management platform fits, or whether something more tailored makes sense. Get in touch and tell us about your business.

Share this post

Know someone who'd enjoy reading Why Your Shop's Stock Never Matches the Books, and How to Fix It?

Leave a Comment

1