Accurate and complete lease data is essential for several reasons.\u00a0 Firstly, it ensures compliance with lease accounting standards such as <\/span>ASC 842<\/span><\/a>, <\/span>IFRS 16<\/span><\/a>, and <\/span>GASB 87<\/span><\/a>. Secondly, lease data significantly impacts financial statements and key metrics, influencing a company\u2019s financial position and performance. Finally, comprehensive lease data enables informed decision-making regarding lease vs. buy options, lease portfolio management, and overall financial planning, leading to better resource allocation and cost optimization.<\/span><\/p>\n Efficiently collecting lease data requires a systematic approach. A centralized repository, like a dedicated lease management and accounting solution, is crucial for storing and managing all lease information in one accessible location. A solution like <\/span>LeaseQuery<\/span><\/a>, provides a way to easily search for lease agreements by lease name\/title, asset type, or expiry date, instead of sifting through countless file folders or spreadsheets. This not only saves time but also ensures that everyone involved in lease management and lease accounting has access to the same up-to-date information.<\/span><\/p>\n Leveraging technology to automate data extraction from lease agreements significantly reduces manual effort and improves accuracy. Instead of manually entering key dates, payment terms, and other critical details, AI-powered tools, like LeaseQuery, can extract this information automatically, minimizing the risk of human error. Standardized templates further enhance accuracy and consistency. For example, a template standardizes which data points users input ensuring that no crucial information is overlooked.\u00a0<\/span><\/p>\n When collecting lease data, you need to capture a wide range of information. This includes key dates such as <\/span>lease start date (possession date)<\/b><\/a> and end dates, the frequency and amounts of payments, and finally your <\/span>borrowing rate<\/b><\/a> as of the lease start date.<\/span><\/p>\n Additionally, you need to gather asset information, including a description of the leased asset, its location and estimated useful life. Determining the lease type \u2013 whether it\u2019s an operating lease or a capital lease \u2013 is crucial for proper accounting treatment. It\u2019s also important to identify and account for any <\/span>embedded leases<\/span><\/a> within service agreements. Finally, capturing other relevant clauses like termination options, purchase options, and restrictions on use can help you fully understand the lease agreement and its implications.<\/span><\/p>\n For your accounting to be complete, you will have to look beyond the usual suspects, like real estate and vehicle leases. <\/span>Service contracts<\/b><\/a> often contain <\/span>embedded leases<\/b><\/a> that can go unnoticed. Because you\u2019re contracting a vendor for a service \u2013 say transportation or data center operation \u2013 you may not realize that you\u2019re leasing equipment or space in the process.<\/span><\/p>\n Here\u2019s one example that can easily fly under the radar: ABC Co. operates a remote manufacturing plant. To meet its electricity demand, ABC Co. may enter into an agreement with the local power company to supply its power from a particular plant.<\/span><\/p>\n In this case, the power company is allocating specific assets to be used exclusively for ABC Co.\u2019s plant. That\u2019s a potential embedded lease.<\/span><\/p>\n Missing embedded leases could lead to <\/span>material misstatements<\/b><\/a>, yet many organizations aren\u2019t being diligent enough about evaluating them.<\/span><\/p>\n Every service agreement should be reviewed to find any embedded leases. A good place to start is by talking to accounts payable and looking at recurring payments. From there, you can look at the service contracts tied to those payments and drill down to see if they contain leases. The legal or procurement teams may have copies of your service contracts to review. If there is no central repository of contracts consider a contract management solution like FinQuery Contract management to make this process, as well as the related prepaid and accrual accounting, easier in the future.<\/span><\/p>\n If all else fails, you can also reach out to your vendors for this information. The initial review will be time-consuming, but it\u2019s worth it to set yourself up for compliance.<\/span><\/p>\n This is self-explanatory. You need to have start and end dates for each lease.<\/span><\/p>\n To determine if you have an embedded lease, you must first identify the asset that you may have exclusive control over, keeping in mind that the identification may be explicit or implicit.<\/span><\/p>\n For embedded leases, you need to use systemic, rational methods to allocate the \u201cconsideration\u201d (or fixed payments) by determining the fair value of the <\/span>lease and non-lease components<\/b><\/a> to which you have exclusive rights. The new standards require that you document how you determine that value.<\/span><\/p>\n You may have contracts that are denominated in a currency that is different from your functional currency. In this scenario, you need to capture the historical conversion rate, which is the rate that was in place as of the start of the contract. This is important because the <\/span>ROU asset<\/b><\/a>, or right-of-use asset, for leases under Topic 842 and IFRS 16 is a non-monetary asset, which requires \u201cremeasurement\u201d as opposed to \u201ctranslation\u201d from transactional currency to local currency.<\/span><\/p>\n For entities reporting under <\/span>ASC 842<\/b><\/a> or <\/span>IFRS 16<\/b><\/a> use our <\/span>Lease Asset Tracker<\/b><\/a> to compile and track your lease inventory. If you report under <\/span>GASB 87<\/b><\/a>, we\u2019ve created a <\/span>GASB-specific Lease Asset Tracker<\/b><\/a> that includes tabs for both <\/span>lessee and lessor<\/b><\/a>.<\/span><\/p>\n Maintaining compliance with lease accounting standards demands a proactive approach to lease data management. This includes establishing a centralized repository for lease information, utilizing technology for automated data extraction, and implementing standardized templates for consistent data collection. However, ongoing compliance involves more than just gathering the right data.<\/span><\/p>\n It\u2019s also crucial to have the ability to make adjustments and corrections as needed, such as for lease modifications or amendments. This requires a clear audit trail to ensure compliance and facilitate smooth audits. Additionally, accurate calculation of the present value of lease liabilities and right-of-use (ROU) assets at specific points in time is essential for ongoing compliance.<\/span><\/p>\n Lease accounting software like LeaseQuery simplifies these processes. By automating data extraction, centralizing lease information, performing complex calculations, and providing real-time updates and alerts, it streamlines lease accounting and ensures compliance with accounting standards.<\/span><\/p>\n<\/div>\n\n","protected":false},"excerpt":{"rendered":" Accurate and complete lease data is essential for several reasons.\u00a0 Firstly, it ensures compliance with lease accounting standards such as ASC 842, IFRS 16, and GASB 87. Secondly, lease data significantly impacts financial statements and key metrics, influencing a company\u2019s financial position and performance. Finally, comprehensive lease data enables informed decision-making regarding lease vs. buy […]<\/p>\n","protected":false},"author":1,"featured_media":110186,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11759],"tags":[3767,3356],"dealstore":[],"offerexpiration":[],"class_list":["post-110185","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-accounting","tag-blog","tag-collect"],"yoast_head":"\nHow to collect lease data<\/b><\/h2>\n
What lease data to collect<\/b><\/h2>\n
Look beyond the obvious<\/b><\/h2>\n
Effectively capturing embedded leases<\/b><\/h2>\n
![\"Embedded](\"https:\/\/finquery.com\/wp-content\/uploads\/2019\/07\/EmbeddedLeaseTest.jpg\")
<\/a><\/p>\nA checklist of what to collect on each lease:<\/b><\/h3>\n
Timeframe<\/b><\/h4>\n
Use of an asset<\/b><\/h4>\n
Documentation of allocation methods<\/b><\/h4>\n
Historical currency rates<\/b><\/h4>\n
Download one of our free lease tracking templates<\/b><\/h3>\n
How to achieve ongoing compliance\u00a0<\/b><\/h2>\n