Reinsurance

Deductible Checks on Reinsurance Bordereaux: Worked Maths

On this page

Last reviewed: November 2026

The storm bordereau showed 500 claims and a total just over the cat retention. The broker asked for a cash call.

Nobody had checked whether those claims were before or after each homeowner's own deductible.

Deductible checks on reinsurance bordereaux confirm that each claim row deducts the policy deductible before any treaty share is applied.

A deductible missed on every row inflates quota share recoveries and can push an excess of loss layer into a claim.

This guide gives you a treaty loss formula, a worked windstorm claim, a cat layer sensitivity test and copy-ready sanity tests.

Key Takeaways

  • Cede the net, not the ground-up. The treaty shares what the cedent pays after the policy deductible.
  • Check the percentage base. 2% of sum insured and 2% of loss give very different deductibles.
  • Small errors add up in events. A fixed deductible missed on 500 claims can trigger a layer.
  • Track aggregates as balances. An annual aggregate deductible needs a running column per policy.

What Are Deductible Checks on Reinsurance Bordereaux?

Deductible checks on reinsurance bordereaux are row-level tests that the claim amount ceded is net of the policyholder's deductible.

They sit beside rate checks on reinsurance bordereaux: one tests premium, the other tests the claim figure.

Why does the word deductible mean two things in reinsurance?

The word deductible means two things in reinsurance, and bordereau teams must keep them apart.

This guide checks the first. The second is applied later, to the cedent's net loss.

How Do Policy Deductibles Change the Treaty Loss on a Bordereau?

Policy deductibles change the treaty loss on a bordereau by cutting the ground-up loss before any reinsurance calculation starts.

The Munich Re glossary defines ground-up loss as loss before deductions for reinsurance and before any deductible.

TREATY LOSS FORMULA (per claim)
Deductible (fixed)       = D
Deductible (% of SI)     = p x Sum insured
Deductible (% of loss)   = p x Ground-up loss
Policy loss payable      = MIN( MAX(Ground-up - Deductible, 0), Sum insured )
Quota share ceded        = Policy loss payable x Ceded %
Excess of loss recovery  = MIN( MAX(Net event loss - Retention, 0), Limit )

Sum insured caps the loss after the deductible, not before. Check the wording if the policy says otherwise.

What Does a Worked Deductible Check Show on One Windstorm Claim?

A worked deductible check on one windstorm claim shows how two common mistakes overstate a quota share recovery.

Illustrative facts: sum insured 2,000,000, windstorm deductible 2% of sum insured, ground-up loss 300,000, 40% quota share.

MethodDeductiblePolicy loss payable40% cededOverstated by
Right: 2% of sum insured40,000260,000104,0000
Wrong: ground-up reported0300,000120,00016,000
Wrong: 2% of loss6,000294,000117,60013,600

One claim is overstated by up to 15.4%. Across a storm portfolio, the same error repeats on every row.

How should a percentage deductible be calculated on a bordereau claim?

A percentage deductible on a bordereau claim should be calculated on the base the policy names, which the bordereau must carry as its own field.

Ask for three columns: deductible type (fixed, % of sum insured, % of loss), deductible rate and deductible amount applied.

If only an amount is supplied, recompute it from type and rate on a sample and query any gap.

How Much Can Ground-Up Reporting Move an Excess of Loss Recovery?

Ground-up reporting can move an excess of loss recovery from nil to a claim when the event sits near the retention.

Illustrative event: 500 home claims, each with a fixed 1,500 deductible, and a cat excess of loss of 15m excess of 10m.

BasisEvent lossOver 10m retentionRecovery claimed
Ground-up (deductibles missed)10,500,000500,000500,000
Net of deductible (500 x 1,500 = 750,000 off)9,750,00000
Sensitivity: average deductible missedEvent loss reportedRecovery claimed
50010,000,0000
1,00010,250,000250,000
1,50010,500,000500,000

Every 1,000 of deductible missed per claim adds 500,000 to this event. Log the corrected figure in your event loss tracking.

What should a reinsurer ask for when a claims bordereau looks ground-up?

A reinsurer that suspects a ground-up claims bordereau should ask the cedent to restate a sample before paying any cash call.

  • Sample: the 20 largest claims, with policy schedule pages showing deductible type and amount.
  • Restatement: ground-up, deductible applied and net paid as three separate columns.
  • Confirmation: a signed note that the event total is net of all policy deductibles.

How Should Aggregate Deductibles Be Tracked on Claims Bordereaux?

Aggregate deductibles on claims bordereaux should be tracked per policy year with a running balance, because each claim uses up part of one pot.

Illustrative policy: annual aggregate deductible 25,000, three claims in the same policy year.

ClaimGround-upDeductible left beforeDeductible appliedPayableLeft after
110,00025,00010,000015,000
212,00015,00012,00003,000
38,0003,0003,0005,0000

A bordereau that applies 25,000 to claim 3 alone shows nil payable and hides a 5,000 ceded loss.

Ask the cedent to report the deductible left after each claim, not just the amount applied.

Which Sanity Tests Catch Deductible Errors on a Bordereau?

Sanity tests that catch deductible errors on a bordereau compare the deductible with sum insured, the loss and the paid amount.

Assume H sum insured, I deductible type, J deductible rate, K deductible amount, L ground-up loss and M net paid.

Deductible above sum insured        =K2>H2
Percentage stored as whole number   =AND(I2<>"Fixed", J2>1)
% of SI deductible recompute gap    =AND(I2="% SI", ABS(K2-J2*H2)>1)
Paid equals ground-up, deductible>0 =AND(K2>0, M2=L2)
Net plus deductible mismatch        =AND(L2>K2, ABS(M2+K2-L2)>1)
Paid on loss below deductible       =AND(L2<=K2, M2>0)
Deductible missing on property row  =OR(ISBLANK(K2), K2=0)

The net plus deductible test needs a loss above the deductible and no sum insured cap. Exclude capped claims first.

Treat a zero deductible on a class that always carries one as a query, not an error.

For class-specific fields, see property bordereaux for reinsurers.

Deductibles also leak in storms; see the deductible leakage problem in severe convective storm reinsurance.

How Does Insurnest Help After Deductible Checks Are Done?

Reinsurance Bordereaux Reconciliation does not recalculate policy deductibles or test deductible fields on a bordereau.

It calculates claim liability by reinsurer from configured participation and builds each reinsurer's net position.

It compares those calculated values with bordereaux, claim and settlement records and marks positions as matched or needing review.

Where a variance appears, the platform shows the difference. Your claims team decides whether a deductible caused it.

Key Terms

  • Ground-up loss: The loss before any policy deductible or reinsurance is applied.
  • Aggregate deductible: A deductible that applies once across all claims in a policy year.
  • Retention: The cedent's own share of a loss before an excess of loss treaty pays.

Sources

Frequently Asked Questions

What are deductible checks on reinsurance bordereaux?

Deductible checks on reinsurance bordereaux confirm that each claim row applies the policy deductible correctly, so the ceded loss is net of what the policyholder bears.

Why does the word deductible mean two things in reinsurance?

The word deductible means two things in reinsurance: the policyholder's excess on the original policy, and the cedent's retention under an excess of loss treaty.

How do policy deductibles change the treaty loss on a bordereau?

Policy deductibles change the treaty loss on a bordereau by reducing the ground-up loss before any quota share or excess of loss calculation. Ceding ground-up figures overstates recoveries.

What does a worked deductible check show on one windstorm claim?

A worked deductible check on one windstorm claim with a 2% of sum insured deductible shows a 40% quota share ceding 104,000, not 120,000 ground-up or 117,600.

How should a percentage deductible be calculated on a bordereau claim?

A percentage deductible on a bordereau claim should be calculated on the base the policy names, usually sum insured or loss. Applying the wrong base understates the deductible.

How much can ground-up reporting move an excess of loss recovery?

Ground-up reporting can move an excess of loss recovery from nil to a claim. In the illustration, 500 fixed deductibles of 1,500 push a 9.75m event over a 10m retention.

How should aggregate deductibles be tracked on claims bordereaux?

Aggregate deductibles on claims bordereaux should be tracked per policy year with a running balance column, so each claim applies only the deductible still unused.

Which sanity tests catch deductible errors on a bordereau?

Sanity tests that catch deductible errors on a bordereau include deductible above sum insured, percentage stored as whole number, paid equal to ground-up, and net plus deductible mismatching.

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

Rate Checks on Reinsurance Bordereaux: Rule Spec & Example

rate checks on reinsurance bordereaux: a field-by-field rule spec, the exceptions to allow and a worked 1.2‰ vs 2.0‰ example that finds premium ceded cheaply.

Read more
Reinsurance

Property Bordereaux for Reinsurers: Error Catalogue & Fixes

property bordereaux for reinsurers: an error catalogue for locations, sums insured and building codes, with detection rules, fixes and a 10x outlier example.

Read more
Reinsurance

The Deductible Leakage Problem in Severe-Convective-Storm Reinsurance

The deductible leakage problem in severe-convective-storm reinsurance is eroding treaty economics. Learn how misapplied wind and hail deductibles leak into treaty layers and how rules engines can audit them.

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.