Business

A weekly stock check of your top 20 items

Pick the 20 items that bring in the most money, count them in about 15 minutes each week and spot a stock gap before it costs you sales.

Editorial illustration for A weekly stock check of your top 20 items

Count only the 20 items that bring in the most money, once a week, at the same hour, and write down the quantity on a fixed sheet. Twenty items at roughly 45 seconds each is about 15 minutes (20 x 45 = 900 seconds), short enough that you will actually do it. A gap in one of these items shows up in your cash faster than a gap in a slow mover.

How do you pick the 20 items that matter most?

Do not guess from memory. Use your own bills or your daily sales book for the last four weeks and work out, item by item, quantity sold multiplied by selling price. Sort the list from biggest to smallest and take the first 20.

Item (made-up kirana)Sold in 4 weeksPrice eachSales value
Atta 5 kg bag60₹250₹15,000
Sunflower oil 1 litre pouch90₹140₹12,600
Sugar 1 kg120₹48₹5,760
Tea 250 g pack55₹110₹6,050

The prices above are invented to show the arithmetic. Your own list will look different, and that is the point. Rank by sales value, not by units, because 120 packs of sugar still earn less shelf value than 60 bags of atta here.

Then add two or three cheap items that make a customer walk out if you run dry, such as milk packets or bread. They rank low by value but high by annoyance.

What does the 15-minute count look like?

  1. Pick one fixed time each week, for example Monday before opening, so the day's sales do not mix with the count.
  2. Print or write the 20 items in the order they sit on your shelves, so you walk once and never backtrack.
  3. Count front to back, one item at a time, and write the number with its unit (bags, packs, litres).
  4. Where a carton is sealed, write cartons plus loose pieces rather than guessing the total.
  5. Finish by marking any item at or below your own minimum level with a tick.

What columns should the sheet have?

Keep it to five columns: item, count last week, bought this week, count now, and a gap column. The gap is simply what went out of the shop during the week: last count plus bought minus count now.

Take atta 5 kg bags as an example. Last week you counted 14, you bought 20, and today you count 9. That means 14 + 20 - 9 = 25 bags left the shop. If your bills show 23 bags sold, two bags are unexplained.

Is a gap of two bags worth worrying about?

One small gap in one week is often a miscount, so recount the shelf and the godown corner before you decide anything. Treat it as a signal when the same item is short two or three weeks in a row, or when the missing item is a high-value one.

Before suspecting anyone, check the ordinary causes:

  • A bag opened and sold loose by weight, so the pieces do not match the bills.
  • Stock taken home or given as a favour and never written down.
  • A supplier delivering fewer pieces than the challan says, which is why the count on delivery day matters.
  • Sales made without a bill or without a note in the sales book.

How often should you refresh the top 20?

Rework the ranking once a month, and again before a festival or a season change. Cold drinks, sweets, dry fruits and school stationery can all climb into the top 20 for a few weeks and drop out again. An item that has not entered your top 20 for three months can be removed from the sheet.

A checklist for the first four weeks

  • Week 1: build the ranking from the last four weeks of sales and write the list in shelf order.
  • Week 2: do the first count and do not judge the gaps yet, since you have no earlier week to compare with.
  • Week 3: calculate the first real gaps and recount any that surprise you.
  • Week 4: note which items hit your minimum level and place the order for them before they run out.

Purchases for restocking can be added by hand in SpendixAI, several at once, so the week's buying sits next to the count you wrote on paper.

SPENDIXAI JOURNAL

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

Explore your reports