Can a more accurate sales forecasting process help in pulling in more revenue for businesses? Check out these five strategies today.
In this article:
With so many business and finance leaders facing unprecedented market disruption and the need for wholesale transformation in their businesses, there has never been a more crucial time to get a grip on revenue forecasts. This is the perfect time for companies to take a serious look at making accurate sales forecasts.
Strong revenue predictability based on historical data provides a sound platform for the critical decisions that need to be made in these tumultuous times.
These headlines spell out the obvious: predictability is something many businesses still can’t deliver. Although there is no silver bullet in revenue forecasting, my view is that the first place to look at is within the sales function.
Why? Well, I think it’s mostly dysfunctional.
In my experience, the sales profession considers forecasting as nothing more than a necessary evil that has been mandated by finance. I have lost count of the times I have heard, “It’s just a distraction from our real job of selling.”
What’s more, the sales data doesn’t lie and there are endless metrics that showcase how dysfunctional sales forecasting actually is today:
According to SiriusDecisions, 79% of sales organizations miss their forecasts by more than 10%. CSO Insights reported in their most recent annual survey that 54% of the deals forecast by reps never close.
So as the CFO, statistically, you might as well toss a coin if you want a more accurate forecast than the sales team is giving you.
According to SiriusDecisions, reps spend an average 2.5 hours per week and managers 1.5 hours on forecasting. Yet, they often don’t anticipate missing targets or realize too late in the quarter to take action.
This just isn’t sustainable for any business, so what can you do to fix this broken sales forecasting process?
Here are five strategies to use to build a more accurate sales forecast:
Make it mandatory and part of the culture to ensure that sales provide accurate data on deals and opportunities.
There are a number of ways to ensure this happens. You can create dashboards to highlight good and poor data stewardship by team or by rep. You can set up simple flags and alerts to highlight lazy and poor behaviors, e.g., an emailed alert to highlight deals with close dates in the past or deals that have close dates pushed by more than X times in a quarter.
Given the value of accurate data, some organizations have gone as far as linking KPIs and compensation to data hygiene. Ultimately you need to hold sales leaders accountable for the data quality of their sales team.
Link KPIs and compensation to forecast accuracy.
Maybe this won’t be well received in the sales community, but nothing focuses the mind more than putting pay on the line. I have seen this work well when it is introduced alongside other change processes in sales forecasting, i.e., when a new tool or process is implemented.
In my experience, I have seen KPIs that are tied to a range of forecast tolerances with the most common being in the range of +/- 5% of the opening forecast.
Keep it simple and don’t overdo the frequency.
Nothing turns salespeople off more than making it time-consuming and onerous to forecast. Having to forecast too frequently or making the process overly taxing just means it will not get the sales team’s focus or attention it really deserves.
You will also end up taking away critical selling time and the sales team’s ability to deliver a sales forecast will be hugely diminished.
Use a common set of tools for pipeline management and forecasting.
Ensure that sales and finance teams use the same platform for sales pipeline management and forecast processes. Any disconnect here just opens up data challenges and typically wastes endless time discussing the validity of the numbers. When forced to use the finance forecasting tool, it gives sales a reason not to update their data in the CRM system.
Use your CRM as the system of record for pipeline data and avoid spreadsheets at all costs. When you’re juggling multiple spreadsheets and the complexities of a global or matrixed organization, the errors and inaccuracies pile up. What’s more, building and maintaining these complex spreadsheets is time-consuming and often incredibly expensive.
Deploy a pipeline analytics tool that can easily show you what has changed and provide both finance and sales early insight into deal and pipeline risk.
Ensure that the forecasting platform you are using gives both sales and finance what they need. Excel gives finance the flexibility to roll up the numbers in multiple dimensions (e.g., product, region, sales org), but it just isn’t designed to handle the complexity of matrix, overlay, and channel sales organizations.
Use data science to score deals by comparing them to deals you have won in the past.
So many sales forecasts are based on the “gut instinct” of the sales team. There will always be some subjectivity in forecasting, but judgments should be based on objective data. Historical trend data and top-down run rate predictions have some value in forecasting, but in today’s rapidly changing markets a bottom-up, deal-by-deal forecast is essential.
The challenge here is that anecdotal details and personal judgments can dilute the accuracy of the numbers as they are rolled up through the sales organization. Sales managers usually know the right questions to ask, but they often lack the time to inspect every opportunity, so this isn’t the fail-safe that most companies believe it is.
To get around this, I am increasingly seeing companies utilizing data science to score deals by comparing them to deals they have won in the past. This provides an objective data-based view of a deal’s likelihood to close and gives a great benchmark with which finance functions can compare the sales leadership numbers.
Although the accuracy of these data science-based algorithms is shown to outperform human judgment, my advice is to use them to augment human forecasting processes, not replace them.
So, my takeaways are that forecasting has become a painful, time-consuming process. Wasted time cripples everyone and company leaders just don’t have the reliable projections they need to build a predictable business.
It’s time for the sales function to stand up and take accountability for its forecasting and become a real business partner to the finance team. For this to happen, the business also needs to deliver the right tools, processes, and cadence for accurate sales forecasting. Use data and science alongside human insights in every forecasting judgment.
What’s the biggest blocker to accurate forecasting for your company? Share your experience with sales forecasting in the comments section below.
Discover how predictive forecasting can help you improve your forecast accuracy by grabbing the free ebook below.