Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →
Accountants search the bank statement for an order ID or payment ID and find nothing, because each reference number belongs to a different system.
Order ID links the shop to the gateway, payment ID identifies the payment inside the gateway, RRN identifies it on the card or UPI network, the settlement UTR identifies the bank credit, and ARN identifies a card refund.
Keep order ID, payment ID and RRN on the order record; keep settlement ID and UTR on the settlement record; keep refund ID and ARN on the refund record.
Every bank credit is traced to its settlement by UTR, every settlement to its payments by payment ID, and every payment to its order by order ID.
Each reference number answers a different question. The order ID and payment ID are labels created by your shop and your payment gateway. The RRN and UTR are bank-network references that follow the money. The ARN traces a card refund back to the customer. To match a sale you use the first two; to find money in your bank you use the UTR; to chase a refund you use the ARN.
Which reference is which?
| Reference | Who creates it | Where you see it | What it is used for |
|---|---|---|---|
| Order ID | Your website, app or billing system | Your order list, invoice | Matching a sale to a payment |
| Payment ID (transaction ID) | The payment gateway | Gateway dashboard, settlement report | Finding a payment inside the gateway |
| RRN (retrieval reference number) | The card or UPI network | Customer’s UPI app or card statement, gateway report | Identifying one payment between banks |
| UTR (unique transaction reference) | The bank sending the transfer | Your bank statement narration, settlement report | Tracing the settlement credit to your bank |
| ARN (acquirer reference number) | The merchant’s acquiring bank | Gateway refund details | Tracing a card refund to the customer’s bank |
The “acquiring bank” is the bank that processes card payments on the merchant’s side. The customer’s bank is called the “issuing bank”.
Which number do I search for in my bank statement to find a gateway settlement?
The settlement UTR. A gateway does not send you one bank transfer per customer payment. It adds up a batch of payments, subtracts fees and refunds, and sends one transfer for the net amount. That transfer has its own UTR, which the settlement report lists against the settlement ID. Search your bank statement for that UTR and you will usually find the credit, often with the gateway’s name in the narration.
Order IDs and payment IDs almost never appear in a bank statement. Searching for them is the most common reason beginners think a settlement is missing.
Is the UPI reference number the same as the UTR in my bank narration?
Not quite, and the naming causes confusion. When a customer pays by UPI, their app shows a 12-digit reference for that one payment. NPCI calls this the RRN; many apps and banks label it the UPI reference number, and some call it the UTR.
That number identifies the customer’s payment. If the customer paid you through a gateway, the money reaches you later inside the gateway’s settlement, which carries a different UTR. If the customer paid your business UPI ID or QR directly, the RRN itself usually appears in your bank narration.
So: customer says “my UTR is 4321…”, look it up in the gateway dashboard (or your direct UPI credits), not in the settlement narration.
Worked example: one ₹3,499 order, end to end
- On 6 October a customer places order ORD-10452 for ₹3,499 on your website.
- The gateway creates payment ID pay_8Hk2… for that order.
- The customer pays by UPI. Their app shows UPI reference 427915830612 (12 digits).
- On 7 October the gateway settles 214 payments worth ₹4,12,850 gross. After ₹7,140 of fees and GST, it sends ₹4,05,710 to your bank with settlement UTR UTIBR52026100700381.
- Your bank statement shows a credit of ₹4,05,710 with that UTR in the narration.
To prove the ₹3,499 reached you: bank credit (UTR) to settlement ID, settlement ID to payment ID pay_8Hk2…, payment ID to order ORD-10452. Check of the batch: ₹4,12,850 minus ₹7,140 is ₹4,05,710.
Inside that batch, this one order’s share works the same way. At an illustrative 1.5% fee, the fee on ₹3,499 is ₹52.49, and GST at 18% on that fee is ₹9.45. So this order contributes ₹3,437.06 to the ₹4,05,710 credit. Check: ₹3,499 minus ₹52.49 minus ₹9.45 is ₹3,437.06.
The reference values above are illustrative.
Using these keys every month
Once you know which key belongs to which record, matching a month of credits becomes a chain: bank to settlement by UTR, settlement to payments by payment ID, payments to orders by order ID. Keep all three on your records and most mismatches are found in minutes.
What to read next
- Next in this series: UPI settlement reconciliation
- What is a UTR number?, with the formats used by NEFT, RTGS and IMPS
- What is an ARN number and how do you trace a refund?
- Payment gateway reconciliation
Payment-gateway settlement reconciliation is on the TransactIG roadmap.
Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →