Credit Life Bordereaux: Validating Lender-Sourced Data
On this page
- Key Takeaways
- Why Is Lender-Sourced Credit Life Data Hard to Validate?
- Which Validation Rules Should a Credit Life Bordereau Pass?
- How Is Credit Life Premium Recalculated on a Bordereau?
- Which Credit Life Data Failures Hurt Reinsurers Most?
- Who Should Fix Credit Life Bordereau Errors?
- How Does Insurnest Support Credit Life Bordereaux?
- What Should a Head of Credit Life Reinsurance Test on Next Month's File?
- Key Terms
- Sources
- Frequently Asked Questions
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.
| # | Field | Rule | Failure example | Action |
|---|---|---|---|---|
| 1 | Loan ID | Unique within the period | Restructured loan reported under old and new IDs | Reject duplicate |
| 2 | Borrower ID | Present and stable across loans and months | Same borrower with two ID formats | Query lender |
| 3 | Date of birth | Entry age within product limits | Entry age 67 where the maximum is 65 | Reject row |
| 4 | Age at maturity | Entry age plus term within maximum cover age | Age 60 with a 10-year loan, maximum 65 at expiry | Query; cover may stop early |
| 5 | Cover start date | Within the treaty period, not before disbursement | Cover starts a month before the loan was paid out | Query lender |
| 6 | Original loan amount | Within the product's maximum sum insured | Loan above the scheme maximum | Reject or refer |
| 7 | Outstanding balance | Not above original amount; declining unless a top-up is flagged | Balance rises month on month with no top-up | Query lender |
| 8 | Sum insured basis | Matches the product: outstanding balance or fixed amount | Fixed amount reported on a declining-balance product | Query lender |
| 9 | Sum at risk per borrower | Total across loans within the free cover limit, or evidence held | Three loans each under the limit, total above it | Refer to underwriting |
| 10 | Premium | Recalculated premium within tolerance | Rate applied to the original amount | Query and adjust |
| 11 | Premium rate | Within any local regulatory cap | Rate above a published cap | Escalate to compliance |
| 12 | Loan status | No premium after closure, prepayment or write-off | Loan prepaid in March still charged in April | Reverse premium |
| 13 | Benefit codes | Map to benefits the treaty covers | Retrenchment cover reported on a life-only treaty | Exclude from cession |
| 14 | Claim: date of death | Inside the cover period and after any waiting period | Death before cover start | Reject claim row |
| 15 | Claim: amount | Not above the outstanding balance at death on a balance basis | Claim equals original loan amount | Query cedent |
| 16 | Claim: loan match | Loan appears in the premium bordereau for that period | Claim on a loan never reported for premium | Query 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.
| Input | Value |
|---|---|
| Product | Monthly premium on outstanding balance |
| Rate | 0.60 per 1,000 per month |
| Original loan | 275,000 |
| Outstanding balance this month | 250,000 |
| Premium reported by lender | 165.00 |
| Quota share ceded to reinsurers | 70% |
What does the credit life premium check show?
The credit life premium check shows that the lender applied the rate to the wrong amount.
- Expected premium: 250,000 ÷ 1,000 × 0.60 = 150.00.
- Reported premium: 165.00, which equals 275,000 ÷ 1,000 × 0.60. The rate was applied to the original loan.
- Gross overstatement: 165.00 minus 150.00 = 15.00, or 10% of the correct premium.
- 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.
| Failure | What the reinsurer carries |
|---|---|
| Borrowers over the maximum entry or maturity age | Mortality on lives outside the priced age band |
| Accumulation above the free cover limit | Large sums at risk with no medical evidence |
| Closed loans still charged | Premium later refunded, and claims on debts that no longer exist |
| Unmatched claim rows | Claims on loans with no premium history |
| Benefit codes outside the treaty | Disability 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
- National Credit Regulator: The final credit life insurance regulations published (February 2017)
- National Credit Regulator: Interpretation Guideline 002/2026 on Regulation 3(1) of the Credit Life Insurance Regulations (March 2026)
- Insurnest: Bordereaux Calculation and Reconciliation
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
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 →