Since July 1, 2026, Indian lenders report to credit bureaus on four reference dates a month, and incremental files are due within four calendar days. A wrong balance or days past due (DPD) value from an old loan management system (LMS) can now reach the bureaus within days of cutover. Fixing it later means a corrected resubmission.
Quick Answer
Validate an LMS migration in three layers: balances, accruals, and DPD history. Reconcile each loan by loan against the old system and the general ledger, across a full month-end and a bureau reporting date. Keep stage-wise business sign-offs and audit trails, as RBI’s IT governance direction requires for in-scope lenders.
Key Takeaways
• Reconcile principal, interest, fees and suspense balances at account and portfolio level.
• Rebuild accruals and repayment schedules independently rather than checking only totals.
• Preserve event-level DPD history so delinquency and bureau reporting remain defensible.
• Use at least one full-volume rehearsal and assign owners to every unresolved exception.
Why Does an LMS Migration Need More Than Row Counts
Matching record counts proves that accounts arrived. It does not prove that the money, interest, and status on each account are right.
RBI’s Master Direction on IT Governance, Risk, Controls and Assurance Practices took effect on April 1, 2024. It covers banks, credit information companies (CICs), and non-banking financial companies (NBFCs) in the Top, Upper, and Middle layers. Base Layer NBFCs are not covered.
For data migration, it requires:
- A documented policy that keeps data integrity, completeness, and consistency intact.
- Sign-offs from business users and application owners at each stage of migration.
- Audit trails, and logging detailed enough to serve as forensic evidence.
- Change management with a way to recover from failed changes.
What Does a Sound Validation Sequence Look Like
The sequence below is recommended practice, not an RBI-prescribed process.
| Stage | What to validate | Exit test |
| Mapping | Every source field has a target field and rule | Business owner signs the map |
| Mock loads | Balances, accruals, DPD for all loans | Zero unexplained differences |
| Month-end rehearsal | Totals against the general ledger | Differences explained and approved |
| Bureau rehearsal | Incremental and full file formats | Files accepted in test |
| Cutover | Frozen source extract, controlled load | Sign-off at each stage |
| Post-cutover | First live month-end and bureau cycle | Reconciliation clean |
How Do You Validate Balances
Reconcile at loan level first, then at portfolio level. A matching portfolio total can hide offsetting errors on individual loans.
Check these items for every loan:
- Principal outstanding: old system against new system.
- Interest and charges outstanding: overdue and not yet due.
- Unallocated receipts: payments received but not yet applied.
- Advance installments: amounts paid ahead of the due date.
- Closed and written-off accounts: correct final status and balance.
- Repayment schedule: remaining installments, dates, and amounts.
Then tie portfolio totals to the general ledger. Investigate every difference, including rounding. Small unexplained differences can point to a rule that the mapping missed.
How Do You Validate Accruals
Accruals are interest and fee income earned but not yet received. They depend on rules, so a correct balance can still carry a wrong accrual.
Recompute accruals in the new system for a sample of loans over a full period. Compare them with the old system. Cover each product, day-count method, and rate type you run.
Three accounting rules need explicit tests:
- NPA income: under RBI’s November 2025 NBFC directions, income on non-performing assets (NPAs) is recognized only when realized. Previously accrued, unrealized income is reversed.
- Ind AS fees: NBFCs that apply Indian Accounting Standards (Ind AS) defer upfront processing fees. They amortize them over the loan life using the effective interest rate (EIR) method.[source]
- Moratorium interest: capitalized interest for a moratorium period need not be reversed if the loan later turns NPA.
Check that the opening accrual position at cutover equals the closing position in the old system. A cut-off date mismatch can produce one-day differences.
How Do You Validate DPD History
DPD history is the hardest layer because it is derived, not stored as a balance. The new system must reproduce status, not just copy a number.
RBI’s rules fix the core logic. DPD is counted from the oldest unpaid due date, and status is set in the day-end process. Special mention account (SMA) buckets run up to 30, 60, and 90 days, and NPA follows beyond 90 days for most NBFC categories.
Test these cases against old-system history:
| Check | Why it matters |
| Oldest unpaid due date per loan | It anchors every DPD value |
| SMA and NPA dates | Status dates drive provisioning and reporting |
| Linked facilities | When one facility turns NPA, all facilities of that borrower are NPA |
| Upgrade history | Upgrade needs all arrears cleared, not one installment |
| Partial payments and reversals | They change which due date is oldest |
| Ind AS stage | Stage 2 uses a 30-day presumption, and Stage 3 uses 90 days |
The Ind AS stage can differ from the RBI status. An account can be Stage 3 under Ind AS 109 while still SMA-2 under RBI norms. Migrate both views.
Which Reporting Deadlines Raise the Stakes
RBI’s amendment directions of December 4, 2025 took effect on July 1, 2026. Credit information is reported as on the 9th, 16th, 23rd, and last day of each month.
| As on | Share with CICs by |
| 9th | 13th |
| 16th | 20th |
| 23rd | 27th |
| Last day | 5th of next month |
Incremental files cover accounts opened, closed, changed, or overdue. An account whose only change is DPD still qualifies, so a DPD error in migrated data will appear in the next file.
Lenders must fix data rejected by CICs and resubmit it before or with the next reference date. CICs report lenders that miss timelines to RBI’s supervision department half-yearly.
Plan cutover so that a rehearsal file can be tested before the first live reference date.
Migration Validation Checklist
Before cutover
- Get a signed field map with business-owner approval.
- Run multiple mock loads and clear every unexplained difference.
- Reconcile loan-level balances, then portfolio totals to the general ledger.
- Recompute sample accruals for each product and day-count method.
- Replay DPD and status for a sample of loans, including partial payments and reversals.
- Test bureau files in the new formats and reference-date cycle.
- Document a rollback plan for a failed load.
At cutover
- Freeze the source extract and record its date and time.
- Keep a manual-edit log. The IT governance direction calls for no manual modification of data during transfers.
- Capture stage-wise sign-offs and audit trails.
After cutover
- Reconcile the first live month-end against the general ledger.
- Compare the first bureau incremental file with the old system’s last file.
- Review every rejected record and resubmit it on time.
- Track borrower queries about balances, charges, and DPD.
Bottom Line
An LMS migration succeeds when balances, accruals, and DPD history all reproduce the old system’s results, or differences are explained and approved. Row counts show none of that.
With bureau files due within days of each reference date, errors surface quickly. Test the three layers loan by loan, and keep the sign-offs that RBI expects.
FAQs
What should be validated in an LMS migration?
Validate balances, accruals, and DPD history at loan level, then reconcile totals to the general ledger. Also test bureau files and keep stage-wise sign-offs.
Does RBI have rules for data migration?
Yes, for in-scope lenders. The IT governance direction requires a documented migration policy, stage-wise sign-offs, audit trails, and no manual data modification during transfers.
How do bureau reporting dates affect cutover?
From July 1, 2026, lenders report on four dates a month. Incremental files are due within four calendar days, so errors reach bureaus quickly. Time cutover around these dates.
