Holiday Calendar Handling in Loan Systems: EMI and DPD Rules
Last reviewed: November 2026
Holiday calendar handling in loan systems is the set of calendars and rules that decides what a lending system does when an equated monthly instalment (EMI) due date, a mandate presentation, a cheque deposit or a day-end job falls on a Sunday, a bank holiday or a lender non-working day. Get it wrong and borrowers see bounced debits, extra interest or a days past due (DPD) count they did not earn.
This guide is for heads of loan operations and chief operating officers (COOs) at banks and non-banking financial companies (NBFCs). It gives you a holiday decision table, business-day conventions with dated examples, a tested Python snippet, a settings table and a go-live checklist, configured by Digiqt on the Digiqt Lending Platform.
Quick answer: keep a state-wise holiday master, write one business-day convention into every loan agreement, adjust presentation dates by that convention, decide upfront whether shifted days earn interest, and compute DPD from the adjusted due date.
What Is Holiday Calendar Handling in Loan Systems?
Holiday calendar handling in loan systems covers four calendars: the Reserve Bank of India (RBI) list of holidays under the Negotiable Instruments Act for each state, the lender's own branch calendar, the borrower's bank calendar and the payment system calendar. The loan system applies them to due dates, presentations, accrual, DPD and day-end jobs.
Holiday calendar vs presentation file: National Automated Clearing House (NACH) presentation file generation builds the debit file, while the holiday calendar decides which date that file carries. Holiday calendar vs DPD engine: DPD calculation for NBFCs counts overdue days, and the calendar tells it which due date to count from.
Why Do Bank Holidays Break EMI Dates, Presentations and Interest?
Bank holidays break three things at once: the date a debit is presented, the interest for any shifted days, and the date from which overdue days are counted. Four RBI provisions frame the choices.
- NACH runs every day: the RBI's Statement on Developmental and Regulatory Policies of 4 June 2021 made NACH available on all days of the week from 1 August 2021, so presenting on a holiday is a policy choice, not a system limit.
- Overdue means unpaid on your due date: paragraph 11(2) of the RBI's NBFC Income Recognition, Asset Classification and Provisioning Directions, 2025 treats an amount as overdue if it is not paid on the due date fixed by the NBFC.
- Due dates sit in the agreement: paragraph 15(1) of the same Directions requires exact due dates and repayment frequency in the loan agreement.
- Day-end decides classification: paragraphs 18 and 19 flag overdue accounts in the day-end process for the due date, and housing finance companies (HFCs) follow paragraphs 15 to 19 through paragraph 39 of the RBI's HFC Directions, 2025.
Put together: the business-day rule must be in the agreement, or a Monday payment for a Saturday due date may count as two days past due. Separately, paragraph 7(4) of the RBI's NBFC Miscellaneous Supervisory Directions, 2026 lists charging interest beyond the period a loan was outstanding as an unfair practice.
How Should a Loan System Handle a Due Date That Falls on a Holiday?
A loan system should handle a holiday due date by payment channel, because each channel behaves differently. Use this holiday decision table as your rule sheet; owners are illustrative.
| Event | Presentation | Interest Accrual | DPD Impact | Owner |
|---|---|---|---|---|
| EMI due on a Sunday, NACH mandate | On the due date, or next business day per policy | No extra interest if the schedule is unchanged | Count from the adjusted date | Operations |
| State bank holiday at the borrower's bank | Next business day in that state | As above | Count from the adjusted date | Operations |
| Post-dated cheque due on a holiday | Deposit on the next business day | As above | Count from the adjusted date | Branch |
| Cash collection, branch closed | Collect next working day | As above | Count from the adjusted date | Branch |
| Unified Payments Interface (UPI) Autopay mandate | On the due date; UPI runs every day | Normal | Count from the contractual date | Operations |
| Month-end due date (31st) on a Sunday | Modified following: previous business day | Credit or ignore the one day per policy | Inside the same month | Operations |
| Due day 29, 30 or 31 in a shorter month | Last day of the month | Normal | Count from the last day | Product |
For cheques, keep the deposit calendar inside your PDC management for lenders process, and compare channels in eNACH vs UPI Autopay.
How Do You Set Up a Holiday Calendar Step by Step?
You set up a holiday calendar in seven steps, from loading data to testing the year ahead.
- Load the RBI holiday matrix for every state where borrowers' banks or your branches sit, plus Sundays and the second and fourth Saturdays.
- Add lender non-working days and any mid-year holiday notified by a state.
- Pick one business day convention per product and write it into the loan agreement.
- Decide whether shifted days earn interest, and record it in the agreement and the schedule logic.
- Point the DPD engine at the adjusted due date.
- Map presentation cut-offs so files for a Monday debit are built on Saturday if needed.
- Run next year's schedules against the new holiday master before 1 January and review exceptions.
Are holiday due dates creating false overdue flags in your loan book?
Configure Holiday-Aware Due Dates on the Digiqt Lending Platform
Send us last year's holiday exceptions and check your holiday calendar rules with our team.
Business-day conventions on real 2026 dates (illustrative holiday master):
| Contractual Due Date | Following Business Day | Modified Following | Preceding Business Day |
|---|---|---|---|
| Saturday 15 August 2026 (Independence Day) | Monday 17 August | Monday 17 August | Friday 14 August |
| Sunday 31 May 2026 | Monday 1 June | Saturday 30 May | Saturday 30 May |
What Code Adjusts a Due Date for the Holiday Calendar?
This Python snippet adjusts a due date by a holiday calendar and counts DPD from the adjusted date; it was tested on the dates above.
from datetime import date, timedelta
def is_business_day(d, holidays):
return d.weekday() != 6 and d not in holidays # Sunday = 6
def adjust(due, holidays, rule="following"):
step = -1 if rule == "preceding" else 1
d = due
while not is_business_day(d, holidays):
d += timedelta(days=step)
if rule == "modified_following" and d.month != due.month:
return adjust(due, holidays, "preceding")
return d
def dpd(as_of, contractual_due, holidays, adjusted=True):
ref = adjust(contractual_due, holidays) if adjusted else contractual_due
return max(0, (as_of - ref).days)
hols = {date(2026, 8, 15)}
print(adjust(date(2026, 8, 15), hols)) # 2026-08-17
print(adjust(date(2026, 5, 31), set(), "modified_following")) # 2026-05-30
print(dpd(date(2026, 8, 17), date(2026, 8, 15), hols)) # 0
print(dpd(date(2026, 8, 17), date(2026, 8, 15), hols, False)) # 2Load second and fourth Saturdays into the holiday set; the function treats only Sundays as fixed non-business days.
Which Holiday Calendar Settings Should a Loan System Expose?
A loan system should expose eight holiday calendar settings to operations, each with a safe default.
| Setting | Options | Suggested Default |
|---|---|---|
| Holiday master scope | National, state, branch, borrower bank | State of the borrower's bank |
| Business day convention | Following, modified following, preceding | Following; modified following for month-end |
| Interest on shifted days | Accrue, ignore | Ignore for retail EMIs |
| DPD reference date | Contractual, adjusted | Adjusted |
| NACH presentation on holidays | Present, defer | Defer to next business day |
| Day-end job on holidays | Run, skip | Run every calendar day |
| Mid-year holiday change | Auto-apply, approve | Approve, then re-plan affected presentations |
| Short-month due day | Last day, first of next month | Last day of the month |
Run the day-end every calendar day, holidays included, so DPD and accruals never jump.
How Does Digiqt Configure Holiday Calendars in Lending Systems?
Digiqt configures holiday calendars as part of the servicing logic it builds on the Digiqt Lending Platform, connected to your loan system through application programming interfaces.
- Holiday master → a state-wise table loaded from the RBI matrix each year, with maker-checker on every change.
- Business-day function → one tested function used by schedules, presentations, accrual and DPD, so no module invents its own rule.
- Presentation planner → files built on the last business day before a holiday cluster, reducing NACH bounce rates.
- Mid-year changes → a notified holiday triggers a list of affected loans for approval.
- Reconciliation → holiday receipts through UPI match cleanly in UPI collection reconciliation.
Your operations team still approves the yearly load and owns the agreement wording. Holiday rules also matter when a moratorium is implemented in loan systems, because restart dates can land on holidays.
What Should a Holiday Calendar Go-Live Checklist Cover?
A holiday calendar go-live checklist should cover data, rules, agreements and tests; copy these ten items.
- State-wise holiday master loaded from the RBI matrix for the coming year.
- Second and fourth Saturdays and lender non-working days added.
- One business day convention per product, written into the agreement and Key Facts Statement (KFS) schedule.
- Interest-on-shifted-days rule documented and coded.
- DPD engine reading the adjusted due date.
- Presentation calendar mapped to sponsor bank cut-offs.
- Day-end process scheduled for every calendar day.
- Month-end and short-month rules tested on 29, 30 and 31 due days.
- Mid-year holiday change process with maker-checker.
- Year-ahead dry run with exceptions signed off before 1 January.
Want every EMI, presentation and DPD count to respect the right holiday calendar?
Set Up Holiday Calendar Rules With Digiqt
Share your agreement wording, or visit Digiqt to review business-day conventions with our servicing engineers.
Official Sources
- RBI: Holiday Matrix – Holidays Under the Negotiable Instruments Act
- RBI: Statement on Developmental and Regulatory Policies, 4 June 2021
- RBI: NBFC Asset Classification Directions, 2025 (overdue and day-end rules)
- RBI: Housing Finance Companies Directions, 2025
- RBI: Non-Banking Financial Companies – Miscellaneous Supervisory Directions, 2026


