Some links on this page are affiliate links: if you buy through them we may earn a commission, at no extra cost to you.
To reconcile UPI payments with bank statements and settlement reports, trace the money in three linked stages: match your sales or receipts to payment-level transaction records, match those transactions and any supported adjustments to the provider’s settlement report, then match the settlement amount to a credit actually posted in your designated bank account. These records describe different parts of the process, so a customer payment does not necessarily appear as a separate bank-statement credit. Record unmatched items as exceptions and investigate them rather than forcing a match.
What does each reconciliation record prove?
Each record answers a different question. Your sales or receipt ledger shows what your business believes it was owed; a provider’s transaction report shows payment-level activity as represented by that provider; its settlement report shows the amounts it assigns to settlement; and your bank statement shows credits that were actually posted to the account. Reconciliation links those views without treating any one of them as a substitute for the others.
As an Amazon Associate I earn from qualifying purchases.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →| Record | What it tells you | What it does not establish by itself |
|---|---|---|
| Sales, invoice or receipt records | What you sold or collected, and the amount your business expected to receive. | That a customer’s payment completed successfully or that funds reached your bank. |
| Transaction report | Payment-level activity shown by your acquiring bank or payment provider, including the references, amounts, dates and statuses that report makes available. | That every transaction has already been assigned to a settlement or credited to your account. |
| Settlement report | The provider’s accounting of amounts assigned to settlement, including any adjustments it reports. | That the corresponding credit has posted to your bank account. |
| Bank statement | Credits and other entries actually posted to the account you use to receive funds. | Which individual customer payments make up a grouped credit, unless your bank or provider supplies enough detail to establish that link. |
There is no universal merchant-facing report format established by the sources for this guide. Portal names, available fields, transaction grouping, statement narration and timing can vary by acquiring arrangement. Use the reports and identifiers available from your own bank or provider, and consult the applicable agreement where the process is unclear.
Why might UPI payments, settlement reports and bank credits not match one for one?
UPI network settlement and a merchant’s payout reconciliation are related, but they are not the same accounting view. The National Payments Corporation of India (NPCI) describes itself as the clearing and settlement agency for inter-bank UPI transactions between remitter and beneficiary members. It calculates net debit or credit positions from network data and debits or credits member settlement accounts held with the Reserve Bank of India (RBI).
Popular on Amazon
- Ideal for Gifting
- Ideal for a bookworm
- Compact for travelling
That member-level netting process does not specify how an individual merchant’s bank statement will describe a payout, or guarantee that each customer payment becomes its own bank credit. The way a provider groups transactions into settlement reports and credits depends on the merchant’s acquiring arrangement. As a result, comparing a day’s total sales directly with one bank-statement line may leave a difference that requires tracing through the transaction and settlement records.
NPCI says banks use NPCI reports and their own reports to reconcile and raise adjustments for exceptional transactions. Its documentation concerns participating institutions, not a prescribed reconciliation template for every merchant. The NPCI UPI Settlement Process document is useful context for understanding the network layer; for your business’s record format and payout handling, follow your acquiring bank or provider’s reports and agreement.
What records should I gather before reconciling?
For the same period, gather three groups of records: your own sales or receipt records, the transaction and settlement reports from the acquiring bank or payment provider, and the bank statement for the account designated to receive funds. You may also need supporting documents for reported refunds, reversals or adjustments. The exact report names and portal paths depend on your arrangement, so do not assume every provider uses the same labels or offers the same fields.
Also popular on Amazon
- Business records: sales, invoices or receipts for the reconciliation period. These establish what your business expected to collect.
- Provider records: transaction-level activity and settlement reporting for the same period. Retain the references, dates, amounts and statuses that are present in those reports.
- Bank records: the statement for the correct destination account, covering the relevant period and showing posted credits.
- Adjustment support: provider or bank records that support any reported reversal, refund, deduction or other adjustment you intend to include in the reconciliation.
Use consistent period boundaries when comparing records. For example, if your ledger covers a calendar month, obtain records that let you trace transactions and settlement activity relevant to that month; do not assume a report generated for one date range will contain precisely the same activity as a bank statement covering another. Keep the underlying records available when an item remains disputed.
How do I reconcile UPI payments step by step?
Work from the business transaction toward the bank credit, and preserve a traceable path at each stage. A match should be supported by the references and amounts available in your records, not by a convenient assumption that two similar totals must relate to each other.
- Set the period and destination account. Define the date range you are closing and identify the bank account designated to receive the funds. Collect the sales or receipt records, provider reports and bank statement for that scope. If their date ranges differ, note the boundary difference instead of treating it as a payment discrepancy immediately.
- Check your business-side total. Review the relevant invoices, sales or receipt entries and confirm the amounts your records say were due. This is the starting point for the comparison, not proof that all those payments completed or settled.
- Match receipts to transaction activity. For each receipt you can identify, compare the available transaction reference, amount, date and status with the acquiring bank’s or provider’s transaction report. Mark what matches and what does not. A missing match is an item to investigate, not a reason to invent a reference or presume a successful payment.
- Trace transaction activity into settlement. Use the available references, amounts, dates and statuses to find the corresponding activity in the settlement report. Account for a refund, reversal, adjustment or other deduction only when your provider’s report or agreement supports it. Do not assume a settlement report will reproduce your sales ledger line for line.
- Compare settlement with the bank statement. Compare the settlement amount and the reference or date information supplied by the provider with posted credits in the designated account. Check whether the statement contains a grouped credit rather than expecting a separate line for each customer payment. If the bank narration or provider data does not let you establish the link, retain the item as unresolved and request the necessary detail through the agreed channel.
- Record exceptions and follow-up. Log each unmatched, duplicated, reversed, refunded or disputed item with enough information to trace it: transaction reference, amount, relevant dates, status, responsible provider or bank, and resolution or next action. These are practical tracking fields, not a universal NPCI-prescribed merchant form.
- Close only what is supported. Mark an item reconciled when the records support the path from receipt to transaction activity to settlement and bank credit, or when a documented adjustment explains the difference. Keep open exceptions visible and retain the supporting records until they are resolved.
How should I build an exception log?
An exception log makes differences actionable: it shows what has not matched, what evidence you have, who needs to respond and whether the issue is resolved. NPCI directs member institutions to retain records of disputed transactions until disputes are resolved; merchants should likewise preserve relevant records and use the retention and dispute process that applies to their arrangement.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Repair Windows errors before they cause bigger problemsFix Now →Also popular on Amazon
| Field to track | Why it helps |
|---|---|
| Transaction reference | Lets you identify the item in the records where that reference is available. |
| Amount | Shows the value under investigation and helps distinguish otherwise similar entries. |
| Relevant dates | Captures the dates shown in the business, provider and bank records, which may not line up neatly. |
| Current status | Identifies whether the item is unmatched, duplicated, reversed, refunded, disputed or otherwise pending. |
| Responsible party and next action | Shows which provider or bank needs to clarify the item and what follow-up is outstanding. |
| Resolution and supporting record | Documents how the difference was explained or corrected, so it does not reappear as an unexplained open item. |
Do not erase an original mismatch simply because a later adjustment appears. Preserve the relationship between the original transaction and the adjustment in your records so that the final settlement and bank credit can be understood later. If a transaction is disputed, retain the relevant records while the dispute remains open and follow the procedure in your agreement.
What should I do when the totals still differ?
First locate the stage where the trail breaks: business receipt to transaction report, transaction report to settlement report, or settlement report to posted bank credit. This narrows the question and gives the bank or provider a reference point, rather than presenting only a broad claim that “UPI is short.”
- Receipt has no corresponding transaction entry: recheck the reference, date, amount and status in the report available to you. If the entry remains absent or unclear, ask the acquiring bank or provider to trace the transaction and note the response in the exception log.
- Transaction activity has no clear settlement match: preserve the transaction details and compare the settlement report’s available references, dates and amounts. Ask the provider to explain how that item was assigned or adjusted; do not infer a settlement from a similar aggregate total.
- Settlement report has no identifiable bank credit: check the statement for the designated destination account and compare the settlement amount and reference/date information supplied by the provider. If the statement does not establish the match, ask the provider or bank for the relevant trace details and record the case as open.
- Credit differs from the settlement amount: look for a documented adjustment, refund, reversal or other deduction in the provider’s report or agreement. Include only supported items in your calculation; do not invent a fee or deduction to make the figures balance.
- Entries appear duplicated or disputed: keep the records for each item, note its current status, and use the provider’s stated dispute or support process. Do not count a duplicate-looking entry as a second settled receipt without evidence.
The RBI’s directions for payment aggregators say that agreements among a PA, its merchants, acquiring banks and other stakeholders should delineate responsibilities, including for failed transactions, refunds, grievance redressal and reconciliation. That is a reason to check your own agreement for the responsible party and process; it should not be generalized as a universal legal duty of every small merchant or as proof that every provider has the same escalation channel. See the RBI Master Directions on Regulation of Payment Aggregators.
Also popular on Amazon
Do NPCI’s settlement-cycle changes tell me when a merchant payout will arrive?
No. NPCI’s cycle update describes member settlement operations; it is not a guarantee of an individual merchant’s payout time. NPCI circular NPCI/2025-26/UPI/222, dated 12 September 2025 and effective 3 November 2025, says cycles 1–10 comprise authorization settlements only and dispute settlements move to two cycles, DC1 and DC2. The circular also says other rules, including reconciliation reports, remain unchanged.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
The circular’s distinction can matter when interpreting member-level settlement and dispute processing, but it does not establish a universal merchant payout lag, a guaranteed date for a bank credit or the exact narration a merchant will see. Use the timing information and reports supplied for your specific acquiring arrangement, and verify current instructions with that provider or bank. The details are in NPCI’s September 2025 circular on authorization and dispute settlement cycles.
How often should a business reconcile?
The available official sources do not prescribe a universal merchant reconciliation frequency. Choose a period that fits your recordkeeping and the reporting arrangement you have, and make sure you can compare business records, provider transaction and settlement reports, and the destination bank statement for the same scope. Where report periods or statement dates do not align, document the difference and carry open items forward rather than declaring them resolved by default.
Also popular on Amazon
- It can be a gift option
- Comes with secure packaging
- Helpful in various ways
Whatever period you use, keep a repeatable sequence: confirm the business-side amount, trace payment-level activity, tie activity to provider-reported settlement, and verify the posted bank credit. Save evidence for adjustments and maintain a follow-up status for open discrepancies. A consistent process makes it easier to distinguish a timing or grouping question from a genuine missing or disputed transaction without assuming a provider-specific rule that may not apply to your account.
Frequently Asked Questions
Can I treat a UPI payment success message as proof that my business received the money?
Not by itself. A customer-facing or transaction status is evidence at the payment-activity stage; reconcile it against the provider’s settlement records and the credit posted to the designated bank account before treating the funds as bank-reconciled.
What if my bank statement has one UPI credit for many customer payments?
Keep the credit linked to the provider settlement information rather than trying to assign it to a single customer. Ask the provider for the relevant settlement breakdown if its report and the statement do not give you enough information to support the grouping.
Should I delete an exception once a refund or reversal is recorded?
Keep the original item and the related refund, reversal or adjustment in the audit trail. Record how the later entry resolves or changes the original discrepancy, so a reviewer can follow both events.
Does the NPCI settlement-cycle circular set the time my provider must credit my account?
No. It describes member settlement cycles and does not set a universal merchant payout timetable. Check your acquiring arrangement’s terms and current provider or bank instructions for account-specific timing.
