How to track referral revenue without trusting someone else's spreadsheet

If you're in a referral arrangement where the closing agency sends you a monthly report, you're tracking referral revenue — but you're not verifying it. The difference matters as soon as the closing agency has any incentive to undercount, which is always.

The answer to tracking referral revenue is simple to state: attribution must be tied to a verifiable, third-party event — specifically, a paid invoice in a system neither party controls. Everything else is faith dressed up as tracking.

Here's why the most common setups fail, and what needs to be in place before they don't.

Why spreadsheets and informal reports break down

The most common tracking setup is this: the closing agency runs a monthly report, calculates what they owe you, and sends a number. You compare it to your own estimate, decide if it looks roughly right, and invoice them.

This works fine if you trust the closing agency completely and their bookkeeping is accurate. It falls apart in four specific scenarios.

When the client is on a payment plan. Revenue-share on MRR sounds straightforward — 10% of what the client pays each month. But clients don't always pay on time. If the closing agency reports "$2,000 paid this month" but the client paid $1,000 and owes the rest, you get half the referral fee with no way to verify what happened to the other half.

When a client pauses or cancels. A 12-month revenue-share agreement requires knowing when the client stops. If the closing agency reports cancellation in month seven but the client was actually active through month nine, two months of fees disappear into the gap between their internal records and your access to them.

When scope changes. Revenue-share agreements define what the fee applies to. If the closing agency upsells the client — adds a new service, shifts the retainer structure — whether that incremental revenue is in scope depends on the agreement language. Without an independent record of what the client is actually paying, you can't verify whether the report reflects the right baseline.

When the relationship gets strained. The closing agency has a recurring financial obligation to you on a client they now manage entirely. At some point, their incentive is to minimize what they report. This doesn't require bad faith — rounding, exclusions, administrative lag — but the result is the same: your payout tracks their internal decisions, not objective payment events.

None of these scenarios require dishonesty to cost you money. They just require that the closing agency's reporting be your only source of truth.

What an auditable trail actually requires

An auditable referral trail has three components.

1. Attribution tied to a paid invoice, not a closed deal.

This starts in the agreement. The fee trigger should be a payment event — specifically, the date the client's invoice is paid — not the deal closing, the proposal being signed, or the closing agency's estimate of when to send you money. A well-written referral agreement names the trigger explicitly, because "when the deal closes" and "when the invoice is paid" can be weeks apart and carry very different implications for your first payout.

Once the trigger is defined as a payment event, attribution becomes verifiable: did the payment happen? When? What was the amount? Those are facts that exist in a payment processor or accounting system, independent of either party's claims.

2. An independent source of payment data.

If the closing agency's report is the only record, you're back to honor-system tracking. An auditable trail requires access to a payment record neither party can edit unilaterally.

In practice this looks like one of the following:

• Shared accounting access. The closing agency grants you read access to the client's invoice history in their accounting software. You can see what was invoiced, what was paid, and on what dates. You don't need access to anything else.
• Payment processor notifications. If the closing agency uses Stripe or a similar processor, payment success events can be sent to a shared log — a dashboard or simple spreadsheet import — that both parties can see.
• A platform in the middle. Instead of two agencies exchanging reports, a partner network handles the routing, tracks the client relationship, and ties payouts to actual payment events. Neither party depends on the other's honesty; the platform's record is the single source of truth. How agencies share leads and split revenue covers how this model works in practice.

3. A log that captures changes over time.

Clients upgrade, downgrade, pause, and cancel. If your revenue-share applies to MRR for 12 months, the monthly baseline can change. An auditable trail logs those changes — not just what the client pays today, but what their payment history looks like across the full term of your agreement.

Without this, the closing agency's report for month eight can claim the client downgraded in month five, and you have no way to verify or dispute it.

The structural problem with self-reporting

Asking the closing agency to report the revenue they owe you a cut of is asking someone to score their own exam. They might do it accurately. But the incentive is wrong, and when there's ambiguity in the agreement, they'll tend to resolve it in their own favor — not necessarily out of malice, but because that's how incentive structures work.

Agency partnership revenue-share models lays out why MRR rev-share at 10–20% for 12 months is usually the right structure for retainer referrals. But the math only works if you can verify what the other party reports. Whether you receive $3,600 or $2,800 over 12 months on a $2,000/month client at 15% depends entirely on what the closing agency says the client paid each month — unless you have access to something more objective.

Use the revenue split calculator to model what each structure pays out over your cap period before agreeing to terms. The point is not just to check whether the deal is fair — it's to understand exactly what you're tracking and for how long.

Before the lead changes hands

The right time to set up tracking is before you refer anyone.

The lead-sharing agreement template is the right starting point: it defines the fee trigger as a payment event, the fee structure, the cap period, and the non-circumvention clause. What it doesn't do is build you an independent data feed — you still need to decide how you'll access payment records.

If you're routing leads to a partner you trust and don't want to build out a payment integration, at minimum: get the fee trigger in writing as a specific payment event, agree on a shared source of invoice records, and set a monthly reporting cadence both parties sign off on. That's a minimum viable audit trail — not perfect, but substantially better than waiting for the closing agency's email and assuming the number is right.

For more on the specific clauses that prevent payout disputes before they start — including the non-circumvention language that stops a closing agency from restructuring the engagement to eliminate your fee — see what a marketing agency referral agreement actually needs.

If you're routing multiple leads through the same partner, or want to stop managing this manually, the structural answer is a platform that handles attribution for you. Neither agency has to trust the other's bookkeeping because payment events are recorded in a system both parties can see.

The first referral arrangement is usually fine on faith. It's the third month, or the second partner, where informal tracking starts to cost you money.