Premium to Claims Bordereaux Matching for Reinsurers: Rules
On this page
- Key Takeaways
- What Does Premium to Claims Bordereaux Matching for Reinsurers Catch?
- Which Match Key Should Come First When Matching Claims to Ceded Policies?
- What Decision Table Settles Each Claims Bordereau Match Outcome?
- What Do 12 Unmatched Claims Out of 400 Mean for a Quota Share Reinsurer?
- Who Signs Off an Unmatched Claim on a Reinsurance Bordereau?
- How Does Insurnest Help With Premium to Claims Bordereaux Matching?
- Key Terms
- Sources
- Frequently Asked Questions
Last reviewed: November 2026
Your auditor picks one claim from the Q3 claims bordereau and asks a plain question: where is the premium for this policy?
If the answer takes a week, the treaty has a matching problem.
Premium to claims bordereaux matching for reinsurers links every claim row to the ceded policy that earned the reinsurer premium.
Claims with no matching ceded policy are the ones to find before they are paid.
This guide gives you a match-key hierarchy, an outcome decision table with owners and a 400-claim case with 12 unmatched rows.
Key Takeaways
- Match on references first. Names and addresses are fallbacks, not primary keys.
- Unmatched is not invalid. Late cessions and other treaty years explain many gaps.
- Count by value, not rows. In the case below, 3% of rows carry about 19% of incurred.
- Name an owner per outcome. Each unmatched claim needs one person who closes it.
What Does Premium to Claims Bordereaux Matching for Reinsurers Catch?
Premium to claims bordereaux matching for reinsurers catches claims that cannot be traced to a ceded policy on any premium bordereau.
Some are harmless, such as a reference typed differently. Others mean a policy was never ceded, or the claim sits on the wrong treaty.
The RAA glossary describes a bordereau as a periodic report of premiums or losses on specific risks ceded.
Matching is what proves the two reports describe the same risks.
Which Match Key Should Come First When Matching Claims to Ceded Policies?
The certificate or policy reference should come first when matching claims to ceded policies, because it is unique by design.
Lloyd's Coverholder Reporting Standards list Certificate Reference among claims fields.
The same claims set carries insured name, risk inception date and location of risk. Those are the fallbacks.
| Rank | Match key | Strength | Typical failure |
|---|---|---|---|
| 1 | Certificate reference, exact | Strong | Renewal suffixes such as /01 or /02 |
| 2 | Reference normalised (spaces, hyphens, leading zeros, renewal suffixes removed) | Strong once rules are agreed | Over-cleaning merges two policies |
| 3 | Insured name plus risk inception date | Medium | Spelling, group companies, trading names |
| 4 | Location or risk ID plus inception | Weak | Several locations on one policy |
Stop at the first key that returns exactly one policy. Two candidates means a fuzzy match, not an exact one.
What Decision Table Settles Each Claims Bordereau Match Outcome?
A decision table for claims bordereau match outcomes gives each result one action and one owner.
| Match outcome | Evidence | Decision | Owner |
|---|---|---|---|
| Exact match | Rank 1 key; loss date inside policy and treaty period | Accept into the recovery calculation | Bordereaux analyst |
| Fuzzy match | Rank 2 to 4 key; one candidate only | Accept provisionally; cedent corrects the reference | Bordereaux lead |
| No match but covered | Policy on a later premium bordereau or another treaty year | Request the late cession or move the claim | Technical accountant |
| No match, outside period | Loss date outside the policy or treaty period | Hold, query the date, reject if confirmed | Claims manager |
| No match at all | No policy on any premium bordereau | Escalate; no recovery until proven | Head of claims and treaty underwriter |
Timing gaps between the two files are covered in claims bordereaux lag and bordereaux cut-off dates.
What Do 12 Unmatched Claims Out of 400 Mean for a Quota Share Reinsurer?
Twelve unmatched claims out of 400 can mean a fifth of the reinsurer's incurred share is unproven.
Take an illustrative 40% quota share. The Q3 claims bordereau has 400 rows and USD 9.6m gross incurred, and 388 rows match exactly.
| Outcome | Claims | Gross incurred | Reinsurer's 40% |
|---|---|---|---|
| Fuzzy match | 5 | USD 310,000 | USD 124,000 |
| No match but covered | 4 | USD 540,000 | USD 216,000 |
| No match, outside period | 2 | USD 180,000 | USD 72,000 |
| No match at all | 1 | USD 830,000 | USD 332,000 |
| Total unmatched | 12 | USD 1,860,000 | USD 744,000 |
The 12 unmatched claims are 3% of rows (12 ÷ 400) but about 19% of incurred (1.86 ÷ 9.6 = 19.4%).
What does a fuzzy match between a claim and a premium row need before acceptance?
A fuzzy match between a claim and a premium row needs one candidate policy, a loss date inside its period and cedent confirmation.
In the case, five claims carried references like "PRP-0045512" against "PRP45512/01" on the premium file.
Normalising matched all five to single policies. The cedent confirmed them, and USD 124,000 moved to accepted.
Why can a claim with no premium row still be covered by the treaty?
A claim with no premium row can still be covered when the policy was ceded late or belongs to another treaty year.
Four claims, USD 540,000 gross, sat on June policies left off the June premium bordereau.
Those policies arrived on the October file as late cessions.
On a policies attaching treaty, a claim on last year's policy belongs to last year's treaty.
Check every open treaty year before calling a claim unmatched.
What happens when a claim's loss date falls outside the ceded policy period?
When a claim's loss date falls outside the ceded policy period, the reinsurer holds the claim and queries the date.
One of the two claims was 12 days after expiry on a renewal not yet ceded. It became "no match but covered".
The other carried 2025 instead of 2026 as the loss year, a typing error the cedent fixed.
Under losses occurring during cover, the RAA glossary ties recovery to losses that happen in the treaty term.
So a date error can change which treaty pays.
When should a claim with no match anywhere be escalated?
A claim with no match anywhere should be escalated the day it is found, before any recovery is paid.
The single USD 830,000 claim had no policy on any premium bordereau in three treaty years. The reinsurer's 40% share is USD 332,000.
Ask the cedent for the policy schedule, its inception date and proof of cession. The answer may be a policy that was never ceded.
Who Signs Off an Unmatched Claim on a Reinsurance Bordereau?
An unmatched claim on a reinsurance bordereau is signed off by the owner its outcome names in the decision table.
Log every unmatched claim in a register, so the next quarter starts from the open list rather than from scratch.
| Register field | Example entry |
|---|---|
| Claim reference and treaty year | CLM-77120, 2026 |
| Outcome and key used | No match at all; ranks 1 to 4 tried |
| Gross incurred and reinsurer share | USD 830,000; USD 332,000 |
| Owner and date raised | Head of claims, 14 October 2026 |
| Query sent to cedent | Policy schedule and cession proof requested |
| Resolution and sign-off | Open |
Large unmatched claims belong in reinsurance flagging on claims and in the scope of the next cedent claims audit.
How Does Insurnest Help With Premium to Claims Bordereaux Matching?
Reinsurance Bordereaux Reconciliation computes every reinsurer's premium and claims share from the configured participation.
It compares those values with bordereaux, master, premium, claim and settlement records.
Differences are flagged and brought forward for investigation.
Status is shown by reinsurer, so each share of the USD 744,000 above can be tracked to closure.
It does not run fuzzy name matching or apply the key hierarchy above.
The platform identifies the difference. Your accounting and finance teams determine the cause.
See also reconciliation variance root cause.
Key Terms
- Match key: The field or field set used to link a claim row to a ceded policy row.
- Late cession: A policy reported on a premium bordereau after the period in which it incepted.
- Fuzzy match: A link found on a fallback key that still needs confirmation.
Sources
- Lloyd's: Coverholder Reporting Standards User Guide (Version 5.2, August 2019, claims fields)
- Reinsurance Association of America: Glossary of Reinsurance Terms
- Insurnest: Reinsurance Bordereaux Reconciliation
Frequently Asked Questions
What does premium to claims bordereaux matching for reinsurers catch?
Premium to claims bordereaux matching for reinsurers catches claims with no ceded policy behind them, such as late cessions, wrong treaty years, bad dates and policies never ceded.
Which match key should come first when matching claims to ceded policies?
The certificate or policy reference should come first when matching claims to ceded policies, then a normalised reference, then insured name with inception date, then location.
What decision table settles each claims bordereau match outcome?
A decision table for claims bordereau match outcomes maps five results, exact, fuzzy, covered but unmatched, outside period and no match, to an action and a named owner.
What does a fuzzy match between a claim and a premium row need before acceptance?
A fuzzy match between a claim and a premium row needs one single candidate policy, a loss date inside its period and cedent confirmation of the correct reference.
Why can a claim with no premium row still be covered by the treaty?
A claim with no premium row can still be covered when the policy was ceded late or attaches to another treaty year, so the premium sits on a different bordereau.
What happens when a claim's loss date falls outside the ceded policy period?
When a claim's loss date falls outside the ceded policy period, the reinsurer holds it, queries the date and checks for an uncessed renewal before rejecting it.
When should a claim with no match anywhere be escalated?
A claim with no match anywhere should be escalated at once to claims and underwriting heads, with no recovery paid until the cedent shows the policy and its cession.
Who signs off an unmatched claim on a reinsurance bordereau?
An unmatched claim on a reinsurance bordereau is signed off by the owner its outcome names, from bordereaux analyst to head of claims, and logged in a register.

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 →