Reinsurance

Duplicate Treaty Records: Match Scores and Merge Rules

On this page

Last reviewed: November 2026

The 2026 quota share showed EPI of EUR 18m in the portfolio report. The slip said EUR 9m.

The London team had booked it as "Northwind Insurance Co Ltd". The branch had booked "NORTHWIND INSURANCE COMPANY LIMITED".

Duplicate treaty records are two or more system records for the same reinsurance contract, often keyed by different teams.

They matter because every report that sums records, from EPI to exposure, counts the contract twice.

This guide gives you a weighted match-scoring table, hard override rules, three scored pairs and merge rules for the survivor.

Key Takeaways

  • Normalise before matching. Most duplicates differ only in how the cedent is spelt.
  • Score, do not guess. Weighted fields beat eyeballing a list.
  • Let hard rules win. A different underwriting year means a renewal.
  • Merge, never delete. Re-point every transaction and keep the old ID as an alias.

What Are Duplicate Treaty Records at a Reinsurer?

Duplicate treaty records at a reinsurer are separate records for one contract, with the same cedent, year, layer and terms.

They are different from duplicate payments; for those, see duplicate claim payments in reinsurance.

What damage do double-booked reinsurance contracts cause?

Double-booked reinsurance contracts cause damage wherever records are summed or transactions are split.

  • Doubled EPI and exposure. Portfolio and capital reports overstate the line.
  • Split claims. Some losses post to one record, some to the other.
  • Two statements. The cedent receives conflicting accounts.
  • Broken audit trail. Neither record shows the true position.
  • False capacity limits. Line checks see twice the share and may block new business with that cedent.

How Do Reinsurers Find Duplicate Treaty Records?

Reinsurers find duplicate treaty records in two steps: group likely pairs into blocks, then score each pair on weighted fields.

BLOCKING QUERY (candidate pairs)
Group treaty records by:
  normalised_cedent_name  (or cedent LEI)
  underwriting_year +/- 1
  treaty_type
Keep groups with 2+ records; compare every pair in the group.

Blocking keeps the work small. A 5,000-treaty register would otherwise need about 12.5 million comparisons.

FieldAgreementPoints
CedentSame LEI30
Normalised name exact25
Name similar (spelling variant)15
Underwriting yearSame15
Different–20
Inception dateSame15
Within 31 days8
Layer or sectionSame attachment, limit, share basis and currency20
Same type, different figures5
Broker referenceSame15
Missing on one record0
Different–10
Class and treaty typeSame5

The maximum is 100. Match broker references in the form your policy number mapping uses.

How should cedent names be normalised before treaty matching?

Cedent names should be normalised before treaty matching with fixed, written rules, applied the same way to every record.

  1. Lower-case and trim spaces.
  2. Remove punctuation and legal suffixes: ltd, limited, plc, co, company, sa, ag, gmbh.
  3. Standardise "&" to "and" and known spelling variants (harbour, harbor).
  4. Map the result to the cedent's LEI, where one exists.

The LEI is a 20-character code under ISO 17442. Each LEI identifies only one legal entity.

What Match Score Makes Two Treaty Records Duplicates?

A match score of 80 or more makes two treaty records probable duplicates, subject to hard rules that override the score.

Score or conditionDecisionAction
Different underwriting yearNot a duplicate (renewal)Link as prior year
Different attachment in the same programmeNot a duplicate (another layer)Check programme structure
Different cedent LEINot a duplicateClose
80 – 100Probable duplicateMerge after checker review
55 – 79Possible duplicateClerical review with the slip
Below 55DistinctClose

This three-band rule follows the classic Fellegi–Sunter approach to record linkage.

A Census Bureau research report describes it: match above the upper threshold, review between, non-match below.

Set your thresholds from a sample you have checked by hand, then adjust them.

When should a reinsurer run the duplicate treaty check?

A reinsurer should run the duplicate treaty check at set-up, monthly, and before each renewal season and quarter-end close.

  • At set-up. Score every new record against the register before saving it.
  • Monthly. Run the full blocking query over records created that month.
  • Before 1 January, 1 April and 1 July. Renewal peaks create the most double keying.
  • Before quarter-end. Duplicates inflate the EPI that finance reports.

The check at set-up is the cheapest. A duplicate stopped before its first premium posts needs no merge at all.

How Do Three Candidate Treaty Pairs Score?

Three candidate treaty pairs, illustrated below, show a merge, a review and a renewal.

FieldPair 1Pair 2Pair 3
Names"Northwind Insurance Co Ltd" / "NORTHWIND INSURANCE COMPANY LIMITED""Harbor Mutual" / "Harbour Mutual Assurance""Delta General" / "Delta General" (same LEI)
Cedent251530
Underwriting year2026 / 2026: 152026 / 2026: 152025 / 2026: –20
Inception1 Jan / 1 Jan: 151 Apr / 1 Apr: 151 Jan 2025 / 1 Jan 2026: 0
Layer30% QS / 30% QS: 20EUR 10m xs 5m both: 20EUR 10m xs 5m both: 20
Broker referenceSame: 15Missing on one: 0Different: –10
ClassSame: 5Same: 5Same: 5
Score957025
DecisionMergeReviewRenewal (hard rule)

Pair 2 went to review. The slip confirmed one contract, keyed twice by a branch, so it was merged.

Pair 3 is a renewal. Merging it would wipe out a year of history.

Instead, link the 2026 record to the 2025 record as its prior year, so renewal and loss history stay connected.

How Should a Reinsurer Merge Duplicate Treaty Records?

A reinsurer should merge duplicate treaty records in a fixed order, so no transaction is lost or counted twice.

  1. Choose the survivor. Apply the rule below.
  2. Re-point transactions. Premiums, claims, cash, bordereaux and documents move to the survivor.
  3. Reverse double-counts. Where both records took the same premium, reverse one.
  4. Check shares. Recalculate with reinsurer participation share calculation.
  5. Retire the duplicate. Status "merged into [survivor ID]", kept as an alias.
  6. Log it. Who merged, when, and why, with the score and evidence.

Update the reinsurance treaty register so the alias resolves to the survivor.

Which treaty record should survive a merge?

The treaty record that should survive a merge is the one whose terms match the signed slip, with the most transactions posted.

If both match and both carry transactions, keep the earliest created record. Never pick by whoever spots the duplicate first.

How Does Insurnest Help Keep One Record Per Treaty?

Reinsurance Treaty Management holds each treaty as one controlled digital record of structure, participation, retention and limits.

It keeps commission formulas, premium and settlement calculations, treaty versions and an audit trail of changes.

It does not detect, score or merge duplicates. Run the matching in your data tools, then keep the survivor as the controlled record.

Key Terms

  • Blocking: Grouping records by a few keys so only likely pairs are compared.
  • Clerical review: Manual check of pairs that score between the two thresholds.
  • Survivor record: The record kept after a merge, holding all re-pointed transactions.

Sources

Frequently Asked Questions

What are duplicate treaty records at a reinsurer?

Duplicate treaty records at a reinsurer are two or more system records for the same reinsurance contract, usually keyed by different teams under slightly different cedent names or references.

What damage do double-booked reinsurance contracts cause?

Double-booked reinsurance contracts cause doubled EPI and exposure, claims split across two records, two settlement statements and an audit trail that cannot show one true position.

How do reinsurers find duplicate treaty records?

Reinsurers find duplicate treaty records by grouping candidates on normalised cedent and underwriting year, then scoring each pair on name, year, inception, layer, broker reference and class.

How should cedent names be normalised before treaty matching?

Cedent names should be normalised before treaty matching by lower-casing, removing legal suffixes and punctuation, standardising '&' and spelling, then mapping each name to its LEI where one exists.

What match score makes two treaty records duplicates?

A match score of 80 or more out of 100 makes two treaty records probable duplicates. Scores of 55 to 79 go to clerical review, and hard rules override any score.

How do three candidate treaty pairs score?

Three illustrative candidate treaty pairs score 95, 70 and 25: one clear duplicate to merge, one for clerical review that proved a duplicate, and one renewal that is not.

How should a reinsurer merge duplicate treaty records?

A reinsurer should merge duplicate treaty records by choosing a survivor, re-pointing premiums, claims, cash and bordereaux to it, reversing double-counts and retiring the duplicate as an alias.

Which treaty record should survive a merge?

The treaty record that should survive a merge is the one matching the signed terms with the most transactions posted. Ties go to the earliest created record.

Hitul Mistry

Hitul Mistry

CEO, Insurnest

An InsurTech leader with more than a decade of experience across insurance and technology, focused on solving business problems with the help of technology. Has worked with brokers, insurance carriers, and reinsurance firms across the India, UAE, and US markets.

View LinkedIn profile →
ShareLinkedInX

Read our latest blogs and research

Featured Resources

Reinsurance

Reinsurance Treaty Register: One Record of Every Treaty

A reinsurance treaty register gives reinsurers one complete record of every active, expired and run-off treaty, with status, shares, owners and documents.

Read more
Reinsurance

Policy Number Mapping Between Cedent and Reinsurer: Key Spec

policy number mapping between cedent and reinsurer: a field-by-field key map spec, the shortcuts that fail and a filled example of a reissued life policy.

Read more
Reinsurance

Reinsurer Participation Share Calculation for Panels

Reinsurer participation share calculation explained: written vs signed lines, signing down, layer-by-layer allocation and rounding across reinsurance panels.

Read more

Meet Our Innovators:

We aim to revolutionize how businesses operate through digital technology driving industry growth and positioning ourselves as global leaders.

circle basecircle base
Pioneering Digital Solutions in Insurance

Insurnest

Empowering insurers, re-insurers, and brokers to excel with innovative technology.

Insurnest specializes in digital solutions for the insurance sector, helping insurers, re-insurers, and brokers enhance operations and customer experiences with cutting-edge technology. Our deep industry expertise enables us to address unique challenges and drive competitiveness in a dynamic market.

Get in Touch with us

Ready to transform your business? Contact us now!

We respond within one business day.