Reinsurance

Credit Life Bordereaux: Validating Lender-Sourced Data

On this page

Last reviewed: November 2026

The lender's monthly file lands two days late, with 40,000 loans and a premium total that is 6% up on last month.

Lending volumes did not grow 6%. Nobody can tell whether the jump is new loans, a rate change or prepaid loans still being charged.

Credit life bordereaux are periodic listings of insured loans, premiums and claims under a credit life programme, built from the lender's own loan system.

Validating them means testing every row against rules that turn loan data into insurance data, before ceded premium and claims reach reinsurers.

Key Takeaways

  • A loan system is not an insurance system. Loan fields must be translated into sum insured, premium and cover status.
  • Recalculate premium, do not accept it. The rate, the basis and the balance must all agree.
  • Aggregate by borrower, not by loan. Several small loans can breach the free cover limit together.
  • Closed loans are a premium and claims risk. Cover ends at closure, even if the lender keeps charging.
  • Grade each failure. Some rows should be rejected, others queried or accepted with a flag.

Why Is Lender-Sourced Credit Life Data Hard to Validate?

Lender-sourced credit life data is hard to validate because the lender's systems were built to manage loans, not insurance cover.

The lender knows the disbursed amount, outstanding balance, instalment and loan status. The treaty needs sum insured, premium, entry age and cover dates.

Every translation step is a place for error. A restructured loan may get a new ID while the old one stays active, and two loans then carry cover for one debt.

Mapping each lender's columns to your standard fields comes first. Our guide to bordereau template mapping covers that step.

Borrower data in these files is personal data. See personal data in bordereaux for handling it.

Which Validation Rules Should a Credit Life Bordereau Pass?

A credit life bordereau should pass rules on identity, age, dates, amounts, premium and status.

Product terms set the exact limits, so the values below are illustrative.

#FieldRuleFailure exampleAction
1Loan IDUnique within the periodRestructured loan reported under old and new IDsReject duplicate
2Borrower IDPresent and stable across loans and monthsSame borrower with two ID formatsQuery lender
3Date of birthEntry age within product limitsEntry age 67 where the maximum is 65Reject row
4Age at maturityEntry age plus term within maximum cover ageAge 60 with a 10-year loan, maximum 65 at expiryQuery; cover may stop early
5Cover start dateWithin the treaty period, not before disbursementCover starts a month before the loan was paid outQuery lender
6Original loan amountWithin the product's maximum sum insuredLoan above the scheme maximumReject or refer
7Outstanding balanceNot above original amount; declining unless a top-up is flaggedBalance rises month on month with no top-upQuery lender
8Sum insured basisMatches the product: outstanding balance or fixed amountFixed amount reported on a declining-balance productQuery lender
9Sum at risk per borrowerTotal across loans within the free cover limit, or evidence heldThree loans each under the limit, total above itRefer to underwriting
10PremiumRecalculated premium within toleranceRate applied to the original amountQuery and adjust
11Premium rateWithin any local regulatory capRate above a published capEscalate to compliance
12Loan statusNo premium after closure, prepayment or write-offLoan prepaid in March still charged in AprilReverse premium
13Benefit codesMap to benefits the treaty coversRetrenchment cover reported on a life-only treatyExclude from cession
14Claim: date of deathInside the cover period and after any waiting periodDeath before cover startReject claim row
15Claim: amountNot above the outstanding balance at death on a balance basisClaim equals original loan amountQuery cedent
16Claim: loan matchLoan appears in the premium bordereau for that periodClaim on a loan never reported for premiumQuery cedent

Rule 9 depends on borrower IDs from rule 2. Without a stable borrower ID, accumulation cannot be tested at all.

For limits and evidence rules, see free cover limit monitoring.

Which credit life rules depend on local regulation?

The credit life rules that depend on local regulation are mainly premium caps and benefit restrictions, and they differ by market.

South Africa's 2017 regulations, per the National Credit Regulator, cap cost at R4.50 per R1,000 of the deferred amount.

The cap for mortgage agreements is R2 per R1,000.

The NCR's March 2026 guideline notes cost may be calculated on the deferred amount at inception or from time to time.

So the product terms, not habit, decide which basis rule 10 tests.

The same release says consumers who are not employed cannot be sold retrenchment cover. Check current local rules before building any cap into rule 11.

How Is Credit Life Premium Recalculated on a Bordereau?

Credit life premium is recalculated on a bordereau by applying the treaty rate to the product's sum insured basis for each loan. This example is illustrative.

InputValue
ProductMonthly premium on outstanding balance
Rate0.60 per 1,000 per month
Original loan275,000
Outstanding balance this month250,000
Premium reported by lender165.00
Quota share ceded to reinsurers70%

What does the credit life premium check show?

The credit life premium check shows that the lender applied the rate to the wrong amount.

  1. Expected premium: 250,000 ÷ 1,000 × 0.60 = 150.00.
  2. Reported premium: 165.00, which equals 275,000 ÷ 1,000 × 0.60. The rate was applied to the original loan.
  3. Gross overstatement: 165.00 minus 150.00 = 15.00, or 10% of the correct premium.
  4. Ceded effect: 70% of 165.00 is 115.50, against a correct 105.00. Reinsurers receive 10.50 too much on this loan.

The error grows each month, because the balance falls while the original amount stays fixed.

Overstated premium is not a gain for reinsurers. It is usually refunded later, and the same wrong basis can also inflate claims.

Which Credit Life Data Failures Hurt Reinsurers Most?

The credit life data failures that hurt reinsurers most are those that create cover nobody priced or claims nobody can check.

FailureWhat the reinsurer carries
Borrowers over the maximum entry or maturity ageMortality on lives outside the priced age band
Accumulation above the free cover limitLarge sums at risk with no medical evidence
Closed loans still chargedPremium later refunded, and claims on debts that no longer exist
Unmatched claim rowsClaims on loans with no premium history
Benefit codes outside the treatyDisability or retrenchment losses ceded under a life-only treaty

Claim rows deserve the closest check, because a paid claim is far harder to reverse than a premium adjustment.

Outstanding claim documents follow a separate routine, covered in outstanding claim requirements tracking.

Who Should Fix Credit Life Bordereau Errors?

Credit life bordereau errors should be fixed by whoever owns the source field. The cedent's operations team routes them.

  • Lender: loan IDs, borrower IDs, balances, status and dates.
  • Cedent operations: field mapping, premium recalculation and benefit coding.
  • Cedent underwriting: referrals above the free cover limit and age exceptions.
  • Reinsurer: sample checks on accumulation and claims before settlement.

Agree a correction deadline with the lender, so the next file is not built on the same errors.

How Does Insurnest Support Credit Life Bordereaux?

Insurnest Bordereaux Calculation and Reconciliation supports the step after validation, not the validation rules themselves.

It maintains participation percentages and allocates premium and claims by reinsurer share. It then calculates each reinsurer's net position.

It compares those calculated values with the bordereau, premium and claim registers and settlement records.

Each reinsurer then shows a status: reconciled, or variance to investigate.

It does not check file formats or completeness, and it does not find root causes. The rules in this guide stay with your team.

What Should a Head of Credit Life Reinsurance Test on Next Month's File?

A head of credit life reinsurance should test next month's file on the rules most likely to move money.

  • Recalculate premium for a sample of 200 loans. Compare the basis used with the product terms.
  • Aggregate sums at risk by borrower ID. List every borrower above the free cover limit.
  • Match closed loans to premium. Check that no premium follows a closure date.
  • Match claims to premium rows. Query every claim on a loan missing from the premium file.

Key Terms

  • Credit life: Insurance that repays a borrower's outstanding loan on death, and sometimes on disability or job loss.
  • Outstanding balance basis: Sum insured that falls as the loan is repaid.
  • Free cover limit: The sum at risk up to which lives are covered without medical evidence.
  • Per-borrower accumulation: Total sum at risk on one life across all of that borrower's loans.

Sources

Frequently Asked Questions

What are credit life bordereaux?

Credit life bordereaux are periodic listings of insured loans, premiums and claims under a credit life programme, built from the lender's loan system. Cedents send them to reinsurers so ceded premium and claims can be calculated, checked and settled under the treaty.

Why is lender-sourced credit life data hard to validate?

Lender-sourced credit life data is hard to validate because it comes from a loan system built for lending, not insurance. Fields such as disbursed amount, outstanding balance and loan status must be turned into sum insured, premium and cover status, and each step can go wrong.

How do you validate a credit life bordereau?

To validate a credit life bordereau, test each row for unique loan and borrower IDs, entry age, age at maturity, cover dates, sum insured basis, per-borrower accumulation, recalculated premium and loan status. Rows that fail are rejected, queried with the lender or accepted with a flag.

What is the most common credit life premium error?

A common credit life premium error is charging the rate on the original loan amount instead of the outstanding balance when the product is priced on a declining balance. In the worked example, that overstates one loan's monthly premium by 10%, and the ceded premium with it.

Why does per-borrower accumulation matter in credit life bordereaux?

Per-borrower accumulation matters in credit life bordereaux because one borrower may hold several loans. Each loan can sit under the free cover limit while the total sum at risk on that life exceeds it, so the reinsurer carries unassessed risk.

What happens to prepaid loans in a credit life bordereau?

Prepaid loans in a credit life bordereau should stop carrying premium and cover from the closure date. If the lender keeps charging, premium is overstated and refunds follow, and a claim on a closed loan may be paid where no debt existed.

Is there a regulatory cap on credit life premiums?

Some markets cap credit life premiums. South Africa's 2017 credit life regulations, as published by the National Credit Regulator, limit cost to R4.50 per R1,000 of the deferred amount for most credit and R2 for mortgages. Check current local rules before relying on any cap.

Does Insurnest validate credit life bordereau formats?

Insurnest does not validate credit life bordereau formats or completeness. Insurnest Bordereaux Calculation and Reconciliation allocates premium and claims by reinsurer share and compares calculated values with the bordereau and registers, surfacing mismatches for teams to investigate.

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

Free Cover Limit Monitoring for Group Life Reinsurers

Free cover limit monitoring stops group life reinsurers carrying risk nobody underwrote. Learn where FCL breaches start and how to catch them at each census.

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.