Direct download · XLSX checked with LibreOffice Calc
This free Excel template provides clinic operations teams with a structured referral tracking spreadsheet for routine referral intake, follow-up, scheduling, and closure review. It includes a 500-row referral register, calculated action alerts, standardized dropdown fields, and a dashboard filtered by clinic and coordinator.
Populated sample referrals demonstrate the intended workflow and should be replaced or removed before operational use.
Preview 1 — “Dashboard” sheet Click to enlarge
In practice
What this template helps you manage
✓
Keep referral intake, destination, specialty, urgency, payer, authorization, coordinator, status, dates, outcomes, and notes in one register.
✓
Surface past-due target dates, follow-ups due, pending authorizations, and data-quality problems through calculated outputs.
✓
Review total, open, scheduled, and completed referral counts from a consolidated dashboard.
✓
Compare workload by referral status and by five open-aging bands.
How to use it
How to use the workbook
Start by updating the Dashboard Review Date, because open days, aging, past-due flags, and follow-up-due flags use that date. On the Referrals sheet, replace or remove the populated samples and enter one referral per row using a unique Referral ID and a non-identifying Client Reference. Complete the applicable dropdown fields and dates, then maintain referral status, authorization, follow-up, appointment, and closure details as work progresses. Review the calculated Data Check and Action Alert columns, and use the clinic and coordinator filters to focus the dashboard on selected workloads. Do not use this workbook to manage emergency referrals or time-critical clinical situations.
Preview 2 — “Referrals” sheet Click to enlarge
Inside the file
Included features and controls
＋Four worksheets: Dashboard, Referrals, Lists, and Instructions.
＋A ReferralTable spanning A1:AA501, with one header row and 500 prepared operational rows.
＋Seven calculated outputs: Days Open, Aging Band, Open Flag, Past Due Flag, Follow-up Due Flag, Data Check, and Action Alert.
Track Each Referral from Intake Through Closure
The Referrals sheet organizes one referral per row across 20 user-entry fields. Teams can record the Referral ID, Date Received, non-identifying Client Reference, Referring Clinic, Destination Organization, Specialty, Urgency, Referral Reason Category, Payer Category, Authorization Status, Coordinator, and Referral Status. Date, outcome, and notes fields support ongoing updates through scheduling or closure. The 500 prepared rows run from row 2 through row 501; populated examples are samples rather than additional capacity.
Preview 3 — “Lists” sheet Click to enlarge
Prioritize Referral Follow-Up and Exceptions
Seven formula-driven columns turn entered data into operational outputs. Days Open and Aging Band show elapsed time, while open, past-due, and follow-up-due flags support exception review. Data Check identifies issues such as missing required information, duplicate referral IDs, or invalid date sequences. Action Alert categorizes populated records as Check data, Closed, Past due, Follow-up due, Authorization pending, or On track according to workbook logic. The calculated columns are outputs and should not be treated as manual-entry fields.
Review Clinic and Coordinator Workload
The Dashboard summarizes current workload using the selected Review Date and optional clinic and coordinator filters. Metrics include Total Referrals, Open Referrals, Past Due, Follow-up Due, Scheduled, Completed, New, Pending Authorization, Data Issues, Closed Without Scheduling, Completion Rate, and Average Open Days. Selecting All includes the available list values, while a specific selection narrows every dashboard metric and chart. This provides a filterable operational view without changing the underlying referral records.
Preview 4 — “Instructions” sheet Click to enlarge
Understand Status and Referral Aging
The workbook treats New, Sent, Scheduling, and Scheduled referrals as open. Open workload is grouped into 0–7, 8–14, 15–30, 31–60, and 61+ day bands. Days Open uses the Closed Date when present and otherwise uses the Dashboard Review Date, with a minimum result of zero. Two charts display counts by referral status and open-aging band, providing a visual workload summary grounded in the referral register.
Common questions
About this template
The Referrals sheet contains 500 prepared operational rows, covering rows 2 through 501 beneath the header. Some rows contain populated sample referrals that demonstrate the workflow; replace or remove those samples before operational use.
Users enter Referral ID, Date Received, Client Reference, Referring Clinic, Destination Organization, Specialty, Urgency, Referral Reason Category, Payer Category, Authorization Status, Coordinator, Referral Status, Target Action Date, Referral Sent Date, Appointment Date, Closed Date, Last Follow-up Date, Next Follow-up Date, Close Outcome, and Notes.
The workbook calculates Days Open, Aging Band, Open Flag, Past Due Flag, Follow-up Due Flag, Data Check, and Action Alert across the prepared referral rows. These are formula-driven outputs rather than manual-entry fields.
A populated referral is marked Past due when it is open, has a Target Action Date, and that date is earlier than the Dashboard Review Date. It is marked Follow-up due when it is open, has a Next Follow-up Date, and that date is on or before the Dashboard Review Date.
Yes. The Dashboard has clinic and coordinator dropdown filters, each with an All option. The selected values apply to all dashboard metrics and both charts.
No. The Instructions sheet states that the workbook should not be used to manage emergency referrals or time-critical clinical situations. It is designed for routine clinic operations tracking and review.
Editorial process
Prepared and reviewed against the workbook
Maya Brooks
Workbook editor
Maya Brooks is an editorial pseudonym used for the role that structures workbook requirements, fictional sample data, calculations, and operating checks.
Daniel Reed
Content checker
Daniel Reed is an editorial pseudonym used for the role that compares page copy with the generated workbook and states practical limits.
