Free SaaS Revenue Forecast Template
A SaaS revenue forecast template should make recurring revenue movement visible month by month. The table below is intentionally simple so founders can copy it into a spreadsheet before adding more advanced inputs such as acquisition channels, pricing tiers, expansion revenue, payment failures, or sales capacity.
What the Template Includes
Use starting MRR as the opening recurring revenue base for the month. Add new MRR from new customers and expansion MRR from upgrades, added seats, higher usage, or paid add-ons. Subtract churned MRR from cancellations. If you also track downgrades separately, add a contraction MRR column between expansion and churned MRR.
Ending MRR becomes the following month starting MRR. ARR is ending MRR x 12. Cumulative forecast revenue can be added as another column by summing monthly ending MRR over the forecast period.
Copyable Forecast Table
| Month | Starting MRR | New MRR | Expansion MRR | Churned MRR | Ending MRR | ARR |
| 1 | $10,000 | $1,000 | $250 | $300 | $10,950 | $131,400 |
| 2 | $10,950 | $1,095 | $274 | $329 | $11,990 | $143,880 |
| 3 | $11,990 | $1,199 | $300 | $360 | $13,129 | $157,548 |
Month,Starting MRR,New MRR,Expansion MRR,Churned MRR,Ending MRR,ARR 1,10000,1000,250,300,10950,131400 2,10950,1095,274,329,11990,143880 3,11990,1199,300,360,13129,157548
How to Use It
Start with your actual current MRR, not a target. If you have annual contracts, divide the annual recurring contract value by twelve to normalize it into MRR. Keep one-time services, setup fees, or implementation projects outside the recurring revenue columns unless they truly repeat.
Next, create conservative, base, and aggressive versions of the model. The conservative case should include slower new MRR and higher churn than you want. The base case should reflect your current sales and retention motion. The aggressive case should be tied to specific changes, such as better activation, new pricing, channel expansion, or a stronger expansion revenue motion.
Use the Aura Revenue calculator to test the shape of the curve quickly, then use the template for the operating detail. Read the methodology to understand what the public calculator includes and what a deeper spreadsheet should add.
Metrics to Add Beside the Template
The forecast table explains monthly recurring revenue movement. For a fuller operating dashboard, add retention and efficiency metrics beside it: revenue churn, net revenue retention, CAC payback, burn multiple, and Rule of 40. These metrics help explain whether growth is durable, efficient, and realistic.
Important disclaimer
Aura Revenue provides educational forecasting tools and examples only. Outputs are estimates based on user-provided assumptions and should not be treated as financial, legal, tax, accounting, or investment advice.