What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
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
Use the same date range in your sales register and UPI transaction history, then match each sale by amount, date and time, transaction ID, and transaction reference number. Confirmed matches can be closed; missing, duplicate-looking, pending, timed-out, or otherwise unclear entries belong on an exception list until the bank or acquiring bank confirms what happened.
What UPI reconciliation actually checks
Merchant reconciliation answers a narrow question: does every sale recorded in your shop, service business, or online order system have a corresponding UPI transaction with the expected amount and a confirmed status? It also checks the reverse: did money appear in the UPI history without a sale entry?
This is different from settlement accounting. Your sales register records what you sold. The UPI history records payment attempts and their statuses. A bank’s settlement report may show when funds were payable, adjusted, or posted to a member bank’s ledger. NPCI’s daily payable/receivable general-ledger instructions in circular NPCI/UPI/OC No. 17 / 2016–17 are directed to UPI member banks, not presented as a merchant bookkeeping requirement. Use your own sales reconciliation to identify operational differences, and use the acquiring bank’s records when you need settlement or status confirmation.
UPI is described as available 24/7 in NPCI’s FAQ, but that does not create a universal resolution time for a pending or timed-out payment. The transaction’s actual status and your bank’s procedure control what you should do next.
#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: 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.
- Economical &Reusable: Built durable materials with a long-lasting battery,our CAGIWIRU air duster it's a sustainable alternative to disposable air cans.
Records and fields to collect
Choose one reconciliation period, such as a business day, week, or month, and collect both sides before matching anything. Keep the original exports or reports unchanged so you can return to the source data if an entry is edited later.
| Record | Fields to capture | How it helps |
|---|---|---|
| Sales register or point-of-sale report | Sale number, sale date and time, amount, customer or order reference, payment method, refund or cancellation note | Defines what your business says was sold and how much was expected to be paid. |
| UPI transaction history | Transaction date and time, amount, transaction ID, transaction reference number, displayed status, payer or remitter details when supplied by the bank | Provides the payment-side evidence used to confirm, investigate, or escalate a sale. |
| Bank or acquiring-bank status response | Query date, returned status, bank case or complaint number, staff member or channel used, next action | Documents the answer for an item that cannot be closed from the original history alone. |
| Refund and adjustment records | Original transaction reference, refund or adjustment date, amount, reason, bank confirmation, customer communication | Prevents a legitimate return or adjustment from being mistaken for a missing payment. |
NPCI merchant guidance identifies the transaction ID, transaction reference number, and status as important transaction fields. A customer screenshot can be useful as a lead, but it should not replace the transaction details in the merchant or bank channel.
Step-by-step reconciliation workflow
-
Set one date range and timezone
Write down the opening and closing date and time before exporting either report. Use the same local business timezone for both reports; for an Indian merchant this will normally be Indian Standard Time. Decide whether the period is based on the sale time, the payment time, or a defined cutoff such as midnight, and apply that rule consistently. A payment made near midnight can otherwise appear in a different day from the sale.
Free tools Windows power users keep installed
One-click scans. No signup required.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
Gather complete source records
Export or review the sales entries for the period, then obtain the UPI transaction history for the same period from the merchant, bank, or acquiring-bank channel available to you. Include every displayed status, not only entries that look successful. Save the report date and the account or merchant outlet it belongs to. If the UPI history is split across devices, stores, or settlement accounts, keep each source identifiable rather than combining them without labels.
Rank #2
EVEO® Screen Cleaner Spray Kit (Streak-Free) TV Screen Cleaner for Smart TV, Lcd, LEd, Oled | Computer Screen Cleaner Spray and Wipe Microfiber Cloth - TV, Monitor, Laptop, iPad, Car - 6.7oz 1 Pack- 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
-
Normalize the data before comparing
Use one amount format, such as rupees with two decimal places, and remove accidental spaces from transaction IDs and reference numbers. Keep the original timestamp as well as a normalized version for sorting. Do not round amounts to make them agree. If a report omits seconds or uses a different display format, compare within the precision the source actually provides and flag close-but-not-exact times for review.
-
Match the strongest evidence first
Start with an exact amount match at a compatible date and time. Where available, confirm the transaction ID and transaction reference number against the payment entry or receipt. Mark the sale as confirmed only when the payment record and its status support the match. A reference number is especially useful for reconciliation and disputes because NPCI describes it as the customer reference for those purposes.
-
Build an exception list instead of forcing a match
Move any item that is missing, duplicated, amount-mismatched, or status-uncertain to a separate list. Practical exception categories include sale with no UPI record, UPI record with no sale, two sales that could fit one payment, one sale that appears to have two payments, different amounts, pending status, timeout, and an apparent refund or adjustment. These are workflow categories for organizing work, not an NPCI-defined taxonomy.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy. -
Check unresolved status through the bank route
For each exception, use the relevant bank or merchant/acquiring-bank status channel. NPCI’s FAQ and merchant guidance identify the acquiring bank as the route for checking transaction status or raising a merchant grievance. Record the query time, the exact status returned, and any case number. Do not close the sale merely because a customer says the money was debited or supplies a screenshot.
Rank #3
Sale
BladeHawks RGB Gaming Mouse Pad Extra Large Extended 31.5x12 Inch-Black | LED mouse pad with 14 lighting modes, covers keyboard & mouse, anti-slip rubber base, waterproof surface, USB powered- 【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.
-
Record the resolution and any financial action
Update the exception log with the evidence that resolved the item: confirmed payment, confirmed failure, duplicate entry removed, refund initiated, adjustment posted, or escalation still open. Keep the original values and add a resolution field rather than overwriting the first observation. If the bank instructs you to wait, record that instruction and the next review date.
-
Close the period with a control check
Count confirmed matches, open exceptions, and resolved adjustments. Compare the total value of confirmed UPI payments with the value of sales marked as paid by UPI, after accounting for documented refunds or corrections. A difference is a signal for investigation, not proof that the bank has made an error. Keep the source reports and the completed log together for the period.
How to decide whether two entries match
| Situation | Decision | Evidence to retain |
|---|---|---|
| Amount, date/time, transaction ID, reference number, and status agree | Mark the sale confirmed. | Sales row, UPI row, and the identifiers used. |
| Amount and time agree but an identifier is missing | Mark as probable and keep it reviewable until your records or bank channel provide sufficient confirmation. | Both rows and a note describing the missing field. |
| Two sales have the same amount and similar times | Do not assign one payment by guesswork; use the transaction ID, reference number, order information, or customer communication to distinguish them. | Both candidate sales and the decision evidence. |
| One sale has two apparently successful payment entries | Check whether one entry is a duplicate payment, a retry, or a reversal/refund-related record before treating it as additional revenue. | Both transaction records and the bank’s status response. |
| Amounts differ | Leave the item open. Check partial payment, tip or surcharge handling, split payment, data-entry error, or refund/adjustment records. | Original amounts and the reason for the difference. |
| A customer screenshot exists but no matching merchant record is found | Use the screenshot to collect clues, then verify through the acquiring bank or bank transaction channel. | Screenshot reference, query date, and official response. |
Pending, timed-out, and unclear payments
Pending is not automatically a failed payment
NPCI’s FAQ includes the question, “My transaction is showing ‘Pending’. The amount has been debited and not credited. Is there a problem?” Its guidance describes a pending payment as potentially delayed. Therefore, do not mark a sale paid solely because the customer’s account was debited, and do not mark it failed solely because the screen has not changed immediately. Leave the sale unresolved and check the status through the bank or acquiring bank.
When a response times out
NPCI circular NPCI/UPI/OC No. 39 / 2017–18 discusses merchant status checks when a response times out, including timeout or deemed-approved handling. The practical control is to query the transaction in the authorized bank or merchant channel and retain the returned status. A timeout in an app, terminal, or network response is not, by itself, proof that no payment occurred.
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.
When the bank reports a confirmed outcome
Use the bank’s returned status and transaction identifiers to update the exception. If the payment is confirmed, link it to the sale and note when confirmation was obtained. If it is not confirmed, keep the sale unpaid or follow your business’s documented customer-contact procedure. Status labels and available actions can vary by bank implementation, so use the label and instructions actually returned for that transaction.
Using transaction IDs and reference numbers
Keep the transaction ID and transaction reference number in separate fields. Do not assume they are interchangeable just because both are numeric or appear on a receipt. NPCI’s merchant response guidance names the transaction ID, transaction reference number, and status. It describes the reference number as the customer reference for reconciliation and disputes.
When contacting the acquiring bank, provide the transaction date and time, amount, transaction ID, reference number, merchant account or outlet identifier, and the status displayed. Supplying the complete set reduces the chance that a bank agent searches the wrong payment. Mask unnecessary personal information in internal copies, while preserving the identifiers required for the bank to locate the transaction.
Recommended Free Tools
Sales reconciliation versus settlement reconciliation
A sales reconciliation asks whether each sale has a corresponding payment event. Settlement reconciliation asks whether the amount expected from the payment provider was credited or adjusted in the relevant bank account. They are related but not identical.
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.
For example, a sale can have a confirmed UPI payment while the settlement credit is still pending in the bank’s settlement report. Conversely, a bank adjustment can appear in settlement records without representing a new sale. Keep separate columns for sale status, UPI transaction status, and settlement or adjustment status. NPCI circular NPCI/UPI/OC No. 17 / 2016–17 discusses downloading settlement and adjustment records and daily payable/receivable ledger reconciliation for member banks. Do not copy those bank-directed ledger duties into a merchant checklist as if they were a specific merchant legal obligation.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.A practical exception-log format
A spreadsheet, accounting system, or case register can hold one row per unresolved item. The important feature is a traceable history, not a particular software product.
| Column | Example content |
|---|---|
| Exception ID | EX-2026-0042 |
| Sale number and sale timestamp | INV-1847; 16 October 2026, 14:32 IST |
| Sale amount | ₹1,250.00 |
| UPI transaction date/time | 16 October 2026, 14:33 IST, if present |
| Transaction ID | Exact value copied from the bank or merchant record |
| Transaction reference number | Exact customer reference, if present |
| Displayed status | Pending, timed out, confirmed, or the bank’s exact label |
| Exception type | Sale with no matching payment, amount difference, duplicate-looking entry, or other internal category |
| Action and date | Status checked through acquiring bank on 16 October 2026 |
| Bank response or case number | Exact response and reference supplied by the bank |
| Resolution | Confirmed, refunded, corrected, still open, or another documented outcome |
For an illustrative case, a ₹1,250 sale at 14:32 and a ₹1,250 UPI entry at 14:33 may be a likely match, but you should close it only after checking the available transaction identifier and status. If the entry remains pending, the row stays open with the status query and next review date.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Troubleshooting common mismatches
| Symptom | Likely explanation to investigate | Next action |
|---|---|---|
| The sale exists, but no UPI entry appears | The customer used another payment method, the history period is wrong, the payment belongs to another outlet/account, or the record is delayed. | Check payment method, date boundaries, outlet filters, and the acquiring-bank history. |
| UPI entry exists, but no sale exists | The sale was omitted, entered under another order, or the payment was made in error or for a different outlet. | Search order references and staff records; keep the payment unmatched until identified. |
| Amount is close but not equal | Partial payment, split tender, surcharge, tip, data-entry error, or refund/adjustment. | Compare the payment breakdown and adjustment records; never alter the amount just to force a match. |
| Several entries share the same amount | Common-price sales, retries, or duplicate payments. | Use timestamps, transaction IDs, reference numbers, and order details. |
| Payment shows pending after debit | NPCI’s FAQ describes pending payments as potentially delayed. | Check through the bank or acquiring bank and leave the sale unresolved until confirmed. |
| Terminal or app timed out | The request may have reached the payment system even though the response did not return. | Use the status-check procedure described by the bank or acquiring bank; do not immediately ask for a second payment without checking. |
| Bank and sales records still disagree | The issue may require acquiring-bank investigation or a formal grievance. | Preserve all identifiers and raise the matter through the acquiring bank. |
Refunds for returned goods or rejected services
When a customer returns goods or a service is rejected, link the refund request to the original transaction rather than deleting the sale or payment row. NPCI’s FAQ says merchants should request refunds through the bank’s defined process. Ask the acquiring bank which process applies, record the request date and amount, and keep the original transaction reference with the refund or adjustment entry.
Do not describe a refund as complete until the bank or authorized channel confirms it. A customer communication can be stored alongside the case, but it does not replace the bank’s refund status.
Escalation and follow-up
For an unresolved merchant-side status question or grievance, NPCI identifies the acquiring bank as the merchant’s route. The NPCI complaint process can also provide transaction or complaint-status routing through the relevant member bank. Start with the acquiring bank’s support channel because it can access the merchant-side transaction details.
When escalating, send a concise packet: merchant identifier, outlet, transaction date and time, amount, transaction ID, transaction reference number, displayed status, sale number, and the steps already taken. Ask for a status determination or the correct refund or adjustment procedure, and record the case number. Set a review date instead of repeatedly editing the same row without a history.
Quick Recap
Controls that make the process reliable
- Reconcile on a defined schedule, such as daily for high-volume outlets and at least before a reporting period is closed.
- Restrict edits to the original sales and payment fields; add corrections as dated notes or adjustment rows.
- Use a unique exception ID so staff can discuss a case without confusing it with the sale number or bank reference.
- Require a second check for duplicate-looking payments, refunds, and amount differences.
- Keep reports, bank responses, and refund confirmations together for the same period and outlet.
- Limit access to payment identifiers and customer information to staff who need it for reconciliation.
- Do not treat a bookkeeping or accounting tool as a source of UPI truth. Software can import records, match rows, flag exceptions, and preserve an audit trail, but transaction status must still be confirmed through the bank or acquiring bank.
End-of-period checklist
- Confirm that the sales and UPI reports cover the identical dates, times, outlet, and account.
- Verify that amounts use the same currency and decimal convention.
- Match each confirmed sale with the available transaction ID, reference number, amount, time, and status.
- Move every uncertain, pending, timed-out, duplicate-looking, missing, or amount-mismatched item to the exception log.
- Check unresolved status through the acquiring bank and record the response or case number.
- Link refunds and adjustments to their original transaction references.
- Compare confirmed totals with UPI-designated sales totals, then investigate—not conceal—any difference.
- Save the source reports and close only the items supported by evidence.
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.
