UPI Merchant Payment Tracking & Reconciliation Guide

Updated 14 November 2026 · Standard formula, shown below

This guide walks you through tracking UPI merchant payments and reconciling them against your records, whether you run a small business or manage finances for a larger operation. You’ll learn how to capture transaction data, match it with your sales records, and resolve discrepancies efficiently. Before you start, ensure you have access to your UPI settlement reports and your internal sales or accounting records.

What You’ll Need

Access to your UPI merchant account (e.g., the dashboard or app provided by your payment gateway or bank).
Your internal sales records: invoices, receipts, or POS data for the same period.
A spreadsheet application (Excel, Google Sheets, or similar) for organizing and comparing data.
Your bank statement showing the settlements deposited into your bank account.
A basic understanding of your business’s sales tax and refund policies (for handling discrepancies).

Step-by-Step

Collect UPI transaction data: Log into your UPI merchant dashboard and export the transaction report for the period you want to reconcile. Most platforms allow you to filter by date, status (successful, failed, refunded), and payment method. Download the file (usually CSV or Excel) to your computer.
Collect your internal sales data: Pull your sales records for the same date range. This could be from your POS system, invoicing software, or a manually maintained ledger. Ensure the data includes transaction IDs, amounts, and dates.
Prepare a reconciliation spreadsheet: Create a new spreadsheet with columns for: Transaction ID, Date, UPI Amount, Internal Amount, Status, and Notes. This will be your master comparison sheet.
Import and standardize data: Copy both the UPI transaction report and your internal sales data into separate sheets within the same spreadsheet. Standardize the date formats (e.g., YYYY-MM-DD) and ensure amounts are in the same currency and format (e.g., no commas, two decimal places).
Match transactions: Use a VLOOKUP or INDEX-MATCH function to match transactions by a unique identifier, usually the UPI transaction reference number (also called UTR or RRN). If your internal records don’t have the UPI reference, match by date and amount. Flag any rows that don’t match.
Categorize discrepancies: For each unmatched transaction, determine the reason:

Missing from UPI report: Payment not captured (e.g., customer didn’t pay, payment failed).
Missing from internal records: Payment received but not recorded in your sales system (e.g., manual error, missed entry).
Amount mismatch: The UPI amount differs from your internal amount (e.g., due to fees, discounts, or partial payments).
Status mismatch: A transaction marked as successful in one system but failed or refunded in the other.

Reconcile with bank settlements: Compare the total of successful UPI transactions with the settlement amount credited to your bank account. The settlement amount should equal the sum of successful transactions minus any gateway fees or TDS (as per your agreement). If there’s a difference, check for pending settlements or reversals.
Investigate and resolve: For each discrepancy, take action:

If a payment is missing from UPI but present internally, contact the customer to verify payment status.
If a payment is present in UPI but missing internally, add it to your sales records.
For amount mismatches, check if any discounts or fees were applied. Adjust your internal records accordingly.
For failed/refunded transactions, ensure your internal records reflect the final status, and if a refund was issued, verify it appears in both systems.

Document and adjust: Make the necessary corrections in your internal records. Keep a log of all discrepancies and the actions taken for audit purposes. If you use accounting software, make journal entries to correct any revenue or fee misstatements.
Finalize and archive: Once all discrepancies are resolved, save the reconciled spreadsheet and the original export files. This becomes your official reconciliation record for the period.

Common Mistakes

Matching by amount only: Two transactions for the same amount on the same day can be easily mismatched. Always use the UPI reference number if available.
Ignoring timezone differences: UPI reports may show transaction times in IST (Indian Standard Time), while your POS may use local time. This can cause date mismatches for transactions near midnight.
Forgetting about fees and TDS: The settlement amount is not equal to the total of successful transactions. Gateway fees, GST on fees, and TDS are deducted before settlement. Failing to account for these will cause an apparent shortfall.
Not reconciling failed transactions: A failed transaction in UPI may still have a corresponding record in your internal system if the payment was attempted. Ensure you mark these as failed to avoid counting them as revenue.
Overlooking refunds: Refunds reduce your net settlement. If you issue a refund, it must be recorded in both your internal system and the UPI report to reconcile correctly.

Tips

Reconcile regularly: Do this daily or weekly, not monthly. It’s much easier to resolve a few discrepancies than a pile of them.
Use a dedicated tool: If you handle a high volume of transactions, consider using accounting software that integrates with your payment gateway for automatic reconciliation.
Keep a master reference list: Maintain a list of all UPI transaction IDs and their corresponding internal invoice numbers. This speeds up future matching.
Set up alerts: Enable notifications in your UPI dashboard for failed payments and refunds, so you can address them promptly.
Understand your settlement cycle: Know when settlements are credited (e.g., T+1 or T+2 days). This helps you match bank deposits accurately.

Troubleshooting

What if the settlement amount doesn’t match the sum of successful transactions?

Check if any transactions are still in ‘pending’ status. They may settle in the next cycle.
Verify that the settlement date range aligns with the transaction dates (some gateways settle transactions on a T+1 basis).
Review your gateway’s fee structure. Fees may be deducted on a per-transaction basis or as a batch, and they can vary by payment method (UPI vs. card).

What if a transaction is in my UPI report but not in my internal records?

Double-check your internal system for the customer’s name or order ID. It may have been manually entered incorrectly.
If you use a POS, check if the payment was linked to a different order or was a duplicate attempt.

What if a transaction is in my internal records but not in UPI?

Ask the customer for the UPI reference number from their payment app. Search for it in your UPI dashboard.
If the payment was made via a third-party app, it may take longer to appear in your report. Wait 24-48 hours before assuming it’s missing.

What if I find a mismatch in amounts?

Check if a discount or cashback was applied at the time of payment. The UPI amount is what the customer actually paid, not the original invoice amount.
Look for partial payments (e.g., customer paid part via UPI and part via cash).

Frequently Asked Questions

Q: How often should I reconcile UPI payments?
A: Ideally daily or at least weekly. Regular reconciliation prevents small errors from snowballing and makes it easier to spot fraud or system glitches.

Q: What is a UTR number and why is it important?
A: UTR (Unique Transaction Reference) is a unique alphanumeric code assigned to each UPI transaction. It’s the most reliable way to match payments between your UPI report and bank statement.

Q: Do I need to reconcile failed transactions?
A: Yes. Failed transactions should be marked as such in your internal records to avoid overstating revenue. They also help you track customer behavior and potential fraud.

Q: Can I automate UPI reconciliation?
A: Yes, many accounting tools (like Zoho Books, QuickBooks, or Tally) offer integration with payment gateways to automatically import and match transactions. This is highly recommended for high-volume businesses.

Q: What should I do if I can’t find a transaction in my UPI report?
A: First, verify with the customer that the payment was successful. Ask for their payment screenshot. Then, contact your payment gateway’s support with the UTR number and your merchant ID to trace the transaction.

Q: How do I handle refunds during reconciliation?
A: Refunds should be recorded as a reduction in revenue. In your UPI report, they appear as ‘refunded’ status. In your internal system, create a credit note. The settlement will show the refund as a deduction.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.