Description
Full Walkthrough
Track recurring revenue, member churn, retention, lifetime value and acquisition cost for membership sites, communities and subscriptions.
Who it’s for
Membership sites, online communities, paid newsletters and subscription businesses who want clear numbers without another tool.
What’s inside
- Dashboard: MRR, ARR, members, ARPA, growth, NRR, churn, LTV, CAC, LTV:CAC, payback, 3 charts, plan mix and channel scorecard
- Members: Subscription list with MRR after discount, status and months active
- MRR Changes: Upgrades (expansion) and downgrades (contraction)
- Spend: Sales & marketing spend by channel and month
- Monthly Metrics: 12-month MRR bridge, member counts, churn %, revenue churn %, NRR, ARPA, CAC, LTV, LTV:CAC, CAC payback
- Cohorts: Retention triangle: % of each signup month still active after 0–11 months, heat-mapped
- Settings: Currency, first month, gross margin, plans & prices, channels, churn reasons
What you get
- The .xlsx workbook with sample data that’s easy to clear
- Setup Guide PDF, with every tab explained
- A video walkthrough
FAQ
Does it work in Google Sheets?
Yes. Upload it to Google Drive, open it with Google Sheets, then choose File > Save as Google Sheets.
Which Excel version do I need?
Excel 2019 or newer, Microsoft 365 or Excel for Mac.
Is this a subscription?
No. You pay once and keep the file. No macros, no add-ons.
Sample numbers are example data, not benchmarks.
This is a digital product. No physical item will be shipped.
Also on Gumroad: Membership & Subscription Business Tracker: MRR, Churn & LTV on Gumroad
Build your own store: Hostinger WordPress hosting (affiliate link: I may earn a commission at no extra cost to you)
