Tracking MRR in Google Sheets is completely doable, and for an early-stage company it's often the right call — no integration, no recurring fee, total control. The trick is building it so a monthly refresh is a single paste and the formulas don't silently break. Here's the structure.
In the model tab, convert every plan to a monthly figure: annual ÷ 12, quarterly ÷ 3. A simple IF on the interval column does it. This one step prevents the most common Sheets MRR error — annual plans inflating MRR the month they bill.
To get new/expansion/contraction/churn, compare each customer's monthly amount this period vs last. A keyed lookup — SUMIFS or a pivot on customer ID + month — lets you classify each change. The result is the bridge: Start + New + Expansion − Contraction − Churn = End.
Once MRR and movement work, layer on ARPU (MRR ÷ accounts), revenue churn (churned MRR ÷ starting MRR), and net revenue retention. These reuse the same model tab, so they're a few cells each.
Building from scratch takes a few hours and some debugging of the keyed lookups — the cohort comparison is where most people stumble. If you'd rather not, a ready-made Sheets template ships the three-tab structure, the normalization, and the movement bridge already wired; you paste your export and it fills in. It also runs in Excel for teams that prefer it.
The template we recommend is exactly this: a clean Google Sheets / Excel MRR tracker with the movement breakdown, retention, and a formulas-explained tab, ready to paste your export into.
Use three tabs — a raw paste of your billing export, a model tab that normalizes plans to monthly and keys customers by month, and a dashboard. Compare each customer month over month to build the MRR movement breakdown.
Use full-column ranges or a table so new rows are included, keep the raw tab formula-free, and never type numbers onto the dashboard — always reference the model tab.
Yes — SaaSDash is a Google Sheets/Excel template with the three-tab structure, plan normalization, MRR movement, retention and a formulas-explained tab already built; you just paste your export.
Page built 2026-06-14 from public, dated buying-intent signals. Updated as new signals land.