Free download β’ Use as a template β’ Print or share
A Sales Forecast is a structured operational document that projects future revenue over a defined period β monthly, quarterly, or annually β using pipeline data, historical sales performance, and documented assumptions about win rates, deal sizes, and market conditions. It translates the raw information sitting in a CRM or sales spreadsheet into a single, credible revenue number that finance, operations, and leadership can plan around. Unlike a sales report, which documents what already happened, a sales forecast commits to a view of what is most likely to happen next β and explains the reasoning behind that view in enough detail that assumptions can be tested and updated as conditions change.
Without a structured sales forecast, revenue planning is guesswork dressed up as strategy. Finance teams build budgets from assumptions that sales leaders have never validated. Operations managers order inventory or hire staff based on targets that no one has tied to an actual pipeline. Founders walk into investor meetings with a revenue number they cannot explain. The consequences are concrete: over-hiring when pipeline is thin, stockouts when demand exceeds the plan, and credibility gaps when actuals miss a number that was never grounded in data. A well-built sales forecast forces you to surface the assumptions behind your revenue number before the period starts β so when a deal slips or a customer churns, you know exactly what changed, how much it matters, and what to do about it. This template gives you a step-by-step framework to build that forecast in hours, not days.
| If your situation is⦠| Use this template |
|---|---|
| Projecting revenue month by month for the next 12 months | Monthly Sales Forecast |
| Building a bottom-up forecast by individual sales rep or territory | Sales Rep Performance Forecast |
| Forecasting revenue by product line or SKU | Product Sales Forecast |
| Projecting pipeline conversion from CRM stage data | Pipeline Forecast Report |
| Planning quarterly targets and quotas for the sales team | Sales Plan |
| Forecasting revenue as part of a full business or operating plan | Business Plan |
| Tracking actuals vs. forecast over a rolling 12-month period | Sales Report |
Why it matters: A $2M pipeline with a 25% win rate is a $500K forecast, not a $2M forecast. Treating every open deal as a closed deal leads directly to over-hiring, excess inventory, and missed cash flow targets.
Fix: Apply stage-based win rates to every open opportunity and sum the weighted values. Revisit win rates each quarter against actual close data.
Why it matters: A single number creates false precision. When actuals miss by 20%, there is no pre-agreed contingency plan and leadership is caught flat-footed.
Fix: Always present base, upside, and downside cases. Define the trigger conditions that would shift you from base to downside so the team knows when to activate contingency plans.
Why it matters: Overwriting the original forecast with actuals destroys the variance data needed to measure and improve forecasting accuracy over time.
Fix: Lock the forecast at the start of each period. Record actuals in a separate column and calculate variance explicitly β this is the only way to learn what assumptions were wrong.
Why it matters: A top-line forecast with no disaggregation gives no visibility into which part of the business is at risk, which rep is sandbagging, or which product line is underperforming.
Fix: Always build the forecast from the bottom up β by rep or segment β and let the total emerge from the sum. The bottoms-up view is where accountability lives.
Why it matters: A trend-based forecast extrapolates the past into the future and misses structural changes β a new competitor, a lost anchor customer, or a shift in go-to-market strategy that makes the historical rate irrelevant.
Fix: Use historical trend as a sanity check on the pipeline-weighted forecast, not as the primary method. If the two diverge by more than 15%, investigate why before presenting the number.
Why it matters: Without stated assumptions, the forecast cannot be updated when inputs change β leaving the team working from stale numbers for weeks after a key variable has shifted.
Fix: List every material assumption explicitly with its source and the period it is based on. When an assumption changes, update that row and recalculate the projection in minutes.
Decide whether you are forecasting monthly, quarterly, or annually. Choose your primary method: pipeline-weighted (best for deal-based B2B sales), historical trend (best for high-volume transactional businesses), or top-down from a market-share assumption.
π‘ Pipeline-weighted forecasting requires an accurate, up-to-date CRM. If your pipeline data is unreliable, start with historical trend analysis and layer in pipeline as data quality improves.
Gather actual revenue for the prior 2β3 years, broken down by month. Identify seasonal patterns, one-time spikes, and the underlying growth rate. Use these as the anchor for your projections.
π‘ Remove one-time deals (large single contracts that are not repeatable) from the baseline before calculating your growth rate β they distort the trend.
Pull the active pipeline from your CRM, grouped by deal stage. Assign a probability to each stage based on your historical win rate per stage, then calculate the weighted pipeline value.
π‘ Use 90-day rolling win rates rather than all-time averages β recent conversion rates reflect your current market and team, not legacy performance.
Translate the weighted pipeline into monthly revenue projections. Add a renewal or expansion revenue line if applicable. Sum to a quarterly and annual total.
π‘ Flag any month where projected revenue relies on more than 30% from a single deal. That concentration is a risk that should be visible in the forecast, not hidden in the total.
Disaggregate the total by the dimension most useful for accountability β typically by sales rep or territory for a B2B team. Check that each rep's forecast sums correctly to the total.
π‘ Ask each rep to submit their own commit number before you build the top-down view. Comparing bottoms-up rep commits to your top-down model reveals alignment gaps early.
List every variable the forecast depends on β win rate, average deal size, sales cycle, ramp time, churn rate β in the assumptions section. State the source and time period for each.
π‘ If a single assumption swings the forecast by more than 10%, flag it as a key risk and build a sensitivity row showing the impact of a 20% change in that variable.
Create three versions of the total projection: base (most likely), upside (2β3 favorable outcomes), and downside (2β3 adverse outcomes). The range between downside and upside is your planning band.
π‘ The downside scenario should reflect a realistic bad quarter, not a catastrophic one. If hitting downside requires layoffs or a pivot, it belongs in a separate contingency plan.
Lock the forecast at the start of each period, then update actuals weekly or monthly as results come in. Record the original forecast number before overwriting it β you need the variance data to calibrate future forecasts.
π‘ A forecast that is never wrong is a forecast that is always being revised to match actuals. Measure forecasting accuracy over 4β6 quarters to hold the process accountable.
A sales forecast is a projection of expected revenue over a future period β typically monthly, quarterly, or annually β built from pipeline data, historical performance, and stated assumptions about win rates, deal sizes, and market conditions. It gives sales leaders, finance teams, and executives a shared number to plan hiring, spending, and inventory around, and a baseline to measure actual performance against.
The three most common methods are pipeline-weighted forecasting (applying stage-based win rates to open opportunities), historical trend analysis (projecting forward from actual revenue growth rates), and top-down market share modeling (starting from total market size and estimating capture rate). Most B2B sales teams use a pipeline-weighted approach as their primary method, validated against historical trend as a sanity check.
Most businesses maintain a rolling 12-month forecast updated monthly or quarterly. For annual planning and budgeting, a 3-year view is standard. The practical limit on accuracy is roughly one full sales cycle ahead β if your average deal takes 90 days to close, a 90-day forecast is reasonably reliable; a 12-month forecast for the same business is directional at best and should be treated as a planning range rather than a commitment.
At minimum: 12β24 months of actual revenue by period, an up-to-date pipeline with deal stage and estimated close date, your historical win rate by stage, average deal size, and average sales cycle length. For SaaS or subscription businesses, add churn rate and net revenue retention. The quality of your CRM data is the single biggest constraint on forecast accuracy β garbage in, garbage out.
A sales plan defines targets, strategies, headcount, and go-to-market tactics for achieving a revenue goal β it is prescriptive. A sales forecast projects what is actually likely to happen given current pipeline and market conditions β it is predictive. The two documents should reference each other: the plan sets the target, the forecast tracks progress toward it, and the variance between them drives tactical adjustments.
Best-in-class B2B sales organizations forecast within plus or minus 5% of their quarterly commit. A variance of 10β15% is acceptable for most teams. Consistently missing by more than 20% signals a structural problem β typically unreliable CRM data, poor stage definitions, or sales reps sandbagging their commits. Tracking forecast accuracy over 4β6 quarters is the only way to identify and fix systemic bias.
Coverage ratio is total pipeline value divided by the revenue target for a period. A 3Γ coverage ratio means you have $3 of pipeline for every $1 of target. This ratio matters because even well-managed pipelines do not close at 100% β you need enough volume to absorb slippage and still hit the number. Teams with less than 2Γ coverage at the start of a quarter are almost always at risk of missing their target.
For most B2B sales teams, a weekly pipeline review with a formal forecast update at the end of each month is the standard cadence. The original forecast for each period should be locked at the start and not overwritten β actuals are recorded in a separate column so variance can be calculated and tracked. A forecast that changes every week without locking a baseline is a running guess, not a management tool.
No. A sales forecast template structures the output β the projection tables, assumptions, and variance tracking β but the underlying deal data should live in a CRM (Salesforce, HubSpot, Pipedrive, or similar). The template is most useful for synthesizing CRM data into a presentation-ready document for leadership, board meetings, or investor updates, and for documenting the assumptions and scenarios that a CRM report alone does not capture.
A sales plan defines the strategy, targets, headcount, and tactics for hitting a revenue goal β it is prescriptive and forward-looking. A sales forecast projects the revenue that is actually likely to materialize given current pipeline and market conditions β it is predictive. The plan sets the destination; the forecast tells you whether you are on track to reach it. Both documents belong in the same planning cycle.
A sales report documents what happened in a completed period β closed deals, revenue attained, quota performance, and pipeline movement. A sales forecast projects what will happen in a future period. Reports feed forecasts: the actuals from last quarter's report become the historical baseline for this quarter's forecast. They are sequential, not interchangeable.
Financial projections cover the full P&L, cash flow, and balance sheet across all revenue and cost lines. A sales forecast focuses exclusively on the top line β units sold or revenue by segment β and feeds into the broader financial model. For investor or board presentations, a sales forecast is typically the source document that the revenue line in the financial projections is built from.
A business plan is a comprehensive document covering market analysis, competitive positioning, team, strategy, and financials for an external audience β investors, lenders, or partners. A sales forecast is one operational input to a business plan, focused specifically on revenue mechanics. You typically extract and simplify the sales forecast when building the revenue section of a business plan.
MRR/ARR growth, churn rate, expansion revenue from upsells, and new logo acquisition are all modeled separately before rolling into a single net revenue forecast.
Forecasts drive production scheduling, raw material purchasing, and warehouse capacity planning β a 15% miss translates directly into excess inventory or stockouts.
Revenue projections are tied to billable hours and utilization rates; a services forecast must account for project start dates, staff availability, and scope-change risk.
Seasonal demand curves, promotional lift factors, and average order value trends are the primary forecast drivers, with monthly granularity essential for inventory planning.
| Path | Best for | Cost | Time |
|---|---|---|---|
| Use the template | Sales managers, small business owners, and founders building their first structured revenue projection | Free | 2β4 hours to complete the first forecast; 30β60 minutes for monthly updates |
| Template + professional review | Teams preparing a forecast for a board meeting, investor update, or bank loan application | $200β$800 for a finance consultant or fractional CFO review | 1β2 days |
| Custom drafted | Enterprise sales organizations integrating a forecast model with CRM data, ERP systems, or complex multi-segment revenue structures | $2,000β$10,000 for a custom financial modeling engagement | 2β6 weeks |
This document is one of 3,000+ business & legal templates included in Business in a Box.
Access over 3,000+ business and legal templates for any business task, project or initiative.
Customize your ready-made business document template and save it in the cloud.
Share your files and folders with your team. Create a space of seamless collaboration.
"Fantastic value! I'm not sure how I'd do without it. It's worth its weight in gold and paid back for itself many times."
"I have been using Business in a Box for years. It has been the most useful source of templates I have encountered. I recommend it to anyone."
"It has been a life saver so many times I have lost count. Business in a Box has saved me so much time and as you know, time is money."
Stop downloading documents. Start operating with clarity. Business in a Box gives you the Business Operating System used by over 250,000 companies worldwide to structure, run, and grow their business.
Start freeΒ Β·Β No credit card required
