IFRS 16 in Excel: When Spreadsheets Become a Balance Sheet Risk

Almost every company starts lease accounting under IFRS 16 in Excel. For manageable and largely static lease portfolios, this can still be an appropriate solution. It becomes critical not at a fixed number of leases, but when changes, parallel measurement approaches and controls can no longer be reliably traced. This article shows how to recognize that point, which typical errors arise and which three operating models are available thereafter. 

What Excel actually needs to handle under IFRS 16

The “Excel or software” discussion is usually reduced to the present value calculation. That is the easiest part. A complete IFRS 16 process covers the following throughout the lease term:

• Initial measurement of the lease liability and right-of-use asset, including initial direct costs, incentives and restoration obligations
• Subsequent measurement: interest accretion, scheduled depreciation and allocation of payments
• Remeasurements following changes in the assessment of the lease term, exercised options or adjusted residual value guarantees
• Modifications and partial terminations with the correct impact on profit or loss
• Index- and market-related adjustments – including when the discount rate must be adjusted and when it must not
• Foreign currency translation and parallel measurement under HGB, ASC 842 or local accounting standards
• Disclosures, maturity analyses, fixed asset schedules and liability schedules
• Journal entries in the structure required by the downstream system, including adjustment entries for periods already closed
• An audit-ready change history and documented controls

Excel can handle each of these steps individually. The question is not whether it can be done, but what it costs when all of these steps must be performed simultaneously, repeatedly and in an audit-ready manner.

When Excel is genuinely sufficient for IFRS 16

There is a legitimate case for using Excel, and it is narrower than most teams assume. All four conditions must be met:

1. A small number of similar leases:
For example, a manageable number of long-term building or parking-space leases with an identical structure.

2. Infrequent and standardized changes:
Individual index adjustments or lease changes do not necessarily rule out Excel. What matters is that the accounting treatment is clearly defined, historical values are retained and every change, including review and approval, can be traced.

3. One measurement approach, one currency:
 No parallel HGB accounting, no ASC 842, and no group currency alongside the entity’s functional currency.

4. Limited key-person risk:
The calculation logic is fully documented and can be understood and reviewed by at least one other person. What matters is not the number of users, but that the process continues to function during absences, role changes or staff turnover.

In this case, a present value calculation – for example using XNPV in Excel – straight-line depreciation of the right-of-use asset, roll-forward of the liability against payments and periodic recognition of interest expense are sufficient. That is manageable.

The four triggers that cause Excel to break down in lease accounting

1. Modifications and partial terminations
If leased space is reduced, the lease term is extended or a lease is partially terminated, simply overwriting the payment schedule is not enough. When the scope of a lease is reduced, IFRS 16 first requires a proportionate derecognition of the right-of-use asset and lease liability, with the difference recognized in profit or loss – only then is the remaining liability remeasured. Simply recalculating instead produces an incorrect carrying amount and an impact on profit or loss that is never recognized. The example below works through exactly this case.

2. Index and market adjustments
Index-linked lease payments lead to recurring remeasurements. The accounting distinction is critical: where an adjustment results solely from an index or rate, the liability is remeasured using the unchanged discount rate. A new discount rate is used only in certain circumstances, for example when the assessment of the lease term changes or for variable lease payments linked to a floating interest rate. In Excel, this distinction is frequently handled incorrectly because the model simply has no dedicated place for it.

3. Foreign currency and parallel accounting
As soon as a lease is denominated in a foreign currency or the same lease portfolio must be measured under IFRS 16 and HGB, ASC 842 or FRS 102, model complexity multiplies. One file turns into several parallel calculation models that must be kept consistent. This is also where many internationally oriented standard tools, designed primarily around ASC 842, reach their limits – for German groups, HGB alongside IFRS is the norm rather than the exception.

4. Disclosures and audit evidence
Maturity analyses, fixed asset schedules, liability schedules and reconciliations: these reports are recreated in Excel every year, usually under time pressure and with manual intermediate steps. They are among the areas of the financial statements auditors examine most closely – and among those for which Excel provides no automatic derivation from the lease data.

IFRS 16 example calculation: a lease modification worked through in full

The following example is deliberately simple: a single lease, monthly payments and no special cases. Even so, it shows how quickly an Excel solution can lead to an incorrect carrying amount.

Initial situation

Immediately before the modification on 01/01/2029 – after three years – the statement of financial position shows a lease liability of EUR 274,982 and a right-of-use asset of EUR 256,090.

The modification as of 01/01/2029

The leased space is reduced by 40%. The monthly lease payment decreases to EUR 10,000. A current incremental borrowing rate of 4.00% applies to the remeasurement. Two years remain on the lease term.

Step 1: Proportionate derecognition based on the reduction in scope (40%)

The difference of EUR 7,557 is recognized in profit or loss. It arises because the lease liability and the right-of-use asset have different carrying amounts at this point in time.

Step 2: Remeasurement of the remaining liability at 4.00% with monthly payments of EUR 10,000

Because the lease payment does not decrease proportionately with the reduction in space from EUR 12,000 to EUR 7,200, but only to EUR 10,000, the modification includes both a reduction in scope and a change in the consideration for the remaining space.

The EUR 66,237 increase in the liability resulting from the remeasurement is recognized against the right-of-use asset, not in profit or loss.

The typical Excel error under IFRS 16

In Excel, this case is often handled differently: from 01/01/2029 onward, the lease is simply recalculated using the new terms as if it were a new lease. The right-of-use asset is then set equal to the new liability. The result:

• Right-of-use asset of EUR 231,226 instead of EUR 219,891 – overstated by EUR 11,335
• Depreciation of EUR 115,613 instead of EUR 109,946 – overstated by EUR 5,667 per year
• The EUR 7,557 gain from the partial termination is never recognized

For a single lease, an error like this may have little impact. Across fifty leases with comparable modifications, it becomes an audit finding risk – and can take several person-days to reconstruct.

Why the breakdown often becomes visible only during the IFRS 16 audit

A flawed Excel model keeps calculating. It does not report an error, it does not stop, and the financial statements can still be prepared with it. The breakdown typically becomes visible only when the auditor asks for three things that Excel does not systematically provide:

• Traceability over time: Which value applied at which reporting date, who changed it, when, and on what basis? A file with a version number in its filename is not a change history.
• Documented controls: Not merely the statement that a review took place, but documentation of who approved what and when – and evidence that the approval could not subsequently be altered.
• Consistency across entities: Same facts, same treatment and the same discount-rate logic across all entities in the group.

That is the real cost driver. Not the calculation itself, but proving that it is correct.

Seven signs that Excel has caught up with you in lease accounting

If several of these points apply, your team is already working against the tool:

1.    The close is delayed because a specific person is unavailable.
2.    Before every close, the file is “reviewed again” without a clear definition of what is actually being checked.
3.    Lease changes are collected and processed in batches instead of being recorded as they occur.
4.    There are multiple file versions, and no one can immediately say which one is the reviewed version.
5.    Journal entries are manually transferred into an accounting workbook.
6.    During the last audit, questions about how individual values were derived resulted in more than a day of additional work.
7.    Training a new colleague on the model is deliberately postponed.

Decision guide: Excel, consulting services or IFRS 16 software

There is no single right way to implement IFRS 16. Depending on the lease portfolio, internal resources and complexity, Excel may be sufficient, support from a specialized consulting provider may make sense, or professional IFRS 16 lease accounting software may provide the right foundation. The following overview shows which situations each approach is particularly suited to.

Long-term success: operating IFRS 16 with partner support

The models for implementing IFRS 16 are not mutually exclusive. Especially in larger projects, technical expertise and specialized IFRS 16 software are often combined, for example during implementation, data migration, process design or when dealing with complex measurement issues. Companies can also outsource ongoing processing or individual parts of the IFRS 16 process to a specialized service partner.

In such a model, a professional lease accounting solution provides the calculation and data foundation. Depending on the agreed scope, the service partner may take on tasks such as data preparation, processing lease changes, performing periodic calculations and providing journal entry files and reports.

Accounting policies, judgment-based decisions and final approval remain with the company or are handled jointly with a specialist consulting partner.
A partner-supported model is particularly suitable for:

• temporary capacity constraints,
• initial implementations and system transitions,
• clearly defined or largely homogeneous portfolios,
• and companies that need accurate figures and journal entry data but do not want to operate the entire process themselves.

Before making a decision, the scope of services, data responsibilities, processing cycles, approvals, audit support and service levels should be clearly agreed.

What specifically changes with IFRS 16 software such as Envoria

The difference between Excel and IFRS 16 software such as Envoria is not about individual features, but about which work still needs to be done at all:

Conclusion: when the spreadsheet becomes a financial reporting risk

Excel is a legitimate solution for a small number of static leases. What matters, however, is not the number of leases but how often things change, how many measurement approaches run in parallel and how many people need to be able to understand how a value was derived.

IFRS 16 accounting in Excel can be sufficient as long as four conditions are met simultaneously:
1. The lease portfolio is manageable and largely homogeneous.
2. Lease changes occur infrequently and are fully documented.
3. The number of currencies and measurement approaches is limited.
4. Calculation logic, controls and responsibilities are documented so that the process does not depend on a single person.

There is no fixed lease-count threshold. Lease modifications therefore do not automatically mark the end of Excel, but they are a crucial stress test: if changes cannot be versioned, processed correctly from an accounting perspective and reproduced at any time, the spreadsheet becomes a financial reporting and audit risk.

The breaking point is therefore predictable. It announces itself with the first modification that no one has properly documented. And it becomes visible when the auditor asks about it. Those who recognize it early can calmly choose between three paths. Those who do not will have to decide under time pressure.