Soft4LesseeSoft4LesseeSoft4LesseeSoft4Lessee
  • Product Tour
    • First Column
      • Data Import / Export
      • Lease Agreement Data Management
      • Reports for IFRS 16 Presentation and Disclosures
      • Accounting for Lease Liability
      • Accounting for right of use asset
    • Second Column
      • Handling of Non-lease component
      • Managing Lease Modifications
      • Lease status management
      • Assessment of the Lease Term
      • Re-measurement
    • Third Column
      • Variable Leases
      • General Ledger integration
      • Sub-leases and Lease-in lease-out scenario
      • Parallel accounting under IAS 17 standard
      • Managing the multi-company businesses
  • Standards
    • IFRS 16 lease accounting software
    • ASC 842 lease accounting software
    • AASB 16 lease accounting software
  • Why choose us?
    • About us
    • Our team
    • Working with us
    • Meet our customers
    • References
  • Pricing
  • Resources
    • Blog
    • Events
    • Downloads
    • Roadmap
    • FAQ
  • Become partner
  • Contact Us
  • Try Free
    • Get free trial
    • Watch guided demo
    • Watch how to videos
    • Request a live demo

IFRS 16 lease accounting calculator

Get FREE Calculator for IFRS 16 lease accounting

Nowadays there is a lot of information about a new accounting standard for leases – IFRS 16 released by the IASB (International Accounting Standards Board), and ASC 842 by the FASB (Financial Accounting Standards Board). You can find many useful illustrative examples and tutorials, which explain the concept well. Although the practical implementation of the IFRS 16 standard still leaves some questions unanswered, once new the lease standard requirements are clear, your “practical” topics will be:

  • What tools should I use for lease calculations under the IFRS 16 standard? Does my current accounting system have the required features?
  • Which G/L postings need to be produced monthly? (most of examples you may find are very simplified).
  • How much work will this add to my accountants? Can it be handled manually, or does it require automation?

Once you figure out how your lease accounting will be setup under the new rules, your further questions may be:

  • How exactly can the transition to IFRS 16 be accomplished or implemented? OK, in theory, you know what your options are – retrospective vs cumulative catch-up – but then you’ll need a tool to model the impact on your balance sheet, impact on your P&L, and on your key performance indicators – as all these will change.
  • Is your “to-be” process flexible enough to accommodate variations to lease agreements, as the circumstances may change? How complex will it be to account for any changes?

To make the right decisions, at some point in time, you may need to play with your lease figures and model your accounting transactions to see the impact on your balance sheet – as the essence of IFRS 16 is a requirement to disclose the operating lease liability on the balance sheet, together with the Right-of-use asset. In order to do that, you will need a “sand box” tool to perform your calculations. This practical exercise will give you a better insight into the coming changes from two perspectives– changes in accounting and changes in your software.

Here, I’ll share my excel based IFRS 16 calculator with you. Feel free to use it as your “sand box”. Have a go at trying it out and if you have any questions, contact us by email at: info@soft4lessee.com.

This IFRS 16 Calculator was tested against calculation samples published by well-known consultancy companies (Deloitte, PWC, Ernst & Young) then we used it in testing our comprehensive lease accounting software package.
For businesses who have just a handful of operating leases – the excel calculator and manual journal postings may work well. Those who have hundreds of leases, or have complex lease agreements (e.g. variable leases, leases in foreign currency), should consider a transactional system.
Note: The Excel-based calculator is suitable for companies that have about 100 lease agreements. Those that manage more should consider a more sophisticated software solution – Soft4Lessee. Read more about the Soft4Lessee features here. 

Calculator




    • Product Tour
    • Accounting Standards
    • About Us
    • Pricing
    • Contact Us
    • Become partner
    © 2019 Soft4Lessee
    • Product Tour
      • Data Import / Export
      • Sub-leases and Lease-in lease-out scenario
      • Handling of Non-lease component
      • Assessment of the Lease Term
      • Reports for IFRS 16 Presentation and Disclosures
      • Lease Agreement Data Management
      • Accounting for Lease Liability
      • Managing Lease Modifications
      • Lessor management
      • Variable Leases
      • Accounting for right of use asset
      • Lease status management
      • Re-measurement
    • Accounting Standards
      • ASC 842 lease accounting software
      • IFRS 16 lease accounting software
      • AASB 16 lease accounting software
    • Pricing
    • Why choose us?
      • About Us
      • Our Team
      • Working with us
      • Meet Our Customers
      • Become a partner
      • References
    • Resources
      • Blog
      • Downloads
      • Roadmap
      • Events
      • FAQ
    • Contact Us
    • Try Free
      • Get free trial
      • Watch guided demo
      • Request a live demo
    Soft4Lessee
    Use of Cookies

    This website uses cookies which improve browsing quality and user experience. In addition, they allow us to make the website more user-friendly. By clicking “Agree” button, you agree to the use of cookies. You can withdraw your consent at any time. For more information, please visit privacy policy page.

    Strictly necessary cookies
    These cookies are necessary for the operation of the Website and may not be deactivated in our systems. Strictly necessary cookies improve the performance of the Website, its quality and user experience. Strictly necessary cookies activate main functions. You can set your browser to block these cookies and notify about them, however, in such case, certain sites of the Website may be unavailable.
    I accept strictly necessary cookies
    Statistical cookies
    These cookies collect anonymous information and enable to count visits and the source of visitor flows so that we could measure and improve the performance of the Website. The entire information collected by these cookies is generalized; therefore, collected data are used anonymously. If you disable these cookies, we will not know you have visited our site.
    I accept statistical cookies
    Marketing cookies
    These cookies are used to determine which offers or any other information could be of interest to you. These cookies uniquely identify your browser and devise. If you disable these cookies, you will not be able to see our targeted advertisements in other various websites.
    I accept marketing cookies