Technology

UPI Collection Reconciliation: Match Every EMI to a Loan

|Posted by Hitul Mistry / 17 Nov 26

Last reviewed: November 2026

UPI collection reconciliation is the matching of every Unified Payments Interface (UPI) repayment a lender receives to the right loan account, instalment and settlement credit. When it fails, borrowers who paid on time get reminder calls, suspense balances grow and the finance team cannot close the books without days of manual matching.

This guide is for chief financial officers (CFOs) and heads of operations at non-banking financial companies (NBFCs), banks, housing finance companies (HFCs) and fintech lenders. It covers the identifiers that make matching possible, a six-step workflow, eight matching rules, exception handling and the metrics that show it is working.

Key Takeaways

  • UPI collection reconciliation has three links to close: payment to loan, loan to instalment and payment to settlement credit.
  • The single biggest fix is a unique lender reference on every payment request, through dynamic QR codes, intent links or loan-specific UPI IDs.
  • Treat pending UPI status as pending; NPCI now limits how often a status can be checked.
  • From 15 October 2026, settlements may arrive net of merchant fees, so loans must be credited gross and fees booked separately.

What Is UPI Collection Reconciliation?

It proves that each UPI rupee received has been credited to the right loan and that every credit in the loan system is backed by money in the lender's bank account. It covers intent payments, QR codes, payment links and UPI AutoPay debits.

Receipts that cannot be identified at all are covered in our guide to unidentified receipts in lending. This guide focuses on UPI-specific matching, which is where most of those receipts can be prevented.

Five identifiers link a UPI payment to a loan: the lender's transaction reference, the UPI retrieval reference number (RRN), the payer's UPI ID, the amount and timestamp, and the settlement batch reference. Each one closes a different link.

IdentifierWhere It Comes FromWhat It Links
Lender transaction referenceCreated by the lender for each payment requestPayment to loan and instalment
UPI RRNAssigned by the UPI networkPayment to bank and partner records
Payer UPI ID and namePayment callbackPayment to borrower or third party
Amount and timestampPayment callbackValue date and allocation
Settlement batch referencePayment partner settlement reportPayment to bank credit

Why Does UPI Collection Reconciliation Fail?

UPI collection reconciliation fails for five reasons: payments without a lender reference, collections into personal UPI IDs, mishandled pending status, net settlements and duplicate or partial payments. Each has a prevention check.

CauseEffectPrevention Check
Static QR or plain UPI transfer, no referencePayment lands in suspenseDynamic QR or intent with lender reference
Agents collect on personal UPI IDsMoney and loan never meetLender-owned QR on every collection device
Pending shown as failedBorrower pays twicePending state with callback and timed check
Settlement credited net of fees in batchesBank credit never equals loan postingsGross-to-net matching per batch
Duplicate or partial paymentsWrong allocation, refunds missedInstalment-level matching rules

Why Are Personal UPI IDs a Reconciliation and Compliance Risk?

Personal UPI IDs break the chain between the borrower's payment and the loan, and they put the lender's money in an individual's account. For digital loans, the RBI (Non-Banking Financial Companies – Credit Facilities) Directions, 2025 (RBI/DOR/2025-26/347) require repayments to be made directly into the NBFC's bank account, without any pass-through or pool account of a third party.

Separately, NPCI stopped person-to-person (P2P) collect requests from 1 October 2025, following a circular dated 29 July 2025. Field teams should collect only through lender-generated QR codes or links, and our guide to a field collection app shows how to put them on every device.

What Is the Right UPI Collection Reconciliation Workflow?

The right UPI collection reconciliation workflow has six steps: tag, capture, post, settle, resolve and close. Run it daily, not at month-end.

  1. Tag every payment request with a unique lender reference tied to loan and instalment.
  2. Capture payment callbacks and status, including pending results.
  3. Post successful payments to the loan with the payment date as value date.
  4. Settle by matching each settlement batch to captured payments, gross and net.
  5. Resolve exceptions such as no reference, duplicates, excess amounts and refunds.
  6. Close the day with a report of matched, pending and unmatched items.

Step 1: How Do You Make Every UPI Payment Identifiable?

Make every UPI payment identifiable by creating the reference before the borrower pays. Dynamic QR codes, intent links in the app and payment links can all carry a lender transaction reference for a specific loan and instalment.

Where a static code is unavoidable, such as at a branch counter, use a loan-specific UPI ID rather than one shared ID for the whole company. Our guide to digital payment links for loan collections explains how to build reference-carrying links for overdue accounts.

Step 2: How Should Pending UPI Status Be Handled?

Handle pending UPI status as a separate state, never as a failure. According to an NPCI circular of 21 May 2025 on UPI application programming interface (API) usage, applied from 1 August 2025, members must wait at least 90 seconds after authentication before checking status and may check only three times in two hours.

So the loan system should wait for the partner's callback, run a limited number of timed status checks and tell the borrower the payment is being confirmed. Asking the borrower to pay again is the most common source of duplicate EMIs.

Steps 3 and 4: How Do You Match Settlement Credits to Loan Postings?

Match settlement credits by batch, not by individual bank line. Post each successful payment to the loan at the gross amount and payment date, then match the partner's settlement batch, its fee and tax lines and the net bank credit to the postings.

From 15 October 2026, UPI person-to-merchant payments above ₹2,000 carry a merchant discount rate (MDR), so settlement batches may include fee deductions. The loan must still show the full amount the borrower paid, with the fee and Goods and Services Tax (GST) booked as lender expenses.

Our guide to disbursement reconciliation applies the same batch logic to money going out.

Step 5: Which UPI Exceptions Need a Human?

Seven UPI exceptions need a human decision: no reference, third-party payer, duplicate payment, excess payment, partial payment, payment after closure and refund or chargeback. Everything else should match automatically.

ExceptionTypical CauseResolution
No lender referenceStatic QR or plain UPI transferMatch by payer, amount, date; then call
Third-party payerFamily member or employer paidConfirm with borrower, record payer
Duplicate paymentPending shown as failedAdjust to next EMI with consent, or refund
Excess paymentBorrower rounded upHold as advance or refund per policy
Partial paymentBorrower short of fundsAllocate per appropriation policy
Payment after closureOld link or QR reusedRefund and expire old references
Refund or chargebackDispute raised by payerReverse posting, reopen dues if needed

Exceptions should land in one place, and our guide to the loan servicing exception queue shows how to route them by owner.

Which Matching Rules Should Run on UPI Collections?

Eight matching rules should run on UPI collections: reference match, amount check, instalment check, duplicate check, payer check, status check, settlement match and fee check.

Matching RuleWhat It Catches
Lender reference maps to one open loanPayments posted to the wrong account
Amount equals or is within tolerance of duePartial and excess payments
Instalment not already paid by mandateDouble payment of one EMI
No second success on same referenceDuplicate payments
Payer name compared with borrowerThird-party and possibly fraudulent payments
Only success status is postedPostings on pending or failed payments
Settlement batch total equals postingsMissing or extra settlement lines
Fee and tax lines match expected pricingWrong MDR or GST deductions

How many UPI repayments are sitting in suspense today, and how old is the oldest?

Talk to Our Lending Platform Specialists

Visit Digiqt to see how a lending platform can match every UPI repayment to the right loan.

How Much Can UPI Collection Reconciliation Save?

Better UPI matching saves operations hours and protects borrowers from false overdue calls. In this illustrative scenario, a lender receives 60,000 UPI repayments a month, 5% need manual matching and each takes 15 minutes.

Assume lender references on every payment request and automated matching cut manual items to 1%. These are assumptions to show the method, not benchmarks.

MeasureManual MatchingReferences Plus Auto-Matching
UPI repayments a month60,00060,000
Items needing manual matching3,000600
Staff hours a month750150
Borrowers at risk of false overdue callsUp to 3,000Up to 600

There is also a fee-control angle. If 30,000 of those payments are manual UPI EMIs averaging ₹6,000, the new MDR adds about ₹24 each, or ₹7.2 lakh a month plus GST, that finance must be able to trace.

The lesson for leadership: reconciliation is designed at the moment a payment is requested, not at month-end. A reference created before the borrower pays saves hours of matching after.

Where Does Digiqt Lending Platform Fit in UPI Collection Reconciliation?

The Digiqt Lending Platform is built to help lenders launch custom lending products or platforms in a matter of weeks. It handles onboarding, disbursement and repayments through APIs, and for NBFCs it offers APIs for onboarding, payments and other financial products.

The platform page does not list a UPI reconciliation module, so the workflow above would be configured or custom-built on its repayments layer. Typical components include:

  • Reference generation for each payment request, tied to loan and instalment.
  • Callback and status handling with a pending state and rule-limited status checks.
  • Posting and settlement matching, gross to the loan and net to the bank, with fee lines.
  • An exception queue with owners and ageing for unmatched items.

Digiqt's delivery process starts with problem understanding, suggests a technological solution after validating return on investment (ROI) and solution fit, and then delivers through prototyping, agile sprints, launch and ongoing optimisation. Digiqt is ISO 9001:2015 certified; test any build on a month of your own UPI and settlement data before rollout.

Digiqt's payment exception resolution AI agent shows how payment breaks can be triaged before they reach a person.

Which UPI Collection Method Fits Each Repayment?

The right UPI collection method depends on whether the payment is scheduled, ad hoc or collected in the field.

Repayment SituationRecommended Approach
Regular monthly EMIUPI AutoPay or another mandate, reconciled by mandate reference
Ad hoc payment in the lender's appUPI intent with lender reference
Overdue account, remote borrowerPayment link with lender reference and expiry
Field collectionDynamic QR generated on the lender's device
Branch counter paymentLoan-specific UPI ID, not a shared company QR

How AutoPay compares with electronic mandates is covered in our guide to eNACH vs UPI AutoPay.

Which Metrics Show UPI Collection Reconciliation Is Working?

Five metrics show whether the matching is working: auto-match rate, unmatched ageing, pending resolution time, settlement variance and duplicate payment rate. Review them daily in operations and monthly with finance.

MetricFormulaWhat a Weak Number Signals
Auto-match ratePayments matched without manual touch ÷ UPI paymentsMissing references or weak rules
Unmatched ageingValue of unmatched items older than 3 daysSuspense build-up
Pending resolution timeAverage hours from pending to final statusCallback or status-check gaps
Settlement variance(Postings − settled gross) ÷ postingsMissing batches or wrong fees
Duplicate payment rateDuplicate payments ÷ UPI paymentsPending shown as failed

Which Mistakes Weaken UPI Matching?

Four mistakes weaken UPI matching, and each is avoidable.

  • One company QR for everyone. Every payment then needs detective work.
  • Matching bank lines instead of batches. Net settlements never tie to postings.
  • Showing pending as failed. Borrowers pay twice and refunds follow.
  • Posting the net amount to the loan. The borrower appears short by the fee.

What Is Changing Next?

Merchant fees are now part of UPI settlement. According to the Department of Financial Services and NPCI FAQs of 15 September 2026, UPI person-to-merchant payments above ₹2,000 carry a 0.4% MDR from 15 October 2026, capped at ₹300, while UPI AutoPay mandates carry no prescribed MDR and merchants cannot pass the fee to customers.

Reconciliation rules should now expect fee lines per transaction and different pricing by collection method. Ask your payment partner for a settlement report that shows gross amount, MDR and GST for every payment.

Want every UPI repayment matched to the right loan the same day?

Talk to Our Lending Platform Specialists

Visit Digiqt to see how the Digiqt Lending Platform can tag, post and reconcile UPI repayments automatically.

Sources

Read our latest blogs and research

Featured Resources

Technology

Unidentified Receipts in Lending: Clear Suspense Credits

Unidentified receipts in lending: why borrower payments land in suspense, a 7-step workflow to apply them on time and the metrics that keep reporting true.

Read more
Technology

Disbursement Reconciliation: Match Every Payout to a UTR

Disbursement reconciliation for lenders: why loan payouts fail to match bank UTRs, a 7-step daily workflow and the controls that close breaks early.

Read more
Technology

Digital Payment Links for Loan Collections: One-Click EMIs

Digital payment links for loan collections: how to get overdue EMIs paid in one click, stay within RBI's direct-repayment rule and reconcile every payment fast.

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

Malaysia

Level 23-1, Premier Suite One Mont Kiara, No 1, Jalan Kiara, Mont Kiara, 50480 Kuala Lumpur

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