A Producer Commission Worksheet for P&C Brokerages

Different commercial lines often carry different new-business and renewal rates. List each policy type your agency writes and its rate for both new business and renewal, since a commission plan that treats every policy type identically usually does not match how your carriers actually pay the agency.

Agency-billed policies put your agency in control of collecting premium and paying the carrier, while direct-billed policies have the carrier collecting directly and remitting commission to the agency afterward. This affects payout timing more than plan structure: agency-billed commission can often be recognized sooner, while direct-billed commission has to wait for the carrier's remittance, which both tools can track but neither can speed up.

This is the most contentious line item in most agency compensation plans. Some agencies keep paying a departing producer's trail commission on their existing book for some defined period, others transfer it immediately to whoever now services the account, and some split it during a transition window. Whatever your agency's actual policy is, write it down here, since this is where disputes with departing producers most often start.

QuotaPath handles a straightforward two-tier new-business and renewal structure well as long as book transfers are relatively rare. CaptivateIQ is stronger once you need to model a book transfer mid-year, splitting trail commission between a departing and receiving producer for a defined transition window, since that kind of time-bound split is easier to configure without manual monthly adjustments.

If your rows show simple, stable rates across a small number of policy types and low producer turnover, QuotaPath will serve your agency well. If several rows show book transfers, mixed agency and direct billing, and multiple policy-type rate tiers, CaptivateIQ's flexibility will reduce the manual reconciliation work every renewal season. CaptivateIQ vs QuotaPath vs Spiff is worth reading next if producers at your agency would value Spiff's real-time view into renewal commission as it comes due.

How to act on your finished worksheet:

• Simple, stable rates across a few policy types and low producer turnover point to QuotaPath.
• Several rows showing book transfers, mixed agency and direct billing, and multiple rate tiers point to CaptivateIQ and less reconciliation work each renewal season.
• Write down your trail-commission policy for departing producers, whatever it is, before the first departure happens.
• Configure producer statements to break out new-business commission, renewal trail, and book-transfer adjustments separately.

A commercial policy sometimes gets rewritten with a different carrier at renewal, often because a producer shopped the account for better terms or the incumbent carrier declined to renew. Most agencies treat this as a new-business event for commission purposes rather than a renewal, since the producer had to re-market and re-sell the account rather than simply processing an automatic renewal, even though the client relationship itself is continuous.

Decide this rule alongside your book-transfer policy, since the two situations get confused with each other in practice: a policy that moves carriers is a commission-rate question, while a policy whose servicing producer changes is a commission-recipient question. Keeping them as two clearly separate rules in your documentation avoids a producer arguing one applies when the other is what actually happened.

A producer statement that only shows a single total commission figure for the period makes it hard for a producer to verify their own pay is correct, especially once new business, renewals, and any book-transfer adjustments are all blended into one number. Whichever tool you use, configure statements to break out new-business commission, renewal trail commission, and any transfer-related adjustments as separate line items, so a producer can check their own math against each policy rather than only against a single bottom-line figure.

This level of detail also reduces the volume of commission-related questions your operations team fields each period, since a producer who can see exactly which policy each dollar came from is far less likely to need a follow-up conversation than one looking at an unexplained total.

Finally, review your statement format with a handful of producers directly before rolling it out agency-wide, since what operations considers a clear breakdown does not always match what a producer actually wants to see first when checking their own numbers. A short feedback round before a full rollout catches formatting confusion while it is cheap to fix, rather than after every producer has already formed an opinion about a confusing statement layout.