Sign in

Blog · Data quality and reconciliation · Insurance

Check renewal premium comparability before calling it a rate change

Match prior and renewal terms and flag changed exposure, limits, periods and cover before interpreting premium movements.

The short answerMatch prior and current terms at the appropriate coverage level, then flag changes in exposure, limits, deductibles and period length. Compare like-for-like records separately from changed or unmatched policies.

A policy's premium can rise after a limit increase, a longer term or a changed insured schedule. The price movement may be real, but calling the entire difference a rate increase is unsupported. A comparability review should happen before a premium growth bridge is calculated.

Define the data before the metric

One row represents: one reviewed prior-to-current policy-term match, allowing documented replacement or split relationships.

Useful fields: Prior term ID, renewal term ID, coverage line, term length, exposure unit and amount, limit, deductible, insured schedule, premium and match status.

Use explicit renewal links if available and review cases where one policy becomes several or several consolidate into one. Compare terms on a consistent period basis only when such normalization is meaningful. Assign each match to comparable, changed-basis or unresolved. Preserve the original amounts and reasons for exclusion.

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.

Pair Premium change Comparability
A $10,000 → $11,000 Same recorded exposure and terms
B $8,000 → $12,000 Exposure rises 50%
C $6,000 → $9,000 Term changes from 12 to 18 months

A's 10% increase is a useful candidate for closer rate review, though other risk changes may still exist. B's increase matches its recorded exposure growth. C's nominal 50% increase coincides with a longer period. Pooling all three as a pure renewal rate increase would mix different changes.

Use the result in a review

  1. Publish the comparable population's premium share so the agency knows whether a rate discussion covers most of the book or a small subset.
  2. Ask account staff to review large changed-basis records and explain the source of their movement.
  3. Resolve split and consolidated terms before comparing producer or carrier outcomes.

Checks before publishing

  • Verify that the prior and current records represent the same underlying coverage relationship, not simply matching names.
  • Check consistent units for limits, exposure and premium currency.
  • Reconcile all terms into comparable, changed-basis and unresolved groups without discarding difficult cases.

Where this analysis can mislead

Matching visible fields cannot prove identical risk or policy wording. A stable limit and exposure are useful checks, but the analysis should still call the result premium movement unless a stronger basis for pure rate comparison exists.

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

Is the same policy number enough for a valid renewal comparison?

No. Check the term, coverage relationship, exposure, limits and period. Reused policy numbers and replacements can create misleading matches.