A referral source tracking template, and when you outgrow it

In March your BD rep sat down with a therapist group across town, left a stack of brochures and wrote the visit in a notebook in the car. Nobody called them again. In July one of their clients needed residential care, and the therapist phoned the center whose rep had stopped by in June.

Nobody did anything wrong. The March visit just never turned into a date on anyone's list. Robert D'Annibale of Crossroads told Behavioral Health Business in 2025 that the people who come through a center “are your biggest spokespeople”, and the same goes for the therapists, ER social workers and court staff who send people your way. They refer to the center that stays in touch.

Below is a three-tab template you can copy into a spreadsheet today, who fills in each tab, how often partners should hear from you, and the signs that the sheet has run its course.

Who sends people to treatment

TEDS, SAMHSA's federal count of treatment admissions, records how each admission reached treatment, in seven groups: the person themself (self-referral included), another treatment program, other health care such as doctors and hospitals, schools, employers and EAPs, other community referrals, and courts and the criminal justice system. In its yearly reports, self-referral and the courts are usually the two largest.

For a private center, the people behind those groups have names: therapists and counselors, hospital ERs and their social workers, primary care doctors, sober living homes, interventionists, EAPs, drug court staff, probation officers, and your own alumni and their families. Each one goes on the sheet as a partner.

What the sheet has to answer

A referral sheet earns its place by answering three questions on any Monday morning:

1. Who are our partners, and who is the person to call at each one?
2. When did each partner last hear from us, and when are they due again?
3. Which partners sent someone this quarter, and did that person admit?

A column that doesn't help answer one of those can go. Most sheets that stop being used died from too many columns, not too few.

The template: three tabs

Make one spreadsheet with three tabs: Partners, one row per organization; Touches, one row per visit, call or email; and Referrals, one row per inquiry a partner sent. Keeping them apart means nobody types a partner's details twice, and the Partners tab stays short enough to read.

The tables below show the headings with a few sample rows. Copy the headings into row one of each tab and delete the samples.

Tab 1 of 3 Partners

Status has three values: prospect (not visited yet), first visit (met, nothing sent yet) and referring (sent at least one inquiry). Sort by Next due every Monday, and the BD rep's week is planned.

Tab 2 of 3 Touches

Each touch also changes Last touch and Next due on the Partners tab. If nobody does that, the Partners tab drifts and nobody trusts it.

Tab 3 of 3 Referrals

Notice what's missing: the client's name. The inquiry ID matches the record in your admissions software; the name stays there. A spreadsheet gets forwarded, printed and left open on a laptop, so a name, a diagnosis or a story never goes in any tab, notes included.

Who updates it

Give each tab one owner, and say so in writing.

• The BD rep updates Partners and Touches the same day as each visit or call, from the car if needed.
• The admissions coordinator adds the Referrals row mid-call, by asking who pointed them to you and picking the partner from the list.
• The admissions director reads all three tabs before the Monday meeting and asks about anything overdue.

If a BD rep moves on, the sheet stays, and so does every partner's history. That alone is worth the ten minutes a day.

How often partners should hear from you

There's no published standard, so set one and stick to it. A rhythm many outreach teams use:

• Referring partners: once a month, in person or by phone.
• New partners: every two weeks for the first two months.
• Quiet partners: a call to anyone with no touch in 60 days.

A touch should carry something useful: open assessment times this week, your direct admissions line, a new evening program, a program you've added or closed. An update about a client someone referred goes out only with that client's signed consent, and never with clinical detail in writing.

No column for gifts

There is no column for gifts, meals, payments or anything else of value given to a partner, because nothing of value should be tied to a referral. The federal Eliminating Kickbacks in Recovery Act (EKRA) covers payments for referrals to recovery homes, treatment centers and laboratories, with as much as $200,000 in fines and 10 years in prison for each occurrence. Several states, Florida among them, have their own brokering laws on top. This is not legal advice: have counsel review your outreach policy, and see the brokering laws post for the plain-English version.

When you outgrow the spreadsheet

A spreadsheet works well for one BD rep and a few dozen partners. These are the signs it has stopped working:

1. Two or more reps edit it, and copies go around by email.
2. More than about 40 active partners, so the Monday sort takes longer than the meeting.
3. Admits get typed in weeks later, or not at all.
4. A partner's referral reaches your main line, and nobody can say who sent it.

The fix is software that gives each active partner its own tracking number or link, so the source is set before the phone is answered. RehabSignal's Referral Partners keeps each partner with its named people, visit notes and due dates on the BD rep's phone, and counts admits per partner from the admissions board. Until then, the three tabs above will do the job, as long as someone owns each one.