“The new reports are here.” How I’d build insurance commission tracking for a small agency.

Why is commission tracking so hard?

Commission tracking is hard because carrier commission statements don’t share a standard layout. Some arrive as PDFs, some as Excel files, some as CSV files. Each carrier names its columns differently and lists groups its own way.

Then the splits. One group’s commission might be split between two producers and the agency. Those rules usually live in a spreadsheet, or in one person’s head.

What do most agencies try first?

Most agencies try a commission tracking spreadsheet with a tab per carrier and someone careful to type the statements in each month. For a few carriers, that works.

The spreadsheet breaks when a carrier changes its statement layout, when you add carriers, or when splits change. The person who built it becomes the only one who can read it. And the question that matters, “Did every group pay what it should have?”, gets checked when someone has time, which is rarely during renewal season.

Wanna fix it?

Commission tracking gets fixed with an agent that reads the carriers’ commission statements, a master list of splits for every producer and the agency, and a person who approves the payouts before any money moves.

1. Collect the statements in one place. Every carrier’s master commission report goes into one folder, whatever format it arrives in.
2. Write the split list once. One master list of every group and how its commission splits between the producers and the agency.
3. Keep a list of what you expect. Every active group, its carrier, and roughly what it should pay each month. That’s what turns tracking into commission reconciliation.
4. Ask for the reports. When the statements land, you tell the agent, “Hey, the new reports are here. Give me the individual reports for the producers.”
5. Approve before anyone gets paid. The agent drafts each producer’s report and flags anything that doesn’t match: a missing group, a short payment, a group that paid twice. A person reviews it and approves the payouts.

What would it look like once it’s running?

Once it’s running, commission day would start with the statements landing and one request to the agent. Out would come a report for each producer showing their groups, what each carrier paid, and their share, plus a short list of lines that need a human.

The person who used to type statements would spend that time on the exceptions: calling a carrier about a missing payment, or fixing a split that changed. Since I haven’t built it, I can’t give you hours saved. The closest thing I have running is my enrollment platform’s deduction report, which already stores premiums by product and group. That’s a natural starting point for the expected pay list.

Can you do this yourself?

Yes, with a well built commission tracking spreadsheet. Give it these columns: carrier, group, month, premium, commission rate, expected commission, commission paid, difference, producer, and split. Sort by the difference column every month and chase anything that isn’t zero.

The spreadsheet stops working when the typing takes longer than the checking. Two carriers and one producer, use the spreadsheet. A dozen carriers and a handful of splits, have an agent read the statements. If you’d rather buy, AgencyBloc sells a commissions module that says it imports carrier statements and handles splits.

Quick answers

What is insurance commission tracking?

Recording what each carrier paid, by group, and who at the agency gets what share.

What is commission reconciliation?

Checking what carriers actually paid against what you expected, and chasing the differences.

What goes in a commission tracking spreadsheet?

Carrier, group, month, premium, rate, expected commission, paid commission, difference, producer, and split.

Why are carrier statements hard to combine?

There’s no standard layout. They come as PDFs, Excel files, or CSV files with different column names.

Should an agent pay producers automatically?

No. The agent drafts the reports. A person approves the payouts.

Has DoBetter built this?

Not yet. Chris Cordon would build it from the carriers’ statements and a master split list.