Referral Tracking Spreadsheet Template for Business Groups

When a spreadsheet is the right starting point

Use a spreadsheet when your group is small (roughly five to twelve active members), meets at least twice a month, and one person can own data entry without it becoming a second job.

Spreadsheets fail when volume rises, members skip logging, or leaders need conversion metrics without manual pivot tables. At that stage, see referral tracking software—but many groups never get past a disciplined sheet because they skip the template structure entirely.

Start with a template. Discipline beats tooling at the early stage.

Tab 1: Referral log (core template)

Create one row per warm introduction. Do not merge multiple intros into a single row.

Status values (use a dropdown in the sheet):

Keep statuses consistent so monthly reporting is possible:

Every status change should update Last updated. Stalled rows trigger follow-up at the next meeting.

• Requested — receiver asked for an intro; referrer has not sent yet
• Sent — intro delivered to receiver
• Accepted — receiver agreed to pursue
• Declined — receiver passed with reason
• Meeting booked — first conversation scheduled
• Qualified — real opportunity, progressing
• Client — signed work or revenue recorded
• Lost — closed without deal; note why
• Stalled — no movement in thirty days

Tab 2: Published needs register

Referrals without published needs produce vague intros. Maintain a second tab where each member organization lists what they are actively seeking.

Review this tab at every meeting. Pause needs older than ninety days with no activity—they clutter matching.

Tab 3: Monthly summary (leader view)

Leaders should not rebuild reports from scratch each month. Pre-build formulas or a simple pivot:

Share the summary in the group so members see ROI—not just activity.

Spreadsheet maturity: when rows are enough

Weekly workflow: fifteen minutes per meeting

Build spreadsheet maintenance into the meeting agenda so rows stay current:

Assign scribe rotation monthly so one person does not burn out.

• Open with two minutes: any new referrals since last meeting?
• Scribe adds rows live or immediately after—same day, not next week
• Update status on any row marked Stalled
• Close with one number: referrals sent this month, clients signed this quarter

Minimum viable template vs full template

If you choose minimum viable, add columns as soon as members ask "did that intro ever convert?"

Common spreadsheet mistakes

• Logging only sent referrals, not declined or stalled—distorts conversion rate
• Letting one member own the sheet privately instead of shared edit access
• Using free-text status instead of dropdowns—breaks filtering
• No link between needs tab and referral log—cannot prove which needs produce clients
• Celebrating referral count without outcome column—referrers stop when credit never appears

When to graduate from spreadsheet to software

Move to referral tracking software when two or more apply:

Software does not replace discipline—it makes discipline visible to the whole group.

• More than twelve active members or multiple chapters
• Referrals happen between meetings and nobody updates the sheet
• Leaders spend hours consolidating before quarterly reviews
• Members publish needs in chat but log referrals elsewhere
• Referrers regularly ask "whatever happened to that intro?" with no answer