IFRS 16 Excel Lease Accounting Tool

Complying with the new IFRS 16 lease accounting standard may seem daunting, especially given its complexities. To support businesses in this transition, we present our IFRS 16 Lease Accounting Tool – an Excel-based, macro-driven solution that simplifies the task.

The tool is designed with usability in mind, catering to businesses of all sizes. Its key strength lies in accurately calculating the lease liability and right-of-use asset values, while considering individual lease conditions such as discount rates, lease periods, and payment schedules. Although the tool currently does not support the generation of journal entries and foreign currency calculations, it delivers a robust foundation for the core IFRS 16 calculations.

Our IFRS 16 Lease Accounting Tool also accommodates unlimited modifications in the lease contracts and aids in the preparation of disclosures as required under the IFRS 16 standard.

The tool is user-friendly with clear instructions and guidance integrated within the application. If you’re a small business grappling with the intricacies of IFRS 16, or a larger organization seeking a cost-effective solution for managing your lease portfolio, our tool offers a helpful resource to streamline your lease accounting processes.

Note: Companies that have hundreds of leases, or have complex lease agreements (e.g. leases in foreign currency), should consider a transactional system.

IFRS 16 is a significant global financial reporting standard, introduced by the International Accounting Standards Board (IASB) that replaced IAS 17. It addresses lease accounting and was implemented to bring more transparency and comparability into financial reporting of lease transactions.

The central principle of IFRS 16 is that it requires lessees to recognize almost all leases on the balance sheet, as it eliminates the classification of leases as either operating leases or finance leases. This means that lessees must now recognize a lease liability reflecting future lease payments and a ‘right-of-use’ asset for virtually all lease contracts.

This standard dramatically changes the way lessees record leases in their financial statements, making the company’s financial leverage more apparent. In the income statement, it replaces the straight-line operating lease expense with a depreciation charge for the right-of-use asset and an interest expense on the lease liability, potentially impacting key financial metrics such as EBITDA and operating profit.