Articles & E-Books


The Top 5 Forecasting Problems Your Business May Face — and How to Tackle Them

Nov 13, 2018

Financial planning is the cornerstone of every business’s continued success. The process of allocating funds and determining how to best use those funds to achieve both short- and long-term business objectives is vital and powerful.

One of the key elements in the planning cycle is the need for accurate forecasting — not always an easy task. In fact, there are some serious pitfalls that commonly prevent companies of all maturity levels from accomplishing good forecasting and thereby realizing sound, strategic financial planning.

In my experience, these are the five most prevalent problems companies face:

1. Organizational Misalignment

When it comes to planning and forecasting, alignment is one of the most critical components. Companies must ensure their business leaders not only understand the financials, but also recognize how to accomplish the organization’s financial goals.

Finance teams must work across departments to first assess their organization’s various leaders’ understanding of the forecasting and planning process, then align goals. Do all leaders in your organization think about the financial impacts of the decisions they’re making? Does everyone have the same priorities and are they moving in the same direction? Create a cohesive team by getting everyone on the same forecasting page and planning path.

2. Financial Forecasting Inefficiencies and Lack of Data Credibility

From incomplete information to disconnected data within the forecast, many forecasts have credibility issues. Often the forecast simply fails to tell the authentic story of where the business is headed.

Without credible data, a forecast simply will not be effective. It certainly won’t support those all-important leadership discussions, nor will it establish the organization’s necessary trust in the numbers. It’s also going to have little value and therefore little impact on the business. 

There are a few solutions that can help organizations patch quality issues and get the valuable data they need to drive business decisions. To start, finance teams should spend time implementing structured processes, checks and balances and analytical procedures that allow them to compile the right forecasts with credible data, every time. Teams can also create workflows and introduce structured templates to allow for easy replication and consistent data presentation across business functions. Finally, spending time developing your finance staff to be trusted business advisors will also drive credibility and increase your organization’s decision-making capabilities.

3. Operational Data Issues

In the process of reporting and analyzing, problems will arise when it’s necessary to leverage operational data for insights. The data either isn’t in a format that can be easily accessed or it isn’t easily analyzed, particularly when there’s a business issue to address.

Additionally, companies aren’t always able to report on key metrics in a timely manner, nor does everyone within the organization understand what those metrics mean. The data simply does not support the performance metrics the business needs. 

Real-time reporting can go a long way toward helping finance teams address operational data issues. By leveraging software with built-in dashboards and optimal visibility, teams can easily pull and analyze data and access it anywhere, any time. Advanced analytics programs also empower teams to further solidify the data they gather and deliver it to leaders who need it to make important business decisions.

4. Cumbersome Financial Consolidation

Every business wants to cut down the number of days to close books. The faster the time to close, the faster the lead times to make sound business decisions. When closing is delayed, executive management won’t be able to get critical information quickly enough to support their decisions. The right software tools can help simplify this complicated process.

At a minimum, Excel worksheets can be valuable in helping finance teams compile, organize and deliver financial information in a format that is easily accessible to business leaders. Teams can also take this a step further by investing in software solutions that enable you to cut days from your close process through automated, dynamic journal entries, which can pull the appropriate amounts from the correct accounts to create eliminating, controlling interest and reclass entries.

5. Difficulty With Translating Foreign Currency

A key part of the financial statement consolidation process is foreign currency translation. Needless to say, there’s also a lot of complexity in translations, especially when multiple countries are involved, which can add several days to closing the books. It’s also very difficult to incorporate currency translations into an effective forecast process.

While this is another area in which Excel worksheets can help (particularly if they include links and checks and balances, as I described above), a more viable option would be to leverage an automated accounting platform for reporting in both local and common currencies. This type of technology also allows finance teams to store conversion rates by account and time, which means their forecasts will include conversions and cut days from the close process.

Financial planning and analysis help businesses achieve their goals and grow forward with intention. By recognizing and avoiding these five forecasting pitfalls, you can ensure your organization develops a plan that promotes clarity, informs leaders and fosters effective decision-making. Need help navigating the financial planning and analysis process? Contact me at or 414.290.8023 to learn more.