Why Excel Models Break Down After IFRS 16 Goes Live
When IFRS 16 first came into effect, most companies focused on one thing: Getting implementation done.
Lease inventories were prepared. Discount rates were determined. Right-of-use assets were recognised. Lease liabilities were calculated. Project complete. Or so everyone thought.
But the real challenge didn’t begin on Day 1. It began on Day 2.
Compliance Was Never the End Goal
Imagine a logistics company with a fleet of 600 leased trucks. Six months later:
- 50 trucks returned earlier than planned.
- 100 new vehicles are added under revised commercial terms.
- The lease term for another fleet is extended by three years.
- Rentals are renegotiated because of market conditions.
Or consider a cement manufacturer.
Its quarry equipment lease is modified after production forecasts change. The company expands one plant, closes another, and renegotiates warehouse leases across multiple states.
None of these are unusual business events. They’re simply how businesses operate. The challenge is that every one of these decisions has accounting consequences.
IFRS 16 Didn’t Just Change Lease Accounting
It changed how companies manage leases. Under older accounting models, many lease modifications simply affected future rental expenses. Today, a modification can trigger:
- remeasurement of the lease liability,
- revision of the right-of-use asset,
- reassessment of the lease term,
- and even changes to the discount rate.
What looks like a commercial negotiation in the procurement department can become a significant accounting event for the finance team.
Why “Day 2” Is So Difficult
The initial implementation of IFRS 16 was largely a one-time exercise. Day 2 is continuous. Leases evolve. Businesses grow. Assets are replaced. Facilities are expanded. Contracts are renegotiated. Finance teams must continuously evaluate whether those changes represent:
- a lease modification,
- a separate lease,
- a reassessment event,
- or simply a variable payment adjustment.
The accounting depends on understanding the commercial substance, not just updating a spreadsheet.
Why Excel Eventually Reaches Its Limits
Many organisations initially managed lease accounting through sophisticated Excel models. For a handful of leases, that works. But imagine tracking:
- hundreds of heavy equipment leases,
- multiple vehicle fleets,
- varying lease terms,
- changing discount rates,
- partial terminations,
- foreign currency leases,
- and monthly modifications.
The issue isn’t that Excel calculates incorrectly. The issue is that businesses change faster than spreadsheets are designed to manage. Version control becomes difficult. Audit trails weaken. Manual interventions increase. The risk shifts from accounting complexity to operational complexity.
The Bigger Lesson
One of the biggest misconceptions about IFRS 16 is that it’s merely an accounting standard. It isn’t. It’s also a data governance challenge.
Successful compliance today depends as much on communication as on technical accounting. Procurement teams. Operations. Legal. Treasury. Finance.
All need to know when a lease change occurs, because accounting is often the last function to hear about it, yet the first expected to report it accurately.
Looking Beyond Compliance
Companies that manage Day 2 effectively don’t just have better accounting policies. They have better processes. Lease modifications are identified early. Responsibilities are clearly assigned. Systems capture changes as they happen, not months later during the audit.
In other words, they treat lease accounting as a living process rather than a completed implementation project.
Final Thought
The biggest misconception about IFRS 16 was that implementation marked the finish line. In reality, implementation was only the starting point.
The real test isn’t whether your lease model worked on Day 1. It’s whether it still reflects economic reality after two years of contract renegotiations, fleet expansions, facility closures, and changing business needs.
Because leases don’t remain static. And neither should the accounting that reflects them.