Why your stock register never matches the shelf

Every shop owner has done this. You open the stock register (or the stock screen), it says you have 24 packets of something, you walk to the shelf — and there are 17.

Seven packets didn't vanish. They leaked out of your records through one of a handful of predictable gaps. Find the gap, and the numbers start matching again.

Here are the four leaks we see most often, and how to close each one.

Leak 1: Sales that never became a bill

This is the biggest one. A regular customer takes something "I'll pay tomorrow". A staff member hands over an item while you are busy and forgets to bill it. You sell a loose quantity and round it off in your head.

Each one is small. Over a month, they add up to the gap you see on the shelf.

How to close it

• Bill everything, even credit sales. A credit sale is still a sale — record it against the customer's account. Their balance goes up, your stock goes down, and both numbers stay honest.
• Make billing faster than not billing. If raising a bill takes a minute, people skip it at rush hour. Barcode scanning and a quick-add counter screen bring it down to seconds.
• Give each staff member their own login. When every bill is tied to a person, "I forgot" happens far less often.

Leak 2: Purchases entered late — or not at all

Stock arrives, gets unpacked onto the shelf, and the supplier's bill goes into a drawer "to enter later". Until it is entered, your records think you have less than you do. Then a few bills get missed entirely.

How to close it

• Enter the purchase bill the day the goods arrive, before they go on the shelf. Make it part of receiving stock, not a separate job.
• Check the bill against the delivery. If the supplier billed 12 and sent 10, record what you actually received and settle the difference with them — otherwise your register starts the day wrong.

Leak 3: Returns, damage and expiry

A customer returns a product. Something breaks in transit. A batch expires and goes in the bin. A packet gets opened for a "sample".

None of these are sales, so they never appear in your sales records — but they all change what is on the shelf.

How to close it

• Record customer returns as sales returns, not by quietly putting the item back. The return reverses the sale and puts the stock back in your records properly.
• Record goods sent back to the supplier as purchase returns.
• Use a stock adjustment for everything else — damage, expiry, theft, samples, your own use. Write a short reason each time ("expired", "damaged in delivery"). After a few months, those reasons tell you exactly where your losses come from.

Leak 4: The opening stock was never right

If the starting number was a guess, every number after it is a guess too. This is common when a shop moves from a paper register to software and types in "roughly" what it has.

How to close it

• Do one honest count. Pick a quiet day, count your top items properly, and set their stock to the real figure.
• Start with the items that matter. You don't need to count every screw on day one. Count your top 50 sellers and your most expensive items first; fix the rest as you go.

A 15-minute weekly routine that keeps it honest

You do not need a full stock-take every week. You need a small, regular check:

1. Pick 10 items — rotate through your catalogue, but always include a few fast movers and a few expensive ones.
2. Count them on the shelf and compare with what your records say.
3. If it matches, move on. If it doesn't, ask: was there an unbilled sale, a purchase not entered, a return or damage not recorded?
4. Fix the cause, then adjust the number with a reason.

Ten items a week is roughly 500 a year. Most small shops will have checked every important item several times over without ever closing for a stock-take.

Let the software do the arithmetic

The point of keeping stock in software is that you stop doing the maths. In MyShoppingBill:

• every sales invoice reduces stock and every purchase bill increases it, automatically;
• sales returns and purchase returns move stock the right way;
• stock adjustments handle damage, expiry and corrections, with a note;
• low-stock alerts can be switched on per item, with your own minimum level, so you reorder before the shelf is empty;
• the stock summary report shows quantity and value for every item at a glance.

When cancelled bills are reversed (rather than deleted), the stock goes back too — so the record of what happened stays complete.

The shelf and the register will never match by accident. But close these four leaks and they will match far more often than not — and when they don't, you'll know where to look.