Pharmacy Analytics in India: The Numbers Your Billing Software Is Not Showing You (And Why They Matter)

A pharmacy owner in Pune named Sunil asked me a simple question last year: "Which ten medicines make me the most profit?"

He could not answer it. He knew his top sellers by volume — Dolo 650, Pan 40, Shelcal — because he reorders them every week. But profit? That requires knowing not just sales volume but purchase cost, selling price, expiry losses, and return rates for each product. Sunil had been running his pharmacy for eight years without ever calculating per-product profitability.

When we finally ran the analysis using his billing data, he discovered something that shook him. His number one seller by volume — Dolo 650 — was his number fourteen product by profit margin. He was selling 400 strips a month at a 12% margin. Meanwhile, a diabetes supplement he sold 30 units of per month was generating nearly the same absolute profit because of a 45% margin.

"I have been spending my energy promoting the wrong products for eight years," he said.

That single insight — which took his billing software all of fifteen minutes to calculate once we connected the analytics — changed how Sunil runs his pharmacy. He did not stop selling Dolo (you cannot, it is a staple). But he started giving shelf space, counter placement, and staff attention to his high-margin products instead of his high-volume ones.

That is what analytics does. It shows you what your gut feeling misses.

Why Most Pharmacy Owners Fly Blind

Indian pharmacies generate enormous amounts of data every day — every sale, every purchase, every return, every expiry. But most of that data sits in the billing software like coins in a forgotten piggy bank. Present but unused.

Here is why:

The Billing Software Trap

Most pharmacy billing software in India is designed to do one thing well: generate bills. It calculates GST, prints receipts, and tracks inventory at a basic level. At the end of the day, it gives you a total sales figure.

But it does not tell you:

• Which product categories are growing and which are declining
• Which distributors give you the best effective margin (after accounting for schemes, returns, and credit terms)
• What your real profit margin is after expiry losses
• Whether your evening staff sells more per hour than your morning staff
• How your weekday sales compare to weekends, and what that means for staffing

These questions require analytics — not just data recording.

The Spreadsheet Purgatory

Some pharmacy owners try to fill this gap with Excel. They export data from their billing software, spend Sunday mornings building spreadsheets, and create charts that they look at once and then forget.

The problem with spreadsheets: they require manual effort every time you want an answer. "How did Category X perform last quarter?" requires exporting data, filtering, calculating, and formatting. By the time you have the answer, the insight is stale.

An analytics dashboard gives you the same answer in two clicks. And it updates in real time.

The Five Reports Every Pharmacy Owner Needs

After working with 50+ pharmacies on analytics implementations, I have identified five reports that consistently drive the most impactful business decisions.

Report 1: Product Profitability Analysis

What it shows: Every product ranked by gross profit — not revenue, not volume, but actual rupees of profit after accounting for purchase cost.

Why it matters: You probably give premium shelf space and counter attention to your top sellers. But top sellers are not always top profit generators. A product with Rs 5 profit per unit sold 500 times a month makes Rs 2,500. A product with Rs 50 profit per unit sold 80 times makes Rs 4,000.

The action: Rearrange your counter display and staff recommendations based on profit, not volume. Place high-margin products at eye level. Train your counter staff to suggest alternatives that are better for both the customer and your margin.

Report 2: Dead Stock and Slow Movers

What it shows: Products that have not sold a single unit in 30, 60, or 90 days. Products with sales velocity below a threshold you define. Products approaching expiry with more than 60% of stock remaining.

Why it matters: Dead stock is money sitting on your shelf earning zero returns. Worse, it is money that will become a write-off when it expires. The average Indian pharmacy has 5% to 8% of inventory value in dead or near-dead stock at any given time.

For a pharmacy with Rs 20 lakh in inventory, that is Rs 1 lakh to Rs 1.6 lakh doing nothing. If you could redeploy that capital into fast-moving products, the impact on cash flow is immediate.

The action: Run a monthly dead stock review. Return what you can to distributors (many accept returns within policy periods). Transfer slow movers to other locations if you have multiple stores. Offer near-expiry products at discounted rates to hospitals, clinics, or NGOs before they expire.

Report 3: Purchase Analytics — Distributor Performance

What it shows: For each distributor: total purchase value, effective discount (including schemes), return acceptance rate, average delivery time, and stock-out incidents.

Why it matters: Most pharmacy owners choose distributors based on relationship and habit. "I have been buying from Sharma Agencies for fifteen years." That loyalty is admirable. But is Sharma Agencies actually giving you the best deal?

When you compare distributor performance side by side, patterns emerge. Distributor A offers 10% discount but delivers in 3 days. Distributor B offers 8% discount but delivers same-day and accepts 100% returns. Depending on your situation — whether you need fast restocking or maximum margin — the "best" distributor is different.

The action: Review distributor performance quarterly. Negotiate with data: "Your delivery time averaged 4.2 days last quarter while your competitor averaged 1.8 days. Can you match that, or should I shift 30% of my orders?"

Report 4: Time-Based Sales Patterns

What it shows: Sales broken down by hour of day, day of week, and week of month.

Why it matters: Staffing is your second-largest cost after inventory. If you are staffing uniformly throughout the day but 60% of your sales happen between 5 PM and 9 PM, you are overstaffed in the morning and understaffed in the evening.

A pharmacy in Bangalore I worked with discovered that their Saturday sales were 40% higher than weekdays but they had the same staff count. They added one person on Saturdays and their customer complaints about wait times dropped by half.

The action: Align staffing with demand patterns. Consider extended evening hours if your data shows demand past your current closing time. If Monday mornings are slow, use that time for inventory counts, returns processing, or staff training.

Report 5: Customer Purchase Behaviour

What it shows: For patients who purchase regularly: their purchase frequency, average basket size, product preferences, and any gaps in their expected purchase pattern.

Why it matters: A diabetic patient who buys Metformin every month and suddenly stops is either getting it from somewhere else (you lost a customer) or has stopped their medication (a health concern). Either way, it is actionable.

The action: Set up alerts for "expected customers who did not purchase this month." A simple WhatsApp message — "We noticed you have not picked up your regular medicines. Everything okay?" — is both good customer service and good business.

The Margin Analysis That Changes Everything

Let me walk through a specific analysis that has transformed how every pharmacy I have worked with thinks about their business.

True Margin Calculation

Most pharmacy owners calculate margin as: (Selling Price - Purchase Price) / Selling Price.

That is your gross margin. Your true margin is lower, and here is what eats into it:

• Expiry losses: 1% to 3% of purchase value annually
• Pilferage and breakage: 0.5% to 1%
• Near-expiry discounts: When you sell products at reduced rates to clear stock
• Credit losses: Customers who buy on credit and never pay
• Scheme products consumed internally: Those "free" strips from buy-10-get-1 schemes that your staff takes home

When you factor all of this in, a pharmacy showing 18% gross margin often has a true margin of 12% to 14%. The analytics dashboard tracks each of these erosion factors, so you know your real profitability — not the number that looks good on paper.

Category-Level Margin Analysis

Break your products into categories and compare true margins:

This table explains why smart pharmacies are expanding their supplements and wellness sections. The margins are significantly higher, the expiry risk is lower, and the customer does not need a prescription to buy.

Setting Up Analytics: What You Need

If You Already Have Billing Software

Most modern pharmacy billing software can export data. The question is whether it has built-in analytics or whether you need a separate tool.

Built-in analytics (preferred): The dashboard is part of your billing software. Data updates in real time. No export-import cycle. You click a tab and see your reports. GoMeds AI Pharmacy Management Software includes a built-in analytics dashboard with all five reports described above, plus customisable views.

Separate analytics tool: You export data from your billing software (usually as CSV or Excel) and import it into an analytics platform. This works but adds a manual step and means your data is always slightly behind.

If You Are Choosing New Software

Make analytics a selection criterion, not an afterthought. During the demo, ask the vendor:

1. "Show me my top 10 products by profit margin, not by sales volume."
2. "Show me a distributor comparison report."
3. "Show me which products are approaching expiry with more than 50% stock remaining."
4. "Can I see sales broken down by hour of day?"
5. "Can I set up an alert when a regular customer misses their expected purchase?"

If the vendor cannot demo these, their software is a billing tool with analytics as a label, not a capability.

The Weekly Analytics Routine

Analytics is useless if you check it once during setup and never again. Here is a weekly routine that takes 30 minutes and drives real decisions:

Monday morning (15 minutes):

• Review last week's total sales and compare to the previous week and same week last year
• Check dead stock report — anything new that has not moved?
• Look at expiry alerts — any products expiring in the next 60 days that need to be pushed?

Friday evening (15 minutes):

• Review the week's top 10 sellers by volume and profit
• Check distributor delivery performance (any late deliveries this week?)
• Look at customer alerts — any regular patients who missed their expected purchase?

That is it. Thirty minutes per week. The insights compound over months. After three months, you will make inventory, pricing, and staffing decisions with a confidence you never had before.

The Bottom Line

Your pharmacy already has the data. Every bill you generate, every purchase you record, every return you process — it is all data. The question is whether that data is working for you or just sitting in a database.

A sales analytics dashboard does not require a data science degree. It requires software that presents your existing data in a way that answers business questions. Which products make money? Which ones waste shelf space? Which distributors deliver on their promises? When do customers buy?

The answers to these questions are already in your billing system. You just need a dashboard that extracts them.

If your current software gives you a sales total and nothing more, you are running your business on one number when you could have a hundred insights. Explore GoMeds AI Pharmacy Software with built-in analytics, or book a demo to see your data the way it should be seen.

---

Deepak Nair is a retail pharmacy business analyst based in Pune who has implemented analytics systems at 50+ independent pharmacies and pharmacy chains across Maharashtra and Karnataka.