Referral-Only Agent KPI Dashboard Template For Monthly Referral Income
If you're a referral agent KPI person, you already know the hard part isn't sending a referral. It's tracking what happens next, and predicting what you'll actually get paid.
A Referral-Only Real Estate Agent can run a simple, flexible business, but income can feel "lumpy." One month looks great, then nothing closes for weeks. A KPI dashboard fixes that because it turns your referrals into a clear pipeline with math behind it.
Below is a copy/paste-friendly dashboard template you can rebuild in Google Sheets, Excel, or Notion, plus benchmarks, a glossary, an income forecast, and real examples.
What to measure (and what to ignore) in a referral-only model
Traditional real estate KPIs can waste your time here. You don't need "doors knocked" or "buyer consults held." You need numbers that tell you three things: volume, conversion, and timing .
Start with these categories:
- Referral flow : How many new referrals you sent, and where they came from.
- Pipeline health : How many are active, what stage they're in, and whether they're moving.
- Conversion : Your referral-to-close rate, plus close rates by source and by partner agent.
- Income quality : Average referral fee per close (gross and net), not just total dollars.
- Speed : Days from intro to close, because time is a hidden cost.
Also, keep your license compliance visible. If you're staying active while not selling, track renewal dates and CE deadlines in the same system. State rules differ, so use your state's official guidance (for example, Utah's active license renewal overview shows how specific renewal windows can be).
If you're new to the model, Direct Connect's Referral Agent FAQs can help clarify how referral-only work typically flows, including payout timing and common fee structures.
Track net referral income , not just gross referral fees. Fees and splits don't feel "small" when your pipeline is thin.
Copy/paste KPI dashboard template (monthly, pipeline, partners, forecast)
Use four tabs: Monthly Summary, Referral Pipeline, Closed Deals, Partner Scorecard. Keep the stages consistent so your reporting stays clean.
Tab 1: Monthly Summary (top-line KPIs)
Paste this table, then add one row per month.
| Month | New Referrals Sent | Active Referrals (End of Month) | Closed Referrals | Referral-to-Close % | Gross Referral Fees ($) | Brokerage/Platform Fees ($) | Net Referral Income ($) | Avg Days Intro-to-Close | Rolling 3-Mo Net Avg ($) |
|---|---|---|---|---|---|---|---|---|---|
| 2026-01 | 4 | 6 | 1 | 25% | 2,800 | 399 | 2,401 | 54 | 2,401 |
| 2026-02 | 3 | 7 | 0 | 0% | 0 | 0 | 0 | 0 | 1,201 |
| 2026-03 | 5 | 8 | 2 | 40% | 6,200 | 798 | 5,402 | 47 | 2,601 |
Key formulas (adjust column letters to your sheet):
- Referral-to-Close %:
=IFERROR(D2/B2,0) - Net Referral Income:
=F2-G2 - Avg Days Intro-to-Close: calculate from Closed Deals tab (see below) using
AVERAGEIF - Rolling 3-Mo Net Avg:
=IF(ROW()<4,H2,AVERAGE(OFFSET(H2,-2,0,3,1)))
Tab 2: Referral Pipeline (every referral, one row each)
This is where you earn your predictability. The "Weighted Expected Income" column is the heart of the forecast.
| Referral ID | Date Sent | Source | Client Type | State/Market | Receiving Agent | Stage | Stage Prob. | Expected Close Month | Expected Referral Fee ($) | Weighted Expected Income ($) | Next Touch Date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| R-2026-014 | 2026-03-02 | Past Client | Seller | Tampa, FL | J. Smith | Consult Set | 35% | 2026-04 | 3,000 | 1,050 | 2026-03-18 |
| R-2026-015 | 2026-03-05 | CPA Partner | Buyer | Austin, TX | K. Lee | Under Contract | 80% | 2026-04 | 2,400 | 1,920 | 2026-03-20 |
Suggested stage probabilities (edit to fit your history):
- Introduced: 10%
- Connected: 20%
- Consult Set: 35%
- Active Search/Prep: 50%
- Under Contract: 80%
- Closed: 100%
- Lost: 0%
Key formula:
- Weighted Expected Income:
=J2*H2
Tab 3: Closed Deals (for clean reporting)
| Close Date | Referral ID | Source | Receiving Agent | Side | Sale Price ($) | Receiving Agent Gross Commission ($) | Referral % | Referral Fee ($) | Brokerage/Transaction Fee ($) | Net to You ($) | Days Intro-to-Close |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 2026-01-28 | R-2025-112 | Sphere | J. Smith | Sell | 410,000 | 10,250 | 30% | 3,075 | 399 | 2,676 | 58 |
| 2026-03-22 | R-2026-006 | Attorney | K. Lee | Buy | 365,000 | 9,125 | 25% | 2,281 | 399 | 1,882 | 42 |
Helpful formulas:
- Referral Fee:
=G2*H2 - Net to You:
=I2-J2 - Avg commission per close (gross):
=IFERROR(SUM(I:I)/COUNT(I:I),0)
Tab 4: Partner/Referrer Scorecard (who earns your attention)
If you need a new receiving agent in a market, use a trusted directory instead of guessing. Direct Connect agents can reference the Referral Agent Directory to connect with licensed referral partners and networks.
| Partner Name | Partner Type | Referrals Sent (90 Days) | Closings (90 Days) | 90-Day Close Rate | Avg Net per Close ($) | Update Speed (1-5) | Notes | Next Action Date |
|---|---|---|---|---|---|---|---|---|
| J. Smith | Receiving Agent | 4 | 1 | 25% | 2,676 | 4 | Strong comms, steady follow-up | 2026-03-25 |
| CPA Partner | Referrer | 2 | 0 | 0% | 0 | 5 | Needs simple handoff script | 2026-03-28 |
Key formulas:
- 90-Day Close Rate:
=IFERROR(D2/C2,0) - Avg Net per Close:
=IFERROR(Total_Net_From_Partner/Closings,0)
KPI glossary, monthly benchmarks, forecast totals, and update routine
KPI glossary (plain-English definitions)
Use these definitions so you stay consistent month to month.
| KPI | Definition | Why it matters for referral-only |
|---|---|---|
| New Referrals Sent | Count of referrals you formally sent this month | Your "top of funnel" activity |
| Active Referrals | Referrals not marked Closed or Lost | Your true workload and future income |
| Referral-to-Close % | Closed referrals divided by referrals sent (same period or cohort) | Measures quality of your pipeline |
| Gross Referral Fees | Total referral fees earned before any brokerage fees | Shows deal size and mix |
| Net Referral Income | Gross referral fees minus platform or transaction fees | What hits your bank account |
| Weighted Expected Income | Expected referral fee multiplied by stage probability | Your monthly income forecast |
| Days Intro-to-Close | Days from referral sent date to close date | Helps set realistic cash timing |
Recommended monthly targets (ranges, not rules)
Benchmarks vary by market and network size. Still, ranges keep you honest:
- New referrals sent : 1 to 6 per month
- Intro to connection rate : 60% to 90% (client responds and engages)
- Referral-to-close rate : 10% to 30%
- Under contract to close : 70% to 95%
- Average net per close : $750 to $3,500 (depends on price point and referral %)
- Time to close : 30 to 90 days for many buyers, 45 to 120 for many sellers
Stay compliant while you build. Sponsorship and license status rules are state-specific. For example, Texas outlines sales agent sponsorship basics on the official TREC licensing page.
Also, referral fee rules can be regulated by state law, so confirm what's allowed where you operate. One example resource is Minnesota's statute section on real estate brokerage matters.
Income forecast (monthly) from the pipeline
Add this small table below your pipeline or on a Forecast tab:
| Expected Close Month | Sum of Weighted Expected Income ($) | Notes |
|---|---|---|
| 2026-04 | 2,970 | Mostly from Under Contract and Consult Set |
| 2026-05 | 1,200 | Early-stage referrals, watch movement |
Formula idea:
- Sum by month:
=SUMIF(Pipeline!I:I,"2026-04",Pipeline!K:K)
Monthly checklist to update your dashboard (10 minutes)
- Update each referral's stage and next touch date .
- Enter any new referrals, even if they feel "too early."
- Move closed deals into Closed Deals, then verify net matches your deposit.
- Mark "Lost" referrals quickly so your forecast stays real.
- Refresh Partner Scorecard counts for the last 90 days.
- Scan your rolling 3-month net average, then set next month's referral target.
Two short examples (so you can see the math)
Example 1: Past client seller referral
You send a seller referral with a $3,000 expected referral fee. It's at "Consult Set" (35%). Your weighted expected income is $1,050. If it closes and your transaction fee is $399, net becomes $2,601. That one relationship can cover months of license costs.
Example 2: CPA partner buyer referral
A CPA introduces a buyer who goes "Under Contract" fast. Expected referral fee is $2,400 at 80%, so weighted expected income is $1,920. Even before it closes, your forecast already shows what that lead is worth.
Conclusion
A referral-only business shouldn't feel like guessing. When you track the right numbers, your pipeline starts to act like a calendar, not a lottery ticket. Build your dashboard once, update it monthly, and let your referral agent KPI view guide where you spend your attention next. The fastest win is simple: keep stages current, keep net income visible, and keep partner performance on record.
Recent Posts
