Why co-lending reconciliation is structurally harder than normal loan reconciliation
A standard loan exists in one system — the institution's own CBS. Its transactions are recorded once and do not need to be matched against another institution's records. A co-lending loan exists in two systems simultaneously — the bank's core banking system and the NBFC's CBS — and every transaction must appear in both at the agreed split, on the same value date, or a reconciliation item is created. The structural sources of reconciliation breaks in co-lending are: value date differences (the bank books a transaction on T and the NBFC books it on T+1, creating a one-day float mismatch); rounding differences (the 80:20 split applied to an odd EMI amount produces a one-rupee rounding gap that neither system resolves automatically); interest calculation method differences (the bank uses a daily reducing balance method while the NBFC uses a monthly reducing balance method, producing systematic interest discrepancies); and payment routing delays (the borrower pays through the NBFC's collection channel, the NBFC receives and applies the payment, but the bank's 80% share is not transferred until the next settlement window).
Each of these is a known, predictable source of reconciliation breaks. The Co-Lending Ops Agent AI identifies each type, categorises the break, and resolves what can be resolved automatically — rounding differences, value date offsets — while routing genuine discrepancies to the finance team for resolution.
The daily reconciliation: what the Co-Lending AI matches
Rajan Textiles ₹18,400 EMI
20% = ₹3,680 ₹14,720 (80%)
Value: Nov 14 ₹0 · Exact Matched ✓
Kaveri Agro ₹11,200 EMI
20% = ₹2,240 ₹8,960 (80%)
Value: Nov 14 ₹0 · Exact Matched ✓
Suresh Kumar SE ₹9,100 EMI
20% = ₹1,820 ₹7,281 (80%)
Value: Nov 14 ₹−1 · Rounding Auto-resolved ⚑
Geetha Constructions ₹42,800 prepay
20% = ₹8,560 Not received yet
Value: Pending ₹8,560 open Unmatched ✗
Metro Retail Pvt Ltd ₹28,400 EMI
20% = ₹5,680 ₹22,720 (80%)
Value: Nov 13 ← T−1 1-day value date Date offset ⚑
The transaction types the Co-Lending AI reconciles
| Transaction Type | Split Rule | Common Break Cause | Auto-Resolution Available |
|---|---|---|---|
| EMI receipt — full | 80:20 ratio · NBFC collects and transfers 80% to bank | Rounding (±₹1–2) on odd EMI amounts | Yes — rounding ≤₹2 |
| EMI receipt — partial | Partial applied to interest first, then principal · Split after application | Interest calculation method differences (daily vs monthly reducing balance) | Partial — if method difference known |
| Prepayment — partial | Prepayment reduces principal · 80:20 share of principal reduction | Prepayment date vs application date — bank books on receipt date, NBFC on borrower-authorised date | Partial — date offset auto-categorised |
| Prepayment — full foreclosure | Full outstanding at 80:20 + foreclosure charge split | Foreclosure charge split formula — some agreements specify flat charge, others pro-rata by share | No — requires agreement review |
| Disbursement | NBFC disburses 20%, bank disburses 80% simultaneously | Bank's disbursement delayed by internal approval — NBFC disburses, bank records T+1 | Auto-flagged · Date offset expected |
| Penal charges | Penal charges split 80:20 — or per agreement if different | NBFC levies penal charges per its own policy; bank may not levy penal on its share — creates asymmetric accrual | No — agreement clause review required |
| Interest accrual (monthly) | Monthly interest split per outstanding balance ratio | Daily vs monthly reducing balance methodology produces accumulating difference over the year | Partial — systematic difference flagged for annual true-up |
| NPA provisioning | Each partner provisions on their own book independently — no shared computation | NBFC classifies NPA at 90 DPD; bank may classify at a different date (different DPD counting method) | No — regulatory compliance for each partner separately |
The exception resolution framework: from detection to closure
Auto-resolved: the party with the rounding shortfall is credited ₹1–2 in the next settlement cycle
When 80:20 splits produce a fractional rupee that cannot be distributed, the rounding convention (typically: NBFC takes the fraction in its favour, bank rounds down) is applied automatically. The ₹1–2 accumulated rounding difference is trued up in the monthly settlement summary rather than creating a daily reconciliation item.
→ Auto-resolved · Accumulated in monthly true-up · No human actionAuto-categorised as a date offset · Resolved when the lagging partner posts the transaction
The Co-Lending AI detects that the same transaction (same amount, same account) appears in one partner's records with a one-day offset. It is categorised as a pending match rather than a genuine break. The partner with the later booking is sent an automated reminder. If the transaction does not appear in both systems within 48 hours, it escalates to a genuine exception requiring investigation.
→ Auto-categorised · Partner reminder sent · Escalates at 48 hours if unresolvedThe largest reconciliation break by rupee amount — borrower pays the NBFC, bank's 80% share is in transit
When a borrower makes a prepayment through the NBFC's channel, the NBFC holds 100% of the payment until it transfers the bank's 80% share in the next settlement window. During this gap, the NBFC's books show the full amount received and the bank's books show nothing. This is not a break — it is a timing difference with a known resolution. The Co-Lending AI tracks the settlement window and confirms the bank's 80% is transferred within the agreed period (typically 2 business days).
→ Bank's share tracked to settlement window · Escalate if not transferred within 2 business daysSystematic difference that grows through the year · Resolved at annual true-up
When the bank computes interest on a daily reducing balance and the NBFC uses monthly, the interest accruals diverge by a small but accumulating amount over the year. The Co-Lending AI tracks this systematic difference, quantifies it monthly, and produces the annual true-up calculation at year-end that resolves the accumulated divergence between the two partners' interest books.
→ Tracked monthly · Quantified · Annual true-up calculation generatedA co-lending partnership whose reconciliation is current is a partnership that can be trusted — one whose reconciliation is backlogged is a partnership built on unverified numbers
The bank's relationship manager and the NBFC's CFO need to be able to answer one question about their co-lending portfolio at any time: "Are our books in agreement?" In a manually reconciled partnership, the honest answer to that question is often "we think so, as of three weeks ago." In a Co-Lending Ops AI-managed partnership, the answer is "yes, as of yesterday's close, with three transactions worth ₹4,600 under review." The difference between those two answers is the difference between a partnership that can scale and one that will collapse under the weight of its own unreconciled backlog.