The Scenario
Every Monday morning your founder asks the same question in the company Slack: "How are we tracking vs last month?"
You have Payhere's dashboard open on one screen. It shows the current 30-day totals. It shows the prior 30-day totals. It does not calculate the percentage change. It does not show you a formatted table you can paste into Slack or the weekly report workbook. So every Monday you squint at two sets of numbers, do the math in your head, type it into an Excel worksheet, format it, and share the link.
The bad version:
- Open Payhere, read current 30-day revenue, prior 30-day revenue, new subscriber count, payment count — write them down
- Open the workbook, paste in the numbers, write formulas for percentage change in three separate cells
- Realize last week's numbers are still in the workbook from the previous Monday and you've overwritten them, losing the historical trend
The report takes 15 minutes to produce. It looks like it took 2.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It talks to Payhere's stats endpoint and writes a formatted comparison directly into your workbook — math included.
Pull my Payhere company stats for the last 30 days and populate a summary table in this Excel sheet comparing revenue and subscriber metrics to the previous 30-day period — write current values in column B, prior values in column C, and percentage change in column D
What You Get
- Current 30-day totals and prior 30-day totals written side by side in your workbook
- Percentage change calculated automatically in column D for each metric
- Data written as numeric values so you can apply your own formatting and charting on top
- The whole table in under a minute — no copying from the dashboard, no mental arithmetic
What If the Data Is Not Quite Ready
You want the stats appended as a new row each week, not overwritten
Fetch Payhere's current 30-day stats and append a new row to the bottom of this worksheet with today's date in column A, current revenue in column B, prior revenue in column C, new subscribers in column D, and payment count in column E
You need the delta as an absolute number, not just a percentage
Pull Payhere's 30-day payment stats and write a summary table with current value, prior value, absolute change, and percentage change for revenue, subscriber count, and payment count — one metric per row
The stats need to go into a presentation-ready summary block
Fetch Payhere's 30-day stats and write a one-page summary into the Dashboard worksheet with current period totals in cells B2 through B4, prior period values in C2 through C4, and percentage change formatted with a + or − sign in D2 through D4
Weekly briefing plus trend analysis in one command
Get Payhere's current 30-day stats, write the comparison table into the Weekly worksheet with today's date, and in the Trends worksheet append one row to the running historical table so we can track month-over-month patterns over time
The pattern: pull the live data and update the historical record in the same command so the trend workbook stays current without a separate step.
Try It
Get the 7-day free trial of SheetXAI and open your weekly reporting workbook, then ask it to pull and populate this week's Payhere stats comparison. See also: exporting your full payment history when you need the transaction-level detail behind the headline numbers. Full Payhere overview: How to Connect Payhere to Excel.