Referral Tracking Spreadsheet for Lawyers
Most lawyers know referrals are their best source of clients. Almost none of them track referrals systematically. They have a vague sense that “Bob sends me a few cases a year” but can’t tell you exactly how many, what kind, what they were worth, or whether they sent anything back to Bob.
This is a problem because you can’t improve what you don’t measure. And because the single most effective way to get more referrals is to nurture the sources who already send them — which you can’t do if you don’t know who they are.
Here’s a referral tracking system you can set up in any spreadsheet in 15 minutes.
The Referral Tracking Template
Create a spreadsheet with these columns. Every referral that comes in gets a row.
Column Definitions
| Column | What to Enter | Why It Matters |
|---|---|---|
| A: Date Received | Date the referral contacted you | Track seasonal patterns and response time |
| B: Referred By (Name) | Full name of the referring person | Your most important data point — who sends you work |
| C: Referrer Type | Category: Attorney, CPA, Past Client, Financial Advisor, Doctor, Friend/Family, Other | Identify which categories produce the most referrals |
| D: Referrer Firm/Company | Their organization | Helps track organizational vs. personal relationships |
| E: Prospect Name | Name of the person referred to you | Track the individual matter |
| F: Case Type | Practice area category | See which referrers send which types of cases |
| G: Consultation Date | Date you met with the prospect | Measure time from referral to consultation |
| H: Outcome | Signed / Declined by Firm / Declined by Prospect / Pending | Track your conversion rate on referrals |
| I: Reason if Declined | Why you or they didn’t proceed | Identify patterns — are you getting wrong-fit referrals from certain sources? |
| J: Revenue | Fee earned (or estimated) from the case | Calculate the dollar value of each referral source |
| K: Thank You Sent | Yes / No + date | Never forget to thank a referral source |
| L: Thank You Type | Email, handwritten note, gift, lunch, phone call | Vary your appreciation — don’t send the same email every time |
| M: Reciprocal Referral Given | Yes / No + details | Track whether you’re reciprocating — relationships are two-way |
| N: Notes | Any relevant context | ”Bob mentioned they’re retiring next year,” “Second referral from this source this quarter” |
Sample Data
| Date | Referred By | Type | Firm | Prospect | Case Type | Consult | Outcome | Revenue | Thank You | Reciprocal |
|---|---|---|---|---|---|---|---|---|---|---|
| 1/15 | Sarah Chen | Attorney | Chen Family Law | James R. | Estate Plan | 1/18 | Signed | $3,500 | Handwritten 1/20 | Sent PI case 2/3 |
| 1/22 | Mark Davis | CPA | Davis & Co. | Lisa M. | Business Formation | 1/25 | Signed | $2,800 | Lunch 2/1 | Not yet |
| 2/3 | Tom Wilson | Past Client | — | Andrea K. | Estate Plan | 2/7 | Declined - Conflict | — | Email 2/4 | N/A |
| 2/14 | Sarah Chen | Attorney | Chen Family Law | Robert P. | Trust Admin | 2/19 | Signed | $5,200 | Gift basket 2/20 | — |
How to Analyze Your Referral Data
Once you have three to six months of data, the analysis is straightforward.
Top Referral Sources Report
Sort your spreadsheet by “Referred By” and count referrals per source. Then calculate total revenue per source.
| Referral Source | Total Referrals | Signed Cases | Total Revenue | Avg. Case Value |
|---|---|---|---|---|
| Sarah Chen | 6 | 5 | $22,400 | $4,480 |
| Mark Davis | 3 | 2 | $5,600 | $2,800 |
| Tom Wilson | 2 | 1 | $3,200 | $3,200 |
This tells you where to invest your relationship-building time. Sarah Chen is worth a quarterly lunch and a holiday gift. She’s your most valuable referral source.
Referral Source by Category
| Category | Referrals | Signed | Revenue | % of Total Revenue |
|---|---|---|---|---|
| Attorneys | 14 | 10 | $45,000 | 55% |
| CPAs | 6 | 4 | $15,000 | 18% |
| Past Clients | 8 | 5 | $12,000 | 15% |
| Financial Advisors | 3 | 2 | $8,000 | 10% |
| Other | 2 | 1 | $2,000 | 2% |
Now you know that attorneys generate 55% of your referral revenue. That tells you where to focus your networking time.
Conversion Rate by Source
Track what percentage of referrals from each source actually become clients. If Bob sends you ten referrals a year but only two are good fits, that’s a 20% conversion rate. If Jane sends you three but all three sign, that’s 100%. Jane’s referrals are higher quality — she understands your practice better. Consider having a conversation with Bob about what kinds of cases you’re looking for.
The Quarterly Referral Review
Block 30 minutes every quarter to review your referral data. Here’s the checklist:
Quarterly Review Process
- Count total referrals received this quarter — up, down, or flat vs. last quarter?
- Identify your top 5 referral sources by volume and revenue
- Check thank-you column — did you thank every referral source within one week? Any gaps?
- Review reciprocal referrals — are you sending work back to your top sources? If not, why?
- Identify dormant sources — anyone who used to refer but hasn’t in 6+ months? Reach out.
- Check conversion rates — any sources consistently sending poor-fit referrals? Have a conversation about your ideal client profile.
- Calculate cost per referral — what did you spend on relationship maintenance (lunches, gifts, events) divided by referrals received? Compare to your cost per lead from advertising.
- Plan next quarter’s outreach — schedule lunches, send notes, or make calls to your top 10 referral sources
- Identify new potential referral sources — anyone you met this quarter who could become a referral partner?
The Thank-You System
This is where most lawyers fail. They get a referral, handle the case, and never acknowledge the source. Here’s a simple system:
Within 48 hours of receiving a referral: Send a thank you. The method should escalate with the value and frequency of the relationship.
| Referral # from Source | Thank You Method |
|---|---|
| First referral ever | Personal phone call + handwritten note |
| 2nd-3rd referral | Handwritten note |
| 4th+ referral (established source) | Quick email or text + quarterly lunch |
| Every 5th referral | Gift (bottle of wine, gift card, something personal) |
| End of year | Holiday gift to all sources who sent 2+ referrals |
Important: Check your jurisdiction’s ethics rules on referral fees and gifts. Most states allow reasonable thank-you gifts to referral sources but prohibit paying referral fees to non-lawyers. A $50 bottle of wine is fine everywhere. A $500 referral bonus may not be.
Making It Stick
Add referral tracking to your intake process. The question “How did you hear about us?” should be mandatory on every intake call and web form. Don’t accept “Google” or “the internet” as an answer — dig deeper. “Did someone recommend us specifically, or did you find us through a search?” The difference between a Google organic lead and a word-of-mouth referral matters for tracking purposes.
Update the spreadsheet weekly. Set a 10-minute recurring calendar event every Friday to update your referral tracker. If you let it pile up, you won’t do it.
Share insights with your team. If associates or paralegals handle intake, make sure they know to capture referral source information and enter it in the tracker. The data is only as good as the capture.
The law firms that get the most referrals aren’t the ones that passively hope for them. They’re the ones that track every referral, thank every source, and systematically nurture the relationships that generate their best clients. This spreadsheet is the tool. The discipline to use it is on you.