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 by tying three records together: the payment-provider or merchant transaction history, the UPI settlement report, and the business bank statement. Match each item by its transaction ID or UTR, verify the amount, direction, counterparty and final status, then explain every difference as a timing item, fee, refund, reversal, chargeback, error or other documented exception. Keep gross collections, fees, refunds and the net bank credit in separate ledger lines; a single net total cannot show whether the settlement is complete.
UPI (Unified Payments Interface) is an instant payment system developed by NPCI, an entity regulated by the Reserve Bank of India. Instant customer confirmation does not mean that the accounting outcome is final: a payment can remain pending, be reversed, be refunded later, or appear in a later bank settlement cycle.
What a UPI reconciliation should prove
A completed reconciliation should allow a reviewer to answer four questions for every material transaction:
- Did the payment or debit actually occur, and can it be identified by a transaction ID or UTR?
- Did the expected gross amount reach the correct UPI or bank account, with the correct credit or debit direction?
- Were fees, refunds, reversals, chargebacks and other adjustments posted separately rather than hidden in a net figure?
- Is every unmatched row assigned an explanation, owner, due date and supporting evidence?
There are usually three different totals in play:
| Total | What it represents | Where to verify it |
|---|---|---|
| Gross UPI activity | Customer collections, supplier payments, refunds and other transactions before deductions | PSP or merchant transaction history and the sales or expense ledger |
| Settlement amount | The amount a provider or member bank sends to the business account for a settlement batch | UPI settlement report |
| Net bank movement | The credit or debit that actually appears on the bank statement after fees and adjustments | Business bank statement |
The settlement amount and the bank movement can differ in date or amount without indicating fraud or an accounting error. The difference must still be explained and documented.
#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.
Collect and preserve the source records
Start with a fixed period, such as one business day, week or month. Export the following before changing or filtering anything:
- Business bank statement: Include the full account number or masked identifier, opening and closing balances, transaction dates, value dates, narrations, credits, debits and the bank’s reference numbers.
- Every relevant UPI source: Export the PSP or app transaction history, merchant dashboard transaction list and the settlement report. If more than one PSP, virtual payment address (VPA), merchant account or bank account is used, export each one separately.
- Accounting records: Export sales invoices, expense entries, refund records, fee bills, chargeback records and the general-ledger activity for the UPI clearing accounts.
- Dispute and support evidence: Preserve payment-status responses, customer or bank correspondence, return references and chargeback notices for any exception.
Keep the original files unchanged. Record the extraction date and time, account or VPA, PSP, reporting period, file name and person who downloaded the file. Work from a copy so that a later reviewer can reproduce the reconciliation.
Build one normalized reconciliation table
Different exports use different date formats, signs, currencies and status labels. Convert them into one row structure before matching. Do not overwrite the original values; retain the source value and a normalized value when a conversion is necessary.
Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Clear out junk files and repair common Windows errorsFree Scan →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →| Column | Required treatment |
|---|---|
| Transaction ID / UTR | Store the complete value exactly as supplied, preserving leading zeroes and capitalization. Keep a separate field for a provider-specific ID if it differs from the bank UTR. |
| Transaction date and time | Retain the source time zone and add a normalized date used for reporting. Do not replace transaction time with settlement date. |
| Amount and currency | Use a numeric amount with an explicit currency. Keep gross amount, fee, refund and net amount in separate columns. |
| Credit/debit direction | Record whether money was expected into or out of the business account. A negative sign alone is not sufficient when different exports use opposite conventions. |
| Payer or payee | Capture VPA, displayed name and any merchant or customer identifier available in the source. |
| Account and source | Identify the bank account, PSP, merchant profile and source file from which the row came. |
| Status | Normalize labels such as successful, settled, pending, failed, reversed, refunded, disputed or charged back, while retaining the original label. |
| Settlement date and batch | Record the date and batch reference shown by the settlement report. This may differ from the transaction date. |
| Invoice or journal link | Enter the invoice number, expense document, refund note or journal-entry ID that explains the business purpose. |
| Match result and exception data | Use values such as reconciled, timing difference, duplicate, missing bank line, missing UPI line, wrong account, fee, pending, reversal, refund or chargeback. Add owner, due date, evidence reference and reviewer date for exceptions. |
Normalize date and time only after saving the original. For example, a provider export in local time and a bank export in another time convention can appear to be different-day transactions even when they belong to the same settlement cycle.
Step-by-step reconciliation procedure
1. Set the scope and opening position
Define the accounts, VPAs, PSPs and exact start and end dates. Agree whether the period is based on transaction date, settlement date or bank value date; use separate fields if management needs all three. Carry forward unresolved items from the previous period and confirm that the opening balance of each UPI clearing account agrees with the prior close.
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
2. Match by transaction ID or UTR first
Use an exact match on the complete transaction ID or UTR as the primary key. A match is not complete merely because the identifier appears in both files. Confirm the amount, credit or debit direction, payer or payee, account, transaction date and final status. A UTR reused or duplicated in the source should be escalated rather than silently matched to the first row.
3. Use a documented composite key when the reference is missing
If one source omits the UTR, create a temporary composite key from fields such as normalized date and time, amount, direction, account, VPA and provider reference. Record which fields were used and mark the row for review. A composite match is weaker evidence than a UTR match; require a second person or source confirmation before closing a material item.
Windows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallOutdated 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 match4. Reconcile each settlement batch to the bank
Group the settlement report by settlement date and batch. Compare the batch’s expected net credit or debit with the corresponding bank line or lines. Check whether the bank narration contains a batch reference, provider name or settlement UTR. If one batch is split across several bank lines, record the allocation; if several batches are combined, retain the calculation that bridges the combined amount.
5. Bridge gross activity to the settled amount
For each batch, calculate:
Gross transactions − refunds and reversals − fees ± other documented adjustments = expected net settlement.
Keep this bridge in the reconciliation file. It shows why a sales total is not expected to equal the bank credit and prevents a fee or refund from being mistaken for a missing sale.
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.
6. Tie settled transactions to business ledgers
Link successful collections to invoices or sales journals, outgoing UPI payments to expense or supplier records, and refunds to approved refund documents. Confirm that transactions in the bank are posted to the correct legal entity, bank account and accounting period. Do not recognize revenue from a notification that remains pending or from a transaction later reversed.
7. Record and resolve exceptions
Move every unmatched or questionable row to an exception log. Include the reason code, amount, source references, assigned owner, due date, proposed correction, evidence and reviewer/date. Post an adjusting journal only after the underlying event is supported; retain the original row and link the journal to it.
8. Review and close
A reviewer should inspect duplicate IDs, unusual reversals, manual journals, large fees, old pending items and rows assigned to the wrong account. Close the period only when every material difference has an explanation or an approved open-item owner. Carry unresolved items forward rather than deleting or hiding them.
Account for gross, fees, refunds and net cash separately
A practical design uses clearing accounts so the bank statement is not forced to explain sales detail. Names vary by accounting system, but the logic is consistent.
| Event | Typical posting logic | Control point |
|---|---|---|
| Customer payment accepted | Debit UPI collections clearing; credit sales or accounts receivable for the gross amount | Invoice, UTR and final successful status must be linked. |
| Settlement reaches bank | Debit bank for the net credit; debit payment-fee expense or fee clearing for the fee; credit UPI collections clearing for the gross settled amount | The entries must equal the settlement report’s gross-to-net bridge. |
| Customer refund | Debit refunds or returns (or the approved receivable); credit UPI clearing or bank, according to when cash leaves the account | Link the refund to the original UTR and authorization. |
| Reversal of a failed or declined payment | Reverse the original clearing entry or post the return to the same clearing account | Use the return reference and final bank or provider status. |
| Chargeback | Debit chargeback receivable, loss or customer balance; credit bank or UPI clearing as appropriate | Retain the dispute reference and settlement-cycle outcome. |
Businesses that support it should use separate clearing accounts for UPI collections, refunds, fees and chargebacks. This makes an aged clearing balance visible and prevents unrelated adjustments from netting to zero.
Recommended Free Tools
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.
How to handle pending, failed, reversed and refunded transactions
Pending
Do not treat a pending app message as a completed sale or a final failure. Keep the row in a pending queue, monitor the provider and bank status, and match it again after the relevant settlement cycle. NPCI’s FAQ says a transaction shown as pending may reach the beneficiary within 48 hours after the beneficiary bank completes its daily settlements. That is an operational expectation, not permission to close the item without a final status.
Failed but debited
A customer may see a failure while the payer’s account has been debited. NPCI states that UPI provides real-time reversals for declined transactions, but a refund can take longer than intended. Its FAQ advises contacting the bank if a failed-but-debited transaction has not been refunded within one hour. Record the debit, the expected return, contact reference and eventual credit or reversal; do not create a second sale or refund entry just because the customer received an error message.
Reversed or refunded
Confirm that the return is linked to the original transaction and that the amount and beneficiary account are correct. A provider status of refunded is not enough if the bank has not received the return where cash movement is expected. Keep the original sale, the refund or reversal and the bank movement as separate linked rows.
Chargeback
Chargeback initiation is not necessarily the final financial result. NPCI’s February 10, 2025 chargeback circular notes that chargebacks were sometimes raised before beneficiary banks had time to reconcile and process returns. For specified URCS bulk-upload flows, it describes automatic acceptance or rejection based on TCC/RET in the next settlement cycle, effective February 15, 2025. Preserve the dispute reference and check the next settlement-cycle result before closing the item or recognizing a loss.
Free tools Windows power users keep installed
One-click scans. No signup required.
Exception categories and the evidence to request
| Exception | Diagnostic question | Evidence or action |
|---|---|---|
| Timing difference | Was the transaction recorded near a cut-off or settled in a later batch? | Compare transaction, settlement and bank value dates; carry the item to the next period with an owner. |
| Duplicate transaction ID | Does the same UTR appear more than once, or was one payment imported twice? | Compare source-file row IDs, amounts and timestamps; reverse the duplicate journal only with review approval. |
| Missing bank line | Does the UPI report show settlement but no bank credit? | Obtain the bank’s detailed statement or confirmation and check the account and value date. |
| Missing UPI line | Does the bank show a UPI-related movement absent from provider exports? | Request the provider’s detailed report, inspect another PSP or VPA and retain the bank narration. |
| Wrong account | Was the settlement sent to another business account or entity? | Verify account ownership and inter-account transfer postings; correct the ledger classification. |
| Fee or adjustment | Is the bank credit lower than gross settlement by a documented amount? | Obtain the fee or adjustment detail and post it separately from sales. |
| Pending, reversal or refund | Has the final status and cash return been confirmed? | Keep a status queue, link the return to the original UTR and monitor until resolved. |
| Chargeback | Has the next settlement-cycle decision been received? | Retain dispute evidence and update the accounting entry when the outcome is known. |
Cadence, roles and close controls
Reconcile daily when UPI volume is material or when customer-service and cash-forecasting decisions depend on current balances. Lower-volume businesses should reconcile at each bank close and at month-end, with a documented reason if an item remains open.
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.
- Source control: Lock the original exports and record extraction date, account, PSP and period.
- Segregation: The person importing data should not be the only person approving manual journals or closing exceptions.
- Completeness: Compare the count and total of every source file with the normalized table; investigate missing pages, filtered rows or changed export dates.
- Analytics: Review duplicate IDs, unusual reversals, aged pending items, unexpected fee rates and manual journals each period.
- Open-item discipline: Never delete an unmatched row. Assign an owner, reason code, due date and resolution evidence.
- Retention and security: Restrict access to statements and VPAs, retain the audit trail and follow the organization’s retention policy for financial records.
NPCI’s UPI Settlement Process document expresses the same control principle: “Using the reports provided by NPCI and bank’s own reports, bank need to reconcile and raise required adjustments on back-office portal to handle the exceptional transactions.” A business reconciliation extends that discipline across the PSP report, bank statement and accounting ledger.
Worked example: why sales do not equal the bank credit
Assume a settlement batch contains three successful customer payments of ₹1,000, ₹2,500 and ₹500. Gross activity is ₹4,000. A ₹100 approved refund and a ₹40 provider fee reduce the expected bank credit to ₹3,860. The reconciliation should show:
| Component | Amount | Source and accounting treatment |
|---|---|---|
| Gross successful payments | ₹4,000 | UPI transaction history; sales or receivable postings |
| Refund | (₹100) | Refund record linked to the original UTR |
| Fee | (₹40) | Provider fee report or settlement adjustment |
| Expected net settlement | ₹3,860 | Settlement report and clearing-account bridge |
| Bank credit | ₹3,860 | Bank statement line and value date |
The sales ledger remains ₹4,000 gross; the refund and fee are separate entries. If the bank credit were ₹3,760, the ₹100 difference would be an exception, not a reason to reduce sales without evidence.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Scan for outdated or missing drivers - takes under a minute3Clear out junk files and repair common Windows errorsChoosing software or a spreadsheet process
The right tool is the one that preserves source evidence and makes exceptions visible. Before adopting a connector, accounting module or spreadsheet workflow, test these capabilities with real (appropriately redacted) exports:
| Capability | Questions to ask |
|---|---|
| Bank and PSP imports | Can it ingest the exact statement, transaction-history and settlement formats used by each account? Does it preserve original files and row identifiers? |
| UTR and transaction-ID matching | Can it match on a complete UTR first, detect duplicates and document a composite-key match when a reference is missing? |
| Gross-to-net settlement | Can it show gross collections, refunds, fees, adjustments and net bank credit in one auditable bridge? |
| Status handling | Can pending, failed, reversed, refunded and chargeback rows remain open until a final outcome? |
| Exception workflow | Can each item have a reason code, owner, due date, comments, evidence and reviewer sign-off? |
| Role-based review | Can preparation, approval and period-close permissions be separated? |
| Ledger export | Can approved matches and journals export to the existing accounting ledger without losing the UTR and source reference? |
| Retention and security | Are access controls, audit logs, encryption, retention and deletion policies suitable for bank and payment data? |
Integration quality is provider- and account-specific. Require a sample import, duplicate test, pending-status test and month-end export before relying on automation for a close.
Quick Recap
Practical month-end checklist
- Confirm that every bank account, VPA, PSP and reporting period is included.
- Save immutable copies of the bank, transaction-history and settlement exports.
- Verify that normalized rows retain full UTRs, timestamps, amounts, directions and original statuses.
- Match exact UTRs first and document any composite-key matches.
- Reconcile each settlement batch to bank value dates and amounts.
- Prepare a gross-to-net bridge for collections, refunds, fees and adjustments.
- Link successful transactions to invoices or approved expense records.
- Review pending, failed-but-debited, reversed, refunded and chargeback queues.
- Investigate duplicates, wrong accounts, missing lines and unusual manual journals.
- Post supported adjustments, obtain reviewer sign-off and carry approved open items forward with owners and due dates.
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.
