Accountio / Templates / Lease accounting

IFRS 16 lease calculation template in Excel, with FRS 102 checklists

A tested lease calculator for the liability, right-of-use asset, interest and depreciation, a register of every lease, and checklists for the revised FRS 102 Section 20 and the IFRS 16 disclosures.

Finance teams
$19
Files
4, Word and Excel
Last checked
November 2026
Buy the pack · $19
US library · 52 packs

Get this pack and 51 more for $79

Lease accounting · this packBookkeeping and advisory lettersAudit and AUP lettersBook-to-tax reconciliationCompilation and review lettersIndependent contractorsCPA verification letters1040 checklistsIRS notices+ 43 more
$79$69889% off
Buy the US library · $79

Want every pack, for every region? Global library, 110 packs, $99

What's inside

Lease calculator, first page
Lease calculator
Lease register, first page
Lease register
Lease checklists, first page
Lease checklists

First page of each document. 4 files, Word and Excel.

What lease accounting involvesDocument in the pack
Every lease identifiedFRS 102 20.15, IFRS 16
✓
Lease schedule registerIncluding leases inside service contracts
Short-term and low-value exemptions applied correctlyFRS 102 20.5, IFRS 16 para 6
✓
Lease schedule registerFlags leases that do not qualify
Lease liability at present valueFRS 102 20.49, IFRS 16 para 26
✓
Lease calculatorAdvance or arrears, increases and rent-free months
Right-of-use asset and depreciation
✓
Lease calculatorInitial direct costs, incentives and restoration
Interest and the year-end split
✓
Lease calculatorCurrent and non-current liability each year
Maturity analysisIFRS 16 para 58
✓
Lease calculator and registerUndiscounted payments by period
Transition to the revised Section 20FRS 102 1.44 to 1.53
✓
Lease checklistsPeriods beginning on or after 1 January 2026
The lease noteFRS 102 20.74 to 20.82, IFRS 16 paras 51 to 60A
✓
Lease checklistsEvery disclosure as a tick list
Break notice deadlines
✓
Lease schedule registerWarns you before the notice date

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.