Outward Reinsurance Bordereaux Preparation for Cedents: Kit
On this page
- Key Takeaways
- What Is Outward Reinsurance Bordereaux Preparation for Cedents?
- Why Do Reinsurers Reject Outward Bordereaux From Cedents?
- What Should a Cedent Check Before Sending an Outward Bordereau?
- How Do You Score an Outward Bordereau Before It Goes to Reinsurers?
- How Does Insurnest Help Cedents Check Reinsurer Shares Before Sending?
- Key Terms
- Sources
- Frequently Asked Questions
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 reason | What the reinsurer sees | Prevented by item |
|---|---|---|
| Template changed | Inserted or renamed columns; mapping fails | B1 |
| Totals do not tie | File total differs from the technical account | C1 |
| Wrong period | Rows dated outside the reporting quarter | A2 |
| Mixed treaties | Rows for another treaty or year | A3 |
| 100% versus share unclear | Share premium in a 100% column, or the reverse | B4 |
| Unexplained negatives | Return premiums with no original policy link | C3 |
| Unreadable file | Password, macros, merged header cells | D1 |
| Excess personal data | Identity or health details the treaty does not need | B5 |
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.
| Item | Check | Owner | Points |
|---|---|---|---|
| A. Scope | 15 | ||
| A1 | Treaty, section and underwriting year in file name and header | Ceded reinsurance accountant | 5 |
| A2 | Every row inside the treaty's reporting period | Ceded reinsurance accountant | 5 |
| A3 | Rows for other treaties removed or sent separately | Ceded reinsurance accountant | 5 |
| B. Data | 35 | ||
| B1 | Reinsurer's template used; headers unchanged and in order | Reinsurance data analyst | 8 |
| B2 | Required fields complete (see below) | Reinsurance data analyst | 8 |
| B3 | Dates in one agreed format; no text dates | Reinsurance data analyst | 5 |
| B4 | 100% amounts and ceded share in separate, labelled columns | Reinsurance data analyst | 8 |
| B5 | Personal data limited to treaty need | Reinsurance data analyst | 6 |
| C. Financials | 30 | ||
| C1 | Totals tie to the technical account for the period | Ceded reinsurance accounting manager | 12 |
| C2 | Ceded premium and commission recalculated at treaty rates | Ceded reinsurance accounting manager | 8 |
| C3 | Negative and adjustment rows carry the original policy reference | Ceded reinsurance accounting manager | 5 |
| C4 | Currency on every row; any conversion rate and date stated | Ceded reinsurance accounting manager | 5 |
| D. File and send | 20 | ||
| D1 | XLSX, no password, no macros, no merged header cells | Reinsurance data analyst | 6 |
| D2 | Version number in file name; resubmissions say what they replace | Ceded reinsurance accounting manager | 5 |
| D3 | Cover note with row count, totals and known issues | Ceded reinsurance accounting manager | 5 |
| D4 | Sent to every reinsurer or broker on the treaty's list | Head of Reinsurance | 4 |
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.
| Score | Status | Action |
|---|---|---|
| 90 to 100 | Green | Send |
| 75 to 89 | Amber | Fix failed items before sending, unless the reinsurer agrees in writing |
| Below 75 | Red | Do 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.
| Stage | Items passed | Items failed | Score |
|---|---|---|---|
| A. Scope | A1, A2, A3 | None | 15 / 15 |
| B. Data | B2, B3, B4, B5 | B1: two columns inserted | 27 / 35 |
| C. Financials | C1, C2, C4 | C3: 14 negative rows without original policy reference | 25 / 30 |
| D. File and send | D1, D3, D4 | D2: no version number | 15 / 20 |
| Total | 82 / 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
- HMRC: Lloyd's Manual glossary (LLM11000)
- Lloyd's: Delegated Data Manager premium bordereaux standard operating procedure
- Lloyd's: Coverholder reporting standards
- Information Commissioner's Office: Principle (c): Data minimisation
- Insurnest: Reinsurance Bordereaux Reconciliation
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
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 →