Business

Missing cash or missing stock: telling which one is leaking

Compare cash difference and stock difference side by side for two weeks to see if a shop leak is cash, goods or recording, with a four-case table.

Editorial illustration for Missing cash or missing stock: telling which one is leaking

To tell whether cash or stock is leaking, put two numbers side by side for two weeks: the cash difference at closing and the stock difference from a count. Where the two columns point in different directions, the pattern tells you whether the problem is money, goods, or a recording gap. You need only two weeks and a short list of items to count.

What are the two numbers?

The cash difference is counted cash minus the cash your bills say should be there. The stock difference is the value of what is physically on the shelf minus what the records say should be there: opening stock plus purchases minus items sold on bills. Value stock at your purchase cost, not at the selling price, so that a shortage is not overstated.

Reading the pairs: a four-case table

Cash differenceStock differenceMost likely story
ShortStock matchesMoney left the drawer after billing: errands, wrong change, UPI booked as cash, or credit that was never collected
MatchesStock shortGoods left without a bill: breakage, spoilage, giveaways, theft, or weighing too generously
OverStock shortGoods were sold and paid for in cash, but the bill was never written
ShortStock shortMore than one cause. Work on cash first, then stock, one week each

These are leads, not verdicts. A shop can have several causes at once, but the table tells you where to look first.

How do I count stock without closing the shop?

You do not need to count everything. Pick ten items that move fast or are expensive, and count only those on the same day each week, at closing. Write the count against the records. Over two weeks this gives a fair signal even if the rest of the shop is never counted.

  1. List ten items that account for most of the shelf value or that customers buy daily.
  2. On day one, count them and note the quantity and the purchase cost.
  3. During the week, record every purchase received and every item sold.
  4. On day eight, count again. Expected quantity is opening plus purchases minus sold.
  5. Value the difference at purchase cost and note it beside the week's cash difference.

A two-week example with made-up numbers

WeekCash differenceStock difference at cost
Week 1minus ₹420minus ₹60
Week 2minus ₹380minus ₹110
Totalminus ₹800minus ₹170

Cash is short by 420 + 380 = ₹800 while stock is short by 60 + 110 = ₹170 over two weeks. Cash is the bigger leak by a wide margin, so spend the next week on what leaves the drawer: slips for small errands, UPI against cash, change handling. The stock gap is small enough to look at later, perhaps as normal breakage.

What should I do after two weeks?

Pick the bigger column and work on it for the third week. If you chose cash, bring in small cash slips and a handover count. If you chose stock, tighten receiving: count items when they arrive and tick them against the invoice. Then repeat the two-column test for another fortnight to see whether the gap moved.

Why do shops mix up cash and stock problems?

Cash is counted every night and stock is counted rarely, so cash problems look bigger simply because they are measured more often. A leak of ₹50 a day in goods can go unnoticed for a year when nobody counts, while the same ₹50 in cash shows up within days. Counting a few key items every week closes that visibility gap, and closing the gap is as valuable as finding the cause, because you can only fix what you measure.

A last check before you blame anyone

  • Were all purchase bills entered, including small cash purchases?
  • Were returns to a supplier or from a customer recorded?
  • Was any stock taken for home or sample use without a note?
  • Did a price change in the middle of the fortnight affect your valuation?

If the answers are all yes and the gap persists, a short joint count with a trusted second person is the next step.

SPENDIXAI JOURNAL

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

Explore your reports