Track Introductions and Follow-Ups Before You Build a Referral CRM

Tom — Singapore Digital Business & Systems Consultant

Tom

Digital Business & Systems Consultant · Singapore

7 min read Article date First published
Track Introductions and Follow-Ups Before You Build a Referral CRM

For a few introductions, you do not need a CRM. A simple referral tracking spreadsheet, or a notebook page, shows every follow-up at a glance: one row per introduction, with the business type instead of a name, the permission date, what you shared with consent, the introduction date, the next step and who owns it, and a status. Keep a possible commission apart from a payment actually received. Software helps when several people update the same records every week; for a referrer, that is rare.

Key takeaways

  • One row per introduction, with no names, numbers or chats in the sheet.
  • Every open row has one next step and one owner, usually not you.
  • Six statuses are enough, from asked to project confirmed.
  • Only money in your account goes in the payment column.
  • Delete rows you no longer need, but keep a record of any payment you receive.

Why a sheet comes before a CRM

A CRM suits a business with many enquiries, staff and repeat customers; my guide on whether SMEs need a CRM covers that job. A referrer's job is smaller: remember who agreed to what, see what happens next, and chase nobody.

If you keep a weekly note of requests you hear, keep it separate. That note has no names; a row here starts only once an owner has raised a need and you have offered an introduction.

Record only what is necessary

Write a business type, such as "home bakery", instead of the owner's name. Their number already sits in your phone or the chat where they said yes, so do not copy it into the sheet.

Singapore's PDPC advisory guidelines say the PDPA's Data Protection Provisions "do not apply to business contact information", but that term excludes details "provided by the individual solely for his or her personal purposes". A small business owner's mobile can be both. This is not legal advice; the simple habit is to keep no contact details in the sheet.

Never add passwords, logins, customer lists, anything exported from the owner's systems, private chats or screenshots, a home address or identity numbers, even if offered.

Delete rows you no longer need: after a no, no reply, or an introduction that ended with no project, once you have noted what you learned.

Track permission, the next step and who owns it

The permission column is your note of the owner's yes: the date, the channel, what they agreed you could share and whether you mentioned a possible referral fee. If the yes was spoken, a short confirming text gives you both a record. Asking permission before an introduction covers that conversation.

Every open row gets one next step with one name beside it, usually the owner's (deciding) or mine (the call and proposal). As how my referrals work explains, your part is the introduction; then you step back.

Status definitions

StatusWhat it meansWhat you do
AskedThe owner raised a need; you offered an introductionWait; if it is a no or no reply, delete the row
Permission givenThe owner said yes and chose what you may shareIntroduce us, or send them my website
IntroducedYou connected us, or the owner has my detailsStep back
In discussionThe owner and I are talking: a call or a proposalNothing; the owner decides
No projectThe owner decided not to go ahead, or to waitDelete the row when you no longer need it
Project confirmedThe owner has agreed a project with meCheck the terms; this is not a payment

Change a status only when the owner or I tell you. If unsure, ask me rather than pressing the owner.

Separate possible commission from confirmed payment

Two columns stop wishful thinking. Possible commission is a note about the terms, never an amount: "not checked", "asked; service listed" or "none: no project". Payment received stays blank until money is in your account.

Commission is not guaranteed. The referral programme page sets out the current terms, including when an introduction has directly contributed to a project, and how introductions are recorded: there is no referral code or link, and my dated written reply is the record. Your sheet is a memory aid, not the record that decides a payment, so read those terms, including who can take part, before relying on it.

Project confirmed is not payment received. Fill in the payment column from your bank record, never from expectation.

If a payment arrives, record the date, amount received, payer and which row it relates to, by business type, in a payment record kept apart from the sheet. IRAS's page on keeping proper records and accounts says: "You should keep proper records and accounts for 5 years so that the income earned and business expenses claimed can be readily determined." It adds: "Estimates and improper records are not acceptable." How that applies to you is for IRAS to confirm. The payment record needs no owner details, so trimming the row does not affect it.

Example: Geraldine's sheet

Geraldine, a homemaker, sells handmade cards at weekend markets (fictional example). She messaged me her questions about the terms before her first introduction. Then three owners she knows asked about website help. In your own spreadsheet, the labels on the left become column headings; here they run down the side to fit a phone.

ColumnRow 1Row 2Row 3
Business (type only)Tailoring shopHome bakeryTuition centre
Permission given2 Sep, spoken, confirmed by text; fee mentioned10 Sep, WhatsApp; fee mentioned20 Oct, WhatsApp; fee mentioned
Shared, with consentName, shop name, shop number, needName, bakery name, business email, needCentre name, office number, need
Introduced3 Sep, WhatsApp group12 Sep, WhatsApp21 Oct, WhatsApp group
Next step (who)None; project with BusinessWithTomDelete row (Geraldine)Discovery call (owner, BusinessWithTom)
StatusProject confirmedNo projectIn discussion
Possible commissionAsked; service listedNone: no projectNot yet known
Payment receivedNoNoNo

Row 2 ended with no project: after my call with her, the owner decided her Instagram page was enough for now. No commission for about half an hour of Geraldine's time, and a friendship left as it was. She deleted the row.

Row 1 is confirmed, but its payment column stays no until money arrives; whether a payment follows depends on the programme terms, not on her sheet. Row 3 could end either way. Updating the sheet takes her minutes.

When structured software becomes useful

For a referrer, rarely: a handful of rows that only you update fits in one spreadsheet. Software starts to make sense when tracking is part of running a business:

  • Several people update the same records.
  • One workflow repeats every week: enquiry, quote, job, invoice.
  • Details are copied by hand between chats, sheets and invoices.
  • You need to see who changed what, and when.

If that describes your own business, operations digitalisation is my service for it: a custom web app that replaces a WhatsApp-and-spreadsheet workflow, with a central database, role-based access, reports and a dashboard, scoped and quoted as a separate project.

Sources (checked 31 October 2026)

Frequently Asked Questions

Do I need a CRM for three introductions?

No. A one-tab spreadsheet or a notebook page with one row per introduction is enough. Software helps when several people update the same records every week.

How do I avoid treating every contact as a lead?

Start a row only when an owner has raised a need and you have offered an introduction. If someone says no or does not reply, delete the row and do not follow up.

Should I put the owner's phone number in the sheet?

No. Write the business type and leave the number in your phone or the chat where they agreed. Never add passwords, customer lists or private chats.

Does a confirmed project mean I will be paid?

Not necessarily. Commission is not guaranteed and depends on the current programme terms, so fill in the payment column only when money is in your account.

How long should I keep each row?

Delete it once you no longer need it, such as after a no or a no-project ending. Keep any payment record separately; IRAS says to keep records for five years.

Is your own business tracking enquiries, jobs and follow-ups across chats and spreadsheets every week? Message me to talk through whether a sheet is still enough or a simple system would help. For a handful of referral introductions, the sheet above is all you need.

No obligation. No sales pitch. Just an honest conversation.

お問い合わせ