Build an insurance agency commission-and-fee revenue bridge

A headline growth percentage does not show whether the agency expanded relationships or merely benefited from changed premium and commission terms. A complete bridge also catches unclassified movements that a narrative might otherwise ignore. Keep agency income distinct from premium and use stable client identities.

Define the data before the metric

One row represents: one reporting client and income category for each of two comparable periods, with transaction detail available underneath.

Useful fields: Reporting client ID, period, commission, fees, recurring category, adjustment category, client entry or exit status, line, branch and currency.

Use the same business perimeter and period length. Identify new and lost clients from the relationship history, not only the presence of revenue in one month. Calculate retained-client changes from actual commission and fee records. Keep acquisition, transfer and restatement effects separate if they change the comparison population.

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.

Current agency income is $110,000, a 10% increase. New minus lost income contributes $7,000, retained-client commission movement contributes $4,000, and fee changes or corrections remove $1,000. The bridge explains all $10,000 of growth; it does not imply that retained-client movement is entirely producer-driven.

Use the result in a review

1. Review the bridge before writing the monthly growth narrative, ensuring the components match the financial control.
2. Split retained-client changes into line mix, premium movement and commission effects where the data supports those distinctions.
3. Ask each office to explain material unclassified movements instead of distributing them across convenient categories.

Checks before publishing

• Assert that opening income plus all movement components equals closing income within an agreed rounding tolerance.
• Apply mutually exclusive client categories so the same account is not both new and expanded.
• Keep agency acquisitions, scope changes and currency effects explicit rather than calling them organic growth.

Where this analysis can mislead

Client entry and exit can be ambiguous in a transaction ledger. A temporary zero-income period does not prove a relationship was lost. Finance and operations should agree the status rule and treatment of late records before publication.

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.

Related guides

• Keep contingent commission separate in agency forecasts
• Booked versus received commission: explain the timing gap
• Commercial insurance broker KPIs

Reference context

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

• Insurance terminology
• Agency benchmarking context