To find the items that tie up your cash, take the last two purchase bills for each item, add the quantities, count what is left on the shelf, and work out how much of it has sold. Items where only a small share has sold since those bills are your slow stock. A made-up grocery table below shows a jar of sauce and a packet of cookies standing out.
- Your purchase bills for the last four or five months, sorted by item or by supplier.
- A shelf count of each item you want to check, including quantities in the back room.
- The date of the older of the two bills, since it tells you the time period.
You do not need every item. Start with the ones that look dusty, and with items you ordered more than once and feel you still have too much of.
How do I read the bills against the shelf?
For each item, add the quantity on the last two bills. That is what you bought in the period. Subtract what is on the shelf now. The result is roughly what has sold in that period. Divide by the quantity bought to get the share sold. Here are four made-up items:
| Item | Bought (last 2 bills) | Left on shelf | Sold | Share sold |
|---|---|---|---|---|
| Ghee, 500 g | 12 + 12 = 24 | 3 | 21 | 88 percent |
| Oats, 1 kg | 20 + 20 = 40 | 14 | 26 | 65 percent |
| Pasta sauce jar | 24 + 24 = 48 | 40 | 8 | 17 percent |
| Imported cookies | 30 + 30 = 60 | 52 | 8 | 13 percent |
Ghee has moved almost entirely, so it is healthy. Oats are middling. The sauce and the cookies have sold under a fifth of what was bought, and the shop ordered a second time anyway.
How much cash is stuck?
Multiply the quantity left by what you paid. Say the sauce cost ₹95 a jar and the cookies ₹60 a packet. The sauce is 40 × ₹95 = ₹3,800 and the cookies are 52 × ₹60 = ₹3,120. Together that is ₹6,920 of cash on two shelves. Look at the time period as well. If the two bills were eight months apart, a share sold of 17 percent is slower than if they were three weeks apart.
What should I do about slow items?
- Stop reordering them until the shelf is clear, even if the supplier or a salesman suggests a deal.
- Check the expiry date or best-before date, since slow items are the ones that expire on the shelf.
- Move them to a place where customers see them, or put them near the counter.
- Try a small bundle or a price cut, and work out the margin you give up. A sauce that cost ₹95 and sells at ₹120 earns ₹25. Selling at ₹105 earns ₹10, which is better than a jar thrown away.
- Ask the supplier whether unsold, sealed goods can be returned or exchanged, and get the terms on a bill.
Can I do this in a sheet?
Set up columns for Item (A), Bought (B), Left (C), Sold (D), Share sold (E) and Cost per unit (F). Then:
- D2: =B2-C2
- E2: =D2/B2
- Cash tied up in G2: =C2*F2
- Total tied up: =SUM(G2:G100)
Sort by column E from low to high, and the slowest items come to the top. Format E as a percentage. These work in Excel and Google Sheets.
What if the item is new?
A new item needs a little time. Give it a few weeks before judging, and set a review date when you first order it. If the share sold is low on that date, treat it like any other slow item.
Keeping the bills where you can find them
The method needs purchase bills at hand. In SpendixAI, a receipt can be kept with its transaction, so a supplier payment imported from your statement can carry the bill image with it. That makes it easier to pull out the last two bills for an item when you want to check it.
A monthly habit
- Pick ten items you suspect are slow and check them.
- Record the cash tied up and the action you took.
- Revisit in a month to see if the shelf is lighter.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

