Technology

Holiday Calendar Handling in Loan Systems: EMI and DPD Rules

|Posted by Hitul Mistry / 20 Nov 26

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.

  1. 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.
  2. 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.
  3. Due dates sit in the agreement: paragraph 15(1) of the same Directions requires exact due dates and repayment frequency in the loan agreement.
  4. 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.

EventPresentationInterest AccrualDPD ImpactOwner
EMI due on a Sunday, NACH mandateOn the due date, or next business day per policyNo extra interest if the schedule is unchangedCount from the adjusted dateOperations
State bank holiday at the borrower's bankNext business day in that stateAs aboveCount from the adjusted dateOperations
Post-dated cheque due on a holidayDeposit on the next business dayAs aboveCount from the adjusted dateBranch
Cash collection, branch closedCollect next working dayAs aboveCount from the adjusted dateBranch
Unified Payments Interface (UPI) Autopay mandateOn the due date; UPI runs every dayNormalCount from the contractual dateOperations
Month-end due date (31st) on a SundayModified following: previous business dayCredit or ignore the one day per policyInside the same monthOperations
Due day 29, 30 or 31 in a shorter monthLast day of the monthNormalCount from the last dayProduct

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.

  1. Load the RBI holiday matrix for every state where borrowers' banks or your branches sit, plus Sundays and the second and fourth Saturdays.
  2. Add lender non-working days and any mid-year holiday notified by a state.
  3. Pick one business day convention per product and write it into the loan agreement.
  4. Decide whether shifted days earn interest, and record it in the agreement and the schedule logic.
  5. Point the DPD engine at the adjusted due date.
  6. Map presentation cut-offs so files for a Monday debit are built on Saturday if needed.
  7. 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 DateFollowing Business DayModified FollowingPreceding Business Day
Saturday 15 August 2026 (Independence Day)Monday 17 AugustMonday 17 AugustFriday 14 August
Sunday 31 May 2026Monday 1 JuneSaturday 30 MaySaturday 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))  # 2

Load 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.

SettingOptionsSuggested Default
Holiday master scopeNational, state, branch, borrower bankState of the borrower's bank
Business day conventionFollowing, modified following, precedingFollowing; modified following for month-end
Interest on shifted daysAccrue, ignoreIgnore for retail EMIs
DPD reference dateContractual, adjustedAdjusted
NACH presentation on holidaysPresent, deferDefer to next business day
Day-end job on holidaysRun, skipRun every calendar day
Mid-year holiday changeAuto-apply, approveApprove, then re-plan affected presentations
Short-month due dayLast day, first of next monthLast 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.

  1. State-wise holiday master loaded from the RBI matrix for the coming year.
  2. Second and fourth Saturdays and lender non-working days added.
  3. One business day convention per product, written into the agreement and Key Facts Statement (KFS) schedule.
  4. Interest-on-shifted-days rule documented and coded.
  5. DPD engine reading the adjusted due date.
  6. Presentation calendar mapped to sponsor bank cut-offs.
  7. Day-end process scheduled for every calendar day.
  8. Month-end and short-month rules tested on 29, 30 and 31 due days.
  9. Mid-year holiday change process with maker-checker.
  10. 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

Read our latest blogs and research

Featured Resources

Technology

NACH Presentation File Generation: Cleaner EMI Cycles

NACH presentation file generation for lenders: the file errors that cause wrong debits and returns, a 7-step workflow and the checks to automate it.

Read more
Technology

DPD Calculation for NBFCs: RBI Day-End Rules and Examples

DPD calculation for NBFCs: RBI day-end rules, the oldest-due formula, a part-payment example, edge cases and how the Digiqt Lending Platform helps.

Read more
Technology

eNACH vs UPI AutoPay: Choosing a Loan EMI Mandate Rail

eNACH vs UPI AutoPay for loan EMIs: limits, RBI e-mandate rules, NPCI execution windows, bounce drivers and a hybrid routing model for lenders.

Read more

About Us

We are a technology services company focused on enabling businesses to scale through AI-driven transformation. At the intersection of innovation, automation, and design, we help our clients rethink how technology can create real business value.

From AI-powered product development to intelligent automation and custom GenAI solutions, we bring deep technical expertise and a problem-solving mindset to every project. Whether you're a startup or an enterprise, we act as your technology partner, building scalable, future-ready solutions tailored to your industry.

Driven by curiosity and built on trust, we believe in turning complexity into clarity and ideas into impact.

Our key clients

Companies we are associated with

Life99
Edelweiss
Aura
Kotak Securities
Coverfox
Phyllo
Quantify Capital
ArtistOnGo
Unimon Energy

Our Offices

Ahmedabad

B-714, K P Epitome, near Dav International School, Makarba, Ahmedabad, Gujarat 380051

+91 99747 29554

Mumbai

C-20, G Block, WeWork, Enam Sambhav, Bandra-Kurla Complex, Mumbai, Maharashtra 400051

+91 99747 29554

Stockholm

Bäverbäcksgränd 10 12462 Bandhagen, Stockholm, Sweden.

+46 72789 9039

Lewes

16192 Coastal Highway, Lewes, Delaware 19958, USA

software developers ahmedabad
ISO 9001:2015 Certified

Call us

Career: +91 90165 81674

Sales: +91 99747 29554

Email us

Career: hr@digiqt.com

Sales: hitul@digiqt.com

© Digiqt 2026, All Rights Reserved