New Patient Intake

Tracking Referrals: Spreadsheet vs Software

When a referral log is enough, when referral management software pays for itself, and how to set up either one safely in a medical practice.

AssistCall research teamPublished Reviewed by Faruque Amin, VP of Sales and Marketing7 min read

On this page
  1. The question practices actually face
  2. What any tracking method must do
  3. Building a referral log that works
  4. Keep the log secure
  5. Where spreadsheets break
  6. The options beyond a spreadsheet
  7. Small practices and EHR variety
  8. Making the decision under cost pressure
  9. A worked comparison
  10. Questions to ask a referral software vendor
  11. Moving from a log to software
  12. Frequently asked questions
  13. References
New Patient Intake: Tracking Referrals: Spreadsheet vs SoftwareArticle coverNEW PATIENT INTAKETracking Referrals:Spreadsheet vs SoftwareAva Medical IntakeInsightsNew Patient Intake: Tracking Referrals: Spreadsheet vs SoftwareArticle coverNEW PATIENT INTAKETracking Referrals:Spreadsheet vsSoftwareAva Medical Intake

Key takeaways

  • Any tracking method must show every open referral, its owner, its next deadline and its outcome.
  • A well-built, access-controlled log works for low volumes and a single coordinator.
  • Software earns its place when volume, multiple locations, authorization work or referrer reporting outgrow one person's spreadsheet.
  • Check your EHR's referral module before buying anything; it may already do most of the job.

The question practices actually face

Every practice tracks referrals somehow. Some use a fax tray and memory, some a spreadsheet on a shared drive, some the EHR's referral module and some a dedicated referral management product. The real question is not which tool is best in general, but whether your current method still lets you see every open referral and act on it on time.

The stakes are real. In a large health system study, only 34.8% of primary care referrals to specialists ended in a documented completed appointment[1]. Tracking alone does not fix that, but you cannot fix what you cannot see, and the right tool is the one that makes stalled referrals impossible to miss.

What any tracking method must do

  • Show every open referral in one place, whatever channel it came from.
  • Name one owner for each referral and each next step.
  • Show the next deadline, such as first contact, authorization or referrer notice, and flag anything overdue.
  • Record each contact attempt with date, method and result.
  • Record the outcome: booked, seen, declined, not reached, redirected.
  • Produce simple counts each month: received, booked, completed, by source.
  • Protect patient information with access controls and an audit trail.

If a spreadsheet does all seven reliably for your volume, you do not need software yet. If it does not, no amount of extra columns will fix it.

Building a referral log that works

Minimum columns for a referral log
ColumnWhy it matters
Date receivedStarts every deadline clock
Referral source and contactNeeded for notices and referrer reporting
Patient name, DOB, phoneTwo identifiers plus the number you will call
UrgencySets the booking window
Plan and authorization statusPrevents visits that are cancelled later
OwnerOne name per row
Next action and due dateDrives the daily worklist
Contact attemptsDate and result of each call or text
Outcome and dateBooked, seen, declined, not reached
Referrer notifiedDate each notice was sent

Sort the log by next due date each morning and work from the top. Use a filter for overdue rows and a separate tab for closed referrals, so the open list stays short enough to read.

Keep the log secure

A referral log is a list of patients, their phone numbers and why they are being seen. It is protected health information and needs the same care as the chart. If it lives in a cloud file service, that service handles protected information on your behalf, and HIPAA allows that only with a business associate agreement in which the vendor gives satisfactory assurance that it will safeguard the information[2].

  • Store it in a system covered by a business associate agreement, never on a personal account or a desktop.
  • Limit access to the staff who work referrals, and remove access the day someone leaves.
  • Never email the file or attach it to messages.
  • Keep version history turned on so accidental deletions can be recovered.
  • Record the minimum clinical detail needed; the full referral stays in the chart.

Where spreadsheets break

  • Volume: once open referrals run into the hundreds, the daily list stops fitting on a screen and overdue items hide.
  • More than one coordinator: two people editing the same rows overwrite each other, and ownership blurs.
  • Multiple locations: each site starts its own copy, and nobody sees the total.
  • Authorization-heavy specialties: tracking approvals, visit counts and expiry dates in cells becomes error-prone.
  • Double entry: every referral is typed into the log and again into the EHR, and the two drift apart.
  • Reporting: referrers ask how many of their patients were seen, and the answer takes a day of filtering.

The options beyond a spreadsheet

There are three broad alternatives. The EHR's own referral or order tracking module is often already paid for and keeps referrals attached to the patient record, though it may be built more for sending than receiving. Dedicated referral management software focuses on intake queues, authorization tracking, patient outreach and referrer reporting, and connects to the EHR in varying depth. Broader patient access or contact center platforms add referral queues to phone, text and scheduling tools.

How the three main approaches compare
CriterionSpreadsheet logEHR referral moduleDedicated software
Upfront effortLowConfiguration timeImplementation project
Ongoing costStaff time onlyOften includedSubscription
Linked to the chartNoYesDepends on integration
Overdue alertsManual filtersUsually availableBuilt in
Multiple coordinatorsFragileGoodGood
Authorization trackingManualVariesUsually strong
Referrer reportingManualVariesUsually strong
Patient outreachManualLimitedOften included

Small practices and EHR variety

What your EHR can do depends heavily on which EHR you have. Only 32% of solo physicians used an EHR from one of the five market-leading developers in 2024, compared with 90% of physicians in practices with more than 50 physicians[3]. Smaller practices are more likely to run systems with lighter referral features and fewer ready-made integrations.

Physicians using an EHR from one of the five market-leading developers, 2024
Physicians using an EHR from one of the five market-leading developers, 2024Comparison. Solo practice: 32%; More than 50 physicians: 90%.32%Solo practiceSolo practice: 32%90%More than 50 physiciansMore than 50 physicians: 90%Physicians using an EHR from one of the five market-leading developers, 2024Comparison. Solo practice: 32%; More than 50 physicians: 90%.32%Solo practiceSolo practice: 32%90%More than 50 physiciansMore than 50 physicians: 90%

Source: Office of the National Coordinator for Health IT (ASTP/ONC), HHS, 2024[3]

Show the data
ItemValue
Solo practice32%
More than 50 physicians90%

Before buying anything, ask your EHR vendor for a demonstration of incoming referral tracking specifically, not outgoing orders. Ask whether it supports a shared work queue, due dates, contact attempt logging and a report of referrals by source and outcome.

Making the decision under cost pressure

Budgets are tight. In a June 2026 poll, 84% of medical groups reported operating costs higher than at the same point a year earlier[4]. At the same time, automation was practice leaders' top planned cost-cutting move for 2026 at 36%, ahead of process fixes at 23%[5]. Both point the same way: spend where a tool replaces real staff hours or recovers lost visits, and fix the process first so the tool has something good to automate.

  • A log is usually enough when one coordinator handles referrals, open referrals fit on one screen, authorizations are rare and referrers rarely ask for reports.
  • Software usually pays when several people work the queue, you have more than one location, authorizations are routine, referrers expect reporting, or double entry is eating hours each week.
  • Either way, write down the workflow first: owners, deadlines and notices. A tool configured around an undefined process just automates the confusion.

A worked comparison

Example: a fictional two-location gastroenterology practice receives about 300 referrals a month. Two coordinators share a spreadsheet, and each spends roughly an hour a day re-entering referrals into the EHR and reconciling the log. A monthly review shows that about one in eight referrals has no contact attempt within three business days. The practice estimates the re-entry time alone at around 40 staff hours a month.

It first tests the EHR's referral queue, which handles intake and due dates but not authorization tracking. It moves intake into the EHR queue, keeps a small authorization tracker, and drops the spreadsheet. A dedicated product stays on the shortlist for the next budget year, with a clear test: does it cut the remaining authorization work and produce referrer reports without manual filtering?

Questions to ask a referral software vendor

  • Which EHR do you connect to, and does the connection create the patient and the referral automatically, or does staff still retype them?
  • Can incoming faxes be read into a referral record, and how are pages that fail to read handled?
  • How does the work queue show ownership, due dates and overdue items for each coordinator?
  • Can patients receive a text with a booking link after a missed call, using wording we approve?
  • What does the referrer report look like, and can it be sent to each referring office automatically?
  • Will you sign a business associate agreement, and where is the data stored?
  • What happens to our data if we leave, and in what format can we export it?

Ask for a trial on a copy of your real workflow, not a scripted demonstration. A week of your own referrals passing through the tool will show more than an hour of slides, especially around fax handling and EHR integration, where most problems hide.

Moving from a log to software

  1. Clean the log first

    Close stale referrals with a recorded reason so you migrate only open, real work.

  2. Map columns to fields

    Match each log column to a field in the new tool, and decide what to drop.

  3. Run both for two weeks

    New referrals go into the new tool; the log is read-only for open items until they close.

  4. Train on the daily worklist

    The habit that matters is working the overdue list every morning, whatever the tool.

  5. Measure before and after

    Compare time to first contact and share booked within the urgency window for the month before and the month after.

Tracking is one part of the referral path. See closing the referral loop, referral leakage and the new patient welcome packet for the steps around it.

Frequently asked questions

Is a spreadsheet HIPAA compliant for referral tracking?

It can be used safely if it is stored in a system covered by a business associate agreement, access is limited and it is never emailed. The spreadsheet itself is not compliant or non-compliant; how you store and share it is what matters.

What should referral tracking software do that a spreadsheet cannot?

Shared work queues, automatic overdue alerts, contact logging linked to the chart, authorization tracking and referrer reports without manual filtering.

Does our EHR already track referrals?

Most EHRs track outgoing referral orders, and many can track incoming ones. Ask your vendor to demonstrate incoming referral queues, due dates and outcome reporting specifically.

How do we know if software would pay for itself?

Measure staff hours spent on double entry and reconciliation, and the share of referrals contacted late or lost. If a tool would recover enough of both, it is worth a trial.

References

  1. Journal of General Internal Medicine (via PubMed Central) (2018). Closing the Referral Loop: an Analysis of Primary Care Referrals to Specialists in a Large Health System (Journal of General Internal Medicine) (opens in a new tab) โ†‘

  2. Legal Information Institute, Cornell Law School (current). 45 CFR ยง 164.502 - Uses and disclosures of protected health information: General rules (opens in a new tab) โ†‘

  3. Office of the National Coordinator for Health IT (ASTP/ONC), HHS (2024). Office-based Physician Electronic Health Record Adoption, 2008-2024 (ONC Data Brief) (opens in a new tab) โ†‘

  4. Medical Group Management Association (MGMA) (2026). Operating costs keep climbing for medical practices in 2026 (opens in a new tab) โ†‘

  5. Medical Group Management Association (MGMA) (2026). Automation, process fixes top list of cost-cutting moves for medical practices in 2026 (opens in a new tab) โ†‘

Book a demo

See Ava handle your calls.

Book a short demo. Weโ€™ll walk through your calls and workflow, and agree what Ava should take care of.

Book a demo