The Scenario
You are a growth analyst. The new quarter starts in six weeks and you need to forecast MRR for the next 90 days from ProAbono subscription renewal data.
You have 600 active subscriptions with renewal dates spread across the quarter. You need subscription ID, customer reference, period start, period end, and amount in an Excel workbook so you can model which renewals are at risk and what the expected MRR is each month.
The bad version:
- You open ProAbono and look for a way to view upcoming periods sorted by renewal date
- The UI does not let you filter by period end date
- You export a CSV of subscription data, but it does not include period dates, only subscription start dates
- You realize period data is a separate endpoint and ask engineering for a query
- Engineering is busy and says next week
- You present your MRR forecast to leadership using last quarter's data because the renewal data was not ready.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that can query ProAbono's subscription periods endpoint directly so you do not have to wait for an engineering script.
Open the SheetXAI sidebar and type:
List all ProAbono subscription periods starting after today and ending within the next 90 days. Write subscription ID, customer reference, period start, period end, and amount into the Renewals tab of this workbook. Sort by period end ascending so nearest renewals are at the top. Add a "Month" column grouping each renewal into July, August, or September.
SheetXAI calls ProAbono's periods endpoint, filters for the upcoming 90-day window, writes the data sorted by renewal date into the Renewals tab, and adds the monthly grouping column. Your MRR forecast input is ready.
What You Get
A renewal forecast workbook in the Renewals tab:
- Subscription ID and customer reference — so you can look up specific accounts
- Period start and end — exact renewal dates
- Amount — the expected MRR contribution from each renewal
- Month column — for grouping into July, August, September totals
The period data comes from ProAbono's billing cycle records, not inferred dates. You are forecasting from actual billing periods.
What If the Data Is Not Quite Ready
Renewal forecasting always surfaces edge cases. SheetXAI handles them inline.
When you need to separate monthly from annual subscriptions
Annual renewals and monthly renewals affect your cash flow model differently.
List all ProAbono subscription periods ending within the next 90 days. Add a "Billing Cycle" column: flag periods where end date minus start date is greater than 60 days as "Annual", otherwise "Monthly". Add a summary table at the bottom of the Renewals tab grouping by billing cycle.
When you want to flag accounts with overdue invoices as at-risk
A renewal is less likely to clear if the account already has unpaid invoices.
List all ProAbono subscription periods ending within the next 90 days. For each subscription, check if the customer has any unpaid invoices in ProAbono. Flag accounts with unpaid invoices as "AT RISK" in column F of the Renewals tab. Sort AT RISK rows to the top.
When leadership wants the forecast grouped by plan tier
The CFO wants to see renewal MRR broken down by offer name, not just as a single total.
List all ProAbono subscription periods ending in the next 90 days. For each period, fetch the offer name of the parent subscription. Group the results by offer name and calculate total renewal MRR per tier. Write both the detail rows and the tier summary into the Renewals tab.
When you need a full 12-month rolling forecast
The board wants 12 months of renewal visibility, not just the next quarter.
List all ProAbono subscription periods starting after today and ending within the next 365 days. Write subscription ID, customer reference, period start, period end, amount, and offer name into the Renewals tab. Add a "Quarter" column grouping renewals into Q3 2025, Q4 2025, Q1 2026, Q2 2026. Add a summary table at the bottom showing expected renewal MRR per quarter.
The pattern: instead of waiting for an engineering query on renewal data, you ask for the period window you need and SheetXAI pulls it directly from ProAbono.
Try It
Get the 7-day free trial of SheetXAI and open a blank workbook, then ask it to pull ProAbono subscription periods for the next 90 days. The ProAbono integration is included in every SheetXAI plan. For related workflows, see how to export active subscriptions for MRR analysis or the ProAbono in Excel overview.