TL;DR: A 24-person independent insurance brokerage in Atlanta places business with eleven carriers. Each pays commission on its own schedule, in its own format: three CSVs, five PDFs, two portal downloads, and one that still arrives in the post. The operations principal reconciles them against the agency management system by hand, four days a month. She checks the four largest carriers line by line and spot-checks the rest, because checking all 2,840 policy lines would take three weeks she does not have. An audit of a single quarter found $31,400 in commission underpaid and never queried. We designed a four-stage agent that parses every statement, matches each line against AMS360, flags variances above tolerance, and calculates producer splits. Running cost: $61 to $134 per month.
Eleven Carriers, Eleven Formats
Kathy is the operations principal. On the ninth of the month, the statements start arriving.
Two carriers email a CSV. One emails an Excel file with the totals in a merged cell at the bottom, which is a decision somebody made on purpose. Five send PDFs, one of which appears to have been photographed rather than exported. Two require logging into a portal, selecting a date range, and downloading.
And one still posts a printed statement. It arrives about a week after the others, and Kathy keys it in by hand. Nobody has ever asked them to stop.
She opens AMS360 on one monitor and the statements on the other. Policy number, premium collected, contracted rate, commission paid. Where the four agree, she moves on. Where they do not, she makes a note.
By day three she has worked through the four largest carriers, roughly 70% of the book. The remaining seven she spot-checks: the biggest accounts, anything unusual, anything a producer has already queried. Then she runs the producer splits, because commission is only half the job. Five producers, five different contracts, two of them with separate rates for new business and renewal.
On day four she closes the file and returns to the job she was hired to do.
Last spring a producer questioned a renewal commission on a commercial auto account. Kathy checked. The carrier had paid at 10% on a policy contracted at 12.5%. She queried it, they corrected it, and she went home wondering how long that had been going on.
So she asked the firm's accountant to audit one quarter properly. Not spot-checks. Every line.
$31,400 underpaid across 2,840 policy lines. Some of it was rate errors like the commercial auto account. Some of it was policies that renewed and never appeared on any statement at all. One carrier had been applying a 2023 rate schedule for fourteen months, which nobody had noticed because noticing would have required somebody to read fourteen months of statements in full.
None of it was fraud. All of it was arithmetic.
This is, when stated precisely, a business that audits its own revenue by sampling, on the working assumption that eleven separate companies are all calculating correctly, from rate schedules the brokerage cannot see, at a volume no single person can read. Kathy did not decide to leave 30% of the book unchecked. She got through seven carriers and ran out of month.
The Brokerage
Independent property and casualty brokerage in Atlanta, Georgia. Twenty-four employees: two principals, five producers, six account managers, four service representatives, three claims, two accounting, one marketing, one admin. $4.1M in annual commission revenue on roughly $27M of premium placed. Commercial lines weighted, with a personal lines book carried over from the founder's era.
Eleven carrier appointments. Approximately 2,840 active policies. Statements arrive monthly from eight carriers and quarterly from three, which means that in any given month Kathy is reconciling a different combination of documents from the month before.
Reconciliation takes four days a month: roughly 32 hours. At her loaded cost of $76 per hour, that is $29,184 a year spent checking arithmetic, performed by one of the two people least able to spare the time.
Coverage under the manual process: four carriers checked line by line, seven spot-checked. Approximately 68% of policy lines verified in any given month. The other 32% are, in the kindest interpretation, assumed correct.
The quarterly audit found $31,400 in underpayment across the unverified portion. Annualised, and assuming the audited quarter was ordinary, that is roughly $125,600 of earned commission the brokerage was not collecting. Against $4.1M in commission revenue, a little over 3%.
Two further costs sit alongside it. Producer commission disputes: eleven in the prior year, each taking two to four hours to investigate, several resolved in the producer's favour after a manual recalculation nobody enjoyed. And a clawback nobody saw coming, where a carrier reversed $8,900 of commission on cancelled policies across three statements, netted the reversals against later payments, and thereby made them visible only to somebody reading every line of a document that exists to be filed.
The pattern behind all of it: money already earned, recorded in two systems that never speak to each other, verified by a person doing it between other jobs.
The design is next. The design, the build guide, the running costs and the take-away are free to subscribers. Enter your email below and the rest of this Blueprint opens. New ones arrive every Tuesday and Friday.
