SaaS Metrics Command Center

Know your MRR, churn and runway in one spreadsheet.

Enter your monthly numbers in one tab. Get a clear dashboard of 15 SaaS metrics, with charts that update as you change your figures.

Get the spreadsheet — $69 Watch the walkthrough

One-time purchase · Manual input, automatic calculations · Excel & Google Sheets · Instant download

Works in Excel & Google Sheets
Instant download via Gumroad
15 metrics calculated automatically
Example data included
Product walkthrough

See how the spreadsheet works in 2 minutes

A short walkthrough of the workbook tabs, how to enter your data, and what the dashboard shows you.

Video not loading? Watch on YouTube

What it covers

Three areas of your SaaS business, in one file

Each group of metrics helps you understand a different dimension of how your business is performing.

Growth

Revenue trajectory

Understand the shape of your revenue. See whether you are accelerating, holding steady, or declining — and by how much each month.

  • MRR at end of month
  • ARR
  • Month-over-month MRR growth
  • Net new MRR
Retention

How well you keep customers

See the damage from churn and whether expansion revenue is offsetting your losses — the combination that separates healthy SaaS from struggling SaaS.

  • Customer churn rate
  • Gross revenue churn rate
  • Net Revenue Retention
  • SaaS quick ratio
Acquisition & Runway

Unit economics and cash position

Understand what acquiring a customer costs relative to what they are worth, and how long your current cash balance lasts at your current burn rate.

  • CAC
  • ARPU
  • Estimated revenue LTV
  • Estimated revenue LTV:CAC
  • Estimated runway
How it works

From download to first dashboard in under 10 minutes

No formulas to write, no setup required. The workbook arrives ready to use.

Open the workbook and explore the example data

All 12 months are pre-filled with fictional figures. Every metric and both charts are already working so you can see exactly what you are buying before changing anything.

Replace the yellow input cells with your figures

The Monthly Input tab has one clearly marked column per month. Enter your customer counts, MRR movements, costs, spend and cash balance.

Review your metrics and charts

Switch to the Dashboard tab. All 15 metrics recalculate automatically. The MRR and net new MRR charts update to reflect your figures.

Fill in the next column each month

The workbook has 12 monthly columns. At the end of each month, add a column of figures. Everything updates in a few minutes.

What's included

One file. Four tabs. Fifteen metrics.

Open in Excel 2016 or newer, Excel Online, or Google Sheets. No installation, no account, no subscription.

Four workbook tabs

  • START HERE — Instructions and a quick-start guide for the workbook
  • Monthly Input — The only tab you edit: customer counts, MRR movements, costs, marketing and sales spend, and cash balance
  • Dashboard — 15 calculated metrics and 2 charts, updated automatically when you change your input figures
  • What Good Looks Like — Benchmark guidance to help you interpret your metrics

Two charts

  • MRR over time
  • Net new MRR over time

What you receive

  • Excel file (.xlsx) — works in Excel 2016 and newer, and Excel Online
  • Google Sheets version — a link to copy to your own Drive
  • 12-month column layout, pre-filled with example data
  • Instant delivery via Gumroad after purchase

15 calculated metrics

  • Customers at end of month
  • MRR at end of month
  • ARR
  • MoM MRR growth rate
  • Net new MRR
  • Customer churn rate
  • Gross revenue churn rate
  • Net Revenue Retention
  • SaaS quick ratio
  • ARPU
  • CAC
  • Estimated revenue LTV
  • Estimated revenue LTV:CAC
  • MRR minus monthly costs
  • Estimated runway
Questions

FAQ

Is this software or a spreadsheet?
It is a spreadsheet — an Excel workbook (.xlsx) with a Google Sheets version included. There is nothing to install and no account to create. You open the file in Excel or Google Sheets and it runs on your computer.
Does it connect to Stripe automatically?
No. There is no live Stripe connection and no import tab. You enter your monthly figures manually into the input tab. If you export your MRR data from Stripe or another tool, you read the numbers off and type them in — it takes under 10 minutes per month.
What figures do I enter each month?
The Monthly Input tab asks for: customers at the start of the month, new customers added and customers churned; starting MRR, new MRR, expansion MRR, contraction MRR and churned MRR; total monthly costs; marketing and sales spend; and your cash balance. Everything else calculates automatically from those inputs.
Do I need finance experience to use this?
No. The only tab you ever edit is the Monthly Input tab. All 15 metrics calculate automatically from your inputs. The workbook ships with 12 months of fictional example data so you can see it working before you replace anything with your own figures.
How is estimated revenue LTV calculated?
Estimated revenue LTV = ARPU divided by your customer churn rate. It is a simplified estimate. It does not account for gross margin or expansion revenue. Use it as a directional reference, not a precise valuation.
How is estimated runway calculated?
Estimated runway = cash balance ÷ (monthly costs − MRR), when costs exceed MRR. MRR is a simplified proxy for cash receipts, so actual cash timing can differ.
How do I receive the product after purchase?
Gumroad emails you a download link immediately after checkout. Check your spam folder if it does not arrive within a few minutes. You can also access all purchases in your Gumroad Library at gumroad.com/library. You receive the Excel file and a link to the Google Sheets version.
What is the refund and support policy?
All sales are final as these are instant digital downloads. If a file fails to open or a formula does not work as described, email najwa.saadi1@hotmail.com within 14 days of purchase — we will fix it or, if we cannot, issue a full refund. See our Terms of Service for full details.
Get started

Know your numbers. Keep it simple.

15 SaaS metrics calculated automatically from your monthly input. No software, no subscription, no setup. Open it in Excel or Google Sheets and start with the example data.

Get the spreadsheet — $69 One-time purchase · Instant download