Blog · Data quality and reconciliation · Insurance
Use dated producer assignments for historical book reports. Separate current ownership from the owner at the original reporting date.
A policy written by one producer can later sit in another producer's book. Joining every historical transaction to the current owner moves the old income too, making prior performance change without a new sale. A dated ownership history lets the agency choose the view deliberately.
One row represents: one primary client or policy ownership assignment with valid-from and valid-to dates.
Useful fields: Client or term ID, producer ID, assignment start, assignment end, transfer reason, reporting date, transaction date and chosen attribution basis.
Define whether a measure uses the owner at transaction, expiry, confirmation or snapshot date. Use that date to select one valid assignment. Keep a current portfolio view available for service responsibility, but label it differently from an historical performance view. Where assignments overlap or are missing, retain an exception rather than guessing.
The following records and amounts are invented to show the method. They are not customer results, industry benchmarks or a forecast of Covirage performance.
| Period | Assigned owner | Income recorded |
|---|---|---|
| January–June | Producer A | $30,000 |
| July–December | Producer B | $40,000 |
| Current owner at year end | Producer B | All current service responsibility |
Under transaction-date attribution, A has $30,000 and B has $40,000. A current-owner portfolio can show the $70,000 relationship under B, but that is a portfolio view, not proof that B produced all the year's income. Both are useful when labeled clearly.
Ownership attribution is a management convention and may differ from contractual producer compensation. Do not use this view to calculate payments without the approved crediting and compensation rules.
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.
Only in a clearly labeled current-portfolio view. Historical performance should use the chosen as-of attribution rule.