SaaS Sales Forecast Template

Start with the Assumptions sheet. Download the file and open it in Excel or upload it to Google Sheets. Enter your current MRR, average contract value by pricing tier, monthly new logo target, and your current gross churn rate. If you're not sure about churn, start with what you can calculate from the past six months — new MRR added minus ending MRR minus beginning MRR. Getting the Assumptions right takes about 20 minutes and everything else flows from there.

Once assumptions are set, move to the Pipeline Forecast sheet and enter your current open opportunities by stage. This is where the bottoms-up sales view meets the top-down MRR model. If your weighted pipeline implies more revenue than your assumptions model, one of them is wrong — and working through that tension is where the real insight lives. Update this sheet weekly or after significant deal movement to keep the forecast current.

At the end of each month, enter actuals in the Actuals vs Forecast sheet. This takes five minutes and is the most valuable habit you can build. Over time, the pattern of variances tells you whether your assumptions are calibrated — whether you're consistently over-forecasting new logos or under-estimating expansion. Founders and revenue leaders who run this cadence monthly say it's the single best diagnostic for their go-to-market motion, not just a reporting exercise.

SaaS revenue is fundamentally different from transactional businesses, and a generic sales forecast misses most of what matters. In a subscription model, the forecast isn't just about how many deals you close this month — it's about the stock of recurring revenue you carry in, how much of that erodes through churn and contraction, how much grows through expansion, and how much new MRR you add on top. A restaurant forecasting next month's sales needs different math than a SaaS company modeling its ARR trajectory. The MRR waterfall is the right framework, and most general-purpose forecast templates don't have one.

The metrics that drive SaaS sales forecasting — MRR, ARR, net revenue retention, logo churn, dollar churn — have specific definitions that matter precisely because investors and boards are fluent in them. NRR above 100% means your existing customers are growing faster than they're churning, which is the clearest indicator of product-market fit in a subscription business. Pipeline coverage ratio — how much pipeline you have relative to your quota — is a leading indicator of whether you'll hit next quarter's number. A purpose-built SaaS forecast model handles all of these correctly. A generic spreadsheet requires you to build that structure yourself, which is where errors and inconsistencies creep in.

The practical workflow is a three-layer cycle: set your annual assumptions in Q4 or at the start of a new fiscal year, update your pipeline forecast weekly or after major deal events, and close the loop on actuals monthly. Most SaaS teams run a weekly pipeline review and a monthly forecast review as separate cadences — the pipeline review is about deal-level accountability, the forecast review is about whether the model's assumptions still hold. This template supports both cadences: use the Pipeline Forecast sheet in your weekly sales meeting, and pull up the Actuals vs Forecast sheet in your monthly leadership review.