How to Create a Sales Forecast: Methods, Example and Template

Learning how to create a sales forecast helps you plan hiring, stock, marketing spend and cash with far more confidence than a gut feeling. You do not need complex software or a finance degree: a simple, honest forecast built from your own data is enough for most small businesses. In this guide you will learn what a sales forecast is, why it matters, five forecasting methods, a 7-step process, a worked example, common mistakes, how to measure accuracy and a template you can copy.

✔ Key takeaways

⏱ About 8 min read · the short version is right here

  • A sales forecast estimates how much you will sell over a set period, usually month by month for the next 12 months.
  • Pick a method that fits your data: past sales, sales pipeline, lead-driven or market-based forecasting.
  • Build the forecast from units and prices per product line, then add recurring revenue from existing customers.
  • Always prepare a best case and a worst case, and write down the assumptions behind each number.
  • Compare forecast with actual sales every month and adjust; accuracy improves quickly with practice.

Have a specific question? Jump to FAQ →

What is a sales forecast?

A sales forecast is an estimate of the revenue your business expects to earn over a future period. Most small businesses forecast monthly for the next 12 months, then update it every month as real results come in.

A good forecast is not a target or a wish. Targets say what you want to sell; a forecast says what you realistically expect to sell based on evidence. Keeping the two separate stops you from hiring or spending against numbers that were never likely.

📌 Forecast vs budget

The sales forecast feeds your budget and cash flow plan. Expenses, hiring and stock decisions all depend on it, so start here before you plan spending.

Why small businesses need one

Cash

Avoid cash surprises

Knowing quiet months in advance lets you build a buffer. Pair your forecast with a plan to improve cash flow.

Plan

Hire and buy at the right time

A forecast shows when demand will rise, so you hire, order stock or add capacity before you are overwhelmed.

Funding

Win over lenders

Banks and investors expect a realistic forecast in your business plan, with clear assumptions.

A forecast also makes your goals measurable. If you set quarterly OKRs, the sales forecast tells you whether the target is a stretch or simply business as usual.

5 sales forecasting methods

MethodHow it worksBest for
Historical (past sales)Use last year’s sales for the same month, adjusted for growth and known changesBusinesses with at least 12 months of sales data
PipelineMultiply each open deal by its win probability for its stageB2B, agencies and consultants with a sales pipeline
Lead-drivenExpected leads × conversion rate × average order valueOnline businesses that track traffic and conversions
Market-based (top-down)Estimate your share of a defined marketNew businesses with no sales history
Bottom-up capacityWhat your team, stock or hours can realistically deliverService businesses limited by time or staff

Many small businesses combine two methods. For example, an agency might use the pipeline method for the next three months and historical trends for the rest of the year. If you use a pipeline, my guide on how to build a sales pipeline shows how to set stages and win rates.

⚠️ Be careful with top-down forecasts

“We only need 1% of a huge market” is the classic forecasting trap. Market share is earned customer by customer, so always cross-check a top-down estimate with a bottom-up view of leads and conversions.

Five sales forecasting methods shown as flat geometric icons for past sales history, sales pipeline, lead funnel, market size and team capacity

Five sales forecasting methods side by side: historical trend, pipeline, lead-driven, market-based and capacity.

↑ Back to contents

How to create a sales forecast in 7 steps

1

Choose the period and level of detail

Forecast monthly for 12 months. Split by product or service line so you can see what drives the total.

2

Gather your data

Export past sales, current pipeline, website traffic, lead numbers and conversion rates from your accounts, CRM and analytics.

3

Pick your method

Use historical data if you have it, the pipeline method for big-ticket B2B deals and lead-driven forecasting for online sales.

4

Estimate units or customers per month

Work out how many sales you expect each month, adjusting for seasonality, holidays and planned campaigns.

5

Multiply by average price

Use price excluding VAT or sales tax and include planned price changes. Add recurring revenue from existing customers separately.

6

Create best and worst cases

Adjust key assumptions up and down, for example conversion rate or deal win rate, to show a realistic range.

7

Write down assumptions and review monthly

List every assumption next to the numbers, then compare forecast with actual sales at the end of each month and update.

💡 Start with what you control

Leads, conversion rate and average order value are the three levers behind most forecasts. If you know them, you can explain and improve every number in your forecast.

↑ Back to contents

Sales forecast example

Here is a simple lead-driven forecast for a small online course business for one quarter. All figures are illustrations to show the method, not benchmarks.

MonthExpected leadsConversion rateNew salesAverage priceForecast revenue
January1,0002%20$200$4,000
February1,2002%24$200$4,800
March (launch campaign)2,0002.5%50$200$10,000

The quarter totals $18,800. A worst case might assume a 1.5% conversion rate and 20% fewer leads in March, while a best case might assume the launch converts at 3%. Showing all three gives a far more useful picture than a single number.

For a B2B service, the pipeline method works the same way: a $10,000 proposal at 50% probability contributes $5,000 to the forecast, and a $6,000 early-stage lead at 10% contributes $600.

A sales forecast drawn as flat geometric monthly bars with an expected line and a shaded best case and worst case range around it

A sales forecast example shown as monthly bars with a best case and worst case range around the expected line.

↑ Back to contents

Forecasting recurring and seasonal sales

Two patterns trip up many sales forecasts: recurring revenue and seasonality. Both are easy to handle once you separate them from one-off sales.

Recurring revenue. If you sell subscriptions, retainers or memberships, forecast them on their own line. Start with current monthly recurring revenue, subtract expected cancellations (your churn rate from recent months) and add expected new subscribers. For example, 200 members at $30 a month with 4% monthly churn lose about 8 members a month unless new sign-ups replace them.

Seasonality. Compare each month with the average month over the last one or two years. If December sales are usually 1.5 times your average month and August is 0.7 times, apply those seasonal factors to your baseline. Retailers often see peaks around Black Friday and the holidays, B2B firms often slow down in August in Europe and in late December, and tax or wedding businesses have their own calendars.

💡 Plan campaigns into the forecast

Product launches, email promotions and price changes are known in advance. Add them to the months they happen, with their own assumption, instead of hoping they show up in the average.

↑ Back to contents

Common forecasting mistakes

  • Confusing targets with forecasts: a forecast built backwards from a goal is not evidence-based.
  • Ignoring seasonality: December, summer holidays and Black Friday change demand sharply in many sectors.
  • One single number: without a range, you cannot plan for a bad month.
  • Forgetting churn and refunds: recurring revenue falls when customers leave; read my customer retention strategies to reduce it.
  • Never updating it: a forecast written in January and never revisited is out of date by March.
  • Including VAT or sales tax: forecast net revenue, because tax collected is not yours.

↑ Back to contents

How to track forecast accuracy

At the end of each month, compare actual sales with the forecast. Forecast accuracy is commonly measured as variance: (actual − forecast) ÷ forecast × 100. If you forecast $10,000 and sell $9,000, your variance is −10%.

What you seeWhat it usually meansWhat to do
Consistently under forecastAssumptions too optimisticLower conversion rates or win probabilities
Consistently over forecastAssumptions too cautiousRaise estimates and plan more capacity
Large swings both waysNot enough data or unclear driversForecast by product line and track leads weekly

Add forecast accuracy to your list of small business KPIs. It also helps you judge marketing spend: if you know your customer acquisition cost, you can forecast how many customers extra budget should bring.

↑ Back to contents

Sales forecast template

Copy this sales forecast template into a spreadsheet, with one row per product line and one column per month.

Monthly sales forecast template

Month: [month and year]
Product or service line: [name]
Expected units or new customers: [number] (based on: [history / pipeline / leads])
Average price, excluding VAT or sales tax: [$ / €]
Forecast revenue = Units × Average price: [result]
Recurring revenue from existing customers: [$ / €]
Total forecast: [sum]
Best case / worst case: [result] / [result]
Key assumptions: [conversion rate, seasonality, price changes, launches]
Actual result and variance: [fill in at month end]

Keep the assumptions box filled in. When a forecast misses, the assumptions show you exactly what to fix next time.

↑ Back to contents

Frequently Asked Questions

What is the simplest way to create a sales forecast?

Take last year’s sales for each month, adjust them for expected growth and known changes such as price increases or new products, then compare with actual sales every month.

How far ahead should a small business forecast sales?

Twelve months, broken down by month, is the most common. Many businesses also keep a rough three-year view for funding and planning.

How do I forecast sales for a new business with no history?

Use a lead-driven or bottom-up method: estimate traffic or outreach, a realistic conversion rate and your average price. Cross-check against competitors and market size, and keep the forecast conservative.

What is the difference between a sales forecast and a sales target?

A forecast is your realistic expectation based on evidence. A target is the result you want to achieve. Plan spending against the forecast and use the target to motivate the team.

How accurate should a sales forecast be?

Accuracy improves with data and practice. Aim to narrow the gap between forecast and actual each month, and use best and worst case ranges rather than expecting a perfect single figure.

Which tools can I use for sales forecasting?

A spreadsheet is enough to start. As you grow, a CRM with deal stages and win probabilities makes pipeline forecasting faster and more reliable.

Now you know how to create a sales forecast, which method fits your business and how to keep it accurate. Build your first 12-month forecast with the template above, write down your assumptions and review it every month: within a few months you will plan with numbers you can trust.