How To Build A Simple Referral Tracker Spreadsheet In Google Sheets

If you're a referral tracker spreadsheet person, you don't need fancy software to stay organized. You need a clean system that answers three questions fast: Where did this referral come from, what's happening now, and did I get paid?

That matters even more if you're a Referral-Only Real Estate Agent . You're not chasing showings or writing contracts, but you still need tight records for follow-ups, referral agreements, and thank-you rewards.

The good news: Google Sheets can act like your "paper trail," without becoming another job.

Start with a single tab named Referrals . Keep the columns simple enough to fill out in under a minute, but detailed enough to prevent "Wait, what happened with this one?" later.

Here's a practical schema you can copy as your header row (Row 1):

A quick compliance note: referral rules can vary by state, so it's smart to check your state's licensing guidance and your brokerage policy. For example, New Jersey has a helpful overview in the NJ Referral Agent licensing FAQs, and Texas explains referral-focused models through its TREC guidance on referral businesses and LFROs.

If you're building a referral-based business under a brokerage model, it also helps to understand how referral fees are handled and paid; see the referral-only real estate agent FAQs.

Create a new Google Sheet, then rename Sheet1 to Referrals .

Next, set up the basics so your sheet stays usable once you have 50 to 200 referrals logged.

1. Paste the column headers into Row 1.
2. Freeze the header row: View → Freeze → 1 row
3. Add filters: Data → Create a filter
4. Format key columns:
   • Dates (Date Received, Expected Close Date, Paid Date): Format → Number → Date
   • Currency (Est. Referral Fee, Reward Amount): Format → Number → Currency

Click the Status column cells (for example, J2:J), then:

• Data → Data validation → Add rule
• Criteria: Dropdown
• Add these values (keep them in this order):
  • New
  • Contacted
  • Converted
  • Reward Due
  • Paid

Tip: "Converted" can mean the receiving agent confirmed the client is active and moving forward (for example, under contract). "Reward Due" is a nice checkpoint for when you want to send the thank-you.

Select O2:O, then:

• Data → Data validation → Add rule → Dropdown
• Values: Yes , No

In A2 (Referral ID), paste this formula:

=IF(B2="","", "R-"&TEXT(B2,"yymmdd")&"-"&TEXT(ROW()-1,"0000"))

Then fill it down for as many rows as you want.

Because IDs shouldn't change, lock them in:

1. Select column A (starting at A2).
2. Copy.
3. Paste values only: Edit → Paste special → Values only

Your first entries might look like this:

Add a second tab named Summary . This becomes your "one look" page.

In Summary, you can create labels in Column A and formulas in Column B:

• Total referrals logged (B2)
  =COUNTA(Referrals!A2:A)
• Active referrals (not Paid) (B3)
  =COUNTIF(Referrals!J2:J,"<>Paid")
• Referral fees paid this month (B4)
  =SUMIFS(Referrals!L:L,Referrals!J:J,"Paid",Referrals!M:M,">="&EOMONTH(TODAY(),-1)+1,Referrals!M:M,"<="&EOMONTH(TODAY(),0))
• Unpaid rewards total (B5)
  =SUMIFS(Referrals!N:N,Referrals!O:O,"No",Referrals!J:J,"Reward Due")

That last number is the one that keeps your reputation clean. If it creeps up, you know what to handle next.

On the Summary tab (for example, starting in A8), paste:

=SORT(QUERY(Referrals!A1:O,"select C, count(A), sum(L) where C is not null and J='Paid' group by C label count(A) 'Paid Deals', sum(L) 'Paid Referral Fees ($)'",1),2,false)

This outputs a tidy table: referrer name, how many paid deals, and total paid fees.

On the Summary tab (for example, starting in E8), paste:

=QUERY(Referrals!J1:J,"select J, count(J) where J is not null group by J label count(J) 'Count'",1)

Anywhere on Summary, paste:

=FILTER(Referrals!A:O,Referrals!J:J="Reward Due",Referrals!O:O="No")

Conditional formatting (color that tells the truth):

• Select the full data range (A2:P).
• Go to Format → Conditional formatting .
• Add rules like:
  • "Text is exactly" Reward Due (apply to range J2:J), set a yellow fill.
  • "Text is exactly" Paid , set a light green fill.
  • "Date is before" Today for Expected Close Date (K2:K) and use a light red fill, then follow up with the agent.

Protect your formulas and headers:

• Protect Row 1 and your Summary formulas: Data → Protect sheets and ranges
• This helps if you ever share the sheet with an assistant or partner.

Lock down dropdown consistency:

• In each data validation rule, turn on "Reject input" so typos don't create fake statuses.

A simple referral tracker spreadsheet is like a receipt folder for your referral business. It keeps stories from turning into guesses. Once your columns, dropdowns, and Summary formulas are in place, your sheet becomes a lightweight system you can trust.

Set aside 30 minutes, build it once, then keep it updated after every intro and every status change. Your future self will thank you, and your rewards due list won't sneak up on you.