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 teamsUS 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 · $79Want every pack, for every region? Global library, 110 packs, $99
What's inside



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
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.
