How to Track Insurance Agent Commissions (Without Spreadsheets)

By Chris Keller

Every insurance agency owner reaches the same tipping point.

At some point — usually somewhere between two and five producers — the commission spreadsheet that used to be “fine” starts costing you real money. Rates get entered wrong. Splits get missed. Renewals get paid at new-business rates. You catch some of it. You don’t catch the rest.

If you’re at that tipping point, or you just want to understand how commission tracking should actually work in an insurance agency, this guide walks through the whole thing: what data you need to capture on every sale, how the calculations actually work, and how to move off spreadsheets without breaking anything.

What “tracking commissions” actually means in an insurance agency

For agencies outside insurance, “tracking commissions” usually means one thing: rep sold something, rep gets a percentage. Simple.

Insurance is not that.

Real commission tracking in an insurance agency has to handle at least four moving parts on every policy:

1. 1. Premium written — the total premium the client is paying.
2. 2. Commission earned by the agency — the percentage the carrier pays your agency, which varies by carrier, product line, and often by tenure.
3. 3. Commission owed to the producer — a share of what the agency earned, which depends on the producer’s contract, whether it’s new business or a renewal, whether there’s a split, and whether there are overrides in play.
4. 4. Payout timing — some carriers pay commission monthly, some quarterly, some in advance, some as-earned. That timing determines when the producer actually gets paid.

If your current tracking system doesn’t handle all four cleanly, you have two problems: you don’t know what your producers are owed, and you don’t know what your agency is actually making.

The data you need to capture on every sale

At minimum, every policy your agency writes should be logged with:

• Client name and policy number
• Carrier
• Product line (personal auto, homeowners, commercial GL, life, whatever)
• Premium written (in dollars)
• Effective date
• New business or renewal
• Producer(s) of record (with split percentages if multiple)
• Agency commission rate (from the carrier)
• Producer commission rate (from the producer’s contract)
• Any overrides (agency principal or team lead overrides)

That’s the minimum. If you have a house book, split producers, or shared accounts, you’ll also need to track who owns what percentage of each account long-term.

Most agencies capture some of this in their AMS (Applied, Vertafore, EZLynx, HawkSoft) and some in a spreadsheet, and the spreadsheet is where the errors happen.

The three methods agencies actually use

There are effectively three ways insurance agencies track commissions today. Each has trade-offs.

Method 1: Spreadsheets

The default. Every agency starts here. Someone builds an Excel file, columns for the fields above, and enters every deal by hand. Formulas calculate commission owed.

Pros: cheap, familiar, flexible.
Cons: error-prone, no real-time visibility, doesn’t scale past a few producers, one accidental cell edit can wreck a month, no audit trail, no permissions (either everyone sees everything or someone becomes the bottleneck).

Most agencies outgrow this by their third producer. Many stay in it anyway, which is what actually costs them money.

Method 2: AMS reports plus manual reconciliation

Some agencies use their AMS’s built-in commission reports (Applied, Vertafore, and EZLynx all have some version) and then reconcile against a spreadsheet at the end of the month.

Pros: fewer manual entries; some data comes automatically.
Cons: AMS commission modules are notoriously clunky, they don’t handle custom producer splits well, and reconciliation still happens in a spreadsheet — which means you inherit all of Method 1’s problems on top of AMS licensing costs.

Method 3: Purpose-built commission software

Software designed specifically to track sales, calculate commissions, and give producers and owners the right dashboards.

Pros: real-time, handles complex splits and overrides, producer/owner separation baked in, audit trail, no formula errors.
Cons: another tool to learn, monthly cost.

If you’re comparing your current spreadsheet setup to purpose-built software, there’s a full breakdown in 5 reasons insurance agencies are moving off commission spreadsheets.

Step-by-step: how to move from spreadsheets to software

If you’ve decided the spreadsheet has to go, here’s the order of operations. Skip a step and you’ll spend the next quarter cleaning up data.

Step 1: Export what you have.

Pull your existing commission spreadsheet and your last 12 months of policy data. You don’t need pristine data — you need historical context so you can spot-check the new system.

Step 2: Define your commission rules before you enter a single policy.

This is the step agencies rush. Slow down. Write down:

• Every carrier and the commission rate for each product line
• Every producer’s contract terms (new business rate, renewal rate, splits, overrides)
• Any house book rules
• Any special arrangements (loans against commission, salary offsets, etc.)

If you don’t have these written down anywhere, you’re not alone — most agencies don’t. But you can’t automate commission tracking against rules that only exist in your head.

Step 3: Set up producer profiles.

Every producer gets a profile with their contract terms. Once set, calculations happen automatically for every deal they write.

Step 4: Reconcile against your last full month.

Before you go live, take the most recent complete month, enter every deal from that month into the new system, and compare the calculated commissions to what you actually paid. Any discrepancies are either (a) your old spreadsheet was wrong, or (b) your new rules are set up wrong. Fix both before you launch.

Step 5: Go live and cut off the spreadsheet.

Pick a date. From that date forward, every new policy is entered in the new system only. The spreadsheet becomes a read-only historical archive. Producers get logins the same day so they can see their own numbers in real time.

For a deeper look at what producers should see vs. what stays with the owner, see owner vs. producer dashboards: what each role should see.

Common mistakes agencies make

A few patterns show up in almost every agency that struggles with commission tracking:

• Paying new business rates on renewals. Renewals should almost always be paid at a lower rate. If your current system doesn’t distinguish, you’re overpaying. More on structuring these correctly here.
• Not tracking splits precisely. “It’s roughly 50/50” is not a commission structure. Track exact percentages.
• Skipping duplicate detection. Same policy entered twice = paid twice. Happens more than agencies want to admit.
• Waiting until the end of the month to reconcile. By then, memories are fuzzy and disputes are harder to resolve.
• Not giving producers visibility. Producers who can’t see their own numbers assume they’re being shortchanged, even when they aren’t.

How CommishPulse fits in

CommishPulse was built to handle every one of the requirements above without a spreadsheet in sight. New vs. renewal rates, splits, overrides, carrier-specific rates, producer dashboards, owner-only financial visibility, duplicate detection — all of it, in real time. See pricing.

Frequently asked questions