Credit Life Loan Book Reconciliation: Monthly Match Guide
On this page
- Key Takeaways
- Which Match Categories Does Credit Life Loan Book Reconciliation Use?
- How Does a Worked Credit Life Loan Book Match Add Up?
- What Is the Monthly Close-Out Routine for a Credit Life Loan Book Match?
- How Does Insurnest Support Credit Life Loan Book Reconciliation?
- What Can Credit Life Finance Leaders Check This Quarter?
- Key Terms
- Sources
- Frequently Asked Questions
Last reviewed: November 2026
A borrower dies, and the lender files a credit life claim on a loan that never appeared on any bordereau.
The lender says the borrower was charged for cover. The cedent's records show no premium, and the reinsurer asks why it should pay.
Credit life loan book reconciliation is the monthly match between the lender's full loan book and the insured loans on the credit life bordereau.
Doing it well means matching every loan, not totals, so each break gets a category, a premium effect and an owner before settlement.
Key Takeaways
- Totals hide breaks. Errors in both directions cancel out in the premium total.
- Five categories cover almost every loan. Matched, balance mismatch, in book not insured, insured not in book, and closed.
- Some gaps are valid. A borrower who substituted their own policy should be in the book but not on the bordereau.
- Missed enrolments are the costliest break. They create claims with no premium behind them.
- Use the same cut-off on both sides. Different dates create false breaks every month.
Which Match Categories Does Credit Life Loan Book Reconciliation Use?
Credit life loan book reconciliation uses five match categories, each with its own cause, test and fix.
| Category | Likely cause | Test | Fix |
|---|---|---|---|
| Matched | Loan and cover agree | Loan ID found both sides, balance within tolerance | None |
| Balance mismatch | Bordereau uses an old balance, arrears or the original amount | Balance difference above tolerance | Lender corrects balance; premium adjusted |
| In book, not insured: valid | Borrower opted out or substituted another policy | Opt-out or substitution evidence on file | Record evidence; no cover expected |
| In book, not insured: missed | Enrolment failed or loan never sent to the insurer | Loan requires cover, no evidence of opt-out | Enrol with back-dated premium, or escalate |
| Closed loan still on bordereau | Prepayment, settlement or write-off not passed to the insurer | Closure date in the lender's records | Stop premium and cover from the closure date |
| Insured, not in book | Restructured under a new ID, or a loan that never existed | Search restructure records and the old-new ID map | Re-key restructures; send the rest to fraud review |
Restructured loans deserve a mapping table of old and new loan IDs. Without it, one debt appears twice, or a live loan looks closed.
Why is "in book, not insured" not always an error?
"In book, not insured" is not always an error, because some borrowers are entitled to use a different policy.
In South Africa, section 106(4) of the National Credit Act gives the consumer the right to substitute a policy of their own choice.
An NCR guideline from June 2024 says the lender must accept a substitute that meets the regulations. Those loans belong in a separate, evidenced category.
Why does a credit life balance mismatch matter beyond premium?
A credit life balance mismatch matters beyond premium because the balance often sets the claim amount as well.
An NCR guideline from March 2026 says cover may not materially exceed the consumer's outstanding obligations at any time.
Other markets set different rules. Whatever the market, a claim paid on an inflated balance is hard to recover later.
How Does a Worked Credit Life Loan Book Match Add Up?
A worked credit life loan book match adds up when every loan on both sides lands in exactly one category. This example is illustrative.
The lender's book holds 10,000 loans with balances of 412.0m. The bordereau holds 9,880 loans with balances of 405.0m.
Premium is 0.60 per 1,000 of balance per month, and closed loans have already left the lender's book.
| Category | Loans | Book balance | Bordereau balance |
|---|---|---|---|
| Matched | 9,640 | 395.2m | 395.2m |
| Balance mismatch | 150 | 6.3m | 6.9m |
| In book, not insured: valid opt-out or substitute | 160 | 8.0m | – |
| In book, not insured: missed enrolment | 50 | 2.5m | – |
| Closed loan still on bordereau | 70 | – | 2.1m |
| Insured, not in book: no trace | 20 | – | 0.8m |
| Total | 10,000 book / 9,880 bordereau | 412.0m | 405.0m |
The book side adds up: 9,640 + 150 + 160 + 50 = 10,000 loans, and 395.2m + 6.3m + 8.0m + 2.5m = 412.0m.
The bordereau side adds up too: 9,640 + 150 + 70 + 20 = 9,880 loans, and 395.2m + 6.9m + 2.1m + 0.8m = 405.0m.
What is the premium effect of each credit life break?
The premium effect of each credit life break is its balance difference multiplied by the monthly rate of 0.60 per 1,000.
| Break | Balance effect | Monthly premium effect |
|---|---|---|
| Balance mismatch | 0.6m too high | 360 overcharged |
| Closed loans still charged | 2.1m with no debt | 1,260 overcharged |
| No-trace rows | 0.8m with no debt | 480 overcharged |
| Missed enrolments | 2.5m with no cover | 1,500 undercharged |
| Net | 600 overcharged |
The bordereau premium is 405.0m × 0.60 per 1,000, or 243,000. The correct premium is on 404.0m (395.2m + 6.3m + 2.5m), or 242,400.
The 600 net difference is about 0.25% of the correct premium. A total-only check would pass it.
Yet 290 loans are broken (150 + 50 + 90), and the gross errors add up to 3,600, six times the net figure.
On a 70% quota share, reinsurers receive 170,100 against a correct 169,680. The bigger risk is the 2.5m of debt on 50 borrowers with no cover.
What should happen to a missed credit life enrolment?
A missed credit life enrolment should be enrolled with back-dated premium where the scheme and treaty allow late declarations, and escalated where they do not.
Late-declaration terms differ by treaty, so the cedent should check them before adding back-dated cover. Some treaties cap how late a life can be declared.
The hardest case is a borrower who has already died. The claim then depends on the scheme terms, the lender's own obligations and the treaty, not on the bordereau.
Recording the date each missed enrolment was found matters. It shows how long cover was missing and whether the gap is growing.
What Is the Monthly Close-Out Routine for a Credit Life Loan Book Match?
The monthly close-out routine for a credit life loan book match runs on fixed working days, so breaks do not roll into the next settlement.
- Day 1–3: take both files at one cut-off. Use the same month-end date for the loan book and the bordereau.
- Day 3–5: match and classify. Match on loan ID, then borrower ID and disbursement date for loans with changed IDs.
- Day 5: quantify. Calculate the premium effect per category, gross and net.
- Day 5–8: route breaks. Balances and closures go to the lender, enrolments to the cedent, no-trace rows to fraud review.
- Day 10: agree adjustments. Book premium corrections and record evidence for valid opt-outs.
- Day 10: carry forward. Age every open break, so repeats from the same lender are visible.
Cut-off dates cause many false breaks. See bordereaux cut-off dates for setting them.
For finding causes behind variances, see reconciliation variance root cause.
Which keys should a credit life loan match use?
A credit life loan match should use the loan ID as its primary key, with borrower ID and disbursement date as fallbacks.
Account numbers often change on restructures, top-ups and system migrations. A fallback key catches the loans the primary key misses.
How Does Insurnest Support Credit Life Loan Book Reconciliation?
Insurnest Bordereaux Calculation and Reconciliation supports the reinsurance side of the match, not the lender-side matching.
It maintains participation percentages, allocates premium and claims by reinsurer share and calculates each reinsurer's net position.
It compares those values with bordereaux, master data, premium and claim registers and settlement records. Mismatches appear in one view, by reinsurer.
Matching the lender's book row by row, and finding the cause of each break, stays with your team and the lender.
For how cessions are administered on life business, see life reinsurance cession administration.
What Can Credit Life Finance Leaders Check This Quarter?
Credit life finance leaders can check this quarter whether their reconciliation counts loans or only compares totals.
- Ask for the break count, not the net difference. Insist on loans per category each month.
- Review missed enrolments. Ask how many borrowers carry debt with no cover, and since when.
- Test closed-loan premium. Sample loans closed last quarter and check that premium stopped.
- Check the opt-out evidence. Confirm each valid opt-out or substitution has a document behind it.
Key Terms
- Loan book: The lender's full list of live loans and balances at a cut-off date.
- Missed enrolment: A loan that should carry credit life cover but was never sent to the insurer.
- Substituted policy: A borrower's own policy accepted by the lender in place of the lender's proposed cover.
- Gross vs net break: The sum of all errors, compared with the total left after errors offset.
- Settlement reconciliation: Matching cash settled with reinsurers to agreed accounts. See reinsurance settlement reconciliation.
Sources
- National Credit Regulator: Guideline on the Application of the Credit Life Insurance Regulations 003/2024 (June 2024)
- National Credit Regulator: Interpretation Guideline 002/2026 on Regulation 3(1) (March 2026)
- Insurnest: Bordereaux Calculation and Reconciliation
Frequently Asked Questions
What is credit life loan book reconciliation?
Credit life loan book reconciliation is the monthly match between the lender's full loan book and the insured loans on the credit life bordereau. Each loan is classed as matched, balance mismatch, in book but not insured, insured but not in book, or closed, and each break is resolved.
How is loan book reconciliation different from bordereau validation?
Loan book reconciliation is different from bordereau validation because it compares two populations rather than checking rows in one file. Validation tests whether each bordereau row is sensible, while reconciliation finds loans that are missing, extra or carrying the wrong balance.
Why is a loan in the book but not insured a problem?
A loan in the book but not insured is a problem when cover should exist, because the borrower is unprotected and the lender may expect a claim to be paid without premium. It is not a problem where the borrower validly opted out or substituted another policy.
What does insured but not in book mean in credit life?
Insured but not in book means a loan appears on the credit life bordereau but not in the lender's loan book. Some are restructured loans under new IDs, but rows with no trace at all need investigation, because premium and cover then exist with no underlying debt.
How do you reconcile a credit life loan book each month?
To reconcile a credit life loan book each month, take both files at the same cut-off, match on loan ID with borrower ID and disbursement date as backups, classify every loan into a match category, quantify the premium effect, and assign each break an owner and deadline.
Can credit life premium totals agree while loans are wrong?
Credit life premium totals can agree while loans are wrong because errors in both directions cancel. In the worked example, the net premium difference is 600, about 0.25%, while 290 loans are broken and the gross errors add up to 3,600.
Must credit life cover match the outstanding balance?
Credit life cover must closely track the outstanding balance in some markets. A March 2026 National Credit Regulator guideline in South Africa says cover may not materially exceed the consumer's outstanding obligations at any time. Rules elsewhere differ, so check local requirements.
Does Insurnest match lender loan books to bordereaux?
Insurnest does not match lender loan books row by row. Insurnest Bordereaux Calculation and Reconciliation allocates premium and claims by reinsurer share and compares calculated values with bordereaux, master data, registers and settlement records, showing which reinsurers are reconciled.

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 →