SystemPolicy Administration & Servicing

Policy Data Conversion

Policy data conversion that re-rates every in-force policy and proves it matches before go-live

Every converted policy proved to match on premium and coverage before go-live.

See one case, screen by screen ↓
demo97.25%parity at test load 3 — 17,905 of 18,412 policies match to the cent or within $1.00
demo472policiesthat differ, every one explained in six causes, each traced to its record or scanned form
demo128policiesfixed and re-rated by one approved rule — the dropped alarm credit
target100%of converted policies compared on premium and coverage before go-live
In short

What is Policy Data Conversion?

Moving in-force policies off a legacy policy administration system onto a new one, with their coverages, forms, endorsements and history, and proving each one is the same policy afterwards. Policy Data Conversion has six agents read the legacy records and the scanned forms behind them, convert every policy, re-rate it in the new system and compare it, and a wave is signed only when count, premium and coverage tie out.

How to choose AI solutions for insurance →

Updated

The problem

Why a batch that ties out in total can still be wrong

A new policy system is only live when the in-force book is on it. Every policy has to come out of the old system with its remarks, scanned forms and endorsements, be mapped to the new products and forms, and come out the other side as the same policy: same coverage, same premium. Conversion teams map fields in spreadsheets, load a test batch and reconcile premium at the batch level.

Batch totals hide the problem. Rating facts sit in free-text remarks and on scanned certificates, not in fields, so a field-to-field map drops them without an error. Rises and falls net out, and a dropped credit on 128 policies disappears inside a $31 million wave. The customer finds it at renewal, as an unexplained premium change — or as a jewelry schedule that never loaded and a claim that is not covered.

typical~50%of core-system replacements miss time or budget, with data migration a named cause
target≈1monthper convert–load–compare cycle, done by hand
demo+$11,207a yearnet difference on a $31 million wave — hiding 472 policies that do not match
Where a convert–load–compare cycle’s working days goestimated
By hand22 days
With the solution5 days
  • Profiling extracts and mapping codes4 → 1 d
  • Loading the test batch and re-rating3 → 1 d
  • Reconciling premium and coverage5 → 0.5 d
  • Tracing each difference to its cause5 → 1 d
  • Fixing the map and reloading3 → 1 d
  • Wave sign-off report2 → 0.5 d

Estimated split for one cycle on one wave, by hand and with the solution, in working days.

How it works

How a policy converts

Six specialist agents read, convert, re-rate and compare every policy; the conversion lead approves each fix and the program manager signs the wave.

What comes in
Old system in18,412 policies · 41,206 scans · extracts, scanned forms, mapping, new-system rating
Agents at work
Legacy record readerfields + remarks
Document readerscanned forms
Then
Product and form mapper
Parity checkerre-rates in the new system
Then
Difference explainer
Wave reconciler
A person decides
Conversion leadapproves each rule; the wave is signed
What comes out
Converted, tied out
Differences explained
Wave signed
One case, step by step

One wave, from test load to signed

Larkhaven Mutual is moving 214,860 in-force policies off HOMER, its in-house mainframe in service since 1994, onto Larkhaven One, one wave of renewals at a time. Wave 3 is 18,412 Homeowners policies in Iowa and Nebraska renewing in December. Offers mail Fri 30 Oct; the wave freezes Sun 25 Oct. Here is Monday 12 October, screen by screen, in the working solution.

  1. 01Monday morning

    Test load 3, policy by policy

    Nadia Kerrigan · Conversion lead

    Test load 3 ran Sunday at 22:40. The wave ribbon splits all 18,412 policies: 17,596 match to the cent, 309 within the $1.00 rounding tolerance, 472 differ, 35 can’t convert — 97.25% parity, up from 94.9% at test load 2. The first difference is Dale & Marisol Brennan, HO 418829-04: the HOMER green screen on the left, the Larkhaven One record on the right, aligned field by field.

    “+$14.00 a year, the customer would see it on the renewal offer.”

  2. 02One click

    Re-rated in the new system, step by step

    Parity checker

    Nadia presses “Re-rate in Larkhaven One”. The current term is rated again at IA-HO-2025-07, the same rate version HOMER used, and all 11 rating steps are compared. Ten are equal. Step 6, the protective device credit, is −$14.00 in HOMER and not applied in Larkhaven One. The run log says why: converted with mapping version 3.7, one value with no target — PROT DEV = Y.

    Same rate version or no comparison: a rate change is never mistaken for a conversion error.

  3. 03Traced

    The credit was in a remark and on a scan

    Difference explainer · Document reader

    HOMER’s PROT DEV field says only Y. The alarm type sits in the remark CS ALM SOUTHGATE MON #77412 CERT REC 03/19, and the scanned certificate of alarm installation from Southgate Monitoring Co., installed 14 March 2019, shows central-station burglary and fire monitoring. Under rule 406 of the rule manual, that earns a 1% credit on the $1,400.00 base premium.

    “Protective device credit dropped. HOMER’s PROT DEV says only Y; the alarm type sits in the remark field, and the map had no target for a bare Y.”

  4. 04Decided

    One rule for every policy with the same cause

    Nadia Kerrigan · Conversion lead

    The same cause runs through 128 wave 3 policies, worth +$2,108 a year. The proposed rule shows its evidence: 128 of 128 remarks name a central station, and 119 alarm certificates and 9 monitoring invoices read all show fire and burglary monitoring. Approving it moves the map from version 3.7 to 3.8; any policy that still differs stays on the list.

    “When PROT DEV = Y with no type, read the remark and the alarm certificate and set the device type.”

  5. 05Re-rated

    128 of 128 match to the cent

    Parity checker

    All 128 policies are converted again and re-rated at HOMER’s rate versions. The Brennan home now reads $1,412.00 on both sides, protective device “Central station · fire + burglary”, and wave 3’s differences fall from 472 to 344. Parity moves to 97.94%.

    “128 policies fixed and re-rated · 344 differences left in wave 3.”

  6. 06Next

    Every other difference, by cause

    Difference explainer

    344 policies still differ, net +$9,099 a year, across five causes — each with a count, an average, an example policy and a drafted rule. Roof age taken from the year built: 61 policies, about +$195 each; Ruth and Arne Halvorsen’s roof was replaced in 2021, but the age came from the 1962 build year, so $1,644.00 became $1,826.40. A 1.5% wind and hail deductible rounded to 2%. ZIP 50023 split into territories 14 and 14A, moving 96 Ankeny homes.

    A rule fixes the conversion, not the rate, and a person approves every rule.

  7. 07Coverage

    A jewelry schedule that never loaded

    Document reader

    Teresa Villanueva’s HO 04 61 lists four jewelry items worth $18,400. The extract carried the schedule’s $202.40 premium but not its items, so Larkhaven One has no items — the coverage is missing. The same is true on 39 policies, $333,900 of scheduled property in all. The rule reads each scanned HO 04 61 and loads every item; a person checks any item over $10,000.

    “Coverage differs — cannot be accepted; approve the rule.”

  8. 08Doubtful

    The map, with the doubtful values left to people

    Tomás Reyes · Product and forms specialist

    Mapping version 3.8 covers 9 products, 64 forms, 212 fields and 1,318 code values. Values at 95% confidence or more are approved on their own; the rest wait for a named person. ENDT SPP to Scheduled personal property (HO 04 61) waits for Tomás; the roof age class, the wind and hail deductible, the split territory and the loss-free years wait for Nadia. Every decision is versioned.

  9. 09Exceptions

    35 policies that need a person

    Lorraine Abbott · Policy services lead

    21 policies have no construction type, 9 have a ZIP that does not match the county, and on 5 the named insured has died with the estate pending. They stay on HOMER until resolved, each with its agency and an action: request from the agent, correct the address, or convert by hand at renewal.

  10. 10Before the freeze

    The wave signs only when it ties out

    Grant Whitfield · Program manager

    The Wave reconciler ties wave 3 measure by measure. Coverage A ($5,237,418,000), forms, endorsements and mortgagees tie. Written premium is +$9,140 against a $3,123 tolerance, and scheduled property is $333,900 short. Six blockers are listed, each with its owner, and the signatures go in order: Nadia Kerrigan, then Lorraine Abbott, then Grant Whitfield.

    “Wave 3 signs when every policy ties out, or each open item is accepted with a reason. Coverage differences cannot be accepted.”

Who it’s for

Built for everyone who carries a conversion wave.

The same wave, seen by the four people who answer for it — what their test loads looked like, and what they look like now.

NK
Nadia KerriganConversion lead, Larkhaven Mutual
Conversion lead
Before
Reconciles premium at the batch level and knows a wave that ties out in total can still have a hundred customers paying the wrong amount.
Now
Starts from every policy re-rated and compared step by step, with differences grouped by cause; approves one rule per cause and signs first.
TR
Tomás ReyesOwner of the product and form map
Product and forms specialist
Before
HOMER kept half its rating in the remarks; he needs to see the remark and the form together to decide a mapping.
Now
Gets only the doubtful values below 95% confidence, each with its policies, and checks scheduled items over $10,000.
LA
Lorraine AbbottOwner of renewal offers and hand conversions
Policy services lead
Before
If the renewal goes out wrong, her team takes the call.
Now
Sees the 35 policies that can’t convert by reason, with the agency and the action, and signs second.
GW
Grant WhitfieldProgram manager, Larkhaven One program
Program manager
Before
Signs when the numbers tie, not when the batch finished, and today those numbers are batch totals.
Now
Signs from a tie-out of count, premium and every coverage, with each blocker, owner and rule on the record.
Built on the engine

6 agents. Each with one job, and hard limits.

Six specialist agents read, convert, re-rate and compare every policy; the conversion lead approves each fix and the program manager signs the wave.

Legacy record reader

Reads the legacy extracts — policy, coverage, rating, remarks and claims — profiles every field and links each policy’s scanned documents.

  • Read-only on the legacy system
  • Every value cites its file, record and offset
  • Keeps remark lines whole
Document reader

Reads scanned declarations, endorsements, alarm certificates, inspection reports and appraisals, and cites the page for every value.

  • Never invents a value it cannot read
  • Unreadable pages go to a person
  • Cites the page and position
Product and form mapper

Maps legacy products, forms, fields and code values to the new system, with a confidence and sample policies.

  • Never maps below 95% confidence without a person
  • Never drops a value without a decision
Parity checker

Converts each policy, re-rates its current term in the new system at the legacy rate version, and compares field by field and rating step by step.

  • Same rate version or no comparison
  • Never changes a premium, a rate or a coverage to force a match
Difference explainer

Groups differences by cause, traces each cause to a legacy field, remark or scanned form, and drafts one rule per cause.

  • Never applies a rule — a person approves every one
  • Every cause cites its source
  • Fixes the conversion, not the rate
Wave reconciler

Ties counts, written premium, every coverage limit, forms, endorsements and mortgagees per wave, lists each blocker with its owner and drafts the sign-off report.

  • Never signs
  • Never accepts a coverage difference
Conversion lead

Approves every rule. The agents propose; a named person decides.

Ask in plain words

Ask about any policy, difference or wave

The conversion team can ask about any policy, difference, rule or wave in plain words — or say what to decide. Every answer cites the record or page it rests on.

Why is the Brennan renewal $14 higher?

Because the protective device credit was dropped. HOMER says only PROT DEV = Y; the alarm type is in the remark CS ALM SOUTHGATE MON #77412. The scanned certificate shows central-station fire and burglary monitoring, which earns 1% of the $1,400.00 base premium — $14.00. 128 wave 3 policies share this cause.

Which differences would a customer notice at renewal?

359 policies would see a higher premium: 128 lost the alarm credit, 61 have a roof aged from the build year (about +$195 each), 96 Ankeny homes moved territory and 74 lost loss-free years. Worse, 39 would lose scheduled jewelry and art coverage — $333,900 in all.

Can wave 3 sign off before the freeze on 25 Oct?

Yes, if the six rules are decided this week. Offers mail Fri 30 Oct and the wave freezes Sun 25 Oct. Today 472 policies still differ and scheduled property is short by $333,900, which cannot be accepted; the 35 that can’t convert need Lorraine Abbott’s acceptance.

Show me the policies that lose coverage

39 policies, all with a scanned HO 04 61 whose items never reached the extract — Teresa Villanueva’s $18,400 jewelry schedule is the first. The Document reader has read all 39 schedules; approving the rule loads 212 items.

Every screen

The working solution, as it ships.

13 screens from the working solution, on its sample data. Pick one to see it large.

The parity viewThe legacy green screen beside the converted record, field by field, under a wave ribbon of match, within $1.00, differ and can’t convert.
Rating, step by stepThe current term re-rated at the same rate version, every rating step side by side, with the agents’ run log for the policy.
The scanned certificateThe alarm certificate with the values read from it, the legacy field and the new field, and the effect on the rating.
Approving one ruleThe cause, the rule, the evidence across 128 policies and what happens when it is approved.
Matched to the centAfter the rule: the Brennan policy re-rated at $1,412.00 on both sides and 344 differences left in the wave.
Differences by causeEvery differing policy plotted by premium difference, with each cause’s count, average, example and drafted rule.
Wave 3 policiesEvery policy with its legacy and new premium, the difference and its cause, filterable by differ, coverage changed and within $1.
A scheduled property endorsementFour jewelry items on a scanned HO 04 61 that never reached the extract — coverage missing in the new system.
Product, form and code mapLegacy code values mapped to new products, forms and values, with confidence, status and who decides.
Can’t convertThe 35 policies that need a person, by reason, with the agency and the action for each.
Wave sign-offThe tie-out of policies, premium, Coverage A, scheduled property, forms and mortgagees, with blockers and the signature order.
Conversion wavesSix waves on the renewal calendar, each wave’s funnel from read to signed, and parity across test loads 1 to 3.
Your conversion’s rulesPremium, wave and coverage tolerances, the rate version rule, mapping confidence, reading scanned forms, the scheduled-item check and the renewal calendar.
Governance

Built for a book you cannot get wrong: cited, decided by people, signed in order.

Every difference cites its sourceEach difference points to the legacy record, field or remark and the scanned page behind it — the certificate, the inspection report, the HO 04 61.
The legacy system is read, never changedThe agents are read-only on the old system. Changes since the last load are converted and re-rated again every night at 01:00 until the wave goes live.
Agents propose, people decideNo rule applies without the conversion lead, and no doubtful mapping without the forms specialist. A rule can be withdrawn; its version stays on the record.
Nothing is forced to matchThe agents never change a premium, a rate or a coverage to make a policy match, and they compare only at the legacy rate version.
Coverage differences block sign-offAny coverage difference stops the wave and cannot be accepted. Other open items are accepted only with a written reason and an owner.
Signed in order, with the trail attachedConversion lead, policy services lead, then program manager sign the wave. Rule versions, who approved them and the re-rate results per test load travel with the sign-off report.
Configuration

Your conversion’s rules, not ours

What Larkhaven Mutual decided for this conversion. Every change is a new version on the record.

SettingDefaultChoose from
Premium tolerance per policy$1.00Any amount counted as rounding
Wave tolerance at sign-off0.01% of premiumAny share of written premium
Coverage toleranceNoneAny coverage difference blocks sign-off
Rate version must equal the legacy system’sOnOn · Off
Auto-approve mappings at≥ 95% confidenceBelow it, the forms specialist decides
Scheduled items needing a personAbove $10,000Any item value
Renewal offers mail32 days before the effective dateAny number of days
Wave freeze5 days before offers mailNo rule changes after it
Connections

Works with the systems your conversion already runs on

Your legacy policy systempolicy, coverage, rating, remark, claims and mortgagee extracts, read-only
Scanned policy documentsdeclarations, endorsements, alarm certificates, inspection reports, appraisals
Your new policy systemtest rating of the current term at the same rate version
Old-to-new product and form mapproducts, forms, fields and code values, versioned
Your rating rule manualthe rules each credit and charge is checked against
Load files and reportsconverted records ready to load, the parity report and the wave sign-off report
What it changes

The difference, in numbers.

Every figure is labelled: a target the solution is built to, an estimate, a typical published result, or a proven one.

target
100%
of converted policies compared on premium and coverage before go-live
18,412 of 18,412 policies
compared before sign-off
target
1week
per convert–load–compare cycle, instead of about a month
Today≈ 1 month
With agents≈ 1 week
typical
~50%
of core-system replacements miss time or budget, with data migration a named cause

“demo” = seen in the working solution, on its sample wave of policies · “target” = the design goal, measured in the live solution · “estimated” = our estimate · “typical” = published figures (Roland Berger, How insurers can maximize value from core insurance system transformation — about half of core-system replacements miss time or budget, with underestimated data migration among the causes). People, companies, policies and addresses named on this page — Larkhaven Mutual, HOMER, Larkhaven One, Southgate Monitoring and every insured — are fictional: characters and sample data in the working solution.

Questions

What conversion teams ask us.

What is policy data conversion?

Moving in-force policies off a legacy policy administration system onto a new one, with their coverages, forms, endorsements and history, and proving each one is the same policy afterwards. Policy Data Conversion has six agents read the legacy records and the scanned forms behind them, convert every policy, re-rate it in the new system and compare it, and a wave is signed only when count, premium and coverage tie out.

How does it prove a converted policy matches?

The Parity checker re-rates each policy’s current term in the new system at the same rate version the legacy system used, then compares every field and every rating step, not just the total premium. A difference points to one rating step — in the demo, step 6, the protective device credit — and from there to the field, remark or document behind it.

Does it read scanned forms and remarks?

Yes. The Document reader reads scanned declarations, endorsements, alarm certificates, inspection reports and appraisals, and cites the page for every value; the Legacy record reader keeps remark lines whole. Pages it cannot read go to a person — in the demo wave, 12 of 41,206 scanned documents.

Does it change premiums or our legacy system?

No. The agents are read-only on the legacy system, and they never change a premium, a rate or a coverage to force a match. A fix is a rule that changes how the policy is converted, and a person approves every one.

What happens to policies that can’t convert?

They stay on the legacy system until resolved, listed by reason — such as a missing construction type, a ZIP that does not match the county, or a deceased named insured with the estate pending — with an owner and an action: request the data from the agent, correct it, or convert by hand at renewal.

Can we convert on renewal, wave by wave?

Yes. The solution tracks each wave on the renewal calendar, from read to converted, re-rated, matching and signed, with parity across test loads. The renewal-offer lead time and the wave freeze are settings, and changes in the legacy system are re-converted and re-rated every night until the wave goes live.

Do people stay in control?

Yes. The conversion lead approves every rule, the forms specialist decides every mapping below the confidence threshold, and the wave is signed in order by the conversion lead, the policy services lead and the program manager. Coverage differences cannot be accepted, and other open items only with a written reason.

How long does it take to go live?

The Agentic Solution Engine builds and deploys it from your requirements — your legacy extracts and record layouts, a sample of scanned forms, your product and form map and your rule manual — and it goes live once every quality gate has passed. We will walk you through it on a sample of your own policies first.

See it on
your in-force book.

We’ll run Policy Data Conversion on a sample of your own legacy policies and scanned forms.