How CFOs Can Reshape Enterprise Sales Forecasting with Virtual Sales Forecasting (VSF)

Editor's Note:Michael Ballou is a Senior Director in the Data & Analytics practice within the Consulting segment at FTI Consulting. The views expressed in this article are solely those of the author and do not necessarily reflect the views of FTI Consulting.

Even for the most experienced corporate finance professionals, accurately forecasting performance is no easy task. Building a reliable framework for future performance insights is a key driver of business success, supporting strategic planning and reducing unexpected shocks.

Cost forecasting presents its own unique challenges, but overall, companies have far more control over the scale of their expenditures than over their sales revenue. Sales forecasting requires quantifying the impact of future customer behavior on revenue, which typically involves multiple time-consuming steps, data extraction from multiple sources, cross-functional participation, and a considerable degree of speculation.

Traditional forecasting processes may provide valuable information, but in my observation, their complexity and extensive manual processing time often limit the frequency of reforecasting to monthly, quarterly, or even semi-annual intervals. As a result, strategic decisions are often based on outdated forecasts that do not reflect changes in the sales environment in real time.

Pain Points of Traditional Sales Forecasting Processes

A typical sales forecasting process generally looks like this:

The finance team establishes a baseline revenue forecast based on sales data from existing customers, analyzing general ledger data (taking into account seasonality and other known business cycle trends).

Subsequently, the sales team overlays forecasts for new business, which comes from extracting opportunity records in the customer relationship management (CRM) system, requiring manual analysis of sales funnel stages, win probabilities, and opportunity sizes.

Finance and sales departments, possibly in collaboration with customer service and IT departments, jointly forecast potential future business attrition based on analysis of the competitive environment, expiring contracts, subscription status, and other risk factors.

This foundational process may produce reliable sales forecasts, but it requires time investment from four business departments and involves three rounds of manual analysis. This does not yet account for the complexities unique to each company—for example, the impact of manufacturing on order fulfillment, product installation cycles for new customers, or high customer churn rates resulting from aggressive new-customer pricing. These factors all need to be analyzed separately to assess their impact on revenue forecasts.

After completing the internally focused forecast, companies also need to consider external factors such as changes in consumer preferences, macroeconomic fluctuations, and new competitors entering the market, all of which can significantly impact the forecast.

By the time an updated traditional forecast is finally completed, it may have consumed days or even weeks, and the results remain static until the next forecast cycle.

Building a Virtual Sales Forecast (VSF)

There is a better solution: the Virtual Sales Forecast (VSF). Most modern enterprises have analytical tools that can connect data sources and automate the analyses, assumptions, and adjustments previously performed manually, enabling more efficient, accurate, and actionable sales forecasts. Think of it as building a robotic assembly line for sales data.

Instead of extracting data into Excel for analysis, VSF leverages a data warehouse architecture, accessing CRM records, financial data, order entry systems, and other key forecasting drivers through backend connectors and application programming interfaces (APIs). Automated programs integrate data from different sources, process the numbers, and deliver results that might take days or even weeks with manual processes. Data visualization tools such as Tableau and Power BI provide the infrastructure to clearly present and securely distribute reports across the organization.

The advantages of VSF extend beyond refresh frequency—it also presents forecast results at a more actionable level of detail. Due to front-end software limitations and manual processing bottlenecks, traditional sales forecasts are typically top-down, based on applying assumptions to aggregated results and then adjusting for major accounts and known events. This means traditional forecasts are limited by the granularity of the data available at the time they are generated.

VSF, in contrast, is built as a bottom-up model through data connectivity and computational power, providing granular detail. The VSF model applies appropriate forecasting methods to each customer and product, then aggregates forecasted revenue at any level of granularity available in the dataset, such as customer type, product category, or sales region. With row-level security features in data visualization software, reports can be securely distributed across the organization, allowing executives to view the entire business while regional managers see only their own assigned customers.

Benefits of VSF

When designed and executed properly, VSF can automatically present the latest sales forecast each morning in a clear, concise dashboard. These figures integrate the most current information available within the organization, including elements such as the general ledger, CRM tools like Salesforce, operational data stores (ODS), manufacturing software, and master data attributes.

In a recent project completed for a telecommunications and media company, my team transformed a traditional forecasting process into a modern VSF, enabling the following capabilities:

• Sales executives can view the forecasted revenue impact of new, won, and lost opportunities, as well as updated contract win probabilities;
• Operations and supply chain leaders can manage revenue risk arising from product installation schedules being pulled forward or delayed;
• Product managers can understand the extent to which changes in development timelines impact future revenue streams;
• Customer service representatives can plan response activities for unexpected intraday fluctuations in order entry.

Most importantly, the finance team can continuously learn from the interactions among different revenue drivers and assess what updates are needed in forecasting methodologies.

From an organizational perspective, executives can now drill down into specific elements of the VSF to understand issues, evaluate the drivers of change, and make informed decisions on pressing matters while absorbing information valuable for long-term strategic planning. Day-to-day managers can drill down into specific customers, regions, consumer types, or product categories as needed, guiding business decisions and freeing up valuable time for analysis and action. Forecasts are no longer refreshed monthly or quarterly but are updated every morning.

The project was completed in 10 weeks, but depending on data complexity and the systems involved, the timeline could range from 6 to 12 weeks. The outcome of this one-time investment is a sustainable, automated, and repeatable process with limited ongoing maintenance burden for the IT organization. Finance, accounting, and customer service teams can focus on forecast impact and business improvement opportunities rather than manual data collection and processing. More importantly, the connectivity and level of detail provided by VSF enable companies to continuously measure and optimize forecast accuracy, leading to more reliable forecasts and better business outcomes.

The views expressed herein are solely those of the author and do not necessarily reflect the views of FTI Consulting, Inc., its management, subsidiaries, affiliates, or other professionals. FTI Consulting, Inc., including its subsidiaries and affiliates, is a consulting firm and is not a certified public accounting firm or a law firm.