Matching Hundreds of UPI Payments a Day to Invoices
Put the invoice number and amount in a dynamic UPI QR or payment link, save customers' UPI IDs, and reconcile daily: match on reference, then on payer ID and amount, apply part payments, and park unknown receipts in suspense with the UPI reference. UPI is not cash for the income-tax cash limits.
A distributor gets 300 UPI payments a day. The bank statement shows the amount, a UPI reference and sometimes a name. The books show invoices. Somebody has to connect the two, and when nobody does, customers get chased for bills they already paid.
Why UPI is hard to reconcile
- ✓No invoice number. Most customers pay the amount and add nothing in the note.
- ✓Different names. The payer is often a family member or an employee, not the customer in your books.
- ✓Part and combined payments. One payment covers three invoices, or three payments cover one invoice.
- ✓Settlement timing. Payments through a payment gateway reach your bank in a batch, often the next working day, net of charges.
- ✓Refunds and failures. Reversed payments can show up days later.
Set up so matching is easy
- Use a dynamic QR or payment link on each invoice, carrying the invoice number and the exact amount. The reference then comes back with the payment.
- Save each customer's UPI IDs in their record the first time they pay, so later payments match by payer ID.
- Use separate collection accounts or virtual accounts for large customers or branches, if your bank offers them.
- Keep one place for the day's collections: your billing software, not a notebook.
A daily routine
| Step | What to do |
|---|---|
| 1. Download | Bank statement and gateway settlement report for the day |
| 2. Auto-match | Match on invoice reference, then on payer UPI ID and exact amount |
| 3. Review | Look at what is left: part payments, combined payments, unknown payers |
| 4. Apply | Apply each payment to invoices, oldest first unless the customer says otherwise |
| 5. Park | Put unknown payments in a suspense account with the UPI reference, and follow up |
| 6. Close | The day's collections in the books should equal the bank credits plus gateway charges |
A worked example
A Bhopal pharmacy distributor receives 320 UPI credits on a Monday:
- ✓210 match automatically on the invoice reference from payment links;
- ✓70 match on saved payer IDs and exact amounts;
- ✓28 are part or combined payments and are applied after a quick call;
- ✓12 are unknown and are parked in suspense with their references.
By Wednesday, 10 of the 12 are identified. The remaining two are refunded to the payers after checking with the bank.
Tax points to remember
- ✓UPI receipts are not cash. The cash receipt limits in the income-tax law do not apply to them.
- ✓Gateway charges carry GST. Collect the gateway's tax invoices so you can claim credit.
- ✓Advances received for services attract GST when received, even by UPI. Advances for goods generally do not.
Frequently asked questions
How long can a payment stay in suspense?
As short as possible. Review it weekly and refund unidentified payments to the source after a reasonable period.
Should we give customers a receipt for UPI payments?
Yes, linked to the invoices paid. It cuts follow-up calls.
What about chargebacks?
Record them against the original payment and the invoice, which becomes unpaid again.
Sources
- ✓Bank reconciliation: a monthly checklist, Sleet Accounting
- ✓Cash transaction limits under income tax law, TaxGuru
- ✓GST on advances for goods and services, GST Council e-flier
This is a practical guide, not legal advice.
Written by
Founder, Airwix Technologies (Sleet)
Vatsal Sutariya is the founder of Airwix Technologies in Ahmedabad, the company that builds Sleet: SleetHR for HR and payroll, and Sleet Accounting for GST billing and books. He writes about GST, invoicing, business tax and choosing software for Indian businesses, and checks each rule against the official notification before it is published.
LinkedIn profile →