Get FP&A best practices, research reports, and more delivered to your inbox.
Bottom line: A complete SaaS financial model has three connected parts — a revenue/ARR build, a headcount and expense plan, and a rolling forecast that rolls them into a forward view with scenarios. Build each driver-based (assumptions in one place, flowing through), and you have a model you can actually maintain. Free templates for all three are linked below.
Free downloads: Aleph offers free, driver-based templates for each piece of a SaaS model — a rolling forecast template, a sales capacity model, and a headcount planning template, all in Excel and Google Sheets.
What is a SaaS financial model?
A SaaS financial model is a structured projection of a subscription business's financials, built around recurring revenue. Unlike a generic three-statement model, it's organized around SaaS mechanics: an ARR bridge (new, expansion, contraction, churn), driver-based headcount and spend, and the SaaS metrics investors and boards watch — NRR, CAC payback, the Rule of 40, and burn. The output is a forward view of revenue, costs, profitability, and cash you can plan and fundraise against.
What a good SaaS financial model template includes
The difference between a useful template and a static spreadsheet with month columns:
- A revenue/ARR build with a bookings-to-ARR bridge — new, expansion, contraction, and churn broken out, not a single growth line.
- A driver-based headcount and expense plan — hiring and cost tied to assumptions you can change in one place.
- A rolling forecast output — anchored to your last closed month so the model always shows trailing actuals plus a forward window.
- SaaS metrics — ARR, NRR/GRR, CAC payback, Rule of 40, and burn calculated automatically from the build.
- Base, upside, and downside scenarios that flex revenue and costs together.
- Data validation to catch missing or duplicate inputs before they corrupt the model.
No single tab does all of this cleanly — which is why it's better assembled from focused components than forced into one mega-spreadsheet.
The three components (and a free template for each)
Start with the rolling forecast template as the spine, then layer in the sales capacity model for the new-ARR build and the headcount planning template for the people plan.
How to build a SaaS financial model
- Start with the revenue/ARR build. Model new bookings and the ARR bridge (new, expansion, contraction, churn) — this drives everything downstream.
- Add the headcount and expense plan. Tie hiring to drivers (revenue, capacity, ratios) rather than a flat list, since people are most SaaS companies' largest cost.
- Roll it into a forward forecast. Anchor to your last closed month and project 12–18 months ahead. See how to build a rolling forecast.
- Layer in scenarios. Build base, upside, and downside cases. See scenario planning in FP&A.
- Surface the SaaS metrics. Calculate NRR, CAC payback, Rule of 40, and burn off the build so they update automatically.
SaaS metrics your model should track
A SaaS financial model should output the metrics boards and investors benchmark you against — NRR, gross retention, CAC payback, the Rule of 40, and burn multiple — calculated from the build rather than typed in. For how these benchmark across 342 companies, see the 2026 Aleph × Benchmarkit SaaS & AI Performance Benchmarks.
From template to connected model
Templates are the right place to start; they break when the data goes stale. The moment a SaaS model depends on manually pasting actuals from the ERP, CRM, and billing each month, it stops being current. Tools worth looking at when you outgrow the spreadsheet: Aleph (driver-based modeling on live, connected data while staying in Excel and Google Sheets), and alternatives like Cube, Datarails, Bob Finance (formerly Mosaic), and Pigment. See best FP&A software for SaaS companies. And if budgeting and forecasting is the specific job you're hiring software for, we ranked the best budgeting and forecasting software for SaaS on exactly that: ARR modeling, headcount planning, and NetSuite fit across 11 platforms.
Sources and related reading
Guidance reflects standard SaaS FP&A practice; for general financial-modeling fundamentals see Corporate Finance Institute. Related: how to build a rolling forecast, scenario planning in FP&A, and best FP&A software for SaaS companies.
Build yours from working models: download the free rolling forecast, sales capacity, and headcount planning templates, or book a demo to run your model on live data.
Get FP&A best practices, research reports, and more delivered to your inbox.
