Sales Forecast: What It Is and How to Create One
Make the estimate. Record the assumptions. Learn from the difference.
A close total. A different mix.
September at a hypothetical repair shop.
On this page
A sales forecast is an estimate of how much a business expects to sell during a defined future period. It may predict units, revenue, or both. The estimate uses available evidence, such as past sales, current orders, seasonal patterns, sales activity, capacity, and stated assumptions, to provide a realistic view of likely results.
A forecast does not promise what will happen. Its purpose is to help a business prepare, monitor change, and make better decisions as new information arrives.
The idea to remember
Forecast what you expect, not what you hope. Then compare it with what actually happens.
What is a sales forecast?
A sales forecast predicts likely sales for a specific week, month, quarter, or year. A small company might forecast monthly revenue by product or service. A sales team might estimate the value of deals expected to close this quarter.
Why does it matter?
A sales forecast gives other parts of the business a practical starting point for planning.
- Cash and budgets: Expected sales influence spending plans and cash needs.
- Staffing and capacity: Managers can prepare enough people, equipment, or appointment slots.
- Inventory and purchasing: Product businesses can order closer to expected demand.
- Sales management: Teams can identify gaps early and focus on the activities that drive sales.
The forecast also creates a baseline. Comparing forecast sales with actual sales helps managers spot changes, question assumptions, and respond sooner.
How it works
A basic sales forecast has five elements:
- A defined period. Choose the month, quarter, or other period being forecast.
- A clear scope. Decide whether to forecast the whole business or separate products, services, locations, or channels.
- Relevant evidence. Use past sales, confirmed orders, active opportunities, seasonality, price changes, capacity, and market conditions when available.
- Explicit assumptions. Record what must be true for the estimate to make sense, such as expected customer volume or an unchanged selling price.
- Regular review. Compare the estimate with actual results and revise future periods when the evidence changes.
For a simple business, the main calculation can be:
The calculation
Forecast sales revenue = expected units sold x average selling price
Calculate each useful product or service category separately, then add the results. This shows whether a change comes from expected volume, price, or both.
A simple example
Hypothetical example: A bicycle repair shop is forecasting sales for September. It groups work into two services rather than forecasting every repair type.
| Service | Expected units | Average price | Forecast revenue |
|---|---|---|---|
| Standard tune-ups | 120 | EUR 40 | EUR 4,800 |
| Major repairs | 30 | EUR 90 | EUR 2,700 |
| Total | EUR 7,500 |
The owner checks whether the estimate is realistic. In this hypothetical example, last September's sales were similar, current bookings support the expected workload, and the workshop has enough mechanic hours. The owner records those assumptions.
At the end of September, the shop completes 110 tune-ups and 35 major repairs. Actual sales are EUR 4,400 + EUR 3,150 = EUR 7,550. The total is close to the forecast, but the service mix is different.
| Service | Forecast revenue | Actual revenue | Actual minus forecast |
|---|---|---|---|
| Standard tune-ups | EUR 4,800 | EUR 4,400 | -EUR 400 |
| Major repairs | EUR 2,700 | EUR 3,150 | +EUR 450 |
| Total | EUR 7,500 | EUR 7,550 | +EUR 50 |
That detail may affect staffing, parts purchasing, and the next forecast. A small net difference does not mean each category performed as expected.
Compare the forecast with actual sales
+0.67% versus forecast. Review the category mix, not only the total.
| Service | Forecast | Actual | Difference |
|---|---|---|---|
| Standard tune-ups | EUR 4,800 | EUR 4,400 | -EUR 400 |
| Major repairs | EUR 2,700 | EUR 3,150 | +EUR 450 |
When should you use it?
Create or update a sales forecast when:
- Preparing a monthly or annual operating plan.
- Deciding how much inventory or capacity to arrange.
- Estimating near-term cash inflows and expenses.
- Reviewing whether current sales activity supports likely results.
- Planning a new product, service, location, or sales period.
- Responding to a meaningful change in price, demand, competition, or capacity.
A monthly forecast is a practical starting cadence for many small businesses. Sales teams with active deals may review a shorter-term forecast weekly.
How to interpret the result
Treat the forecast as the best current estimate, not a guarantee. Ask what evidence supports it, how sensitive it is to key assumptions, and what would cause it to change.
Then compare forecast with actual sales for the same categories and period. A small difference may be normal. A repeated shortfall may signal optimistic assumptions, weaker demand, delayed deals, or limited capacity. Repeated results above forecast may mean demand is stronger than expected or the method is too conservative.
The direction and cause of the difference matter more than celebrating or blaming one isolated number. Update the next forecast with what you learn.
Common confusion
| Term | What it means |
|---|---|
| Sales forecast | What the business currently expects to achieve, based on evidence. |
| Sales target | What the business wants the team to achieve, which may be intentionally ambitious. |
| Sales pipeline | Individual opportunities moving toward a purchase. An input to the forecast, not the forecast itself. |
A forecast should remain evidence-based even when it falls below the target. Pipeline data may inform it, but the forecast summarizes expected sales for a defined period.
Revenue is also different from gross profit, which subtracts the cost of goods sold. Sales are not automatically cash collected; payment timing matters when planning cash needs.
Common mistakes
- Starting with the target: Turning a desired number into the forecast without supporting evidence.
- Hiding assumptions: Publishing a total without explaining the expected volume, price, timing, or conversion behind it.
- Using stale information: Leaving delayed deals, cancelled orders, or changed prices untouched.
- Choosing the wrong detail: Using one broad total that cannot explain differences, or so many categories that updates become unmanageable.
- Ignoring actual results: Failing to compare the forecast with what the business really sold.
- Treating it as certain: Making commitments without considering uncertainty or alternative outcomes.
Limitations
A sales forecast depends on the quality of its inputs and assumptions. Historical patterns can stop being useful when prices, competition, customer behavior, capacity, or the wider market changes. New businesses have less evidence, and long-range forecasts usually carry more uncertainty. The forecast supports judgment; it does not replace it.
Quick checklist
A completed checklist does not make the forecast certain.
Put it to work
Build a one-month sales forecast in 25 minutes
- Choose next month and list two to four main product or service categories.
- For each category, estimate units using recent sales, bookings, active opportunities, seasonality, and capacity.
- Write the expected average selling price.
- Multiply expected units by price, then add the category totals.
- Record three assumptions that could materially change the result.
- Schedule a 15-minute review after month-end to compare forecast and actual sales by category.
Finish with one sentence: Our forecast is most likely to be wrong if ______ changes.
Key takeaways
- A sales forecast estimates likely sales for a defined future period.
- It should be based on evidence, clear sales drivers, and visible assumptions.
- A simple forecast can multiply expected units by average selling price.
- A forecast is an expectation; a sales target is a desired result.
- Regular comparison with actual sales makes future forecasts more useful.
Final takeaway
A sales forecast turns available evidence into a practical estimate of future sales. Keep the period, categories, calculation, and assumptions clear. Then review actual results and revise the estimate as conditions change.
The value is not in predicting the future perfectly. It is in seeing gaps earlier and making better operating decisions before those gaps become problems.