- Helen Veetamm
This is about financial planning and consolidation. I think there are no related questions any longer about accounting software purposes. If you need to plan, report and consolidate financial data from several companies, you are probably facing the option of some kind of spreadsheets or some IT solution. Maybe you don’t even think about software solutions, as you think it’s too complicated, expensive or unnecessary. Think again — there are more IT solutions than you can expect. There are several databases with thousands of solutions (GetApp, Capterra etc). If you know what you need, just search for it.
But back to pros and cons — when should you consider the software and when the spreadsheet solution?
- Easy to use
- Suitable for small consolidations (max 5 entities) and simple planning
- Possibility to automate process (to some extent) with macros, formulas
- “Everyone” has it
- Not very expensive (depending on solution)
- Not suitable for complicated budgets or bigger consolidation groups
- Breaks easily (I think you know the situation where your formula is not working and you spend hours on finding why)
- Customized logic is known only for spreadsheet creator (personnel changes creates problems)
- Input data should be similar or needs adjustments
- Current and historic data accessibility is complicated
- Usually takes a lot of time and effort (expensive from the sake of salary expenses spent on time)
- Business models, reporting needs and IT solutions have changed, spreadsheet opportunities not really.
- Makes financial reporting process faster and more effective
- Gives extra time for CFO or head account to do more valuable activities
- Current and historic data accessible to all necessary persons
- No need for unifying accounting software (saves time and money; depending on financial software of-course)
- Gives extra value (budgets, reporting in one place; more accurate data; more information etc)
- Not effective, if used only once a year or additional value not seen
- Big ERP solutions can be time consuming and expensive (plus when something does everything, it is not usually effective)