The Tool Desk
Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
Reconcile UPI money in three separate links: match every order to an authoritative payment record, record refunds and reversals as separate movements, then match the provider’s settlement detail to the actual credit in your bank account. Payment status, refund status, and settlement status answer different questions and must not be collapsed into one field.
This workflow is for Indian merchants, finance teams, and developers handling gateway, acquiring-bank, or QR collections. It shows what to capture, how to match records without creating false positives, how to investigate “payment successful but order not updated” cases, and how to escalate unresolved exceptions.
The reconciliation model: three linked but different questions
A UPI transaction can be successful from the customer’s perspective while the order remains unfulfilled, a refund can be initiated without appearing in the next settlement, and a settlement report can show a payout before the bank statement posts the credit. These are not contradictions when each record is answering a different question.
Recommended Free Tools
1. Was this order paid?
Compare the order database with the merchant-side payment record from the acquiring bank, gateway, QR provider, or other channel you use. The payment record should be authoritative for whether money was recorded on the merchant side. A customer’s UPI app screen, a redirect back to checkout, or a screenshot is evidence of what the customer saw, not proof that your acquiring side recorded and captured the payment.
#1 Best Overall
- Powerful Turbo Fan:CAGIWIRU Electric Air Duster have reached speed up to 130000RPM,Can efficient remove dust and debris.With LED light and Three Adjustable Speed to meet with different cleaning tasks.
- With Attached USB C Fasting Charging cable.Charing 3 hours,Enjoy up to 240 minutes of use on the lowest setting, For third speed can use for 25mins.with four charging options to meet with your needs.
- Wide Application:Upgraded attached 5 different nozzles,making it suitable for a variety of scenes, such as car,pet, pc, keyboards, and other electronic devices. It also serves for office and home clean duster.
- Handy Design & Portable:Cordless air duster electric nozzle is Light weight and small size, design and comfortable to hold and space saving, convenient to carry around. You can put it in your room or inside the car without taking up space.
- Warranty & Support: Our Electric air duster comes with 5 years warranty and 24/7 customer service. During this period, if you have any questions,pls kindly feel free to contact us.
2. What happened after the payment?
Refunds, reversals, disputes, and adjustments are separate financial movements. Keep their amounts, references, and statuses beside the original payment instead of overwriting it. An original payment can remain successful while a partial refund is pending, a full refund fails, or a reversal is later posted.
3. Did the provider’s settlement reach the bank?
A settlement report describes the transactions and deductions included in a payout or cycle. The bank statement proves that a credit or debit actually posted. Compare both; neither record proves the other by itself.
Build a control file before importing reports
Create one order-side control record for every checkout attempt. Keep the internal order ID even when a customer retries payment, because one order may have multiple attempts. At minimum, retain:
Free tools Windows power users keep installed
One-click scans. No signup required.
- Internal order ID and the order’s creation timestamp.
- Expected amount and currency.
- Current order state, such as created, fulfilled, cancelled, or your equivalent.
- Checkout, QR, or provider reference supplied when the payment was created.
- The provider order ID and payment ID when your integration exposes them.
- The payment attempt’s creation time and channel.
If you use a gateway integration, create the provider order server-side for each payment and preserve the returned identifier. In its integration guidance, Razorpay recommends creating an order, passing the order_id to checkout, storing the payment ID and order ID returned by checkout, and verifying the signature. That is a provider-specific implementation example, not a universal requirement for every UPI flow.
Keep original rows, not just totals
Save the unmodified export or API response from each system with an import date and reporting period. A total-only spreadsheet cannot explain why two payments with the same amount were matched to one order or why a refund changed a later settlement. Preserve the source row, the normalized fields used for matching, and the final resolution note.
Use stable identifiers and conservative matching
Start with identifiers that are intended to be unique. A practical match hierarchy is:
- Match the provider payment ID and provider order ID to the corresponding order attempt.
- Cross-check the amount and currency.
- Check transaction time against the order and payment-attempt window.
- Use a UPI transaction reference, such as an RRN, when the provider or acquirer supplies one.
- If more than one candidate remains, stop automatic matching and send the row to an exception queue.
Do not match only on customer name, phone number, or amount. Amounts repeat, names can be formatted differently, and a single order may have several attempts. Never silently collapse duplicate attempts: retain each attempt and mark which one, if any, funded the order.
Rank #2
- Screen Cleaner is Your Screen’s New Bestfriend! - EVEO is proud to present a screen cleaner that’s perfectly suited for your TV. Meet your new screen cleaner, computer screen cleaner, laptop cleaner, iPad cleaner, Macbook,tv cleaner or any other electronic device. Our screen cleaner spray and wipe along with the included plush microfiber cloth, easily removes dust, fingerprints & other smudges on the screen’s surface. Clean effectively for a streak-free screen
- Gentle on your Screens - Our screen cleaner spray and wipes is compatible to be used even for the most sensitive LCD, LED, CRT, and OLED screens in proper use. Be at ease knowing that this product is compatible with all the major brands: LG, SONY, Samsung, Sharp, iPad, iPhone, Android screens, Kindle, PC monitors - we’ve got you covered! Can be used as LCD screen cleaner, tv cleaner, smart tv screen cleaner, and more
- Premium Super Soft Plush Microfiber Cloth - Included in this efficient screen cleaning kit. This screen cleaner spray and wipe has our signature plush microfiber cloth specially designed to comply with screens and monitors and leave them streak-free. Has been shown to effectively absorbs stubborn stains, zero streaks, and no fiber shedding. Always use this together with our screen cleaner for the best results
- Easy-to-Use Screen Cleaner Kit + microfiber cleaning cloth - The EVEO Screen Cleaning Kit will easily be your new favorite tool when it comes to taking care of the things you love most, quick and easy solution for a streak-free screen. Simply screw on the sprayer gun on the screen cleaner bottle. Spray the cleaning liquid onto the microfiber cloth, then wipe the screen until desired cleanliness & shine is achieved.
- Quality Screen Care Kit Worth Purchasing - Enjoy a convenient Screen Cleaner anytime, anywhere you need it. Your satisfaction is our top priority. We stand behind the quality of our products and that’s why, you shouldn’t be worrying at all. We manufacture the Best Screen Cleaner. and can be used for laptop cleaning kit, laptop screen cleaner, tv screen cleaner for smart tv. MacBook screen cleaner, monitor cleaner or screen cleaner spray for electronic devices with microfiber cleaning cloth
Fields commonly exposed by a provider
Provider reports may include a payment ID, order ID, UPI method, amount, payment status, captured indicator, timestamp, refund status, amount refunded, and a transaction reference under acquirer data. Razorpay’s QR documentation illustrates fields of this kind, including UPI as the method and an RRN. Other providers and direct bank reports can use different names, omit fields, or expose them in separate files, so map your own schema rather than assuming a universal format.
Separate order, payment, refund, and settlement states
Use independent state dimensions. A single “paid” flag cannot represent the lifecycle accurately.
| State dimension | Examples | What it controls |
|---|---|---|
| Order | Created, fulfilled, cancelled | Whether goods or services should be supplied and whether the order remains open. |
| Payment | Pending, authorized, captured, failed | Whether the merchant-side provider record says funds were received or captured. |
| Refund | None, pending, partial, full, failed | How much of the original payment has been returned or is still being processed. |
| Settlement | Included in a provider payout, omitted, adjusted, or bank-posted | Whether the provider’s payout detail has been tied to an actual bank entry. |
Do not mark an order paid solely because checkout redirected successfully. Confirm the provider or acquirer record. Likewise, do not tell a customer that a refund has arrived merely because your system initiated it. Retain the refund reference and authoritative status until the provider or bank process confirms completion.
End-to-end reconciliation procedure
Step 1: Close the order-side period
Choose a reporting window and export all orders created or changed in it. Include cancelled and unpaid orders, not just fulfilled orders, so that missing payments and duplicate attempts remain visible. Record the expected amount, currency, order state, and every provider reference associated with each attempt.
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Step 2: Import payment records from every collection channel
Download or retrieve transaction-level data from each acquiring bank, gateway, QR provider, or other UPI channel. Do not mix channels without retaining the source name. Normalize timestamps to one timezone and normalize amount and currency formats, but preserve the original values for audit.
Step 3: Match payment rows to order attempts
Apply the identifier-first hierarchy described above. A successful match should have a provider identifier, a consistent amount and currency, and a plausible timestamp. If the amount differs, do not “round” it into a match; investigate whether the order was changed, a fee was included, or a different attempt was selected.
Step 4: Confirm the order decision
For each matched payment, decide whether the order should be fulfilled, held, cancelled, or reviewed according to your business rules. A payment record proves a merchant-side transaction, not that inventory was shipped or a service was delivered. Keep that operational decision in the order state rather than changing the payment state.
Rank #3
- 【Large size】：Measuring 800 x 300 mm/ 31. 5×12 inches, which is wider and taller than others. Large mouse pad can perfectly fit your keyboard and mouse of any size, and there is also ample space for peripherals such as phones, tablets, etc.
- 【LED backlight mouse pad】：Blade Hawks RGB mouse pad provides 7 static modes and 7 dynamic modes will give you the options you are looking for. Power-off memory function remembers the last lighting mode you selected. The super glow fiber Chroma will give you a colorful gaming setup that you want.
- 【Anti-slip rubber base】：Made from Natural rubber, this gaming mousepad will firmly grip your desktop, allowing you to enjoy the ultimate precision in the games you are most passionate about. It also comes with a texture that enhances this ability even further.
- 【Smooth and waterproof surface】: Micro-textured cloth surface, for extremely precise mouse control and a smooth movement. When liquid splashes on the gaming mouse pad, it forms water droplets and slides down. Will not delay your work or gameplay.
- 【Plug and play】: This mouse and keyboard pad is powered by USB, plug and play, no driver required. One button control light modes. Press one time to change the lighting mode, press twice to change the brightness, press and hold about 3 seconds turn ON/OFF.
Step 5: Load refunds, reversals, and adjustments separately
Attach every refund or reversal to the original payment using the provider’s refund or transaction reference. Record requested amount, processed amount, request time, completion time when supplied, and current status. For a partial refund, keep the original captured amount and the cumulative amount refunded; do not replace the original amount with the net figure.
Step 6: Obtain settlement detail for the same period
Export the provider or acquiring-bank settlement report. Identify its settlement ID, payout date, included payment transactions, refunds, reversals, fees, taxes, reserves, and other adjustments where the report supplies them. The exact fields and deduction treatment depend on your provider contract.
Step 7: Tie each settlement to the bank statement
Locate the corresponding credit or debit in the merchant bank account. Use the provider settlement ID, bank reference, value date, and amount when available. If the statement shows only a net amount, retain the settlement report as the transaction-level explanation and document how the net was calculated.
Step 8: Reconcile the arithmetic
For each payout, start with included collections, subtract documented refunds and reversals, and account for fees, taxes, reserves, and other adjustments shown in the actual report. Compare the resulting net to the bank credit. Do not assume every provider uses the same cutoff, payout day, fee treatment, or reserve policy.
Step 9: Close or escalate exceptions
Every unmatched row should end in a documented resolution: corrected order link, pending provider status, confirmed duplicate, accounting adjustment, or escalation case. Keep the original source rows and the person, date, and evidence supporting the decision.
How to handle refunds correctly
NPCI’s merchant guidance says a merchant asks its bank to refund under the defined process. In practice, your ledger should distinguish at least three events: the refund request, the provider’s processing status, and the final customer-side completion when the authoritative record supplies it.
Partial refunds
Store the original payment amount, each refund reference, each requested amount, and the cumulative amount refunded. The remaining captured amount is a calculation, not a replacement for the original payment. A settlement may contain the refund as an offset in a later cycle rather than in the cycle containing the original payment.
Rank #4
- 【Softer and More Comfortable】Vaydeer wrist rest has unique diamond pattern, which is the combination of softness and aesthetics. The materials of wrist rest are improved into higher quality memory foam and covered with silky smooth lycra. The computer wrist rest makes you as comfortable and cushiony as like rest your wrists on clouds.
- 【Ergonomic Wrist Saver】The wrist rests for keyboard and mouse comes with a 17.32×3.15×0.83 inch keyboard wrist pad and a 5.94×3.15×0.83 inch mouse wrist support. Based on ergonomic design, the unique concave shape is the perfect fit for your wrist joints. The wrist rest pad fits most computer keyboards and laptops, improve hand and wrist posture, release your wrist and arm stress.
- 【Non-Slip Rubber Bottom】Featuring an anti-skid silicone base on the bottom, this wrist keyboard support stays firmly in place on your desk, preventing the padding from sliding around, ensuring stable and consistent wrist support during extended computer sessions.
- 【Better Experience & Pain Relief】Our keyboard arm rest is beneficial to alleviate the soreness caused by direct contact and friction between your arm and a hard desk surface, reducing the risk of wrist fatigue or carpal tunnel. The soft texture of memory foam can evenly distribute the pressure around your wrists and provide good support with just enough give.
- 【Helpful in Multiple Scenarios】Whether you're working, studying, writing, typing, gaming, this keyboard and mouse rest combo is an essential accessory to add comfort and support to your hands and wrists. It’s also a great gift for men, women, family, friend, coworker, gamer, teacher, etc.
Pending or failed refunds
A refund request that remains pending belongs in the exception queue if it exceeds your documented service window. A failed refund requires a new decision: retry through the provider’s process, contact the acquiring bank, or arrange the permitted alternative while preserving the original failed reference. Do not create a second refund blindly; first establish whether the first request eventually completed.
Refund not reflected in settlement
Check whether the provider reports refunds on a separate section, uses a later payout cycle, or shows a negative line against the original transaction. Compare the refund reference and processing date, not just the customer order date. If the provider confirms completion but no corresponding settlement movement appears after the applicable reporting cycle, escalate with the original payment ID, refund ID, amount, and report lines.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Settlement reports versus bank statements
Settlement detail and bank credits are related records, not interchangeable records. A settlement report can explain the composition of a payout, while a bank statement confirms posting to your account.
| Check | Evidence to compare | Typical conclusion |
|---|---|---|
| Identity | Settlement ID, provider reference, bank narration or UTR where supplied | Whether the report line and bank credit are the same payout. |
| Timing | Provider payout date, bank value date, posting date | Whether a cutoff or banking delay explains the difference. |
| Amount | Report net amount and statement credit | Whether fees, taxes, refunds, reserves, or adjustments are documented. |
| Contents | Payment IDs and refund or reversal lines in the settlement file | Which orders and movements make up the net credit. |
NPCI’s member-bank settlement process describes banks reconciling NPCI reports with their own reports and raising adjustments for exceptional transactions. That network-level process does not define every merchant provider’s dashboard, export, cutoff, or payout schedule. Use the acquiring bank or provider’s merchant settlement report for your account.
Exception queue: symptoms, checks, and next actions
| Exception | Checks | Next action |
|---|---|---|
| Order has no confirmed payment | Search all attempts by provider order ID, payment ID, RRN, amount, and time. | Keep the order unpaid until the acquiring-side record confirms receipt; investigate pending or failed attempts. |
| Payment exists with no order | Check delayed callbacks, incorrect order IDs, duplicate attempts, and the raw provider export. | Create a review case; do not assign the payment to an order based only on amount. |
| UPI app says successful but order is not updated | Verify the provider-side status and callback or webhook log; search by RRN or provider payment ID. | Update the order only after authoritative confirmation, then document any delayed notification. |
| Amount or currency mismatch | Compare the original order snapshot, payment row, refund lines, and currency normalization. | Hold automatic fulfillment and resolve the source discrepancy. |
| Duplicate credit or attempt | Compare provider IDs, RRNs, timestamps, and order attempts. | Keep both records visible and decide whether one payment needs refund or order reassignment. |
| Refund initiated but absent | Check refund status, reference, processing date, separate refund section, and later settlement cycles. | Escalate with the payment and refund references if the provider’s stated process has completed. |
| Settlement report has no bank credit | Check payout date, value date, bank narration, account used, and whether the report is preliminary. | Ask the provider or bank for the settlement-to-bank reference and retain the report line. |
| Bank credit differs from report net | Recalculate included payments, refunds, reversals, fees, taxes, reserves, and adjustments. | Open a settlement exception with the exact arithmetic and source rows. |
What each record proves
| Record | Helps establish | Does not establish alone |
|---|---|---|
| Order database | What the merchant expected to collect and the order lifecycle. | That funds were actually received. |
| Customer UPI app or confirmation | What the customer interface displayed. | That the merchant’s acquiring side recorded and settled the transaction. |
| Provider or acquirer payment record | Payment ID, status, amount, method, and available UPI references. | That the net settlement reached the merchant bank. |
| Refund record | Whether a refund was initiated or recorded, plus its amount and status. | That the customer has received the funds unless the authoritative status confirms it. |
| Settlement report | Which transactions and adjustments the provider included in a payout or cycle. | That a bank credit posted. |
| Bank statement | The actual credit or debit to the merchant account. | Which individual orders make up a net payout without transaction-level linkage. |
UPI settlement-cycle change effective 3 November 2025
NPCI circular NPCI/2025-26/UPI/222, dated 12 September 2025, states that UPI settlement cycles 1 through 10 comprise AUTH transactions only, while cycles 11 and 12 process disputes only. The change took effect on 3 November 2025, with other settlement rules unchanged according to the circular.
Those cycle numbers describe the UPI member-settlement framework. They are not a promise that every merchant gateway will pay out on a particular day or expose identical cycle labels. Confirm your provider’s cutoff, payout schedule, report definitions, and bank-credit timing separately.
Choosing controls when you use multiple providers
If collections run through more than one gateway, bank, or QR channel, compare reporting capabilities rather than assuming their schemas are equivalent.
Best Value
- 【No Drill Mounted】Cable management tray can be assembled in as little as 3 minutes or less-simply. Side clips easily clampe the edge of desk, pass through the holes on the sides, and secure excess cables with baskets. Desk cable management supports inward or outward installation to meet your needs in different scenarios, and provides you with great convenience when collecting and organizing wires.
- 【Rubber Pad Protects Desk】Wire organizer under desk built-in soft rubber pads on the clamp protect your desk from scratches, so you will not damage your furniture or office.
- 【Sturdy and Beautiful】Cord management under desk is made of high-quality carbon steel and holds about 15 lbs. The wire basket has 2 holes on each side of the tray to enable your cables to pass freely. Cable baskets are suitable for desk thickness use from 0.4" to 2.4".
- 【Space Saving & Keep Organized】Desk cable management tray holds all your power cords, outlet strips, USB hubs and computer transformers hidden from your feet, and the data cables will not enter the vacuum cleaner to keep your desk clean and tidy. Desk wire organizer is also suitable for use in the kitchen and outdoors.
- 【Reduce Safety Risks】Cable tray under desk keeps all plugs away from your kids, no more worry about tripping. Using 2 holes wire tray saves extra space, helps you easily cabling and wire protection. The mesh design is not easy to accumulate dust, but avoids safety accidents caused by messy wires.
| Comparison criterion | Questions to ask |
|---|---|
| Order linkage | Can every payment row carry your internal order ID and the provider order ID? |
| UPI references | Are RRN or other transaction references exposed consistently? |
| Report access | Are transaction-level exports or APIs available, and can you retrieve historical periods? |
| Refund visibility | Are refund IDs, statuses, partial amounts, reversals, and completion dates shown? |
| Settlement linkage | Does each payout have a settlement ID and a bank reference? |
| Deductions | Are fees, taxes, reserves, and adjustments itemized rather than bundled? |
| Support route | Is the acquiring bank or provider clearly responsible for status checks and grievances? |
No provider has a universal schema or schedule. Select the source that gives your team enough identifiers and detail to reproduce the match and the settlement arithmetic.
Escalation package for the acquiring bank or provider
NPCI’s merchant guidance directs merchants to check status or raise a grievance with the acquiring bank. A useful case contains:
- Internal order ID and provider order ID.
- Provider payment ID and UPI transaction reference, such as the RRN, when available.
- Payment, refund, and settlement amounts with currency.
- Relevant timestamps, including timezone.
- Current payment and refund statuses.
- The exact settlement report name, period, settlement ID, and affected row.
- The corresponding bank-statement date, narration, and amount, with sensitive account details redacted appropriately.
- A concise description of the mismatch and the resolution you are requesting.
Attach original report rows rather than screenshots alone. Keep the case number and final response with the exception record so a later reviewer can follow the chain from order to payment to settlement.
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 & 11Practical operating cadence
Daily
Resolve payment-versus-order mismatches before fulfillment cutoffs, identify pending attempts, and record new refund requests. Keep customer-service cases linked to the same payment and order identifiers used by finance.
At each settlement
Import the provider detail, calculate the expected net, tie it to the bank credit, and open an exception immediately when the amount or reference is missing.
At period close
Review all open exceptions, confirm that cumulative refunds do not exceed captured amounts, investigate duplicate credits, and retain the source exports and reconciliation sign-off. The exact frequency can be adapted to your payout schedule, but the evidence chain should remain reproducible.
The Bottom Line
Keep order, payment, refund, settlement, and bank-posting states separate. Match with provider identifiers first, preserve every refund and adjustment as its own movement, and close the loop only when settlement detail agrees with the actual bank credit. When records disagree, retain the source rows and escalate through the acquiring bank or provider with the complete identifier and amount trail.
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.
