How to Create a Sales Forecast for a Small Business

A Practical Guide to Predicting Revenue, Planning Growth and Making Better Business Decisions

How much revenue is your business likely to generate over the next 12 months?

Not how much you'd like to generate.

Not the figure you've put in your business plan.

And not simply last year's turnover plus another 20%.

But a realistic estimate based on:

Your existing customers.
Your current sales pipeline.
The number of new enquiries you receive.
Your sales conversion rate.
Your average sale value.
Repeat purchases and recurring income.
Seasonal patterns.
Your business's capacity to deliver.

Many SME business owners set ambitious sales targets but don't have a reliable method of forecasting whether those targets are achievable.

They might say:

"We want to increase turnover from £400,000 to £500,000 next year."

That's a goal.

But where will the additional £100,000 come from?

How many customers will you need?

How many enquiries will you need to generate?

How many of those enquiries must become paying customers?

Can your business deliver the additional work?

And will the increased revenue generate enough profit and cash?

These are the questions a good sales forecast should help you answer.

Sales forecasting isn't about predicting the future perfectly. It's about making better decisions using the information available today.

In this guide, we'll explore how to create a practical sales forecast for your SME, including the calculations, methods, examples and management routines that make forecasting useful.

What Is a Sales Forecast?

A sales forecast is an estimate of the revenue your business expects to generate over a future period.

That period might be:

The next 30 days.
The next quarter.
The next six months.
The next 12 months.

A forecast should be based on reasonable assumptions and available evidence rather than simply what the business owner hopes will happen.

For example, if your business consistently receives 100 enquiries each month, converts 25% into customers and generates an average sale value of £800, you have a starting point for forecasting new customer revenue.

The calculation is:

Enquiries × Conversion Rate × Average Sale Value = Forecast Sales Revenue

In this example:

100 × 25% × £800 = £20,000

That suggests £20,000 of potential monthly revenue from those enquiries, assuming they convert into sales within the forecast period.

You would then need to consider existing customers, repeat business, seasonality, sales timing and other relevant factors.

Why Is Sales Forecasting Important for SME Businesses?

A sales forecast helps you plan ahead rather than react to what happens.

Without one, business decisions can become guesswork.

Should you recruit another employee?

Can you afford to increase marketing?

Will you have enough work for your team?

Should you purchase new equipment?

Is the business on track to achieve its growth target?

A forecast helps you answer these questions with greater confidence.

Five Benefits of Sales Forecasting

1. Better financial planning

You can estimate future revenue and use it to develop profit and cash flow forecasts.

2. More effective marketing

You can calculate how many leads are required to support your sales targets.

3. Improved staffing decisions

You can anticipate workload and capacity requirements.

4. Earlier identification of problems

If future sales are likely to fall below target, you can act sooner.

5. Greater accountability

You can compare expected sales with actual results and understand why differences occur.

Sales Forecast vs Sales Target – What's the Difference?

This distinction is important.

Sales Target

A sales target is what you want to achieve.

For example:

£600,000 annual turnover.

Sales Forecast

A sales forecast is what you realistically expect to achieve based on current information.

For example:

£525,000 expected annual turnover.

The difference is:

£75,000

That's your projected gap.

Now you can ask:

What would need to change to close that gap?

You might need more enquiries, better conversion, higher average sale values or stronger customer retention.

Your target gives you direction. Your forecast tells you where you're currently heading.

Sales Forecast vs Cash Flow Forecast

These are two different tools.

A sales forecast estimates when revenue is expected to be generated or recognised.

A cash flow forecast estimates when money is expected to enter and leave the business.

For example:

You complete a £10,000 project in March.

The customer has 60 days to pay.

Depending on the applicable accounting treatment, the sale may be recognised in March.

But the customer payment might not arrive until May.

Your sales forecast and cash flow forecast must reflect that difference.

This is why a business can achieve its sales targets but still experience cash flow problems.

Five Sales Forecasting Methods for Small Businesses

Different businesses need different approaches.

You may use one method or combine several.

1. Historical Sales Forecasting

This uses previous sales performance to estimate future revenue.

For example:

Last year's sales:

£400,000

Expected growth:

10%

Forecast:

£440,000

This method is simple.

But it assumes historical performance remains relevant.

It may be less reliable if your business has changed significantly, lost a major customer or entered a new market.

2. Lead-Based Sales Forecasting

This uses the number of enquiries, conversion rates and average sale values.

Formula:

Leads × Conversion Rate × Average Sale Value

For example:

200 leads.

20% conversion.

£1,500 average sale.

Forecast:

200 × 20% × £1,500 = £60,000

This is useful for businesses that generate measurable enquiries.

3. Pipeline-Based Forecasting

This uses the value and probability of opportunities currently in your sales pipeline.

For example:

Opportunity

Potential Value

Estimated Probability Weighted Value

Customer A £10,00080 £8,000

Customer B £15,00050 £7,500

Customer C£8,00025 £2,000

Total£33,000

£17,500

Weighted value is calculated as:

Opportunity Value × Estimated Probability

This approach can help forecast sales from known opportunities.

However, probabilities should be based on evidence wherever possible, such as historical conversion rates by pipeline stage.

A weighted forecast is an expected-value estimate, not a guarantee that £17,500 will be won.

4. Recurring Revenue Forecasting

This is useful for businesses with subscriptions, retainers or ongoing contracts.

For example:

50 customers.

Average monthly fee:

£200

Monthly recurring revenue:

£10,000

You would then adjust for:

Expected cancellations.
New customers.
Upgrades.
Downgrades.
Contract changes.

For a membership business, forecasting customer retention can be just as important as forecasting new members.

5. Capacity-Based Forecasting

This is useful for businesses where revenue depends on available time, employees or production capacity.

For example:

A service business has:

4 employees

Each can deliver:

25 billable hours per week

Average realised hourly rate:

£60

Potential weekly revenue:

4 × 25 × £60 = £6,000

But that assumes all 25 hours per person are billable and sold.

You must also allow for holidays, sickness, administration, cancellations and demand.

A capacity forecast tells you what you could deliver. A demand forecast tells you what customers are likely to buy.

A realistic forecast considers both.

How to Create a 12-Month Sales Forecast – Step by Step

Step 1 – Review Your Previous Sales Performance

Start with the last 12 months of sales.

If available, review the previous two or three years as well.

Look at:

Monthly turnover.
Number of customers.
Average sale value.
New customer revenue.
Repeat customer revenue.
Recurring revenue.
Seasonal changes.
Lost customers.
Sales conversion rates.

Don't simply look at total turnover.

Understand what generated it.

For example, if annual sales increased by £100,000, was that because:

You gained more customers?

Existing customers spent more?

You increased prices?

You won one unusually large contract?

These factors affect how confidently you can forecast future performance.

Step 2 – Identify Your Revenue Streams

Many SMEs generate income from several sources.

For example, a business coaching company might have:

One-to-one coaching.
Group coaching.
Membership subscriptions.
Workshops.
Training programmes.

A commercial cleaning business might have:

Regular cleaning contracts.
One-off deep cleans.
Builders' cleans.
Specialist cleaning.
Additional services.

Forecast each significant revenue stream separately.

This gives you a clearer understanding of where growth is likely to come from.

Step 3 – Forecast Existing Customer Revenue

Start with customers you already have.

This is often more reliable than forecasting completely new business.

For example:

20 existing customers.

Average monthly spend:

£500

Expected monthly revenue:

£10,000

But consider:

Contracts ending.
Customer cancellations.
Expected price changes.
Reduced customer spending.
Seasonal changes.
Known project completions.

If three contracts are due to end, don't automatically assume all 20 customers will continue.

Step 4 – Forecast New Customer Enquiries

Now estimate how many new enquiries you're likely to receive.

Use historical data where possible.

For example:

MonthEnquiriesJanuary80February90March110April100May95June105

Six-month total:

580 enquiries

Average per month:

Approximately 97 enquiries

This gives you a starting point.

But don't ignore seasonality or planned changes in marketing.

If you intend to increase advertising, estimate its likely impact using previous results rather than assuming every additional pound will generate the same return.

Step 5 – Calculate Your Sales Conversion Rate

Your conversion rate shows what proportion of enquiries become customers.

Formula:

Customers Won ÷ Enquiries × 100

For example:

100 enquiries.

25 customers.

Conversion rate:

25%

If you forecast 120 enquiries next month and expect the same conversion rate:

120 × 25% = 30 new customers

The definition of an enquiry must be consistent.

A casual social media interaction is not necessarily equivalent to a qualified sales enquiry.

Step 6 – Calculate Your Average Sale Value

Formula:

Sales Revenue ÷ Number of Sales

For example:

£60,000 sales revenue.

40 sales.

Average sale value:

£1,500

Now combine this with your forecast customer numbers.

30 expected sales.

£1,500 average value.

Forecast revenue:

£45,000

If some customers buy more than once, distinguish transaction value from customer value so you don't double-count revenue.

Step 7 – Account for Your Sales Cycle

Not every enquiry becomes revenue immediately.

For example:

A customer enquires in January.

You send a quotation in February.

They accept in March.

The project is delivered in April.

Revenue may be recognised in April or over the delivery period, depending on the relevant accounting treatment.

If your sales process takes several weeks or months, a forecast that assumes all enquiries become revenue in the same month will be misleading.

Track the time between:

Enquiry → Sale Agreed → Work Delivered → Invoice → Payment

These are different stages.

Your sales forecast and cash flow forecast should reflect the appropriate timing.

Step 8 – Include Repeat Business

Some customers purchase more than once.

Imagine a business has:

100 existing customers.

30% are expected to make another purchase during the forecast period.

Average repeat purchase:

£600.

Expected repeat revenue:

100 × 30% × £600 = £18,000

This assumes one repeat purchase per returning customer.

If customers purchase multiple times, model frequency separately.

Be careful not to include repeat revenue already captured in your existing contract forecast.

Step 9 – Include Customer Retention and Churn

This is particularly important for membership and subscription businesses.

Imagine you have:

100 members.

Monthly membership fee:

£30.

Monthly recurring revenue:

£3,000

If you expect 5% of members to cancel each month, that affects future revenue.

A simplified monthly member forecast is:

Opening Members + New Members − Lost Members = Closing Members

You can then calculate expected revenue using the relevant billing assumptions.

For a growing membership business, don't just ask:

How many new members can we attract?

Also ask:

How many existing members are we likely to retain?

Step 10 – Consider Seasonality

Some businesses experience predictable seasonal patterns.

Examples include:

Garden and landscaping companies.
Retailers.
Travel businesses.
Heating engineers.
Air conditioning companies.
Hospitality.
Events businesses.

If December is historically quieter, don't simply divide annual sales by 12 and assume every month will be identical.

Use historical monthly patterns where appropriate.

Step 11 – Check Your Capacity

Your forecast might suggest you could generate £70,000 in monthly sales.

But can you actually deliver £70,000 of work?

Consider:

Employee availability.
Equipment.
Production capacity.
Supplier lead times.
Working hours.
Holidays.
Recruitment requirements.
Management capacity.

If your business can only deliver £50,000 of work with its current resources, a £70,000 forecast needs a capacity plan.

Step 12 – Create Three Forecast Scenarios

Avoid relying on one set of assumptions.

Create:

Conservative Forecast

Lower enquiry volumes, weaker conversion or slower sales.

Expected Forecast

Your most realistic estimate based on available evidence.

Optimistic Forecast

Stronger demand, improved conversion or additional opportunities.

For example:

Scenario Enquiries, Conversion, Average Sale

Forecast Revenue Conservative £1,000 £16,000

Expected £1,000 £25,000

Optimistic £1,000 £36,000

These examples assume sales convert into revenue during the period.

The purpose isn't to choose whichever figure you prefer.

It's to understand how different outcomes would affect the business.

Worked Example – A 12-Month Sales Forecast for an SME

Let's imagine a service business with two main revenue streams:

Existing customer contracts

and:

New customer projects

The business currently generates £15,000 per month from existing contracts.

It also expects new project sales.

For simplicity, assume all forecast project sales are delivered and recognised as revenue in the same month.

Month

Existing Contracts

New Project Revenue

Total Forecast

January £15,000 £10,000 £25,000

February £15,000 £12,000 £27,000

March £15,000 £15,000 £30,000

April £15,000 £13,000 £28,000

May £15,000 £16,000 £31,000

June £15,000 £18,000 £33,000

July £15,000 £14,000 £29,000

August £15,000 £12,000 £27,000

September £15,000 £19,000 £34,000

October £15,00 0£20,000 £35,000

November £15,000 £18,000 £33,000

December £15,000 £10,000 £25,000

Annual Total £180,000 £177,000 £357,000

This gives the business a forecast annual revenue of:

£357,000

Now compare that with the sales target.

Suppose the owner wants to achieve:

£400,000

The forecast gap is:

£43,000

Now you have something specific to work on.

How to Close a Sales Forecast Gap

If your target is £400,000 but your forecast is £357,000, you need an additional £43,000.

There are several possible ways to achieve this.

Option 1 – Generate More Enquiries

If your average new sale is £2,000 and your conversion rate is 25%, the number of additional enquiries required is:

£43,000 ÷ £2,000 ÷ 25% = 86 enquiries

That's approximately seven or eight additional enquiries per month.

This assumes those enquiries can be converted, delivered and recognised as revenue within the forecast year.

Option 2 – Improve Sales Conversion

If your business already receives plenty of enquiries, improving conversion may be more efficient than generating more leads.

For example:

100 enquiries per month.

Current conversion:

20%.

Average sale:

£1,000.

Current expected sales:

£20,000

If conversion improves to 25%:

£25,000

That's an additional:

£5,000 per month

Under the simplified assumptions.

Option 3 – Increase Average Sale Value

You might achieve this through:

Better pricing.
Additional services.
Upselling.
Cross-selling.
More suitable customer targeting.

But ensure the additional revenue also contributes profit.

Option 4 – Improve Customer Retention

Keeping more customers can protect existing revenue and reduce the pressure to replace lost business.

Option 5 – Develop Referral Marketing

Satisfied customers and referral partners may generate additional qualified enquiries.

Option 6 – Improve Sales Follow-Up

Some opportunities are lost because nobody follows up consistently.

A better follow-up process may increase conversion without additional advertising expenditure.

The purpose of the forecast is to identify which commercial levers you need to improve.

How to Create a Sales Forecast in Excel

You can build a simple sales forecast using Excel or Google Sheets.

For a lead-based forecast, create these rows:

RowDescription1Month2Expected enquiries3Conversion rate4Expected new customers5Average sale value6Forecast new customer revenue7Existing customer revenue8Repeat customer revenue9Total forecast revenue

Assume January is in Column B.

Expected new customers (B4):

=B2*B3

Forecast new customer revenue (B6):

=B4*B5

Total forecast revenue (B9):

=SUM(B6:B8)

Copy the formulas across the remaining months.

Format conversion rates as percentages and revenue figures as pounds sterling.

Make sure the three revenue categories don't overlap.

For a more accurate model, you may also need separate rows for sales timing, cancellations, discounts and delivery capacity.

Should Your Sales Forecast Include VAT?

For a typical business revenue forecast, sales should generally be presented excluding VAT where VAT is collected on behalf of HMRC.

For example:

A customer pays:

£1,200 including 20% VAT

The net sale is:

£1,000

The VAT element is:

£200

The exact accounting treatment depends on your business and applicable VAT arrangements.

A cash flow forecast, by contrast, should reflect the actual amounts expected to be received and paid, including VAT where applicable.

How Accurate Should a Sales Forecast Be?

No forecast will be perfectly accurate.

Customers change their minds.

Projects get delayed.

Markets change.

Competitors act.

Unexpected opportunities arise.

The objective is to make your forecast as useful and evidence-based as possible.

Compare forecast results with actual sales.

Then investigate the differences.

For example:

Forecast sales: £40,000

Actual sales: £34,000

Difference:

−£6,000

Ask:

Did we receive fewer enquiries?

Was conversion lower?

Was the average sale value lower?

Were projects delayed?

Did customers cancel?

The answers help improve your next forecast.

How Often Should You Update a Sales Forecast?

For many SMEs:

Weekly: Review pipeline activity and significant changes.

Monthly: Update the forecast with actual results and revise future assumptions.

Quarterly: Review trends, strategy, capacity and longer-term targets.

A business with large or rapidly changing sales opportunities may need more frequent updates.

How to Use Sales Forecasting to Plan Marketing

Suppose your business wants to generate £50,000 in monthly new customer revenue.

Average sale value:

£2,000

Required sales:

Conversion rate:

25%

Required enquiries:

100

Now you know your marketing needs to generate approximately 100 suitable enquiries per month, assuming the conversion and timing assumptions hold.

You can then work backwards.

Which channels will generate those enquiries?

How much will they cost?

How many are likely to be qualified?

Can your team handle the enquiries?

This connects your sales forecast to a practical marketing plan.

How to Use Sales Forecasting to Plan Recruitment

Imagine your forecast shows revenue increasing from:

£40,000 per month

to:

£60,000 per month

over the next six months.

That's a 50% increase.

Can your current team deliver the additional work?

You may need to:

Recruit.
Train employees.
Improve processes.
Purchase equipment.
Increase supplier capacity.
Review management responsibilities.

But recruitment creates costs before the additional revenue may arrive.

That's why sales forecasting should be connected to your profit and cash flow forecasts.

How to Use Sales Forecasting to Improve Cash Flow

Sales forecasts can help estimate future customer invoices.

But they don't tell you exactly when cash will arrive.

For that, you need to understand:

When work will be delivered.
When invoices will be issued.
Customer payment terms.
Actual payment behaviour.
Deposits and staged payments.

A customer sale forecast for March may create cash receipts in April or May.

Use your sales forecast to inform your cash flow forecast, but don't treat them as the same thing.

Sales Forecasting for Different SME Sectors

Trades and Construction Businesses

Forecast using:

Confirmed projects.
Quotations outstanding.
Historical quotation conversion.
Average project values.
Project start and completion dates.
Labour capacity.
Seasonal demand.

Be careful to distinguish contract value from revenue expected to be recognised during each month.

Commercial Cleaning Companies

Forecast using:

Existing monthly contracts.
New contract opportunities.
Expected cancellations.
One-off cleaning jobs.
Contract price changes.
Staffing capacity.

A recurring revenue model combined with a pipeline forecast may work well.

Professional Service Businesses

Forecast using:

Existing retainers.
Confirmed projects.
Sales pipeline.
Billable capacity.
Average fees.
Client retention.

Retail and Ecommerce Businesses

Forecast using:

Historical monthly sales.
Website traffic.
Conversion rates.
Average order values.
Repeat purchases.
Seasonality.
Stock availability.

Recruitment Businesses

Forecast using:

Active vacancies.
Expected placements.
Historical placement conversion.
Average placement fees.
Contractor revenue.
Customer demand.

Membership Businesses

Forecast using:

Opening members.
New members.
Cancellations.
Membership fees.
Upgrades and downgrades.
Retention rates.

For membership businesses, customer churn can have a major impact on the reliability of future revenue.

Seven Common Sales Forecasting Mistakes

1. Confusing Targets With Forecasts

A target is what you want.

A forecast is what you realistically expect.

2. Being Too Optimistic

Don't assume every enquiry will convert or every quotation will be accepted.

3. Ignoring Existing Customers

Existing contracts and repeat purchases may represent a significant part of future revenue.

4. Forgetting Seasonality

Not every month will perform the same way.

5. Ignoring Delivery Capacity

Winning sales is only part of the challenge.

You must be able to deliver the work.

6. Failing to Update the Forecast

An outdated forecast quickly loses value.

7. Not Investigating Differences

If actual sales fall below forecast, understand why.

Simply reducing next month's target doesn't solve the underlying issue.

The Five Sales Numbers Every SME Owner Should Know

1. Number of Enquiries

How many potential customers are contacting your business?

2. Conversion Rate

What percentage become paying customers?

3. Average Sale Value

How much revenue does each sale generate?

4. Repeat or Recurring Revenue

How much income comes from existing customers?

5. Sales Pipeline Value

How much potential future business is currently being pursued?

These measures can provide the foundation for a useful sales forecast.

A Simple Monthly Sales Forecast Dashboard

KPI Target Forecast Actual Enquiries

Conversion rate

New customers

Average sale value

New customer revenue

Existing customer revenue

Total sales revenue

Sales vs target

This makes it easier to see where performance differs from expectations.

A 30-Day Plan to Introduce Sales Forecasting

Week 1 – Understand Your Sales History

Gather:

Previous sales figures.
Customer numbers.
Average sale values.
Enquiry volumes.
Conversion rates.
Existing contracts.
Repeat business.

Outcome: Reliable starting information.

Week 2 – Build Your Forecast

Separate revenue streams.

Estimate existing customer sales.

Forecast new customer sales.

Account for seasonality and capacity.

Outcome: A realistic 12-month forecast.

Week 3 – Compare Forecast With Targets

Identify gaps.

Calculate the additional:

Enquiries.

Conversions.

Customers.

Average sale value.

Repeat purchases.

required to close them.

Outcome: A clearer sales improvement plan.

Week 4 – Introduce Accountability

Create a monthly sales review.

Track actual results.

Update assumptions.

Agree actions.

Assign responsibility.

Outcome: A repeatable sales forecasting and management process.

Ten Questions Every SME Owner Should Ask About Their Sales Forecast

What revenue are we realistically expecting over the next 12 months?
How much is already secured through existing customers or contracts?
How much depends on winning new business?
How many enquiries do we expect?
What is our current sales conversion rate?
What is our average sale value?
How much repeat business do we expect?
What could cause sales to fall below forecast?
Do we have the capacity to deliver the expected work?
What actions would improve the forecast?

If you can't answer these questions, your sales planning may be relying too heavily on guesswork.

A Sales Forecast Should Lead to Action

A forecast isn't just a spreadsheet.

It's a management tool.

If your forecast shows that sales will fall short of target, you can investigate the reasons.

Perhaps you need:

More enquiries.

Better sales conversion.

Stronger follow-up.

Higher average sale values.

More repeat business.

Better customer retention.

More referral opportunities.

Improved marketing effectiveness.

The forecast helps you identify the gap.

Your business strategy determines how you close it.

Stop Hoping You'll Hit Your Sales Target

Many SME owners start the year with an ambitious turnover target.

Then they get busy.

Customers need attention.

Employees need managing.

Problems arise.

And the sales target becomes something they review occasionally.

A good sales forecast changes that.

It creates a connection between:

Your goals.

Your marketing activity.

Your sales pipeline.

Your conversion rate.

Your delivery capacity.

Your financial performance.

Instead of simply hoping you'll achieve your target, you can identify what needs to happen and measure progress.

Forecasting gives you visibility. Accountability turns that visibility into action.

Want to Grow Sales More Predictably in Your SME Business?

I'm Kim Wheatley, a business coach and mentor helping SME business owners across Essex and the UK.

I work with business owners who want to improve:

Lead generation.
Sales conversion.
Customer retention.
Pricing.
Profitability.
Cash flow.
Business planning.
Marketing.
Accountability.
Sustainable growth.

Many businesses don't necessarily need a more ambitious sales target.

They need a clearer understanding of how that target will be achieved.

That means knowing:

How many customers you need.

How many enquiries are required.

What conversion rate is realistic.

What customers are worth.

Which marketing activities work.

What actions need to happen each week.

Business coaching can help you turn these numbers into a practical plan and maintain accountability for delivering it.

Book Your Free Business Growth Accelerator Meeting

If you want to increase sales but aren't sure exactly where the additional revenue will come from, let's look at your business.

During a Free Business Growth Accelerator Meeting, we can discuss:

Your current sales performance.
Your growth targets.
Your sales pipeline.
Enquiry generation.
Conversion rates.
Average sale values.
Repeat business.
Customer retention.
Opportunities to improve profitability.
Practical actions to support future growth.

The objective is to identify realistic opportunities and the actions needed to pursue them.

Book Your Free Business Growth Accelerator Meeting Today.

Frequently Asked Questions About Sales Forecasting

What is a sales forecast for a small business?

A sales forecast is an estimate of the revenue a business expects to generate over a future period, based on available information such as historical sales, enquiries, conversion rates, existing customers and sales opportunities.

How do I create a sales forecast?

Review previous sales, identify revenue streams, forecast existing customer income, estimate new enquiries and conversion rates, account for average sale values and timing, and calculate expected monthly revenue.

What is the simplest sales forecasting formula?

A useful starting formula for new customer sales is:

Expected Enquiries × Conversion Rate × Average Sale Value

However, a complete forecast may also need existing customer revenue, repeat sales, seasonality and sales timing.

Can I create a sales forecast in Excel?

Yes. Excel or Google Sheets can be used to create monthly revenue forecasts using simple formulas, with separate sections for new customers, existing customers and repeat business.

How far ahead should a small business forecast sales?

A rolling 12-month forecast is useful for many SMEs, supported by more detailed short-term pipeline reviews.

How accurate should a sales forecast be?

No forecast will be perfectly accurate. The aim is to use realistic assumptions, compare forecasts with actual results and improve the estimates over time.

What's the difference between a sales forecast and a sales target?

A sales target is what the business wants to achieve. A forecast is what it realistically expects to achieve based on current evidence.

Should sales forecasts include VAT?

Revenue forecasts are generally prepared excluding VAT where VAT is collected on behalf of HMRC. The correct treatment depends on the business and applicable accounting arrangements.

How do I forecast sales for a new business?

Use realistic assumptions based on market research, expected enquiries, conversion rates, pricing and capacity. Because historical data is limited, use conservative scenarios and update frequently.

How do I forecast sales for a service business?

Consider existing contracts, project opportunities, average fees, conversion rates, delivery capacity and the timing of work.

How do I forecast recurring revenue?

Start with existing recurring revenue, then adjust for expected new customers, cancellations, upgrades, downgrades and price changes.

What if my sales forecast is lower than my target?

Identify the gap and calculate what would need to change in enquiry volumes, conversion rates, average sale values, repeat business or retention.

How often should I update my sales forecast?

Many SMEs benefit from reviewing sales opportunities weekly and updating the overall forecast monthly.

Can a sales forecast help improve cash flow?

Yes. It can help estimate future revenue and customer invoices, which can then inform a separate cash flow forecast based on expected payment dates.

Can a business coach help with sales forecasting?

A business coach can help owners understand sales performance, set realistic goals, identify opportunities for improvement and maintain accountability for the actions needed to achieve growth.