"Excel just wasn’t designed to do some of the heavy lifting that companies need to do in finance.” So says Paul Hammerman, a business applications analyst at Forrester Research Inc. Despite that generally accepted fact, spreadsheets continue to be widely used as the default tool of choice for managing the finances of construction projects large and small. Most individuals that find themselves in this situation however, would enthusiastically agree that the use of spreadsheets for this level of complexity requires a ridiculous amount of meaningless effort for very little return. Far too much effort is put into getting the data into the spreadsheet – and all the formulas straightened out – that little time is actually spent analyzing that data.
Several decades ago, organizations used to manage all their finances using big paper-based ledgers, where they’d spend much of their day “doing the books”. These large ledger books worked for hundreds of years, however it would be a challenge to find any modern company today that runs their business on paper-based accounting methods.