Free tools Windows power users keep installed
One-click scans. No signup required.
Reconcile UPI in three separate links: each sale to a UPI transaction, UPI transactions to the acquiring bank’s settlement report, and settlement batches to credits in the bank statement. Use transaction references, merchant identifiers, amounts and dates, then investigate unmatched items instead of forcing totals to agree.
A successful UPI payment is evidence that a customer’s payment was accepted. It is not automatically the same event as the later settlement credit, nor does it by itself prove that the sale was recorded in the correct accounting or GST period.
As an Amazon Associate I earn from qualifying purchases.
What a UPI reconciliation actually proves
A reliable reconciliation answers three different questions:
- Was the sale recorded? The invoice, receipt or sales-register entry should describe what was supplied, to whom, for how much and when.
- Was the payment accepted? The UPI or acquiring-bank transaction report should show the payment status and available reference details.
- Did the money reach the bank account? The settlement report should explain how transactions were grouped, adjusted or refunded before a credit appeared on the merchant’s bank statement.
Keep these tests separate. A UPI transaction may be successful while its settlement is delayed, grouped with other transactions, reversed or still being investigated. Conversely, a bank credit may relate to a previous day’s sales, a refund reversal, another branch, or a non-sales receipt.
#1 Best Overall
- [Ultra-Lightweight Ear Buds Designed for Small Ears] Each earbud weighs only 3.7g and features a compact, ergonomic in-ear design made especially for small ears. Secure, low-profile, and comfortable for workouts, all-day wear or overnight sleeping.The ultra-slim profile sits flush in your ear with no hard edges poking or rubbing, so you can even sleep on your side without discomfort.
- [Immersive Stereo Sound with TOZO OrigX Technology] TOZO OrigX tuning delivers clear vocals, balanced mids, and natural stereo sound for music, podcasts, and videos.
- [Long Battery Life for Daily Use] Get up to 7 hours of playtime on a single charge, with up to 32 hours total using the charging case—ideal for workdays, commuting, and extended listening sessions.
- [Bluetooth 5.3 & Stable Connection] Bluetooth 5.3 provides fast pairing, stable wireless performance, and reduced dropouts as you move around home or office.
- [Deep Bass with Clear Vocals] High-performance drivers produce punchy bass while keeping vocals clean and detailed for everyday listening.
For a GST-registered business, add a fourth comparison: turnover in the books against GSTR-1 and GSTR-3B. The Institute of Chartered Accountants of India (ICAI) guidance published on 31 March 2025 describes reconciling these returns with the books, including amendments, debit notes and credit notes. A payment-to-bank match cannot establish that turnover, tax classification or return period is correct.
Records to collect before matching
Sales and invoice records
Export the sales register or invoice list for a defined period. Preserve the invoice or receipt number, invoice date, customer or order reference, taxable and total amounts, tax details where applicable, payment mode and any UPI reference captured at checkout. Receipt vouchers and invoices need the particulars required for the transaction and taxpayer type under applicable Central Goods and Services Tax (CGST) rules; use the current CBIC requirements for your situation.
UPI and acquiring-bank records
Obtain both the transaction-level report and the settlement report available from the acquiring bank or payment provider. The transaction report may contain a UPI transaction reference, merchant ID, status, amount, transaction timestamp and merchant order reference. The settlement report may group many transactions into one credit and show adjustments, refunds, reversals, charges or a settlement reference. Names and fields differ by provider, so do not assume that a report from one bank uses the same date or status definitions as another.
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 matchBank statement
Download the statement for the merchant account in a format that preserves the transaction description, value date, posting date, credit amount and bank reference. Note whether the statement displays the date the bank received the settlement instruction, the value date used for interest or availability, or the date the entry was posted. Keep the original statement as well as any spreadsheet used for matching.
Books, GST returns and source documents
Keep the relevant cash or bank ledger, sales ledger, credit and debit notes, refund records, receipt vouchers and GST return workings. Electronic records should remain linked to the source transaction and statement line. CBIC rules describe retaining specified accounts and supporting documents, electronic backups and audit-trail or source-document interlinkages. A CBIC CGST Act page displays a 72-month retention period for specified registered-person accounts; treat that figure as subject to the current legal text, amendments and the taxpayer’s facts rather than as a universal retention rule.
Set the period and cut-off correctly
Choose a start date, end date, bank account and business location before exporting anything. Write down which date each system uses:
| Record | Date that may appear | Why it matters |
|---|---|---|
| Sales register | Invoice, supply or receipt date | Determines when the sale was recorded and may affect GST reporting. |
| UPI transaction report | Payment initiation, completion or provider timestamp | Shows when the customer payment was accepted according to that system. |
| Settlement report | Settlement or batch date | Shows when the provider released one or more transactions for bank credit. |
| Bank statement | Posting date, value date or both | Shows when the merchant’s bank recognized the credit. |
Do not move a sale into a later period merely because its settlement arrived late. Carry the late settlement as an open timing item, and document when the underlying sale and payment occurred. The correct cut-off depends on the business’s accounting and tax obligations and the provider’s report definitions.
Step-by-step UPI reconciliation workflow
1. Freeze the population
Record the period, account number or masked account identifier, branch or store, UPI merchant ID and report-generation date. Prevent later edits to the source exports. If a provider allows a report to be regenerated, retain the original file and note the report parameters.
Rank #2
- 【IP68 Waterproof Multifunctinal Smart Watch】Torjalph fitness activity tracker smart watch is IP68 waterproof technology ,you can wear it when swimming,handwashing,it's rain-proof which means that you perform multiple exercise modes outside without worrying about sweat or rain corroding your fitness smart watch,and this watch equipped with a 230 mAh large capacity battery magnetic charging ,and this sports activity tracker watch can be used 5-7 days If fully charged.
- 【Larger 1.83'' Full Screen Watch & Multi-dial Selection】1.83 inch full HD color touch screen smart watch for men / women provides excellent 240*284 resolution image quality ,This Bluetooth smart watch offers a better touch experience and remarkable immersion and ,more than 200 watch faces for you to choose from App"Da Fit ", you can change the dial style according to your mood to wear keeping the world on your wrist
- 【Accurate Activity Tracker Smart Watch 】sports watch activity tracker uses sweat and dust resistant breathable silicone strap, our Fitness Tracker Smart Watch for Android iOS Phones supports 12 sports modes,walking,running,bicycle,swimming,badminton,basketball,football,rope skipping. This bluetooth calls smart watch for men women is lightweight and stylish, bringing more convenient and relaxing sports experience while also providing more protection.
- 【Your 24 Hour Personal Daily Health Monitor】Fitness watch for women men full touch screen IP67 waterproof bluetooth smartwatch for Android iOS Phones with heart rate blood pressure monitor multifunction Andriod smart watch with steps counter sleep monitor sports fitness watch, monitoring blood oxygen saturation allows you to understand your physical condition in real time to track fitness progress ,to know your health status in time.
- 【More Functions Bluetooth Call Smart Watch】This fitness activity smart watch full screen for iPhone and Android phones includes a bunch of new features including:The bluetooth smart watch can hang up the phone, receive and display WhatsAPP /Text /Facebook /Twitter /Messenger reminder.Support sedentary reminder, alarm clock, stopwatch, timer,weather information,music control, remote camera control compatible with Android 5.0 and above or iOS 9.0 and above smartphones.
2. Export the sales evidence
Start with the sales register or invoice list, not the bank statement. Include all sales in the period, regardless of whether the payment was UPI, card, cash, bank transfer or another tender. This prevents a UPI-only report from being mistaken for total turnover. Preserve the amount due, amount received and any invoice, order or receipt reference.
3. Download UPI transaction and settlement reports
Request the reports from the acquiring bank or payment provider. NPCI’s merchant support material identifies the acquiring bank as the channel for transaction-status checks and grievances. The provider may call the files transaction reports, collection reports, settlement reports or reconciliation files; confirm the definitions and time zone before using them.
4. Match each sale to a payment
Use the strongest identifier first: a UPI transaction reference or provider reference recorded against the invoice. Then compare the merchant ID, amount, transaction date and order or customer reference. Mark a row as matched only when the available evidence supports the link. An amount-only match is not conclusive when several customers paid the same amount.
5. Match transactions to settlement batches
Use the settlement report to map one transaction to one credit or several transactions to a grouped credit. Reconcile the gross transaction total to the settlement calculation, showing any provider-documented refunds, reversals, fees or other adjustments as separate lines. Never hide an unexplained difference inside a rounding or suspense entry.
6. Match settlement batches to bank credits
Search the bank statement using the settlement reference, credit amount, posting date and value date. A single statement credit may represent many UPI transactions, and one transaction may settle later than the report’s transaction date. Record the exact statement line used as evidence.
7. Maintain an exception register
For every unmatched or partially matched item, record the amount, transaction date, settlement date, transaction reference, invoice or order reference, bank statement line if any, exception type, person responsible, next action and resolution evidence. Keep open items visible across periods rather than deleting or overwriting them.
8. Post only supported corrections
Correct the sales ledger, clearing account, refund entry or bank ledger only after identifying the cause. Attach the source invoice or receipt, provider report row, bank statement line and correspondence or case number. If the provider confirms a failed, reversed or duplicate transaction, document that confirmation before changing the books.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Repair Windows errors before they cause bigger problems3Fix the driver behind crashes, sound loss and screen glitches9. Perform the GST and books comparison
After payment and bank matching is complete, compare book turnover with GSTR-1 and GSTR-3B. Check amendments, credit notes, debit notes, tax rates, taxable values and the relevant HSN or other classification required for the business. Resolve a GST difference through the sales and return records; do not treat a matching bank deposit as proof that the return is right.
Rank #3
- [Low Noise High Fidelity] New bee guitar cord with 22AWG oxygen-free-copper center conductors provides enhanced signal transfer, the PVC insulation material and the high-density stranded copper double shield provide noise rejection for quiet operation
- [Ideal for Choice] New bee 1/4 straight and right angle metal connectors, ensures a secure connection in any instrument, pedal, or amp jack. L shape great fro on stage guitar stands
- [Wide Compatible] Suitable for mixer, power amplifier, microphone, effector, decoder, equalizer, electoronic organ, electric guitar, electric bass and other electronic equipments. Widely used in the installation of smart home, karaoke speaker, professional stage audio, etc
- [Easy Disassemble] Making incidental repairs quick and easy! Very nice, flexible cable
- [Dont Hesite to Order] 24 hours customer services and professional technology team are standing by
How to decide whether a match is strong enough
Apply a consistent hierarchy so that two people do not reach different conclusions from the same data.
| Evidence pattern | Suggested treatment |
|---|---|
| Unique transaction reference linked to an invoice, with matching amount and merchant ID | High-confidence match; retain the linked references. |
| Reference is absent, but order reference, amount, date and customer details agree uniquely | Documented probable match; record why no reference was available. |
| Only amount and approximate date agree | Unresolved until another identifier or provider evidence is found. |
| One settlement credit equals several transactions | Use the settlement report’s constituent rows; do not create a one-to-one assumption. |
| Several sales have the same amount and date | Do not allocate by amount alone; obtain a reference, order detail or provider confirmation. |
Keep the original identifiers even after importing data into accounting software. A shortened description or a manually typed note is not a substitute for the provider’s reference.
What the acquiring bank and settlement provider do
UPI transaction status and bank settlement are related but distinct records. The acquiring bank or payment provider maintains the merchant-side transaction and settlement information and is the practical first point of contact for a missing status, late credit or disputed transaction. NPCI support material directs merchants to their acquiring banks for status checks and grievances and asks for transaction details or logs when investigating missing or late settlement data.
Recommended Free Tools
The Reserve Bank of India’s discussion paper dated 17 September 2019 describes payment aggregators and gateways as intermediaries involved in online payment collection and settlement. It also discusses arrangements that allocate responsibilities for settlement, reconciliation, refunds and disputes. That paper is background, not a promise of one current settlement timetable or report format. Use the merchant’s present bank or provider agreement and reports for operational details.
Exception playbook
UPI shows successful, but no bank credit appears
Check whether the transaction is included in a later settlement batch, whether the bank statement search uses posting rather than transaction date, and whether a refund or adjustment changed the expected amount. Compare the provider’s settlement status with the bank’s posting range. If the item remains unresolved, raise it with the acquiring bank or provider using the transaction reference, merchant ID, amount, timestamps and relevant report files.
A bank credit appears with no sales entry
Search prior and later sales periods, other branches and non-sales receipts using the bank reference and amount. The credit could be a late settlement, a refund reversal or another tender’s receipt. Do not automatically book an unidentified credit as current-period UPI sales; place it in a clearly identified investigation account only under the business’s accounting policy and clear it when evidence is obtained.
A sale exists, but no UPI transaction is found
Check the invoice’s recorded payment mode and search the card, cash, bank-transfer or other tender reports. Then verify that the correct merchant ID, date range and branch were exported. The problem may be a different payment method, a data omission or an incorrectly marked sale.
Duplicate transactions or duplicate sales
Compare transaction references, invoice numbers, order IDs, timestamps and amounts. A duplicate report row is not necessarily a duplicate payment; some files show an original row and a later status update. Reverse or remove a duplicate only after distinguishing a reporting duplicate from a genuine second payment and preserving the evidence.
Rank #4
- Digital Family Calendar: BSIMB digital calendar wall touch screen puts an end to your chaotic life. Designed for busy families, the digital calendar keeps you organised and in step with your family. Assign different colours and tasks to each family member to make family scheduling easier and more intuitive.
- Easy Setup and Auto-Sync: Plug in, connect to WLAN and auto-syn your electric calendar in minutes. Digital wall calendar compatible with Google calendar, iCloud calendar, Outlook calendar, Cozi calendar and Yahoo calendar. Add events directly on the device or through the ecalendar app. Electronic calendar stays current whether you're at work or traveling—no manual updates needed.
- All-In-One Home Assistant: Smart calendar builds habits and encourage independence with personalised chores. Display daily meal plan to reduce the daily ‘What's for dinner?’ stress. To-do lists keep track of everything you want. Turning chores into valuable achievements with stars and rewards, making life easier and more enjoyable.
- Manage Anytime Anywhere: BSIMB electronic calendar for family stay connected with the powerful ecalendar app. Access and manage your digital wall calendar anytime, anywhere with free features like stars & rewards, photo screensaver, chore charts, meals plans, to-do lists etc. Electronic planner paid features like Magic Import tailor advanced tools for users with special needs.
- Stay in Touch with Loved Ones: Share photos or videos from your phone to electronic wall calendar with app, instantly update your life moment, and keep in touch with your family, especially those who are far away; you can also surprise your smart calendar digital wall by sending him a wish card; it's also great for keeping tech-illiterate elders in touch with the youngsters.
Date or amount mismatch
Check time zone, date cut-off, value date versus posting date, partial payments, split tenders, rounding and provider adjustments. Reconcile the gross transaction amount to the settlement amount before treating a net bank credit as an incorrect sale value.
Refund, reversal or chargeback
Link the refund or reversal to the original transaction and invoice. Record the provider status, refund date, amount and bank movement separately from the original sale. RBI material places responsibility for arrangements covering refunds and disputes among the relevant intermediaries; follow the current provider process and the business’s tax treatment.
Pending or failed payment
Do not mark a pending attempt as collected merely because a customer shows a debit notification. Use the final provider status and settlement evidence. If the sale was cancelled or paid by another method, correct the payment mode and retain the failed attempt for audit history.
The Tool Desk
Outbyte PC Repair FREEClear out junk files and repair common Windows errorsFree Scan →Outbyte Driver Updater FREEScan for outdated or missing drivers - takes under a minuteDriver Scan →GST turnover differs from the books
Reconcile the books to GSTR-1 and GSTR-3B as a separate workpaper. Trace differences to omitted invoices, amendments, credit or debit notes, tax-rate errors, timing and classification. A bank statement cannot identify which GST document should be amended.
Total UPI receipts differ from total sales
Break the difference into identified items: non-UPI tenders, late settlements, refunds, reversals, duplicates, pending transactions, wrong-period entries and unidentified credits. The reconciliation is complete only when the remaining balance is supported by a documented timing item or an open investigation with an owner.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.A practical reconciliation worksheet
A spreadsheet or accounting workpaper should preserve both source values and the conclusion reached. These columns are a useful minimum; adapt them to the fields your bank and provider actually supply:
| Column group | Examples |
|---|---|
| Sale identity | Invoice or receipt number, invoice date, order number, branch, customer reference. |
| Sale amount | Gross amount, taxable value, tax amount, amount received, currency. |
| UPI evidence | UPI transaction reference, merchant ID, provider status, transaction timestamp. |
| Settlement evidence | Settlement ID, batch date, gross amount, adjustments, net amount, refund or reversal reference. |
| Bank evidence | Statement date, value date, posting date, credit amount, bank narration or reference. |
| Control fields | Match status, exception type, owner, next action, resolution date, evidence location. |
Use controlled statuses such as Matched, Timing difference, Provider investigation, Refund or reversal, Duplicate review and Unidentified credit. Do not overwrite the original amount or date when correcting a row; add an adjustment line and explain the reason.
Choosing reports or accounting tools
No universal UPI reconciliation product or report schema is established for every merchant. When comparing your bank, provider exports or accounting tools, assess these practical capabilities:
- Transaction-level detail rather than totals only.
- Stable reference IDs that survive export and import.
- Clear distinction between gross transactions, grouped settlements and net credits.
- Separate visibility for refunds, reversals, disputes and fees.
- Documented transaction, settlement, value and posting-date conventions.
- Links from a payment to an invoice, order or receipt.
- Export of the original files, supporting documents and audit trail.
- Permission controls and a history of who changed a match or adjustment.
Confirm each capability against the merchant’s actual agreement and current reports. A tool that imports only bank credits cannot replace a transaction-level UPI report, and an import that matches by amount alone can create false positives.
Recommended control schedule
Daily or next business day
- Review failed, pending and reversed payments.
- Capture invoice or order references for successful UPI receipts.
- Flag unusually large or unidentified credits for review.
Weekly
- Match transaction reports to sales and clear routine exceptions.
- Check that settlement batches expected during the week appear in the bank account.
- Escalate missing or late settlement cases before report retention windows make investigation harder.
Monthly and before GST filing
- Reconcile all open settlement items and document explanations.
- Compare book turnover with GSTR-1 and GSTR-3B, including amendments and credit or debit notes.
- Archive source exports, statements, invoices, vouchers and provider correspondence in a retrievable location.
These are control recommendations, not a universal NPCI schedule. Increase the frequency when transaction volume, multiple branches or frequent refunds make a monthly review too slow.
Evidence, access and retention
UPI references, customer names, phone numbers and bank details can be sensitive. Restrict editing and downloading to staff who need it, mask account numbers in working files, and retain an unaltered source export. Keep a readable link between the ledger entry, invoice or receipt, UPI row, settlement row and bank statement line. If a provider case is opened, save the case number, submitted evidence and final response with the affected rows.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
For registered persons, apply the current CBIC record-keeping and electronic-backup requirements to the business’s facts. The 72-month figure displayed on a CBIC CGST Act page should be checked against the current law and amendments before being used as a retention policy.
When to ask for help
Contact the acquiring bank or payment provider for transaction status, settlement, refund, reversal and dispute questions. Supply precise references rather than a screenshot of an unexplained total. If the issue affects return amendments, tax classification, books or a material unresolved balance, consult a qualified Indian tax professional. Tax obligations vary with registration status, type of supply, place of supply and other facts, and neither NPCI operating procedures nor the RBI’s 2019 background paper substitutes for current directions.
Illustrative example
Assume a shop’s sales register contains three UPI sales of ₹500, ₹750 and ₹500 on 10 October. The UPI report contains three successful rows with unique references. The settlement report groups them into one gross ₹1,750 batch, shows a documented ₹10 adjustment and reports a net ₹1,740 settlement dated 11 October. The bank statement shows a ₹1,740 credit posted on 12 October.
The correct workpaper links each invoice to its UPI reference, links all three references to the settlement batch, records the ₹10 adjustment separately and links the batch to the 12 October statement line. The sales remain dated 10 October; the 11 October settlement date and 12 October posting date are timing evidence, not reasons to move the sales into a later period. If the ₹1,740 credit were present without the settlement report, it would remain an unidentified credit until the provider supplied enough evidence to identify its constituent transactions.
Quick wins for a faster PC:
Clear out junk files and repair common Windows errorsFree Scan →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →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.
