What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Reconcile UPI with your books by linking three records for the same period: the UPI or payment-service-provider transaction report, the bank statement or electronic settlement scroll, and your sales, invoice, cashbook and GST records. Match transactions by UTR first, keep unsettled receipts in a UPI clearing account, and explain every difference as timing, fees, tax, refund, reversal, chargeback, duplication or an error. A UPI success message proves a payment event; the bank statement proves when cash settled.
What a UPI reconciliation is—and why the totals differ
Unified Payments Interface (UPI) is an instant payment system developed by the National Payments Corporation of India (NPCI), an RBI-regulated entity. “Instant” describes the payment instruction and status response, not necessarily the date on which your bank account receives a settlement credit.
As an Amazon Associate I earn from qualifying purchases.
A customer can receive a successful UPI confirmation while the related settlement appears in a later bank batch. Conversely, a bank credit may combine many customer payments and deduct processor fees or taxes before it reaches the account. Refunds, reversals, chargebacks and duplicate imports create further differences between a UPI-app total, a bank total and your sales register.
The objective is not to force the three totals to agree by netting them. It is to create a traceable bridge from each source transaction to the accounting entry and then to the bank settlement.
#1 Best Overall
- Compact & Portable Design: This Small Excel, Word, PowerPoint, & Windows Cheat Sheet Mouse Pad measures 11.8" x 9.8", offering a portable mouse pad. Its compact size fits in bags or laptop cases, suitable for professionals, students, or travelers.
- Multi-Software Shortcut Guide: Featuring essential shortcut keys for Excel, Word, PowerPoint, & Windows, this small mouse pad provides a quick reference for frequently used shortcuts, offering a reference designed to support workflow efficiency
- Smooth & Precise Surface: The finely-textured surface ensures precise mouse control, allowing for smooth and accurate movement during work or gaming sessions.
- Durable & Non-Slip Design: This Multi-Software Shortcut Mouse Pad features stitched edges to reduce fraying. The non-slip rubber base helps keep it securely in place, and the water-resistant fabric allows for easier maintenance.
- Clear Print Quality: Displays high-resolution printing intended to remain legible through regular use and cleaning
The three-ledger model
| Record | What it proves | Fields to preserve | Typical timing |
|---|---|---|---|
| UPI or PSP transaction detail | Payment instruction, payer or payee, status and transaction reference | UTR or reference, payer/payee VPA, gross amount, status, refund or reversal indicator, transaction date and time | When the payment was initiated or reported by the PSP |
| Bank statement or electronic settlement scroll | Cash actually credited or debited to the bank account | Bank value date, narration, UTR or bank reference, credit/debit amount, settlement batch and closing balance | When the bank posts the settlement |
| Sales, invoice, cashbook and GST records | Underlying sale or expense, tax treatment and accounting entry | Invoice number, customer or supplier, gross consideration, tax, ledger account, receipt or payment voucher and posting date | When the underlying supply, receipt or accounting event is recorded |
Keep the original exports from every source. Work on a copy or a controlled reconciliation file so that an adjustment never overwrites the evidence that was supplied by the bank or PSP.
Set the reconciliation scope before importing anything
Write the scope at the top of the reconciliation file. It should identify:
- the accounting period, including the opening and closing dates;
- the specific bank account and currency;
- each UPI app, PSP or payment channel included;
- the opening and closing bank balances;
- the report-generation date and timezone used by each export; and
- the person preparing and the person reviewing the reconciliation.
Do not compare a calendar-month UPI report with a bank statement based on a different timezone, cut-off time or value-date convention. If a report is generated in local time and the bank uses another timestamp convention, retain both the source timestamp and a normalized timestamp.
Recommended Free Tools
Collect and preserve the source files
Obtain the complete period, not only the rows that appear successful. Your evidence pack normally includes:
- UPI-app or PSP transaction history;
- the bank statement or electronic scroll for the account;
- the PSP settlement report, including batch or settlement identifiers;
- the sales and invoice register and cashbook;
- refund, chargeback and reversal reports;
- fee and tax invoices issued by the PSP, where applicable; and
- any bank or PSP correspondence about a disputed or failed transaction.
CGA guidance describes electronic scrolls, purpose transaction summaries, reconciliation reports, challan summaries and receipt-scroll reports for online receipts including UPI. For government or other controlled environments, reconcile those reports challan-wise where that process applies.
Save the original file format and a read-only copy. Record the export date, reporting period, timezone and filters used. A screenshot of a UPI success screen can support an investigation, but it is not a substitute for the downloadable transaction detail and bank evidence.
Rank #2
- [MULTIFUNCTIONAL]You'll get 2 pieces computer monitor memo boards that you can stick on the left and right edges of your monitor, and they're the perfect office desk organizers and accessories. Computer monitor side panels desktop organizer are suitable for home work or office,bringing convenience. Desktop memo is used to organize meeting memos, important messages, business cards, planning notes.Paste on the message board to keep track of important things and to-do items to prevent forgetting.
- [🌟HIGHLY QUALITY] The material of computer screen side note holder is transparent acrylic. Durable, simple, stylish, light weight, easy to use, not easy to fall off or break. This cute office supplies for women desk can be used for a long time. This computer desk accessories is waterproof and dirt resistance, and look simple and stylish. The transparent acrylic sticky note holder as cubicle accessories is easy to notice the context of your sticky notes.
- [📋Easy to use] Office must haves cool office gadgets for desk ready to tear, easy to install and remove, not easy to leave traces. You only need to peel off the protective film on the surface of the computer side board memo, wipe off the dust on the edge of the computer monitor, and then stick the desk essentials for women office on the right or left side of the tape, and you're done. A perfect gift for your colleagues, friends or classmates and family members or relatives
- [🏢MULTI-SCENE USE] This desk supplies computer memo board can be applied to home and office, clear your office decor for women, suitable for most computer monitors, screens and cabinets, you can put it where you think, this cute office decor serve as a reminder. Stick on the computer side. It’s a good office gadgets can remind work improve office productivity. Pasted cabinets, dressers, refrigerators, walls, etc as cubicle accessories. To make life more orderly.
- [💌NOTE] The adhesive force of the computer sticky note holder is very strong. It can not be directly pasted on the computer screen. It should pasted on the black edge of the screen. Narrow edge not recommended!!! If you are not satisfied with your purchase, or if the product is damaged or broken in transit, please let us know immediately. We will promptly solve your problem.
Normalize the data before matching
Different systems use different column names and sign conventions. Create a standard reconciliation schema and map every source into it. At minimum, normalize:
- transaction date and time, including timezone;
- credit and debit signs and the reporting currency;
- UTR, transaction ID or other reference;
- payer or payee name and VPA;
- gross transaction amount;
- processor fee and any tax on that fee;
- net settlement amount;
- status, including successful, pending, failed, reversed, refunded or charged back; and
- settlement date and settlement batch.
Do not delete failed, pending, reversed or duplicate-looking rows. Give each row a final-status field and an exception reason. Removing an unsuccessful row can hide a debit that has not yet reversed or cause a later reversal to be treated as an unexplained bank item.
Match transactions in a controlled order
Use the strongest identifier available first. A reference-only or amount-only match is unsafe when several customers pay the same amount on the same day.
- Match the exact UTR or transaction reference. Confirm that the reference belongs to the same account, direction and status in both systems.
- Check the amount and date window. Use the gross amount for the UPI-to-sales match and the net amount only when tying a settlement line after fees, tax, refunds or other bridge items are shown.
- Use payer or payee details. Compare VPA, name, invoice number or order reference where available.
- Match the settlement batch. A single bank credit may represent many UPI transactions; link every included UTR to that batch rather than treating the batch as one sale.
- Document one-to-many and many-to-one matches. A split settlement, combined bank credit or consolidated refund needs an explicit mapping table. Never silently net several rows into one.
When a UTR is absent from one source, use a controlled combination of amount, date window, payer or payee and settlement batch. Mark the match as secondary and require reviewer approval. Amount-only matching should be an exception, not the normal method.
Post the accounting entries without losing the gross transaction
The accounting treatment should show the underlying sale or expense, the payment processor’s deductions and the eventual bank settlement separately. A UPI clearing account prevents a timing gap from being mistaken for a missing receipt.
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 →Customer payment received but not yet settled
When the UPI report shows a successful customer payment and the sale is recognized, record the gross receipt against the UPI clearing account. The exact ledger names depend on your chart of accounts, but the pattern is:
Rank #3
- Stay Organized with Ease: Our To Do List Notepad provides multiple sections with plenty of space to jot down all of your important tasks.A versatile office supply perfect for daily task management, helping you keep track of everything that needs to be done and prioritize effectively.
- Achieve Your Productivity Goals: Begin each day on a positive note, reminding you of your potential, strength, and the significance of staying focused on your goals. Our Daily Checklist Notepad is the ultimate tool to streamline your daily planning and elevate your productivity. With a clear and concise overview of your tasks, you can effortlessly prioritize what truly matters and make consistent strides towards achieving your goals.
- Reliable and Stylish: Our to do list planner combines functionality with durability. With a transparent PP cover, the inner pages are well-protected from dirt and wear. Additionally, the back cover is crafted with thick paperboard, offering a stable surface for your writing needs. Each notepad includes 52 pages of high-quality, 100gsm paper, which is thick and non-bleeding, resulting in a smooth and enjoyable writing experience.
- Versatile Use: This daily checklist notepad, suitable for teacher supplies and a wide range of applications, proves invaluable in various settings including work, school, and home. Whether you need to organize your daily tasks, plan a project, or create a grocery list, this notepad serves as the ideal tool. Its compact size ensures easy portability, allowing you to conveniently carry it with you throughout your day.
- Perfect Present for Anyone: Our Daily To-Do List Notepad is the perfect present for those who value organization and productivity. With its stylish design and versatility, this office desk accessory is also a practical addition to school supplies. Suitable for students, professionals, and homemakers alike, it helps keep tasks and priorities in check effortlessly.
Debit: UPI clearing account (gross receipt)
Credit: Sales or receivable account (gross receipt, with the applicable tax split)When the PSP or bank settles the amount, move the net cash to the bank and record the deductions explicitly:
Debit: Bank account (net settlement)
Debit: Payment-processing fee expense (fee)
Debit: Input tax or other applicable tax account (tax on fee, where eligible)
Credit: UPI clearing account (gross settlement amount)Use the fee invoice and the applicable tax treatment before posting an input-tax credit. Do not assume that every deduction is a fee or that every fee carries recoverable tax.
Refunds, reversals and chargebacks
Link each refund, reversal or chargeback to the original UTR and retain approval or customer-support evidence. Reverse the original receipt or receivable and record any separate fee or adjustment required by the PSP. A refund that appears in the UPI report before the bank debit belongs in the clearing account until the bank posts it.
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 →Failed and pending transactions
Keep a failed or pending row visible until its final status is established. NPCI’s FAQ says declined transactions are intended to reverse in real time and advises contacting the bank if an account debit does not reverse immediately. If a customer’s account was debited but the expected reversal has not occurred, open an exception with the bank rather than treating the amount as a completed sale or deleting the row.
Classify every unmatched item
At the end of matching, every remaining row needs one reason and one owner. Use categories that lead to an action:
- Timing difference: UPI success is in the period, but bank settlement is in the next period.
- Pending: the final status or settlement is not yet available.
- Failed or reversed: the original instruction did not complete or was returned.
- Refund or chargeback: money moved back after the original receipt.
- Duplicate: the same transaction was imported twice or recorded twice.
- Bank-only: a statement item has no identified UPI or accounting source.
- UPI-only: a payment report row has no bank settlement or accounting link.
- Fee or tax: the bank received the net amount after a separately documented deduction.
- Data-quality error: a missing UTR, wrong sign, wrong date, truncated export or other import problem.
For each exception, record the amount, UTR or reference, source files, explanation, corrective entry or follow-up, responsible person and resolution date. Escalate old pending items and any unexplained bank debit according to your bank or PSP’s dispute process.
Rank #4
- 【Adjustable & Ergonomic】：This laptop stand can be adjusted to a comfortable height and angle according to your actual needs, letting you fix posture and reduce your neck fatigue, back pain and eye strain. Very comfortable for working in home, office and outdoor.
- 【Sturdy & Protective】 ：Made of sturdy metal, it can support up to 17.6 lbs (8kg) weight on top; With 2 rubber mats on the hook and anti-skid silicone pads on top & bottom, it can secure your laptop in place and maximum protect your device from scratches and sliding. Moreover, smooth edges will never hurt your hands.
- 【Heat Dissipation】 ：The top of the laptop stand is designed with multiple ventilation holes. The open design offers greater ventilation and more airflow to cool your laptop during operation other than it just lays flat on the table.
- 【Portable & Foldable】：The foldable design allows you to easily slip it in your backpack. Ideal for people who travel for business a lot.
- 【Broad Compatibility】：Our desktop book stand is compatible with all laptops from 10-15.6 inches, such as MacBook Air/ Pro, Google Pixelbook, Dell XPS, HP, ASUS, Lenovo ThinkPad, Acer, Chromebook and Microsoft Surface, etc.Be your ideal companion in Home, Office & Outdoor.
Reconcile gross UPI activity to net bank settlement
Perform the reconciliation at both transaction and aggregate levels. First compare transaction counts and gross amounts by day and by settlement batch. Then prepare a bridge that explains why the bank credit differs from the gross UPI total:
Free tools Windows power users keep installed
One-click scans. No signup required.
- Start with the gross successful UPI transactions for the period.
- Remove transactions that were refunded, reversed or charged back, showing each category separately.
- Subtract processor fees and related taxes supported by invoices or settlement detail.
- Include timing items that are successful in UPI but settle after the period, and receipts settled in the period that belong to an earlier UPI period.
- Agree the resulting net settlement to the bank statement or electronic scroll.
- Bridge the opening bank balance, add identified receipts, subtract payments and adjustments, and agree to the closing bank balance.
CGA reconciliation reporting is intended to show transactions that have not settled with the bank. Keep that unsettled list with the period file; it explains why a correct UPI total can differ from the cash balance at the reporting date.
Illustrative example: suppose a sales register records a customer payment of ₹10,000, the PSP settles ₹9,800 after a ₹200 fee, and the bank posts the credit one day later. The sale remains ₹10,000 in the sales and tax records. The ₹10,000 first enters UPI clearing; the later settlement moves ₹9,800 to bank and ₹200 to the fee account. The one-day gap remains a dated timing exception, not a missing sale. The figures are illustrative; use your actual settlement report and fee invoice for posting.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.GST and audit records: what to retain
GST and audit readiness depends on source documents and a reproducible trail, not merely on a final total. CBIC’s accounts-and-records rules call for invoices, bills, credit and debit notes, receipt and payment vouchers and other relevant documents, together with an audit trail showing the inter-linkages between source documents and financial accounts.
For each material receipt or adjustment, retain a link from:
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Scan for outdated or missing drivers - takes under a minute3Repair Windows errors before they cause bigger problems- the invoice or voucher to the UPI transaction and UTR;
- the UPI transaction to the settlement batch and bank statement line;
- the fee or tax deduction to the PSP invoice or settlement report; and
- the refund, reversal or chargeback to its original transaction and approval evidence.
Preserve the original electronic files, the normalized working file, the exception log, adjustment journals, reviewer sign-off and the final reconciliation report. RBI financial-statement directions provide a banking presentation and disclosure framework, but the accounting standard and retention period applicable to your entity still need to be confirmed for your circumstances. Do not infer a retention period from a generic UPI article.
Best Value
- Twin-Ball Design : Hiacry gel pen features a double ball conical tip that reduces writing resistance and provides a stable and smooth writing experience. 0.7mm quick drying black ink ensures no jumping, leakage or seepage.
- Quick-Dry Long Lasting Ink：0.7mm black ink can slide effortlessly, dry immediately, & is not easily dirty. It has a high-capacity reservoir (up to 1300 meters), which is very suitable for left-handed & right-handed users.
- Sleek Design for Journaling & Planning: Engineered with a low center of gravity and precision tip for steady ink flow, these journaling pens excel at note-taking, sketching, planning, and more. They combine stylish pens with top-tier performance.
- Rolling Ball Design：The pocket clip with roll ball design can be easily attached to notebook pockets and binders, in addition, the fidget on the pen clip is also a small toy for your daily thinking to relieve stress.
- Comfortable Non-Slip Grip：The ergonomic pen barrel has a soft rubberized coating for a comfortable, non-slip grip, so you won't get fatigued even after long hours of writing.
Choose a process or accounting tool by control, not by the payment logo
If you use software or a spreadsheet, test the workflow against the controls that matter:
- UTR-level matching and a safe secondary-match rule;
- bank-feed or statement import with duplicate detection;
- settlement-batch handling for one-to-many and many-to-one relationships;
- separate treatment of fees, fee taxes, refunds, reversals and chargebacks;
- an exception queue that keeps pending and failed rows visible;
- GST fields, invoice links and voucher references;
- an exportable audit log and reviewer approval;
- support for multiple bank accounts and PSPs;
- retention, role-based access and an export of the original source files; and
- ability to reproduce the reconciliation after a correction.
A GST-capable accounting system with bank feeds and UPI reconciliation can reduce manual work, but verify the product’s supported banks, GST functions, security controls, retention and current pricing before adopting it. The category is more important than a particular vendor name.
Common failure modes and fixes
“The UPI total is higher than the bank credit.”
Check unsettled transactions, PSP fees and taxes, refunds, reversals and chargebacks. Reconcile gross UPI activity to net settlement rather than comparing the two headline totals.
“The same amount appears several times.”
Use the UTR and payer or payee details. Amount-only matching can attach one customer’s payment to another or duplicate a settlement batch.
“A successful payment is missing from the bank statement.”
Check the settlement date and batch, then review pending or reversed status. Keep the item in UPI clearing until settlement or final reversal is evidenced.
“The bank statement has a credit with no UPI match.”
Inspect the narration, bank reference and settlement scroll, then request the PSP batch detail. Do not post the item to sales solely because it is a credit; classify it as bank-only until its source is established.
“A failed debit has not come back.”
Retain the failed row and the debit evidence, check the final status and contact the bank when the debit has not reversed promptly, following NPCI’s stated direction.
“The reconciliation changes after a correction.”
Do not overwrite the original file. Post a dated adjustment, preserve the prior version, explain the change in the exception log and obtain reviewer approval.
A repeatable month-end checklist
- Freeze the period, accounts, PSPs, opening and closing balances, report date and timezone.
- Save original UPI, bank, settlement, sales, invoice, refund and fee files.
- Normalize dates, signs, currency, references, parties, amounts, status and settlement dates.
- Match exact UTRs, then apply documented secondary keys only where necessary.
- Post gross sales or expenses, clearing movements, fees, tax, refunds, reversals and chargebacks separately.
- Classify and assign every unmatched row.
- Compare counts and gross/net totals by day and settlement batch.
- Bridge opening balance plus receipts minus payments to the bank closing balance.
- Attach invoice, voucher, settlement and approval evidence to each material adjustment.
- Have an independent reviewer sign off and lock the completed reconciliation file.
Checking NPCI’s current circular index is prudent because operating and dispute rules can change. Apply the rule in force for the relevant transaction date and retain the version or reference used in your procedure.
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.
