Why Spreadsheets Fail for Lease Accounting

It is 11pm on a Sunday. The audit starts Monday morning, and you are staring at a spreadsheet with 47 tabs, one for each lease, plus a handful of “v2-FINAL-FINAL” consolidation sheets. You just discovered that the rent increase on lease #23, processed six months ago, broke a cell reference that cascaded into four other leases. The ROU asset totals no longer tie to the general ledger. You have a few hours to figure out which numbers are wrong, which are right, and how to explain the difference to your auditor.

If this sounds familiar, you are not alone. Nearly every finance team starts with spreadsheets for lease accounting, and for good reason: they are flexible, familiar, and free. But lease accounting under IFRS 16 and the amended FRS 102 is not a one-time calculation. It is an ongoing compliance process where modifications, remeasurements, and evidence requirements compound with every reporting period.

Here is where spreadsheets start to break down, and what to do about it.

Modifications: where audit trails break down

This is a familiar scenario: a landlord agrees to extend your office lease by three years and increase the rent by 8%. Under IFRS 16, you need to remeasure the lease liability, recalculating what you owe in today’s money using a revised discount rate, and adjust the right-of-use (ROU) asset accordingly. Straightforward enough in theory.

In a spreadsheet, you have two bad options. You can a) overwrite the original schedule, which destroys the pre-modification data your auditor needs to see, or b) create a new tab that references the old one. After two or three modifications on the same lease, you end up with a chain of interdependent tabs where a single broken cell reference cascades through every subsequent calculation.

This is the single most common audit finding in spreadsheet-based lease accounting. Auditors reviewing modified leases have to trace logic across tabs, verify each formula independently, and confirm that prior periods were not inadvertently altered.

The discount rate documentation gap

Your auditor asks a simple question: “How did you determine 4.5% for this lease?”

Under IFRS 16, the incremental borrowing rate (IBR), the rate you would pay to borrow an equivalent amount for a similar term, must be documented and justified. Under FRS 102, the same applies to the obtainable borrowing rate (OBR). Auditors expect to see the reference rate source, the credit spread adjustment, how you matched the term, and who approved it.

A proper rate memo takes time to prepare. But in a spreadsheet, nothing prompts you to create one, nothing ensures the evidence exists, and nothing flags when that documentation becomes outdated. The gap between “we know why we picked this rate” and “we can prove why we picked this rate” is exactly where audit findings live.

At group level, the problem compounds. Different subsidiaries apply different rates, currencies, and spreadsheet structures, making it difficult to ensure consistency. Consolidation then becomes a manual process of pulling, translating, and aggregating data across entities, with each step introducing additional risk.

No proactive monitoring

Spreadsheets sit there passively. They do not tell you when something needs attention. A lease approaching expiry, an index-linked rent review coming due, stale discount rate documentation, or a modification agreed but not yet reflected in the numbers. These issues only surface during audit preparation, which is the worst possible time to discover them.

Spreadsheet errors are particularly dangerous because they look correct. Excel does not care if your present value formula uses the wrong sign convention or if an amortisation schedule fails to run down to zero. A depreciation calculation with the wrong number of periods will still return a number. It will just be the wrong one.

When multiple people work on a lease portfolio in spreadsheets, even basic questions become hard to answer. Who changed the discount rate on lease #14, and when? Which version of the Q3 schedules went to the auditor? The risk also scales with portfolio size: one lease with a formula error is a correction; twenty with the same copied error is a restatement risk, the kind of issue you want to catch before it reaches audit.

Evidence packs that take days to prepare

Think about what a complete audit evidence pack for lease accounting actually includes:

Lease-by-lease schedules showing the ROU asset, lease liability, depreciation, and interest expense for each period
Journal entries for every transaction
Discount rate documentation with supporting memos
Opening-to-closing balance reconciliations
Disclosure data, including the maturity analysis required by IFRS 16

Producing this from a spreadsheet means copying data across multiple tabs, formatting it so your auditor can actually follow it, cross-checking that every total ties, and verifying nothing was accidentally overwritten since last period. For a portfolio of 20+ leases with modifications, this preparation typically takes several working days every reporting period.

These issues are not edge cases. They are structural. And they are exactly what dedicated lease accounting systems are built to solve.

How the LeaseAccounting.app platform addresses these failure points

Each of these limitations maps directly to a specific platform capability. In practice, LeaseAccounting.app replaces manual work and fragile spreadsheets with a structured, auditable process.

Modifications are handled automatically. Update the lease terms and the system recalculates from the modification date, maintaining the complete history of every change. Both pre-modification and post-modification schedules are preserved in the audit trail. No more tab chains, no more broken references.

The Discount Rate Advisor determines and documents your discount rate using reference rates from the ECB, Bank of England, Riksbank, and Norges Bank. It supports three evidence tiers for FRS 102 OBR and drafts the rate memo for your review, so the documentation exists from day one, not as an afterthought before the audit.

Maintenance agents run daily, scanning for missing rate documentation, overdue reassessments, stale judgements, and approaching lease expirations. Issues surface in your Daily Morning Brief on the dashboard, not as surprises during audit preparation.

Evidence packs are a one-click export of journal entries, amortisation schedules, and calculation details for your auditor: structured, complete, and ready to hand over.

Zen AI explains every calculation in plain language, walks through lease setup, and flags common data entry errors. It is advisory only; it never touches the calculation engine, which remains fully deterministic.

The Vault, soon to be released, lets you share structured evidence directly with your auditor. Auditors register free and access period-based evidence packs with full activity logging. No more emailing spreadsheets back and forth.

Making the switch

If you are currently managing lease accounting in spreadsheets, the transition is more straightforward than you might expect:

Export your lease data: commencement dates, terms, payment schedules, discount rates, modification history. You already have all of this; it just needs to be gathered in one place.
Enter leases into the system using our PDF AI reader. Most teams complete this step in a single sitting.
Run parallel for one period: produce schedules and journal entries from both the spreadsheet and the system, then compare the outputs line by line. This is the step that builds confidence.
Validate the numbers: any discrepancies will point to either a spreadsheet error or a data entry issue. Use the free tier to verify calculations before migrating your full portfolio.
Switch over: use the system as your primary source and archive the spreadsheets. They have served you well, but it is time to move on.

Start validating today

Spreadsheets are not failing because they are wrong. They are failing because the process has outgrown them. Register free and use 2 leases to compare the system’s output against your current spreadsheet.

If the numbers match, you have independent validation of your work. If they differ, you have identified an error worth investigating, before your auditor does. Alternatively, get in touch at hello@leaseaccounting.app and we will be happy to tell you more.