Track Introductions and Follow-Ups Before You Build a Referral CRM
Tom
Digital Business & Systems Consultant · Singapore

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
| Status | What it means | What you do |
|---|---|---|
| Asked | The owner raised a need; you offered an introduction | Wait; if it is a no or no reply, delete the row |
| Permission given | The owner said yes and chose what you may share | Introduce us, or send them my website |
| Introduced | You connected us, or the owner has my details | Step back |
| In discussion | The owner and I are talking: a call or a proposal | Nothing; the owner decides |
| No project | The owner decided not to go ahead, or to wait | Delete the row when you no longer need it |
| Project confirmed | The owner has agreed a project with me | Check 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.
| Column | Row 1 | Row 2 | Row 3 |
|---|---|---|---|
| Business (type only) | Tailoring shop | Home bakery | Tuition centre |
| Permission given | 2 Sep, spoken, confirmed by text; fee mentioned | 10 Sep, WhatsApp; fee mentioned | 20 Oct, WhatsApp; fee mentioned |
| Shared, with consent | Name, shop name, shop number, need | Name, bakery name, business email, need | Centre name, office number, need |
| Introduced | 3 Sep, WhatsApp group | 12 Sep, WhatsApp | 21 Oct, WhatsApp group |
| Next step (who) | None; project with BusinessWithTom | Delete row (Geraldine) | Discovery call (owner, BusinessWithTom) |
| Status | Project confirmed | No project | In discussion |
| Possible commission | Asked; service listed | None: no project | Not yet known |
| Payment received | No | No | No |
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.