Reinsurance

Outward Reinsurance Bordereaux Preparation for Cedents: Kit

On this page

Last reviewed: November 2026

The Q2 property bordereau went to five reinsurers on the last day of July. By the end of August, three had sent it back.

One wanted the original template, one found the totals did not match the account, and one asked why it showed 100% premium.

Outward reinsurance bordereaux preparation for cedents is building and checking each treaty's bordereau so reinsurers accept it first time.

It matters because every rejected file delays settlement, and repeated rejections become a renewal conversation.

This guide gives you a rejection-reason table, a 16-item pre-send checklist with owners, a 100-point score and a filled scorecard.

Key Takeaways

  • Use their template. Changed columns break the reinsurer's mapping.
  • Tie to the account. The bordereau total must equal the technical account.
  • Label 100% and share. Never leave the reader to guess which one a column holds.
  • Send less personal data. Only what the treaty needs.

What Is Outward Reinsurance Bordereaux Preparation for Cedents?

Outward reinsurance bordereaux preparation for cedents is the cedent-side process of producing the premium and claims files that reinsurers require.

A bordereau, per the HMRC Lloyd's Manual glossary, gives a reinsurer "details of individual risks insured under a reinsurance treaty".

Reinsurers passing business on to retrocessionaires face a similar task, covered in retrocession bordereaux preparation.

Why Do Reinsurers Reject Outward Bordereaux From Cedents?

Reinsurers reject outward bordereaux from cedents when the file cannot be mapped, does not reconcile, or covers the wrong business.

Rejection reasonWhat the reinsurer seesPrevented by item
Template changedInserted or renamed columns; mapping failsB1
Totals do not tieFile total differs from the technical accountC1
Wrong periodRows dated outside the reporting quarterA2
Mixed treatiesRows for another treaty or yearA3
100% versus share unclearShare premium in a 100% column, or the reverseB4
Unexplained negativesReturn premiums with no original policy linkC3
Unreadable filePassword, macros, merged header cellsD1
Excess personal dataIdentity or health details the treaty does not needB5

Lloyd's premium bordereaux procedure recommends XLSX files that are not password-protected.

It also warns against merged cells, heavy macros and changing heading order. Those are delegated-authority tips, but they suit treaty files too.

Negative rows are covered in negative premiums in reinsurance bordereaux.

What Should a Cedent Check Before Sending an Outward Bordereau?

A cedent should check scope, data, financials and the file itself before sending an outward bordereau, in that order.

ItemCheckOwnerPoints
A. Scope15
A1Treaty, section and underwriting year in file name and headerCeded reinsurance accountant5
A2Every row inside the treaty's reporting periodCeded reinsurance accountant5
A3Rows for other treaties removed or sent separatelyCeded reinsurance accountant5
B. Data35
B1Reinsurer's template used; headers unchanged and in orderReinsurance data analyst8
B2Required fields complete (see below)Reinsurance data analyst8
B3Dates in one agreed format; no text datesReinsurance data analyst5
B4100% amounts and ceded share in separate, labelled columnsReinsurance data analyst8
B5Personal data limited to treaty needReinsurance data analyst6
C. Financials30
C1Totals tie to the technical account for the periodCeded reinsurance accounting manager12
C2Ceded premium and commission recalculated at treaty ratesCeded reinsurance accounting manager8
C3Negative and adjustment rows carry the original policy referenceCeded reinsurance accounting manager5
C4Currency on every row; any conversion rate and date statedCeded reinsurance accounting manager5
D. File and send20
D1XLSX, no password, no macros, no merged header cellsReinsurance data analyst6
D2Version number in file name; resubmissions say what they replaceCeded reinsurance accounting manager5
D3Cover note with row count, totals and known issuesCeded reinsurance accounting manager5
D4Sent to every reinsurer or broker on the treaty's listHead of Reinsurance4

When a file does come back, handle it through bordereau resubmission handling.

Which data fields does an outward bordereau need for each treaty?

The data fields an outward bordereau needs for each treaty are set by the reinsurer's template and the treaty's reporting clause.

Where no template exists, the Lloyd's Coverholder Reporting Standards are a useful reference.

They set a "standardised core data set" for reporting risk, premium and claims data.

Lloyd's procedure lists mandatory fields such as a unique risk reference, which it notes is not the UMR.

Others include risk inception and expiry dates, insured name, premium currency, gross premium, and commission percentage and amount.

Mapping your system fields to a reinsurer's layout is covered in bordereau template mapping.

How much personal data should an outward bordereau carry?

An outward bordereau should carry only the personal data the treaty needs to price, account and settle.

UK GDPR Article 5(1)(c) requires personal data to be "adequate, relevant and limited to what is necessary".

A policy reference often does the job a name and date of birth would. See personal data in bordereaux.

How Do You Score an Outward Bordereau Before It Goes to Reinsurers?

To score an outward bordereau before it goes to reinsurers, give each item its full points if it passes, and zero if it does not.

ScoreStatusAction
90 to 100GreenSend
75 to 89AmberFix failed items before sending, unless the reinsurer agrees in writing
Below 75RedDo not send; rebuild the file

Bands and weights are illustrative. Adjust them once you know which reasons your reinsurers cite most.

Which bordereau errors should block sending regardless of score?

Bordereau errors that should block sending regardless of score are the ones a reinsurer cannot correct for you.

  • C1 fails. Totals do not tie to the technical account.
  • A3 fails. Rows for another treaty are still in the file.
  • B4 fails. Nobody can tell 100% amounts from ceded share.
  • B5 fails. Personal data goes beyond what the treaty needs.

A file can score 88 and still be blocked, because C1 alone is worth 12 points.

What does a filled pre-send scorecard look like?

A filled pre-send scorecard, illustrated below for a Q3 2026 property quota share premium bordereau, shows where points go.

StageItems passedItems failedScore
A. ScopeA1, A2, A3None15 / 15
B. DataB2, B3, B4, B5B1: two columns inserted27 / 35
C. FinancialsC1, C2, C4C3: 14 negative rows without original policy reference25 / 30
D. File and sendD1, D3, D4D2: no version number15 / 20
Total82 / 100: Amber

No blocking item failed. Once the three items are fixed, the re-scored file reaches 100 and goes out green.

How Does Insurnest Help Cedents Check Reinsurer Shares Before Sending?

Reinsurance Bordereaux Reconciliation does not check templates, field formats or personal data, and does not score or send files.

It calculates each reinsurer's premium share, claim liability and net position from configured participation.

It compares those values with bordereaux, premium, claim and settlement records, and shows which positions match and which need review.

That supports items B4, C1 and C2. Your team still investigates each difference before the file goes out.

Key Terms

  • Outward bordereau: A bordereau a cedent sends to its reinsurers for a treaty.
  • Blocking error: A failure that stops sending, whatever the total score.
  • Data minimisation: Holding and sharing only the personal data a purpose needs.

Sources

Frequently Asked Questions

What is outward reinsurance bordereaux preparation for cedents?

Outward reinsurance bordereaux preparation for cedents is the work of building, checking and sending each treaty's premium and claims bordereau so reinsurers can accept and book it first time.

Why do reinsurers reject outward bordereaux from cedents?

Reinsurers reject outward bordereaux from cedents mainly for changed templates, totals that do not tie to the account, wrong periods, mixed treaties, unclear 100% versus share amounts and unreadable files.

What should a cedent check before sending an outward bordereau?

A cedent should check scope, data, financials and the file itself before sending an outward bordereau: 16 items across four stages, each with a named owner and points toward 100.

Which data fields does an outward bordereau need for each treaty?

The data fields an outward bordereau needs for each treaty are set by the reinsurer's template, usually policy reference, inception and expiry, class, sum insured, currency, premium and commission.

How much personal data should an outward bordereau carry?

An outward bordereau should carry only the personal data the treaty needs. Under UK GDPR Article 5(1)(c), personal data must be adequate, relevant and limited to what is necessary.

How do you score an outward bordereau before it goes to reinsurers?

To score an outward bordereau before it goes to reinsurers, award each of 16 checklist items its points, total out of 100, send at 90 or more and fix below that.

Which bordereau errors should block sending regardless of score?

Bordereau errors that should block sending regardless of score are totals that do not tie to the account, rows for another treaty, unclear 100% versus share columns and excess personal data.

What does a filled pre-send scorecard look like?

A filled pre-send scorecard, illustrated for a Q3 2026 property quota share, scores 82 out of 100, with a changed template, unexplained negative rows and no version number to fix.

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

Retrocession Bordereaux Preparation: Fields and Filters

Retrocession bordereaux preparation guide with a premium and risk field list, cession filters for each retro contract and a worked inuring example.

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
Reinsurance

Personal Data in Bordereaux: A Field-by-Field Decision Guide

Personal data in bordereaux needs a rule for every field. This guide shows what to send, minimise, pseudonymise or exclude before files reach reinsurers.

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.