NHS PHARMACY · LEARN

Making Formulary Reporting Understandable

Show how many prescription items match an entry on the local formulary. Put the unresolved count beside the percentage. In this example, 90 of 100 items match a listed entry, five are confirmed outside the list and five still need checking.

  
START WITH THE REFERENCE

Give the Team a Clear Starting Point

A pharmacist and a reporting analyst sit down with 100 prescription items from the past month. They’ve been asked for a formulary percentage. Before they calculate it, the pharmacist asks which version of the local list they are using and what the report will do when it can’t find a match.

A formulary brings together medicine choices and guidance on when to use them. Different hospitals or services may use different lists. Put the hospital, month and version at the top of the report, and say that the figures cover prescription items. A report about medicines supplied would describe different work.

Keep the words your pharmacy team uses for its own categories. Kent and Medway, for example, distinguishes preferred choices, later-line choices and medicines that a specialist should start. Those descriptions give a colleague more to work with than “on the list”.

Start with the codes and descriptions in the report the team already uses. The first item that needs a closer look in this example is a liquid medicine with the same name as a listed tablet.

Use words with colour

Show the local classification in text beside any colour. A reader can interpret “specialist initiation” without having to remember what an orange or amber marker means.

  
FOLLOW ONE MEDICINE

Match the Product Before Reading Its Status

Take Medicine Q. The prescribing system calls its tablets Q-T and its liquid Q-L. The analyst can link Q-T to the tablet entry on the local list. They still need the pharmacist to confirm which entry, if any, applies to Q-L.

Two source codes in the worked example
Source medicine What the reporting team knows
Q-T · tablets Verified link to the relevant formulary entry
Q-L · liquid Link still needs checking

Keep the original codes and descriptions beside the proposed matches. The medicine name is a useful clue. To confirm the match, the pharmacist may also need the form, strength or another detail required by the entry.

Until the pharmacist checks the liquid, mark it “match unresolved”. That tells the next reader that the team still has a question about the record. Use “outside the formulary” for a record the team has checked against the chosen list.

What dm+d contributes

The NHS dictionary of medicines and devices, or dm+d, provides product descriptions and codes. Where these are used, the team still needs the relationship to its applicable local formulary entry.

  
READ THE FINDINGS

Keep Different Follow-Ups Visible

The pair apply the agreed mapping to all 100 prescription-item records. Their summary separates four groups. These are reporting labels for this example; a local team would use wording that reflects its own formulary and process.

The example review covers 100 prescription items
Finding and countWhat the team examines next
80 · Listed entry, no additional condition flaggedThe applicable entry and local classification
10 · Listed entry with conditionsThe conditions and the information needed to assess them
5 · Confirmed outside the selected listThe relevant local review or exception information
5 · Mapping unresolvedThe source code and the relationship needing verification

For the ten items with conditions, the pharmacist needs the relevant context before assessing whether those conditions were met. A match to the entry gives the team a starting point for that review. The supporting record should help them locate what is known and what still needs checking.

The five items outside the list have their own route through the local process. Kent and Medway’s guidance recognises circumstances where non-formulary prescribing may be appropriate. A reporting label can therefore help a colleague find the relevant case and information without deciding the clinical question for them.

Q-L remains among the five unresolved records. The analyst has a concrete piece of follow-up work, while the pharmacist can concentrate on the classifications and context that are ready to review. The summary gives mapping work its own place alongside the pharmacy review.

Make follow-up easy

Keep the original source identifier available beside the finding. It gives the pharmacist and analyst a shared reference when they investigate a match or discuss supporting information.

  
EXPLAIN THE SUMMARY

Show the Count Behind the Percentage

The original request was for a formulary percentage. With the groups visible, the team can choose a measure that describes what it actually knows. Ninety of the 100 items have a verified link to a listed entry, including the ten with conditions. They can call that “90% of all items matched to listed entries”.

If they calculate the percentage only among the 95 items with resolved classifications, the result is 90 ÷ 95, or 94.7% rounded to one decimal place. That is a different denominator. Showing “90 of 95 classified items” alongside the five unresolved items makes the calculation explainable.

The team chooses the first measure for its main summary and keeps all four groups underneath. The result describes list matching. A broader compliance measure would need an agreed rule and the information required to assess applicable conditions.

Keep the detail close to the summary

A shared view becomes useful when colleagues need to move from those totals to the medicine records behind them. IntelliFront BI is self-hosted business intelligence software from ChristianSteven Software. Reporting authors can use prepared classifications in native dashboard charts and grid visuals, with suitable filters for the review.

For this team, the useful arrangement is a summary beside records showing the source medicine code, description, matched entry and reporting status. The local authors supply the approved source route, mapping and measure definitions. Self-hosting places the software on infrastructure the organisation controls, giving the team a place to maintain this reporting in its own environment.

NHS Education for Scotland lists an IntelliFront project aimed at improving pharmacy teams’ access to formulary-compliance data. The same practical need applies here: colleagues need access to the supporting records as well as the headline measure.

Comparing two teams?

Agree the formulary scope, item definition, period and treatment of unresolved records before comparing percentages. Similar headings alone do not make two results comparable.

  
KEEP THE REFERENCE CLEAR

Make the Next Review Explainable Too

One of the five unresolved records is the Q-L liquid. Before the next meeting, the pharmacist confirms that it matches a listed liquid entry with no additional condition flagged. The analyst updates the map. The report now shows 91 of 100 items matched to listed entries and four still unresolved. The prescription records stayed the same. The team learned more about one of them.

If the team reopens last month’s report, agree which list it should use. The version in force last month helps explain the original result. Today’s version answers a different question about the same records. Name the version so someone can reproduce the figures later.

Try this with one or two medicines from your own report. See whether a colleague can tell which entry was matched, whether it has conditions and which records still need checking. If the detail answers those questions, the percentage has something solid behind it.

If colleagues need to review the summary alongside its supporting records, see how NHS pharmacy formulary dashboards can bring both views together.

Contributors:

Christian Ofori-Boateng

Christian Ofori-Boateng

CEO, ChristianSteven Software