Business

Stock count does not match records: finding the gap in a shop

When the stock count does not match your records, work through a re-count, unrecorded sales, returns, samples and losses to find the gap.

Editorial illustration for Stock count does not match records: finding the gap in a shop

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?

  1. Count again, in a different order, ideally with a second person who did not do the first count.
  2. Check every place the item lives: the shelf, the back room, the godown, the display window and the delivery bag.
  3. Check the unit: a carton of 12 and a loose packet are not the same, and mixing them up gives a gap of 11.
  4. 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?

PatternLikely causeWhat to check
Record is higher than the count, small and steadyLoose sales, samples, wastage not written downAdd a column for samples and wastage in the stock book
Count is higher than the recordA purchase not entered, or a return not enteredCheck recent bills and credit notes
Gap equals one cartonUnit mix-up or a carton not openedLook for the carton in the back room
Gap appears in one item after a sale daySales not billed in the rushCompare the day's bills with the till and UPI
Gap in small, valuable items again and againItems taken or misplacedMove 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

  1. Rank the gaps by rupee value and start at the top.
  2. Re-count, and check the unit and location.
  3. Go through sales, returns, samples and wastage for the period.
  4. Write down the cause, correct the record and set one change for next month.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports