How to Read Your Pharmacy's Sales Reports Like an Expert
Quick Answer
To read your pharmacy's sales reports like an expert, stop at total sales last rather than first. Five things carry almost all the signal, and none of them is the day's collection figure.
- Gross margin by product and category: Which lines actually earn, as opposed to which ones move.
- Sales trend on a like-for-like comparison: This Monday against last Monday, not against yesterday.
- Inventory turnover and stock movement: How fast your money converts back into money.
- Near-expiry and slow-moving stock: Losses that have already happened but have not yet been booked.
- Customer and credit patterns: Who comes back, who owes you, and for how long.
Compared week on week and month on month, those five show you which medicines make you money, which ones are quietly holding your cash, and where profit is leaking without ever appearing as a line item called "loss".
Why Total Collection Is the Least Useful Number You Have
Most pharmacy owners in India check exactly one number at close of day: what came into the drawer. It is the easiest number to get and the hardest to act on, because it answers a question nobody needed answered — how busy were we — while staying silent on the one that matters.
A medical store can bill ₹50,000 in a day and still go backwards. Thin margins on a shifted product mix, a batch quietly ageing toward expiry, discounts given at the counter that nobody logged, and credit customers who will not pay for another forty days all sit underneath that collection figure without disturbing it. Sales reports exist to turn billing data into decisions: what to stock, what to reorder, what to discount, and what to stop buying altogether.
Profit is an opinion until the margin report agrees with it
Collection is cash that arrived today, some of which you already owe your distributor for stock you bought last month. The two numbers can move in opposite directions for a full quarter before anyone notices.
The Eight Reports That Actually Matter
1. Daily and Monthly Sales Summary
Your starting point: total sales, bill count, the split across cash, UPI and credit, returns, and discounts given. It is the only report on this list you should open every single day.
What to look at: compare today with the same weekday last week rather than with yesterday. A Monday and a Saturday are different businesses, and comparing them manufactures alarm or comfort that is not real. Then watch bill count and average bill value as a pair — if bills hold steady while average bill value falls, customers are buying one item from you and the rest of the basket somewhere else, which is a very different problem from losing footfall.
2. Product-Wise Sales Report
Every product sold, with quantity and value against it. Sort it twice — once by value and once by quantity — because the two lists answer different questions and the gap between them is where the interesting items live.
The familiar rule of thumb is that 20% of products bring 80% of revenue. Directionally that holds, but measured data is usually a little flatter: in a published analysis of 4,581 drug items, 22% of items accounted for about 70% of the money. Either way the instruction is the same — the short list at the top should never go out of stock, and you should know it by name. Meanwhile a product selling in high quantity at low value may still earn its shelf space by bringing people through the door for everything else.
3. Profit and Margin Report
The report most owners skip, and the one that changes the most decisions. Read gross margin three ways: by product, by category (ethical, generic, OTC, FMCG, surgical) and by company.
What to look at: the direction of overall margin percentage against the direction of sales. If sales are rising while margin percentage falls, your mix is drifting toward low-margin lines and the extra revenue is buying you less than it looks like. Generics, OTC and surgical typically carry materially better margins than branded ethical medicines, which is why category-level margin is more actionable than a single blended number.
4. Inventory Turnover and Stock Movement
Inventory turnover is cost of goods sold ÷ average inventory value, and it tells you how many times a year your stock converts back into cash. Stock movement is the same question asked SKU by SKU.
What to look at: your own twelve-month trend, before anyone else's benchmark. There is no published India-specific turnover benchmark for retail pharmacy, and borrowing a foreign average as a target is how stores end up under-stocking their best sellers. Use the report to split the catalogue three ways — fast movers to reorder more often, slow movers to buy in smaller lots, and items with no sale at all — and act on the split rather than on the ratio.
"No sale in 60 to 90 days" is a flag, not a verdict
A quarter of no movement tells you to look; it does not by itself make an item dead stock. The test that settles it is arithmetic: at its recent sales rate, can the quantity on your shelf clear before that batch expires? If it cannot, the difference is dead regardless of how recently it last sold — and if it can, you have a slow mover to manage, not a loss to book.
That distinction matters because the two need opposite responses. A slow mover gets a smaller reorder quantity and a nudge; genuine dead stock gets returned, transferred or liquidated now, because its value only falls from here.
5. Near-Expiry and Expiry Report
In a pharmacy, expired stock is not a markdown — it is a write-off plus a disposal obligation. This report is the cheapest insurance you have against both.
What to look at: everything expiring in the next 30, 60 and 90 days, reviewed weekly rather than monthly. At 90 days out you can still move stock to the front shelf, return it inside the supplier's window, or transfer it to a branch that will sell it. At 30 days out most of those options have quietly closed. Pair it with FEFO — First Expired, First Out — at the counter, because the batch that arrived most recently is frequently not the one that expires last.
6. Purchase vs Sales Report
What you bought set against what you sold, per product. It is the report that catches overstocking while it is still reversible.
What to look at: any product where purchases have exceeded sales for two or three periods running. That is a reorder level set too high, or a distributor scheme you accepted without doing the arithmetic. Bulk offers only pay if the stock clears before expiry — a 10% scheme discount is wiped out entirely by one expired batch, and the capital was parked the whole time it was waiting.
7. Customer and Credit Report
Repeat customers, chronic-medicine buyers, and what is outstanding against whom. Patients on monthly refills for diabetes, blood pressure or thyroid conditions are the most predictable revenue a pharmacy has, and the easiest to lose quietly.
What to look at: refill due dates, so a reminder goes out before the patient runs out and buys elsewhere. Then credit ageing in buckets — 0-15, 16-30, 31-60 and 60-plus days — rather than as a single outstanding figure. A total tells you how much; the buckets tell you which of it is still likely to arrive.
8. GST and Tax Report
This is where a stale rate master shows up, and a year on from the change it is still one of the commonest billing errors in Indian pharmacies. Since 22 September 2025 the slab structure is 5%, 18% and a 40% de-merit rate — the 12% slab was abolished. Most medicines now sit at 5%, 33 lifesaving drugs moved to nil, and 3 further drugs used in cancer, rare diseases and severe chronic conditions moved from 5% to nil.
What to look at: whether the HSN code and rate on each product are actually right, because errors here surface at filing time rather than at billing time. Note also the reporting requirement attached to your size — businesses with aggregate annual turnover above ₹5 crore must report 6-digit HSN codes in Table 12 of GSTR-1, and those at or below it report 4 digits.
Rates and reporting thresholds change. Confirm your own position with a qualified chartered accountant before relying on it at filing time.
The KPIs Worth Tracking, and How Often
| KPI | What it tells you | How often |
|---|---|---|
| Total sales | Business volume, and nothing else | Daily |
| Average bill value | What each customer spends per visit | Weekly |
| Gross margin % | Real profitability behind the volume | Weekly |
| Near-expiry value | Losses that have happened but are not yet booked | Weekly |
| Credit outstanding, by age bucket | How much of your cash is sitting with customers | Weekly |
| Inventory turnover | How fast stock converts back into cash | Monthly |
| Dead stock value | Money that cannot clear before it expires | Monthly |
| Repeat customer rate | Whether your chronic patients are still yours | Monthly |
Targets for several of these are worth setting deliberately rather than borrowing, and a few — turnover especially — have no credible Indian benchmark to borrow in the first place. The companion piece works through sensible target ranges and the ones you should refuse to copy.
Reading the Patterns, Not the Numbers
Experienced owners are not doing harder arithmetic than you are. They are reading two reports against each other and noticing when the pair stops making sense. These are the disagreements worth knowing by sight.
- Sales up, profit flat: Almost always discounting that nobody is tracking, or a mix that has drifted toward low-margin brands. Check discount given as a percentage of sales before you check anything else.
- Repeated stock-outs of your top sellers: A reordering problem, not a demand problem. The demand was visible in the product-wise report the whole time; the reorder level was not set against it.
- Returns climbing: Either billing errors at the counter or a quality complaint concentrating on one batch or one company. The product-wise return split tells you which within a minute.
- A regular customer's purchases falling away: Chronic patients do not taper — they switch. A refill that is two weeks late usually means an online pharmacy or the shop down the road, and it is far cheaper to win back in week two than in month three.
- Physical stock not matching system stock: Billing mistakes, leakage or theft, in that order of likelihood. It calls for a stock audit rather than an adjustment entry — an adjustment hides the number that was about to tell you something.
A 20-Minute Weekly Routine
You do not need to be an accountant to use this data well. You need a fixed slot and the same sequence every week, so that the comparison is like-for-like and a drift shows up as a drift rather than as a surprise.
- 1
Monday: last week against the week before
Sales summary, bill count and average bill value. Same weekday against same weekday. Five minutes, and it sets the context for everything else you look at.
- 2
Midweek: the near-expiry report
Everything inside 90 days. Decide the action now — front shelf, supplier return, or branch transfer — because all three get harder every week you defer them.
- 3
Before you place an order: stock movement
Check what actually moved before you commit money. This is the single step that stops a distributor scheme from becoming next quarter's dead stock.
- 4
Friday: credit outstanding by age
Work the 31-60 and 60-plus buckets specifically. Anything older than 30 days is already affecting your ability to pay your own distributor.
- 5
Month-end: margin, turnover and dead stock
The three that need a full month of data to mean anything. This is also the right moment to re-check category mix, because that is what quietly moves your blended margin.
Where Software Actually Helps
None of this is analytically difficult. It fails for a much more boring reason: pulling it out of registers or a spreadsheet takes hours that a working counter does not have, and by the time the numbers are assembled they describe a month you can no longer change.
BitMed's pharmacy management software builds several of these out of the bills and purchase entries you are already making — a product- and category-wise sales report, a profit and loss view with gross margin for any period, near-expiry stock grouped into 30-, 60- and 90-day buckets, demand analytics that flag low-cover and no-sale stock, receivables showing each credit customer's oldest unpaid bill, and GSTR-1 and GSTR-3B reports. The point is not the reports. It is spending the twenty minutes acting on them instead of assembling them.
Frequently Asked Questions
What is a pharmacy sales report?
A summary of everything sold over a period — quantities, revenue, discounts, returns, taxes and payment modes. Read on its own it describes what happened; read against your purchase, stock and credit reports it tells you what to do next, which is the whole point of generating it.
How often should I check my pharmacy sales reports?
Daily for the sales summary. Weekly for near-expiry, credit ageing, margin percentage and average bill value. Monthly for inventory turnover, dead stock value and repeat customer rate — those three need a full month of data before the movement means anything.
What is a good profit margin for a pharmacy in India?
It depends almost entirely on product mix, which is why a single blended number is the least useful way to look at it. Branded ethical medicines sit lowest, while generics, OTC and surgical carry materially more. Tracking margin by category tells you something you can act on; tracking one overall percentage mostly tells you that your mix changed.
What is inventory turnover in a pharmacy?
Cost of goods sold divided by average inventory value — how many times a year your stock sells and is replaced. Higher generally means less cash trapped on the racks, but there is no published India-specific benchmark for retail pharmacy, so your own twelve-month trend is a far safer guide than any borrowed target.
How do I spot dead stock in a sales report?
No sale in 60 to 90 days is the flag that tells you to look. What settles it is whether the quantity on the shelf can clear before that batch expires at its recent rate of sale — if it cannot, the excess is dead whatever the report says about recent movement.
How can I reduce expiry losses in my pharmacy?
Review near-expiry stock weekly rather than monthly, dispense by FEFO so the shortest-dated batch goes first, return eligible stock inside the supplier's window, and stop bulk-buying slow movers on scheme. The weekly review is the one that does most of the work, because it is what keeps your options open.
Which GST slabs apply to medicines now?
Since 22 September 2025 most medicines are taxed at 5%, with 33 lifesaving drugs at nil and 3 further drugs used in cancer, rare diseases and severe chronic conditions moved from 5% to nil. The 12% slab was abolished in the same reform, so any rate master still carrying 12% on medicines is out of date.
Which software is best for pharmacy sales reports in India?
Look for product- and category-wise sales reports, a profit and loss view with gross margin, near-expiry stock grouped by how soon it expires, reports that flag slow-moving and no-sale stock, customer receivables, and GST-ready summaries — and check that the reports come out of your billing data rather than needing separate entry, because a report you have to assemble is a report you will stop running.
Your sales reports already hold the answers to most of the questions you are asking about the business: what to stock, what to drop, where profit leaks, and which customers need a phone call this week. Reading them like an expert means looking past total sales at margin, stock movement, expiry and customer patterns — and then doing it again next week, in the same order, so that the comparison is worth something.
Spend the twenty minutes acting, not assembling
Gross margin, near-expiry stock, stock movement, customer receivables and GST reports generated from the bills you are already writing. Start your 30-day free trial — no credit card required.
Explore BitMed