When your stock count does not match your records, first re-count, then look for the ordinary causes before suspecting theft: sales not recorded, returns, samples, damage, pack size mix-ups and bills entered twice or not at all. Work item by item, starting with the largest gap in rupees. Most small gaps are explained by two or three of these.
Is the count itself right?
- Count again, in a different order, ideally with a second person who did not do the first count.
- Check every place the item lives: the shelf, the back room, the godown, the display window and the delivery bag.
- Check the unit: a carton of 12 and a loose packet are not the same, and mixing them up gives a gap of 11.
- Check that the record is up to date: has every purchase bill and sales entry for the period been put in?
A re-count alone often removes half of the gaps. Do this before anything else.
What does a gap of 7 units look like in practice?
Say your records show 48 packets of an item, and the shelf has 41. The gap is 7. You work through the causes and find:
- 3 packets sold loose from an opened carton, never entered
- 2 packets given as samples to a regular customer
- 1 packet past its date and thrown away
- 1 packet you cannot explain
That is 3 + 2 + 1 + 1 = 7. Only one of seven units is truly unexplained, and one packet at ₹60 is not a crisis. Writing the explanation in the stock book beside the entry turns the gap into a record.
Which patterns point to which cause?
| Pattern | Likely cause | What to check |
|---|---|---|
| Record is higher than the count, small and steady | Loose sales, samples, wastage not written down | Add a column for samples and wastage in the stock book |
| Count is higher than the record | A purchase not entered, or a return not entered | Check recent bills and credit notes |
| Gap equals one carton | Unit mix-up or a carton not opened | Look for the carton in the back room |
| Gap appears in one item after a sale day | Sales not billed in the rush | Compare the day's bills with the till and UPI |
| Gap in small, valuable items again and again | Items taken or misplaced | Move them closer to the counter and count them daily |
Returns from customers and returns to suppliers both change the count. A customer who returns a pack and is given a different one leaves a gap if only one side is recorded. A pack sent back to a supplier needs a credit note, which should be entered when it arrives. Keep returns in a separate notebook page with the date, the item and the name of the supplier or customer, and add them to your records every evening.
When should I worry about theft?
Only after the ordinary causes have been cleared, and only if the same item or the same shift keeps showing a gap. Even then, start with process rather than blame. Count small valuable items at the start and end of each shift, keep a sign-out list for anything that leaves the shop without a bill, and keep the till and the stock book reconciled each day. If a pattern remains and the amounts are meaningful, talk to your accountant or a trusted advisor about the next step, and avoid accusing anyone without evidence.
How do I prevent the same gap next month?
- Enter every bill on the day it arrives.
- Make a sample and wastage page in the stock book.
- Count the top ten items by value every week, not only at month end.
- Sell loose items from one opened pack at a time, and mark the pack.
- Reconcile the day's bills with the cash and UPI at closing.
Keeping purchase evidence together
A purchase that is entered twice or not at all is one of the easiest gaps to cause and to find. If you attach each supplier bill to its payment as a receipt in SpendixAI, and import your bank statement so the payment appears on its own, you can match payments to bills when the count disagrees. Stock quantities themselves still live in your own register.
A fast way to work
- Rank the gaps by rupee value and start at the top.
- Re-count, and check the unit and location.
- Go through sales, returns, samples and wastage for the period.
- Write down the cause, correct the record and set one change for next month.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


