Accountio / Templates / Lease accounting / Lease schedule register

Lease schedule template in Excel for every lease you hold

Keep one list of every lease the company holds as lessee, with its dates, payments and treatment, and see what is still to pay and which break notices are coming up. This lease schedule template is one Excel register with totals by asset class, commitments for exempt leases and a check on every row.

Finance teams
$19
In the pack
Lease accounting pack
Files
4, Word and Excel
Buy the pack · $19
Middle East and Africa library · 36 packs

Get this pack and 35 more for $79

Lease accounting · this packUAE AML for accountantsUAE Corporate TaxUAE e-invoicingEgypt e-invoiceeTIMS expense validationNigeria data protectionNigeria Tax Act 2025POPIA and PAIA+ 27 more

What the register looks like

Lease schedule register template
What the register coversSheet or column in the register
Reporting date and warning period
✓
SettingsReporting date, today's date and how many days' notice you want before a break deadline
The lease and who it is with
✓
Lease ID, Asset class, Description, LessorProperty, vehicles, plant and equipment, IT equipment or other
Dates and payments
✓
Commencement date, Term (months), End date, Current payment, Frequency, Advance or arrearsMonthly, quarterly or annual payments, with the end date worked out
Treatment of each lease
✓
Purchase option?, Low-value asset?, TreatmentOn balance sheet, short-term exemption or low-value exemption
Where each lease stands
✓
Status at reporting date, Payments leftNot started, active or ended at the reporting date
What is still to pay
✓
Remaining payments, Within 1 year, 1 to 5 years, Over 5 yearsUndiscounted payments split from the reporting date
Balance sheet figures
✓
Lease liability at reporting date, Right-of-use asset at reporting dateCopied in from the lease calculator for each lease on the balance sheet
Break notices
✓
Break date, Notice period (months), Notice deadlineA warning before the deadline and a flag once it has passed
Rows that need attention
✓
CheckMissing details, a short-term or low-value treatment the lease does not qualify for, and a missing discount rate
Totals for the lease note
✓
SummaryActive leases, liability, asset and payment bands by asset class, plus commitments for exempt leases

When you need a lease schedule

A lease schedule is the list of every lease a company holds, with the terms needed to account for it and to manage it. Under IFRS 16 and the revised FRS 102 Section 20, which applies to accounting periods beginning on or after 1 January 2026, most leases go on the balance sheet, so the list has to be complete. Use this one when:

  • Your company is moving to the revised FRS 102 Section 20 and needs to find every lease first
  • Leases are spread across property, fleet and IT, and nobody holds one list
  • The auditor asks how you know no lease has been missed
  • A break clause passed last year because nobody tracked the notice date

How to use the lease schedule template

  1. Fill in Settings. Enter the reporting date and how many days' warning you want before a break notice deadline. Today's date fills itself in.
  2. Add one row per lease. Enter the asset class, lessor, commencement date, term, current payment, frequency and whether it is paid in advance or arrears.
  3. Choose the treatment. On balance sheet, short-term exemption or low-value exemption. The Check column flags a treatment the lease does not qualify for.
  4. Copy in the calculator figures. For each lease on the balance sheet, enter the lease liability and right-of-use asset at the reporting date from the lease calculator.
  5. Add break dates and read the Summary. Enter any break date and notice period, then use the Summary totals and payment bands for the lease note.

Questions

What is a lease schedule?

A list of every lease a company holds, with the asset, lessor, dates, payments and accounting treatment. It is where lease accounting starts, because a lease that is not on the list does not get into the accounts.

What is a short-term lease?

A lease that, at the commencement date, has a lease term of 12 months or less. A lease with a purchase option is not short-term. IFRS 16 and FRS 102 use the same definition.

Can a car be a low-value asset?

No. FRS 102 lists cars, vans, trucks, forklifts, land and buildings and production line equipment among the assets that are not of low value, so the register flags a low-value exemption on any vehicle.

What lease commitments must be disclosed?

Under FRS 102, a lessee that uses the short-term or low-value exemption discloses those commitments separately for three periods: not later than one year, one to five years and later than five years. Under IFRS 16 a lessee gives a maturity analysis of lease liabilities.

When does the new FRS 102 lease accounting start?

For accounting periods beginning on or after 1 January 2026. Early application is allowed if all the 2024 amendments are applied at the same time.

Also in the lease accounting pack

Lease calculatorLease checklists

See the whole pack →

Who it's for

Finance teams of companies that lease property, vehicles or equipment and report under IFRS or FRS 102.

Last checked

Checked against IFRS 16 and FRS 102 Section 20 as revised by the 2024 periodic review in November 2026.