Think you have all the data you need for ASC 842/IFRS 16 compliance? Think again.
Extracting data for ASC 842 transition or IFRS 16 compliance is more than a numbers game. In addition to the dates and payment amounts associated with your leases, there are more complex quantitative data points that will need to be captured from lease documents. Some will need to be calculated based on specific lease terms, such as breakdowns of lump-sum rent payments and CPI increases.
While the main source of data will be the leases themselves, there are also qualitative data points that won’t be found in the lease documents, but instead might come from your real estate team or lease administration partners. You may also need help from outside resources to understand the legal and accounting implications of all lease conditions.
The complexity of capturing and aggregating data for ASC 842 or IFRS 16 compliance is exacerbated when you’re not starting from a single source of truth. Before the new lease standards were announced, many organizations had no central repository for lease information. Now that lease data is moving onto the balance sheet, it’s essential that you collect the right data and ultimately gain more visibility about your leases.
Keep reading to learn what you may be overlooking, as well as the steps to improve the speed and quality of your data collection efforts for ASC 842 or IFRS 16 compliance.
Data you may be missing for ASC 842 transition or IFRS compliance
In most organizations, the accounting teams are driving data collection for ASC 842 or IFRS 16 compliance. The problem is, your accounting managers are focused on the numbers and are not lease experts. So, there are going to be lease terms they won’t understand what to do with, and data they won’t realize they need to capture.
These are just a couple of examples:
Lump sum rent payments: it’s not enough to capture an all-inclusive monthly payment amount. That needs to be broken down to show what portion is intended as base rent, as well as portions for taxes, insurance and CAM expenses. That detail is not likely to be found in the lease.
Intentions: If a lease includes an option to purchase at the end, you need to find out if your business intends to exercise that option. Similarly, you need to know if the business may be planning to end a lease early (if you have an office that’s moving to a new building, for example). These intentions must be identified because they now impact the lease assets and liabilities you’ll need to show on the balance sheet for ASC 842 or IFRS 16 compliance.
3 data collection steps that ensure complete and reliable data
To avoid overlooking important data, which can undermine your compliance timeline and the accuracy of your reporting, follow these data collection steps.
STEP 1: Gather and organize all relevant documents
Simply locating all your lease documents are can be a major challenge for a global organization with hundreds or thousands of leases. You’ll need a strategy for uncovering all records and possibly a mandate from upper management to help you get cooperation from everyone.
For your most complex leases (typically property leases), you’ll need to gather multiple documents, including addendums and commencement letters, in addition to the master lease. Before beginning to extract data, make sure you’ve considered the entire scope of documents associated with every lease and have the most up-to-date and accurate records. You may need help understanding the links between the various documents, so you can tell which include the relevant data.
TIP: If you’re missing amendments or other records, lessors may be able to help (they are gathering the same data for ASC 842/IFRS 16 compliance).
Another source of data may prove challenging for accounting teams when it comes to the ASC 842 transition and IFRS 16 compliance: embedded leases within service contracts. If an agreement includes an implicit or explicit asset that you control the use of, such as equipment or vehicles, that may be considered a lease. You’ll need to collect any contracts that might have embedded leases, and also devise policies to help those extracting data to decide what constitutes a lease for ASC 842 or IFRS 16 compliance.
STEP 2: Collect the right data
The last thing you want to do is spend lots of time and resources pouring through lease documents, then find out you missed critical information and be forced to go through them again. Get it right the first time with these tips.
Understand lease terms well enough to extract the relevant data. For example, there may be different ways to calculate payments that are subject to CPI increases, and a close examination of the lease terms is needed to make sure the amounts are correct.
Be smart about using automated abstraction tools. If humans have trouble understanding lease terms, then AI/machine learning software will also. Automated tools that use optical character recognition (OCR) to recognize words can’t either- they can only extract simple terms. These tools can speed up the process for the easy data, but you’ll need experts to extract and validate complex terms.
Knowing what to extract is just the beginning. You’ll need to make decisions about how to categorize certain terms. With complex leases (again, your real estate leases) there may be terms that are difficult to put into buckets. Turn to resources that can help you understand the legal and accounting implications of all lease conditions. Your technology vendor and accounting advisory partner should be able to help.
Get data from your business. Certain qualitative data, especially about your intentions around lease options and obligations, won’t be in the lease documents. That’s also true of leased asset details such as physical location and assigned department. You’ll need to turn to your lease administrators and those using the assets to collect this information.
Don’t forget about data for ongoing lease management. In the rush for ASC 842/IFRS 16 compliance, you may be tempted to collect only what you need for performing calculations. If you do this, you’re overlooking the benefit you stand to gain from this process beyond merely being compliant. Having all your lease data centrally located and easily accessible provides visibility into your leases that you can use to reduce costs and get better value from your property and other assets.
Gather the data for lease management as a second layer (or have two teams working concurrently) if you’re worried about meeting the ASC 842/IFRS 16 compliance deadline.
STEP 3: Data quality audit
Your data collection effort needs to be both complete and accurate to meet your goals for the ASC 842 transition or IFRS 16 compliance. Errors can happen for many reasons:
- Manual data entry mistakes (“fat finger” errors)
- Misunderstandings about lease terms
- Data that doesn’t import correctly (TIP: be sure your lease accounting system will alert you about data that fails to sync or assign)
- Aggregation issues when the same data from multiple systems doesn’t match
Those errors add up to reporting results that don’t make sense. You don’t want those mistakes showing up as you get close to your adoption date for the new lease standard. That’s why you need quality checks throughout the data collection process.
Spot checks. As you bring data into your repository or lease accounting database, conduct spot audits regularly. For example, have someone look at some of your most complex leases and verify that the data in the system is correct, especially items like renewals and increases.
Validate data against your assumptions. As you reach milestones, roll up your data, run reports and have your leadership review your findings to see if the numbers feel right. If something jumps out as being way out of line, that’s the time to go back and look for incorrect data that could be impacting your calculations.
TIP: Your lease accounting software should provide the ad-hoc and drill-down reporting flexibility to slice and dice data as needed to perform validation checks.
Don’t put off asking for help
Here’s our last bit of advice and it’s important: if you know you’ll need help with any aspect of the ASC 842 transition or IFRS compliance, now is the time to engage the experts. Get your questions answered, get resources for data collection, and choose your lease accounting system as soon as possible. As the deadline nears, it’s likely you’ll wait longer and even pay more for the limited pool of expertise available.
Don’t hesitate to reach out to us at Visual Lease. We’re lease experts and we’re here to help you through your IFRS 16 or ASC 842 transition.
Attending the CoreNet Global Summit 2017 Nov 5 – 7 in Seattle? See Visual Lease in action at Booth #722.