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.

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.

Use four tabs: Monthly Summary, Referral Pipeline, Closed Deals, Partner Scorecard. Keep the stages consistent so your reporting stays clean.

Paste this table, then add one row per month.

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)))

This is where you earn your predictability. The "Weighted Expected Income" column is the heart of the forecast.

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

Helpful formulas:

• Referral Fee: =G2*H2
• Net to You: =I2-J2
• Avg commission per close (gross): =IFERROR(SUM(I:I)/COUNT(I:I),0)

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.

Key formulas:

• 90-Day Close Rate: =IFERROR(D2/C2,0)
• Avg Net per Close: =IFERROR(Total_Net_From_Partner/Closings,0)

Use these definitions so you stay consistent month to month.

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.

Add this small table below your pipeline or on a Forecast tab:

Formula idea:

• Sum by month: =SUMIF(Pipeline!I:I,"2026-04",Pipeline!K:K)

• 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.

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.

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.