How to Track Referrals When You Don’t Use a CRM

How to track referrals without a CRM: Use a simple spreadsheet or notebook with five columns: who sent the referral, the client name, what the job was, whether it closed, and what you owe. Review it once a month. That is the whole system, and for most solopreneurs it is more than enough.

Most Solopreneurs Do Not Use a CRM, and That Is Fine

I have been self-employed for over a decade. I have tried three different CRMs during that time. Each one lasted about six weeks before I stopped logging in.

It was not that the software was bad. It was that my business does not work the way CRMs are designed to work. I do not have a “sales pipeline” with stages and conversion rates. I have a guy named Dave who texts me when he has an HVAC install that needs ductwork, and a wedding photographer who emails me when a bride asks for a videographer recommendation.

If that sounds like you, you are not alone. Most solopreneurs and small service businesses operate on some combination of text messages, phone calls, and memory. A CRM built for a 20-person sales team is overkill for someone who gets five to ten referrals a month.

The problem is not that you need a CRM. The problem is that you need some system. Because right now, you are probably losing track of referrals, forgetting who sent what, and leaving money on the table.

The Notebook and Text Message Method

Let me be honest: I ran my referral tracking on a spiral notebook and text messages for years. And it worked. When someone sent me a lead, I would scribble the name, the job, and who referred them in whatever notebook was closest. When I closed the job, I would text the referrer a thank-you and settle up however we had agreed.

When this works

• You get fewer than five referrals a month
• You have two or three referral partners, not twelve
• Your referral arrangements are informal and reciprocal (no fees changing hands)
• You have a good memory and a habit of checking your notebook regularly

When this breaks down

• Volume picks up. Once you are juggling eight or ten open referrals across five different partners, a notebook page turns into a mess of crossed-out names and question marks.
• Money is involved. The moment referral fees enter the picture, you need a record that both sides agree on. A text message you sent three months ago that you cannot find anymore is not that record.
• You forget to follow up. A referral partner sends you a lead. You are busy. You write it down but never check back. The lead goes cold, and the partner stops sending you work because they think you dropped the ball.
• You cannot see the full picture. Who sends you the most work? Who have you not reciprocated with lately? Which referrals actually turned into paying jobs? A notebook does not give you these answers without flipping through months of pages.

If any of that sounds familiar, it is time to upgrade. Not to a CRM. Just to a spreadsheet.

A Simple Referral Tracking Spreadsheet

Here is the spreadsheet I used for years before switching to a dedicated tool. It lives in Google Sheets, it takes five minutes to set up, and it does everything a solopreneur actually needs.

The columns

1. Date. When you received the referral. This is important for follow-up timing and for reviewing your monthly activity.
2. Referred by. The name of the person or company who sent you the lead. If you are tracking outbound referrals too (leads you sent to someone else), add a column for “Referred to” as well.
3. Client name. The customer who was referred. This is your lookup key when someone asks “whatever happened with that lead I sent you last month?”
4. Job description. A quick note on what the work was. “Kitchen remodel estimate,” “engagement photo session,” “logo redesign.” Keep it short.
5. Status. I use four values: Open (lead received, not yet contacted), In Progress (talking to the client), Closed-Won (job booked or completed), Closed-Lost (did not work out). You can use whatever terms make sense for your business.
6. Job value. What the job was worth. This matters when referral fees are a percentage. Even if there is no fee arrangement, tracking value helps you understand what your referral network is worth to your business.
7. Fee owed. The referral fee amount, if any. If you have a 10% arrangement and the job closed at $3,000, this column says $300.
8. Fee paid. A checkbox or date field. Once you pay (or collect) the fee, mark it. This is how you avoid the “did I already pay them for that?” conversation.

That is eight columns. You can start with fewer. But I would not go below what I call the minimum viable referral record.

The Minimum Viable Referral Record

If eight columns feels like too much, here is the absolute minimum you need to track for every referral that involves money or a business relationship you want to maintain:

1. Who sent it (or who you sent it to)
2. What the job was
3. Whether it closed
4. What you owe (or what is owed to you)

Four data points. That is it. If you track nothing else, track these. They answer the two questions that matter most: “Am I being fair to my referral partners?” and “Am I getting paid for the value I am creating?”

A handyman I know tracks this in the Notes app on his phone. A wedding photographer friend uses a single Google Sheet tab. A freelance designer I worked with used a Notion table for a while. The tool does not matter. The habit of recording every referral does.

How often to review

Once a month is the right cadence for most solopreneurs. Set a recurring reminder on the first or fifteenth of each month. During your review:

• Update the status of open referrals. Did the lead convert? Did it go cold?
• Check for unpaid fees, both directions. If someone owes you, follow up. If you owe someone, pay them before the end of the week.
• Look at the balance of your referral relationships. If someone has sent you four leads this month and you have sent them zero, make it a priority to find them a lead soon.

This monthly review takes fifteen minutes at most. It is the single most valuable habit for keeping your referral network healthy. (For more on why tracking and reciprocity matter, see how one solo handyman built a referral network over 15 years.)

What This Looks Like Across Industries

The basics are the same everywhere, but the details vary depending on what you do and how your referrals flow. Here are three real examples from people I know.

HVAC contractor

Mike is a solo HVAC tech who gets most of his work from general contractors and home inspectors. His referral tracking is a Google Sheet with about 40 rows in it at any given time. He tracks who sent the lead, the homeowner name, the job type (install, repair, maintenance), the value, and whether he owes a fee.

His referral fee arrangements are simple: 10% to the GC or inspector who sent him the job, paid within two weeks of collecting from the homeowner. He reviews his sheet every other Friday when he does his invoicing. Because his jobs are typically $2,000 to $8,000, even a few referrals a month add up to meaningful fee obligations in both directions.

The challenge Mike ran into was tracking outbound referrals: jobs he could not take because he was booked solid, so he passed them to other HVAC techs. He was sending real work to other people and not getting credit for it. Once he added an “Outbound” tab to his spreadsheet with the same columns, he started collecting fees on jobs he would have given away for free. (This is the exact problem described in what to do when you get more HVAC calls than you can handle.)

Wedding photographer

Jess is a wedding photographer who gets referrals from planners, venues, and florists. Her referral world is different from Mike’s because wedding bookings are larger ($3,000 to $6,000) and the referral relationships are longer-term. A planner who likes her work might send her five to eight couples a year.

She tracks everything in a single spreadsheet tab, one row per referral. Her columns include the planner or venue name, couple name, wedding date, package value, referral fee percentage (usually 10% to 15%), and whether the fee has been paid. She reviews it quarterly rather than monthly because her booking cycle is longer: a referral she receives in January might not result in a wedding (and a fee payment) until October.

The thing Jess found most valuable was being able to look at her sheet at the end of the year and see exactly which planner sent her the most business. That data changed how she allocated her time. She started prioritizing relationships with the planners who actually sent bookings, not just the ones who were friendly at networking events.

Freelance designer

Alex is a freelance brand designer who gets project referrals from copywriters, web developers, and marketing consultants. His referral fees are less common than in trades or weddings: most of his referral partnerships are reciprocal rather than fee-based. But he still tracks them because he wants to make sure the reciprocity is actually balanced.

His spreadsheet has two tabs: “Received” (leads sent to him) and “Sent” (leads he sent to others). Each row has the referral partner’s name, the client, the project type, estimated value, and whether it closed. He reviews it monthly and uses it as the basis for his “relationship maintenance”: if a copywriter has sent him two projects this quarter and he has sent her nothing, he makes a point to think of her the next time a client mentions needing copy.

The key lesson from all three: the tracking system does not have to be sophisticated. It has to exist, and you have to actually use it.

Signs You Have Outgrown DIY Tracking

A spreadsheet or notebook can carry you for a long time. I used mine for about four years before the cracks started showing. Here are the signs that it might be time to look at something more structured:

• You are regularly forgetting to update it. If your spreadsheet is always two weeks behind reality, it is not serving its purpose. The data is only useful if it is current.
• Fee disputes are happening. If you and a referral partner have disagreed more than once about what was sent, what closed, or what is owed, you need a shared record that both sides can see. A spreadsheet on your computer is your record, not theirs.
• You are managing more than ten active referral partners. At this volume, manual tracking becomes a part-time job. You are spending time on data entry that should be going to actual work.
• Referral fees are a meaningful part of your income. If you are earning (or paying out) a few hundred dollars a month in referral fees, the tracking needs to be reliable. A missed $300 fee because you forgot to log a referral is not a rounding error anymore. (This is especially true in trades where fees on cleaning referral arrangements or HVAC overflow work add up fast.)
• You want to know which relationships are actually paying off. A spreadsheet can answer this question, but only if you maintain it religiously. If you want this data without the maintenance burden, a purpose-built tool does it automatically.

None of these signs mean you need a CRM. They mean you need a tool that does one thing well: track referrals between you and your partners, keep both sides on the same page, and coordinate the payment side without awkward conversations.

That is what PureIntro is built for. It is not a CRM: there is no pipeline, no lead scoring, no marketing automation. It just handles the referral workflow: who sent what, what the terms are, whether the job closed, and what is owed. Both sides see the same record, and payment is facilitated when the work is done.

What Matters Is the Habit, Not the Tool

I have seen people track referrals successfully in a notebook, a Notes app, a Google Sheet, and a purpose-built platform. I have also seen people fail with all of those same tools. The difference is never the software. It is whether the person actually records every referral and reviews the data regularly.

If you are running on texts and memory right now, that is okay. You do not need to overhaul everything. Just start with the minimum viable referral record: who sent it, what the job was, whether it closed, what you owe. Write it down every time. Look at it once a month. That alone will save referrals you are currently losing and strengthen the relationships that feed your business.

And when the spreadsheet stops being enough, you will know. The signs are hard to miss.

If you are ready for a simple referral tracking system that replaces the spreadsheet without the overhead of a CRM, see how PureIntro works for home services professionals.

This post reflects one professional’s experience and is for informational purposes only. It is not business, legal, financial, or professional advice. Results described are individual and not guaranteed. Referral fee arrangements may be subject to state and local regulations. Consult a qualified professional for guidance specific to your situation. PureIntro facilitates referral tracking and payment processing but does not guarantee payments between users or any particular business outcome.