# Stripe Revenue Report

> Generate MRR/ARR reports from Stripe — new, expansion, contraction, churn — broken down by plan or segment. Use on "what's my MRR?", "weekly revenue report", "churn this month", or "show me expansion".

- Skill: `composio-community/stripe-revenue-report` (Agent Skill)
- Install (CLI): `npx skillmds@latest add composio-community/stripe-revenue-report`
- Raw SKILL.md: https://api.skillmd.com/api/skills/composio-community/stripe-revenue-report/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Docs & Writing
- Author: composio-community (https://skillmd.com/u/composio-community)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/composio-community/stripe-revenue-report

---


# Stripe Revenue Report

Compute MRR movements from Stripe subscriptions via Composio.

## Workflow

1. **Scope.** Ask for: period (this month, last 30 days, Q2), grouping (plan, segment, geography), format (markdown, Slack, Sheet).
2. **Link Stripe:**
   ```bash
   composio link stripe
   ```
3. **Pull subscriptions + invoices:**
   ```bash
   composio execute STRIPE_LIST_ALL_SUBSCRIPTIONS -d '{ "limit": 100, "status": "all" }'
   composio execute STRIPE_LIST_INVOICES -d '{ "created": { "gte": 1714521600 }, "limit": 100 }'
   ```
4. **Classify each MRR delta** in the period:
   - `new` — first paid invoice for the customer in the window
   - `expansion` — plan/seat upgrade raising MRR
   - `contraction` — downgrade/seat reduction lowering MRR
   - `churn` — subscription canceled or failed-payment lapse
   - `reactivation` — previously churned, now paying again
5. **Compute:**
   - Starting MRR, New, Expansion, Contraction, Churn, Ending MRR
   - Net New MRR = New + Expansion − Contraction − Churn
   - GRR = 1 − (Churn + Contraction) / Starting MRR
   - NRR = (Starting + Expansion − Contraction − Churn) / Starting
6. **Report** in the requested format. Always show the component table, not just the headline.

## Report template

```
# Revenue Report — <period>
Starting MRR:   $<x>
+ New:          $<a>    (<n> customers)
+ Expansion:    $<b>    (<n>)
- Contraction:  $<c>    (<n>)
- Churn:        $<d>    (<n>)
Ending MRR:     $<y>
Net New:        $<e>
GRR: <xx>% · NRR: <yy>%

Top expansion: <cust> +$<amt>
Top churn: <cust> -$<amt> — reason if known
```

## Guardrails

- Clarify whether "MRR" means normalized monthly (annual / 12) or billed-this-month.
- Failed payments are not churn yet — flag as "at-risk" with dunning status.
- Never post customer-level revenue to public channels without confirming.