Historical Bordereaux Loading for Reinsurers: Tie-Out Plan
On this page
- Key Takeaways
- What Stages Does Historical Bordereaux Loading for Reinsurers Follow?
- How Should Historical Bordereaux Be Tied Out to the Ledger?
- Where Do Handoffs Break in Historical Bordereaux Loading?
- What Does a Dated Historical Bordereaux Loading Timeline Look Like?
- How Many Years of Bordereaux History Should a Reinsurer Load?
- How Does Insurnest Help Once Historical Periods Are Loaded?
- Key Terms
- Sources
- Frequently Asked Questions
Last reviewed: November 2026
"Load the old files as they are. We will clean them once they are in the new system."
Two years later, 2023 premium in the new system still differs from the ledger by USD 476,000. Nobody knows which file caused it.
Historical bordereaux loading for reinsurers is bringing back-years of cedent bordereaux into a new system.
Done properly, the loaded totals agree with what was booked in the ledger at the time.
This guide gives you a five-stage table, a layout vintage mapping example and a worked five-year tie-out with a tolerance.
Key Takeaways
- Inventory before mapping. Know every file, gap and resubmission first.
- Map by vintage, not by file. Layouts change; each layout gets one mapping.
- Tie out to the ledger. Loaded totals must agree with booked accounts within a tolerance.
- Sign off before load. Once loaded, history is hard to correct.
What Stages Does Historical Bordereaux Loading for Reinsurers Follow?
Historical bordereaux loading for reinsurers follows five stages, each with an owner and evidence kept.
| Stage | Trigger | Action | Owner | Evidence kept |
|---|---|---|---|---|
| 1. File inventory | Decision to load back-years | List every file by cedent, period, version and receipt date; mark gaps and resubmissions | Reinsurance data lead | Inventory with row counts and control totals |
| 2. Vintage mapping | Inventory agreed | Group files by layout; map each layout's columns to target fields | Data lead with bordereaux team | Signed vintage mapping table |
| 3. Validation | Mapping approved | Check row counts, control totals, field rules, date ranges and duplicates | Bordereaux analysts | Validation log per file |
| 4. Tie-out to ledger | Validation passed | Compare totals by year and cedent with booked accounts | Technical accounting | Tie-out schedule with explanations |
| 5. Sign-off and load | All years within tolerance | Approve, load and freeze source files | Head of reinsurance accounting and data owner | Sign-off memo |
Why does a file inventory come first in historical bordereaux loading?
A file inventory comes first in historical bordereaux loading because gaps and resubmissions must be known before mapping.
Record each file's row count and control total at inventory. Later stages compare against those numbers.
Where a cedent sent a resubmitted file, record which version it replaces. Bordereau resubmission handling sets the rules.
What are layout vintages in historical bordereaux?
Layout vintages in historical bordereaux are runs of periods in which a cedent used the same file layout.
Even market standards change.
Lloyd's Coverholder Reporting Standards v5.2 added fields, such as Spanish risk postcodes from 1 June 2019. Older files lack them.
Below is an illustrative vintage map for one cedent's quota share, 60 monthly files from 2021 to 2025.
| Vintage | Periods (files) | Layout | Key difference | Mapping rule |
|---|---|---|---|---|
| V1 | Jan 2021 to Jun 2022 (18) | 18 columns, one sheet | "Premium" is net of 25% commission; no currency column; day-first dates | Gross = premium ÷ 0.75; currency USD; parse day first |
| V2 | Jul 2022 to Dec 2023 (18) | 24 columns | Gross premium and commission split; currency column added | Map directly; check commission is 25% of gross |
| V3 | Jan 2024 to Dec 2025 (24) | 31 columns, risk and premium tabs | Tabs joined by policy number; transaction type added | Join on policy and endorsement number; use transaction type |
A V1 row showing USD 7,500 premium loads as USD 10,000 gross, because 7,500 ÷ 0.75 = 10,000.
Mapping one vintage at a time is covered in bordereau template mapping.
What should validation check in historical bordereaux before tie-out?
Validation of historical bordereaux before tie-out should check each file against its inventory row count and control total.
Then test field rules: dates inside the period, no blank policy numbers, currencies on the treaty list and no duplicate rows.
Log every fix by file. A quality score per cedent, as in ceded data quality scores, shows where to look first.
How Should Historical Bordereaux Be Tied Out to the Ledger?
Historical bordereaux should be tied out to the ledger by comparing loaded premium with booked premium by year and cedent.
Here, the tolerance is 0.1% of each year's booked premium. Figures are illustrative.
| Year | Files | Loaded bordereaux premium (USD) | Booked ledger premium (USD) | Difference (USD) | Tolerance (USD) | Result |
|---|---|---|---|---|---|---|
| 2021 | 12 | 18,420,000 | 18,420,000 | 0 | 18,420 | Pass |
| 2022 | 12 | 21,035,400 | 21,050,000 | -14,600 | 21,050 | Pass |
| 2023 | 12 | 23,912,000 | 24,388,000 | -476,000 | 24,388 | Fail |
| 2024 | 12 | 26,104,250 | 26,090,000 | +14,250 | 26,090 | Pass |
| 2025 | 12 | 28,760,000 | 28,760,000 | 0 | 28,760 | Pass |
| Total | 60 | 118,231,650 | 118,708,000 | -476,350 |
The yearly differences add to the total: 0 − 14,600 − 476,000 + 14,250 + 0 = −476,350.
The 2023 gap was the original October 2023 file, loaded instead of its resubmission, which was USD 476,000 higher.
After the swap, 2023 shows zero difference. The remaining total gap of −USD 350 is rounding, within tolerance in both years.
What tolerance should a historical bordereaux tie-out use?
A historical bordereaux tie-out should use a tolerance agreed with finance before testing, so nobody moves it afterwards.
Set it tight enough that one missing monthly file fails. Here, one month is about USD 2m against a tolerance near USD 24,000.
Where Do Handoffs Break in Historical Bordereaux Loading?
Handoffs break in historical bordereaux loading where one team assumes another has already checked the totals.
- Inventory to load. The loader picks files by name, not by the version the inventory marked.
- Mapping to validation. A vintage rule, such as net to gross, is applied to the wrong periods.
- Data to finance. Data signs off row counts; finance assumed it signed off money.
- Project to operations. Source files are not frozen, so someone "fixes" one after sign-off.
Each break leaves a gap that only the tie-out finds. Keep lineage notes, as in reinsurance data lineage.
Wider system risks are covered in managing change risk during core system migration.
What Does a Dated Historical Bordereaux Loading Timeline Look Like?
A dated historical bordereaux loading timeline for 60 monthly files runs about six weeks. This one is illustrative.
| Date | Event |
|---|---|
| 4 Jan 2027 | Kick-off: one cedent, 2021 to 2025, tolerance agreed at 0.1% |
| 8 Jan 2027 | Inventory: 63 files received, 3 are resubmissions, 60 periods |
| 15 Jan 2027 | Vintage map for V1 to V3 signed |
| 29 Jan 2027 | Validation complete; two date-range errors fixed in V2 |
| 5 Feb 2027 | Tie-out: 2023 fails by USD 476,000 |
| 9 Feb 2027 | Cause found: October 2023 original loaded; resubmission swapped in |
| 12 Feb 2027 | All years pass; sign-off memo issued; files frozen |
How Many Years of Bordereaux History Should a Reinsurer Load?
A reinsurer should load as many years of bordereaux history as its pricing and reserving need to see trends.
Solvency II Delegated Regulation 2015/35, Article 19 treats data as complete when it holds enough history to identify trends.
The same article expects data from different periods to be consistent. That is what vintage mapping protects.
For development data, see loss triangle data preparation.
How Does Insurnest Help Once Historical Periods Are Loaded?
Reinsurance Bordereaux Reconciliation does not load historical files, map layouts or convert formats.
Once periods are in, it calculates each reinsurer's share of premium and claims from configured participation.
It compares those values with bordereaux, master and settlement records, and flags differences for investigation.
Allocated totals tie back to the bordereaux received. The platform identifies the difference; finance teams determine the cause.
Key Terms
- Layout vintage: A run of periods in which a cedent sent bordereaux in one layout.
- Tie-out: A comparison of loaded totals with booked amounts, with differences explained.
- Tolerance: The largest difference accepted without investigation, agreed before testing.
Sources
- EIOPA Solvency II rulebook: Delegated Regulation (EU) 2015/35, Article 19
- Lloyd's: Coverholder Reporting Standards User Guide, Version 5.2 (20 August 2019)
- Insurnest: Reinsurance Bordereaux Reconciliation
Frequently Asked Questions
What stages does historical bordereaux loading for reinsurers follow?
Historical bordereaux loading for reinsurers follows five stages: file inventory, layout vintage mapping, validation, tie-out to the booked ledger and sign-off before load.
Why does a file inventory come first in historical bordereaux loading?
A file inventory comes first in historical bordereaux loading because missing months, duplicates and resubmitted files must be known before anything is mapped or loaded.
What are layout vintages in historical bordereaux?
Layout vintages in historical bordereaux are groups of periods in which a cedent used the same file layout. Each vintage needs its own mapping to the target fields.
How should historical bordereaux be tied out to the ledger?
Historical bordereaux should be tied out to the ledger by comparing loaded totals with booked amounts by year and cedent, then explaining every difference above an agreed tolerance.
What tolerance should a historical bordereaux tie-out use?
A historical bordereaux tie-out should use a tolerance agreed with finance before testing starts, such as 0.1% of booked premium per year, so rounding passes and missing files fail.
Where do handoffs break in historical bordereaux loading?
Handoffs break in historical bordereaux loading between inventory and load, mapping and validation, and data and finance, where each team assumes the other checked the totals.
What does a dated historical bordereaux loading timeline look like?
A dated historical bordereaux loading timeline runs from kick-off through inventory, mapping, validation and tie-out to sign-off, about six weeks for 60 monthly files in the example.
How many years of bordereaux history should a reinsurer load?
A reinsurer should load as many years of bordereaux history as its pricing and reserving need to see trends, and no fewer than its triangles and treaty periods require.

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 →