Blog · Data quality and reconciliation · Insurance
Match prior and renewal terms and flag changed exposure, limits, periods and cover before interpreting premium movements.
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.
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.
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.
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.
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.
These references provide terminology or governance background. The worked example and proposed review method above are original illustrations, not prescribed industry standards.
No. Check the term, coverage relationship, exposure, limits and period. Reused policy numbers and replacements can create misleading matches.