Sales Forecast: 5 Methods + a Worked Example (2026)

Quick answer: A sales forecast is an estimate of how much you will sell over a future period, usually month by month for the next 12 months. Small businesses build one from past sales, the sales pipeline, or a bottom-up model of leads, conversion rate and average sale, then adjust for seasonality and capacity.

A good sales forecast drives almost every other plan: how much stock to buy, when to hire, how much cash you will have and whether you can afford a loan. This guide explains five practical forecasting methods, works through a full 12-month example and gives you a simple template you can copy into a spreadsheet.

What is a sales forecast?

A sales forecast projects future revenue, usually by month and often by product or customer group. It is the top line of your projected profit and loss statement and the starting point of your cash flow forecast. Lenders reviewing a business plan look at the sales forecast first, because every other projection depends on it.

A forecast is not a target. A target is what you want; a forecast is what you realistically expect. Keep both, but plan spending on the forecast.

Sales forecasting methods for small businesses

Method	How it works	Best for
Historical growth	Last year's monthly sales times an expected growth rate	Established businesses with stable demand
Bottom-up (unit) forecast	Leads x conversion rate x average sale, capped by capacity	New businesses, service businesses
Pipeline forecast	Open deals x probability of closing	B2B, agencies, contractors with quotes out
Moving average	Average of the last 3 or 6 months	Short-term planning, steady sales
Seasonal index	Average month x each month's seasonal factor	Seasonal businesses (landscaping, retail, events)

1. Historical growth method

Take each month's sales from last year and multiply by 1 plus your expected growth rate. If March last year was $20,000 and you expect 8% growth, forecast $21,600. Adjust for known one-offs, such as a large client you have lost.

2. Bottom-up forecast

Multiply the number of potential customers you can reach by the share who buy and by the average sale. Then check it against capacity: a solo cleaner cannot clean 200 homes a week, however strong demand is.

3. Pipeline forecast

List every open quote with its value and a realistic probability of winning. A $10,000 quote at 40% contributes $4,000 to the forecast. Use your actual quote win rate from past quotes and estimates, not a hopeful guess.

4. Moving average

Average the last three months to forecast the next. It smooths noise but lags behind turning points.

5. Seasonal index

Divide each month's sales by the average month to get an index. Multiply your forecast average month by each index to spread annual sales realistically.

Worked example: a 12-month sales forecast

Sam starts a residential window cleaning business in January (see our window cleaning invoice template for how jobs are billed). He uses a bottom-up method with seasonality.

• Average job: $220.
• Capacity: 4 jobs a day, 5 days a week, about 80 jobs a month at full capacity.
• Marketing reaches 400 households a month; 3% book a first job in the first months, rising to 5% as reviews accumulate.
• 40% of customers rebook each quarter.
• Spring and early summer are busiest; December and January are slow.

Month	Forecast jobs	Forecast sales
Jan	12	$2,640
Feb	16	$3,520
Mar	28	$6,160
Apr	42	$9,240
May	55	$12,100
Jun	60	$13,200
Jul	52	$11,440
Aug	48	$10,560
Sep	50	$11,000
Oct	45	$9,900
Nov	30	$6,600
Dec	18	$3,960
Total	456	$100,320

Peak months stay below the 80-job capacity, which makes the forecast believable. Sam invoices commercial clients on net 15 terms, so in his cash flow forecast about 30% of each month's sales arrive the following month. If you offer longer terms, read about days sales outstanding to model the delay.

How to build a sales forecast: step by step

1. Choose the period and detail. 12 months, monthly, split by your main products or services.
2. Gather data. Past invoices, website traffic, inquiries, quote win rates, competitor prices.
3. Pick a method. Historical for existing businesses, bottom-up for new ones, pipeline for B2B.
4. Apply seasonality. Use your own history or industry patterns.
5. Cap by capacity. Staff hours, equipment, inventory and your own time.
6. Write down assumptions. Price, conversion, rebooking rate, new hires.
7. Create three scenarios. Conservative, expected and optimistic. Plan cash on the conservative one.
8. Review monthly. Compare forecast with actual invoiced sales and update. Our budget vs actual guide shows how to analyze variances.

What data do you need for an accurate sales forecast?

The quality of a forecast depends on its inputs. Collect these before you open the spreadsheet:

• Invoice history: at least 12 months of sales by month, product and customer, if the business is running. Clean, numbered invoices make this easy to export.
• Lead data: website visits, calls, inquiries and quote requests per month, plus where they came from.
• Conversion rates: the share of inquiries that became quotes and of quotes that became jobs.
• Average sale and repeat rate: how much a typical customer spends and how often they come back.
• Capacity: billable hours, staff, equipment and stock limits.
• Known changes: planned price rises, new products, lost or new large clients, marketing campaigns.
• External factors: seasonality, local events, economic conditions in your customer base.

For a new business with none of this history, use test sales, pre-orders, competitor observation and industry benchmarks, and mark every assumption clearly so you can replace it with real data within the first three months.

Simple sales forecast template

Copy these columns into a spreadsheet:

Month	Leads	Conversion %	New customers	Repeat customers	Average sale	Forecast sales	Actual sales	Variance
Jan	400	3%	12	0	$220	$2,640
Feb	400	3%	12	4	$220	$3,520

Fill "Actual sales" from your invoice records each month. A consistent invoice numbering system, such as one from our invoice number generator, makes it easy to total sales by month.

How to turn a sales forecast into a cash forecast

Sales and cash rarely land in the same month. Convert forecast sales into expected receipts using your real collection pattern. Suppose Sam's records show 70% of sales are paid in the month of the job (card and same-day payments) and 30% the month after (invoiced customers).

Month	Forecast sales	70% this month	30% from last month	Expected cash in
Jan	$2,640	$1,848	$0	$1,848
Feb	$3,520	$2,464	$792	$3,256
Mar	$6,160	$4,312	$1,056	$5,368
Apr	$9,240	$6,468	$1,848	$8,316

In a growing business, cash always lags sales. That gap is why fast-growing companies can run short of money while profitable on paper. Reduce it by invoicing on completion, taking deposits and offering card payments. Our cash flow management guide covers more tactics.

Scenario planning: conservative, expected and optimistic

A single number hides risk. Build three versions by changing the two or three assumptions you are least sure about.

Assumption	Conservative	Expected	Optimistic
Conversion rate	2%	3% rising to 5%	5%
Average job	$200	$220	$240
Rebooking rate	30%	40%	50%
Annual sales	About $70,000	$100,320	About $125,000

Set fixed costs, loan payments and owner draws so the business survives the conservative case. Treat the optimistic case as upside, not a plan. If the conservative case does not cover costs, change the plan before you launch, not after.

How to measure forecast accuracy

Each month, calculate the variance: actual sales minus forecast, divided by forecast. Over a year, average the absolute percentage errors (this is the mean absolute percentage error, or MAPE). A falling MAPE means your assumptions are improving. Also look for bias: if you are below forecast eight months out of twelve, your assumptions are systematically too optimistic and need to come down.

• Under forecast, demand problem: fewer leads or lower conversion. Look at marketing and pricing.
• Under forecast, capacity problem: demand was there but you could not deliver. Consider hiring your first employee.
• Over forecast: great, but check whether it was a one-off before raising the whole forecast.

Forecasting tips by business type

• Retainer and subscription businesses: forecast active clients times monthly fee, minus expected churn, plus new sign-ups. Our guide to customer lifetime value helps estimate churn.
• Project businesses (contractors, agencies): use the pipeline method and spread large projects across months using milestone or progress billing dates.
• Retail and e-commerce: forecast traffic times conversion rate times average order value, with strong seasonality around holidays.
• Startups: combine a bottom-up model with your startup costs to see how many months of reserve you need.

Common sales forecasting mistakes

• Hockey-stick growth. Doubling every month rarely happens. Ramp up gradually.
• Ignoring capacity. Sales cannot exceed what you can produce or deliver.
• Confusing sales with cash. Payment terms and late payers delay cash.
• Using a target as the forecast. Plan spending on realistic numbers.
• Forgetting churn. Subscription and repeat businesses lose customers each month.
• Never updating. A forecast is a living document; review it monthly.
• Ignoring price changes. If you plan to raise prices, model the effect on both price and volume.

Example: a pipeline sales forecast for a B2B service

Priya runs a small IT support company that wins most work through quotes. Her pipeline at the start of the quarter looks like this, with probabilities based on her past win rate at each stage:

Client	Quote value	Stage	Probability	Weighted value
Dental clinic network setup	$8,500	Verbal yes	80%	$6,800
Law firm managed services (3 months)	$7,200	Proposal sent	40%	$2,880
Retailer POS upgrade	$4,000	Proposal sent	40%	$1,600
Accounting firm security audit	$3,500	First meeting	15%	$525
Existing monthly contracts	$12,000	Signed	100%	$12,000
Quarter forecast	$35,200			$23,805

The forecast is $23,805, not the $35,200 total of all quotes. Priya updates probabilities weekly as deals move. When a deal is won she invoices the deposit right away, which turns forecast sales into cash faster. Tracking win rates by stage over time is what makes this method accurate.

Using the forecast to make decisions

Once you trust your sales forecast, use it to plan stock purchases, set a hiring date, size a line of credit for slow months and check your break-even point. Compare forecast margins with industry profit margin benchmarks to see whether the plan is realistic.

A sales forecast does not need complex software: a clear method, honest assumptions and monthly comparison with real invoices will make it more accurate every month. To record each sale cleanly, use our free invoice generator, which needs no sign-up and downloads a PDF invoice created in your browser.