Sign in

Blog · Forecast and pipeline · Insurance

Keep contingent commission separate in agency forecasts

Separate confirmed contingent commission from conditional scenarios. Show assumptions and sensitivity without presenting estimates as earned income.

The short answerSeparate received or confirmed contingent income from conditional estimates, and show a range based on the actual agreement's inputs. A scenario amount should not be presented as guaranteed recurring revenue.

An agency can have a strong production year while an additional commission payment depends on results not yet known or confirmed. Combining a speculative amount with ordinary commission makes the forecast look more certain than its evidence supports. A separate scenario lets leadership see the upside and its conditions.

Define the data before the metric

One row represents: one carrier agreement and measurement period, with status and supporting calculation references.

Useful fields: Agreement ID, carrier, measurement period, eligibility status, relevant production or results inputs, estimated amount, confirmed amount, confirmation date and payment date.

Use the current agreement and authorized carrier information. Identify which inputs are known, estimated or unavailable. Build low, base and high cases only where a documented rule supports them. Keep conditional scenarios outside confirmed-income totals and avoid extrapolating one carrier's arrangement to another.

Worked example

The following records and amounts are invented to show the method. They are not customer results, industry benchmarks or a forecast of Covirage performance.

Case Ordinary commission Conditional additional income
Low $200,000 $0
Base $200,000 $15,000
High $200,000 $25,000

The core commission forecast remains $200,000. Conditional total scenarios range from $200,000 to $225,000. If the agency budgets the $215,000 base case, its report should still make the $15,000 conditional portion visible. These illustrative amounts are not a formula for any actual agreement.

Use the result in a review

  1. Ask finance to confirm whether each additional amount is merely estimated, contractually confirmed or actually received.
  2. Show the assumptions that move the low and high cases rather than offering an unexplained probability.
  3. Compare prior estimates with final outcomes to improve future scenario discipline without assuming a repeat payout.

Checks before publishing

  • Verify that the agreement version and measurement period match the inputs used in each scenario.
  • Ensure additional commission is not already included in the ordinary ledger total before adding a scenario.
  • Record unknown inputs explicitly and avoid replacing them with historical averages without an approved assumption.

Where this analysis can mislead

Terms vary and may involve carrier results or other information an agency cannot independently verify. This guide does not determine contractual entitlement or accounting recognition. Those require agreement-specific and finance review.

Explore this question with your own data

Bring a small, authorized sample to Covirage for insurance agencies and brokers. Use the sample to discuss the fields and views your business needs. A dashboard or AI analyst can help explore this question when the required data and definitions are available; missing records still need to be resolved.

Upload sample data to check its structure. Keep unnecessary personal, claims and policyholder details out of an initial sample. The sample check does not establish that every analysis in this guide is available automatically.

Reference context

These references provide terminology or governance background. The worked example and proposed review method above are original illustrations, not prescribed industry standards.

Questions people ask

Should contingent commission be counted as guaranteed forecast income?

No. Separate confirmed amounts from conditional estimates, show the relevant assumptions and follow finance's recognition policy.