The Scenario
You are an operations lead at an online store. Your head of finance just asked: how many orders from last month are still unpaid? You have 800 Razorpay orders from last month in the system. Some paid, some partially paid, some still "created."
Getting this from the Razorpay dashboard means exporting a CSV, opening it in Excel, writing conditional formulas to evaluate payment status per row — starting from a 15-column raw export that doesn't directly tell you whether a payment was captured.
The slow version:
- Export the orders CSV, open in Excel
- Identify the status column, filter for "created" rows
- Realize the order status alone doesn't confirm whether payments were captured — cross-reference required
- Write an INDEX-MATCH against the payments export
- Ninety minutes on a five-minute question.
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 Razorpay orders, evaluate payment status, and flag unpaid ones without you touching the dashboard.
Open the SheetXAI sidebar and type:
Fetch all Razorpay orders from the last 30 days. Import order ID, amount in rupees (convert from paise), order status, receipt number, and creation date into this workbook. Add a "Payment Status" column — write "Unpaid" for orders with status "created," "Fully Paid" for orders with status "paid," and "Partially Paid" for orders where the amount paid is less than the order amount. Sort by Payment Status so "Unpaid" rows appear first.
SheetXAI pulls all 800 orders, evaluates payment status per row, and sorts the workbook.
What You Get
An orders workbook with every row evaluated:
- Order ID, amount, status, receipt, creation date — one row per order
- "Payment Status" column — "Unpaid," "Fully Paid," or "Partially Paid"
- Unpaid rows at the top — sorted so your follow-up list is ready
The finance question is answered directly from the workbook. No formula writing required.
What If the Data Is Not Quite Ready
When you need to distinguish abandoned orders from recently created ones
Fetch all Razorpay orders from the last 30 days. For orders with status "created," add an "Age (days)" column. Flag orders older than 3 days as "Abandoned" and newer ones as "Pending."
When you need the outstanding amount for partial payments
Fetch all Razorpay orders from the last 30 days. For partially paid orders, calculate the outstanding balance (order amount minus captured amount) and write it in column F as "Outstanding: ₹[amount]."
When you only want orders above ₹5,000
Fetch all Razorpay orders from the last 30 days where the order amount exceeds ₹5,000. Import order ID, amount, status, and receipt. Flag unpaid and partially paid orders in column E. Sort by amount descending.
When you want the full picture — pull, evaluate, flag abandoned, and summarize
Fetch all Razorpay orders from the last 30 days. Add a "Payment Status" column with "Fully Paid," "Unpaid," or "Partially Paid." For unpaid orders older than 3 days, relabel as "Abandoned." Write a summary starting in cell H1: total orders, total fully paid, total unpaid, total abandoned, total value of unpaid and abandoned orders combined.
The pattern: the data pull, the status logic, the age flag, and the summary all happen in one prompt.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook, then ask it to pull your last 30 days of Razorpay orders and flag the unpaid ones. The Razorpay integration is included in every SheetXAI plan. For related workflows, see how to export Razorpay payments in Excel or the Razorpay in Excel overview.