Outstanding treatment
792 plans worth £1.2m, diagnosed and not booked · sorted by clinical consequence, not by value
Outstanding
£1.2m
792 plans, average £1,515
Never contacted again
578
73% of them
Clinically active
184
A problem that will get worse
Realistically recoverable
£312k
At Bramfield's own conversion by age
£1.2m is the headline and £312k is the honest number. Applying the practice's own conversion rates by age — 41% under thirty days, 2% past six months — is what the pot is actually worth if somebody works it properly from tomorrow. Quoting the £1.2m to a principal is how software gets sold; quoting the £312k is how it gets kept.
Why plans stall
Reason recorded, or inferred where none was
| Reason | Plans | Value | Followed up |
|---|---|---|---|
| No reason recorded | 412 | £618,000 | 44 |
| Cost | 174 | £348,000 | 88 |
| Wants to think about it | 98 | £132,000 | 41 |
| Timing | 64 | £68,000 | 32 |
| Anxiety | 44 | £34,000 | 9 |
More than half have no reason at all. That is not a patient problem — a plan should not be closeable, or leaveable, without one.
Anxiety is the one to fix first
Smallest pot, worst outcomes, easiest answer
Plans stalled by anxiety44
Offered sedation9 of 44
Offered a longer, slower appointment3 of 44
Of those 44, clinically active21
Average time since presented147 days
Twenty-one anxious patients have an active problem and have been left for five months. These are the patients who eventually arrive in pain, out of hours, needing an extraction rather than the restoration they were offered. It is the worst outcome in the whole list and the cheapest to prevent.
A flag that says "anxious" is not enough. What changes the outcome is a flag that books differently — first appointment of the day, double the time, sedation offered by default, and the same clinician every visit.
Plans to work this week
Clinically active first, then by how much conversion is left in them
| Patient | Treatment | Clinician | Value | Age | Reason | Converts | Status |
|---|---|---|---|---|---|---|---|
| M. Fairbrother | Extraction & implant | Dr Vane | £4,850 | 34 d | Cost | 18% | Active infection |
| J. Okereke | Extraction & bridge | Dr Mehta | £3,200 | 51 d | None recorded | 18% | Unrestorable |
| H. Beswick | Root canal & crown | Dr Reith | £1,680 | 163 d | Anxiety | 7% | Active, 5 months |
| P. Lindqvist | Periodontal therapy | F. Llewellyn | £980 | 88 d | Timing | 18% | Progressing |
| S. Ahmadi | Clear aligners | Dr Reith | £4,200 | 22 d | None recorded | 41% | Never contacted |
| R. Castellano | Composite bonding | Dr Sandhu | £2,400 | 14 d | Wants to think | 41% | Call due today |
| V. Okafor | Aesthetics course, 3 sessions | R. Bellini | £980 | 9 d | None recorded | 41% | Call due today |
| G. Farrant | Two extractions, sedation | Dr Mehta | £1,340 | 201 d | Anxiety | 2% | Offer sedation |
| K. Nwosu | Whitening & veneers | Dr Sandhu | £5,600 | 119 d | Cost | 7% | Elective |
| T. Underhill | Denture replacement | Dr Mehta | £1,850 | 242 d | None recorded | 2% | Likely gone |
The four at the top are not revenue opportunities. They are patients with a diagnosed problem that is deteriorating, and the practice has a clinical duty to have tried.