Kirana Working Capital Manual

How to Identify Dead FMCG Stock and Free Up Trapped Working Capital

7 min practical read • For Android & iOS Phones / Tablets • Inventory Velocity & Cash Flow

Walk into any small provision store or kirana mart in India, and you will notice an identical paradox: the merchant complains bitterly that they have no liquid cash to pay wholesale distributor invoices, yet their shelves and loft storage are packed ceiling-high with cardboard boxes. Their balance sheet is solvent, but their cash flow is dead.

In retail grocery, profit is not made on the percentage margin printed on the carton; profit is made on velocity. An item with a thin 5% margin that rotates off your shelf every 6 days generates far more cash profit across a year than a specialty cosmetic product with a 35% margin that sits gathering dust on your counter for 180 days.

The Velocity Mathematics Every Shopkeeper Must Memorize
  • Fast Staple (Cooking Oil): 5% gross margin, rotates 50 times a year = 250% annual return on your invested ₹10,000 working capital.
  • Slow Impulse Item (Niche Skin Cream): 35% gross margin, rotates 2 times a year = 70% annual return on invested capital, minus packaging deterioration losses.
Chasing high percentage margins on slow-moving products is the quickest path to a liquidity crisis.

The Distributor "Volume Discount" Trap

Wholesale sales representatives are trained to exploit shopkeepers' natural desire for higher margins. They offer tempting schemes: "Bhaiya, buy 24 cartons of this new premium biscuit instead of 2, and you will get an extra 6% scheme discount plus 1 free jar."

Before saying yes, calculate your true holding cost. If those 24 cartons take four months to sell, you have frozen ₹35,000 of liquid cash that you urgently need to purchase high-velocity commodities like sugar, pulses, and atta. Furthermore, under ambient Indian humidity, confectionery packaging softens, labels fade, and distributor returns become disputed after 90 days.

Step-by-Step Offline Stock Audit in KhataOS

1

Log Purchases with True Landing Cost (Not Just Invoice Rate)

Execution Time: ~2 minutes per delivery

When a wholesale delivery arrives, never log just the printed base rate. Your true landing cost determines your real shelf margin:

  • In KhataOS inventory intake, record: Wholesale Invoice Price - Scheme Discount + Inward Rickshaw/Hamali Freight.
  • If you deal in composition or uncredited supplies, include non-claimable GST in the cost price. KhataOS stores this true baseline cost per SKU in local SQLite storage.
2

Classify Inventory into 3 Distinct Velocity Tiers

Strategic Categorization

Tag your inventory into three operational buckets inside KhataOS:

  • Tier A (Cash Flow Engines): Edible oils, dairy, sugar, packaged wheat flour, basic salt, and daily bathing soaps. Shelf turnover: 7 to 14 days. Maintain strict stock availability; running out of Tier A items drives customers to competing shops.
  • Tier B (Stable Margin Earners): Packaged spices, branded detergents, popular biscuits, toothpastes. Shelf turnover: 20 to 30 days. Reorder strictly in weekly batches.
  • Tier C (High-Risk Capital Traps): Gourmet sauces, oversized detergent buckets, seasonal festival packs, specialty confectionery. Shelf turnover: 45+ days. Never buy in bulk quantities regardless of distributor discount schemes.
3

Run the 45-Day Inactivity Audit Filter

Execution Time: ~1 minute (Monthly routine)

On the 1st of every month, perform a cold, unsentimental audit of your shop shelves:

  • Open KhataOS on your mobile phone or tablet and apply the Inactive SKU Filter (45+ Days with Zero Counter Sales).
  • The screen immediately lists all items that have had zero billing activity for over 6 weeks, displaying the exact rupee capital trapped in those units.
4

Execute Swift Capital Liquidation

Action Protocol

Once dead stock is identified, implement an immediate liquidation strategy before package deterioration:

  • Distributor Exchange: If products are intact and within 60 days of purchase, insist that the delivery agent take back the unsold units against credit for fast-moving items.
  • Counter Bundle Offers: Pair a slow-moving item (e.g. ₹60 fruit squash) with a high-velocity essential (5kg Atta) at cost price: "Buy 5kg Atta, get Squash for just ₹35." Recovering your raw capital in cash today is 100x better than staring at an expired bottle six months later.

The Kirana Inventory Health Matrix

Category Type Target Margin Maximum Safe Stock Holding Reorder Strategy
Staples & Commodities 4% to 8% 7 to 10 days of sales Weekly rolling purchase orders.
Branded Packaged FMCG 10% to 15% 14 to 21 days of sales Bi-weekly orders; never exceed 3 weeks stock.
Personal Care & Cosmetics 18% to 25% 30 days of sales Order by single outer packs; reject bulk schemes.
Dead Stock Threshold Any Exceeding 45 days Immediate liquidation or distributor return.

Check Margin vs. Markup Percentages Instantly

Confusing markup with profit margin is the most common retail math error. Test your landing cost and target profit margins with our free web calculator:

Launch Margin vs Markup Calculator →

Protect Your Store's Working Capital with KhataOS

KhataOS provides 100% offline inventory and stock velocity tracking on your Android and iOS mobile device. Monitor dead inventory, protect your counter cash flow, and run your store without monthly subscriptions.

Get on Google Play Download on App Store