Free tools Windows power users keep installed
One-click scans. No signup required.
To track a UPI merchant payment, match the sale in your own order record with the acquiring bank or payment provider’s transaction report, then verify that the expected amount reached the merchant pool or bank account under your agreement. Keep the transaction ID, transaction reference, merchant ID or TID, amount, timestamp, status, and any refund or adjustment reference together. At day-end, separate successful, pending, failed, reversed, refunded, and unmatched items and maintain an exception log until every difference is resolved.
A customer’s success screen and an actual merchant payout are related but not identical evidence. NPCI handles inter-member net settlement, while your acquiring bank or provider supplies the merchant reports and credits your account. The provider agreement determines the payout destination and timing.
As an Amazon Associate I earn from qualifying purchases.
What UPI merchant reconciliation actually covers
Merchant reconciliation answers three separate questions:
- Did the customer’s payment attempt succeed? Check the status and identifiers returned by the acquiring bank or provider.
- Does the payment belong to a real sale? Match it to an order, invoice, or point-of-sale record.
- Did the expected money arrive? Compare the provider’s settlement information with the credit in the merchant pool or bank account.
Do not treat a customer-provided screenshot as final proof. It can help locate a transaction, but the provider’s record and the credited funds are the evidence used for reconciliation and disputes.
#1 Best Overall
Confirm your merchant setup before accepting payments
Identify the acquiring relationship
UPI merchant acceptance starts with an acquiring bank or payment provider. NPCI says the bank supplies the UPI infrastructure, onboards the merchant, and defines details such as the merchant identifier, merchant category code (MCC), and UPI ID. Keep the onboarding agreement and the provider’s support route accessible.
Write down the following configuration details:
- Acquiring bank or payment provider name and support channel
- Merchant ID, terminal ID (MID/TID), or equivalent identifier
- UPI ID and the QR code or integration associated with it
- Account or merchant pool where collections are expected to arrive
- Applicable payout cycle, fees, refunds, reversals, and adjustment terms in the agreement
Know the acceptance mode
NPCI lists QR, intent, application-based, and collect integration modes. The mode affects which screens and technical fields you see, but it does not remove the need to match transactions to sales and settlement credits.
Build a transaction-level record
Record each expected collection at the time of sale rather than trying to reconstruct the day from bank credits. Use one row per order or invoice and preserve the identifiers exactly as displayed by the provider.
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchPC Slower Than It Used to Be?
A free scan shows the junk files, broken settings and background clutter dragging Windows down - then fixes them in one click.Free scan · Windows 10 & 11| Field | What to record | Why it matters |
|---|---|---|
| Sale reference | Order, invoice, receipt, or point-of-sale number | Connects the payment to the goods or services sold. |
| Amount and currency | Expected amount and currency | Allows an exact comparison with the payment and settlement reports. |
| Date and time | Timestamp plus timezone | Prevents confusion when the provider’s business day differs from your local day. |
| UPI transaction ID | The provider or bank’s transaction identifier | Primary key for searching a status or dispute. |
| Transaction reference | Reference number returned for the payment, when available | NPCI’s merchant-intent guidance identifies it as useful for reconciliation and disputes. |
| Merchant identifier | MID/TID, UPI ID, or the identifier used for that collection | Shows which merchant account or terminal received the payment. |
| Status | Successful, failed, pending, reversed, refunded, or adjusted | Stops an unresolved or reversed item from being counted as a completed sale. |
| Adjustment link | Refund, reversal, charge adjustment, or related reference | Connects a later account movement to the original payment. |
NPCI’s merchant-intent document specifically names a transaction ID, transaction reference number, and success or failure status in the merchant application response. Merchants using QR, collect, or another mode should preserve the equivalent identifiers supplied by their own bank or provider.
How to check whether a UPI payment reached your account
- Find the payment in the provider or acquiring-bank view. Search by transaction ID or transaction reference, then confirm the amount, merchant identifier, timestamp, and status.
- Check the destination shown by your agreement. The expected destination may be a merchant pool account or a designated bank account.
- Compare the settlement entry with the bank statement. Look for the provider’s credit, settlement reference, date, and amount. A successful transaction record without a corresponding credit is an exception to investigate, not an automatic loss.
- Check for deductions or linked movements. Fees, refunds, reversals, or adjustments should be supported by the provider report and the agreement before you reduce the expected amount.
- Save the evidence. Retain the transaction record, report line, and bank-credit record together so another person can reproduce the match.
NPCI’s merchant FAQ says funds are received immediately after customer confirmation into the merchant pool or merchant bank account according to the merchant agreement. That statement does not establish one universal payout timetable: providers can use different account arrangements and settlement cycles.
Rank #2
- Ideal for Gifting
- Ideal for a bookworm
- Compact for travelling
Match sales to the provider’s transaction report
Use identifiers before descriptive fields
Start with the transaction ID and transaction reference. If one is missing, use the merchant ID or TID, exact amount, and a narrow timestamp window. Treat name, phone number, or a screenshot as secondary clues; they are not substitutes for the provider’s identifiers.
Classify every row
Use a controlled status list so that staff do not count the same payment differently:
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
- Successful and matched: provider record and sale agree.
- Successful but sale missing: investigate an unrecorded sale, duplicate payment, or wrong merchant account.
- Sale recorded but provider payment missing: check for a failed, pending, or incorrectly routed payment.
- Pending: keep out of settled totals until the provider confirms the final state.
- Reversed or refunded: link the reversal or refund to the original transaction and adjust the sale ledger according to your accounting policy.
- Adjusted: retain the adjustment reference and the provider’s explanation.
Compare the business day correctly
Export the provider’s transaction and settlement evidence for the relevant business day or settlement cycle. A transaction made near midnight may appear in a different provider cycle from your local sales day. Record the provider’s reporting period and timezone rather than moving the item manually without an audit note.
Understand network settlement versus merchant payout
NPCI’s settlement process describes inter-bank netting. It calculates participating members’ net debit and credit positions from acquiring, issuing, and adjustment activity and settles those member accounts. Banks then use NPCI settlement reports together with their own reports to reconcile and raise adjustments for exceptional transactions.
That is a member-level process, not a promise that every merchant will see an individually labelled credit at the same instant as the network settlement. Your merchant payout is governed by the acquiring-bank or provider agreement, including whether collections first sit in a pool account, the payout cycle, and any permitted deductions.
RBI’s discussion paper dated 17 September 2019 describes payment-aggregator services that may include reconciliation, management information reports, transaction-to-fund-flow matching, and merchant fund settlement. It distinguishes an aggregator that may handle and transfer funds from a gateway that primarily supplies technology infrastructure. Use that distinction to understand who can answer a payout question; confirm current services and responsibilities with your provider.
A practical end-of-day reconciliation procedure
- Freeze the sales population. Export or close the day’s orders, invoices, and receipts. Note the sales period and timezone.
- Download provider evidence. Obtain the transaction report, settlement report, and any adjustment or refund report for the matching cycle.
- Normalize identifiers. Preserve leading zeros, capitalization, and the provider’s exact transaction and reference values. Do not replace them with an internal shorthand.
- Match transactions. Match by transaction ID or reference first, then verify amount, merchant identifier, date/time, and status.
- Separate final from unresolved states. Move successful matched rows into the settled population. Keep pending, failed, reversed, refunded, adjusted, and unmatched rows in their respective exception categories.
- Calculate expected funds. Start with successful collections and apply only fees, refunds, reversals, or adjustments supported by the agreement and reports.
- Compare with the bank credit. Match the expected amount and settlement reference to the actual credit in the merchant pool or bank account.
- Log differences. Assign an owner, first-seen date, next action, and escalation date to every unresolved item.
- Approve the close. A responsible person should confirm that settled totals, bank credits, and open exceptions agree with the supporting reports.
NPCI’s 2017 member-bank circular describes daily downloads of settlement files and adjustment reports and daily reconciliation of payable and receivable general-ledger accounts. That is bank-operation guidance, not a universal merchant deadline. Merchants should follow the current procedure and service levels set by their acquiring bank or provider.
Maintain an exception log
An exception log prevents a missing payment from disappearing into email or chat. Include:
- Internal order or invoice reference
- UPI transaction ID and transaction reference
- Merchant ID/TID or UPI ID
- Amount, currency, date, time, and timezone
- Provider status and the last status-check time
- Expected settlement cycle and destination account
- Observed bank credit, if any
- Issue category and suspected cause
- Person responsible, action taken, and next follow-up date
- Final resolution and supporting report or bank entry
What to do in common mismatch cases
The customer says “paid,” but no merchant transaction appears
Ask for the transaction ID or reference, amount, and timestamp rather than relying only on a screenshot. Search the acquiring-bank or provider system across the relevant business day and confirm the merchant ID or UPI ID. Check whether the customer paid a different QR or merchant account. If the provider still has no record, keep the sale unconfirmed and raise the case with the acquiring bank.
The provider shows success, but the bank credit is missing
Confirm that you are checking the correct pool or bank account and settlement cycle. Compare the provider’s settlement total, settlement reference, and any documented deductions with the statement. If the expected credit remains absent, escalate with the transaction and settlement references.
Rank #4
The sale exists, but the payment is pending or failed
Do not mark the invoice as settled solely because a customer attempted payment. Keep the row pending or failed until the provider reports a final successful state. If the customer was debited, provide the transaction identifiers to the acquiring bank so it can check status and any reversal process.
A payment appears twice
Compare both transaction IDs and timestamps with the order record. If two successful collections exist for one sale, record the second as an overpayment or duplicate and follow the provider’s current refund procedure. Never delete one row; preserve both records and the link between them.
A refund, reversal, or adjustment has no original payment
Search by the adjustment reference and amount, then expand the date range because the original payment may belong to an earlier cycle. Do not net it against an unrelated sale. Keep the item open until the provider identifies the original transaction or explains the adjustment.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Escalate with a complete evidence package
NPCI directs merchants to their acquiring bank to raise a grievance or check a transaction’s status. Send one concise package containing:
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Clear out junk files and repair common Windows errorsFree Scan →- Merchant name, MID/TID, and UPI ID
- Transaction ID and transaction reference
- Amount and currency
- Date, time, and timezone
- Expected result and the status shown by the provider
- Order or invoice reference
- Relevant transaction, settlement, adjustment, and bank-credit records
- A precise question, such as “Please confirm final status and settlement date for this transaction”
Keep the support case number in the exception log. Add each response and status change rather than opening duplicate cases for the same transaction.
Best Value
- It can be a gift option
- Comes with secure packaging
- Helpful in various ways
How to evaluate a provider’s reconciliation workflow
When comparing acquiring arrangements, assess the operational evidence you will receive, not just the ability to display a QR code.
| Comparison area | Questions to ask |
|---|---|
| Payout arrangement | Is money credited directly to the merchant account or first to a pool account? What does the agreement say about timing and deductions? |
| Evidence access | Can you export transaction, settlement, status, refund, reversal, and adjustment records with stable identifiers? |
| Exception process | Where are grievances raised, which references are required, and how can you track the case? |
| Integration mode | Does the operation require QR, intent, application-based, or collect integration, and does the provider return the fields your sales system needs? |
| Reconciliation effort | Can reports be matched to order or invoice records and then to actual bank credits without manual re-keying? |
NPCI supports the listed acceptance modes and the acquiring-bank escalation route. RBI identifies reconciliation, MIS, and transaction-to-fund-flow matching as possible aggregator services. Exact report fields, exports, and payout behavior must be confirmed with the provider before onboarding.
Illustrative reconciliation example
Assume a store records three UPI sales in one local business day: ₹1,250, ₹800, and ₹2,000. The provider report shows the first as successful, the second as pending, and the third as successful with a later refund reference. The store should:
- Match the ₹1,250 transaction to its order and include it in successful collections.
- Keep the ₹800 order outside settled totals until the provider supplies a final status.
- Keep the ₹2,000 original payment and its refund linked, then account for the refund in the expected-funds calculation according to the agreement.
- Compare the resulting expected settlement with the provider’s settlement report and the actual bank credit.
- Leave the pending payment and any unexplained difference on the exception log with an owner and follow-up date.
The figures are illustrative; your provider’s report, agreement, and bank statement determine the actual settlement calculation.
Controls that make reconciliation reliable
- Use one canonical transaction record even if the sale is captured in a POS, spreadsheet, and accounting system.
- Restrict editing of transaction IDs and timestamps; record corrections as new audit entries.
- Reconcile by settlement cycle as well as by sales day so timing differences remain visible.
- Keep successful collections separate from pending and reversed items in dashboards and cash forecasts.
- Require a reference for every manual adjustment, refund, or write-off.
- Review old open exceptions regularly and escalate according to the provider’s current procedure.
Frequently Asked Questions
Does a UPI customer screenshot prove that the merchant has been paid?
No. Use the screenshot to obtain a transaction reference, then verify the transaction in the acquiring bank or provider system and match the resulting settlement to the expected pool or bank-account credit.
Who should a merchant contact about an unresolved UPI transaction?
Contact the acquiring bank or payment provider that onboarded the merchant. Provide the transaction ID or reference, merchant identifier, amount, timestamp, status, and supporting settlement or bank-credit evidence.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →
