Life Reinsurance Cession Administration Off Spreadsheets

Life Reinsurance Cession Administration: Moving Policy-Level Cessions Off Spreadsheets

Last reviewed: November 2026

Your life book may hold hundreds of thousands of reinsured policies. The record of what you actually reinsure can still live in a workbook one analyst understands.

Short answer: Life reinsurance cession administration moves off spreadsheets when treaty terms, cedent file mappings and roll-forward checks live in one governed process. Migrate cedent by cedent, run in parallel, and retire each workbook only after results match.

Key Takeaways

• Cession administration is a lifecycle, not a file load. Every policy change after issue alters premium, amount at risk or both.
• Most data arrives in the cedent's format. The reinsurer's real job is to translate, check and reconcile it.
• Roll-forward first, dashboards later. If opening plus movements does not equal closing, nothing downstream is reliable.
• Migrate cedent by cedent. A big-bang switch hides breaks that a parallel run would expose.

What Is Life Reinsurance Cession Administration?

Life reinsurance cession administration records each reinsured policy and every event that changes it. The goal is a correct in-force record, correct premiums and a clean base for claims and reserves.

The SOA's Commentary on Life Reinsurance Treaties lists what reporting must cover. That means new business, premium calculations, policy changes, terminations, claims and statistical data such as reserves and policy counts.

Which events change a cession after issue?

Face amount changes and terminations are the most common. Terminations include lapses, expiries, surrenders, replacements, conversions, reinstatements and recaptures.

Each event needs its own treatment. A conversion, for example, may continue the cession at the original issue age under the treaty's conversion terms.

How Do the Main Administration Models Differ?

Life reinsurance is administered in three main ways, and each puts the data burden in a different place. In the US, most life reinsurance is self-administered by the cedent.

An SOA Reinsurance 101 session notes the cedent prepares billings, in-force listings and transaction listings. It names lack of uniformity in cedent data as the challenge for reinsurers.

Why Do Spreadsheets Break Down?

Spreadsheets break down because they hold rules, data and history in one place that nobody governs. They work for one treaty and fail quietly at fifty.

Why does every cedent report differently?

Reinsurers often accept many reporting formats out of necessity, not choice. The SOA commentary also notes cedents sometimes change their format without telling the reinsurer.

Each new layout means a new set of manual mapping steps. Each step is a place where a column shifts and nobody notices.

Are treaties administered as written?

The SOA's Life Reinsurance Treaty Construction study found billing errors arising where administration differs from treaty language. Participants described older treaties that could not be administered as written.

Not always, and a spreadsheet hides that gap inside formulas. A governed rule makes it visible and forces a decision.

What happens when the workbook owner leaves?

Workbooks grow through years of fixes and special cases. When their author leaves, the logic often leaves too.

For the wider pattern, see our guide to spreadsheet-dependent treaty administration.

What Should a Policy-Level Cession Record Hold?

A policy-level cession record should hold enough to recalculate premium and amount at risk without opening the cedent's files. If you cannot recalculate it, you cannot check it.

• Cedent, treaty and treaty version reference
• Policy number and a stable insured identifier
• Issue date, issue age, sex, smoker and underwriting class
• Rating, such as table ratings or flat extras
• Face amount, cedent retention and ceded amount
• Reinsurance basis, such as YRT or coinsurance
• Transaction type and effective date for each change
• Premium billed by the cedent for the period

What Should the Treaty Say About Reporting?

The treaty should say what the cedent reports, how often, how fast and in what detail. Vague reporting clauses become permanent manual work for the reinsurer.

The SOA commentary suggests treaties set four things. Each one decides how much checking the reinsurer can automate.

Agree these terms at treaty set-up, not after the first late file. They are far harder to change once a cedent's process is built.

How Does a Cession Roll-Forward Catch Errors?

A cession roll-forward catches errors by forcing every movement to explain the change in the in-force book. Breaks point straight at missing or duplicated transactions.

Here is an illustrative example for one cedent and one month.

The 35 policies may be unreported terminations, a dropped file row or duplicates last month. Run the same test on amounts at risk and premiums, not just counts.

How Do You Move Cession Administration Off Spreadsheets?

Move cession administration in controlled steps, one cedent at a time. Each step should leave the old and new results side by side.

1. Inventory the estate. List every cedent, treaty, file format and workbook in the cession process.
2. Codify treaty terms. Capture retentions, shares, reinsurance basis, rate references and allowances as structured data.
3. Standardise intake. Map each cedent's layout to one internal cession record, with field-level checks.
4. Rebuild the core checks. Run the roll-forward and premium recalculation every period.
5. Run in parallel. Compare the new results with the spreadsheet for several cycles, including a quarter end.
6. Retire and monitor. Switch off the workbook for that cedent and keep an exception queue for breaks.

Explain every difference in step five before moving on. A reduced difference is not an explained one.

Which Tasks Should Move First?

Move high-volume tasks with direct financial impact first. Leave rare, judgement-heavy work until the core record is stable.

Where Does Automation Help?

Automation helps by applying the same treaty rules and checks to every cedent file. It does not interpret ambiguous wording or decide how a break is settled.

Reinsurance treaty management holds treaty terms, retention and share configuration, premium calculation rules and amendment versions in one place. That gives cession checks a structured, auditable source of terms instead of a workbook tab.

Bordereaux calculation and reconciliation can then compare reported premiums and claims with calculated shares. The platform identifies the difference, and administrators and finance teams determine the cause.

Hidden workbooks often outlive the system meant to replace them. Our article on shadow spreadsheets replacing the system of record explains why.

Which Metrics Show Progress?

Track metrics that show less manual handling and fewer unexplained breaks. Report them by cedent, so weak data sources stand out.

What Should Life Reinsurance Operations Leaders Do Next?

Life reinsurance operations leaders should map the current estate before choosing tools. The first three actions need no new system.

• List every workbook that touches cession data and name its owner.
• Run a count and amount roll-forward for your three largest cedents.
• Agree a minimum cession record with each cedent at the next review.
• Pick one cedent for a structured pilot and parallel run.

Key Terms

• Cession: The portion of a policy's risk transferred to a reinsurer, with its own record and premium.
• Self-administered reinsurance: The cedent prepares billings and listings and reports them to the reinsurer.
• Bulk reinsurance: Administration using summary data only, with no individual policy details.
• Roll-forward: A reconciliation of opening in force, movements and closing in force.
• Retention: The amount of each life the cedent keeps for its own account.
• Recapture: The cedent taking back previously reinsured business under treaty terms.

Sources

• Society of Actuaries: Commentary on Life Reinsurance Treaties (1994)
• Society of Actuaries: Reinsurance 101, 2019 Annual Meeting Session 026
• Society of Actuaries: Life Reinsurance Treaty Construction (March 2013)
• Insurnest: Reinsurance Treaty Management