UPI Reconciliation for Indian Businesses: Step-by-Step Guide 2026

UPI has become the default payment rail for Indian businesses, processing over 18 billion transactions monthly. Yet for CA firms managing client accounts, reconciling UPI receipts remains a manual, time-consuming task — especially when clients use multiple payment gateways alongside direct VPA payments.

This guide walks through a five-step UPI reconciliation methodology that keeps your books accurate and GST-compliant in 2026.

Understanding UPI Settlement Cycles

UPI transactions do not settle in real time to your bank account when you use a payment aggregator. Gateways such as Razorpay, PhonePe Business, Cashfree, and PayU batch daily collections and release net settlements — gross receipts minus platform fees — to your current account on a T+1 or T+2 basis.

Typical settlement timelines:

• Razorpay: T+1 working days
• PhonePe Business: T+1 or T+2
• Cashfree Payments: T+1
• Direct UPI VPA (e.g., yourfirm@okaxis): Real-time, no aggregator lag

This creates a systematic timing difference. A ₹50,000 collection on a Monday may appear as a ₹49,450 credit on Wednesday — ₹550 less due to gateway fees. Booking ₹50,000 when the customer pays without matching the actual bank credit leaves a growing pile of open items that compounds across hundreds of transactions each month.

Step-by-Step UPI Reconciliation Process

Step 1: Download Settlement and Transaction Reports

At the start of each month-end close, log into every payment gateway portal your client uses. Download two reports for the reconciliation period:

1. 1Settlement report — shows UTR number, settlement date, gross collection, fee deducted, and net credit
2. 2Transaction MIS report — shows individual transaction IDs, customer VPA or order reference, amounts, and timestamps

Export both as CSV or Excel files and consolidate them into a master reconciliation workbook, with one tab per gateway.

Step 2: Match Bank Credits to Gateway Settlements

Pull the bank statement for the same period. For each bank credit:

1. 1Identify the UTR or reference number in the bank statement
2. 2Locate the matching row in the gateway settlement report
3. 3Verify: Bank credit = Gross collection − Gateway fee
4. 4Mark both rows as "Matched"
5. 5Flag any unmatched bank credits for investigation — these may be direct NEFT, IMPS, or VPA payments outside the gateway

Example matching:

Step 3: Link Transactions to Customer Invoices

Each UPI transaction in the MIS report should trace back to a specific customer invoice or sales order. Most gateways allow you to pass an order reference — your invoice number — at the time of generating a payment link, making matching straightforward.

For bulk QR code payments where no reference is captured, rely on the customer-provided UTR and cross-check the amount and date against open AR items.

This step is critical for GST compliance: revenue must be reported in the correct period in GSTR-1, and wrong-period allocation creates mismatches between your books and the buyer counterpart's GSTR-2B data.

Step 4: Book Gateway Fees with Correct GST ITC

Payment gateway fees attract 18% GST (IGST for most aggregators registered outside your state). The ITC is fully claimable against your GST output liability. The accounting entry for each settled batch:

Bank A/c                   Dr.   ₹49,450
Gateway Charges (Expense)  Dr.   ₹   466
IGST Input Credit          Dr.   ₹    84
   To Trade Receivables           ₹50,000

Gateway tax invoices are issued monthly via the billing portal. Set a calendar reminder to download and reconcile these before the GSTR-3B filing date so the ITC appears in the correct return period.

Step 5: Reconcile Refunds and Chargebacks

UPI refunds are netted against the next settlement cycle. They appear as negative line items in the settlement report. For each refund:

1. 1Match the refund transaction ID to the original payment
2. 2Confirm a credit note has been raised against the original GST invoice
3. 3Update the AR ledger — reverse the original receipt entry
4. 4Ensure the credit note falls within the GST amendment window (earlier of the next return or September following the financial year)

Disputed chargebacks require supporting documentation and may take 15–30 days to resolve through the gateway's dispute management portal.

Reconciling Direct UPI Payments (VPA and QR Code)

Businesses receiving payments directly to a VPA or static QR code bypass the aggregator entirely. Credits appear instantly in the bank account, which simplifies the timing mismatch but removes the MIS report layer.

Best practices for direct UPI receipts:

• Enable real-time SMS or email alerts on the current account for every credit
• Request the UTR reference from customers via WhatsApp or email immediately after payment
• Log each UTR against the corresponding invoice in a shared tracker
• Reconcile the tracker against the bank statement weekly rather than waiting until month-end
• Maintain a running balance of unmatched credits so the month-end close takes minutes, not hours

Common UPI Reconciliation Pitfalls

How corpus Helps

Manually reconciling UPI data from four gateways across twenty clients is error-prone and expensive in staff time. corpus automates this for CA firms:

• Bank statement auto-import via net banking integration — UPI credits post to the correct client ledger without manual data entry
• Gateway fee ITC module — enter the monthly gateway invoice once; corpus splits the fee and GST component, posts the ITC entry, and surfaces it in the GSTR-3B ITC tab automatically
• AR aging dashboard — outstanding UPI receipts are mapped against open invoices so nothing slips through at month-end
• GSTR-1 vs. collections audit — a one-click report compares declared turnover with bank-verified UPI inflows, catching omissions before you file

CA firms using corpus report a 70% reduction in month-end UPI reconciliation time, eliminating manual spreadsheet work across their entire client portfolio.

Conclusion

UPI reconciliation is not just a bookkeeping exercise — it directly affects GST reporting accuracy, ITC eligibility, and AR hygiene. The five-step process above gives CA firms a repeatable, audit-ready workflow: download gateway reports, match bank credits, link to invoices, book fees with ITC, and clear refunds systematically.

Ready to automate your clients' UPI workflows? Start your free 30-day trial of corpus and experience structured, error-free reconciliation from day one.