TL;DR: A multi-practitioner physio clinic in Edinburgh was tracking referrals in a colour-coded spreadsheet that the practice manager updated on Fridays. Referrals arrived through three channels: email, NHS SCI Gateway, and fax. Three of fourteen January referrals were never entered. One patient waited six weeks before her GP rang asking for an update. We built a five-stage referral tracking agent that captures every referral the moment it arrives, triages by urgency, assigns to the right practitioner, tracks milestones through to discharge, and auto-generates NHS Scotland reports. Lost referrals dropped to zero. Time from referral to first appointment: 8.2 days down to 3.1. Fiona's admin time: 10+ hours per week down to 2. The referring GP surgery increased referrals by 15%. Agent cost: £140/month.
The Call from Leith
February. A GP surgery in Leith rings the clinic. "We referred a patient to you six weeks ago. Mrs Campbell. Knee pain, post-surgical rehab. Can you give us an update?"
Fiona, the practice manager, checks the spreadsheet. Mrs Campbell isn't on it.
She checks the email inbox. There it is. A referral letter from January 8th. Read. Never entered into the spreadsheet. Never triaged. Never assigned to a practitioner. Never booked.
Mrs Campbell had been waiting six weeks for an appointment that was never made.
Fiona's stomach dropped. Not because this was unusual. Because she knew there were probably more.
She went through January's referrals against the spreadsheet. Fourteen received across all channels. Eleven entered. Three missing.
Three patients. Waiting for a clinic that didn't know they existed.
The GP on the phone was polite about it. But Fiona could hear the note underneath. This surgery accounted for 40% of the clinic's NHS referrals. One lost patient is an oversight. Three in one month starts to look like a pattern.
"I'll get Mrs Campbell booked in today," Fiona said. And she did. But the question she couldn't shake was how many other months had looked like January without anyone noticing.
The Clinic
Multi-practitioner physiotherapy practice in Edinburgh, Scotland. Four physios, Fiona as practice manager, and one receptionist. A mix of NHS-referred patients and private self-referrals. Thirty to forty new referrals per month.
Referrals arrive through three channels. Email from GP surgeries. The NHS SCI Gateway system for electronic referrals. And occasional fax, because some surgeries in the Lothians haven't fully transitioned to digital. Three channels, one person responsible for checking all of them.
Fiona's job title is practice manager. Her actual job is everything that isn't treating patients. Referral intake, scheduling, billing, NHS reporting, practitioner rotas, reception cover, supplier orders, insurance queries. Roughly 15 distinct responsibilities. Referral tracking is one of them.
Her tracking system: a colour-coded spreadsheet she updates on Fridays. Green for booked, yellow for pending, red for overdue. Monday to Thursday, she's doing the other 14 jobs. By Friday, some referrals are a week old before they're entered. Some, as January showed, don't get entered at all.
The revenue maths: each missed referral represents £60 to £120 per session across an average course of six to twelve sessions. That's £360 to £1,440 per patient. Three lost patients in January alone was somewhere between £1,080 and £4,320 in revenue that simply vanished. Not because anyone said no. Because nobody said anything at all.
And then there's NHS Scotland reporting. Monthly data submissions on referral-to-treatment times, waiting list statistics, patient outcomes. Fiona compiles these manually, cross-referencing the spreadsheet with the appointment system. Two-plus hours every month, and she knows the numbers are only as good as the spreadsheet.
Why Nothing Had Worked
The spreadsheet was well-designed. Colour-coded, structured, clear. The problem wasn't the spreadsheet. It was that it only reflected reality when Fiona had time to update it. A tracking system that's current four days out of seven isn't a tracking system. It's a historical record with a lag.
Their practice management software handled appointments and billing but had no referral pipeline tracking. It knew Mrs Campbell existed once she had an appointment. It had no idea she existed between the referral arriving and someone booking her in. Upgrading to a system with pipeline tracking meant £400-plus per month and a data migration nobody could face during busy periods.
Fiona created a "Referrals" folder in the shared email inbox. But referrals arrived mixed with appointment queries, patient communications, and supplier emails. The January email about Mrs Campbell had the subject line "Patient Correspondence — Dr Murray." Not "Referral." It got read and lost.
NHS SCI Gateway covered electronic referrals, but only a portion of the clinic's intake came through it. Some GPs still emailed. A few still faxed. And the Gateway tracked whether the referral was sent, not whether the clinic acted on it.
Every fix depended on Fiona having time she didn't have.
The design is next. The design, the build guide, the running costs and the take-away are free to subscribers. Enter your email below and the rest of this Blueprint opens. New ones arrive every Tuesday and Friday.
