Where does your business actually come from? A simple referral-tracking sheet for owners who hate spreadsheets

You think you know where your customers come from

Ask an owner where their business comes from and you get a confident answer: "mostly word of mouth," or "Google," or "the realtor I work with." Then ask how many paying customers each of those sources produced last quarter and the confidence disappears. I run an SEO agency in Dallas and I have had this conversation with hundreds of owners. Almost none could answer from a record. Most answered from the last two memorable jobs.

The gap matters because every decision about growth depends on it. Whether to renew the ad campaign, whether Thursday lunch at a referral chapter is worth the hours, whether to keep taking the lead-service calls, whether the realtor who sends you three leads a year is a partner or a habit: all of these are questions about source, and without a record you answer them with feeling. I am Mantas Auk, a member of BNI Preston Center, and the sheet described below is the one I wish every owner had before they asked me whether to spend money on marketing.

The U.S. Small Business Administration's marketing and sales guidance says to compare your marketing and sales costs to the revenue they generate, and it admits that some tactics, such as print advertising or word-of-mouth campaigns, are hard to measure. Hard is not impossible. It takes one extra question at the first conversation and one hour a month.

One sheet, one tab, nine columns

You do not need software. A single tab in a spreadsheet, or a page in a notebook ruled into columns, is enough for a business taking fewer than a couple hundred leads a year. If you later outgrow it, you will know exactly what the software needs to do, because you will have run the process by hand. Here is the layout, described so you can build it in ten minutes:

• Date the lead arrived: the day they first called, emailed, walked in or were introduced, not the day you quoted.
• Name and company, enough to find them again.
• Source: the one channel that caused this person to contact you, chosen from a short fixed list that you define once and do not improvise on. Mine is: referral, Google search, Google Business Profile, website form, social media, repeat customer, networking event, paid lead service, other.
• Referrer: when the source is referral, the name of the person who made the introduction. This column is the whole reason the sheet exists.
• Service requested, in a word or two.
• Stage: lead, quoted, won, lost, in the words you already use.
• Value: the amount quoted, replaced by the amount invoiced when the job closes.
• Date closed or lost.
• Notes: one line, including why you lost if you lost.

The source question, and how to ask it so the answer is true

The sheet lives or dies on the source column, and the source column lives or dies on a single question asked at the first contact: "How did you hear about us?" Everyone intends to ask it and most forget, so the fix is to make it impossible to skip. Put it on the intake form, in the phone script, in the first reply template, and on the estimate sheet the technician fills in. If someone else answers your phone, they ask it; a call center such as Karl Haddad's Forward Konnect can build the question into every script, which is how the owner finds out later.

The answer needs a follow-up, because the first reply is usually too vague to use. "I found you online" could mean a Google search, your Business Profile on Maps, a social post or a review site, and those are different decisions for you. Ask one more question: "Do you remember what you searched for, or did someone give you our name?" A surprising share of "I found you online" turns out to be "my neighbor mentioned you and I looked you up," which is a referral that Google confirmed, not a Google lead. Record the referral and note the lookup.

Where there was a referrer, write the name. If you cannot bring yourself to do anything else on this list, do that. The referrer column is what lets you thank the right people and notice who is quietly carrying your business.

What the numbers say that your memory does not

Volume is the figure owners remember and the least useful one. The paid lead service produced forty leads last quarter and the realtor produced three, so the service feels bigger. Then you sort the sheet by source and look at the won column: the service closed two jobs and the realtor closed three. Then you look at value: the realtor's three were full projects and the service's two were the smallest repairs you do. Then you look at the notes and see that the service leads had already called four competitors. One of these sources is the center of your business and it is not the one with forty rows.

Nielsen's 2021 Trust in Advertising study, which surveyed more than 43,000 people in 56 countries, found that 89 percent of respondents trust recommendations from people they know, more than any other channel. The sheet will show you what that trust is worth in your own business: referred leads tend to close at a higher rate, at a higher value and with fewer competing bids.

The other thing the sheet shows is what Google already shows you in a different form. Google's Business Profile performance report counts calls made from the call button, website clicks, direction requests, messages and bookings from your profile, and lists the search terms that surfaced you. That is activity, not customers. Your sheet is where profile activity becomes a row with a stage and a value, which is the only version of the number that pays.

The monthly hour: what to stop and what to double

On the first working day of each month, sit with the sheet for an hour and produce one small table: for each source, how many leads, how many won, total invoiced, and the names of the referrers who appear more than once. Then answer four questions. Which source produced the most closed value for the least cost and effort? Which produced leads that never closed, and why, according to the notes? Which referrers sent more than one lead, and have I thanked each of them this month? What did I spend time on this month that does not appear in the sheet at all?

The decisions follow from the table rather than from the mood of the month. A source with leads and no wins for three months in a row is a candidate to stop, after you check whether the problem is the source or your follow-up. A source with few leads and a high close rate is a candidate to double: more time with that referrer, more one-to-ones with people like them, more of whatever produced it. I compared the two kinds of channel in referral groups versus buying leads; the sheet is how you run that comparison on your own numbers instead of mine.

This is also how our chapter keeps itself honest. Every referral passed is recorded, and when one turns into paid work the receiving member reports it as thank-you for closed business, which BNI's own writing on the value of a chapter seat describes as the yield a membership delivers. Our members have recorded 2,372 referrals in 2026 so far and $3,982,650 in closed business over the past twelve months, which is a tracking sheet kept by seventy people. If you want to see what a room looks like when everyone counts, register on the Visit page and join us on a Thursday at Park City Club, 5956 Sherry Lane, Suite 1700; open networking begins at 11:00 AM.

Where the sheet gets corrupted

The first failure is the growing source list. Someone adds "Facebook" when there is already "social media," then "Instagram," then "neighbor," and within a quarter you have twenty categories and no pattern. Fix the list once, write it on the sheet, and force every answer into it; use the notes column for nuance.

The second is crediting the last touch. A homeowner heard your name from a client of yours, saw your truck, searched for you, read your reviews, then called. The source is the referral; everything after it was confirmation. The sheet should record what started the journey, and the notes can hold what finished it. If you are curious how the confirmation step works and why it leaks referrals when your profile is thin, I covered it in why people find your competitors on Google and in AI.

The third is leaving the value column blank until the job closes. Write the quoted amount at the quote and replace it when invoiced; otherwise the won column fills up and the value column stays empty and the monthly review tells you nothing about money. The fourth is skipping the lost reason. "Lost" alone is useless. "Lost, price, went with a company the realtor also recommended" is a referral strategy in nine words.

What a professional firm tracks differently from a trade

A roofer can run the sheet exactly as described, because the job has a quote and a close date. A CPA, an attorney or an insurance agent needs two adjustments. First, value is annual, so record the expected first-year fee and review it against what was billed at the twelve-month mark. Second, many professional referrals arrive as introductions that take months to become engagements, so add a column for the date of the first substantive meeting; it lets you see how long each source takes to turn into revenue, which is usually the question that decides whether a networking commitment is worth it.

Both kinds of business should record referrals to other people as well as from them. A second small tab, or the bottom of the same page, with the date, the person you referred, whom you sent them to, and whether it closed, is the giving side of the ledger. Over a year it tells you whether your referral relationships are balanced, and it gives you something concrete to bring to a one-to-one with a partner who has gone quiet.

When the notebook stops being enough

The sheet works until it does not: when two people are adding rows, when leads come in faster than anyone records them, or when you want to see the same number sliced by technician, by neighborhood and by month without rebuilding the table each time. That is the point to move to a CRM or to a purpose-built tool, and because you have run the manual version you will know exactly which columns and reports you need rather than paying for a hundred you will never open. A software consultant such as Brandon Turman's Aezion spends much of his time rescuing businesses from spreadsheets that outgrew their owners, and the ones who arrive with a clean nine-column sheet get a far better system than the ones who arrive with a feeling.

Until then, the discipline is the asset, not the tool. An owner who asks the source question every time and reviews the sheet monthly knows more about their business than a competitor with expensive software and no habit.

Start this week, and bring the sheet to lunch

Build the tab today. Tomorrow, go through every lead from the past ninety days you can remember and fill in what you know, leaving blanks rather than guessing. Add the source question to your phone script and intake form by Friday. On the first of next month, do the hour. You will have your first real answer to the question in the title, and it will probably surprise you.

Then bring what you learned to a room where it matters. Our Thursday lunch at Park City Club is full of owners who track exactly this, and the referrer column of your sheet is the best possible preparation for meeting them: you will know who sends you business, which categories are missing from your partner list, and what an introduction is worth to you. Register on the Visit page and come as a guest. You will see seventy tracking sheets in action, hear the thank-yous read aloud, and find out whether a seat in your category is open.

Questions people ask me