The Scenario
You are a customer success manager. Your team logged 120 refund requests in a Google Sheet over the last 60 days — one row per request, with the payment ID in column A and the requested refund amount in column B.
Now you need to know which ones are already in Razorpay as processed refunds and which ones have not been touched yet. Finance wants the gap report by end of day Friday.
The slow version:
- Pull the Razorpay refund list from the dashboard (CSV export, limited to 500 rows, date-filtered)
- Open the CSV in Sheets
- VLOOKUP payment IDs from the refund export against your logged requests sheet
- Figure out which payment IDs appear in your sheet but not in the refund export — that's the missing ones
- Realize the refund export uses
payment_idas a column and your sheet uses "Payment ID" in the header — fix the VLOOKUP - Do the same for last month's export because the 60-day window spanned two CSV files
- Miss two refunds because one payment ID had a typo in your logged sheet.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your spreadsheet that can pull all Razorpay refunds and run the cross-reference against your logged requests, without you touching a CSV.
Open the SheetXAI sidebar and type:
Fetch all Razorpay refunds from the last 60 days. Import refund ID, payment ID, amount in rupees, status, and creation date into a new tab called "Razorpay Refunds." Then compare the payment IDs in the "Razorpay Refunds" tab against column A of this sheet. For any payment ID in column A that does not appear in the "Razorpay Refunds" tab, write "Missing" in column C of this sheet. For payment IDs that do appear, write "Processed" and the refund status.
SheetXAI pulls the refund data, writes it into a new tab, runs the comparison, and updates column C with the status of each logged request.
What You Get
An updated sheet with the gap report built in:
- "Razorpay Refunds" tab — every refund from the last 60 days, with refund ID, payment ID, amount, status, and date
- Column C of the main sheet — "Processed" with the refund status for matched payment IDs, "Missing" for the ones not in Razorpay
- One source of truth — the logged requests and the Razorpay data are now in the same workbook
Finance gets the gap report from column C. The "Missing" rows are the ones that need follow-up. No VLOOKUP, no two-file comparison.
If you want to see the missing ones sorted to the top, ask SheetXAI to sort the sheet by column C. It reorders the rows immediately.
What If the Data Is Not Quite Ready
Refund tracking sheets have their own edge cases. SheetXAI handles them in the same prompt.
When the payment IDs in your sheet have inconsistent formatting
Some rows have pay_ABC123 with the prefix, some rows just have ABC123. Razorpay stores them with the pay_ prefix.
Before comparing, normalize the payment IDs in column A — if a value does not start with "pay_", add the prefix. Then fetch the Razorpay refunds and run the cross-reference with the normalized IDs.
When you need to see partial refunds separately
Some refunds are full, some are partial. You want to distinguish them in column C.
After fetching the Razorpay refunds, compare against column A. For matched payment IDs where the refund amount equals the original requested amount in column B, write "Fully Refunded." Where the refund amount is less than column B, write "Partially Refunded — [refund amount]." For unmatched rows, write "Missing."
When a single payment ID has multiple refunds
Some payments were refunded in two installments. Your sheet has one row per payment ID, but Razorpay has two refund records.
Fetch all Razorpay refunds from the last 60 days. For each payment ID in column A, sum all refund amounts for that payment ID across all Razorpay refund records. Compare the total refunded amount against column B. Write "Fully Refunded," "Partially Refunded," or "Missing" in column C accordingly.
When you want the full gap report — pull, match, flag, and summarize
Fetch all Razorpay refunds from the last 60 days and put them in a "Razorpay Refunds" tab. Compare payment IDs against column A of this sheet. Write "Processed," "Partially Refunded," or "Missing" in column C. Then write a summary in cell E1: total logged requests, total processed, total partially refunded, total missing, and total missing amount (sum of column B for rows marked "Missing").
The pattern: the data pull, the cross-reference, and the summary all come out of one prompt.
Try It
Get the 7-day free trial of SheetXAI and open your refund tracking sheet, then ask it to pull the Razorpay refund data and flag the gaps. The Razorpay integration is included in every SheetXAI plan. For related workflows, see how to export disputes for triage or the Razorpay in Google Sheets overview.