7 Things to Consider Before Choosing A Lease Accounting System

In the race to get compliant, accounting leaders may assume the easiest way to get the calculations they need is to purchase a simple standalone lease accounting tool and feed it with data from other systems or repositories (such as spreadsheets, or a lease management point solution).

That approach rarely proves as fast or easy as you expect. For one thing, your lease data probably resides in numerous systems: real estate may have their own point solution, procurement may have spreadsheets with IT equipment data, and many leased assets are still in a PDF on somebody’s computer! Aggregating all that information is complex and requires some manual intervention to ensure data integrity. Without all of the data residing in one place and serving as your “single source of truth,” you’ll face a time-consuming data validation process to ensure information is consistent and not duplicative. And don’t forget, you’ll need to repeat this process on Day 2 to ensure data is synced and your reporting is valid and accurate.

Selecting a single platform that performs both administrative and accounting functions can allow you to skip secondary data validation and ongoing integration costs. Also, while your immediate goal might be FASB/IASB compliance, don’t make the mistake of overlooking the long term benefits that a single system can provide:

• It can help you manage your policies with respect to options and contingent/variable rent obligations
• It can provide the strategic business intelligence needed to shape short and long term real estate decisions to support business needs while reducing occupancy expenses
• It can directly identify and correct costly payment mistakes.

The financial benefits of these lease management capabilities can easily dwarf the cost of your FASB/IASB compliance efforts, providing an easy ROI.

The simplicity (or complexity) of getting your data into your chosen lease accounting tool is probably the biggest factor impacting how fast your company can become compliant. Before choosing a system, ask these questions to understand the process, resources and time required for this all-important task.

Will you need to pay an external consultant to manage the process, or is the vendor willing and able to help you manage it?

Does the vendor have enough lease expertise to help you manage data collection and abstraction? If consultants are needed, it’s important to understand total costs and project duration.

Is data migration automated, manual or a hybrid?

It’s essential to have bulk-upload capabilities to speed population of both quantitative and qualitative data. However, relying entirely on automated data entry, especially for complex real estate lease information, will result in data integrity problems. The system you choose should easily accommodate both manual and automated data entry, and the process must include quality checks throughout.

Does the vendor provide data migration tools and implementation instructions?

You should expect collecting and validating all your lease data to be challenging, but migrating it into the new system should be straightforward. Migration tools and clear implementation instructions show the vendor’s level of expertise with the process.

What kind of implementation support you can expect from your accounting partners?

Will they act as an advisory arm to help you with data collection and cleansing as well as policy decisions? Many accounting and consulting firms are providing clients with a repository database where you can aggregate data and validate before importing in your lease accounting system.

Every vendor says their product integrates with other systems. However, to be sure you’ll get the results you expect, it’s up to you to investigate the depth and details of the integration. You may want the data from your lease accounting system to feed multiple tools and enterprise systems.

Many organizations (especially multinational organizations and those with multiple subsidiaries) will need the following integration capabilities:

• Ability to create journal entries, including multiple GLs
• Ability to integrate with common ERP and AP systems, such as SAP & Oracle
• Flexible APIs and XML capabilities for unique integrations
• Integration with modern communication platforms, from Outlook to Slack, for alerting users about critical events and actions
• Ability to feed business intelligence systems that provide high-level dashboards for the C-suite
• Ability to bolt onto an IWMS or lease administration system to add seamless lease accounting functionality to a legacy database

At the end of the day, you need your lease accounting system to provide essential reports with reliable data and accurate calculations. Certainly you’re anxious to see standard FASB disclosure reports, financial variance and future expense reports. Systems that can’t provide those basics won’t make your short list. However, it’s in your best interest to look deeper.

To get the most benefit from your lease accounting system, you’ll want the ability to easily “slice and dice” financial data in unlimited ways. We’re talking about customizing reports according to your terminology, reporting schedule and business practices. There are many situations where you’ll want the ability to easily create ad-hoc and drilldown reports, or make adjustments to predefined reports, such as

• Fiscal year or quarterly reports
• Drilling down into expense obligations by region, organization, cost center, asset type and other variables
• Performing currency conversion and analyses
• Evaluating KPIs and metrics for fixed assets

Being forced to lean on the vendor or a consultant every time you need an adjustment or new report will not only slow you down, but also add considerably to the cost of using the system.

At a high level, implementing ASC 842 and IFRS 16 seems simple enough: gather all your lease information and feed it to your balance sheet. However, there are complexities you must understand at the outset so you know exactly what data you need to gather and policy decisions you need to make. For example, in some cases you’ll need to decide exactly what constitutes a lease. You’ll need to extract embedded lease information within service contracts.

If you have not already done so, now is that time for a discussion with your audit advisors to learn exactly what you will need to do to be compliant with the new standards. Fully understanding what’s required will guide you in making smart decisions and plans upfront, and help you avoid time-consuming and expensive surprises later on. With those decisions and plans in place, you’ll better understand what features you need in a lease accounting system.

While your financial leadership may be laser-focused on getting a lease accounting system live and “flipping the switch” to report in the new format, don’t make the mistake of failing to consider Day 2: your ongoing usage of the system. These are some key factors that will impact how well your lease accounting system works for you, Post-implementation.

User Experience. At this stage of the game when you’re primarily concerned with getting data into and out of a lease accounting system, you may not take a close look at how easy (or difficult) it is to work within it. After you go live, this becomes a much bigger issue.

• Leases change regularly and need to be updated. How many screens will you have to wade through to find the field to modify?
• Is information entered once and used throughout, or entered in multiple places, resulting in data integrity problems?
• How easy is it to produce quarterly and annual reports?
• Will you need to hire experts or invest a lot of time and money in training every time you add new users?

Flexibility. There’s no such thing as a cookie-cutter company. It’s virtually certain that you’ll want to make changes to any lease accounting system so that it operates according to the way you do business. At a minimum, you’ll want the system to accommodate your fiscal calendar and reporting schedule. You may work with multiple currencies. You may need to adjust interest rates depending on asset type, useful life or location, or have the ability to override global rules (related to discount rates or capital/operating lease tests, for example). How easy is it to make those changes? If those things are difficult or impossible, imagine what you’ll go through to make major changes to accommodate an acquisition or a reorganization. Easy configurability is not a nice-to-have, it’s a necessity

Audit Support. During an audit, the last thing you want is to be scrambling to answer questions about how numbers were calculated and the details of policy decisions. Your lease accounting system should provide easy access to supporting data behind FASB quantitative and qualitative disclosures via drill-down capabilities.