The 4 Essential Reports Every SaaS Founder Must Build
Four spreadsheet reports — Revenue Model, Cash Burn, Cohort Retention, and Acquisition Funnel — are the minimum viable analytics stack for any Seed-to-Series A SaaS company.
Jason Kirby· July 14, 2023· 6 min read
The short version
- Build Revenue Model, Cash Burn, Cohort Retention, and Acquisition Funnel — in that order.
- Each report answers one core question: are you growing, solvent, retaining, and acquiring?
- Weekly review of all four creates a feedback loop that keeps you proactive, not reactive.
- Without these four reports, fundraising conversations stall — investors expect to see them.
- Small funnel improvements compound: every extra customer adds New MRR plus Retained MRR for every future month.
Once you hit Product-Market Fit, running a SaaS business without structured reporting is like flying without instruments. These four reports are the minimum viable analytics stack for any Seed-to-Series A recurring-revenue startup — and without them, a fundraise conversation will stall fast.
Build them in this order. Each one unlocks the next, and together they give you a complete view of the business.
I. Revenue Model
The Revenue Model is a single view of past, present, and projected Monthly Recurring Revenue (MRR), broken into its components. It shows exactly how dependent your growth is on new customers versus retaining and expanding the ones you already have.
It lives in a spreadsheet — Equals is the recommended tool — and it's the core model for understanding and growing any subscription business.
How to read it
Every row is an MRR component; every column is a calendar month. Projections extend forward from the current date.
The core equation:
Total MRR = New + Retained − Churned + Expansion − Contraction + Resurrected
Include your acquisition funnel stages in this same model so you get a holistic view of the full bowtie funnel — from top-of-funnel lead volume all the way through to retained revenue.
How to use it
The three recurring jobs:
- Review funnel and MRR components — did you hit last month's Expansion MRR target?
- Decide and act — if you missed, dig into why and set a corrective action for this month
- Follow up — one week later, is the metric moving? Did the action help?
Beyond daily management, the Revenue Model lets you set goals, spot long-term trends, and run scenarios — for example, what would it take to double MRR by year-end?
II. Cash Burn Model
The Cash Burn Model is your source of truth for monthly spend, monthly revenue, cash balance, and runway. It answers the question Paul Graham framed as default alive or default dead — and that answer matters both for day-to-day operations and for your negotiating position with investors.
Managing cash only gets harder at hypergrowth. The volume of transactions — new customers, cloud spend, hiring — scales with revenue, and without a model, costs become invisible until they're urgent.
Components
| Row | What it tracks |
|---|---|
| Revenue | Cash received monthly from subscriptions and services |
| Headcount | Staff, contractors, benefits, and overhead |
| Recurring spend | Office rent, software subscriptions, regular costs |
| One-off spend | Tax payments, equipment, non-recurring items |
How to use it
The three recurring jobs:
- Review costs and revenue — is runway stable, growing, or shrinking, and why?
- Decide and act — if runway fell from 18 to 16 months, identify which cost increased or which revenue line missed, then cut or redirect
- Follow up — after cutting a channel, track whether burn decreased without a material drop in New MRR
A worked example: after observing that ad spend doubled over three months, you analyze Return on Ad Spend by channel. You cut Facebook (lower ROAS than LinkedIn). A week later, spend is down 30% with minimal impact on New customer MRR. Runway stabilizes.
III. Cohort Retention: Customer and Revenue
Retention is where SaaS companies live or die. Aggregate churn rates hide what's actually happening — cohort analysis surfaces it. By grouping customers by the month they first paid, you can compare retention curves across cohorts, spot inflection points, and see whether things are getting better or worse over time.
Christoph Janz's The P9 Guide to Cohort Analysis in SaaS (v0.9) is the definitive deep-dive on building and interpreting these charts.
How to read a cohort triangle
Each row is a customer cohort (month of first payment). Each column is a "lifetime month" — months since acquisition. The current month is always blank, which creates the triangle shape.
- New Customers column — size of each cohort at acquisition (e.g., 88 customers joined in February)
- Lifetime month cells — customers or revenue remaining in that cohort at that age
- Percentage view — convert absolute numbers to a percentage of the original cohort and apply conditional formatting; this makes trend comparison fast
Example: the August cohort starts at 410 customers. By lifetime month 1 (September), 400 remain — 10 churned. By lifetime month 2, 370 remain.
How to use it
The three recurring jobs:
- Review trends — is retention improving with each new cohort? Where are the largest drop-off points? Is the retention curve flattening (good) or continuing to decline (bad)?
- Decide and act — a sharp drop at lifetime month 1 across all cohorts almost always signals an onboarding or activation problem
- Follow up — after changing onboarding, monitor whether qualitative feedback improves and whether the next cohort's month-1 retention ticks up
Track both customer retention (headcount) and revenue retention (MRR) — they diverge when you have a mix of contract sizes.
IV. Acquisition Funnel Report
The Acquisition Funnel Report tracks three metrics at every stage of your pipeline: volume, conversion rate, and time to convert. Together these three numbers tell you not just where your funnel is leaking but how much revenue that leak is costing you.
Small improvements compound hard. Every additional customer acquired adds New MRR that month — and Retained MRR for every month after. In the early stages of a startup, nearly all revenue growth comes from new acquisition, so this report deserves close attention.
How to read it
For a typical inbound, sales-led B2B SaaS funnel, stages run from Marketing Qualified Lead (MQL) → Sales Qualified Lead (SQL) → Opportunity → Closed-Won. For each stage, track:
- Volume — how many accounts are at this stage in a given period
- Conversion rate — what percentage advance to the next stage
- Time to convert — average days between stages
The interaction of all three is what diagnoses problems. Flat SQL volume with a falling Opportunity conversion rate and rising time-to-convert points to a qualification or engagement problem — not a top-of-funnel one.
How to use it
The three recurring jobs:
- Review volume, conversion rate, and time to convert at each stage — look for any metric that has moved two or more months in a row
- Decide and act — if Opportunity volume is down, trace it back through the prior stage's three metrics to isolate root cause, then intervene
- Follow up — if you run targeted outbound to high-intent MQLs to compensate for a shortfall, measure whether Opportunity volume recovers the following week
A worked example: Opportunity volume drops. SQL volume is flat, but the SQL-to-Opportunity conversion rate fell and time to convert grew. You have your SDR team do targeted outbound to high-intent MQLs to compensate for the shortfall. The following week, Opportunity volume ticks up. You also identify that the drop coincided with pausing LinkedIn Ads — enough evidence to run a one-month reactivation test.
Making It a Habit
These four reports work best reviewed on a weekly cadence. Weekly review creates the feedback loop that lets you catch issues early, act, and confirm whether the action worked — all within the same month.
The founders who use these reports consistently stop being reactive. They walk into board meetings and investor conversations with numbers that tell a coherent story, and they build teams that trust the data enough to move fast.
Rahul Reddy and Kyle Doherty are co-founders of RDC, a RevOps and Analytics agency that helps startups build foundational SaaS reporting. Their backgrounds span Business Intelligence and Growth Operations at Trusted Health, Business Operations and Growth Operations at Intercom, and earlier careers in Data Science and Full Stack Engineering.
Questions founders ask
What is the core MRR formula used in a SaaS Revenue Model?
Total MRR = New + Retained − Churned + Expansion − Contraction + Resurrected. Each component is tracked month by month so you can isolate what is driving or dragging overall growth.
What does 'default alive or default dead' mean for a startup?
It's a framework from Paul Graham that asks whether your startup will reach profitability on its current trajectory before it runs out of cash. The Cash Burn Model is the tool you use to answer that question concretely.
Why use cohort retention instead of a single aggregate churn rate?
Aggregate churn hides variation between new and long-term customers. Cohort analysis lets you compare retention curves across acquisition months, spot where customers drop off in their lifecycle, and measure whether retention is genuinely improving over time.
Your situation isn't generic. Neither is the answer.
Ask your question and get a straight answer, sourced from 100+ founders and investors who have raised and exited at scale.
Ask your board