Spreadsheets are common in the workplace and are the most used tool for preparing corporate budgets and forecasts mainly in small enterprises, but surprisingly also in larger organizations. With their familiar user interface, low cost of ownership and readily available functions and a powerful formula builder among the many tools these spreadsheets comprise, it is very tempting to use spreadsheets in the planning and budgeting process. This, however, becomes an increasingly more difficult task as companies grow larger, with more complex operations, more product and service lines, as well as more sophisticated reporting needs. CFOs and other finance executives and professionals soon discover that spreadsheets are not the right tool to use in this process for several compelling reasons. Among them are the inability to effectively scale the model without major redesign, the high risk of errors and omissions and of course the inability to generate complete and accurate financial statements such as a Balance Sheet and a Statement of Cash Flows. More and more CFOs are starting to realize that and switch to a software-based business budgeting solution.
Your Company Involves Many Departments
Even small and medium size organizations have multiple departments and often several or more locations, with distinct product or service lines, often organized in dozens or more business entities, departments and cost centers. Each reporting entity is expected to propose and maintain its own management approved budget, while a consolidation of all the individual budgets is performed in the finance organization according to the company hierarchy. This cannot be reasonably accomplished with a spreadsheet due to the numerous individual worksheets and workbooks linked together to accomplish the consolidation. As many finance professionals have experienced, the slightest change to any of these worksheets can wreak havoc in the budget consolidation, requiring tedious troubleshooting and repair of broken links, displaced formulas and functions and dealing with other issues. This can bring the entire budget process to a halt, usually when there is a process completion deadline on the near horizon.
Collaboration Requires Dealing with Multiple Time Zones
With different reporting entities located in different parts of the country or even in different foreign countries it becomes apparent that a centralized database must be used in conjunction with a dedicated planning and budgeting solution. Reliance on a spreadsheet is no longer an option even if there are only a few persons involved with accessing the data files.
Maintaining a Single Production Version
Maintaining document control for spreadsheets is a difficult task in any corporate environment even if there are only a few users of the master budget set of spreadsheet files. It is common to find that multiple persons are working on multiple versions of the same spreadsheet while there is no one file containing the latest data. It is much more preferable to use a database application to perform the planning and budgeting functions. Purpose designed planning and budgeting applications can allow many users in many reporting entities to be in the same database while simultaneously update data. Review and approval of the budget by finance management is done using one set of data which is always the most current version.
Exceedingly Large Revenue and Expense Budget Lines
As companies grow their accounting and reporting needs become increasingly more sophisticated. An increase in the number of revenue and expense accounts usually dictates a similar increase in the number of revenue, cost and operating expense budget lines. Organizing a large number of budget lines across multiple reporting entities makes the use of spreadsheets impractical. The purpose designed budgeting software with its dedicated database can naturally hold and maintain a much larger amount of data with division of data into logical and functional modules such as revenue and cost, operating expenses, fixed assets, personnel, liabilities and others.
International operations add additional challenges when using spreadsheets to create and maintain corporate budgets. One obvious challenge is maintaining and calculating currency translations from local currencies to the functional currency of the consolidated budget. This can be much easier handled in a corporate planning and budgeting software solution where all local currencies are defined and can easily be maintained as they change during the budget preparation period as well as during the forecast period. Other challenges such as multiple time zones, many reporting entities and large and increasing budget lines were mentioned above.
Numerous Product Offerings and Locations
The greater the number of company locations, divisions, departments and overall reporting entries, coupled with a large and increasing number of product or service lines the more difficult it becomes to prepare and maintain a corporate budget in a spreadsheet or a set of spreadsheets. This is a perfect example where finance executives must look for a dedicated budgeting solution with an underlying database, where multiple product lines, across multiple locations, and other data dimensions can be reliably set up and maintained without the worry of constantly updating and troubleshooting spreadsheets.
Government Regulators to Report to?
When a company is required to undergo an annual audit of its internal controls, end-user computing is one of the topics external auditors examine for proper design and effectiveness. Spreadsheets rarely have an internal control framework mitigating the inherit risks that they present. A change management process, as applies these spreadsheets, is very rare and often doesn’t exist which implies that the results produced by these spreadsheets cannot and should not be relied on. A dedicated planning, budgeting and analysis software solution with its built-in logic and pre-defined options and calculations is a much more robust alternative to the use of spreadsheets in this process.
Using business budgeting software such as Budget Maestro™ is inevitable as your business grows. The only question remaining is, how soon?
Businesses of every description rely on the Budget Maestro™ family of software solutions by Centage Corporation to improve the efficiency and effectiveness of their business budgeting and planning, financial forecasting, financial consolidation and reporting processes. For more information, take a tour of Budget Maestro, contact Centage, or call 800-366-5111 now.