Stop Tracking Referrals in Spreadsheets (7 Ways)

If you’ve ever spent twenty minutes hunting for a referral you know you received, only to find it wedged between two pathology reports in a manila folder, you already understand why referral tracking matters. The question isn’t whether you need a system. It’s which one fits your practice.

There is no single right answer. What works for a solo dermatologist with a trickle of referrals won’t hold for a multi-doctor orthopaedic practice. What matters is knowing where each option gives out, so you change systems before the failure finds you.

Here are seven approaches, simplest to most capable.

1. Paper folders and filing cabinets

Letters are printed or arrive by post and fax, sorted into folders by doctor or urgency, and stored in a tray near reception. It is tangible, and the pile itself is a crude volume gauge.

It still suits a single practitioner with a light, steady flow and someone who touches every folder daily. Past that, you are storing risk in a cabinet: no search, no report, no history if the folder walks.

2. Spreadsheets (Excel or Google Sheets)

Columns for patient, referring GP, date received, status, assigned doctor, notes. Free, familiar, and a genuine step up: conditional formatting alone will show you a stalled column.

The catch is maintenance. The moment the front desk gets busy, the sheet drifts behind reality: referrals booked on Tuesday still showing “pending”, others never entered at all. Two people editing the same row means one of them loses. A well-maintained spreadsheet beats a neglected software system, so if this is your system, make it disciplined: our referral tracking guide has a workable framework, and spreadsheet versus software sets out exactly where the seams open.

3. Shared email inbox with labels

Referrals land at referrals@yourpractice.com.au and staff move them between labels: New, Triaged, Booked, Waiting on documents. If your referrals already arrive by email, this meets them where they are at no extra cost.

Email was built for correspondence, not workflow. A message labelled “Triaged” three weeks ago looks identical to one labelled this morning. Anything arriving by fax, post or phone never appears, so you quietly end up running two systems. An archived thread disappears from view without a trace.

4. Practice management system (Best Practice, Genie, Medical Director)

Referrals are logged as incoming correspondence, attached to the patient record and tracked through the system’s own fields. Everything stays in one place, which doctors like.

These systems are built around the clinical record: appointments, notes, and correspondence attached to a patient. The referral is filed correctly and then goes quiet, because finding it again means opening that patient rather than working a queue of everything outstanding. We compared the two approaches properly in PMS versus dedicated referral management.

5. Whiteboard or physical Kanban board

Columns on the wall (Received, Triaged, Patient contacted, Booked, Documents pending), with a magnet or sticky note per referral. It is immediate, everyone sees the same state, and moving a note across is oddly satisfying.

It works while every active referral fits legibly on the wall and everyone who needs it is standing in front of it. Remote staff and second sites are excluded by design, nothing is searchable, and the moment a note moves you have lost the record of how long it sat where it was.

6. Project management tools (Trello, Asana, Monday.com)

Each referral becomes a card. Columns are stages, people are assignees, comments carry the history. These are real workflow tools and a serious upgrade on a spreadsheet.

They are also general-purpose by design: Trello, Asana and Monday all describe themselves as work and project management platforms rather than healthcare tools. Referral detail lives in your PMS, so your team retypes it into cards and checks yet another tab all day. Before you put health information into a general-purpose platform, check where the vendor stores it and who else in their stack can reach it. Read that from their own documentation rather than assuming.

7. Purpose-built referral management software

A platform built for the stretch other categories skip: from the moment a referral lands, through triage, patient contact and document chasing, to a booked appointment. Pipeline visibility like the whiteboard, but with healthcare stages, an audit trail of who touched what, follow-up attached to the referral rather than to somebody’s memory, and reporting on where the queue actually leaks.

The cost is honest: a subscription, a migration, and a system your team has to learn. If you handle a handful of referrals a week and nothing has ever gone missing, that overhead may not earn its keep. If you can’t currently say how many referrals are unactioned, it will. The Australian software landscape is broader than most practices realise. It splits into four categories that are often mistaken for one.

Have you outgrown what you’re using?

If any of that landed, the fix isn’t necessarily software. A standing fifteen-minute weekly referral meeting closes a surprising number of gaps, and it costs nothing. What it won’t do is find the referrals that were never logged in the first place. For that, see what actually happens when a referral gets lost.

Pick for your volume, and be honest about your discipline

Every system here works at the right scale with the right habits. The expensive mistake isn’t picking the wrong tool. It’s staying on one you’ve outgrown because switching feels like effort, or moving to one nobody will maintain.

Some of the gap is clinical rather than administrative: a systematic review in the Journal of General Internal Medicine found only 35% of specialty referrals result in a documented visit. The administrative slice is the part you control, and what one lost referral actually costs is usually more than practices assume.

To put a number on your own practice, the referral leakage calculator takes about thirty seconds. If you’d rather see a board with your kind of referrals on it, ask us for a twenty-minute walkthrough. Tell us how you triage and we’ll build those stages into your board. You can also start a 14-day free trial, no credit card required.