Reconciling commission when forty carriers pay forty ways
Carrier commission is reconciled by building an expected figure from the policy book and testing every statement against it, because booking whatever the deposit was makes an underpayment indistinguishable from revenue. This is an illustrative example set in a brokerage holding around forty carrier appointments.
Scenario — an illustrative example of how Salt approaches this problem. Not a description of a specific client engagement.
The business shape it describes: US insurance brokerage, ~40 carrier appointments.
- Scenario covers
- Bookkeeping and monthly carrier commission reconciliation
- Software it assumes
- QuickBooks Online
- Jurisdiction
- United States
- Sector
- Insurance
- The brokerage holds appointments with around forty carriers. Each sends a commission statement in its own format, on its own schedule, at its own level of detail.
- Some business is direct bill, where the carrier bills the insured and pays commission to the agency. Some is agency bill, where the agency collects the premium and remits it net of commission.
- Commission is recorded from the bank deposit. Nobody tests the deposit against what the policies in force should have produced.
- Where commission is booked from deposits, an underpayment becomes the recorded revenue. There is no second figure available to disagree with it.
- Renewal commission is the usual gap. A carrier stops paying on a policy still in force and nothing in a deposit-driven ledger registers the absence.
- Producer splits are calculated from the same unverified number, so a carrier shortfall passes straight through to the producer.
- Agency-bill premium sitting in the operating account is a separate problem. It is not the agency's money, and states set rules on how premium held in a fiduciary capacity must be handled.
- The policy book would be exported from the agency management system and turned into a policy-level expectation: carrier, effective date, premium, commission rate, and whether the item is new business or a renewal.
- Each carrier statement would then be matched against that expectation, oldest period first, so a carrier's pattern of underpayment is visible before the current month is touched.
- Unmatched lines would be split three ways: rate applied incorrectly, policy paid late, policy not paid at all. Only the third is worth raising with a carrier; the first two usually resolve on the next statement.
- Producer splits would be recalculated on the corrected figures, with the split percentage recorded against each transaction rather than remembered.
- Agency-bill premium would be separated from operating cash in the ledger, so the fiduciary balance is a number the principal can read rather than infer.
- Month-end would close with a commission reconciliation: expected, received, variance, and a named reason for every variance above a threshold the brokerage sets.
- Forty carriers means forty statement formats, and the only way to test them is to build the expected figure from the policy book first. Without it, the deposit is the sole number available.
- This is reconciliation discipline rather than a view on the policies themselves. It needs someone willing to read every statement line rather than tie to the bank and move on.
- The brokerage would be able to state, each month, what commission it expected, what arrived, and what the difference is attributable to.
- Producer splits would be defensible, because the split percentage and the underlying commission are both recorded at transaction level.
- Renewal commission that stops arriving would surface in the month it stops, rather than whenever somebody happens to notice.
What we'd flag
Carriers do not all accept a historic correction; some will adjust only going forward, so identifying a shortfall is not the same as recovering it. Salt holds no carrier appointments and does not contact carriers on an agency's behalf. The dispute is raised by the brokerage, from the schedule we prepare.
Reconciling commission when forty carriers pay forty ways
Recognise this shape in your own books?
Tell us where you trade and what shape the books are in. You get scope, price and a start date in writing within one business day — no obligation.