Bordereaux Intelligence
Row-Level Validation.
Before the Reinsurer Sees It.
CedeOS catches the five systematic error categories that manual review misses — before submission, not after the debit note.
The condition
The bordereaux you submit reflects data from October 10. The policy cancelled on October 14.
Week 8 of the quarter. Your actuary has rebuilt the reconciliation spreadsheet three times because someone added a column. The bordereaux from your largest MGA arrived as a PDF — again. Two rows have cession rates that don't match the treaty schedule. A senior actuary found them because of a rounding pattern noticed by chance.
Manual validation cannot cover every row. A team of three actuaries cannot read 3,000 rows against an 80-page treaty document every quarter. They check totals. They check the big numbers. They miss the systematic errors — because systematic errors look correct in aggregate. The ones they miss accumulate until a debit note arrives.
The cost
Three consequences. All preventable. None visible without row-level validation.
Premium leakage you cannot see
Systematic misclassification errors average 2.5% of GWP. At KES 2B GWP, that is KES 50M per year leaving through errors that pass every manual spot-check — because they are correct in aggregate and wrong on every individual row.
KES 50M/yr at KES 2B GWP · Calculation: 2.5% industry leakage rate × GWP
Post-submission disputes that consume actuarial capacity
A debit note dispute takes 3–14 weeks to resolve. The actuary tracing cancelled policies and locating original treaty clauses is not doing IFRS 17 close work. The dispute cost is not the amount in question — it is the 14 weeks of misdirected capacity.
14-week post-submission disputes · East African reinsurance XL program analysis
IFRS 17 exposure on unsigned figures
The CFO signs financial statements derived from bordereaux figures that have never been formally validated. The auditor traces the CSM back to source. The answer is a shared drive named Q2_recon_v4_FINAL_actual.xlsx.
IFRS 17 CSM traceability required from 2023 · Not optional under external audit
The standard
What a validated reinsurance submission looks like.
< 3 hrs
Quarterly close
vs. 6-week manual baseline from insurer interviews
Zero
Post-submission disputes
With pre-submission validation — East African composite insurer, Q3 2024
5
Error categories caught per submission
All systematic — none visible without row-level check
100%
Row coverage
Every row validated, not spot-checked totals
Pilot outcome
Kenyan composite insurer, Q3 2024: a 14-week post-submission dispute cycle was eliminated with pre-submission validation. Bordereaux validation identified five error categories across 3,000+ rows before submission — zero reinsurer queries on the validated bordereaux.
Advisory
Former Chief Actuary · East African reinsurer · Advisory engagement, 2024
Validated metric
KES 4M+
Average aggregate retention breach value recovered per event
Kenyan reinsurance treaty analysis. XL program — KES 50M threshold, KES 54M cumulative settlement. CedeOS internal, 2024.
How it works — the mechanism
Five error categories. Applied to every row. Before submission.
The CedeOS validation taxonomy was developed from analysis of East African and Asian bordereaux data and validated with chief actuaries across target markets. Each category has defined detection rules, treaty clause mapping, and impact quantification logic.
Cession Rate Misclassification
A vehicle coded as property and ceded at 40% instead of 30% looks correct in aggregate when mixed with legitimate property cessions. It is wrong on every row.
KES 10M cumulative per quarter on 200 misclassified policies
East African XL program analysis · CedeOS internal, 2024
Reinstatement Premium Miscalculation
Your system calculates reinstatement on current premium after a mid-term endorsement. The treaty specifies original annual premium. The difference accumulates silently until an audit.
KES 110K per XL trigger event
Kenyan composite insurer portfolio analysis · CedeOS internal, 2024
Wrong-Date Currency Conversion
The treaty requires transaction-date central bank rates. The accounting system uses month-end rates. On 400 rows across a quarter, the difference is material to the CFO's financial statements.
USD 34K per quarter
Multi-currency portfolio, East African insurer · CedeOS internal, 2024
Undetected Aggregate Retention Breach
Accumulation was tracked in a spreadsheet. Two motor claims settled in weeks 10 and 11 exceeded the XL threshold by KES 4M. The treaty should have responded. It did not, because no system was monitoring in real time.
KES 4M+ unrecovered per breach event
Kenyan reinsurance treaty analysis · KES 50M threshold, KES 54M cumulative
Cancelled Policies on Bordereaux
Policies cancelled after the extract date remain on the bordereaux. The reinsurer issues a debit note. You dispute it. Weeks of actuary time to locate the policy certificate.
3 weeks actuary time per dispute
Post-submission dispute frequency · East African XL program, 2024
Validation methodology
Validation taxonomy developed from analysis of East African XL program bordereaux data. Each error category has defined detection rules, treaty clause citation logic, and financial impact quantification. Attribution: CedeOS internal analysis, 2023–2024. 40+ column naming conventions normalised automatically — verified count from ingestion engine.
The pipeline
From any format to validated submission in three steps.
Ingest
Bordereaux arrives via email, SFTP, dashboard upload, or REST API — in Excel, CSV, PDF, or direct system export. 40+ column naming conventions normalised automatically. No reformatting required before ingestion.
Validate
Every row checked against every applicable treaty rule simultaneously. Cession rates, currency dates, reinstatement calculations, aggregate accumulation, and policy status — all five categories in a single pass. Each deviation cited to its treaty clause.
Submit
A validated submission with every deviation flagged, explained, and traceable to its treaty clause. Audit trail is machine-readable. The reinsurer receives accurate figures. The dispute does not start.
Regulatory compliance
Every submission meets the regulator's requirements. Automatically.
IRA Kenya
Quarterly XML submission in IRA-native format. Validation rules embedded. Cancelled policy disputes eliminated before submission reaches the regulator.
NAICOM Nigeria
40% minimum retention checked on every bordereaux row. Wrong cession rate equals regulatory breach. CedeOS prevents it before submission.
FSCA South Africa
IFRS 17 audit trail requirements satisfied. Every transformation logged. CSM figures traceable to source policy. POPIA-compliant data residency by architecture.
SAMA Saudi Arabia
Bordereaux accuracy for Takaful pools. In-country data processing enforced. Wakala and conventional structures separated at ingestion.
The path
From first bordereaux to validated submission in four weeks.
Download the Technical Brief
Architecture, validation taxonomy, data residency approach, regulatory coverage. Everything your chief actuary needs to evaluate the validation engine. No commitment.
Pilot Assessment
Submit one quarter of bordereaux data. We return a validation report showing which of the five error categories were present, the financial impact per category, and treaty clause citations for each deviation.
Live Demo
A 20-minute session using your actual bordereaux data. We show you the errors before you submit them — with treaty clause citation and financial quantification for each one.
First Validated Submission
Pilot go-live. First quarterly close with CedeOS. Target: under 3 hours. Zero open disputes. Full IFRS 17 audit trail ready for external review.
Kenyan composite insurer, Q3 2024: a 14-week post-submission dispute cycle was eliminated with pre-submission validation. First fully validated submission completed without reinsurer query.
Anonymized pilot outcome · East African reinsurance XL program · CedeOS pilot, 2024
Your next submission should have zero disputes.
Start with the technical brief. Request a pilot assessment when ready. Book a live demo when you want to see your own bordereaux validated.
Your next quarterly close should take 3 hours. Start your pilot assessment