Referral Tracking Spreadsheet for Coaches: Template and Example

Which referral partners are actually bringing you coaching clients, and which introductions are quietly disappearing after the first email? Use a referral tracking spreadsheet with one row per distinct referred enquiry, a consistent referrer ID, an actual next action and a verified outcome. Count introductions, held calls and paying clients separately.

You do not need a commission program to do this. For a small coaching practice, the first job is simpler: follow up responsibly, stop counting the same person twice and understand which relationships produce suitable enquiries. A referral is not a client, and an invoice is not collected revenue.

This guide gives you a copyable column layout, a fictional worked example, spreadsheet formulas and a weekly review. It tracks incoming, unpaid referrals. It is not an affiliate payout calculator, a referral-fee agreement or a substitute for your private client records.

What should a referral tracking spreadsheet include?

Start with three tabs: Referrals, Partners and Definitions. If you want revenue analysis, add a restricted Payments tab or reconcile against your existing payment records. Keep coaching goals, health details, session notes and other sensitive client information out of the tracker.

The Referrals tab answers what happened to an introduction. Partners holds a stable identifier for each source. Definitions records what your statuses and reporting dates mean. That third tab sounds dull until you discover that last month's “converted” meant a booked call and this month's means a paid package.

Copy this Referrals header row

The following is tab-separated. Paste it into the first row of a blank spreadsheet; each heading should occupy its own column.

ReferralID	ReceivedDate	ReferrerID	LeadID	SourceConfirmed	CallHeld	Status	Owner	NextFollowUp	CashCollected	Refunds	NetCollected

• A, ReferralID: a unique reference for the enquiry, such as R001. It is not a new ID for every email.
• B, ReceivedDate: when the referred enquiry entered your process, entered as a real date.
• C, ReferrerID: the stable partner reference, such as P01, rather than several spellings of a person's name.
• D, LeadID: the matching prospect or client reference in your restricted source system.
• E, SourceConfirmed: Yes, Pending or Disputed, based on the evidence you actually have.
• F, CallHeld: Yes or No. A booking that nobody attended is No.
• G, Status: New, Contacted, Call booked, Decision pending, Won or Closed.
• H and I: the person responsible and the next follow-up date, where another contact is appropriate.
• J, K and L: reconciled cash collected, refunds and net collected in one stated currency and through one stated cutoff.

On Partners, record ReferrerID, display name, relationship type and your own next relationship-review date. On Definitions, record the currency, reporting cutoff, what “Won” means and how you resolve competing source claims. Restrict access to the partner-to-person mapping too; a coded reference is not automatically anonymous.

1. Decide what counts before you enter the first referral

Use “one distinct referred enquiry” as the unit. If a contact introduces the same person twice about the same coaching need, update the existing row. If that person later returns for a genuinely separate engagement, apply a documented repeat-enquiry rule rather than improvising a new count to improve the numbers.

For this template, “Won” means the person has accepted the engagement and made the first required payment. That is an internal reporting definition, not a rule every coaching business must adopt. A corporate practice may need a different verified purchasing event, but it should name that event precisely.

Do not make “Closed” mean “bad lead.” It can mean not suitable, declined, no response after your agreed follow-up or no current need. If you record a reason, keep it short and operational. A source tracker does not need an explanation of somebody's personal circumstances.

A real prospect workspace can hold the operational relationship while the spreadsheet holds a small analytical index. The Coachful demo above illustrates a prospect record surface. It does not show this exact template, automatic source attribution or a referral analytics report.

2. Capture the source without making the introduction intrusive

Ask a light, specific question: “How did you hear about my coaching?” If the person names somebody, clarify whether they are comfortable with you acknowledging the introduction. That is different from asking permission to share their purchasing decision or coaching progress.

For a warm introduction, agree what contact details may be passed along before anyone forwards them. Another person's enthusiasm is not permission to circulate a prospective client's private situation. A person can also choose to contact you independently instead of accepting a group email.

Record an unverified source as Pending rather than guessing. If an enquiry says “a friend” and you cannot establish which friend, keep an Unknown or Unconfirmed category. An honest gap is more useful than tidy attribution you made up.

Choose one primary source rule for analysis. For example, use the prospect-confirmed introduction that prompted the enquiry, retain a note about another known influence in the restricted source record and flag unresolved competing claims. Do not count one enquiry under two partners in the same total.

3. Use the worked example to test your definitions

The following example is entirely fictional. It uses a September enquiry cohort, with outcomes and cash reconciled through October 18. All money is USD, with taxes and payment-processing fees excluded for simplicity. These figures are neither Coachful results nor recommended coaching prices.

• R001, P01: received September 2; call held; Won; $900 collected; no refunds; $900 net.
• R002, P01: received September 8; call held; Decision pending; no payment; next follow-up October 21.
• R003, P02: received September 10; call held; Won; $600 collected; $100 refunded by the cutoff; $500 net.
• R004, P02: received September 22; call held; Decision pending; no payment; next follow-up October 20.
• R005, P03: received September 27; no call held; Contacted; no payment; follow-up was due October 16.
• R006, P01: received October 2; a separate October enquiry, excluded from the September cohort.

The September cohort therefore contains five enquiries, four held calls and two paying clients as defined above. It has $1,500 collected, $100 refunded and $1,400 net collected through October 18. R006 must not enter the denominator just because it appears in the same workbook.

The referral-to-paying-client rate is 2 divided by 5, or 40%. The held-call rate is 4 divided by 5, or 80%. Those are arithmetic descriptions of this small fictional cohort, not conversion benchmarks or evidence that a particular partner will perform the same way next month.

4. Add formulas that match the question you are asking

In L2, calculate net collected for that row. Copy down only across your data rows, and protect the formula cells against accidental edits:

=IF(A2="","",J2-K2)

Enter zero where a reconciled row genuinely has no collected payment or refund. An empty cell should not quietly mean both “nothing happened” and “nobody checked.” If you cannot reconcile the money yet, leave the result out of your revenue report and mark the review outstanding in a separate working note.

Set P1 to the cohort start date, P2 to the exclusive end date and P3 to the source partner ID you want to inspect. For September, use September 1 and October 1 as real dates. Using an exclusive end avoids including an October enquiry.

=COUNTIFS(B2:B1000,">="&$P$1,B2:B1000,"<"&$P$2,C2:C1000,$P$3)
=COUNTIFS(B2:B1000,">="&$P$1,B2:B1000,"<"&$P$2,C2:C1000,$P$3,G2:G1000,"Won")
=SUMIFS(L2:L1000,B2:B1000,">="&$P$1,B2:B1000,"<"&$P$2,C2:C1000,$P$3)

These return that partner's enquiries, Won rows and net collected for the selected enquiry cohort. Divide the Won count by the enquiry count only when the denominator is greater than zero. With no enquiries, display “No enquiries” rather than pretending the conversion rate is 0%.

The formulas use common Excel and Google Sheets syntax with commas as separators; your locale may require semicolons. Expand the bounded ranges deliberately as the file grows. Check your actual sheet with the fictional rows before importing real data.

For overdue follow-ups, add an optional helper column M. This formula ignores Won and Closed rows and returns a blank when no follow-up date exists:

=IF(OR(G2="Won",G2="Closed",I2=""),"",IF(I2<TODAY(),"Overdue","Scheduled"))

It flags dates before today, not later today. For a reproducible test of the worked example, temporarily replace TODAY() with DATE(2026,10,18). R005 should be Overdue; R002 and R004 should be Scheduled. Restore the live date function after testing if that is how you want to work.

5. Reconcile money without turning the tracker into an accounting system

Update collected amounts from actual payment evidence, not from an offer's headline price or an invoice total. A $1,800 package on a payment plan does not produce $1,800 of collected cash the moment the client signs. An invoice can also be issued without having been paid.

If the money detail becomes complex, maintain a separate Payments tab with LeadID, payment reference, event date, currency and signed amount. Record refunds as negative events linked to the original payment. Reconcile the resulting lead totals back to the summary instead of repeatedly typing an ever-changing number without a source.

Keep cohort reporting separate from calendar-period cash reporting. “September referrals generated $1,400 net through October 18” is not the same statement as “we collected $1,400 during September.” The first selects people by enquiry date; the second selects transactions by payment date. Label the report so you cannot accidentally compare the two.

Do not combine currencies in one unlabelled money total. Separate them or use a documented conversion policy appropriate to your accounting. This template is management information, not tax, financial or legal advice. Your accountant's records remain authoritative for formal reporting.

6. Review follow-up and partner quality once a week

Give the tracker an owner, even when the owner is you. In a short weekly review, reconcile new enquiries against your inbox and forms, merge duplicate introductions, inspect overdue actions and check that current statuses reflect actual events.

For R005, the decision is not automatically “send another reminder.” First check whether the person asked for contact, whether you already followed up elsewhere and whether another message is appropriate. Then take the action or close the enquiry accurately. A red date should prompt judgment, not chasing.

Once a month, review each source by enquiry count, suitable enquiries, held calls, paying clients and net collected to the stated cutoff. If you use “suitable” as a metric, define it in advance, such as a need within your scope and a genuine interest in the offered format. Do not equate suitability with willingness to buy an expensive package.

In the example, P01 and P02 each produced two September enquiries and one paying client. Their net collected differs, but one refund and a tiny sample do not establish which relationship is better. Look at fit, elapsed time and your actual delivery economics before redirecting effort.

7. Thank the referrer without sharing the client's business

Acknowledgement can strengthen a relationship without becoming a report about the referred person. Where an acknowledgement is appropriate and consistent with the person's wishes, keep it minimal:

“Thank you for thinking of my coaching work. I appreciate you sharing my details. I will let anyone who contacts me decide whether a conversation is useful, and I keep individual enquiries private.”

Do not send partners a shared workbook containing names, payments or reasons for declining. A referral relationship does not automatically grant access to a prospect's decision, session attendance or progress. Your internal analysis can help you invest in relationships without becoming partner-facing disclosure.

If you want to pay for introductions, stop treating this as a simple unpaid tracker. Check whether the arrangement is permissible and suitable, agree the rules and establish the necessary disclosure and privacy boundaries first. Our guide to coaching referral fees addresses that decision; a separate affiliate payout statement explains approved balances after appropriate terms exist.

When should a coach stop using a referral spreadsheet?

Keep the spreadsheet while one person can maintain it reliably and reconcile it to the source records. Reconsider when several people update different copies, enquiries disappear between channels or a status means something different in every file. There is no universal lead count at which a spreadsheet stops working.

Before changing tools, decide which record owns the contact, source, next action and payment evidence. Avoid maintaining two independent versions of the same follow-up task. Keep an analytical export if useful, but do not rely on it as a second live inbox that nobody consistently checks.

The Coachful screens in this article show real demo surfaces for prospects, intake information, invoices and communication. They do not prove automatic synchronization with this workbook, automatic referral attribution, commission calculations or partner reporting. Test the particular handoffs you need rather than assuming those connections exist.

Frequently asked questions

Can I use this in Excel or Google Sheets?

Yes. The layout is ordinary tabular data, and the example formulas use common functions available in both. Check your locale's formula separator, real-date handling, dropdowns and protected ranges. Test the example results before adding real prospect information.

Should every referred person get a separate row?

Every distinct enquiry gets a row. Repeated messages about the same enquiry update that row. Maintain a separate documented rule for returning clients or new engagements, and use the LeadID to detect accidental duplicates.

What is a good coaching referral conversion rate?

This article establishes no industry benchmark. Define your numerator, denominator and cutoff, then compare genuinely comparable cohorts within your practice. Five enquiries are too few to support a confident forecast, and recent enquiries may not have had time to decide.

Should I share the tracker with referral partners?

Not the internal file by default. It may expose personal and commercially sensitive information. Share only information that is appropriate for an agreed purpose and basis, and keep private coaching records separate from referral administration.

Build a tracker you can actually trust

Start with your next five real introductions, not five years of historical guesswork. Give each enquiry one row, verify the source where possible, record a responsible next action and reconcile the outcome. A small accurate file is more useful than a crowded sheet that makes every relationship look successful.

If you want to inspect the source-record and communication surfaces before choosing where those actions should live, try the interactive Coachful demo. Follow one dummy enquiry from the prospect record to the relevant intake, invoice and message. Keep the spreadsheet only for the analysis it genuinely adds.

Research note: Direct-query results for referral tracking spreadsheets include Referral Rock's manual tracker and Introzy's referral workbook. They demonstrate the established manual-tracking format, not coaching conversion benchmarks. The template, definitions, examples and calculations above are original editorial guidance.