HomeBlog › The Sales-Velocity Reorder Formula Every Indian Pharmacy Should Use

The Sales-Velocity Reorder Formula Every Indian Pharmacy Should Use

2026-07-06 • 6 min read

A pharmacy owner in Surat told us he was placing orders every Monday by memory and gut feel. He had 11 years of experience. He also had ₹2.3 lakh worth of slow-moving stock sitting on his back shelf — some of it 40 days from expiry — while his counter staff was apologizing to customers three times a day for Augmentin 625 and Pantop D being out of stock. He wasn't a bad pharmacist. He just had no formula.

The real problem isn't ordering too much or too little. It's ordering without knowing your sales velocity — how fast each SKU actually sells, adjusted for lead time and buffer. Without that number, every reorder is a guess wearing the costume of experience. And in a business where margins run 10–18% on most OTC lines, guessing wrong repeatedly is the same as quietly writing a check to your distributor.

If you're reading this while staring at a stockout report or a pile of near-expiry strips, here's what you stand to lose by continuing with the current system: pharmacy industry data suggests 3–8% of annual inventory value is lost to expiry and dead stock. On a ₹40 lakh annual purchase, that's ₹1.2–3.2 lakh walking out the door silently, every year.

Your Reorder Points Are Probably Based on Nothing Measurable

A chemist in Thane showed us his order sheet last quarter — a printed Excel file his accountant had made in 2019. The reorder quantities hadn't been updated since GST rollout. Meanwhile, his sales mix had shifted: two new competitor pharmacies had opened nearby, a large diabetic population had moved into the catchment area, and three of his top-five brands had changed strip sizes.

The reason this happens is structural. Manual reorder systems require someone to actively update them. Nobody does. The result is what inventory specialists call "phantom reorder points" — numbers that look official but reflect a reality that no longer exists.

The cost is two-sided. Overstocked SKUs tie up working capital and create expiry risk. Understocked fast-movers generate stockout events that erode customer trust. A single stockout on a chronic medication — a patient's monthly Metformin or Amlodipine refill — may cause that customer to shift their entire basket to a competitor permanently.

Days of Cover Is the Number Your Business Is Missing

Days of cover answers a simple question: at my current sales rate, how many days will my existing stock last before I run out? The formula is:

Days of Cover = Current Stock Quantity ÷ Average Daily Sales

If you have 60 strips of a product and you're selling 4 per day, your days of cover is 15. If your distributor lead time is 3 days and you want a 4-day safety buffer, your reorder point triggers at 7 days of cover — meaning you place an order when stock hits 28 strips.

What most Indian pharmacies skip is adjusting average daily sales for seasonality. Paracetamol (HSN 3004) tablets may move at 2× velocity during monsoon in Mumbai. Cough syrups behave differently in December in Delhi than in April. A static daily average will systematically under-order during peaks and over-order during lulls — generating exactly the expiry pile and the stockout calls that are costing you money right now.

The three variables that make up a sound pharmacy reorder formula:

Reorder Point = (Average Daily Sales × Lead Time Days) + Safety Stock Quantity

The Regulatory Cost of Getting This Wrong

Stock mismanagement isn't just a margin problem — it creates compliance exposure. Under the Drugs and Cosmetics Act and Rule 65 of the D&C Rules, Schedule H and H1 medicines require a maintained purchase-and-dispensing register with 3-year retention. A pharmacy that runs out of an H1 product and sources it informally to cover a gap may inadvertently break the audit trail. Penalties under Section 27 of the D&C Act for record violations run from ₹1 lakh to ₹10 lakh.

From a tax perspective, expired medicines disposed of without proper documentation create GST input credit reversal obligations. Under the current framework — including provisions discussed at the 56th GST Council meeting in September 2025 — businesses disposing of goods on which input tax credit was claimed must reverse that credit. On a ₹1 lakh expiry write-off with 5% GST (applicable to most medicines under HSN 3004), that's a ₹5,000 ITC reversal that never shows up in your "expiry loss" calculation but hits your cash flow all the same.

The owner of a neighborhood pharmacy in Nagpur who began tracking this discovered his actual expiry cost was 23% higher than what he'd been reporting — once the ITC reversal was factored in.

What Running on Velocity Data Actually Looks Like

Here's a before/after for a single-outlet pharmacy doing ₹3.5 lakh monthly in purchases:

| | Before (gut-feel reorder) | After (velocity-based reorder) |

|---|---|---|

| Weekly order time | 45–90 min, owner-dependent | 8–12 min, staff can execute |

| Stockout incidents/month | 15–25 (estimated) | Typically drops to 3–6 |

| Near-expiry stock value | ₹60,000–₹1,20,000 | Often under ₹20,000 |

| Dead stock write-off | 4–7% of annual purchases | Typically 1–2% |

| Order accuracy | Based on memory | Based on 30-day rolling actuals |

The difference is not a technology miracle. It's the difference between ordering based on what you remember selling and ordering based on what your data shows you sold. The formula is not complicated. What's complicated is computing it manually across 800–1,200 active SKUs every week without errors.

That's where a system that tracks stock velocity automatically — and generates reorder suggestions based on actual days of cover — stops being a convenience and becomes a cost-control tool.

How Pharmacies Using Nesayo Handle This Without Thinking About It

A pharmacy owner in Pune who switched to Nesayo described his Monday morning this way: before he unlocks the shutter, he's already reviewed the Stock Sense agent's briefing — which SKUs have dropped below his set days of cover threshold, which items are within 45 days of expiry, and which fast-movers spiked in sales over the past week. The reorder draft is pre-populated. He approves or adjusts. The whole review takes under 10 minutes.

Stock Sense is one of five AI agents in Nesayo — the others are Morning Briefing (daily business snapshot), Expiry Guard (batch-level expiry alerts using FEFO logic), Refill Radar (identifies patients due for chronic medication refills), and Payment Advisor (outstanding credit tracking). These agents run on Nesayo's AI Employee plan, priced at ₹999 per month as of 2026-07-06 (see current pricing at nesayo.com/pricing). Billing itself is free, permanently, with no cap on bills or SKUs.

What makes the velocity calculation reliable in Nesayo is the underlying database — 253,973 medicines with composition, schedule, and HSN data — combined with FEFO batch selection, which means the system automatically surfaces the earliest-expiry batch at the point of billing. This prevents the common scenario where a new batch gets dispensed while an older batch ages toward expiry on the shelf behind it.

For pharmacies that need Schedule H1 compliance, the register is maintained automatically from billing data — no separate entry, no manual update. For owners who run Tally Prime for accounting, Nesayo exports data in Tally-compatible format (this is an export, not a live integration). Voice billing works in 10 Indian languages, which matters in pharmacies where counter staff operates in Marathi, Tamil, Bengali, or Gujarati rather than English.

The Starter AI plan, which includes Stock Sense, is ₹399 per month as of 2026-07-06 (nesayo.com/pricing). For context: if it prevents one expiry write-off of ₹5,000 in a month, the plan has paid for itself 12 times over.

The Choice in Front of You Right Now

If you keep ordering the way you're ordering today, the same three things will happen next month that happened this month: a stockout on a fast-mover, a near-expiry batch you didn't catch in time, and an order that took you an hour to build from memory. That's not a prediction — it's a pattern. The only way to break it is to introduce a reorder system built on actual sales velocity and actual days of cover, not habit.

Spend 2 minutes at nesayo.com/demo — the demo loads with real pharmacy data pre-populated, no signup required. You'll see exactly what your expiry queue and reorder suggestions would look like if your stock velocity were being tracked daily. If you want to see your own numbers, upload last month's sales data at nesayo.com/setup and the dashboard will calculate the rupee figure you lost to preventable stockouts and expiry in the last 30 days.

---

FAQ

Won't migrating to a new system mean losing all my existing stock and sales data?

Nesayo's onboarding includes a data import process for existing item masters and opening stock. You do not start from zero. Most pharmacies complete their opening stock entry within one working day using the bulk upload template. Historical sales data from previous software can be imported depending on the export format your current system supports — the Nesayo setup team will confirm compatibility before you commit to anything.

What happens when there's a power cut or internet outage during billing?

Nesayo is built as a Progressive Web App (PWA) with offline billing capability. Bills can be generated without an active internet connection; data syncs automatically when connectivity is restored. This was a deliberate design decision for Indian pharmacy conditions, where connectivity in Tier 2 and Tier 3 cities can be intermittent. The AI agents require internet to run their analysis, but the core billing counter does not.

What's the catch with free billing — will prices go up after I'm dependent on it?

Billing is free permanently, not free for a trial period. Nesayo's business model is the AI agent subscription — pharmacies that want Stock Sense, Expiry Guard, and the other agents pay for those (Starter at ₹399/month, AI Employee at ₹999/month, Chain at ₹2,499/month for multi-branch, all as of 2026-07-06 per nesayo.com/pricing). Pharmacies that only need billing and the 253,973-medicine database pay nothing. The free tier doesn't expire and isn't artificially capped to force an upgrade.

Nesayo runs pharmacy operations while you serve customers

Free billing forever. The AI Employee — 5 agents, voice billing in Hindi — is ₹999/month (2026). 2-minute setup.

Start free →