The Ultimate Guide to Sales Forecasting

Learn how to create accurate sales forecasts for your sales team or business.

Written by: Aja Frost
close rate sales

FREE SALES FORECASTING TEMPLATE

Use this free guide and Excel template to start closing more deals. Easily calculate drop-off rates and learn how to increase conversion and close rates.

Get it Now
ultimate guide to sales forecasting

Updated:

Published:

Sales forecasting can play a major role in your company's success (and your own career development).

Accurate sales forecasts allow salespeople and business leaders to make smarter decisions when setting goals, hiring, budgeting, prospecting, and other revenue-impacting factors.

Although most salespeople spend a considerable amount of time forecasting each week, less than 25% of sales leaders believe those forecasts are accurate.

salesforecasting_0We‘ve compiled an in-depth guide to creating an accurate sales forecast—rather than a wish-cast. Read on, and don’t miss the sales forecasting template we've included at the end.

Managers use reps' sales forecasts to estimate the business their team will close. Directors use team forecasts to anticipate department sales. The VP of Sales uses department forecasts to project organization sales. These reports are typically shared with company leadership, along with board members and/or stockholders.

Maybe your competitor has started an aggressive new discounting campaign, or your new sales compensation plan unintentionally encourages bad behavior.

Discovering these problems now — versus at the end of the month or quarter — has a huge impact.

Here are a couple of specific reasons why sales forecasting is important and some scenarios that describe the impact of each one.

  1. It encourages better decision-making.
  2. It builds morale and boosts motivation on the team.

Sales forecasts also come into play for a number of decisions, from hiring and resource management to goal-setting and budgeting.

Suppose your sales forecast predicts a 26% increase in opportunities. To make sure you're keeping up with demand, you should start recruiting. If opportunities are predicted to go down, on the other hand, it would be wise to pause your hiring efforts. Simultaneously, look at bumping up marketing spend and investing in prospecting training for your reps.

A sales forecast is a powerful motivation tool.

For example, each week you might update your quarterly sales forecast to see if your team is on track to hit its target. You could also create a forecast every day for an individual sales rep on a performance plan to make sure he's not falling behind.

One of the most important points to remember about sales forecasts: They don't need to be perfect to be valuable. Your sales forecast will often, if not always, be slightly different from your results.

Of course, wildly inaccurate results are problematic — but if you‘re using clean data and have chosen the right method (which we’ll get to), your sales forecast will help you both plan and drive growth.

We're committed to your privacy. HubSpot uses the information you provide to us to contact you about our relevant content, products, and services. You may unsubscribe from these communications at any time. For more information, check out our Privacy Policy.

Free Sales Conversion Rate Template

Easily calculate drop-off rates and learn how to increase conversion and close rates.

  • Dropoff and Conversion Rate Calculator
  • Monthly & Quarterly Sales Goal Setting Template
  • Deal and MRR Pipeline Tracker
Loading your download form

You're all set!

Click this link to access this resource at any time.

Access now
Learn more

Sales Forecasting Methods [+ Examples]

Not all sales forecasting methods are created equal. Here are a few of the most common ways to forecast sales. We've also included some examples to further illustrate each sales forecasting method.

1. Opportunity Stage Forecasting Method

The opportunity stage sales forecasting method accounts for the various stages of the sales process each deal is inThe further along in the pipeline, the likelier a deal is to close.

Once you‘ve picked a reporting period—usually month, quarter, or year, depending on the length of your sales cycle and your sales team’s quota—you simply multiply each deal's potential value by the probability it will close.

salesforecasting_5

After you've done this for each deal in the pipeline, add up the total to get your overall forecast.

Although it‘s relatively easy to create a sales forecast this way, the results are often inaccurate. This method doesn’t account for the age of an opportunity.

In other words, a deal that‘s been languishing in your rep’s pipeline for three months will be treated the same as one that‘s a week old — as long as their close dates are the same. You have to trust your salespeople to regularly clean up their pipelines, which isn’t always feasible.

An opportunity stage sales forecast also may rely too heavily on historical data. If you're changing your messaging, products, sales process, or any other variable, your deals will close at different percentages by stage than they have in the past.

PROS

CONS

It's relatively easy to establish a sales forecast.

Its calculations are objective.

Inaccurate data can lead to inaccurate forecasts.

Its calculations don't consider the size or age of each opportunity.

 

Opportunity Stage Forecasting Example

Let‘s say you’ve established the following likely-to-close percentages based on your pipeline:

  • Initial Call: 5%
  • Qualified:10%
  • Product Demo: 35%
  • Product Trial: 60%
  • Final Call: 80%
  • Deal Closed: 100%

According to this forecasting model, a $1,000 deal at the Product Demo stage is 35% likely to close. The forecasted amount for this deal would be $350.

2. Length of Sales Cycle Forecasting Method

The length of the sales cycle forecasting method uses the age of individual opportunities to predict when they're likely to close.

Because this technique relies solely on objective data rather than the rep‘s feedback, you’re less likely to get a prediction that's too generous.

salesforecasting_3

Suppose a salesperson books a demo with a prospect before they‘re ready. They might tell you the prospect is close to buying — but this method will calculate they’re unlikely to buy because they only started talking to the salesperson a few weeks ago.

Furthermore, this technique can encompass different sales cycles. A normal lead might take roughly six months to buy, but referrals could typically need only one month, and leads coming from trade shows may require approximately eight months. You can bucket each deal type by average sales cycle length.

To get accurate results, you‘ll need to carefully track how and when prospects enter your salespeople’s pipelines. If your CRM doesn't integrate with your marketing software as well as automatically log interactions, your reps will be spending a lot of time manually entering data.

PROS

CONS

Its calculations are objective.

You can easily integrate lead sources to better forecast those opportunities.

Its calculations don't always consider the size or type of each opportunity.

It only works with carefully tracked data.

 

Length of Sales Cycle Forecasting Example

Let‘s say your average sales cycle lasts six months. If your salesperson has been working an account for three months, your forecast might suggest they’re 50% likely to win the deal.

3. Intuitive Forecasting Method

Some sales managers simply ask their reps to estimate the likelihood of closing. The salesperson might say, “I'm confident they'll buy within 14 days, and the deal will be worth X.” This is intuitive sales forecasting.

salesforecasting_2

On the one hand, this method factors in the opinions of the ones closest to prospects: Your salespeople. On the other, reps are naturally optimistic and often offer overly generous estimates.

There's also no scalable way to verify their assessment. To see whether a prospect is as likely to close as the salesperson says, her sales manager would need to listen to her calls, shadow her meetings, and/or read her conversations.

This method is most valuable in the very early stages of a company or product when there's close to zero historical data.

PROS

CONS

It relies on the opinions of your sales team, who works closest to your prospects.

You don't need historical data.

Calculations are subjective and each sales rep can forecast differently.

You can't scale or replicate this method.

 

 

Intuitive Forecasting Example

Let‘s say you want to forecast sales for your brand new business. You’ve only been operating for three months and have no historical data. You have two salespeople on your team, so you ask them to forecast sales for the next six months based on their intuition.

Each salesperson examines the deals in their sales pipeline as well as any prospecting opportunities they have planned for the following months. Based on their analysis, they forecast $50,000 in sales for the following six months.

4. Historical Forecasting Method

A quick and dirty way to predict how much you'll sell in a month, quarter, or year is to look at the matching time period and assume your results will be equal to or greater than those results. This is historical sales forecasting.

salesforecasting_4

There are a few issues with this method. First, it doesn‘t take into account seasonality. Second, it assumes that buyer demand is constant. But if anything outside of the ordinary happens, your model won’t hold up.

Ultimately, historical demand should be used as a benchmark rather than the foundation of your sales forecast.

PROS

CONS

It relies on proven historical data, which can be helpful for steady markets.

It's quick and easy.

It doesn't consider seasonality or market changes.

It doesn't take into account buyer demand.

Historical Forecasting Example

Let‘s say your team collectively sold $80,000 in monthly recurring revenue (MRR) in October. Based on this method, you’d assume they'd sell $80,000 or more in November.

You can make this prediction more sophisticated by adding your historical growth. If you consistently increase sales by 6-8% each month, a conservative estimate for November would be $84,800.

We're committed to your privacy. HubSpot uses the information you provide to us to contact you about our relevant content, products, and services. You may unsubscribe from these communications at any time. For more information, check out our Privacy Policy.

Free Sales Conversion Rate Template

Easily calculate drop-off rates and learn how to increase conversion and close rates.

  • Dropoff and Conversion Rate Calculator
  • Monthly & Quarterly Sales Goal Setting Template
  • Deal and MRR Pipeline Tracker
Loading your download form

You're all set!

Click this link to access this resource at any time.

Access now
Learn more

5. Multivariable Analysis Forecasting Method

The most sophisticated sales forecasting method—multivariable analysis forecasting—uses predictive analytics and incorporates several of the factors mentioned, such as average sales cycle length, probability of closing based on opportunity type, and individual rep performance.

This forecast tends to be the most accurate. However, it requires an advanced analytics solution, meaning it's not always feasible if you have a small budget.

salesforecasting_7

You‘ll also need clean data—if your reps aren’t dedicated to tracking their deal progress and activities, your results will be inaccurate no matter how great your software is.

PROS

CONS

It's very reliant on data and therefore the most accurate.

Because it's so data-driven, it requires an analytics solution and/or forecasting tool, which can be expensive.

Sales reps need to consistently track and clean data.

 

Multivariable Analysis Forecasting Example

Imagine you have two reps, each of which is working a single account. Your first rep has a meeting with Procurement scheduled for Friday, while your second rep just gave her first presentation to the buying committee.

Based on your first rep‘s win rate for this stage of the sales process, combined with the relatively large predicted deal size and the number of days left in the quarter, he’s 40% likely to close in this period. That gives you a forecast of $9,600.

Your second rep is earlier in the sales process, but the deal is smaller and she has a high close rate. She's also 40% likely to close, giving you a forecast of $6,800.

Combine those, and you'd get a quarterly sales forecast of $16,400.

6. Pipeline Forecasting Method

The pipeline sales forecasting method can take some time—maybe too much time—if you don‘t have a program in place to handle your calculations. It reviews each opportunity currently sitting in your pipeline and calculates its chances of closing based on unique company variables including the rep’s win rate and opportunity value.

This forecasting method relies on your ability to provide high-quality data. If you mess up the numbers or use imperfect data, you'll end up with forecasting that provides zero value.

salesforecasting_8

Make sure your reps regularly enter accurate, timely data into their CRM to glean the most insight from this method.

PROS

CONS

It's very data-reliant, which makes it one of the most accurate.

It takes into account unique factors of each opportunity.

It's very data-reliant and can be easily skewed.

It often requires a sales forecasting tool.

 

Pipeline Forecasting Example

If your sales team typically closes deals worth between $5,000 and $8,000 within 60 days, all current deals in your team's pipeline would be given a high likelihood of closing.

You can then use this data to figure your monthly or quarterly forecast.

How to Forecast Sales

  • Establish a sales process for your team.
  • Set individual and team quotas.
  • Invest in a CRM.
  • Choose a sales forecasting method.
  • Include data from other organizations such as Marketing, Product, and Finance.
  • Review prior sales forecasts.
  • Keep your sales team informed and accountable.

Here's a breakdown of how to get started with sales forecasting. These steps will ensure an accurate sales forecast for your business.

1. Establish a sales process for your team.

If your sales team isn‘t consistently using the same stages and steps, you won’t be able to predict the likelihood of an opportunity closing. Reference our guide to building a sales process to learn how to create a documented, structured sales process to use when converting any prospect from a lead to a customer.

Your sales process will also set standard opportunity, lead, prospect, and close definitions. Everyone needs to agree about when and how to count leads entering and exiting the funnel.

2. Set individual and team quotas.

To gauge performance, you need an objective definition of “success”. Work with your sales reps and leaders to set sales quotas. These will serve as financial baseline goals to compare alongside your sales forecasting.

3. Invest in a customer relationship management (CRM) tool.

CRMs, like the HubSpot CRM, give your sales reps a database for tracking opportunities to give you accurate close predictions. Accurate data will allow for accurate forecasting.

Even if your business is brand new, establishing a CRM and getting your reps in the habit of using one will benefit your future forecasting. (If you are brand new, check out our sales forecasting template in the next section.)

4. Choose a sales forecasting method.

Once you have your sales process, sales quota, and CRM in place, you can choose a sales forecasting method.

The method you choose will depend on a few factors, including the age of your business, the size of your sales team and pipelines, and the quality of your sales data and data tracking habits.

If your business is new or doesn't have much historical sales data, the best method for you would be intuitive forecasting.

If you're just getting started with sales forecasting and have busy sales pipelines, opportunity stage forecasting, length of sales cycle forecasting. These methods both present objective forecasting calculations, however, so if you're looking for more detailed pipeline-specific forecasting, multivariable analysis forecasting and pipeline forecasting may be feasible options.

These two work best if your team has impeccable sales data and is in the habit of keeping up with their pipeline data. Lastly, for the most consistent markets and industries, historical forecasting can be a good forecasting model.

Take a close look at your business model, sales team, data tracking, and broader industry before moving forward with a sales forecasting model.

We're committed to your privacy. HubSpot uses the information you provide to us to contact you about our relevant content, products, and services. You may unsubscribe from these communications at any time. For more information, check out our Privacy Policy.

Free Sales Conversion Rate Template

Easily calculate drop-off rates and learn how to increase conversion and close rates.

  • Dropoff and Conversion Rate Calculator
  • Monthly & Quarterly Sales Goal Setting Template
  • Deal and MRR Pipeline Tracker
Loading your download form

You're all set!

Click this link to access this resource at any time.

Access now
Learn more

5. Include data from other organizations such as Marketing, Product, and Finance.

While understanding past sales data is critical for creating a viable sales forecast, other organizations within your company can also provide valuable insight. Make sure you include the following organizations in your forecasting process:

  • Marketing – Your marketing organization has a direct correlation to the quality of your pipeline. Sit down with your marketing team to understand their plans and strategies for the time period you're forecasting.
  • Product – Is your product team working on anything new for the coming year? How do product launches factor into your overall forecast? Including this data in your analysis can help you create a more well-rounded strategy.
  • Finance – The finance team at your company should be running analysis to better understand the financial health of your company as a whole. Work with financial analysts to understand how your sales forecast aligns with the financial goals of the company.
  • HR – Will your future sales goals require additional headcount or employee resources? If so, connect with a business partner from your HR department to map out what that process will look like, and how it impacts your forecast.

6. Review prior sales forecasts.

How did your team perform this year? Compare the actual data you have available to the prior year's forecast and take note of any variances or discrepancies.

Are there any clear areas your sales organization under-delivered on? Were the goals set the prior year unrealistic? Did you factor in major events and seasonality? Highlight any major takeaways or lessons learned that your company's leadership should be aware of as you navigate the forecasting process.

7. Keep your sales team informed and accountable.

Regardless of which sales forecasting method you choose, keep your sales reps informed and communicate changes and decisions often. This is another good reason to invest in a CRM — it keeps your reps informed about every interaction with leads and with each other.

Gather regular feedback from your team about what‘s working and what’s not. Hold your reps accountable for their performance against your sales quotas and sales forecasts. After all, they are the closest to and most familiar with your prospects and overall sales performance as a company.

Factors That Can Impact Your Sales Forecast

Watch out for these ten internal and external factors, for which you'll need to account in your sales forecast.

Internal Factors That Can Impact Your Sales Forecast

1. Hires and Fires

When salespeople leave your company — either because they quit or were terminated — revenue will decrease unless you have a pipeline of potential hires. If a significant number of reps came on board at one time, your sales forecast should predict a big jump in business when they've ramped.

2. Policy Changes

Don't adjust your sales comp plan without adjusting your forecast. If you implement a four-month clawback on commissions, for example, revenue will decrease because your reps will only sell to best-fit prospects. However, in a quarter when far fewer customers churn, your profits will increase.

Or perhaps you say reps can‘t discount after the 15th of every month. You’ll see a spike in close rates in the first two weeks, followed by fewer sales than normal.

3. Territory Shifts

It takes time for reps to familiarize themselves with a new territory and build their pipeline, so expect your close rate to dip before picking up again (assuming you planned your new territories well).

External Factors That Can Impact Your Sales Forecast

4. Competitive Changes

Unsurprisingly, what your competitors are doing will impact your win rates. If another company in the space slashes their prices, your reps may need to discount more aggressively or risk losing business. If a competitor goes out of business, on the other hand, you'll probably see increased demand.

5. Economic Conditions

When the economy is strong, buyers are more likely to invest in their businesses. When it‘s weak, the sales cycle usually takes longer and there’s a greater level of scrutiny for every purchase.

6. Market Changes

Stay on top of what‘s happening with your buyer’s customers. For example, if you sell consulting services to hotels, you'd be interested in an anticipated rise in tourism.

7. Industry Changes

If a complementary solution sees unexpectedly high demand, you‘ll probably see your sales go up too. Imagine you sell jelly. The more peanut butter people buy, the more jelly they’ll buy as well.

8. Legislative Changes

New laws and mandates can either help or hurt your business — either by creating demand for your product or making prospects reluctant to buy anything new.

9. Product Changes

Are you rolling out a highly-requested feature, introducing a new pricing model, or offering a complementary product or service? These changes can help your salespeople increase their average deal size, shorten their sales cycle, and/or win more business.

10. Seasonality

Your customers might be more likely to buy at certain times of the year. For instance, school districts typically assess new purchases in spring and decide what to buy in fall.

We're committed to your privacy. HubSpot uses the information you provide to us to contact you about our relevant content, products, and services. You may unsubscribe from these communications at any time. For more information, check out our Privacy Policy.

Free Sales Conversion Rate Template

Easily calculate drop-off rates and learn how to increase conversion and close rates.

  • Dropoff and Conversion Rate Calculator
  • Monthly & Quarterly Sales Goal Setting Template
  • Deal and MRR Pipeline Tracker
Loading your download form

You're all set!

Click this link to access this resource at any time.

Access now
Learn more

Sales Forecasting Template

There's a common theme throughout these sales forecasting methods: Data.

Even the most lightweight forecasting options rely on knowing how many opportunities are in each rep's pipeline and their project's likelihood of closing.

To keep track of all these details, you can use a free sales forecasting template, such as our sales forecasting tracker.

salesforecasting_6

Download this Template for Free

This tracker includes:

  • A spreadsheet for tracking which deals are guaranteed, likely, potentially, and unlikely to close this month
  • A monthly revenue forecast that automatically updates with the information you entered in the first spreadsheet
  • A yearly goal tracker so you can monitor your progress

This sales forecasting template is ideal when you‘re just starting out. However, if your company is more established, consider using a CRM instead. A CRM will calculate all of the above on its own—so you don’t need to lift a finger.

Try HubSpot's free CRM. Not only will it keep track of your actual and predicted revenue, it automatically logs every interaction with prospects—emails, calls, and social media—making your ability to gauge the likelihood of a deal closing even more accurate.

Start Sales Forecasting Today

With a thoughtful sales forecasting strategy, you can be ready for the future — whatever it brings.

Editor's note: This post was originally written in January 2019 and has been updated for comprehensiveness.

This article was written by a human, but our team uses AI in our editorial process. Check out our full disclosure to learn more about how we use AI.

salesforecasting_1

 

Related Articles

We're committed to your privacy. HubSpot uses the information you provide to us to contact you about our relevant content, products, and services. You may unsubscribe from these communications at any time. For more information, check out our Privacy Policy.

Easily calculate drop-off rates and learn how to increase conversion and close rates.

Powerful and easy-to-use sales software that drives productivity, enables customer connection, and supports growing sales orgs

START FREE OR GET A DEMO