What is planning, budgeting and forecasting?
Planning, budgeting and forecasting is typically a three-step process for determining and mapping out an organization’s short- and long-term financial goals.
- Planning provides a framework for a business’ financial objectives — typically for the next three to five years.
- Budgeting details how the plan will be carried out month to month and covers items such as revenue, expenses, potential cash flow and debt reduction. Traditionally, a company will designate a fiscal year and create a budget for the year. It may adjust the budget depending on actual revenues or compare actual financial statements to determine how close they are to meeting or exceeding the budget.
- Forecasting takes historical data and current market conditions and then makes predictions as to how much revenue an organization can expect to bring in over the next few months or years. Forecasts are usually adjusted as new information becomes available.
The process is usually managed by a chief financial officer (CFO) and the finance department. However, the definition can be expanded to include all areas of organizational planning including: financial planning and analysis, supply chain planning, sales planning, workforce planning and marketing planning.
Discover the power of integrating a data lakehouse strategy into your data architecture, including enhancements to scale AI and cost optimization opportunities.
Basic business accounting practices date as far back as the 1400s, when Venetian investors kept track of their Asian trade expeditions using double-entry bookkeeping, income statements and balance sheets. The word “budget” is from the old French word “bougette,” meaning “small purse.” The British government began to use the phrase “open the budget” in the mid-1700s, when the chancellor presented the annual financial statements. Businesses began to regularly use the term “budget” for their finances by the late 1800s.
Modern business forecasting began in response to the economic devastation of the Great Depression of the 1930s. New types of statistics and statistical analyses were developed that could help business better predict the future. Consulting firms emerged to help companies use these new prediction tools.
Accounting and forecasting were difficult in the early 20th century because they depended on laborious hand-written equations, ledgers and spreadsheets. The emergence of mainframe computers in the 1960s and personal computers in the 1980s sped up the process. Software applications such as Microsoft Excel became widely popular for financial reporting. However, Excel programs and spreadsheets were prone to input errors and cumbersome when various departments or individuals needed to collaborate on a report.
By the start of the 2000s, companies gained access to ever-growing operational data sources, as well as information outside corporate transaction systems — such as weather, social sentiment and econometric data. The vast amounts of available data for forecasting created a need for more sophisticated software tools to process it.
Numerous planning software packages emerged to handle this data complexity, making planning, budgeting and forecasting faster and easier — both for processing and collaboration. With predictive insights drawn automatically from data, companies could identify evolving trends and guide decision making with foresight, not just hindsight.
Today, cloud-based systems are becoming the standard, providing more flexibility, security and cost savings — helping organizations generate accurate predictions and budgets with fewer errors.
But despite these advancements, businesses are still quite dependent on traditional spreadsheets.1 Seventy percent of businesses say they rely heavily on spreadsheet reporting, with only 16 percent using on-premise specialist software — and only ten percent using cloud software for planning.
Many businesses still base their strategy on annual plans and budgets, which is a management technique developed over a century ago. But in today’s more competitive environment, organizations are realizing that plans, budgets and forecasts need to reflect current reality — not the reality of two, three or more quarters ago. Continuous planning and rolling forecasts are becoming widely used methodologies to update plans, budgets and forecasts frequently throughout the year, on a quarterly or even monthly basis. These approaches help managers spot trends before their competitors — helping them make better informed, more agile decisions about pricing, product mix, capital allocations and even staffing levels.
Creating and implementing a sound planning, budgeting and forecasting process helps organizations establish more accurate financial report and analytics — potentially leading to more accurate forecasting and ultimately revenue growth. Its importance is even more relevant in today’s business environment where disruptive competitors are entering even the most tradition-bound industries.
When companies embrace data and analytics in conjunction with well-established planning and forecasting best practices, they enhance strategic decision making and can be rewarded with more accurate plans and more timely forecasts. Overall, these tools and practices can save time, reduce errors, promote collaboration and foster a more disciplined management culture that delivers a true competitive advantage.
Specifically, companies are able to:
- Quickly update plans and forecasts in response to new threats and opportunities, identifying risk areas early enough to rectify issues before they are serious.
- Identify and analyze the impact of changes as they occur.
- Strengthen the links between operational and financial plans.
- Better plan and predict cash flows.
- Improve communication and collaboration among plan contributors.
- Consistently deliver timely, reliable plans and forecasts, plus contingency plans, for a range of possible events.
- Analyze variances and deviations from plans and promptly take corrective action.
- Create a budget specifically for growth and having confidence in how much can be spent.
- More accurately manage sales pipelines while tracking performance against targets.
- Make more confident strategic decisions based on hard data, instead of hopes or guesswork.
- Provide evidence of an organization’s future trajectory to potential investors and lending institutions based on multiple data sources and sophisticated analysis.
Budgeting, planning and forecasting software can be purchased as an off-the-shelf solution or as part of a larger integrated corporate performance management (CPM) solution.
Advanced software solutions enable organizations to:
- Measure and monitor performance through interactive, self-service dashboards and visualizations.
- Examine root-causes with high-fidelity analysis of dimensionally rich data.
- Evaluate trends and make predictions automatically from internal or external data.
- Perform rapid what-if scenario modelling and create timely, reliable plans and forecasts.
Planning is easier and more effective when practitioners follow well-established best practices. Software solutions that support these practices can enhance the timeliness and reliability of information and increase participation by key people throughout the organization; especially those at the front lines.
Leading companies have moved to solutions that address the full planning cycle — data collection, modeling, analytics and reporting — on a common planning platform with lean infrastructure requirements. Such platforms can handle a diverse range of business functions, from budget-focused finance tasks to, for example, supply chain-focused planning for retail environments with thousands of SKUs (stock keeping units).
Companies like IBM offer holistic, integrated software solutions to streamline the planning, budgeting and forecasting process. The logic is that to adapt to today’s quickly changing business conditions, an organization needs one solution that creates a single source of truth and visibility into all its data. These solutions can extend well beyond the financial aspects of the business, becoming a powerful forecasting engine across the enterprise. With these agile planning and exploratory analytics software solutions — whether in the cloud or on-premises — companies can perform planning, budgeting and forecasting with greater speed, agility and foresight.
Evaluating and selecting planning, budgeting and forecasting software is a complex task. It requires careful consideration of the software’s functionality, its value to the planning process and its ability to support planning best practices. There are also factors such as vendor reliability and support, user community connections and commitment to customer success once the sale is complete.
IBM Analytics recently published a guide to help organizations evaluate planning, budgeting and forecasting software — identifying key qualities to look for:
- Adaptive. Can you rapidly change models and re-forecast frequently, based on input from business units? Can you update plans as often as necessary?
- Timely. Is your information always current because users contribute directly to a central planning database? Are your consolidations and rollups done automatically to easily meet deadlines?
- Integrated. Do your planning, analysis, workflow and reporting functions reside on one common platform, reducing the need to maintain “shadow” planning systems?
- Collaborative. Is your solution web-based? Does it enable participation anytime, from anywhere with a secure connection?
- Self-service. Are users able to access data and perform complex analysis without the assistance of IT? Are you able to use a familiar spreadsheet interface for faster user adoption and accelerate time to value?
- Enterprise-scale data capacity. Is your solution capable of handling very large data volumes without limiting cube size? Some solutions do not handle “data sparsity” well — forcing data to be split into multiple cubes for analysis, causing version control issues.
- Efficient. Are your managers able to spend less time managing data and more time managing the business?
- Relevant. Do you have the ability to customize views for different user roles, to help increase adoption and process ownership? Do you have formula capabilities that enable modeling of all relevant business drivers?
- Accurate. Do your plans contain errors because of broken links, stale data, improper rollups and missing components?
The key is not just evaluating product features and capabilities, but also evaluating how those features will be implemented by different users within the organization. It’s important to test any planning solution that will be used by a large variety of stakeholders such as finance, operations, HR and sales.