Co-Lending Reconciliation: Keep Your Books and Partner Bank Books Matched
Build a co-lending reconciliation routine that matches disbursals, collections and splits with your partner bank before differences grow into disputes.
This is for finance controllers, co-lending desk heads and operations managers at NBFCs working with banks or other lenders under co-lending arrangements. When your loan book and the partner's records disagree, collections get mis-split, escrow balances look wrong and month-end becomes an argument. This post gives a loan-level reconciliation method, a break classification that speeds up settlement, and a monthly calendar both teams can follow without endless email chains.
The partner bank's monthly statement shows a principal outstanding several lakhs higher than your LMS for the same pool. Totals do not explain why. After a week of spreadsheets, the team finds a mix of loans foreclosed but not reported, part-payments split on different dates, and a handful of loans where the partner applied a different interest rate on its share.
Each side holds escrow inflows, bounce charges and penal charges in its own system with its own posting logic. Because reconciliation happens only on pool totals, small loan-level differences accumulate for months. When an audit or a partner review asks for proof, nobody can show a clean, loan-by-loan agreement for any recent month.
An NBFC in Chennai co-lending MSME loans with a public sector bank was reconciling only pool balances. Differences kept rolling forward, and a partner review asked for loan-level evidence the team could not easily produce. The co-lending head agreed a shared file template and cut-off with the bank, mapped escrow credits to loans daily, and began matching each loan on five fields. Breaks were tagged by cause and age, and a fixed monthly call worked through them. Old differences were traced to unreported foreclosures and a rate mismatch, both fixed at source, and month-end close became predictable.
How often should co-lending books be reconciled?
Escrow mapping should happen daily. Full loan-level reconciliation is commonly monthly, aligned to the partner's statement. High-volume pools may justify weekly matching. Check your co-lending agreement and current regulatory guidance with your compliance team.
Who should own co-lending reconciliation?
Finance usually owns the reconciliation and sign-off, with the co-lending desk owning partner communication and ops owning escrow mapping. Name a single accountable person so breaks do not fall between teams.
What tolerance should we use for small differences?
Set a small rupee tolerance per field for rounding, agreed with the partner and written down. Anything above it is a break. Keep the tolerance tight enough that genuine errors cannot hide inside it.
What if the partner will not change their file format?
Build a mapping layer on your side that converts their format into your template, and document every field mapping. Revisit the template at the next agreement review so the burden is shared.
Want this fixed in your business?
Send the workflow. You get a scope and a fixed price within two working days — or a straight answer that it isn't a fit.