Do you still rely on spreadsheets in your daily treasury operations?
| 24-08-2016 | Jan Meulendijks |
Spreadsheets, every treasurer knows how to work them. Spreadsheets are deeply embedded in treasury operations and they seem hard to eliminate. We have read multiple articles on this subject lately and we decided to ask our community: Why do treasurers still rely on spreadsheets? (source: gtnews.com)
[separator type=”” size=”” icon=””]
Jan Meulendijks
In many cases the treasurers of companies have started their area of expertise with smaller (SME) companies, where the available ERP-system did not offer treasury features and/or no separate treasury system was in use. So… you build it yourself in a spreadsheet. The big advantage of this is that such a spreadsheet only features what you really need, and can be kept quite simple but effective.
When the treasurer moves up to a larger company, the basic spreadsheet can be expanded with any new features required. Again, simple but effective. The big disadvantage of course, is lack of system documentation and dependance on the original designer to transfer knowledge to others.
I would like to classify this phenomenon under the “80/20”-rule: with a few basic spreadsheet functionalities you can achieve 80% of your treasury requirements, to achieve the remaining 20% you have to undertake large operations and investments. Is that all worth it???
[separator type=”” size=”” icon=””]
Do you still rely on spreadsheets in your daily treasury operations?
