UPI Collection Reconciliation: Match Every EMI to a Loan
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.
Which Identifiers Link a UPI Payment to a Loan?
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.
| Identifier | Where It Comes From | What It Links |
|---|---|---|
| Lender transaction reference | Created by the lender for each payment request | Payment to loan and instalment |
| UPI RRN | Assigned by the UPI network | Payment to bank and partner records |
| Payer UPI ID and name | Payment callback | Payment to borrower or third party |
| Amount and timestamp | Payment callback | Value date and allocation |
| Settlement batch reference | Payment partner settlement report | Payment 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.
| Cause | Effect | Prevention Check |
|---|---|---|
| Static QR or plain UPI transfer, no reference | Payment lands in suspense | Dynamic QR or intent with lender reference |
| Agents collect on personal UPI IDs | Money and loan never meet | Lender-owned QR on every collection device |
| Pending shown as failed | Borrower pays twice | Pending state with callback and timed check |
| Settlement credited net of fees in batches | Bank credit never equals loan postings | Gross-to-net matching per batch |
| Duplicate or partial payments | Wrong allocation, refunds missed | Instalment-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.
- Tag every payment request with a unique lender reference tied to loan and instalment.
- Capture payment callbacks and status, including pending results.
- Post successful payments to the loan with the payment date as value date.
- Settle by matching each settlement batch to captured payments, gross and net.
- Resolve exceptions such as no reference, duplicates, excess amounts and refunds.
- 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.
| Exception | Typical Cause | Resolution |
|---|---|---|
| No lender reference | Static QR or plain UPI transfer | Match by payer, amount, date; then call |
| Third-party payer | Family member or employer paid | Confirm with borrower, record payer |
| Duplicate payment | Pending shown as failed | Adjust to next EMI with consent, or refund |
| Excess payment | Borrower rounded up | Hold as advance or refund per policy |
| Partial payment | Borrower short of funds | Allocate per appropriation policy |
| Payment after closure | Old link or QR reused | Refund and expire old references |
| Refund or chargeback | Dispute raised by payer | Reverse 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 Rule | What It Catches |
|---|---|
| Lender reference maps to one open loan | Payments posted to the wrong account |
| Amount equals or is within tolerance of due | Partial and excess payments |
| Instalment not already paid by mandate | Double payment of one EMI |
| No second success on same reference | Duplicate payments |
| Payer name compared with borrower | Third-party and possibly fraudulent payments |
| Only success status is posted | Postings on pending or failed payments |
| Settlement batch total equals postings | Missing or extra settlement lines |
| Fee and tax lines match expected pricing | Wrong 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.
| Measure | Manual Matching | References Plus Auto-Matching |
|---|---|---|
| UPI repayments a month | 60,000 | 60,000 |
| Items needing manual matching | 3,000 | 600 |
| Staff hours a month | 750 | 150 |
| Borrowers at risk of false overdue calls | Up to 3,000 | Up 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 Situation | Recommended Approach |
|---|---|
| Regular monthly EMI | UPI AutoPay or another mandate, reconciled by mandate reference |
| Ad hoc payment in the lender's app | UPI intent with lender reference |
| Overdue account, remote borrower | Payment link with lender reference and expiry |
| Field collection | Dynamic QR generated on the lender's device |
| Branch counter payment | Loan-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.
| Metric | Formula | What a Weak Number Signals |
|---|---|---|
| Auto-match rate | Payments matched without manual touch ÷ UPI payments | Missing references or weak rules |
| Unmatched ageing | Value of unmatched items older than 3 days | Suspense build-up |
| Pending resolution time | Average hours from pending to final status | Callback or status-check gaps |
| Settlement variance | (Postings − settled gross) ÷ postings | Missing batches or wrong fees |
| Duplicate payment rate | Duplicate payments ÷ UPI payments | Pending 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
- RBI: Non-Banking Financial Companies – Credit Facilities Directions, 2025 (RBI/DOR/2025-26/347)
- Department of Financial Services and NPCI: FAQs on MDR on Select UPI (P2M) Transactions (15 September 2026)
- Taxscan: UPI Auto-Pay Transactions to Be Restricted From August 1 as New API Rules Kick In (NPCI circular of 21 May 2025)
- The Week (PTI): NPCI to Stop UPI P2P Collect Requests From October 1
- Digiqt: Lending Platform



