Reinsurance

Credit Life Loan Book Reconciliation: Monthly Match Guide

On this page

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.

CategoryLikely causeTestFix
MatchedLoan and cover agreeLoan ID found both sides, balance within toleranceNone
Balance mismatchBordereau uses an old balance, arrears or the original amountBalance difference above toleranceLender corrects balance; premium adjusted
In book, not insured: validBorrower opted out or substituted another policyOpt-out or substitution evidence on fileRecord evidence; no cover expected
In book, not insured: missedEnrolment failed or loan never sent to the insurerLoan requires cover, no evidence of opt-outEnrol with back-dated premium, or escalate
Closed loan still on bordereauPrepayment, settlement or write-off not passed to the insurerClosure date in the lender's recordsStop premium and cover from the closure date
Insured, not in bookRestructured under a new ID, or a loan that never existedSearch restructure records and the old-new ID mapRe-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.

CategoryLoansBook balanceBordereau balance
Matched9,640395.2m395.2m
Balance mismatch1506.3m6.9m
In book, not insured: valid opt-out or substitute1608.0m–
In book, not insured: missed enrolment502.5m–
Closed loan still on bordereau70–2.1m
Insured, not in book: no trace20–0.8m
Total10,000 book / 9,880 bordereau412.0m405.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.

BreakBalance effectMonthly premium effect
Balance mismatch0.6m too high360 overcharged
Closed loans still charged2.1m with no debt1,260 overcharged
No-trace rows0.8m with no debt480 overcharged
Missed enrolments2.5m with no cover1,500 undercharged
Net600 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.

  1. Day 1–3: take both files at one cut-off. Use the same month-end date for the loan book and the bordereau.
  2. Day 3–5: match and classify. Match on loan ID, then borrower ID and disbursement date for loans with changed IDs.
  3. Day 5: quantify. Calculate the premium effect per category, gross and net.
  4. Day 5–8: route breaks. Balances and closures go to the lender, enrolments to the cedent, no-trace rows to fraud review.
  5. Day 10: agree adjustments. Book premium corrections and record evidence for valid opt-outs.
  6. 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

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

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

Bordereaux Cut-Off Dates: Stop Late Data Breaking Month-End

Bordereaux cut-off dates decide which data makes each month-end. Get a working-day close calendar, treaty tiering rules and a method for late bordereaux.

Read more
Reinsurance

Reconciliation Variance Root Cause in Reinsurance

Reconciliation variance root cause work explains why reinsurance figures don't match. Read the variance pattern, test the likely cause and fix it at the source.

Read more
Reinsurance

Life Reinsurance Cession Administration Off Spreadsheets

Life reinsurance cession administration still runs on spreadsheets at many reinsurers. See what a policy-level cession record needs and how to migrate safely.

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.