By Johan Smith - 10 Jan 2021
70-80% of all businesses rely on spreadsheets for their financial reporting and budgeting. Spreadsheets are useful, but NOT for recurring processes. It is time-consuming to renew the numbers every month, copy-paste new data, make manual changes, update formulas etc.
The ease with which you can create a spreadsheet is also one of its biggest problems. What begins as a small report or budget model quickly grows into something massive, which becomes harder to maintain, and harder to trust, as time goes on.
Some of the most common problems are:
Research shows that nearly 90% of spreadsheets contains errors. Incorrect formulas, wrong logic, copying mistakes, hardcoded values, or lack of format often leads to problems.
There is a joke that only 3 things can be generally wrong with spreadsheets: the data, the formats, and the formulas. Often there is little certainty that a spreadsheet contains the most recent data, correct formulas, and consistent format ... other than going through the entire spreadsheet and check it all, cell by cell. Every time again.
Updating spreadsheets with new data is tedious. Entering and checking data in a spreadsheet is a waste of your time. As a finance professional, your skills and time are too valuable for this.
Copying and pasting data every month, updating formulas every month, and checking it all manually .. surely, the novelty has worn off and you rather spend your time on analyzing your numbers, not preparing them?
If your business has multiple companies, dimensions, or data sources, it is very tedious to collect, consolidate, and update all data across all these dimensions.
It is difficult to have multiple users work in the same spreadsheet at the same, and keep some level of control over who edits what.
You can add some security to spreadsheets, but it is of limited use. Protection is geared much more towards the overall file, rather than the logic, formulas, and data. You can lock some sheets and cells, but if users have to work with the data, they can usually change it.
Spreadsheets are all-or-nothing. Users can inadvertently change formulas, insert or delete data in the wrong place, overwrite formulas, all without proper process and change control.
It is very hard, if not entirely impossible, to enforce a clear and reliable process flow involving multiple steps across multiple users. For example, consolidation of multiple companies or a multi-department budget process typically involves sending and receiving a myriad of files or different versions, and merging them all together. Who has the latest file? Where is it? Have any formulas been changed?
In short, spreadsheets won’t help you run your business more efficiently. You are better off using XLReporting, which overcomes all above problems.← Back to articles