A three-tier commission waterfall shows Written Premium, Agency Commission Generated, and Producer Earned — split by Paid, Awaiting Payout, and Pending Carrier Payment. Add loss ratio and retention rate and you have the full picture on every producer.
Written Premium (YTD)
$4.82M
+11.3%
Agency Commission
$386K
+9.7%
Producer Earned
$193K
+9.7%
Avg Loss Ratio
38.2%
-4.1%
What it is
Producer commissions move through three stages before cash reaches a producer's pocket: the carrier pays the agency, the agency calculates the producer split, and the producer gets paid. Insurstein maps this entire waterfall — Written Premium, Agency Commission Generated, and Producer Earned — then layers in loss ratio, retention %, and new vs. renewal breakdowns so every performance conversation is grounded in real numbers.
Most agencies piece together producer performance from carrier statements, spreadsheets, and memory. Totaling what each producer earned — and what's still owed from carriers — takes hours every month. Loss ratio per producer is rarely tracked at all, even though it directly affects your E&O exposure and carrier relationships.
Insurstein tracks every dollar across three buckets: Paid (commission disbursed to the producer), Awaiting Agency Payout (carrier has paid the agency but producer payout hasn't been issued), and Pending Carrier Payment (a forward-looking projection of commissions not yet received from the carrier). The projection bucket is clearly labeled so you never mistake expected income for cash in hand.
Core capabilities
Three-tier view: Written Premium → Agency Commission Generated → Producer Earned, per producer.
Every producer statement shows the full commission funnel. Written Premium is the bound policy total. Agency Commission Generated is what the agency earns per commission schedules. Producer Earned is the producer's split after agency retain. All three tiers are visible side by side so you can see exactly where money is at any stage.
Paid, Awaiting Agency Payout, and Pending Carrier Payment — with projections clearly labeled.
Paid = commission already disbursed to the producer. Awaiting Agency Payout = carrier has paid the agency but the producer check hasn't been issued yet. Pending Carrier Payment = projected commissions expected from the carrier, not yet received. The pending bucket is flagged as a projection so producers and managers never misread it as available cash.
Track claims-to-premium ratio by producer to identify risk concentration before it becomes an E&O issue.
Loss ratio is calculated as total incurred claims divided by written premium for each producer's book. A producer with a rising loss ratio may be writing underpriced risks or attracting high-claim accounts. Catching this early protects agency-carrier relationships and informs underwriting conversations.
Retention % = policies bound at renewal ÷ eligible renewals, counting only resolved outcomes.
Insurstein calculates retention only on renewals with a final outcome — bound or lost. In-progress renewals are excluded from the denominator so an open pipeline doesn't deflate the rate artificially. This gives you a defensible retention number you can share with carriers, not a moving target that changes with pipeline size.
See each producer's written premium and commission split between new accounts and renewals.
New business and renewals drive different commission rates and different growth stories. Insurstein breaks every premium and commission figure into its new vs. renewal component so you can see whether a producer is growing their book or just maintaining it — and whether renewal commissions are masking a stalled new business pipeline.
Admins see all producers; non-admins see only their own statement — enforced at the data layer.
Producer performance data is access-controlled by role. Admins and agency owners can view any producer's statement, waterfall, and metrics. Producers without admin rights see only their own data. This means you can roll out the feature agency-wide without worrying about one producer seeing another's compensation.
What they don't do
Stop manually totaling commissions per producer from PDFs and spreadsheets — the waterfall calculates it from bound policy data.
Replace the 'we think his book is performing fine' assumption with an actual per-producer loss ratio pulled from claim records.
Know each producer's exact retention rate — calculated on resolved outcomes only, not inflated by open renewals.
The new/renewal premium split is calculated automatically from policy effective and expiration dates — no manual categorization.
The three payment buckets (Paid / Awaiting / Pending) eliminate disputes about what's been paid vs. what's still owed.
Commission, loss ratio, retention %, and new business all live on one screen — no switching between systems for a producer review.
What it takes off your plate
Calculates Written Premium, Agency Commission Generated, and Producer Earned per producer from bound policy and commission schedule data.
Assigns each commission dollar to Paid, Awaiting Agency Payout, or Pending Carrier Payment and clearly labels projections.
Divides incurred claims by written premium per producer and updates the ratio as claims are entered or updated.
Counts only renewals with resolved outcomes (bound or lost) to produce a defensible retention percentage, excluding in-progress renewals.
Splits premium and commission figures into new business and renewal components based on policy history.
Enforces admin-only access to cross-producer data; non-admin producers are scoped to their own statement automatically.
A day in the life
8:00 AM
Open the Producer Statements tab. Three producers have commissions in the Awaiting Agency Payout bucket from last week's carrier EFT. Queue up the payout run before the morning stand-up.
9:30 AM
David Park's loss ratio climbed to 44% — up 8 points from last quarter. Pull his book and see which accounts are driving claims. Flag two accounts for non-renewal review before the carrier audit next month.
11:00 AM
Rachel's retention rate is 86.2% on resolved renewals. The waterfall shows her Pending Carrier Payment bucket is healthy — $27.7K projected. Conversation focuses on the 11 lost renewals and whether there's a pricing pattern.
1:30 PM
Agency-wide, 68% of written premium this quarter is renewal business. New business is growing but slowly. Share the split with the ownership group — supports the case for hiring a dedicated new business producer.
3:00 PM
Move commissions from Awaiting Agency Payout to Paid after processing the producer checks. The buckets update immediately. Producers can log in and see their statement reflects the disbursement — no more 'did my check go out?' emails.
Daily impact
Written Premium (YTD)
Avg Loss Ratio
Retention Rate
Pending Carrier Payment
Written Premium to Producer Earned — with loss ratio, retention %, and new vs. renewal splits. All in one screen, access-controlled by role.