The Scenario
You're the CFO at a SaaS company that processes African subscriptions through Flutterwave. Your board deck is due Friday. Slide 7 needs to show MRR by plan and a trailing 6-month churn rate. You have 300 active and cancelled subscription records in Flutterwave and none of them are in a workbook yet.
Your analyst started pulling this last quarter. She used the dashboard export, spent two hours cleaning the CSV, and built the formulas. Then the month after, the export format changed slightly and two of the formulas broke. She fixed them. The month after that, she left the company.
Nobody wrote down how she did it.
The bad version:
- You try to reproduce her process. The dashboard export for subscriptions is separate from the transaction export — different menu, different column names.
- You download it, find that cancelled subscriptions show up with a blank cancellation date rather than a null, which breaks your DATEDIF formula for calculating tenure.
- You fix the formula by hand, then realize there's no "plan name" column in the export — only a plan ID — so you have to cross-reference against a second export to resolve the names.
It is Wednesday. The board deck is Friday. The churn calculation is still wrong.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent that lives inside your Excel workbook. It reads your existing workbook structure and pulls the Flutterwave subscription data directly — cancelled and active alike — through its built-in integration. No plan ID lookups, no blank-field workarounds.
Export all Flutterwave subscriptions — both active and cancelled — into this Excel sheet and add a column calculating how many months each subscription has been active
What You Get
- One row per subscription with subscription ID, customer email, plan name, status, amount, currency, and start date.
- Both active and cancelled subscriptions are included, with status clearly marked in its own column.
- The plan name comes through already resolved — not a plan ID that needs a lookup.
- An additional column calculates months active as the difference between today (or cancellation date) and start date.
What If the Data Is Not Quite Ready
You need active and cancelled subscriptions split into separate worksheets
Fetch all Flutterwave subscriptions where status is 'active' and write them into the Active Subscriptions sheet. Fetch all where status is 'cancelled' and write them into the Cancelled Subscriptions sheet. Include subscription ID, customer email, plan name, amount, currency, and start date in both.
The board wants MRR broken down by plan
Fetch all Flutterwave subscriptions where status is 'active', write subscription ID, customer email, plan name, and amount into this sheet, then add a summary table below showing total active count and total MRR (sum of amounts) grouped by plan name
You need to filter to only subscriptions that started in the last 12 months
Fetch all Flutterwave subscriptions with a start date in the last 12 months, write subscription ID, customer email, plan name, status, amount, currency, and start date into this sheet, and add months-active in the next column
Full board-ready data pull: active subs, cancelled subs, MRR by plan, and churn rate — one prompt
Fetch all Flutterwave subscriptions. Write active subscriptions into the Active sheet with subscription ID, email, plan name, amount, currency, and start date. Write cancelled subscriptions into the Cancelled sheet with the same columns plus cancellation date. In the Summary sheet, write MRR by plan (sum of active amounts grouped by plan name) and 6-month churn rate (cancelled in last 6 months divided by total at 6 months ago).
That's the whole board deck data layer in a single prompt. No CSV cleanup, no second-lookup worksheet.
Try It
Get the 7-day free trial of SheetXAI and open any Excel workbook you're building a subscription metrics report in, then ask it to pull all Flutterwave subscription records and calculate MRR and churn rate by plan. You can also see how to pull settlement data into an Excel workbook or the full Flutterwave integration overview.