Spreadsheet vs Software: When to Upgrade Your Referral Tracking

Most specialist practices track referrals in a spreadsheet before they track them anywhere else. It’s familiar, it’s free, and on the quiet afternoon you set it up, it genuinely works.

This isn’t a post arguing that spreadsheets are terrible. It’s about the point where the spreadsheet stops helping and starts creating its own problems. Practice managers usually recognise that point when they hit it.

Why spreadsheets work at first

Give credit where it’s due. A well-structured sheet is flexible: a new column costs you a header, not a support ticket. It’s familiar, so there’s no training period and your receptionist can update it on day one. And it’s free, which is hard to argue with when nothing is obviously broken.

If one person manages the whole referral list at a volume they can hold in their head, a spreadsheet is genuinely fine. Our referral tracking guide sets out the five lifecycle stages worth tracking, and a sheet can carry all five at low volume.

The five signs you’ve outgrown it

The shift from “this works” to “this is a problem” happens gradually. You don’t wake up one morning and decide the spreadsheet is broken. You notice small failures that turn into patterns.

Two of those deserve labouring. The first is trust: once a shared sheet has been overwritten or re-sorted a few times, staff start keeping a private copy or working from memory, and the official tracker quietly becomes decoration. The second is the missing row. A referral that was never entered leaves no trace to find later. You can’t audit for the absence of something, which is exactly how a referral quietly disappears without anyone being at fault.

What no amount of formatting fixes

Some limits are structural rather than a question of discipline.

Nothing reaches out on its own. A sheet can’t message a patient when their referral arrives, or nudge one who hasn’t booked. Every contact is a person remembering to make it. If you want to see what good patient contact looks like, our SMS templates for appointments are a reasonable starting point regardless of what you track in.

It shows the past, not the present. A spreadsheet tells you what was true when someone last saved it. A live queue tells you what’s true now: every referral, every status, every person’s workload.

There’s no meaningful audit trail. When something goes wrong, you need to know who changed what and when. A cell simply holds a different value than it used to.

Trends stay hidden. Referral volume drifting down, a referrer who has gone quiet, one doctor’s time-to-appointment stretching: these are patterns across months, not facts in a row. They’re the same numbers covered in our guide to referral KPIs, and they only surface if something is calculating them for you.

Stay, or move?

If you’re in the left column, tighten the sheet rather than replace it. The five-stage structure in our tracking guide works perfectly well in Excel.

If you’re in the right, the arithmetic usually settles it. A systematic review in the Journal of General Internal Medicine found only 35% of specialty referrals result in a documented visit. Not all of that gap is administrative, but the administrative part is the part you control, and it has a dollar value. Work out yours with the referral leakage calculator, or read what one lost referral actually costs.

One question worth settling first: whether your practice management system already covers this. It usually records that a referral exists without telling you what’s stalled, which is a different job. We’ve set out the distinction in PMS vs dedicated referral management.

Making the move

The transition is less dramatic than it sounds, because the concepts don’t change. SimpleRef is built for Australian specialist practices making exactly this move: every arriving referral sits on a board through triage, patient contact and booking, so “waiting on forms” and “gone quiet” are columns you can see rather than things you have to remember.

One piece of practical advice about the changeover, whichever system you land on: don’t try to import years of history. Start with the referrals that are still open (the ones where a patient is waiting on something) and let the closed ones stay in the sheet as an archive. Migrating live work takes an afternoon; migrating history takes weeks and nobody ever looks at it. The same principle runs through our referral management best practices: the system only has to be right about what’s still moving.

Tell us how your practice triages and we build those stages into your board. You aren’t handed a template designer to configure. Email is included on every plan; SMS is a paid add-on. Pricing is published openly. If you’d rather see the mechanics first, set up a referral workflow in ten minutes walks through it.

Whatever you choose, the principle holds: the best time to upgrade is before you lose a referral that matters. The second-best time is right after.