Reinsurance

Exposure to Premium Reconciliation: Match Risk and Premium

On this page

Last reviewed: November 2026

The March bordereau ties to the account, the premium is in, and the quarter closes on time.

Six months later, a warehouse loss shows a sum insured of 8.5 million that carried a premium of 680.

Exposure to premium reconciliation is the check that the risks ceded on a bordereau carry the premium their sums insured imply, row by row and in total.

The practical method is an implied rate test: divide premium by sum insured, compare it with an expected band, and work every row that falls outside.

Key Takeaways

  • Totals can tie while rows are wrong. A portfolio rate inside its band can hide several broken risks.
  • The implied rate is the simplest test. Premium divided by sum insured, per mille, against an expected band.
  • Cession percentages must agree. The ceded share of premium should match the ceded share of sum insured.
  • Annualise before you compare. Instalments, endorsements and short periods distort the rate if left raw.
  • Root cause stays with people. A test finds the break; the cedent and the bordereaux team explain it.

What Is Exposure to Premium Reconciliation?

Exposure to premium reconciliation is a test that the exposure ceded to a treaty and the premium ceded for it describe the same risks.

On property business the exposure measure is usually the sum insured. Other classes may use turnover, wageroll, vehicles or members.

It differs from a cash reconciliation. Cash checks tie premium to the account; this check asks whether that premium is plausible for the exposure behind it.

Lloyd's Coverholder Reporting Standards v5.2 make sum insured and its currency mandatory for all classes and territories.

The guide cites EIOPA's definition: the highest amount the insurer can be obliged to pay, before any policyholder deductible.

Which Inputs Does the Implied Rate Test Need?

The implied rate test needs six inputs per bordereau row, and each one has a common way of being wrong.

InputTypical bordereau fieldWhy it matters to the test
Sum insured (100%)Sum insured amount and currencyDenominator of the rate; must be at 100% of the original risk
Gross premium (100%)Gross written premium for the transactionNumerator; must be the annual premium, not an instalment
Transaction typeNew, renewal, endorsement, cancellationEndorsement and return rows need separate treatment
Period of coverInception and expiry datesShort periods need annualising before comparison
Cession percentageTreaty share or ceded %Ceded premium and ceded sum insured must use the same %
Rating segmentOccupancy, class or product codePicks the expected band the row is tested against

The formula is simple. Implied rate (‰) = annualised gross premium ÷ sum insured × 1,000.

The expected band comes from the treaty submission, the cedent's rating guide or prior bordereaux. Agree it with the treaty underwriter, segment by segment.

How Does an Exposure to Premium Reconciliation Work on a Real Bordereau?

An exposure to premium reconciliation works by testing each row against its band, then the ceded split, then the total. The figures below are illustrative.

A cedent sends the March bordereau for a 40% property quota share. Five risks are listed.

What does the row-level implied rate test show?

The row-level implied rate test shows three of the five risks outside their expected bands.

RiskSum insuredGross premiumImplied rateExpected bandResult
Office12,000,0009,6000.80‰0.6–1.2‰Pass
Warehouse8,500,0006800.08‰0.9–1.8‰Break
Factory2,450,00036,75015.00‰1.5–3.5‰Break
Retail unit3,200,0004,1601.30‰1.0–2.0‰Pass
Hotel15,000,00000.00‰0.8–1.5‰Break

The warehouse premium of 680 is exactly one twelfth of 8,160. That annual premium gives 0.96‰, inside the band, so the row carries a monthly instalment.

The factory rate of 15.00‰ falls to 1.50‰ if the sum insured is 24,500,000. The query to the cedent is a likely missing digit.

The hotel row has exposure and no premium. It may be premium booked to April, or a risk ceded in error.

What does the ceded share test show?

The ceded share test shows whether the 40% quota share was applied to premium and sum insured alike.

For the retail unit, ceded sum insured is 1,280,000, which is 40% of 3,200,000. Ceded premium is 1,248, which is only 30% of 4,160.

The expected ceded premium is 1,664, so 416 is missing. A 30% share from an earlier treaty year is the first thing to check.

Why does the bordereau total look fine?

The bordereau total looks fine because breaks in opposite directions cancel out.

Total sum insured is 41,150,000 and total gross premium is 51,190. The portfolio implied rate is 1.24‰.

That sits inside a portfolio band of 0.9–1.6‰. A total-only check would pass a bordereau with four broken rows out of five.

Which Exposure to Premium Breaks Appear Most Often?

The exposure to premium breaks that appear most often come from basis mismatches, not wrong data. Each needs a different test and fix.

BreakLikely causeTestFix
Rate far below bandInstalment or deposit premium against full sum insuredPremium × 12, × 4 or × 2 lands in bandAnnualise in the test; keep the cash figure for the account
Rate far above bandMissing digit, or sum insured in thousandsRate ÷ 10 or ÷ 1,000 lands in bandAsk the cedent to confirm and correct the source row
Exposure with no premiumPremium booked in a later month, or risk ceded in errorSearch the next bordereau and the premium registerHold as an open item; remove if not ceded
Premium with no exposure changeEndorsement with additional premium onlyTransaction type is endorsementTest endorsements against the change in sum insured
Ceded % differs between columnsOld share, or share applied to one column onlyCeded premium ÷ gross ≠ ceded SI ÷ gross SIRecalculate at the treaty share
Sum insured counted twiceMulti-location policy with premium at policy levelSame policy reference on several rowsRate at policy level, not location level
Rate swings with no change in riskSum insured and premium in different currenciesCurrency fields differ on one rowConvert at the treaty's rates of exchange
Negative premium, sum insured unchangedCancellation that did not remove exposureCancellation row with positive sum insuredReverse the exposure with the premium

The same logic works for non-property classes with a different denominator, such as turnover for liability.

How Should Teams Close Out Exposure to Premium Breaks Each Period?

Teams should close out exposure to premium breaks with a fixed routine, so open items do not roll silently into the next quarter.

  1. Run the test on every row, not a sample. The worked example shows why totals are not enough.
  2. Classify each break by the table above. A basis break and a data error need different owners.
  3. Raise one query list per cedent. Group rows by break type, with the row reference and the figure you expect.
  4. Age the open items. Carry unresolved rows to the next period with their original month.
  5. Re-run after correction. A corrected file can bring a new break, so test the resubmitted rows again.
  6. Feed the bands back. If a segment fails every month, the band, or the business, has changed.

A rate fall across a whole segment may be soft-market pricing, not an error. That belongs with the treaty underwriter.

Cut-off timing creates many no-premium rows; see bordereaux cut-off dates.

Field naming problems often begin in bordereau template mapping.

Who owns the implied rate bands?

The implied rate bands belong to the treaty underwriter, with the bordereaux team running the test. Operations should not widen a band to clear breaks.

Review bands at each renewal against the submitted rating and prior bordereaux.

How Does Insurnest Support Exposure to Premium Reconciliation?

Insurnest supports the share and register side of exposure to premium reconciliation, not the rate test itself.

Bordereaux Calculation & Reconciliation maintains participation percentages and allocates premium and claims by reinsurer share.

It compares calculated values against bordereaux, master data, the premium register, the claim register and settlement records.

Mismatches appear in one structured view, with a reinsurer-wise status of reconciled or variance to investigate.

That is where an error like the retail unit's 30% share surfaces. Rate bands, annualising and root-cause work stay with your team.

For how unexplained variances turn into lost premium, see ceded premium leakage.

Our reinsurer participation share calculation guide covers the share arithmetic.

Where Should Bordereaux Leaders Start on Exposure to Premium Checks?

Bordereaux leaders should start with last quarter's files from their three largest proportional treaties, and run the row-level test once by hand.

  • Count rows outside band. Note how many of them a total-only check passed.
  • Split breaks by type. Instalments and unit errors usually need different fixes with the cedent.
  • Check the cession % on both columns. Any row where the two shares differ is a direct premium error.
  • Agree bands with underwriting. Write them down per segment before the next quarter's file arrives.
  • Compare with exposure returns. Sums insured in cat exposure returns should be explainable against the bordereaux for the same date.

Key Terms

  • Implied rate: Annualised gross premium divided by sum insured, usually shown per mille (‰).
  • Expected band: The range of implied rates agreed for one rating segment.
  • Ceded share test: A check that ceded premium and ceded sum insured use the same cession percentage.
  • Annualising: Converting an instalment or short-period premium to a full-year figure before testing.
  • Sum insured: The highest amount the insurer can be obliged to pay before policyholder deductibles.

Sources

Frequently Asked Questions

What is exposure to premium reconciliation?

Exposure to premium reconciliation is a check that the risks ceded on a bordereau carry the premium their exposure implies. On property treaties it compares gross premium with sum insured row by row, tests the ceded split, and flags rows whose implied rate falls outside an agreed band.

What is an implied rate test in reinsurance?

An implied rate test divides annualised gross premium by sum insured, usually per mille, and compares the result with an expected band for the rating segment. Rows outside the band are breaks to investigate, such as instalment premiums, unit errors or risks reported without premium.

Why can bordereau totals tie when individual rows are wrong?

Bordereau totals can tie when individual rows are wrong because breaks in opposite directions cancel out. In the worked example, a portfolio implied rate of 1.24 per mille sits inside its band while four of five rows carry premium, sum insured or cession errors.

How do you check the ceded share on a bordereau?

To check the ceded share on a bordereau, divide ceded premium by gross premium and ceded sum insured by gross sum insured for each row. Both ratios should equal the treaty cession percentage. Any difference means the share was applied to one column only, or an old share was used.

How should instalment premiums be handled in exposure checks?

Instalment premiums should be annualised before the exposure check, because a monthly or quarterly instalment set against a full annual sum insured shows an implied rate far below band. The cash figure stays in the account; only the test uses the annual equivalent.

Who should set the expected implied rate bands?

The treaty underwriter should set the expected implied rate bands for each rating segment, using the submission, the cedent's rating guide and prior bordereaux. The bordereaux team runs the test, but should not widen a band simply to clear breaks.

Does exposure to premium reconciliation apply beyond property treaties?

Exposure to premium reconciliation applies beyond property treaties, but the exposure measure changes. Liability business may use turnover or wageroll, motor may use vehicle count and life business may use members or sums assured. The test logic, premium divided by exposure against a band, stays the same.

Does Insurnest run the implied rate test?

Insurnest does not run the implied rate test. Its Bordereaux Calculation & Reconciliation maintains participation percentages, allocates premium and claims by reinsurer share, and compares calculated values against bordereaux and registers, which catches share errors. Implied rate bands and root-cause work stay with the team.

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

Ceded Premium Leakage: Matching Policy Transactions to Treaty Eligibility Automatically

Ceded premium leakage happens when policy transactions slip past treaty eligibility checks. Automated matching connects every transaction to the correct treaty before the bordereaux runs.

Read more
Reinsurance

Cat Exposure Returns to Reinsurers: Accurate Aggregates

Cat exposure returns to reinsurers need accurate peril aggregates. Use this four-stage checklist on scope, location data, aggregation and sign-off every time.

Read more
Reinsurance

Bordereau Template Mapping: Onboard New Cedent Formats Fast

Bordereau template mapping as a reusable specification: header, field map, code tables, control totals and change log, so new cedent formats onboard cleanly.

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.