IFRS 16 Lease Schedule Excel Template

Product Description

Simplify your lease accounting with this practical IFRS 16 Lease Schedule Excel Template. Designed to help businesses calculate and track lease liabilities, right-of-use assets, interest expense, depreciation, lease payments, and disclosure balances, this template provides a clear and structured way to manage IFRS 16 lease accounting requirements.

Whether you are preparing monthly management accounts, year-end audit schedules, financial statement disclosures, or internal lease reconciliations, this template gives you an organised and easy-to-use format for tracking lease obligations over the full lease term.

Key Features

Track lease details including lease start date, end date, payment amount, payment frequency, discount rate, and lease term

Automatically calculates opening lease liability, interest expense, lease payments, and closing lease liability

Calculates right-of-use asset depreciation over the lease period

Provides monthly IFRS 16 amortisation schedule

Includes current and non-current lease liability split

Includes lease maturity disclosure analysis

Generates basic journal entry outputs for lease accounting

Clean, professional Excel layout

Easy-to-edit format for different lease agreements

Useful for accountants, finance teams, auditors, and business owners

Short Product Summary

A professional IFRS 16 Lease Schedule Excel Template designed to help businesses calculate, track, and reconcile lease liabilities, right-of-use assets, interest, depreciation, and disclosure balances in one easy-to-use workbook.

Benefits Section

With this template, you can quickly calculate the IFRS 16 impact of lease agreements and maintain a clear monthly record of lease accounting movements. It helps reduce manual calculation errors, supports audit preparation, improves lease reconciliation, and provides a structured view of lease liabilities and right-of-use asset balances over time.

The template is especially useful for businesses that need a practical working file to support monthly reporting, annual financial statements, and IFRS 16 disclosure requirements.

What’s Included

IFRS 16 Lease Schedule Excel file

Lease input register

Monthly lease liability amortisation schedule

Right-of-use asset depreciation schedule

Current and non-current liability calculation

Lease maturity disclosure section

Journal entry summary

Automatic calculation formulas

Professional formatted layout

Editable fields for your own lease agreements

Who This Is For

This template is perfect for accountants, bookkeepers, finance managers, auditors, business owners, and small to medium-sized businesses that need a simple and practical IFRS 16 lease accounting schedule.

It is ideal for anyone who wants to calculate and track lease liabilities, right-of-use assets, interest expense, depreciation, and IFRS 16 disclosure balances in a structured Excel format.