From ₹30k monthly losses to zero expired medicines
december 2023 - the breaking point: watched papa throw away ₹18,000 worth of diabetes medicines that expired. same week, ran out of paracetamol (our bestseller!) for 3 days straight. he'd been managing inventory in 5 different notebooks—one for purchases, one for expiry dates, one for stock counts. zero system. zero alerts. pure chaos. his profit margin was getting destroyed. i built him a simple Google Sheets tracker with conditional formatting (red = expiring, yellow = low stock). added automatic reorder alerts. 6 months later: ZERO expired meds. stockouts dropped from 12/month to 2/month. revenue up ₹25k/month. papa went from stressed to confident. now he teaches other pharmacy owners the system. sometimes the solution isn't fancy software—it's just organizing what you already know. 💊📊
My father runs a small pharmacy. He was losing ₹20-30k every month because of medicines expiring on the shelf and running out of stock on popular items. He tracked everything in notebooks - no alerts, no analysis.
I built him a simple Excel-based system with color-coded alerts for expiry dates and stock levels. Six months later: zero expired medicines, 80% fewer stockouts, and ₹25,000/month revenue increase.
Expires in < 30 days or stock below reorder level. Take immediate action: discount sale or reorder.
Expires in 30-60 days or stock moderately low. Plan discount promotion or place order soon.
Stock adequate and expiry date comfortable. No action needed, continue monitoring.
Every Sunday, Dad receives an automated WhatsApp message with the week's summary: medicines expiring soon, low stock items, and bestsellers. This 30-second review keeps the inventory healthy with minimal effort.