Recommended Free Tools
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 collections in two linked but separate passes: first match each sale or invoice to the merchant transaction reported by your acquiring bank or payment provider; then match the provider’s settlement batches to credits in your bank statement. Use transaction references, merchant identifiers, amounts, dates and invoice details, and keep an exception list for missing, delayed, duplicated, reversed or otherwise unexplained items. Finally, reconcile book turnover to GST returns as a separate control—UPI settlement by itself does not prove that sales were recorded or reported correctly.
What a UPI reconciliation actually proves
A UPI payment can appear in several records at different stages. Your sales register shows what you sold and what a customer was expected to pay. The acquiring bank or payment provider records the transaction status and normally produces a transaction or settlement report. Your bank statement shows when a settlement credit was posted to the account. These are related events, not automatically the same row or date.
A complete reconciliation therefore answers three questions:
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
- Does every recorded UPI sale have a corresponding transaction with a successful or otherwise explainable status?
- Has every provider settlement been matched to one or more UPI transactions and to the bank credit where it was supposed to arrive?
- Does the sales turnover in the books agree with the GST returns after considering amendments, credit notes, debit notes and tax classification?
The first two questions establish evidence about collection and cash movement. The third establishes reporting completeness and accuracy. Keep them as distinct checks even when the same spreadsheet contains all three data sets.
#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.
The three records you need
Sales register, invoice list or receipt record
Start with the record of the underlying supply. Depending on the business, this may be an invoice register, point-of-sale export, order ledger or receipt-voucher file. Retain the invoice or receipt number, sale date, customer or order reference where available, amount due, tax details and the payment mode marked by the operator. For registered persons, apply the invoice and receipt-voucher particulars required by the CGST rules that fit the transaction.
UPI transaction and settlement reports
Obtain the merchant transaction list and the settlement report from the acquiring bank or payment aggregator. Report names and columns differ by provider. Useful fields can include the transaction reference, merchant identifier, terminal or virtual-payment address, status, gross amount, adjustments, refund or reversal indicator, transaction timestamp, settlement batch and expected settlement date.
NPCI’s merchant support material directs merchants to their acquiring bank for transaction status and grievance handling. If raw data or a settlement is missing, the acquiring bank or provider is the operational source to query; a customer’s screenshot is not a substitute for the merchant-side record.
Bank statement
Use the statement for the account that receives settlements, not merely a daily cash report. Capture the posted date, value date if shown, narration, reference, credit amount and running balance. Banks may display a transaction date, value date and posting date separately. Decide which field is your accounting cut-off and document that choice before matching.
Set the period and cut-off before importing data
Choose a period such as a calendar month and write down the opening and closing times. A sale made late on the last day can be settled in the next period; a provider can also group transactions into a later batch. Do not move the sale date just to make a bank credit fit. Keep the sale in the period in which the supply occurred and show the later settlement as a timing item.
Record these conventions at the top of the reconciliation file:
- Time zone used by the sales system and provider report.
- Whether the period is based on transaction date, settlement date, bank posting date or value date.
- The bank account and merchant identifier included.
- Whether refunds, reversals and fees appear as separate rows or netted amounts.
- The person responsible for resolving exceptions and the target resolution date.
Provider-specific settlement calendars are not universal. Confirm the actual cut-off and fields in the merchant agreement and current reports rather than assuming a one-day or fixed-cycle settlement.
Quick wins for a faster PC:
Scan for outdated or missing drivers - takes under a minuteDriver Scan →Repair Windows errors before they cause bigger problemsFix Now →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →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
Step-by-step reconciliation workflow
1. Export and preserve the source files
- Export the sales register or invoice list for the selected period.
- Download the merchant UPI transaction report and every settlement report covering the period plus a reasonable following-period window for late credits.
- Download the bank statement in a format that preserves the original narration and reference.
- Save the unaltered files with the export date. Work on copies so an audit trail exists for later corrections.
Do not rely on a screenshot or a manually retyped total when a downloadable report is available. If a report cannot be exported, retain the provider’s response explaining the limitation and preserve the visible fields in a controlled file.
2. Normalize fields without changing the evidence
Standardize date formats, remove accidental spaces from reference IDs and represent amounts in one currency and decimal convention. Keep the original value in a separate column. Never overwrite a provider reference, narration or status while “cleaning” the file.
Create stable columns such as invoice number, sale date, sale amount, payment reference, merchant ID, transaction status, transaction date, settlement batch, settlement date, bank posting date, bank reference, adjustment amount, exception code and resolution note.
3. Match each sale to a UPI transaction
Match using the strongest available identifier first. A transaction reference or provider-generated order reference is better than an amount-only match. Confirm the amount, date window, merchant identifier and invoice or order reference. Mark a row as matched only when the evidence supports the link.
Free tools Windows power users keep installed
One-click scans. No signup required.
If several customers paid the same amount, an amount and date match is not conclusive. Leave the row pending until a reference, order detail or provider record distinguishes it. A successful status proves that the provider recorded a successful payment; it does not prove that the sale was posted in the correct accounting period.
4. Reconcile transaction totals to settlement batches
Group the matched UPI transactions by the settlement batch or settlement date shown by the provider. Compare the gross transaction total with the batch amount and list each supported adjustment separately. Depending on the agreement, refunds, reversals, charge-related adjustments or other items may reduce the amount paid into the bank.
Do not assume that a bank credit equals one transaction. One credit can contain many UPI payments, and one payment can be adjusted or settled separately. Keep a batch-level bridge:
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.
| Bridge item | Amount | Evidence |
|---|---|---|
| Gross successful UPI transactions | Provider transaction report total | Transaction IDs and status |
| Refunds or reversals | Supported negative adjustments | Refund or reversal references |
| Other provider adjustments | Only where documented | Settlement report or agreement |
| Expected settlement credit | Calculated total | Batch identifier |
| Bank credit located | Statement amount | Bank posting and reference |
If a fee or tax deduction is not shown in the provider report, do not invent a netting entry. Ask the provider or bank how the credit was calculated and post only a supported adjustment.
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 matchWindows 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 reinstall5. Match settlement credits to the bank statement
Search the bank statement by settlement reference, narration, amount and posting window. Record whether the credit is exact, grouped with other batches or split across entries. A credit posted after the reporting period remains visible as an outstanding timing item; it should not be silently treated as current-period cash.
Where the bank shows only a generic narration, retain the provider settlement report that explains the composition of the credit. If the provider batch is complete but no bank credit appears, move the batch to the exception list rather than forcing a match to an unrelated deposit.
6. Maintain an exception register
For every unmatched or partially matched row, record the amount, date, transaction reference, invoice or order reference, suspected cause, owner, next action, due date and final evidence. Give each exception one category so that recurring process failures can be measured internally.
Useful categories include missing or late settlement, duplicate transaction, duplicate sale, date or cut-off mismatch, amount mismatch, refund, reversal, failed or pending status, wrong merchant account, non-sales receipt and missing source data.
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Fix the driver behind crashes, sound loss and screen glitches3Repair Windows errors before they cause bigger problems7. Correct the underlying record and retain the trail
Post a correction only after identifying whether the error is in the sales register, provider mapping, clearing account or bank posting. Link the correcting entry to the original invoice or receipt, transaction report row, settlement batch, bank statement line and provider correspondence. Keep the original row and explain the change; do not delete evidence to make totals agree.
8. Perform the GST and books reconciliation
After payment and bank matching, compare turnover in the books with the figures reported in GSTR-1 and GSTR-3B where applicable. Reconcile amendments, debit notes, credit notes, tax rates and relevant HSN or other classifications. ICAI guidance dated 31 March 2025 describes reconciliation among GSTR-1, GSTR-3B and the books, including rate-wise and HSN-wise review for listed turnover classes.
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.
A UPI receipt can be collected correctly while the related invoice is omitted, dated incorrectly, classified under the wrong tax rate or amended later. Conversely, a GST return difference can arise from an amendment or credit note without any missing bank credit. Treat the books-to-returns review as its own workpaper.
How to investigate common exceptions
Successful UPI transaction but no bank credit
Check the provider’s settlement report, the expected settlement date and the bank statement’s posting and value-date ranges. Confirm that the transaction was not refunded, reversed or moved to another merchant account. If it remains unresolved, give the acquiring bank or provider the transaction reference, merchant identifier, amount and date and retain the case number or written response. NPCI support material specifically addresses missing or late settlement and directs members through the relevant support process.
Bank credit with no sales entry
Search the sales register across adjacent dates and branches using the amount, narration and available reference. The credit may belong to a previous day, another location, a reversed refund, a non-sales receipt or a different tender type. Do not book every unexplained credit as current-period sales. Place it in a clearly identified clearing or investigation account only under your accounting policy, and resolve it with source evidence.
Sales entry with no UPI transaction
Check whether the customer paid by card, cash, bank transfer or another provider. Review whether the operator selected UPI incorrectly or whether the provider export omitted a row. Correct the payment-mode coding or obtain the missing report; do not mark the sale as a failed UPI collection solely because it is absent from one file.
Totals differ even though many rows match
Recalculate from the unmatched rows and supported adjustments. Check duplicates, partial refunds, reversals, split settlements, date boundaries and a second merchant identifier. A suspense or rounding entry without a documented cause is not a reconciliation.
GST turnover differs from the books
Build a separate bridge from book turnover to each return. Identify omitted invoices, amendments filed in a later period, debit and credit notes, cancelled documents, tax-rate differences and timing policies. A bank deposit total cannot replace this analysis.
The Tool Desk
Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Identifiers and matching strength
| Evidence | Strength | How to use it |
|---|---|---|
| Provider transaction reference or order reference | Strong | Use as the primary link, then verify amount and merchant. |
| Merchant identifier | Strong for account scope | Ensure the transaction belongs to the intended business or branch. |
| Invoice, order or receipt number | Strong when passed to the provider | Connect the payment to the underlying sale. |
| Exact amount | Moderate | Useful confirmation, but not conclusive when amounts repeat. |
| Transaction or posting date | Moderate | Use with the documented cut-off and time zone. |
| Bank narration alone | Weak to moderate | Support a batch match but seek provider detail for grouped credits. |
Use a confidence status such as matched, matched with timing difference, matched with adjustment, pending evidence or unmatched. This makes review more transparent than a single yes/no column.
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.
Illustrative month-end example
Assume a shop’s sales register contains ten UPI-marked invoices dated 30 June. The provider report shows all ten transactions as successful on 30 June, grouped into a settlement batch dated 1 July. The bank statement shows one credit on 2 July with the same batch reference but a lower amount because a documented refund was included.
- Keep all ten sales in the June sales register because that is when the sales occurred.
- Link each invoice to its transaction reference and mark the batch as settling after period end.
- Bridge the gross ten-transaction total to the July bank credit using the provider’s refund row.
- Show the 1 July or 2 July cash movement as a timing and adjustment item, according to the provider and bank dates.
- Review June books against the GST returns independently; the July credit date does not determine the supply period.
This example is a method, not a universal settlement timetable. Actual dates, grouping and deductions depend on the merchant’s bank and provider.
Records, retention and audit trail
Keep invoices, receipt vouchers, sales registers, provider exports, settlement reports, bank statements, refund or reversal evidence, exception correspondence and correction journals together. CBIC rules require registered persons to maintain specified accounts and supporting documents and describe electronic backups and interlinking of entries with source documents and an audit trail. The CBIC CGST Act page displays a 72-month retention period for specified registered-person accounts; verify the current statutory text, amendments and the period applicable to your taxpayer before adopting that number as a policy.
Use access controls, regular backups and a file naming convention that preserves the period, merchant identifier and export date. Keep a read-only copy of each original report and log who resolved each exception and when.
Choosing reports or accounting tools
No single UPI reconciliation format applies to every bank or provider. When assessing your own reports or an accounting system, compare the following capabilities rather than relying on a product label:
| Capability | Questions to ask |
|---|---|
| Transaction-level detail | Are status, reference, merchant ID, timestamp and order or invoice fields available? |
| Stable identifiers | Can references be exported unchanged and used for repeat matching? |
| Settlement visibility | Does the report show gross batches, grouping, split credits and adjustments? |
| Refund and reversal handling | Are these linked to the original transaction or merely netted? |
| Date conventions | Are transaction, settlement, value and posting dates separately displayed? |
| Invoice linking | Can a payment be traced to an invoice, order or receipt without amount-only matching? |
| Source-document retention | Can original exports, statements and correspondence be retained with the entry? |
| Exception workflow | Can owners, due dates, notes and resolution evidence be recorded? |
Confirm each capability against the actual bank or provider agreement and a recent report. Marketing descriptions do not establish that a field or settlement rule exists for your account.
Controls that prevent recurring mismatches
- Require an invoice, order or receipt reference at the time a UPI payment is collected.
- Restrict each merchant identifier to the intended legal entity and bank account.
- Run a daily status check for pending, failed and successful transactions, then a periodic settlement-to-bank check.
- Separate gross collections, refunds, reversals and documented provider adjustments in the ledger.
- Review aged unmatched items with a named owner instead of carrying them indefinitely.
- Lock the period after review and document any later amendment.
- Compare payment-mode totals with sales totals, not just bank deposits.
When to escalate
Escalate to the acquiring bank or payment provider when a transaction reference is successful but the settlement is absent, a settlement batch cannot be explained, or the provider data conflicts with the bank credit. Include the merchant identifier, transaction or batch references, amounts, dates, statement line and supporting logs. For tax treatment, period corrections or GST return differences, consult a qualified Indian tax professional and verify current CBIC requirements. RBI’s 17 September 2019 discussion paper provides background on payment aggregators and gateways as intermediaries involved in collection and settlement, but it is not a substitute for current directions or your present contractual terms.
Quick Recap
Month-end checklist
- Confirm the period, time zone and date cut-off.
- Archive the sales, provider and bank source files.
- Match every UPI-marked sale to a transaction reference or document why it is pending.
- Reconcile transaction totals to settlement batches, showing refunds, reversals and other supported adjustments.
- Match each batch to the correct bank credit, including later postings.
- Review duplicates, date and amount mismatches, missing settlements and unexplained credits.
- Resolve or assign every exception and retain evidence of the resolution.
- Reconcile books to GSTR-1 and GSTR-3B where applicable, including amendments and credit or debit notes.
- Sign off the workpaper and preserve the audit trail.
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.
