Why weekly, and why not just revenue
Revenue is a lagging figure. By the time it moves, whatever caused it to move happened weeks earlier, and the decision which would have changed the outcome is no longer available. That is fine for a business whose inputs are stable and unhelpful for a private pharmacy service, where a supplier problem, a prescriber's absence, a marketing campaign or a drifting review interval all show up in the operational numbers long before they reach the accounts.
The case for weekly rather than monthly is narrower than it sounds. Most figures do not need weekly attention, and four kinds do. Anything with a threshold, where crossing a line changes the payment. Anything with an interval, where a fortnight of drift is a fortnight of missed reviews. Anything with a ratio the business depends on, comprising disputes and chargebacks. And anything clinical, where the cost of not knowing is measured in patients rather than pounds.
Every one of those is ultimately an input to the figure an owner is judged on, since retention, refusal quality, service level and dispute ratios all resolve eventually into earnings. The weekly page holds the leading indicators and the monthly page holds the result, which is the subject of a later section.
An hour, one page, the same time each week, with the superintendent present. That last condition is the one most often dropped and the one which makes the exercise worth doing, since it is the point at which the commercial and clinical views of the same business meet.
The ten numbers to see every week
| Figure | What it tells you | What a bad reading looks like |
|---|---|---|
| New patients started | Whether acquisition is working | Falling whilst spend is flat |
| Conversion by funnel stage | Where people are dropping out | A single stage worsening, which is usually a defect rather than demand |
| Refusal rate | Whether the assessment is genuine | Approaching zero, or falling as marketing rises |
| Reviews due and overdue | Whether intervals are being met | Overdue growing week on week |
| Retention position | Whether the service is worth having | Month three attrition rising in successive cohorts |
| Dispatch against service level | Whether the promise is being kept | Any slippage, since patients experience this directly |
| Disputes and chargebacks | The ratio the payment relationship depends on | Any upward trend, well before a threshold is approached |
| Incidents and near misses | Whether the clinical process is holding | Zero, which usually means under-reporting rather than perfection |
| Pharmacy First month-to-date | Position against the payment thresholds | Sitting at 17 or 27 on the final Monday |
| Cash collected against expected | Whether billing is actually working | A widening gap, which is usually failed recurring payments |
Two readings in that table are counterintuitive and both are deliberate. A refusal rate approaching zero is a warning rather than an achievement, and zero incidents almost always indicates that near misses are not being captured rather than that none occurred. A reporting page which treats both as good news is measuring the wrong thing.
Why refusals and overdue reviews sit beside revenue
Services almost universally separate their commercial reporting from their clinical reporting, on the reasonable-sounding basis that different people are responsible for each. The consequence is that the single most important pattern in private pharmacy becomes invisible, because it only exists in the relationship between the two. A week in which new patients rise, refusal rate falls and overdue reviews grow is not three separate items for three separate meetings. It is one thing happening, being a service taking on more than its clinical capacity can carry, and every element of it looks acceptable in isolation. The commercial report shows growth. The clinical report shows a manageable backlog. Only the combined page shows a service which is converting more people by assessing them less carefully and reviewing them later, which is the failure mode regulators have described in this sector and which the operators concerned did not see coming. Putting the quality lines and the revenue lines on one page costs nothing and is the entire reason the weekly hour exists.
The month-to-date numbers worth acting on
Two figures behave differently from the rest because they are step functions rather than trends, and both reward being known before the month ends.
Pharmacy First clinical pathways count. The fixed payments are awarded at thresholds rather than accrued across them, so as the Pharmacy First analysis sets out, the twentieth consultation of a month is worth approximately five hundred pounds more than the nineteenth, and the thirtieth approximately five hundred more than the twenty-ninth. A count seen on the final Monday can still be acted on. The same count seen in the following month's payment statement cannot.
Position against the monthly cap. The same service pays nothing beyond the cap, so a pharmacy at its ceiling should be redirecting capacity rather than continuing, and knowing which side of that line it sits on is the difference between capacity well spent and capacity donated.
The gateway requirements belong on the same line, since the minimum ambulatory blood pressure and contraception activity guard a payment of up to a thousand pounds and are the easiest things in the month to forget. A single missed monitoring can forfeit the whole fixed payment, which makes it the highest-return item on the page.
What to review monthly rather than weekly
Four things change too slowly to reward weekly attention and matter too much to leave to quarterly.
Retention curves by cohort, since the meaningful comparison is between patients who started in different months, and that needs months to mean anything.
Acquisition cost against modelled lifetime value, split between owned and paid demand, which is the figure that decides whether growth is worth buying.
Review texture, meaning what patients actually mention unprompted, which is the promises audit conducted by strangers.
EBITDA on a rolling twelve months, adjusted as a buyer would adjust it, which the following section addresses in its own right.
The service review itself, comprising the risk assessment and procedures which the regulator's April 2026 themed review asks to be robust and regularly reviewed. Treating that as a scheduled monthly item rather than an annual event is the difference between governance and paperwork.
EBITDA, and why it belongs on the monthly page
EBITDA, being earnings before interest, tax, depreciation and amortisation, is the closest single figure to what a pharmacy business actually generates from operating, stripped of how it is financed and how its assets are written down. It matters to an owner for one reason above all others, which is that a buyer values the business as a multiple of it.
The EBITDA in a set of statutory accounts is rarely the EBITDA a purchaser will pay a multiple of, because a buyer normalises it before applying anything. They add back genuinely non-recurring costs. They remove benefits which will not continue after completion. They substitute a market rate for the owner's own remuneration where the owner has been paying themselves below or above one. And they discount income streams whose durability they doubt, treating stable NHS volume differently from private revenue which grew through a promotion. An owner who tracks only the accounting figure learns the adjusted one during a negotiation, from the other side, at the point when it is too late to influence any of the inputs. An owner who calculates it monthly the way a buyer would has a realistic view of what the business is worth for years before they need it, and knows which adjustments are still fixable. As the exit guide sets out, the factors which move that figure are operational and take one to three years to change, which is precisely why it belongs on a monthly report rather than in a conversation with a broker.
Three practical points make the monthly figure useful rather than decorative.
Use a rolling twelve months, not a single month. Pharmacy revenue is seasonal, with travel health, vaccination and weight management all running to their own rhythms, and a single month tells you about the month. A rolling twelve-month EBITDA reveals the trend, which is the thing a valuation is actually about.
Split it by service line where you can. A group figure conceals which services earn and which occupy. A private vertical which contributes revenue and consumes disproportionate prescriber and consultation capacity may be contributing very little once its costs are attributed honestly, and that is a decision an owner should make deliberately rather than discover.
For groups, calculate it per branch. Sites diverge, and an average across a group hides both the branch subsidising the others and the one being subsidised.
One honest caution belongs alongside it, and it is the reason EBITDA sits on the monthly page rather than replacing anything on the weekly one. EBITDA ignores working capital and capital expenditure, and for a dispensing business those are precisely where cash disappears. Stock is substantial, price concessions move purchasing costs before reimbursement catches up as the concessions guide describes, and a business can show a healthy EBITDA whilst being genuinely short of cash. That is why cash collected against expected stays on the weekly page. EBITDA tells an owner what the business is worth, and the weekly figures tell them whether it will still be there in March.
Where these come from in Dataforge PMR
Most of the ten come from the same underlying record rather than from a separate analytics layer, which is the practical benefit of the single patient journey described in the patient data capture guide.
Bookings and consultations produce the funnel and new-start figures. Clinical decisions, with refusals recorded as first-class outcomes rather than absences, produce the refusal rate. Recalls produce due and overdue, as the recalls article describes. Dispensing and dispatch produce service level performance. And the patient record produces retention, because retention is a question about the same people over time rather than about transactions.
Two figures ordinarily sit outside a PMR and should be brought onto the same page manually rather than left in another system. Disputes and chargebacks live with the payment provider, and cash collected against expected is a billing reconciliation. Both matter enough to justify the two minutes of copying.
When to export instead of report
Standing reports answer standing questions well and novel ones badly, which is the moment to export instead.
Four situations call for it. Cohort analysis, where the question involves a group defined by something the report does not filter on. Audit sampling, where a defined set of records must be produced in full. Cross-referencing, where the answer requires joining the pharmacy's data to something external. And anything needing values as a series, comprising response curves and interval compliance, which requires the entry-level export rather than the patient-level one, per the export guide.
The discipline is to treat the export as the analysis tool and the report as the monitoring tool, rather than expecting either to do the other's job.
Turning a dashboard into a decision
A report which is read and not acted on is worse than no report, because it produces the feeling of oversight without its substance. Four habits close that gap.
Same hour, same page, same attendees, with the superintendent present, because a fixed slot survives a busy week and an unscheduled review does not.
One owner per line. Every figure has a named person who explains it when it moves, which is what converts a number into accountability.
Write the decision, not the number. The output of the hour should be what will be done differently, recorded, with the number as evidence rather than as the conclusion.
Compare against last week and against the same week last quarter. The first catches events and the second catches drift, and drift is the one that ends services.
Reporting mistakes worth avoiding
Too many metrics. A page of forty figures is a page nobody reads. Ten that get acted on beat forty that get scrolled.
Averages hiding distributions. An average dispatch time of one day can contain a tail of patients waiting a week, and it is the tail that complains and reviews.
Reporting what is easy to count. Page views are easy and consultations are meaningful, and services drift toward the first because the number is always available.
No denominators. Twelve refusals means nothing without knowing whether it was out of twenty or two hundred, and rates rather than counts should be the default on every quality line.
Key takeaways
- Revenue is a lagging figure, so the weekly page should carry anything with a threshold, an interval, a ratio the business depends on, or a clinical consequence.
- Ten figures earn a weekly hour, and two readings are counterintuitive, since a refusal rate approaching zero is a warning and zero incidents usually means under-reporting.
- Quality lines belong beside revenue, because rising starts, falling refusals and growing overdue reviews are one pattern which is invisible when reported separately.
- Month-to-date Pharmacy First position is a pricing input rather than a statistic, since the twentieth and thirtieth consultations are each worth roughly five hundred pounds.
- Review retention curves, acquisition cost against lifetime value, review texture and the service review monthly rather than weekly.
- Track EBITDA monthly on a rolling twelve months, adjusted the way a buyer would adjust it, split by service line and by branch, since it is the figure a business is valued on.
- EBITDA ignores working capital and capital expenditure, which is where a dispensing business actually loses cash, so cash collected against expected stays on the weekly page.
- Use reports for monitoring and exports for analysis, and bring disputes and cash collected onto the same page even though they live elsewhere.
- Give every line one owner, write the decision rather than the number, and compare against both last week and the same week last quarter.
FAQs
The numbers, on one page.
Most of these figures already exist in your patient record and nobody has put them together. See it working, then bring us your own case and we will build your weekly page against a live service, quality lines and revenue side by side.
See Dataforge PMR