IFRS 16 Lease Portfolio
Upload the free EunoiaData lease register and see your IFRS 16 year-end figures for every lease, totalled by asset class. Built on the same calculations as the single-lease calculator.
Method IFRS 16 lessee model: present value of lease payments, aggregated by asset class for the reporting year
Upload your lease register
Download the lease register
A free Excel template with instructions. Enter your settings and one lease per row (up to 100).
Download the template (.xlsx)Upload your completed register
How the lease portfolio works
- Download the free lease register. One row per lease: name, asset class, commencement date, term, payments, discount rate and any initial direct costs, incentives or restoration costs.
- Upload it. Every row is checked with the same rules as the single-lease calculator. If anything needs fixing you get the full list, and nothing is saved until the whole register is correct.
- Review your year-end figures. Lease liability (current and non-current), right-of-use assets, depreciation, interest and cash paid for the reporting year, by asset class and lease by lease.
Each lease is calculated with the IFRS 16 lessee model: the lease liability is the present value of the lease payments, and the right-of-use asset is depreciated straight-line over the lease term. The portfolio figures are those results for the reporting year, added up.
Frequently asked questions
How many leases can I upload?
Up to 100 leases per register. For more, split them across two registers. Larger groups usually use dedicated lease accounting software.
What happens to my Excel file?
We read it and discard it straight away: the file is never saved on our server. Only the figures in it are stored, in the same way as the single-lease calculator, and deleted after the retention period unless you buy the report.
Why was my register rejected?
We check every row before calculating anything, so a partial result can never be produced. You get a list of every problem by row and column, for example "Row 14, Discount rate: must be no more than 50". Fix them in Excel and upload again.
What is the reporting year?
The financial year you are preparing accounts for, set in the register (for example the year ending 31 December 2026). The figures show the movements during that year and the balances at its end.
What about short-term leases?
Leases of 12 months or less are shown as "exempt, excluded" and left out of the totals, because IFRS 16 lets you expense them. Leave low-value leases (such as laptops) out of the register altogether.
Can I use the register again next year?
Yes. Keep it as your lease register: add new leases, update the reporting year-end and upload it again at the next year-end.
Does the template contain macros?
No. It is a plain Excel workbook with dropdown lists. Macro-enabled files are not accepted.
Results are based on the figures and judgements in your register, such as lease terms and discount rates. They are not an audit opinion or accounting advice. For help with your leases, talk to our team.