Quick answer

You can track a small referral program for free with unique partner codes, a form or checkout field that captures the code, and a spreadsheet that records each referral’s status and reward. Test the path from link to approved sale before inviting partners. Use software when volume, recurring commissions or multiple systems make manual reconciliation unreliable. Google Analytics and UTM tags can describe traffic; they do not settle commission disputes by themselves.

Referral tracking has one job that matters financially: show which person introduced an eligible customer and what reward the agreement owes. Counting clicks is easier, but a click is not a customer. A simple system can work if the rules are clear and someone reconciles it. A sophisticated dashboard can fail if it cannot explain a payout.

Write the reward rule before choosing a tracker

Decide who can refer, which customer actions count, whether existing customers qualify, how long credit lasts and what happens after a refund or cancellation. If two people refer the same buyer, whose introduction wins? When is a reward pending, approved and paid? Put these decisions in terms participants can read. The tracking setup should reflect the agreement, not invent a different rule after a dispute.

Choose an event you can verify. An accepted lead may suit a service business; a paid, non-refunded order may suit a store. A recurring reward requires rules for renewals and cancellation. If you cannot see the event in your order system or CRM, a referral link alone will not make it payable. The site’s attribution examples explain why a recorded touch and an approved commission can differ.

Set up a free tracker in a spreadsheet

For a low-volume program, use two sheets: Partners and Referrals. Keep customer contact details in your CRM or order system and use internal IDs in the shared tracker. Limit edit access to the person who approves rewards.

Sheet Minimum fields Why they matter
Partners Partner ID, display name, code, accepted terms version, reward rule, status, payout method reference Connects a code to an eligible participant and the terms in force.
Referrals Referral ID, partner ID, customer/order or CRM ID, event date, source, status, qualifying value, reward, approval date, payout batch, reversal reason Lets you explain and reconcile each promised reward.

Use unique codes that do not reveal private information. Create a link such as https://example.com/offer/?ref=partner42, or issue a distinct coupon or introduction code if the buying journey is offline. Your site or form must capture the code when the person acts; a spreadsheet cannot infer it later. Record the code with the order or lead ID, then import only the fields needed for reward review.

Do not calculate rewards from a raw click count. Review each referral against the written rules, mark it pending or rejected with a reason, then approve it when the qualifying event is final. At payout, compare the approved total with the payment batch and mark the payment date. Keep the original record when a reward is reversed so the adjustment has a trail.

Understand what each tracking method can prove

Method Useful for Limit
Unique referral link or code Connecting a visit or order to a partner identifier. May be lost across devices, redirects or manual sales unless carried into the final record.
Coupon code Identifying a promotion at checkout. Can be shared beyond the intended partner; set a conflict rule.
CRM introduction record Tracking a lead through a long B2B sale. Needs duplicate-account and ownership rules.
UTM parameters and GA4 Grouping campaign traffic for analysis. Do not by themselves define an earned reward or verify payment.

You can use more than one method, but choose one commission record as the source of truth. The site’s UTM guide shows how campaign labels fit alongside partner tracking. A self-reported “How did you hear about us?” answer can help investigate a missing referral; it should not silently override the agreement.

Test a real-looking referral before launch

  1. Create a test partner. Assign a unique code and record the terms.
  2. Use the link on a test device. Check the landing page and any redirect. Verify the code survives to the form or checkout.
  3. Complete the qualifying action. Confirm the order or CRM record stores the right partner ID once.
  4. Try an exception. Test a duplicate buyer, expired window or refund according to your rules.
  5. Reconcile the reward. Compare the pending and approved amount with the order or lead record and the payout list.

Repeat the test after changing a landing page, form, redirect or checkout. A link that still opens the right page can lose its referral parameter along the way. If tracking uses cookies or other device data, check the applicable privacy and consent requirements for your market and implementation.

Know when the free approach has run out of room

A spreadsheet is cheap because a person does the reconciliation. Move to suitable software when the same manual errors recur, partners need timely status access, one customer can trigger several commission events, or referrals pass through multiple checkout and CRM systems. Compare the cost of software with the time spent correcting mistakes and explaining payouts. The site’s tool-upgrade guide gives a fuller migration checklist.

Do not buy on the promise of “fraud prevention” without testing your own cases. Self-referrals, coupon sharing and duplicate accounts need explicit rules and review. IP matches alone can be innocent, and a tracking cookie cannot establish a person’s identity. A useful tool records the evidence and lets an authorized person decide.

Frequently asked questions

How can I track referrals for free?

Give each partner a unique code, capture it on the order or lead, and keep a spreadsheet of partner IDs, referral IDs, qualifying status, reward decisions and payouts. Test the full path before inviting partners.

Can Google Analytics 4 track referral commissions?

GA4 can help analyze referral traffic and conversions you configure, but campaign data does not by itself establish a payable commission. Use your program terms and order or CRM records to approve rewards.

What is the difference between a referral link and a coupon code?

A link can carry a partner identifier when someone visits; a coupon identifies a promotion when entered at checkout. Both can be shared or lost in different ways, so define which one receives credit when they conflict.

What fields should a referral tracking spreadsheet include?

Record partner ID, code, terms version, referral and customer or order ID, event date, status, qualifying value, reward, approval date, payout batch and any reversal reason. Keep unnecessary personal data out of the sheet.

When should I replace a spreadsheet with referral software?

Move when recurring manual errors, multiple systems, subscription rewards or partner reporting needs make reconciliation unreliable. Test candidate software against your real payout and exception cases.

How do I prevent duplicate or self-referrals?

Define eligibility in the program terms, match referrals against existing customer or account records, and review suspicious cases before approval. Keep an audit trail; a shared IP address or tracking cookie alone is not conclusive proof.