Builds month-end MRR per customer from the normalized Stripe lines plus declared offline contracts and turns it into the monthly MRR waterfall (new, expansion, contraction, churn, reactivation, FX), ARR, customer counts, logo churn, trailing-12-month and monthly NRR and GRR, and revenue and logo cohort tables.
Builds month-end MRR per customer from the normalized Stripe lines plus declared offline contracts and turns it into the monthly MRR waterfall (new, expansion, contraction, churn, reactivation, FX), ARR, customer counts, logo churn, trailing-12-month and monthly NRR and GRR, and revenue and logo cohort tables, with a gate that opening plus movements equals closing exactly every month, a plan switch is never counted twice, and period-end MRR ties to the Stripe subscriptions export subscription by subscription. Use when someone asks "what's our MRR waterfall", "calculate our NRR and GRR", "build cohort retention from Stripe", "how much did we lose to churn", "show expansion vs new MRR", or after bank-cash-ingest. Do NOT use for product usage or engagement cohorts (use pm-cohort-analysis), for choosing which metrics a startup should track (use wshobson-startup-metrics-framework), or for MRR from data that has not been through stripe-revenue-ingest.This is the skill's description: the text your AI reads to decide when the skill applies.
This is the skill's header. The step-by-step instructions are paid content and aren't shown here.
mrr-movements/SKILL.md
---
name: mrr-movements
description: Builds month-end MRR per customer from the normalized Stripe lines plus declared offline contracts and turns it into the monthly MRR waterfall (new, expansion, contraction, churn, reactivation, FX), ARR, customer counts, logo churn, trailing-12-month and monthly NRR and GRR, and revenue and logo cohort tables, with a gate that opening plus movements equals closing exactly every month, a plan switch is never counted twice, and period-end MRR ties to the Stripe subscriptions export subscription by subscription. Use when someone asks "what's our MRR waterfall", "calculate our NRR and GRR", "build cohort retention from Stripe", "how much did we lose to churn", "show expansion vs new MRR", or after bank-cash-ingest. Do NOT use for product usage or engagement cohorts (use pm-cohort-analysis), for choosing which metrics a startup should track (use wshobson-startup-metrics-framework), or for MRR from data that has not been through stripe-revenue-ingest.
---
… the full instructions are part of a premium pack and load in your AI once you have access.