Commission splits decide how lead ROI shows up in your numbers. The carrier pays according to the split on the turn-in sheet, so the agent who worked a lead only gets credit for the policy if the sheet says so, whoever signed the application. To make lead ROI measurable, write split rules down, record the split and the lead source on every turn-in, check that the shares add up to 100%, and match issued policies back to those records by ID.
Most agencies get this half right. The splits pay people correctly, more or less, but nobody can tell you what a lead vendor returned. This how-to walks through the setup in the order we'd build it.
Why do commission splits decide lead ROI?
Picture an agent who buys leads every month out of their own pocket. Sooner or later they ask a fair question.
"Now he's like, well, if I'm spending it, I want to know how much I'm making." — Kevin Beeftink, founder of RevEngine
To answer it, you match the commission an agent earned to the leads that agent paid for. That match runs through the carrier commission statement. The statement lists the client and the amount paid to each agent, based on the split on file. If a policy doesn't appear on the statement of the agent who worked the lead, the lead spend looks like it returned nothing.
"It doesn't matter who writes it. What matters is how they do the turn in sheet..." — an agency principal we work with
The writing agent on an application is often whoever was licensed for the product or ran the closing appointment. In a team that uses appointment setters, junior agents or a specialist closer, that person is often not the one who bought and worked the lead. The turn-in sheet is where you record what happened.
A worked example: one policy, three ROI numbers
Say Agent A buys 40 leads at $50 each, so $2,000. A works the list for three weeks. Three policies come out of it:
- Policy 1: A closes it. First-year commission of $700.
- Policy 2: A closes it. First-year commission of $500.
- Policy 3: A books the appointment, Agent B runs it and writes the application. First-year commission of $900.
The table shows how the commission split on Policy 3 changes what A's lead spend appears to return:
| Policy 3 split on the turn-in sheet | Commission on A's statement | Return on A's $2,000 |
|---|---|---|
| B 100%, A 0% | $1,200 | $0.60 per dollar |
| A 50%, B 50% | $1,650 | $0.83 per dollar |
| A 100%, B 0% | $2,100 | $1.05 per dollar |
The vendor and the leads are the same in all three rows. In the first row, A looks like they lost 40 cents on every dollar and might drop a vendor that is breaking even on first-year commission alone. Policy 3 sits on B's statement, and B didn't buy any leads, so nobody connects it to the vendor.
The right split depends on your agency's rules. Some agencies give the closer a share, some pay the closer a flat fee, and some credit the full policy to the agent who worked the lead. For ROI, the rule has to be written down and applied the same way every time. Add a lead source field to the turn-in sheet as well, so the vendor still gets credit for Policy 3 even when a split is shared.
How to set up commission splits so lead ROI is measurable
- Write the split rules. Cover the common cases: one agent works the lead and another closes, a joint appointment, a referral from another agent, a policy for a spouse of an existing client. One page is enough.
- Put the split, the lead source and the CRM contact ID on the turn-in sheet. Every submission gets all three, plus the application number. The turn-in sheet is the only place where the CRM contact and the policy meet.
- Log each turn-in as a pending record in one ledger. Use one sheet for all agents and append every new turn-in to it with an automation. The record stays pending until the policy is issued, because a submission is not yet issued business and nobody has been paid.
- Check that the shares add up before you submit. A formula on the turn-in sheet that sums each policy's shares catches most errors before the carrier ever sees them. More on this below.
- Match issued policies back to the ledger. When the issued-policy report or commission statement arrives, match on application or policy number first. Use names only as a fallback, and mark those matches as lower confidence. This matching is the core of commission reconciliation.
- Calculate ROI per lead source and per agent from each agent's share. Add up commission by lead source across all agents, and by agent using only their share. Compare each to what was spent, and put both views in your monthly production report.
- Show each agent their own share. Let them check it against their statement before every agent payout. Agents raise disputes early, while they still remember the details.
How to flag split shares that don't add up
Split errors are common, and they cost money in both directions. An agent keys 70% when the agreement was 50%, two agents each submit the same policy, or someone forgets a line entirely. You catch these by summing the shares for each policy and flagging anything that isn't 100%.
"...has a 70% share and a 50% share, totals 120. That doesn't make sense. So, something doesn't add up in this line." — Kevin Beeftink, founder of RevEngine
For a policy paying $1,000 in commission, each kind of error does this:
| What you see | Example | What it does to your numbers |
|---|---|---|
| Shares over 100% | 70% + 50% = 120% | Reports $1,200 earned on a $1,000 policy. Risk of overpaying agents. |
| Shares under 100% | 50% + 30% = 80% | $200 that no agent is credited with. Someone will ask where it went. |
| Duplicate line | Same policy entered twice at 100% | Doubles the policy count and the commission. |
| Agent not on roster | Share assigned to a former agent | Commission lands with nobody you can pay or report on. |
| Turn-in sheet differs from statement | Sheet says 50/50, statement pays 100/0 | Either the sheet is wrong or the carrier record is. Find out which. |
In a spreadsheet, add a column with SUMIF on the policy number to total the shares per policy, then a second column that flags anything not equal to 100. Run it every week on new turn-ins and again on each statement. Count split policies as fractions when you report volume. A 50/50 policy is half a policy for each agent, so the agency total still adds up to one.
Keep flagged rows in a review queue and tell people plainly that you can't report on them yet. A short list of "we can't price this until the data is fixed" builds more trust than a total that turns out wrong.
What each agent should see
Each agent should see three things for every policy they're on: the client, their share and who they share it with. They don't need the full book or anyone else's commission.
That rule is the reason commission data usually doesn't belong in your CRM. As soon as you type commission amounts into contact records, someone has to decide who can see whose numbers, and most CRMs aren't built for that. A separate system with clear visibility rules handles it better. Agents see their own policies and shares, managers see their team, and the principal sees everything.
Showing agents their split also gets errors fixed faster. An agent who sees "your share: 30%, shared with Agent B" on a policy they wrote alone will tell you within a day. Monthly visibility also cuts the end-of-quarter arguments about who wrote what.
If your agency is on Medicare Advantage or Part D business, remember that CMS sets the rules on agent and broker compensation that plans pay. A split divides that compensation between agents. The total stays the same.
Why name matching only gets you partway
Most agencies start by matching names on the commission statement to names in the CRM. It's a reasonable first pass, and it links some of your policies. Then it stalls on cases like these:
- Nicknames and legal names: "Bob" in the CRM, "Robert J." on the statement.
- Married names, hyphenated names and name changes after a divorce.
- Spouses: the lead came in under one spouse, the policy is in the other's name.
- Typos and truncation, especially on carrier statements with short name fields.
- Two clients with the same name.
Fuzzy matching adds a little, and it brings false matches you then have to check by hand. The fix is the CRM contact ID and the application number on the turn-in sheet, recorded at submission. Then the issued policy matches on a number, and the name is only a sanity check. If you have turn-in sheets going back a few years, export them all into the ledger. Older policies then match too, and your coverage grows without anyone retyping data.
Expect name matching to leave a large share of issued policies unlinked. Report the coverage rate next to every ROI figure, so readers know how much of the book the number covers.
Contribution vs attribution
Even with clean splits, be honest about what you can prove.
"My concern still is: I can show you contribution. I can't show you attribution." — Kevin Beeftink, founder of RevEngine
Contribution means a lead source, a seminar or an agent touched clients who later bought something. You can show that with name matching and a date range. Attribution means you can trace a specific policy and its commission back to a specific lead source through a recorded link: the turn-in sheet with the contact ID and the application number.
The difference matters when you decide where to spend. If a vendor "contributed" to $20,000 in commission, some of those clients might have bought anyway through a referral. If the turn-in records show the vendor's leads produced the policies, you can cut or grow the spend with confidence. Until your turn-in ledger covers most issued policies, call the report a contribution report and say so in the heading.
What to do this week
- Write your split rules on one page and send them to every agent.
- Add lead source, CRM contact ID and application number to your turn-in sheet as required fields.
- Export your past turn-in sheets into one ledger and set up an automation that appends new ones.
- Add a
SUMIFcheck that flags any policy whose shares don't total 100%. - Match last month's commission statements to the ledger and note your coverage rate.
For the monthly side of this, see our month-end reconciliation walkthrough, and for split policies that cancel early, our post on how carriers recover commission after an early cancellation. To compare lead vendors once the numbers line up, Kevlex has a guide to insurance lead sources compared.
RevEngine reports on what your agency earns, checks that carriers paid what they owed, and finds opportunities in your existing book. See how agencies use RevEngine or book a RevEngine demo to walk through your own statements.
