DPD Calculation in a Loan Management System for Partial Payments Reversals and Backdated Entries

October 23, 2026

Table of Contents

A borrower with one missed equated monthly installment (EMI) pays Rs 10,000 on the day the next EMI falls due. Depending on how the loan management system (LMS) applies that payment, the account shows 1 day past due (DPD) or 32. For a lender reporting to credit bureaus every fortnight, that choice changes classification, provisioning inputs, and the borrower’s credit report.

Quick Answer

DPD in an LMS is counted from the oldest unpaid due date, and status is set in the day-end process. Partial payments, reversals, and backdated entries each force a recount of that date. RBI’s NBFC directions fix the counting rules, but they leave payment order and posting controls to the lender’s policy and system design.

Key Takeaways

• DPD is anchored to the oldest unpaid due date and classification is determined through the day end process.

• A partial payment does not move the anchor date unless it fully clears the oldest due amount under the lender’s allocation policy.

• A reversed payment should restore the original overdue position and trigger a recalculation from the original due date.

• Backdated receipts require effective dating, replay of affected day ends and review of charges and bureau data already produced.

What Does DPD Mean Under RBI Rules

The Reserve Bank of India (RBI) directions for non-banking financial companies (NBFCs), dated November 28, 2025, call an amount overdue if not received on its due date. Overdue flagging happens in the day-end process for that due date.

DPD is counted from the oldest unpaid due date. If the due date and billing date differ, the due date is used. RBI set this out in a November 12, 2021 clarification.

The same clarification defines the special mention account (SMA) buckets:

  • SMA-0: up to 30 days overdue.
  • SMA-1: more than 30 and up to 60 days.
  • SMA-2: more than 60 and up to 90 days.
  • Non-performing asset (NPA): overdue for more than 90 days for most NBFC categories.

How Does the Day Count Work in Practice

RBI’s own illustration shows the timeline for a March 31 due date that stays unpaid. Classification happens on the calendar date for which the day-end process runs.

Day-end dateStatus
March 31Flagged overdue
April 30SMA-1
May 30SMA-2
June 29NPA

Borrower level classification adds another requirement. When one facility becomes an NPA, all facilities of that borrower are treated as NPAs. The LMS therefore needs a reliable link between every account and the borrower.

Why Does an Error in DPD Matter

DPD feeds classification, provisioning, and bureau data. Lenders have had to update credit bureau records every 15 days since January 1, 2025, per Business Today. A wrong count can reach bureaus within a fortnight.

Published delinquency rates are low enough that calculation errors can distort a portfolio trend. TransUnion CIBIL’s June 2026 Credit Market Indicator reports the following 90 plus DPD rates for March 2026:

Product90+ DPD rate
Gold loan0.2%
Auto loan0.5%
Home loan0.6%
Consumer durable loan0.7%
Personal loan0.9%
Two-wheeler loan1.3%
Credit card1.7%

At these rates, a few miscounted accounts can shift reported quality. Note that the report measures most products at 90 to 179 days past due, and home and property loans at 90 to 719 days. Definitions of DPD windows differ even among published figures.

RBI’s Financial Stability Report (June 30, 2026) puts bank gross NPAs at 1.8% at end-March 2026, projected at 1.9% by March 2028.

How Should an LMS Handle Partial Payments

A partial payment reduces the overdue amount. It does not move the oldest unpaid due date unless it clears that installment in full.

Example: a Rs 10,000 EMI is due on January 5 and is unpaid. The borrower pays Rs 6,000 on January 20. Rs 4,000 of the January EMI is still overdue.

On the February 4 day-end, DPD is 31 and the account is SMA-1. The January 5 due date is still the anchor.

Partial payments also do not upgrade an NPA. Per the 2021 clarification, interest-only payments or a single installment leave the account classified as NPA until all arrears are paid.

The payment allocation order determines which due amount remains unpaid and therefore which date anchors DPD. The RBI material reviewed does not prescribe that order; lenders set it in their loan terms and system rules.

What Happens to DPD When a Payment Is Reversed

Only actual collection in the bank account discharges a payment obligation. This is the reading of the 2021 clarification by Vinod Kothari Consultants. A cheque received but not cleared does not count.

Example: the borrower pays Rs 10,000 on February 5 against the unpaid January EMI. The LMS posts it. It bounces on February 8.

Correct DPD on the February 8 day-end is 35, and the account is SMA-1. The LMS must restore the January 5 anchor and recompute status from the original due date.

The directions summary reviewed does not address reversals. This is system design. Any bureau submission made between February 5 and February 8 would show a lower count, so plan how corrections flow into the next fortnightly submission.

How Should Backdated Entries Be Treated

A backdated entry arises when a bank credit and the LMS posting fall on different dates. The effective date of receipt should drive DPD, not the posting date.

Example: the borrower pays Rs 10,000 into the lender’s account on January 31. Reconciliation posts it on February 6.

Without effective dating, the February 4 day-end shows 31 DPD and SMA-1. With effective dating, the January EMI was cleared on January 31, so DPD for that day-end is 0.

The LMS therefore needs to replay day-end status from the effective date. It also needs to flag any penal charges or bureau data produced in between. The directions summary reviewed has no rule on backdated entries, so control sits with the lender.

What Do the Rules Fix, and What Do Lenders Decide

TopicSet by RBI text reviewedLeft to lender policy and system design
Overdue definitionAmount not received on due dateCut-off time for same-day receipts
DPD anchorOldest unpaid due dateNone
Status timingDay-end process on the calendar dateRun schedule
SMA buckets0 to 30, 31 to 60, 61 to 90 daysInternal early warning buckets
Upgrade from NPAAll arrears of interest and principal paidInternal approval steps
Payment orderNot prescribed in the summary reviewedOrder of principal, interest, and charges
ReversalsOnly actual collection countsRestore and recompute logic
Backdated entriesNot addressedEffective dating, limits, approvals

What Should an LMS DPD Engine Support

  • Count DPD from the oldest unpaid due date for every loan.
  • Run classification in the day-end process, tied to the calendar date.
  • Apply payments in a configurable order set by loan terms.
  • Restore DPD history when a payment is reversed.
  • Support effective-dated posting and replay of past day-ends.
  • Require maker-checker approval and an audit trail for any backdated entry.
  • Link all facilities of a borrower so NPA status carries across them.
  • Block NPA upgrade until all arrears are cleared.
  • Flag when a correction changes data already sent to a credit information company.

Bottom Line

RBI’s rules set the DPD anchor, the buckets, and the day-end process. They do not tell lenders how to apply payments, undo reversals, or handle backdated credits.

Those choices are implemented in the LMS. Before go live, lenders should test partial payments, reversals and backdated receipts across SMA and NPA boundaries. The test should confirm both the recalculated status and any correction required in reports already produced.

FAQs

How is DPD calculated for an NBFC loan?

DPD is counted from the oldest unpaid due date, using the due date and not the billing date. Status is set in the day-end process for each calendar date.

Does a partial payment reduce DPD?

Not unless it clears the oldest installment in full. The oldest unpaid due date stays the anchor. A partial payment also does not upgrade an NPA account.

Do the SMA and NPA rules apply to banks and housing finance companies?

This article uses the NBFC Directions. Banks and housing finance companies follow their own directions, so check those before applying these rules.

Let's talk!

left-container

Ready to transform lending

Let's discuss how Uncia can accelerate your institution's lending capabilities

Please share your details so we can get back to you soon.