The Last Guide to Sales Forecasting You’ll Ever Need: How-To Guides and Examples

When you produce a sales forecast, you are predicting what your sales or revenue will be in the future. An accurate sales forecast helps your firm make better decisions and is arguably the most important piece of your business plan. 

A sales forecast contrasts with a sales goal. The former is the realistic representation of what you believe will occur, while the latter is what you want to occur. Forecasts are never perfectly accurate, but you should be as objective as possible when creating a sales forecast. Goals, on the other hand, can be based on optimistic or motivational targets.

Because the sales forecast is critical to business planning, many different stakeholders in a company (beyond sales managers and representatives) rely on these estimates, including human resources planners, finance directors, and C-level executives. 

In this article, you’ll learn about different sales forecasting methods with varying levels of sophistication. The most basic method is called naive forecasting, which uses the prior period’s actual sales for the new period’s forecast and does not apply any adjustments for growth or inflation. Naive forecasts are used as comparative figures for more robust methods.

A sales plan describes the goals, strategies, target customers, and likely hurdles for your sales effort. The sales plan defines your sales strategy and the method of execution you will use to achieve the numbers in your sales forecast.

Your sales forecasting model can ultimately become very sophisticated, but to grasp the basics, you should first gain a high-level understanding of what is involved. There are three primary steps to getting started:

1. Decide which forecasting method or technique you will use. Also, determine the time period for your forecast. Later in this guide, we will review different methods of forecasting sales, including how to know which is best for your business.  
2. Gather the data to plug into your forecast model. The data points will vary by method, but will almost always include your actual past sales and current growth rate.
3. Pick a tool to support your forecasting effort. For learning purposes, you can start with pencil and paper, but soon after, you’ll want to take advantage of digital solutions. Common tools include spreadsheets, accounting software, and customer relationship management (CRM) or sales management solutions.

As you get going, remember not to be overly focused on complex formulas. Do regular reality checks to make sure your sales forecasts accord with common sense. Bounce forecasts off sales reps to get realistic feedback, and revise.

You will likely achieve greater accuracy if you build your forecasts based on unit sales wherever possible, because pricing can move independently from unit sales. Use data if you have it.

Sales forecasting helps your business by giving you data to make decisions concerning allocating resources, assigning staff, and managing cash flow and overhead. Using this data reduces your risk and supports your growth. 

Your sales forecast enables you to predict both short and long-term performance and customer demand for your product. In the short term, having a sales forecast makes it easy for you to spot when actual sales are not meeting estimates and gives you an opportunity to make corrections early in the period.

The forecast guides how much you spend on marketing and administration, and the projections generate your sales reps’ objectives. In this way, sales forecasts are an important benchmark for gauging the performance of your sales reps. 

Sales forecasts also lead to better management of inventory levels. With a good idea of how much product you will sell, you can stock enough to meet customer demand without missing any sales and without carrying more than you need. Excess inventory ties up capital and reduces profit margins. 

In the long term, sales forecasts can help you prepare for changes in your business. For example, you might see that within a few years, your company will require more manufacturing capacity to meet growing sales. To expand capacity, you may need to build a new factory, so now you can start planning how you will pay for it. Predictive sales forecasting is a critical part of your presentation if you are seeking equity capital from investors or commercial loans for expansion. 

In short, sales forecasting helps your business avoid surprises, so you aren’t making decisions in a crisis environment. Companies with trustworthy sales forecasts see a 10 percentage point  greater increase in annual revenues compared to counterparts without, according to research from the Aberdeen Group.

Sales forecasting methods break down broadly into qualitative and quantitative techniques. Qualitative forecasts depend on opinions and subjective judgment, while quantitative methods use historical data and statistical modeling.

In reality, most businesses use a combination of qualitative and quantitative methods to produce sales forecasts. Let’s look at the common ways that companies put sales forecasting into action with examples.

Choosing the time period for your sales forecast is an important step. Depending on your business, the purpose of your forecast, and the resources you can devote to making forecasts, the time frame you target will vary. 

A short-term forecast will help set sales rep bonus levels for next quarter, but you need a long-term forecast to decide whether you should plan to build a new factory. A startup that has been doubling revenue every year will have more difficulty making a 20-year forecast than a century-old concern in a mature industry. Here are the three time frames for forecasts: 

1. Short-Term Forecasts: These cover up to a year and can include monthly or quarterly forecasts. They help set production levels, sales targets, and overhead costs.
2. Medium-Term Forecasts: These range from one to four years and guide product development, workforce planning, and real estate needs.
3. Long-Term Forecasts: These extend from five to 20 years and inform capital investment, capacity planning, long-range financing programs, succession planning, and workforce skill and training requirements.

Regardless of the sales forecast method you use, you generally need to have certain pieces of information and conditions in place. These include the following:

• Well-Documented and Defined Sales Process: You need to understand your customer journey and have an established sequence for nurturing each prospect. Without this, you cannot predict which opportunities are getting closer to purchasing. This structure creates accountability. 
• Consensus on Pipeline Stages: Your sales team needs to have a clear and shared understanding of what you mean by lead, prospect, qualified, possible, probable, committed, and other relevant terms. 
• Definition of Success: Communicate clearly what your sales team is striving for in terms of sales quotas or goals; include these quotas and goals for each individual rep, for the team as a whole, and for conversion through each stage of your pipeline.
• Historical Data: You require benchmarks for data points, such as average time to close, conversion rates, average deal size, lifetime customer value, win-loss ratio, and seasonal sales trends. These sales metrics and KPIs are often critical pieces of your forecast.
• Current Status: Up-to-date knowledge of your pipeline is essential, including how many opportunities are at each stage and the potential value of these sales.
• Forecasting Tools: This will almost always include a CRM application and may also include financial management or accounting software, analytics solutions, and spreadsheets.

Sales forecasting should not happen in a vacuum. Take into account changes in the business environment and question assumptions, such as that past growth will continue. Also, be sure to factor in your ideas about global economic trends and competitor behavior.

Here are some common factors to consider regarding your sales forecast. Many of these can have either a positive or negative influence on sales. For example, changing reps’ account assignments may reduce sales, because members of your team will have to familiarize themselves with customers that are new to them. However, sales could increase if your new hotshot gets your biggest opportunity.

• Economic Trends: Inflation, growth, consumer sentiment, risk appetite, and purchasing power
• Regulation: Trade policies such as tariffs, duties, and quotas; health, safety, and environmental rulings on products or processes; court decisions; intellectual property disputes; and competition policy
• Seasonal Trends: Cyclical demand fluctuation, production patterns, and variation in raw material availability 
• Competitor Behavior: New product innovations, pricing changes, and market entries and exits
• Business Economics: Selling prices, direct prices, unit costs, gross margins, and the impact of accrual versus cash accounting on when you can book a sale
• Staffing and Compensation: Hiring or firing new reps, changes in leadership, policies on commissions and bonuses, and training
• Territory Management: Redrawing of territories and changes in account assignments
• Products and Services: Product lifecycle, new products and services, user experience, defects, ticket resolution, changes in distribution, and market entries and exits
• Marketing: Demand generation, advertising, pricing, special campaigns, social media activity, and prospecting

If you are starting a new business or launching a new product, your sales forecasts are crucial because they will determine how much you can spend in order to break even. However, when dealing with a new entity, you lack the advantage of historical data, which you need for almost every forecasting technique. 

If you don’t have historical data, you can use industry benchmarks from trade publications, industry associations, and consultants. For example, if you are launching a new recipe app, look at market research on how other cooking apps have performed. 

Dining establishments can look at number of tables, hours of service, and menu prices to estimate average order amounts and table turnover. Retail outlets use square feet, foot traffic, and average selling prices to forecast sales.

If you are adding a new product to your line, you can forecast sales by looking at how your most similar existing product performed at launch. Then, you can make tweaks based on other relevant information, such as that the new product is harder to master than its predecessor, that it is a later entrant into a crowded space, or that it already has a backlog of orders before launch.

New service businesses can base forecasts on capacity, such as number of staff and service hours and how much to charge for the most popular services. Once you have this data, you can make adjustments accordingly.

Michael Barbarita, President of Next Step CFO, works as a contracted CFO to produce sales forecasts for companies. He likes to tie the sales forecast for service businesses to a metric called sales per direct labor hour, which you can calculate this by dividing sales by the working hours of people in the field performing customer work. For example, an electrical contractor would calculate the sales per direct labor hour of its electricians and multiply that figure by the number of electricians and the hours they work.  

For instance, you may decide that operating at half capacity is a good estimate for your first six months in business. Then, you may operate at three-quarters capacity for the second six months. Therefore, you would multiply maximum capacity by average revenue and then multiply that resulting figure by 0.50 and 0.75, respectively.

If you are eager to dive in and want to generate some simple sales forecasts, you can make use of basic equations. Here are a few easy ones:

• Simple Forecast with No Organic Growth: This formula assumes that this period will duplicate the prior period, except for the impact of inflation. 
  
  Revenue Prior Period) + (Revenue Prior Period x Inflation Rate) = Sales Forecast
   
• Historical Plus Growth: This formula helps you reflect current trends.You look at the prior year and then factor it by your recent growth rate.
  
  (Last Year Revenue x Percentage Growth Rate) + Last Year Revenue = Sales Forecast
• Partial Year: In this method, you project the rest of the year based on historical patterns and early results. Imagine that you know your sales for the first two months of the year and that last year these months represented seven and nine percent of your sales respectively and totaled $100,000. Using the formula below, you would forecast sales of $625,00 for the year: ($100,000 x 100) ÷ 16 = $625,000.
  
  (Current Period Revenue x 100) ÷ Percent That Equivalent Period Represented Last Year = Forecast Sales
• Pipeline Formula: This formula replicates the opportunity stage method that we discussed earlier. You calculate the value of deals at each stage of your pipeline by multiplying the potential deal value by the close probability and adding up the result for each stage.
  
  (Deal Amount x Close Probability) + (Deal Amount x Close Probability) etc. = Sales Forecast

Here are step-by-step instructions for a manually generated sales forecast:

1. Pick Your Time Period: The way in which you will use your forecast determines the most appropriate time interval, whether that be monthly, quarterly, annually, or on an even longer timeline. If you are making your first forecast, estimating on a monthly or quarterly basis for the upcoming year is a good starting point. Experts suggest doing monthly estimates for the first year and then doing annual forecasts for years two through five. 
2. List Products or Services: Write down the items or services that you sell. If you have a lot of them, group them into categories. For example, if you sell clothing, your rows might include shirts, pants, and shoes. Match these revenue streams to the way you organize your accounting. So, if your books look at women’s and men’s clothing separately, do the same for your sales forecast. That way, you can pair your sales forecast with information on your cost of goods sold and overhead to project profit.  
3. Estimate Unit Sales: Predict how many units you will sell in the selected time period. If you have historical data, use that and then factor in assumptions about demand for the upcoming period. For example, is your business growing? Is the economy in recession? Did you launch a big promotion? Use the answers to these questions to make downward or upward adjustments to the historical figure. You can also interview some customers to get insights into their likely purchasing plans. Lastly, don’t forget to factor in seasonal fluctuations. 
4. Multiply by the Selling Price: Multiply the unit sales numbers by the average selling price (ASP). Determine the ASP by analyzing historical sales and adjusting for inflation and other factors. To obtain this figure, you also need to consider discounts, free trials, and unsold inventory. 
5. Repeat for Each Forecast Period: Go through the same calculation for each category and time interval. As you forecast more distant periods, your estimates are likely to be less accurate, so you may want to make a range of forecasts, such as for best, worst, and average scenarios. As time passes, add the actual values and fine-tune your forecast. For instance, you may see that for the first few months of the year, you underestimated sales by 12 percent. Therefore, you decide to increase your forecasted sales amounts in the upcoming months.

Here is a step-by-step guide to building your own sales forecast in Excel:

1. Enter Historical Data: Open a worksheet and enter your past date data in the first column. Then, in the second column, enter the corresponding sales values. If possible, make sure you space the dates consistently (e.g., the first day of every month). 
2. Create Forecast: In the date column, fill out the next date cell with the future date you are forecasting. Select the corresponding sales value cell and in the function field, type: =(FORECAST( A10, B2:B9, A2:A9)), where A10 is the future date cell, B2 to B9 are the historical sales amounts, and A2 to A9 are the historical dates. Hit enter and the forecast sales amount will appear.
3. Repeat: Continue the pattern for your remaining future dates. Remember that the formula uses only known variables, so do not add forecasted amounts to the cell ranges. This function is a linear forecasting method.
4. Power Up: If you have Excel 2016, you can use the forecast sheet function, which automates forecasting and adds a chart. To use this function, select both data columns, and, on the data tab, click the forecast sheet. In the create forecast worksheet box, select whether you want a line or bar chart. In the forecast end field, choose an ending date and then click create. Excel will create a new worksheet that contains both historical and forecast sales data as well as a visual representation. 

For a pre-made basic sales forecast, download this template that projects product sales with both units and sales amount.

Basic Sales Forecast Sample Template

Excel | Google Sheets | Smartsheet

For a wide range of pre-built sales forecast templates in a variety of formats, see this comprehensive collection.

Your goal is to build the most reliable forecast possible, with the minimum amount of resources you need to be effective. To choose the method that fits best, consider these seven questions:

1. What Is the Purpose of the Forecast?
   
   Think about why you need the forecast and what you will do with it. Forecasting methods vary in their accuracy, cost, and ease of execution. If you are using it to set a budget, you will want a high level of accuracy. But, if you are trying to confirm that there is enough demand in a new geographic area to justify entering the market, you do not need as much precision. If the need is urgent, you want a fast technique. If you have time and resources, you may decide your needs are best served by a sophisticated custom model. When you want to model what would happen to sales if you changed one variable, you need a method (such as regression analysis) that can isolate this variable and reliably project the impact.
   
   
   “Consider the purpose of the model and how the results will be used. For example, major decisions with a high degree of impact and uncertainty require more accuracy than those that are low impact or generally more predictable. You also need to consider the data that will be available and the quality of that data,” says Tyson Nicholas, Senior Director of Analytics at HealthMarkets, a national insurance agency. 
2. Is the Time Frame Short, Medium, or Long Term?
   
   Qualitative methods are a good choice for short-term horizons, but they generally underperform quantitative methods for periods beyond a few months. Similarly, consider where you are in your business or product lifecycle. If you are ramping up or in a high-growth phase, you may be making costly investment decisions, so you need a method with a high degree of accuracy, but also relatively quick production time. When you are in a mature phase of your business, decisions about production and marketing are more routine. 
3. How Much Data Do You Have?
   
   The less data you have, the more likely you will be to select a qualitative technique. If you have limited data, you will turn toward more simplistic models. A company that has collected a lot of data and has great confidence in its reliability can choose sophisticated quantitative models. 
4. How Relevant Will History Be in Predicting the Future? 
   
   If your business has undergone big changes, such as launching major new products, experiencing large growth in the sales force, or introducing a different pricing structure, your past results will have less value as a guide to future performance. So, methods that diminish the weight put on historical data and qualitative techniques are a better choice.  
5. In Terms of Time and Money, How Much Does It Cost to Produce the Forecast?
   
   How Does This Cost Compare to the Value of the Potential Benefits?You will need to make tradeoffs between the time and cost to build your forecast and the potential benefits, such as cost savings. Also, consider the potential cost of error. For example, suppose you are contemplating a high-cost sales-forecasting technique (one that takes a lot of data gathering, the creation of a custom model, and expensive staff and technology to produce). The forecast could allow your company to reduce the amount of inventory it holds. Weigh the value of inventory savings against the forecasting cost. If you reduce inventory and the forecast proves inaccurate, what are the potential costs of lost sales — because you did not stock adequately or because you did not cut back enough?  
6. What Degree of Accuracy Do You Need? 
   
   Forecast accuracy rises with the cost and complexity of the methodology. Depending on how you will use the forecast, the size of your company, and the variability of your business, you may feel that it’s not cost effective to produce a maximum-accuracy forecast. If you are a giant global company, a fraction of a percentage point error in your sales forecast could represent many millions. So, the bigger the dollar values, the more meaningful every degree of enhanced accuracy becomes.
7. How Complex Are the Factors That Will Drive the Forecast? 
   
   If your sales dynamic is straightforward — the more sunny days there are, the more beach umbrellas you sell at your beach kiosk — then building a sophisticated, AI-driven forecasting model will be overkill. “It's important not to spend time and energy developing a complex model, when a much simpler one will do the job,” says Nicholas.
   
   But when you are facing a subtle and complex interplay of variables, you need a technique that accounts for them. Suppose you have new products, changes in your marketing, and additional sales reps. A sophisticated model would allow you to forecast the net effects and also try out different scenarios in which the variables fluctuated.

According to CSO Insights, 60 percent of forecasted deals do not close and 25 percent of sales managers are unhappy with the accuracy of their forecasts. Inaccuracy in sales forecasts causes problems for businesses and impacts performance. 

People throughout your company depend on your forecasts to make a multitude of decisions — from pay raises to real estate acquisitions. Let’s look at some of the important reasons to strive for accuracy:

• Early Warning: Your sales forecast helps you spot trouble early, like when revenues are not materializing as expected; the forecast also allows you to intervene and problem solve before this underperformance becomes a crisis.
• Decision Making: The forecast gives leaders confidence and a sound basis for deciding how much and where to spend or invest. Production planners, HR, and others will use the forecast.
• Goal Setting: You set achievable targets for sales reps when you have an accurate forecast. Goal setting prevents sales reps from getting discouraged by unrealistic expectations. Following this strategy also ensures that your commission and bonus scale are calibrated appropriately. 
• Customer Satisfaction: When you are prepared for the right level of demand, your company can improve its record of fulfilling orders on time and in full.
• Inventory Management: You will be more likely to have the right level of inventory if your sales forecasts are accurate. Making accurate predictions allows you to better manage your supply chain and order raw materials or parts in a timely fashion. You also gain more control over your pricing if you have the right amount of inventory. When you have to resort to discounting to get rid of excess inventory, your profitability suffers.

Producing high-quality forecasts takes organizational commitment and long-term effort, and best practices will help improve accuracy.

”Sales forecasting is both an art and a science. Where companies tend to go wrong is relying too heavily on one or the other. You need a consistent process and reliable data,” says Charlene DeCesare, CEO of sales training and advisory firm Charlene Ignites.

She emphasizes five best practices:

1. Ensure that the pipeline feeding the forecast is accurate. You don't need historical data to predict the future when you have a well-defined sales process.
2. Everyone must use the CRM, and should enter notes and coding opportunities in a clear, consistent way. 
3. Buyer behavior is a much more reliable predictor of future sales than gut feel. Challenge optimism that doesn't align with the applicable stage in the sales cycle or isn't supported by clear, mutually agreed-upon next steps.
4. In general, buyer/seller behavior is the leading indicator to rely upon. Too many companies rely on results, which is actually the lagging indicator.
5. Sales leadership can have a huge impact. Sales reps must be rewarded for both honesty and accuracy. Sales forecasting must be an individual, team, and company priority. 

Rob Stephens, a CPA whose firm CFO Perspective advises businesses on forecasts, adds: “A big planning mistake is spending too much of your precious time trying to find the one right scenario… Start with a range of reasonable forecasts based on solid fundamentals. For example, you may project from historical growth rates, customer indications of future sales, or projections of market growth. A company with a new product may need to extrapolate from existing products or early indications from potential customers. Use a higher-probability scenario as a beginning base scenario, but identify why the future may deviate from it.”

Sales pros say they see the same sales forecasting errors on a regular basis and that these often relate to letting the discipline of the forecasting process lapse. 

“The most common operational mistakes are basing forecasts on hope rather than evidence, ignoring repeated close date slippage, failing to take into account the historic forecast accuracy (or inaccuracy) of the salesperson concerned, and failing to hold salespeople accountable for the relative accuracy of their forecasts,” notes Bob Apollo, Founder of Inflexion-Point Strategy Partners, a sales training firm.  

“The most common cultural mistake is when sales leaders press salespeople to forecast a target number without any evidence or confidence that it will actually be achieved," he notes.

Evan Lorendo, Director of Revenue Accelerator, which advises service companies on revenue strategies, says he sees companies with monthly recurring revenue (MRR), such as software as a service (SaaS), frequently make mistakes in sales forecasting.

He gives the example of a company with an MRR product that wants to generate $120,000 in revenue a year. How much in new sales do they need each month? “Most of my clients say $10,000/month, but that is wrong. Because a client is paying on a monthly basis, a client that signs up in January is actually paying 12 times during the year. On the flip side, a client signing up in July will make six payments during the year,” he explains. 

That means there are a total of 78 potential payment configurations per year, not 12. The customer who buys in January will make 12 payments, but November’s buyer will make two. (12 + 11 + 10 + 9 + 8 + 7+ 6 + 5 + 4 + 3 + 2 + 1 = 78.)

“If you want to know how much you need to sell in new sales each month to hit that $120,000 goal, the answer is $1,539 ($120,000/78). That actually seems much more manageable, doesn't it? Based on poor forecasting, a miscalculation can turn off good salespeople who can't hit their quota,” he says.

As your sales forecasting improves, you reap bigger benefits, such as better planning and higher profits. So, you will want to assess and monitor your forecasting effort by using key performance indicators (KPIs).

Below are the main KPIs for sales forecasting. Some of them draw from statistics concepts, such as standard deviation, and computer applications and statistics guides can help you calculate them.

• Bias or Variance: This KPI tells how much the actual results deviated from the forecast over a given period of time. Calculate bias as an absolute number of dollars or units or as a percent of sales. A positive number means sales exceeded projections and a negative number indicates underperformance.
  
  Actual Units - Forecast Units = Bias
• Mean Absolute Deviation (MAD): This metric describes the size of your forecast error in total units or dollars. You calculate how much the actual results deviated from the forecast average, add the deviations, and divide the result by the total number of data points.   
• Mean Absolute Percentage Error (MAPE): This is similar to MAD, but gives the forecast error as a percent of sales volume. 
• Tracking Signal: This is another expression of forecast error and looks at how the error rate varies among forecast values. Normally, you expect all forecast amounts to be wrong by about the same degree. If, from one data point to another, there is a large variation in the error rate, you need to rework your model. 
  
  Tracking Signal = Accumulated Forecast Errors ÷ Mean Absolute Deviation
• Forecast Value Added: This metric measures how much better the forecast was than simply using unadjusted historical data. If your forecasting effort got you closer to actual than the so-called naive forecast (i.e., using historical figures as your forecast), you have added positive value. You calculate this metric by comparing the MAPE of your forecast to the naive forecast.
• Linearity: This looks at how sales are paced over the course of the period. As your reps seek to meet quota, you might see a flurry of deals at the end of the quarter. Or, deals might be spread evenly across the time period. The most stable situation is a deal cadence or velocity that is constant. If expressed as a trend line, this stable situation would appear visually as a flat line. This pattern is called highly linear.

Your sales forecast obviously gives you an idea of how much you will sell in the future, but sales forecasting has other important use cases. Here are five ways you can apply your forecast to business questions:

1. Sales Planning: As noted earlier, your sales plan encompasses your goals, tactics, and processes for achieving your sales forecast. As part of this plan, your sales forecast helps you decide if you need to hire more sales reps to achieve your forecast and if you need to put more energy and resources into marketing.
2. Demand Planning: Demand planning is the process of forecasting how much product your customers will want to buy and making sure inventory aligns with that forecast. In ideal conditions, forecast demand and sales would be virtually the same. But, consider a scenario in which your new product becomes the hot gift of the holiday season. You forecast demand of 100,000 units (the number consumers will want to buy). A large shipment turns out to be defective, and the product is unsellable. So, you forecast sales of just 75,000 units (how much you will actually sell.)   
3. Financial Planning: Your sales forecast is vital to the work of your finance department. The finance team will rely on the forecast to build a budget, manage overhead, and figure out long-term capital needs. 
4. Operations Planning: The unit-sales numbers in your forecast are also important for operations planners. They will look at the production required to meet those sales and confirm that manufacturing capacity can accommodate them. They will want to know when sales are likely to rise or fall, so they can avoid excess inventory. A big increase in sales will also require operations managers to make changes in warehousing and distribution. Retailers may change the product mix at individual stores based on your sales forecast.
5. Product Planning: The trends you foresee in sales will have big implications for product managers too. They will look at products that you forecast as top sellers for ideas about new products or product modifications they should introduce. A forecast of declining sales may signal it is time to discontinue or revamp a product.

Sales forecasts can be simply scribbled-down estimates, or they can be statistical masterpieces produced with the aid of the most sophisticated technology. The style you pursue relates in large part to your level of forecasting maturity (as well as the size and history of your business). 

Below is a description of the four levels of the sales forecasting maturity model:

• Level One: In the beginning stages of sales forecasting, the estimates are usually not very accurate and take a lot of time to produce. The forecasting process depends on reps’ best guesses, and sales managers spend a lot of time gathering these guesses by interviewing each rep. Then, they roll them up into a consolidated forecast. Inconsistent data collection and personal bias can skew the results. Sales managers use spreadsheets, which quickly become outdated, and the forecasts often reflect little more than intuition.
• Level Two: As your forecasting culture grows, you are probably still inputting data by hand, and the forecast is often inaccurate or outdated. But, a CRM solution is enabling your team to have a shared repository for contacts, sales activity, and deal status. Reps don’t see value in spending time contributing to the forecast, and quality is weak. Your CRM automatically aggregates those results, so you can start to examine trends and anomalies. But, your system is not very flexible, and forecasting remains unwieldy and resource intensive.
• Level Three: At this point, automation starts to offer radical improvements in sales forecasting. Solutions backed by artificial intelligence automatically bring together data from a multitude of sources, including email, CRM, marketing platforms, chat logs, and calendars. There is no more manual data entry, and sales managers gain increased visibility into the sales pipeline. KPIs become reliable and an important tool for monitoring performance.
• Level Four: Technology ensures sales that data is accurate and timely. AI and machine learning find patterns and correlations in your historical data, and predictive analytics offer robust forecasting. The forecasting model is continually refined. Forecast accuracy rises, and sales managers can focus more of their time on supporting reps and developing opportunities. These tools make it apparent when reps are sandbagging or being too optimistic, and accountability increases.

While sales forecasting has been around as long as private enterprise, the field continues to evolve, and researchers are looking at ways to improve sales forecasting methodologies. 

Indiana University Professor Douglas J. Dalrymple performed an influential study in 1987 that surveyed how businesses prepared sales forecasts. He found that qualitative and naive techniques predominated, but that early adopters were reducing errors by using computer analysis. At this time, PCs were starting to proliferate and come down in price. 

By 2008, Zhan-Li Sun and his researchers at the Institute of Textiles and Clothing at Hong Kong Polytechnic University were experimenting with an advanced AI-driven technique called extreme learning machine to see if they could improve forecasts for the volatile retail fashion industry by quantifying the influence of factors such as design on sales.  

Scholars F.L. Chen and T.Y. Ou at the National Tsing Hua University in Taiwan took this further with a 2011 study. The study documented sales forecasting advances when combining extreme learning-machine, so-called Taguchi statistical methods for manufacturing quality with novel analysis theories that work on variables with imperfect information.

Paper forecasts and Excel spreadsheets quickly become cumbersome. Sales forecasting capability is available in CRM software, sales analytics and automation platforms, and AI-driven sales technology. These capabilities often overlap among these applications.

Here are some of the features to look for when evaluating a sales forecasting tool:

• Integrations with other software, such as ERP, CRM, marketing suites, contact management, calendars, and more
• Automated collection of data and sales rep activity
• Real-time reporting
• Robust data security
• Analytics and automated scoring of deals
• Insights on most promising deals
• Scenario modeling
• Lead scoring
• Automated forecast roll-ups or summaries by category and team
• Dashboards and graphic displays of KPIs
• Benchmarking
• Customizable forecasting algorithms
• Forecast auditing and error analysis

Empower your people to go above and beyond with a flexible platform designed to match the needs of your team — and adapt as those needs change. 

The Smartsheet platform makes it easy to plan, capture, manage, and report on work from anywhere, helping your team be more effective and get more done. Report on key metrics and get real-time visibility into work as it happens with roll-up reports, dashboards, and automated workflows built to keep your team connected and informed. 

When teams have clarity into the work getting done, there’s no telling how much more they can accomplish in the same amount of time. Try Smartsheet for free, today.