If you are a finance manager, financial controller, or CFO at a UK company, IFRS 16 compliance is likely one of the most time-consuming parts of your year-end close. Since the standard became mandatory in January 2019, UK finance teams have been managing lease liabilities, right-of-use assets, remeasurements, and disclosure requirements — often in spreadsheets that are one formula error away from a material misstatement.
Choosing the right IFRS 16 lease accounting software changes that picture entirely. Instead of rebuilding amortisation schedules every time a lease is modified, and manually pulling disclosure notes together at year-end, a dedicated system handles the calculations automatically and maintains a full audit trail throughout the year.
This guide covers what IFRS 16 demands from UK finance teams in practice, why spreadsheet-based compliance breaks down as lease portfolios grow, and what to look for when evaluating IFRS 16 lease accounting software. If you are currently managing leases in Excel — or your current system is not keeping up — this is worth reading before your next year-end close.
What Is IFRS 16 and Who Does It Apply to in the UK?
IFRS 16 is the international accounting standard issued by the IASB that replaced IAS 17 in January 2019. It fundamentally changed how lessees report leases, moving almost all leases onto the balance sheet under a single accounting model.
Under IAS 17, most operating leases remained off-balance-sheet — effectively invisible to investors and lenders reviewing a company’s financial position. Under IFRS 16, lessees must instead recognise a right-of-use (ROU) asset and a corresponding lease liability for virtually every lease with a term of more than 12 months. The scale of this shift has been significant: an EY survey of 58 companies from the Fortune Global 500 found that IFRS 16 adoption increased total reported assets by an average of 14%, with liabilities rising by more than 20% across the airline, retail, and transport sectors.
For businesses with US reporting obligations, see how IFRS 16 compares to ASC 842.
In the UK, IFRS 16 applies to:
- Companies listed on the London Stock Exchange or other regulated markets
- Large private companies and groups that report under IFRS
- Subsidiaries of international groups using IFRS
Smaller UK companies reporting under FRS 102 have, until recently, operated under a different framework. However, that is changing. The Financial Reporting Council’s 2024 amendments to FRS 102 introduce a lease accounting model closely aligned with IFRS 16, effective for periods beginning on or after 1 January 2026. As a result, a significantly wider range of UK businesses will soon be managing on-balance-sheet lease accounting for the first time. For those finance teams, the question of whether to use dedicated IFRS 16 lease accounting software is becoming increasingly urgent.
What Does IFRS 16 Require in Practice?
IFRS 16 is not a one-time exercise. It requires ongoing calculation and judgement throughout the life of every lease in your portfolio. Here is what UK finance teams need to manage on an ongoing basis.
Initial Recognition
At lease commencement, you calculate the present value of future lease payments, discounted at either the rate implicit in the lease or your incremental borrowing rate. The ROU asset is initially measured at the amount of the lease liability, plus any initial direct costs, prepayments, and lease incentives received.
This calculation is straightforward for a single lease. However, when you have ten, twenty, or fifty leases — each with different commencement dates, payment structures, and discount rates — managing initial recognition manually becomes genuinely difficult and increasingly prone to error.
Ongoing Measurement
Throughout each lease term, your finance team must carry out three ongoing tasks:
- Depreciate the ROU asset over the shorter of the lease term or the asset’s useful life
- Unwind the lease liability each period using the effective interest method, recognising interest expense
- Remeasure the liability whenever lease terms change — renewals, extensions, modifications, rent reviews, or early terminations
Remeasurement is where spreadsheet-based IFRS 16 compliance most commonly breaks down. Each modification requires a reassessment of the lease term, a potential update to the discount rate, and a recalculation of present value from the remeasurement date. In a spreadsheet with multiple linked tabs, this process is error-prone even for experienced teams.
Required Disclosures
IFRS 16 demands detailed note disclosures in your financial statements. Specifically, you must include:
- A maturity analysis of lease liabilities, showing undiscounted payments by time band
- Total cash outflows for leases during the period
- ROU asset movements by class of underlying asset
- Interest expense on lease liabilities
- Short-term and low-value lease expenses
- Weighted average discount rates applied to the portfolio
Pulling these disclosures together from a spreadsheet at year-end typically takes hours. Furthermore, one formula error in the underlying calculation cascades through every disclosure table — which is precisely why auditors look closely at the workpapers behind lease accounting notes.
IFRS 16 Lease Accounting: A Worked Example
To illustrate how the standard works in practice, consider a straightforward UK office lease with the following terms:
- Annual lease payment: £12,000 per year (paid in arrears)
- Lease term: 5 years
- Incremental borrowing rate: 5% per annum
- No initial direct costs or lease incentives
The table below shows the key IFRS 16 calculations at commencement and end of Year 1:
Step | Calculation | Result |
1 | Annual lease payment | £12,000 / year |
2 | Lease term | 5 years |
3 | Incremental borrowing rate | 5% per annum |
4 | Present value of lease payments (PV annuity formula) | £51,963 |
5 | Initial lease liability recognised on balance sheet | £51,963 |
6 | Initial ROU asset (= lease liability + initial direct costs) | £51,963 |
7 | Annual ROU depreciation (straight-line over 5 years) | £10,393 / year |
8 | Interest expense — Year 1 (£51,963 × 5%) | £2,598 |
9 | Lease liability at end of Year 1 (£51,963 + £2,598 − £12,000) | £42,561 |
As a result, the opening balance sheet entry recognises both a £51,963 ROU asset and a £51,963 lease liability. By end of Year 1, the lease liability has reduced to £42,561 after adding interest and deducting the payment, while the ROU asset has reduced to £41,570 (£51,963 minus £10,393 depreciation).
Multiply this calculation across a portfolio of 20, 50, or 200 leases — each at different stages, with different rates and terms — and the case for dedicated IFRS 16 lease accounting software becomes clear. Each remeasurement, modification, or rent review requires the full recalculation to be rerun from the modification date. In a spreadsheet, that is a significant manual effort every time.
Why Spreadsheets Fail for IFRS 16 Compliance
Most UK finance teams started managing IFRS 16 in Excel when the standard first came into effect. It was the path of least resistance — familiar, flexible, and low cost. However, as lease portfolios grow and auditors scrutinise lease accounting workpapers more closely, the limitations have become hard to ignore.
Version Control and Audit Exposure
When more than one person works on a lease accounting spreadsheet, version conflicts are almost inevitable. There is no change history, no access controls, and no record of who changed what and when. Auditors increasingly ask finance teams to trace every lease calculation back to source data. A spreadsheet with unlocked cells, manual overrides, and no audit trail is a difficult position to defend during fieldwork — and a common source of audit findings.
Remeasurement Is Disproportionately Time-Consuming
Under IFRS 16, a lease modification — a change in scope, term, or payment that was not part of the original contract — typically triggers a full remeasurement. Rent reviews, lease extensions, early terminations, and renegotiated payment schedules all require the finance team to recalculate present values and update amortisation schedules from the modification date. In a spreadsheet, every remeasurement is effectively a manual rebuild. In dedicated IFRS 16 lease accounting software, it is a guided workflow that takes a few minutes.
Disclosure Preparation Takes Too Long
Assembling the IFRS 16 note disclosures from a spreadsheet — ROU asset movements, maturity analysis, interest expense, weighted average discount rates — requires significant manual effort at year-end. As noted above, one formula error in the calculation sheet cascades through every disclosure table. Consequently, many finance teams spend more time reconciling outputs than reviewing them for accuracy.
Scalability Breaks Down Quickly
A spreadsheet that works for five leases becomes unmanageable at fifty. For UK companies with large property portfolios, vehicle fleets, or equipment programmes, the volume of data simply exceeds what spreadsheet-based compliance can handle reliably. In fact, as far back as 2019, finance teams at retailers managing portfolios of more than 50 locations concluded that software would be required — spreadsheets were simply not viable at that scale.
Transition Risk for FRS 102 Companies
With the amended FRS 102 effective from January 2026, UK companies currently reporting under UK GAAP will need to bring operating leases onto the balance sheet for the first time. For many mid-sized UK businesses, this represents their first encounter with IFRS 16-style lease accounting. Consequently, starting that transition in a spreadsheet adds unnecessary risk that dedicated software eliminates from the outset. US entities face the same spreadsheet limitations under ASC 842.
Excel vs IFRS 16 Lease Accounting Software: A Direct Comparison
The following table summarises the key differences between managing IFRS 16 compliance in Excel and using a dedicated platform such as AssetAccountant:
Feature | Excel | AssetAccountant |
Automatic IFRS 16 calculations | ✗ | ✓ |
Full audit trail | ✗ | ✓ |
Remeasurement workflow | ✗ | ✓ |
Automated disclosure outputs | ✗ | ✓ |
Multi-user access with permissions | ✗ | ✓ |
Integration with Xero / QuickBooks / Sage | ✗ | ✓ |
Scalable to 50+ leases | ✗ | ✓ |
Cloud-based, no version conflicts | ✗ | ✓ |
The differences above are not simply about convenience. In the context of IFRS 16 — a standard where remeasurement is frequent, disclosures are detailed, and auditors review the underlying calculations — each limitation of a spreadsheet represents a concrete compliance and audit risk.
What to Look for in IFRS 16 Lease Accounting Software
Not all lease accounting software is built to the same standard. Therefore, here are the capabilities that matter most for UK finance teams evaluating their options.
Accurate IFRS 16 Calculations as Standard
The core calculation engine should handle present value calculations, ROU asset depreciation, lease liability unwinding, and remeasurement automatically — with a full audit trail on every figure. Additionally, you should be able to trace any number in a disclosure back to the underlying lease inputs without manual reconstruction.
Support for All Lease Types
Property leases, vehicle leases, equipment leases, and IT contracts each have different structures and terms. As a result, the software should handle all of them without workarounds. In particular, look for consistent, documented handling of both commencement-date calculations and all subsequent modifications.
Built-In Remeasurement Workflow
Lease modifications are common in practice. Therefore, the software should make remeasurement a guided process: you enter the change, the system applies the correct IFRS 16 accounting treatment, and the updated schedule flows through automatically. This is one of the highest-value features in any lease accounting platform — and one of the most commonly under-engineered.
Automated Disclosure Outputs
Generating IFRS 16 note disclosures should take minutes rather than hours. Specifically, look for software that produces a maturity analysis of lease liabilities, ROU asset movement tables, interest expense schedules, and low-value and short-term lease summaries directly from the system — in a format your auditors can review without needing to reconstruct the underlying calculations.
Integration with Your Accounting System
Journal entries need to flow into your general ledger without manual re-entry. Consequently, integrations with Xero, QuickBooks Online, Sage Intacct, and Microsoft Dynamics 365 are the most relevant for UK businesses. Direct posting eliminates the reconciliation step between your lease system and your trial balance. [Link: Xero integration page]
Cloud-Based with Appropriate Access Controls
A cloud-based system gives multiple team members real-time access to the same data, with role-based permissions and a complete audit history. Moreover, this directly addresses the version control and access issues that make spreadsheet-based compliance difficult to defend during audit.
Is IFRS 16 Lease Accounting Software Worth the Investment?
This is a reasonable question, and the answer depends on the size of your lease portfolio and the current cost of managing it manually.
Consider a finance team managing 30 leases: a mix of office properties, company vehicles, and IT equipment. At year-end, pulling together the IFRS 16 disclosures, reconciling the trial balance, and responding to audit queries on lease calculations might take two or three days of senior finance time. Add the time spent on remeasurements during the year — say, four or five modifications across the portfolio — and the annual cost in staff time adds up quickly. Read more: Maximizing ROI with Lease Accounting Software: Strategies for Businesses.
Dedicated IFRS 16 lease accounting software reduces that overhead significantly. Disclosure outputs are generated in minutes rather than hours. Remeasurements run in a guided workflow rather than a manual rebuild. Audit queries are answered by pointing to system reports rather than defending spreadsheet logic.
For most UK finance teams managing more than ten leases, the time savings alone justify the cost of a dedicated system — particularly in the current environment where finance team capacity is under pressure and audit quality standards are rising. AssetAccountant offers a 30-day free trial, so you can evaluate the time savings against your own lease portfolio before committing.
How AssetAccountant Supports IFRS 16 Compliance for UK Finance Teams
AssetAccountant is a cloud-based platform built specifically for fixed asset management, lease accounting, and loan amortisation. It supports IFRS 16 out of the box — alongside US GAAP, IFRS, and ASC 842 — making it particularly well suited to UK businesses with international reporting requirements, dual-jurisdiction subsidiaries, or cross-border investor obligations.
For UK finance teams, specifically, that means:
- Lease schedules are calculated automatically from commencement, using the discount rate you specify — no manual PV calculations required
- ROU asset depreciation and lease liability unwinding run in the background — you review the output rather than constructing it period by period
- Remeasurement is built into the workflow, so modifications are processed consistently and documented automatically with a full audit trail
- IFRS 16 disclosure reports are generated directly from the system, ready for your auditors to review without additional workpaper preparation
- Direct integrations with Xero, QuickBooks Online, Sage Intacct, and Microsoft Dynamics 365 mean journal entries post to your general ledger automatically
The result is a single system of record for your entire lease portfolio — property, vehicles, equipment, IT — that replaces a collection of spreadsheets with a documented, auditable process.
Furthermore, for companies approaching the FRS 102 amendments effective from January 2026, AssetAccountant’s support for IFRS 16-style lease accounting means the technical infrastructure is already in place ahead of the transition deadline — rather than being built under pressure.
Getting Started: Moving from Spreadsheets to IFRS 16 Software
The migration from spreadsheet-based compliance to dedicated IFRS 16 lease accounting software is more straightforward than most finance teams expect. Here is a typical process:
- Compile your lease register — all active leases with commencement dates, payment schedules, lease terms, and any modifications to date
- Gather discount rates for each lease — either the rate implicit in the lease or your incremental borrowing rate at commencement and each subsequent remeasurement
- Import your lease data into the software — most platforms, including AssetAccountant, accept CSV upload or manual entry for smaller portfolios
- Review the opening balances — the system calculates ROU assets and lease liabilities; compare these against your current balance sheet figures
- Reconcile any differences — these commonly arise from different discount rate assumptions or different treatment of lease modifications
- Connect to your accounting system — set up the integration so journal entries post automatically to your general ledger
- Run your first disclosure report — review it against your previous year-end notes before relying on it for reporting
In practice, most finance teams complete the initial setup in one to two working days. After that, ongoing maintenance means entering new leases as they commence and processing modifications as they arise — both of which take a few minutes in a well-designed system.
Additionally, if you are approaching the FRS 102 transition in January 2026, starting this process now gives you time to validate opening balances and test disclosure outputs well before the deadline.
Try AssetAccountant Free for 30 Days
If your IFRS 16 compliance is currently running on spreadsheets — or if your existing system is not keeping up with your lease portfolio — it is worth seeing what purpose-built IFRS 16 lease accounting software can do before your next year-end.
AssetAccountant offers a 30-day free trial with no credit card required. You can import your existing lease data, run the full IFRS 16 calculations, generate disclosure outputs, and connect to your accounting system before committing to anything. For UK finance teams managing the standard’s ongoing requirements, the practical difference between a spreadsheet and a dedicated system becomes clear within the first few hours of use.
Summary
IFRS 16 has been mandatory for UK IFRS reporters since January 2019, and the standard’s demands have not diminished over time. Remeasurement, modification accounting, disclosure preparation, and audit readiness are ongoing requirements — not one-time tasks. For finance teams still managing these processes in spreadsheets, moreover, the risks grow as lease portfolios grow.
Purpose-built IFRS 16 lease accounting software addresses these challenges directly: it automates calculations, maintains full audit trails, and generates compliant disclosures in minutes rather than hours. Furthermore, with FRS 102 amendments bringing IFRS 16-style lease accounting to a significantly wider range of UK companies from January 2026, the window to implement a proper system ahead of the next major compliance transition is already narrowing.
If you are evaluating your options, a 30-day free trial is a practical, low-risk way to assess whether dedicated IFRS 16 lease accounting software is the right move for your business.
