You probably weren’t expecting an EZLease blog to be written by the marketing guy, right? Well, although I am not (by a long shot) a lease accounting expert, I am at least not completely out of my depth here. Not a lot of people know this, but I am actually a fully qualified accountant. I qualified as a Chartered Certified Accounting (ACCA) in the UK with KPMG, back in 19….. Well, let’s just say that it was a little too close for comfort to the decade that spreadsheets were invented! I even practiced for a while as an auditor. But before you start to worry too much, I am not here to flex or impart any accounting knowledge or advice.
What I am here to stand-up and publicly admit is that I am a spreadsheet-oholic and more than that, I am the worst culprit. I wear my hard-earned badge with pride:I am a ‘spreadsheet martyr’.
I confidently pull out my multi-tab, color-coded, formula-heavy spreadsheet, with its highlighted fields for inputs and assumptions and beautifully formatted summary results and charts, while proudly reminding you how late into the night I worked, building all of the amazing complexity.
Spreadsheets have been a pillar of my career from my time as an accountant, to building stock-price analysis models as an investment analyst, to starting my own company and building financial models for VCs, to the reverse waterfall models that underpin my current role as a data-driven CMO. Trust me, I have built some late-night masterpieces (and based on what I outline in this blog, I’ve probably wasted quite a bit of time).
But clearly, I love spreadsheets; I love that they are easy-to-use and don’t require me to spend any money for each new application. I love that I can easily create a complex thing of beauty. For all of these reasons, spreadsheets lure you in with a false sense of security – cheap, easy and powerful makes them a go-to for most people’s complex modeling/calculation needs, especially when a fit-for-purpose app might not exist (hint: there IS an app for lease accounting… but I think you guessed as much!).
Unfortunately, because of this, spreadsheets have moved from productivity tools for internal projects into the much more dangerous territory of mission-critical applications that they were never designed to be. And, while they may be necessary when a suitable app is not available, they are a false economy when there is a fit-for-purpose solution – especially for a mission-critical application that will be used on an ongoing basis, by multiple people. And, while spreadsheets may seem cheap, the real cost and risk of using them is indirect and is often discovered far too late.
Let me elaborate…
But beyond these costs and risks, there are other reasons, specific to the lease accounting standards that make spreadsheets unfit for purpose:
In a nutshell, spreadsheets are the wrong tool to do anything that involves a) more than one person, b) data that changes over time, c) multiple stakeholders, and, most importantly, d) complex projects where the output has legal or compliance consequences.
You might be thinking that all of this is just a trade-off. You might be saying to yourself “my budgets are tight, the costs and risks of using spreadsheets might be a price worth paying if the cost of an alternative fit-for-purpose solution is much higher. And after all, none of this applies to me because I am a ‘spreadsheet ninja’”! But, I am here to tell you that that simply isn’t the case – in fact, I can almost guarantee it.
The simple fact is that apps like EZLease are not expensive. Think of EZLease as the “Turbotax of lease accounting.” Sure, I could learn all of the tax rules and calculate my taxes using a spreadsheet and then update it every year when the rules changed and add bits when my situation changes. Or, I could pay a relatively small subscription, input the basic data (even automate the input of much of the data), answer some simple questions and have a software solution that has all of the up-to-date tax logic built-in, do it all for me….and guarantee the result!
So, if you are tempted to be an ASC 842 ‘spreadsheet martyr’, I urge you to ask yourself a few very simple questions: