Short answer: calculate producer splits from the carrier statements you booked, not from deposits or a side spreadsheet. Each month, the split expense in the ledger should equal the sum of each producer's statement, and each producer statement should trace to policy lines on the carrier statements.
Where splits go wrong
- The split sheet lives outside the books, so nobody checks it against booked revenue.
- Producers are paid on new and renewal business at different rates, and the rate table is out of date.
- Chargebacks on cancelled policies are never clawed back from the producer.
- House accounts get paid out as if a producer owned them.
The monthly tie out
- Start from booked revenue. Export the month's carrier statement lines with policy number, carrier, line of business, new or renewal, and commission.
- Assign each line. Map each policy to its producer from the agency management system. Unassigned lines are house business.
- Apply the agreement. Apply each producer's written split rates, including any chargeback clause.
- Build the producer statement. One page per producer: policies, commission, rate, split, chargebacks, net due.
- Tie to the ledger. Total of all producer statements equals the producer commission expense booked for the month. Any difference gets explained before payroll runs.
- Track the ratio. Producer commission as a percent of commission revenue, by month. A jump means a rate, a mapping or a chargeback problem.
What this protects
Overpaid splits are hard to recover from a producer who has left. A monthly tie out catches errors while they are one month old, and gives each producer a statement they can check.
Want a second set of eyes on your file? Consultgenix runs the books for independent P&C agencies in Miami-Dade, Broward and Palm Beach. Book a free 30 minute file review at consultgenix.com. You leave with a written scope and a fixed monthly price.
