Pick the UPI Ref No, Amount, and Payee from a PhonePe Screenshot
Manually typing the 12-digit UPI Ref No, amount, and payee name from a PhonePe confirmation screen into a spreadsheet takes about 90 seconds per screenshot — this picks all three fields in under 10 seconds.
5-10s per screenshot · Up to 99% accuracy on printed text
Four Fields, One PhonePe Screen
A PhonePe confirmation screen packs payment data, promotional banners, and app UI into one view. With Custom Column Extraction, the AI reads the label beside each value — so the Rs575 that left your wallet and the Rs12 cashback offer stay separate.
The Rs figure uses Indian lakh/crore comma placement (Rs1,00,000 = 1 lakh). The AI reads the numeric value, not commas.
The 12-digit Retrieval Reference Number is the universal reconciliation key for the NPCI network — what your bank needs for disputes. PhonePe also shows an internal Transaction ID; the AI distinguishes them by context.
Appears as "Paid to" followed by a name — could be an individual's name, a UPI ID (name@ybl), or a store name.
Transaction result — "Success", "Pending", or "Failed". Useful for separating confirmed payments from failed attempts.
The 12-Digit Key Sitting Between a Cashback Banner and a UPI ID
PhonePe's confirmation screen is designed for a person to glance at, not for a machine to parse. The UPI Ref No — the one field that matters for reconciliation — sits sandwiched between promotional rewards and the payee's virtual payment address.
Two IDs, One Screen — Which One Goes to the Bank?
PhonePe shows both an internal Transaction ID (alphanumeric, 20+ characters) and the UPI Ref No / RRN (12-digit numeric). Users on the UiPath forum report that their OCR pipeline grabs the wrong ID — and the bank rejects disputes using the internal ID instead of the NPCI-level RRN.
Promotional Content Wrapped Around Payment Data
PhonePe's confirmation screen often includes a "Cashback and Rewards" section showing "You earned Rs12!" or "Get 5% off on your next recharge." Dump-style OCR reads every pixel and outputs the Rs12 cashback as if it were a transaction amount — both are just Rs figures on a purple background.
Rs1,00,000 — Is That 10,000 or 1 Lakh?
India's numbering system places commas differently — Rs1,00,000 means one lakh (100,000), not ten thousand. Standard OCR passes the comma placement through as-is, so Excel interprets Rs1,00,000 as text rather than a number.
Label-Aware Selection Picks the Right Reference Number
Define UPI Ref No and Transaction ID as separate columns. The AI reads the label text next to each identifier — "UPI Ref No" or "RRN" for the 12-digit bank-level code, "Transaction ID" for the PhonePe internal number. Each value lands in the correct column, so your dispute-ready reference is always the right one.
Semantic Boundaries Keep Cashback Out of Your Spreadsheet
The AI understands that "Cashback and Rewards" is a separate visual zone from the transaction detail card. Name your column Amount and the AI returns only the value beside the "Paid" or "Rs" label — the Rs12 cashback offer under the rewards heading stays out of the Amount column entirely.
Indian Numbering Parsed as Numeric Values
The AI reads the actual numeric value of the amount, not the string with commas. Rs1,00,000 is interpreted as 100,000 and exported as a clean number to Excel — no manual fix needed.
From a PhonePe Confirmation Screen to a Clean Spreadsheet Row
If you're logging PhonePe payments for expense tracking, reconciliation, or shared accounting — here's what happens when you drop a screenshot into the tool.
Upload the Screenshot
Upload a PhonePe confirmation screen — a native screenshot from the app, or a photo of the screen if you're working from a second device. PhonePe's in-app screenshots are not blocked, so you can capture the full transaction detail card directly. The confirmation screen after a P2P transfer, merchant QR scan, bill payment, or recharge — all processed the same way.
Name the Columns
Define your column headers: Amount, UPI Ref No, Payee, Status. The AI reads the label beside each value — the 12-digit RRN sits next to "UPI Ref No" or "RRN", the amount sits beside the Rs symbol. If you also want to track which PhonePe internal Transaction ID belongs to each row, add a fifth column — the AI distinguishes it from the UPI Ref No by label context. Add a Computed Column — Cashback (Read Promotional Section) — to optionally capture the rewards amount separately from the transaction amount.
Export the Row
The output lands as a single spreadsheet row — amount, 12-digit UPI Ref No, payee name, and status. Export to Excel, CSV, or push directly into Google Sheets via the add-on. One screenshot becomes one row, each field in its correct column, with the Indian numbering parsed correctly for Excel calculations.
When PhonePe Screenshot Extraction Works Best — and When It Doesn't
When It Works Best
Clear transaction confirmation screens. The payment success page shows all four fields in high-contrast machine-rendered text — including the 12-digit UPI Ref No and amount.
Batch cross-platform processing. One column set extracts from PhonePe alongside Google Pay India and Paytm — all rows merge into one spreadsheet with consistent headers.
Reconciliation and expense tracking. The 12-digit UPI Ref No is the single key across the NPCI network — matching screenshots against bank statements becomes a straightforward VLOOKUP on the RRN column.
When to Be Cautious
Screenshots from older PhonePe app versions. PhonePe periodically redesigns its confirmation screen layout — the UPI Ref No label moved from the top to the bottom in a 2024 update. Semantic extraction handles layout changes, but very old screenshots may reduce accuracy.
PhonePe Business app screenshots. The merchant-side app uses a different UI with additional fields like settlement amount and MDR fees — keep personal and business batches separate.
Pending or failed transactions. A pending payment may show a "Processing..." status with provisional amounts. Confirm the Status shows "Success" before relying on the data.
Frequently Asked Questions
Which ID from a PhonePe screenshot should I use for a bank dispute — the UPI Ref No or the Transaction ID?
The UPI Ref No (also called RRN or UTR number) is the 12-digit numeric code that banks and NPCI use to trace a transaction. PhonePe also shows its own internal Transaction ID, which is alphanumeric and longer. When filing a dispute with your bank or contacting customer support, always provide the UPI Ref No — the bank's system cannot look up a PhonePe internal ID. The AI extracts both fields when you define separate columns (UPI Ref No and Transaction ID), so you always have the right one ready.
Can I extract just the amount from a PhonePe screenshot without also capturing the cashback or rewards text?
Yes. The AI reads the label next to each value — the amount sits beside a "Paid" or "Rs" label, while cashback offers sit under a "Cashback and Rewards" heading. Name your column Amount and the AI returns only the transaction figure, ignoring promotional text that appears elsewhere on the same screen. If you want to capture both, define a separate column called Cashback Offered — the AI will read the rewards section as a separate field.
Will it work with a merchant QR payment screenshot vs a P2P transfer?
Yes. Both transaction types show the same core fields — Amount, UPI Ref No, Payee/Merchant name, and Status. A merchant QR payment shows the store name as the payee (e.g. "Sharma General Store"), while a P2P transfer shows the individual's name. The AI reads the payee label the same way regardless of transaction type. For bill payments and recharges, the same four fields are present — the payee becomes the biller or telecom operator name.
The amount on my PhonePe screenshot shows Rs 1,00,000 — will the AI read it correctly as 1 lakh rupees?
Yes. The AI understands Indian numbering notation — Rs 1,00,000 is interpreted as 100,000 (one lakh), not 10,000. The Indian comma system places the first comma after the hundreds (1,00,000) rather than after the thousands (100,000). The AI reads the numeric value of the amount, not the comma positions, so the output preserves the correct number for Excel calculations. No manual correction needed.
Can I batch PhonePe screenshots with Google Pay India and Paytm screenshots in the same export?
Yes. Define one set of column names — Amount, UPI Ref No, Payee, Status — and the AI processes PhonePe, Google Pay India, and Paytm screenshots in a single batch using the same definitions. Each app's confirmation screen looks different, but the underlying UPI fields are the same. See the payment screenshots overview for the full cross-app capability.
Deep dive into PhonePe's UPI Ref No vs Transaction ID distinction: Google Pay India screenshot extraction — the sibling UPI app with the same 12-digit RRN field
Compare with another Indian UPI leader: Paytm screenshot extraction — three payment sources (Wallet, UPI, Card) in one app
Back to payment screenshots overview — see all supported payment apps