Reinsurance

Reinsurance Bordereaux Period Comparison: Metrics & Example

On this page

Last reviewed: November 2026

"Ceded premium is up 40% on last quarter, and the book has barely grown. Did the cedent push rates, or did something break?"

The CUO wants an answer before the treaty review on Friday.

A reinsurance bordereaux period comparison sets this quarter's cedent data against last quarter's, metric by metric.

Its job is to find the changes that need explaining before anything is booked.

This guide gives you a metrics table with suggested thresholds and a worked +40% premium case with exact arithmetic.

Key Takeaways

  • Compare ratios, not just totals. Average premium and rows per policy expose errors totals hide.
  • Split volume from average premium. Then test the cedent's stated rate change.
  • Drill to rows before concluding. The answer is usually in the transaction type.
  • Control for season and currency. Compare with the same quarter last year, in original currency.

What Goes Wrong When a Bordereau Is Compared on Totals Alone?

When a bordereau is compared on totals alone, data errors look like growth and get booked as business.

In the case below, premium rose from USD 8.0m to USD 11.2m. On totals alone, that is a good quarter.

USD 2.2m of it was repeated premium on endorsement rows.

It would have been reversed a quarter later, after it had already reached reserving and pricing data.

Which Metrics Belong in a Reinsurance Bordereaux Period Comparison?

A reinsurance bordereaux period comparison needs the ten metrics below, each with an alert threshold.

These variance thresholds are suggested starting points. Calibrate them on at least eight quarters of each cedent's history.

A stable motor book can run tighter bands than a fast-growing cyber book. Record the bands per cedent.

MetricFormulaSuggested alert threshold (quarter-on-quarter)A breach often means
Distinct policy countUnique policy numbers±10%New scheme, lost business or missing rows
Rows per policyRows ÷ distinct policiesChange above 0.05Endorsements or duplicate rows
Written premiumSum of premium±15%Rate, mix, duplicates or a missing file
Average premiumPremium ÷ distinct policies±10%Rate change, mix shift or wrong rows
Sum insuredSum of sums insured±15%Exposure growth or a unit error
Rate on sum insuredPremium ÷ sum insured±10%Rate change or a unit error
New vs renewed shareNew policies ÷ all policies±5 pointsGrowth push or renewals missing
CancellationsCount and return premium±25%Lapse wave or batched cancellations
Claims countClaims notified±20%Event, season or late reporting
Claims amountPaid plus outstanding±25%Large losses; check the top ten

Premium against exposure is covered in exposure to premium reconciliation.

How Does the +40% Premium, +5% Policies Case Work Out?

The +40% premium, +5% policies case works out as a data error, found in four steps. Figures are illustrative.

What do the Q2 and Q3 headline figures show on the motor bordereau?

The Q2 and Q3 headline figures on the motor bordereau show premium rising far faster than policies.

MetricQ2 2026Q3 2026Change
Distinct policies10,00010,500+5.0%
Premium (USD)8,000,00011,200,000+40.0%
Average premium (USD)800.001,066.67+33.3%
Rows10,00013,280+32.8%

Average premium is 11,200,000 ÷ 10,500 = 1,066.67. Rows per policy rose from 1.00 to 1.26 (13,280 ÷ 10,500).

How much of the motor bordereau premium change is volume rather than average premium?

Volume explains USD 400,000 of the motor bordereau premium change: 500 extra policies × USD 800.

The rest is average premium: 11,200,000 − (10,500 × 800) = 11,200,000 − 8,400,000 = USD 2,800,000.

The two parts add to the USD 3,200,000 increase.

Does the cedent's stated rate change explain the motor premium increase?

The cedent's stated rate change does not explain the motor premium increase. It states +8% on renewals.

Q3 holds 9,000 renewals and 1,500 new policies. At USD 864 (800 × 1.08), renewals give USD 7,776,000.

New policies at USD 800 give USD 1,200,000. Expected premium is USD 8,976,000.

Recorded premium is USD 11,200,000, leaving USD 2,224,000 unexplained, 24.8% above expected.

What did the row-level drill-down find on the motor bordereau?

The row-level drill-down on the motor bordereau found 2,780 extra rows (13,280 − 10,500), all endorsements.

Each carried the full annual premium, averaging USD 800, instead of the additional premium. 2,780 × 800 = USD 2,224,000.

Lloyd's Coverholder Reporting Standards v5.2 separate original, additional and return premium as transaction types.

The cedent's corrected file showed USD 61,000 of genuine additional premium. Q3 premium became USD 9,037,000, up 13.0%.

Request the correction through bordereau resubmission handling, not by editing the file yourself.

Which Edge Cases Distort a Bordereaux Period Comparison?

Three edge cases distort a bordereaux period comparison most often: seasonality, late or resubmitted files and exchange rates.

How should seasonality be handled in a bordereaux period comparison?

Seasonality in a bordereaux period comparison should be handled by also comparing with the same quarter last year.

Travel, crop and January-renewal books swing every quarter. A threshold breach that repeats each year is pattern, not error.

How do late and resubmitted files distort a period comparison?

Late and resubmitted files distort a period comparison by moving business between quarters or counting it twice.

Agree bordereaux cut-off dates and compare only the latest version of each period.

How do exchange-rate movements distort a bordereaux period comparison?

Exchange-rate movements distort a bordereaux period comparison when converted figures move with the rate, not the business.

EUR premium converted at 1.08 in Q2 and 1.17 in Q3 grows 8.3% in USD (1.17 ÷ 1.08 = 1.0833). Compare in original currency first.

Which Checks Should Run Before Trusting a Bordereaux Period Comparison?

Before trusting a bordereaux period comparison, run six checks on both periods.

  1. Each file ties to the cedent's control totals.
  2. Both periods use the same premium basis, gross or net of commission.
  3. Policies are counted as distinct numbers, not rows.
  4. Every row has a transaction type.
  5. All dates fall inside the reporting period.
  6. Each period uses its latest file only.

Solvency II Delegated Regulation 2015/35, Article 19 expects data from different periods to be consistent.

Where checks fail repeatedly, see ceded data quality scores and reconciliation variance root cause.

Who Should Review a Bordereaux Period Comparison Before Booking?

A bordereaux period comparison should be run by the bordereaux analyst and reviewed by the person who owns each breach.

Breach typeReviewerDeadlineOutcome recorded
Data: rows, dates, transaction typesBordereaux team lead5 working days from receiptFixed, or resubmission requested
Business: rate, mix, new vs renewedTreaty underwriter10 working daysExplained, or raised with the cedent
Money: premium or claims above thresholdTechnical accountingBefore bookingBooked, or held with a flag

An unexplained breach is not booked as normal business. It is held or booked with a flag until explained.

How Does Insurnest Help Alongside a Bordereaux Period Comparison?

Reinsurance Bordereaux Reconciliation does not compare periods or check rates. That analysis stays with your team.

It calculates each reinsurer's premium and claims share for the period from configured participation.

It compares those values with bordereaux, master and settlement records, and flags mismatches with reinsurer-wise status.

The platform identifies the difference. Accounting and finance teams determine the cause.

Key Terms

  • Distinct policy count: The number of unique policy numbers, regardless of how many rows each has.
  • Volume effect: The premium change explained by more or fewer policies at the old average.
  • Additional premium: Premium due from a mid-term change, reported separately from original premium.

Sources

Frequently Asked Questions

What goes wrong when a bordereau is compared on totals alone?

When a bordereau is compared on totals alone, data errors look like growth. A 40% premium rise can be booked as business written when part of it is repeated rows.

Which metrics belong in a reinsurance bordereaux period comparison?

A reinsurance bordereaux period comparison needs distinct policy count, rows per policy, premium, average premium, sum insured, rate on sum insured, new versus renewed share, cancellations and claims.

How much of the motor bordereau premium change is volume rather than average premium?

In the motor example, volume explains USD 400,000 of the USD 3.2m premium increase. The other USD 2.8m comes from a higher average premium per policy.

Does the cedent's stated rate change explain the motor premium increase?

The cedent's stated 8% rate change does not explain the motor premium increase. It supports USD 8,976,000, leaving USD 2,224,000 unexplained.

What did the row-level drill-down find on the motor bordereau?

The row-level drill-down on the motor bordereau found 2,780 endorsement rows carrying full annual premium instead of additional premium, which is exactly the USD 2,224,000 gap.

How should seasonality be handled in a bordereaux period comparison?

Seasonality in a bordereaux period comparison should be handled by comparing each quarter with the same quarter last year as well as with the previous quarter.

How do exchange-rate movements distort a bordereaux period comparison?

Exchange-rate movements distort a bordereaux period comparison when converted figures change with the rate. A move from 1.08 to 1.17 adds 8.3% with no change in business.

Which checks should run before trusting a bordereaux period comparison?

Before trusting a bordereaux period comparison, check control totals, the same premium basis, distinct counting, transaction types, period dates and that each period uses its latest file.

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

Bordereau Resubmission Handling Without Double-Counting

Bordereau resubmission handling made safe: versioning rules for corrected files, a worked double-count example with reinsurer shares, and tests that catch it.

Read more
Reinsurance

Bordereaux Cut-Off Dates: Stop Late Data Breaking Month-End

Bordereaux cut-off dates decide which data makes each month-end. Get a working-day close calendar, treaty tiering rules and a method for late bordereaux.

Read more
Reinsurance

Exposure to Premium Reconciliation: Match Risk and Premium

Exposure to premium reconciliation checks that ceded sums insured and premium agree. Includes a worked implied rate test and a break table with fixes.

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.