Key Takeaways

  • Secondary sales reporting is the weekly record of what stockists and distributors sell on to pharmacies, hospitals and retailers, broken down by area, rep, pharmacy and product.
  • You can read the whole report with four questions: are we behind target, is stock building up, which pharmacies stopped ordering, and can we trust the numbers.
  • Stock at a stockist follows one rule: opening stock plus what you shipped, minus what they sold on, equals closing stock.
  • Most errors come from units counted differently, the same sale entered twice and figures that change after review.
  • Review the report on the same day each week with the same numbers, and lock the week once it has been checked.

Why Most Teams Have Numbers but No Report

Most pharma teams collect secondary sales figures. Far fewer have a report that someone reads every week and acts on. The numbers end up in a stockist’s statement, a rep’s message and a sheet that only one person understands, and by the time they are pulled together the month is almost over.

This article covers the report itself: how to set it up, how to read it and how to review it without losing half a day.

What Secondary Sales Reporting Means

Secondary sales reporting is the regular record of what stockists and distributors sell on to pharmacies, hospitals and other retailers, split by area, rep, pharmacy and product. If you want the basics first, we explain the definitions and what a report line holds in primary vs secondary sales in pharma.

In short, primary sales are what you ship to stockists, secondary sales are what the stockists sell on, and reporting lets you look at both together.

What the Weekly Report Looks Like

Keep the top short. A summary by area is usually enough, with the detail underneath. Here is an example (the numbers are invented):

AreaTarget (units)Sold (units)AchievementLast week
North1,00082082%79%
Central80079099%95%
South60041068%71%

South is behind and slipping, so that is where the review starts. Each line should open up into the pharmacies and products behind it.

Reading It With Four Questions

Start with the target. Look at achievement by area and by rep, then check which products are pulling it down.

Next, check whether stock is building up. Compare primary with secondary for each stockist, using one rule: opening stock plus primary purchases, minus secondary sales, equals closing stock. Say a stockist opened the month with 500 boxes, bought 800 from you and sold on 450. That leaves 850 boxes. At 450 a month, that is about eight weeks of stock on the shelf (again, invented numbers). How many weeks is too many is something you have to decide for your own team.

Then look at the pharmacies. List the ones that bought last month and have ordered nothing this week. A phone call now is easier than winning the pharmacy back later.

The last question is whether you can trust the numbers, and that is what the next section is about.

Where Reports Go Wrong

Most mistakes are small and repeat every month:

  • Units do not match. A carton of 24 strips counted as one unit in one report and as 24 in another throws off every total.
  • The same sale gets entered twice, once by the rep and once from the stockist’s statement.
  • Figures change after review. Monday’s number is different by Thursday and nobody knows why.
  • A stockist’s statement arrives late, so an area looks weak when it is only incomplete.
  • Product names differ between stockists, so one medicine shows up as two lines.

What helps is boring but works: agree on one unit, give each source of figures one owner, and lock the week once it has been checked.

A Weekly Routine That Works

Pick one day and one hour. Look at the same four things every time: achievement against target, stock against sales, pharmacies that stopped ordering, and anything that looks odd. Write down two or three actions with a name beside each, and check them at the next review.

Look at visits too. If a pharmacy’s sales fall while reps keep visiting, that is a different conversation from one where the visits stopped. A daily call report gives you the visit side of the story.

How RxRep Handles Secondary Sales Reporting

RxRep records sales against each pharmacy and product by week, in units and value, entered by the rep or by the manager who has the figures. Totals roll up by rep, area and product and appear beside targets, and a week can be locked once it has been checked. Distributor stock and statements can be kept alongside the sales, so you can review a stockist next to the field results in the same area.

Reports export to Excel or PDF for use in your own tools. RxRep does not have ready-made connectors to ERP systems, so if you need one, speak to the team before you decide. You can try every module free for 7 days with up to 3 users, no card needed.

What to Ask Before You Choose Software

A spreadsheet works for a while. It stops working when several people enter figures, when you need totals by area and product, or when you want to compare sales with targets without rebuilding the file each week. At that point, ask:

  • Can I see a real report, not just a dashboard screenshot?
  • Does it record sales by pharmacy, product and week, in both units and value?
  • Can I lock a week once it is checked?
  • Can I export the report to Excel or PDF?
  • Does it connect to my ERP system, and if not, how will I move the data?

Frequently Asked Questions

What is secondary sales reporting in pharma?

It is the regular report of what stockists and distributors sell on to pharmacies, hospitals and retailers, by area, rep, pharmacy and product.

How often should I review it?

Weekly works well, because a bad week shows up before the month ends.

Who should enter the figures?

Choose one owner for each source, either the rep who visits the pharmacy or the manager who receives the stockist’s data, and keep it that way.

Why do primary and secondary sales differ?

Primary sales are what you ship to stockists. Secondary sales are what they sell on. Stock that has been shipped but not yet sold sits in the gap.

Does RxRep connect to ERP systems?

Not through ready-made connectors. Reports export to Excel or PDF, and you can discuss other needs with the RxRep team.