\n<\/p>\n
Excel is an accountant\u2019s best friend. The ubiquitous software has been around for roughly 40 years and most of us can\u2019t imagine a world without it. It seems like it can do anything.<\/p>\n
Unfortunately, to comply with FASB<\/abbr> Topic 842<\/a>, IFRS<\/abbr> 16<\/a>, FRS<\/abbr> 102<\/a>, as well as GASB<\/abbr> 87<\/a>, Excel simply won\u2019t cut it.<\/p>\n What can go wrong when you rely on Excel?<\/p>\n We\u2019re so sure about Excel\u2019s shortcomings because we\u2019ve seen them firsthand. Here are a few true stories that highlight what can go wrong.<\/p>\n One company stuck with Excel for their leases and ended up overpaying a whopping $648,000 over six years! Luckily for them, they finally ditched the spreadsheets and got on a proper lease accounting software \u2013 in their case, LeaseQuery<\/a>.<\/p>\n Our system flagged a payment as $0 for one of their leases. The accountant thought it was a glitch at first, especially since she wasn\u2019t around when the lease was signed. Smart move, she checked the contract to be sure our system was right.<\/p>\n Turns out the contract showed that rent should have been fully abated<\/a> on every anniversary of the lease. Every 12th month, she should have had free rent. There was nothing in Excel to trigger her to change the lease payment to $0 after 12 months. Crazy expensive mistake, right? Because our software caught it, it more than paid for itself right there.<\/p>\n In this real life example, a bank acquired another bank and completely missed out on a $2 million tenant improvement allowance<\/a>. The reason? They were relying on Excel for their lease accounting<\/a>, and when acquisitions happen, those leases need a proper accounting review.<\/p>\n When clients switch over to our system, they work with lease accounting experts as part of the implementation process. During this process, we discovered that the acquired bank had a $2 million tenant improvement allowance that was transferable in the event of a sale. But the acquiring bank never got that money because it was buried in Excel with no flags. The buying bank never even knew about it!<\/p>\n Stuff like that is super easy to miss in a mess of spreadsheets. Without a proper system triggering a review, that $2 million just vanished. Talk about a costly oversight!<\/p>\n The limitations of relying on Excel for lease accounting resulted in a $79,000 overpayment for one franchise restaurant group owner. While the commencement date<\/a> for several leases was in June, the contractual lease year ran from January to December, with annual payment escalations stipulated. Furthermore, specific instructions within the lease agreements outlined a pro-rated first lease year payment extending from the commencement date to the end of the subsequent calendar year for leases starting after January 1st.<\/p>\n Consequently, payment escalation should have occurred after an 18-month period. However, due to Excel\u2019s inability to automatically capture and process these nuanced terms, the company incorrectly began escalating payments in June, only 12 months post-commencement. This oversight led to six months of overpayment, a discrepancy that would have compounded annually had our technical accounting managers not identified and alerted the client to the issue, after they switched to FinQuery Lease Accounting Software.<\/p>\n The inherent lack of accountability in Excel presents a significant vulnerability, allowing unauthorized modifications that can lead to critical errors. In contrast, our system\u2019s robust audit trail provides a clear record of all actions. For instance, when a disgruntled employee of one of our clients attempted to delete several leases, the system promptly alerted the manager to these changes. The manager was then able to review and reject each deletion, with full visibility into the user responsible and the timestamp of the action, ensuring swift identification and resolution of the attempted manipulation.<\/p>\n As each of the horror stories show, Excel lacks the functionality you need to properly manage your leases<\/a>. There are 18 critical functionalities that a software should have in order to comply with lease accounting standards<\/a>. These functionalities fall into 4 categories:<\/p>\n Navigating changes in lease accounting standards, such as the imminent amendments to FRS 102, presents significant complexities. Excel lacks the inherent capability to accurately interpret these evolving regulations. It cannot perform right of use<\/a> or contingent rent<\/a> calculations, address the election of practical expedients, or correctly identify lease and non-lease components<\/a>.<\/p>\n These tasks go beyond the scope of Excel, making lease accounting software essential for portfolios of more than 10 leases (and good to have even for smaller portfolios<\/a>).<\/p>\n Recognizing the unique challenges across industries, lease accounting software should offer robust flexibility. For example, unlike a rigid 12-month calendar, software should accommodate 13-period calendars common in retail and non-standard fiscal year starts, ensuring accurate expense alignment with specific reporting periods. This adaptability, alongside AI-powered automation for tasks like lease entry and complex calculations, diverse reporting, and a centralized contract repository, makes lease accounting software far more scalable and versatile than Excel.<\/p>\n Excel lacks key controls to preserve the integrity of your data. It can\u2019t lock entries, track changes, adjust access based on roles, or prevent duplicates.<\/p>\n For example, unique identifiers don\u2019t prevent the same lease from being entered twice. A unique identifier won\u2019t prevent the same lease entered differently as \u201ccorporate headquarters\u201d or \u201ccorporate HQ.\u201d So, the software needs to use other means to ensure duplicates are not introduced.<\/p>\n A software that can perform these complex functions to protect the integrity of your data is critical to compliance.<\/p>\n Got leases all over the world? Then you\u2019ll need software that speaks your language and handles all those different currencies for each lease: local, functional, and how you report it. It\u2019s not just about translating the cash; it also tackles tricky re-measurements<\/a> that standards like Topic 842 and IFRS 16 (and don\u2019t forget FRS 102 in the UK and Ireland) make you do. Plus, a good system bends to each country\u2019s specific rules and keeps track of varied fiscal calendars. And if your company\u2019s got branches everywhere, it\u2019d be a lifesaver if it could pull all that lease data<\/a> together for a clear, worldwide picture.<\/p>\n Sure, Excel can do a lot, but who has a month to build a spreadsheet, only to find it\u2019s riddled with errors? We\u2019ve seen it, you probably have too. One wrong number in Excel can snowball into major problems, and good luck figuring out who changed what or when, since it tracks nothing. Ever had that Excel guru leave, taking their magic formulas with them? Or just kept using the same spreadsheet without a second thought? The truth is, everyone messes up in Excel \u2013 it\u2019s not built to catch those human errors.<\/p>\n Excel is easy to use, cheap, and familiar. But overconfidence in its functionalities and your mastery of it can lead to major errors. In all of the scenarios above, the person who created the Excel spreadsheet felt confident in their work. And in the past, that may have been enough. But with the new lease accounting standards, it\u2019s time for a change.<\/p>\n If you recognize the need for change but face resistance, consider this question for upper management: We wouldn\u2019t manage fixed assets<\/a>, a less complex area, with spreadsheets, so why risk the far more intricate world of lease accounting<\/a> with Excel? It\u2019s like using a car for a short trip and a bicycle for a 300-mile journey. Plus, there\u2019s more at stake than just compliance:<\/p>\n FinQuery has extensive experience guiding organizations through the transition from Excel to LeaseQuery<\/a>. We understand the key considerations and potential hurdles involved, and we offer our expertise to assist you. You can also request a personalized demo of LeaseQuery<\/a> to explore your unique needs and requirements with one of our specialists.<\/p>\n Excel is an accountant\u2019s best friend. The ubiquitous software has been around for roughly 40 years and most of us can\u2019t imagine a world without it. It seems like it can do anything. Unfortunately, to comply with FASB Topic 842, IFRS 16, FRS 102, as well as GASB 87, Excel simply won\u2019t cut it. What […]<\/p>\n","protected":false},"author":1,"featured_media":234992,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11759],"tags":[12843,3767,38923,14809,42568,348],"dealstore":[],"offerexpiration":[],"class_list":["post-234991","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-accounting","tag-accounting","tag-blog","tag-excel","tag-lease","tag-noncompliance","tag-set"],"yoast_head":"\nHorror story #1: Overpaying by $648,000 on a lease<\/h2>\n
Horror story #2: Missing $2 million after an acquisition<\/h2>\n
Horror story #3: Escalating payments too soon and overpaying by $79,000<\/h2>\n
Horror story #4: The disgruntled employee<\/h2>\n
Why Excel comes up short: the missing functionalities for lease accounting<\/h2>\n
Advanced compliance tools<\/h3>\n
Accounting and automation tools<\/h3>\n
Data integrity<\/h3>\n
International considerations<\/h3>\n
Other Excel pitfalls<\/h2>\n
Facing the reality that it\u2019s time to change<\/h2>\n
What it boils down to is this: are you willing to bet your job on it?<\/h2>\n
\n
Ready for a new solution?<\/h2>\n
Related articles<\/h2>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":"