{"id":10269,"date":"2019-02-21T15:21:00","date_gmt":"2019-02-21T20:21:00","guid":{"rendered":"https:\/\/www.sage.com\/en-us\/blog\/?p=10269"},"modified":"2026-02-12T05:17:49","modified_gmt":"2026-02-12T10:17:49","slug":"spreadsheet-based-forecasting-is-not-board-worthy-heres-why","status":"publish","type":"post","link":"https:\/\/www.sage.com\/en-us\/blog\/spreadsheet-based-forecasting-is-not-board-worthy-heres-why\/","title":{"rendered":"Spreadsheet-based forecasting is not board worthy\u2014here\u2019s why"},"content":{"rendered":"
\n\t
\n\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\tFree guides and webcasts<\/a>\t\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t
\n\t\t\t\t\t

\n\t\t\t\t\t\tSpreadsheet-based forecasting is not board worthy\u2014here\u2019s why\t\t\t\t\t<\/h1>\n\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t<\/div>\n\t\t

\n\t\t
\n\t\t\t
\n\t
\n\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t
\n\t\t\t\n\t\t\t\t\"ben-collins\"\t\t\t\tBen Collins<\/span>\n\t\t\t<\/a>\n\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\n\n

Last time, I talked about the important truths hiding from CFOs who use spreadsheet-based budgets and email to collaborate. Read the article<\/a>. In this final article of a three-part series, I\u2019ll address why spreadsheets don\u2019t give finance teams enough time to do what-if analysis and forecasting and are never \u201cboard worthy.\u201d At Sage Intacct, we\u2019ve highlighted \u201cThe 8 Signs that Your Company Has Outgrown Excel for Budgeting and Planning.\u201d<\/p>\n\n\n\n

Budgets are only as useful as what you anticipate happening to the business. The reality is that you can\u2019t plan for everything, especially when you don\u2019t always receive advanced notice when a big event will occur. So, when something unplanned happens and actual results don\u2019t go according to plan, such as missing profitability targets, the CFO must forecast what the company is likely to achieve by the year-end. And this forecast usually involves revisiting the budget and identifying which accounts need to be adjusted. While there is so much uncertainty to consider when predicting a forecast, the CEO and board expect forecasts to be very accurate, sometimes to within 1% of actual results.<\/p>\n\n\n\n

The latest spreadsheet version is outdated, and you weren\u2019t notified of the changes<\/h2>\n\n\n\n

For finance teams that do spreadsheet-based budgeting, a forecast often lives in a separate spreadsheet that resembles a financial report of all the budget lines, and the budget targets set at the beginning of the year would likely be the starting point for making updates. A finance person would then either change the budget values directly in the spreadsheet or create a new model based on a relationship of input assumptions to calculate projections for the different financial account lines in the report.<\/p>\n\n\n\n

This process breaks down when the finance team uses the spreadsheet they think is the latest version of the budget and actuals for doing a forecast when unknowingly, the selected spreadsheet is outdated. When looking at the latest version of a spreadsheet, the finance team doesn\u2019t have a way to verify that all the information is current. Changes have occurred that live in other spreadsheets, such as budget assumptions or updated actuals from the accounting system. When these changes aren\u2019t shared with the finance team or sit in an email that\u2019s buried in an inbox, any forecast based on the \u201clatest but outdated\u201d spreadsheet version will mislead the board and ruin the finance team\u2019s credibility.<\/p>\n\n\n\n

Hidden adjustments are buried in spreadsheets<\/h2>\n\n\n\n

The second issue is when a finance professional adjusts a consolidated company budget to forecast the changes affecting the business. How much of an adjustment should you make relative to the original budget? Which assumptions do you need to change, and which accounts should be impacted? How do you spot the changes in your assumptions that have offsetting effects with each other in the report? While a spreadsheet-based report easily shows the updated forecast values, the issue is that the adjustments you made are hidden within the spreadsheet cells, grid coordinates, and formulas in your model. When someone else looks at this forecast, how can they see which values changed?<\/p>\n\n\n\n

When adjustments to the budget are hidden from plain sight on a report, a finance person can\u2019t make the necessary comparisons to evaluate the forecast. For example, if I\u2019m forecasting 10% less revenue than the original plan for the remainder of the year, how much of the projected change is due to my headcount assumption, my average selling price assumption, or some other assumption in the model? And since spreadsheets can\u2019t track the incremental adjustments you\u2019ve made to a report, finance doesn\u2019t have a way to explain the thinking and rationale underlying the forecast relative to the original plan.<\/p>\n\n\n\n

For example, a client of mine developed business software sold as subscriptions. The company had missed first-quarter goals, and the CEO wanted a forecast for the rest of the year. Since the competitive landscape had changed, the original budget numbers had to be updated since they didn\u2019t reflect the current environment. Using spreadsheets, the finance team built a sales capacity model to project revenues based on multiple assumptions: headcount hiring, annual subscription sales price, and quarterly sales ramping and seasonality productivity percentages.<\/p>\n\n\n\n

However, after the finance team input the forecasting assumptions into the model, they didn\u2019t have any visibility into how much each assumption was contributing to profitability. And when the team met with the CFO and CEO to review the forecast, the team also couldn\u2019t explain how the forecast values had diverged from the original assumptions underlying the budget numbers. When the CEO asked the finance team \u201cwhat was our thinking in assumptions when we did the budget,\u201d the finance team couldn\u2019t answer since that information was \u201cleft behind\u201d months ago in another spreadsheet during the annual budget cycle.<\/p>\n\n\n\n

Senior leaders and finance analysts are under pressure and unable to work together to develop a credible forecast. At the end, they finish the meeting feeling unsatisfied about the results and anxious about the upcoming Board meeting. For this client, the business cost and time commitment associated with making procedural decisions around hiring, pricing policy, and sales execution all vary with each other. A productive discussion around forecasting should enable any business leader not only to see their options but also to quantifiably understand the trade-offs amongst their options. Spreadsheets prevent these important discussions from taking place.<\/p>\n\n\n\n

Ideal solution<\/h2>\n\n\n\n

The ideal solution should allow any finance person to make changes in a forecast model and compare the results, both inputs and outputs, to the budget. The ideal solution should also allow changes to be iterated quickly. One of the inherent challenges with forecasting is the uncertainty factor and the likelihood of having to consider different outcomes. The ideal solution should be able to track the incremental changes for multiple outcomes and show quantifiable comparisons with the budget. Sage Intacct Budgeting and Planning<\/a> is designed to enable finance teams to do rapid what-if analysis and give finance both the time and confidence to produce credible forecasts that are board worthy.<\/p>\n\n\n\n

Conclusion<\/h2>\n\n\n\n

If you\u2019ve read the articles in this series, there is a recurring theme about the loss of visibility into the key details and assumptions underlying a budget when using spreadsheets. Spreadsheets don\u2019t provide the necessary detail and contextual support to explain what\u2019s being reported on the surface. To tell if it\u2019s time to replace your spreadsheet-based budget, look for the 8 signs within your finance team.<\/p>\n\n\n\n

Learn more by downloading \u201cThe 8 Signs that Your Company Has Outgrown Excel for Budgeting and Planning.\u201d<\/u><\/p>\n\n\n\n

\n\t
\n\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t

8 Signs Your Nonprofit Has Outgrown Excel for Budgeting and Planning<\/h2>\n\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tDownload<\/a>\n\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\"A\t\t\t<\/div>\n<\/div>\n\n\n
\n\t
\n\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t

Subscribe to our Sage Advice Newsletter<\/h2>\n\n\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t

Get our latest business advice delivered directly to your inbox.<\/p>\n\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tSubscribe<\/a>\n\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\"Working\t\t\t<\/div>\n<\/div>\n\n

\n\t
\n\t\t
\n\t\t\t
\n\t\t\t\t

Browse more topics from this article<\/h3>\n\t\t\t<\/div>\n\t\t\t
\n\t\t\t\t