A family medical referral tracking sheet

A referral tracking sheet gives each referral one row and holds everything the family has been told about it: which office sent it, which office should receive it, what has actually been confirmed, what each office or the insurer says is still needed, and who will make the next call. Its main job is to keep confirmed facts apart from assumptions. A referral the requesting office says it sent is not the same as a referral the receiving office says it has. A pending authorization question is not the same as approved coverage. This guide covers the administrative side only: tracking a referral that already exists. Whether a referral is needed, and what care follows, is for the clinicians involved.

What the sheet needs to capture

The columns below cover the information you are most likely to need when you call an office, hand the task to another relative, or work out why a referral has stalled. The example entries are invented, for illustration only.

Column	What to record	Illustrative entry
Person receiving care	Whose referral this is	Mom
Referral reference	Any number or name the offices use for it	Ref. given by requesting office: 4471
Requesting office	Office name, contact person, phone	Primary care office, front desk
Receiving office	Office name, contact person, phone	Specialty clinic, referral coordinator
Referral date	Date the referral was created, as the requesting office reports it	Oct 2
Sending reported	Date and method the requesting office says it sent the referral, and who said so	Oct 3, sent electronically, per front desk
Receipt confirmed	Date the receiving office confirmed it has the referral, and who confirmed	Not yet confirmed
Contact attempts	Date, office, person reached, outcome	Oct 9, specialty clinic, voicemail left
Requirements stated	Each item requested, who requested it, the date, and whether it is done	Recent records, requested by specialty clinic Oct 10, sent Oct 11
Authorization questions	What was asked, who was asked, and their actual answer	Asked insurer Oct 10; rep said request on file, decision pending
Scheduling status	Where scheduling stands, in the receiving office's words	Clinic will call to schedule after review
Next action	Task, owner, target date	Call clinic to confirm review, Dana, Oct 16
Appointment link	Where the confirmed appointment is recorded	Household appointment list, row 12

Keep each status separate

Referrals tend to stall in the gaps between offices, so the status column should name exactly which step has been confirmed and by whom. Use separate values instead of a single 'in progress':

• Sending reported: the requesting office says it sent the referral. Receipt has not been confirmed.
• Receipt confirmed: the receiving office says it has the referral. Note who told you and when.
• Additional information requested: an office or the insurer has asked for something more. Record what was asked for and who asked.
• Scheduling pending: the receiving office has the referral but has not set an appointment. Note its stated process, for example 'they will call us' or 'we call after review.'
• Appointment confirmed: the receiving office has given a date and time.

Move a referral to the next status only after the relevant office confirms it. If receipt is unconfirmed, write down what each office said and assign the next contact to someone. Don't mark it received on the assumption that it arrived.

Who does what

The sheet works best when it is clear which tasks belong to whom. The person receiving care is the patient. Offices may need that person's permission, or other documentation, before discussing the referral with a relative, so ask each office what it requires. The family coordinator keeps the sheet, makes or assigns follow-up calls, and records answers. The requesting office creates and sends the referral. The receiving office confirms receipt, requests anything missing and schedules. The insurer answers authorization and coverage questions. If more than one relative makes calls, put the caller's name in the contact log. Anyone picking up the task later can then see who spoke to whom.

A contact routine that fills in the sheet

• Call the requesting office. Ask where and when the referral was sent, how it was sent, and what next step that office expects. Record the answer under 'sending reported.'
• Call the receiving office. Ask whether it has received the referral, whether anything is missing, and how its scheduling works. Record who confirmed, and the date.
• If either office says something is needed, such as records, a form or an authorization, add it as a separate requirement. Note who stated it, the date and any deadline they gave.
• Take authorization and coverage questions to the office handling the request and to the insurer. Record what each actually said, including the representative's name and any call reference number. Don't infer coverage from the referral status.
• Before you hang up, write the next action, its owner and a target date.

Example: a referral with no confirmed receipt (hypothetical)

Suppose the requesting office says it sent a referral on Monday, and when you call the receiving office it can't find it. The row stays at 'sending reported; receipt unconfirmed,' and the contact log shows both conversations:

Date    Office            Spoke with     Outcome
Mon     Requesting office  Front desk     Says referral sent Monday electronically
Thu     Receiving office   Scheduler      No record of receipt yet
Thu     Requesting office  Front desk     Will resend; asked us to recheck Monday

Status:       Sending reported; receipt unconfirmed
Next action:  Call receiving office to confirm receipt - Sam - Mon

Once the receiving office confirms it has the referral, record that person and date, then change the status. Nothing moves forward on the sheet until an office confirms it.

Recording requirements, authorization and deadlines

Give every requirement or deadline a source: the office or insurer that stated it, the date they stated it, and whether it is done. When two sources disagree, for example the receiving office says authorization is required and the insurer's representative says it isn't, record both answers and make resolving the difference the next action. Don't pick one. Written notes like 'Insurer rep, Oct 10: decision pending, call back in five business days' are easier to act on than a checkbox marked 'authorized?'

Choosing a format: shared spreadsheet, printable sheet or both

Criterion	Shared online spreadsheet	Printable sheet or PDF on paper	Spreadsheet kept by one person
Shared access	Several relatives can view and update it	Only whoever holds the paper	One coordinator; others get updates
Update effort	Quick edits, easy to sort by next action date	Handwritten; rewriting needed as it fills up	Quick edits, but one person does all of them
Portability	Available on any device with access	Easy to bring to appointments and calls	Depends on where the file is stored
Accessibility	Text can be resized; works with many assistive tools	Can be printed in large type; no device needed	Same as a shared spreadsheet
Cost	Common spreadsheet programs have free options; check current terms	Paper and a printer	Same as a shared spreadsheet

A shared spreadsheet suits families who split calls across several people or live in different places. A printed sheet suits a single coordinator, a care recipient who prefers paper, or anyone who wants the record on hand during calls. Many families keep the spreadsheet as the master copy and print the open referrals when needed. Because the sheet holds health and insurance details, share it only with the people coordinating care, and check the privacy and sharing settings of any app or service before you enter that information.

Setting it up in a spreadsheet

You can copy this header row into the first row of a blank spreadsheet. Use one row per referral and put the detailed call history on a second tab so the main view stays readable.

Referrals tab:
Person,Referral ref,Requesting office,Requesting contact,Receiving office,Receiving contact,Referral date,Sending reported (date/by),Receipt confirmed (date/by),Status,Open requirements,Authorization notes,Next action,Owner,Due date,Appointment link

Contact log tab:
Date,Referral ref,Office,Spoke with,Caller,What was said,Follow-up

• Make Status a drop-down limited to the five values above so entries stay consistent.
• Sort or filter by Due date to see what needs a call this week.
• Record requirements on the contact log, or on their own tab, with columns for source, date stated, deadline and done.
• Start each contact log entry with the date, so the log reads as a timeline.

Closing out a referral

When the receiving office confirms an appointment, copy the date, time, location and any instructions the office gave into the household appointment record. Then link that entry from the referral row and mark the referral closed. Keep the closed row and its contact log. If a later office asks when the referral was sent or received, the answer is already on file.