The Scenario
You are a payments operations manager at an online marketplace. Your acquiring bank has flagged chargebacks and your team has 72 hours to respond. You have no consolidated view of active Razorpay disputes — only the dashboard, one page at a time.
The slow version:
- Log into the Razorpay dashboard, navigate to Disputes
- Screenshot each page, manually build a workbook with payment ID, amount, reason, status, and respond-by date
- Sort by respond-by date
- Add a "Days Until Deadline" formula
- Realize the dashboard timestamps are UTC and your bank's deadline is IST. Redo the deadline column.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that can pull all active Razorpay disputes and build the triage sheet for you, sorted by urgency.
Open the SheetXAI sidebar and type:
List all Razorpay disputes and import payment ID, dispute ID, disputed amount in rupees (convert from paise), reason, status, and respond-by date into this workbook. Sort by respond-by date ascending. Add a "Days Until Deadline" column showing how many days remain from today.
SheetXAI pulls every active dispute, writes the rows into the workbook, and adds the calculated urgency column.
What You Get
A dispute triage workbook ready to share:
- Payment ID, dispute ID, amount, reason, status, respond-by date — one row per dispute
- "Days Until Deadline" column — calculated from today
- Sorted by respond-by date — most urgent dispute in row 2
You can assign team members immediately. Add an "Owner" column and distribute rows. No one needs to log into the dashboard.
What If the Data Is Not Quite Ready
When respond-by dates need IST conversion
Fetch all Razorpay disputes. Convert the respond-by date from UTC to IST before writing to the workbook. Add a "Days Until Deadline (IST)" column.
When you want disputes grouped by reason code for pattern analysis
Fetch all Razorpay disputes and import into this workbook. Add a summary section below the data showing count of disputes by reason code and total disputed amount by reason code. Sort the summary by total disputed amount descending.
When only high-value disputes need senior review
Fetch all active Razorpay disputes. Add a "Priority" column — "High" for disputes above ₹10,000, "Standard" for the rest. Sort by Priority then by respond-by date.
When you want the full triage workbook — pull, sort, flag overdue, and summarize
Fetch all Razorpay disputes. Import payment ID, dispute ID, amount in rupees, reason, status, and respond-by date. Sort by respond-by date ascending. Add a "Days Until Deadline" column. For disputes where the respond-by date is in the past, write "OVERDUE" in a "Status Flag" column. Write a summary in cell H1: total active disputes, total overdue, total disputed amount, average days remaining for non-overdue disputes.
The pattern: the data pull, the urgency logic, the overdue flag, and the summary all come out of one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook, then ask it to pull your active Razorpay disputes and build the triage view. The Razorpay integration is included in every SheetXAI plan. For related workflows, see how to cross-reference refunds in Excel or the Razorpay in Excel overview.