Budgeting By Hand

29.04.2011
I realize we're a long way from the days of pen-and-paper ledgers. But we're also, it seems, far from taking full advantage of the tools available today to ease financial tasks.

In presented by , a maker of modeling and analytics software, a majority of the 287 respondents say they must rework budgets quarterly, and answer more than four requests for ad hoc scenarios per year.

Almost a quarter of the respondents lament that they must turn those ad hoc scenarios around within 24 hours. Couple this tight time frame with the fact that companies with a work force of more than 5,000 say they have almost 350 people involved in the financial planning and analysis process, and you wonder how anything can get done. Especially considering that almost half (48.8%) said IT has no involvement in this process. Almost HALF!

Let's take this a step further. Very few companies say they use targeted tools for business intelligence, budgeting and planning, or business modeling. Yet about 90% rely on spreadsheets. So, connect the dots and, of course, that's why IT's not involved. You don't typically need IT to support spreadsheets.

However, if you look at the biggest technical challenge that these respondents face -- overcoming internal data silos and needing to roll up multiple and inconsistent sources of data -- then you start to question the wisdom of a spreadsheet-centric, non-IT approach. One of the other big challenges reported was the inability to view data in multiple dimensions such as by region, product group, etc.

Developing accurate, insightful forecasts, budgets and plans is hindered, according to the survey, mostly by the difficulty in getting comprehensive and reliable data in a timely fashion.