How to Match UPI Payments With Invoices and Bank Statement
A simple way to match UPI payments with invoices and your bank statement: which reference number to use, a worked example, and part or double payments.
In this article (7 sections)
To match UPI payments with invoices, use the UPI reference number as the link between three records: the invoice, your merchant app or QR report, and your bank statement. Match by reference number first, then by amount and date, and treat anything left over as a part payment, a double payment, a payment still settling, or a payment that never reached you.
This guide sets out a routine any shop, freelancer or small firm can follow in a spreadsheet, with a worked example. It is general information as of October 2026, not accounting advice; your accountant may prefer a different ledger format.
The three records you need
| Record | Where it comes from | Key fields |
|---|---|---|
| Invoice register | Your billing software, GST invoice book or spreadsheet | Invoice number, date, customer, amount including GST |
| UPI collection report | Bank's merchant app, aggregator dashboard or soundbox app | Date and time, amount, payer UPI ID or name, 12-digit reference number, status |
| Bank statement | Net banking (download as Excel or CSV) | Date, narration (usually includes "UPI" and the reference number), credit amount |
If your QR is linked directly to your bank account, each payment usually appears as its own line in the statement. If your QR or soundbox belongs to a payment aggregator, payments are often paid to you as one bulk settlement, and you match individual payments using the aggregator's settlement report instead. Our guide on how to read a bank statement explains common narration formats.
Step-by-step matching routine
Set up once
- Give every invoice a unique number and record the total including GST. Our GST calculator helps split a GST-inclusive amount.
- Ask customers to quote the invoice number in the UPI remarks, or use a dynamic QR that carries the amount and an invoice reference where your billing software or provider supports it.
- Use a separate current account and QR for the business. Personal transfers on the same QR make matching slow; see how to separate personal and business finances.
Do daily or weekly
- Download the UPI report and the bank statement for the same period. Keep only successful payments in the UPI report.
- Match UPI report to bank statement by reference number, or for aggregator QRs, match the aggregator's settlement report total to the bulk credit.
- Match each UPI payment to an invoice. Use the invoice number in remarks first, then customer name or UPI ID plus amount.
- Mark each invoice as paid, part paid or unpaid, and note the reference number against it.
- List exceptions: payments without an invoice, invoices without a payment, amount differences and duplicates.
- Clear exceptions by messaging the customer or raising a ticket with the provider. Do not leave them for month end.
Worked example: one week's matching
A small trader raises five invoices (amounts include 18% GST; for example ₹1,000 + ₹180 = ₹1,180):
| Invoice | Amount | UPI payment found | Reference | Status |
|---|---|---|---|---|
| INV-101 | ₹1,180 | ₹1,180 | 4210...1187 | Paid |
| INV-102 | ₹2,360 | ₹2,360 | 4210...5521 | Paid |
| INV-103 | ₹590 | ₹590 and ₹590 again | 4211...0034, 4211...0039 | Paid twice |
| INV-104 | ₹4,720 | ₹4,000 | 4212...7716 | Part paid, ₹720 due |
| INV-105 | ₹1,770 | None | None | Unpaid |
Totals: invoices = ₹1,180 + ₹2,360 + ₹590 + ₹4,720 + ₹1,770 = ₹10,620. UPI received = ₹1,180 + ₹2,360 + ₹590 + ₹590 + ₹4,000 = ₹8,720. The ₹1,900 gap is fully explained: ₹1,770 unpaid (INV-105) + ₹720 balance (INV-104) − ₹590 extra (double payment on INV-103) = ₹1,900.
Actions: send reminders for ₹1,770 and ₹720, and either refund ₹590 to the customer who paid twice or, with their written consent, adjust it against their next invoice. The reference numbers above are shortened for illustration; always record the full 12 digits.
How to handle common mismatches
| Mismatch | Likely reason | What to do |
|---|---|---|
| Payment in UPI report, not in bank | Aggregator settlement pending, or payment still processing | Check the settlement report and date; raise a ticket if overdue under your agreement |
| Payment in bank, no invoice | Advance, customer paid wrong invoice, or a personal transfer | Ask the payer; record as advance until linked |
| Amount lower than invoice | Part payment or customer deducted something | Record part payment, confirm the reason in writing |
| Amount higher or duplicate | Double tap, retry after "pending" status | Verify both credits, then refund or adjust with consent |
| Bulk credit lower than payments | Fees, GST, refunds or chargebacks deducted | Match against the settlement report's deduction lines |
| Customer shows a screenshot, no credit | Payment pending, failed, sent to another QR, or a fake screenshot | Check your own app and bank statement; never rely on the screenshot alone |
For failed payments where the customer was debited but you were not credited, RBI's turnaround-time framework requires auto-reversal to the customer within T+5 days, with ₹100 per day compensation to the customer if late. If a customer wrongly paid you, they may raise a dispute through their bank; respond promptly with your records. If a customer's money was debited but never reached you, point them to UPI payment failed but money debited.
A simple spreadsheet layout
Use one sheet per month with these columns: Invoice no., Invoice date, Customer, Invoice amount, Amount received, UPI reference, Payment date, Settlement date, Bank credit matched (Y/N), Balance, Remarks. A filter on "Balance not zero" or "Bank credit matched = N" gives your follow-up list in seconds. Many billing and accounting apps can import bank statements and suggest matches automatically, but review the suggestions before accepting them.
At month end, add three checks:
- Total of matched receipts in your sheet should equal UPI credits in the bank statement (or aggregator settlements plus their deductions).
- Outstanding balances should agree with what you believe customers owe; chase anything older than your normal credit period.
- Advances and unlinked receipts should be close to zero. Large unexplained credits can create questions at GST or income-tax time, so link or explain them while memories are fresh.
Safety while chasing payments
- Verify credits only in your own bank or merchant app. Screenshots and SMS forwarded by customers can be edited.
- Never share OTP, UPI PIN or merchant login with anyone claiming to be "UPI support" or "settlement team".
- Find support numbers only in the official app or website of your bank or provider, not from search ads or social media.
- Refund only to the original payer and only after confirming the duplicate credit in your bank statement.
Key takeaways
- The 12-digit UPI reference number links the invoice, the UPI report and the bank statement.
- Reconcile at least weekly; the gap between invoices and receipts should be fully explained by unpaid, part-paid and extra payments.
- Aggregator QRs settle in bulk, so match their settlement report, not individual bank lines.
- Never accept a customer's screenshot as proof of payment.
- Keep a short written trail for every part payment, refund or adjustment.
Related guides: 10 Monthly Financial Numbers a Small Business Must Track, Merchant Refused Refund After UPI Payment? What to Do.
Frequently asked questions
Which number should I use to match a UPI payment?
Use the 12-digit UPI reference number (also called UTR or RRN) shown on the customer's payment screen, in your merchant app and in the bank statement narration. Amount and time help, but two payments of the same amount on the same day can only be told apart by the reference number.
How often should a small business reconcile UPI payments?
Daily for busy counters and weekly at minimum for most small businesses. Small gaps are easy to trace within a few days; after a month the customer, the screenshots and the provider's logs are much harder to get.
What if a customer pays less than the invoice amount?
Record it as a part payment against that invoice and show the balance as outstanding. Send the customer a short message with the invoice number, amount received, reference number and balance due.
What should I do if a customer paid the same invoice twice?
Confirm both credits in your bank statement first, then refund the extra payment to the same UPI ID or account, or adjust it against a future invoice with the customer's written consent. Keep the refund reference with the invoice.
Can I put the invoice number in the UPI payment?
Yes. Ask customers to type the invoice number in the UPI remarks or note field, or use a dynamic QR from your billing software or provider that carries the invoice amount and reference. Remarks are not always shown in bank statements, so keep the merchant app report too.
This article is for general education and is not personalised financial, tax or legal advice. Rates and rules are as of 27 Oct 2026; confirm current terms with your lender, AMC or a qualified adviser.
