IFRS 16 Excel Export Checklist: What Finance Teams Should Review

The schedules, journals, assumptions and review checks that should be visible before an IFRS 16 workbook goes into a close file or audit request.

An IFRS 16 Excel export is useful only if someone can review it later.

That sounds obvious, but it is where many lease accounting files become weak. The calculation may be right on the day it is prepared, but the workbook still needs to explain the inputs, show the lease liability roll-forward, reconcile the ROU asset, produce journal entries and leave enough evidence for a reviewer to understand what happened.

A structured IFRS 16 calculator can help by producing the calculation first, then letting the finance team use Excel as the review and archive file. That is different from relying on a workbook where formulas, assumptions and checks are all mixed together.

This article sets out what should be inside an IFRS 16 Excel export before it becomes part of a month-end close file, year-end audit pack or internal review folder.

Why the export matters

The export is often what survives after the calculation is finished.

A finance team may run a calculator online, review the result, save a PDF or workbook, and then come back months later when an auditor asks how the lease liability was calculated. At that point, a single present value number is not enough.

The workbook needs to show the story of the lease. It should make clear what was entered, how the schedule moved from period to period, where interest and depreciation came from, and how the journal entries connect to the numbers.

That is why Excel export should be treated as part of the control process, not just a convenience feature.

Start with the input sheet

The first part of a good export should be the input sheet.

At minimum, it should show:

• lease start date
• lease end date
• payment amount
• payment frequency
• whether payments are in advance or arrears
• annual discount rate
• useful life or depreciation period
• lease incentives, rent-free periods or initial direct costs if used
• CPI, remeasurement or modification assumptions if used

The reviewer should not have to reverse-engineer the schedule to understand the input assumptions. If the workbook only contains output tabs, it becomes harder to prove that the correct contract terms were used.

The input sheet should also separate data-entry fields from calculated fields. That makes the file easier to inspect and reduces the risk that someone overwrites a formula while trying to update a lease.

The lease liability schedule should roll forward cleanly

The liability schedule is the centre of most IFRS 16 export files.

For each period, the schedule should show the opening lease liability, interest expense, lease payment, any adjustment or remeasurement, and the closing lease liability. Those columns should reconcile period by period.

The reviewer should be able to read one row and understand the movement:

• start with the opening liability
• add interest using the periodic discount rate
• deduct the lease payment
• include any modification or remeasurement if relevant
• carry the closing balance into the next row

This matters because many spreadsheet errors are not obvious in the first period. The schedule may look fine at inception, but errors appear when formulas are copied across months, payment timing changes, or a lease modification is inserted part way through the term.

If you want the calculation mechanics in more detail, this guide explains how IFRS 16 lease calculations work.

The ROU asset schedule should not be an afterthought

The right-of-use asset is often easier to overlook than the liability.

A strong export should show the initial ROU asset, any adjustments, accumulated depreciation and closing carrying amount by period. The depreciation schedule should be visible, not hidden inside a formula cell or implied by a journal total.

This is important because the liability and ROU asset do not always move in the same way. The liability unwinds using interest and payments. The ROU asset normally depreciates over the lease term or useful life, depending on the facts.

The export should make that difference clear. It should also help the reviewer see whether the depreciation expense agrees to the journal entries.

Journal entries should tie back to the schedules

The journal tab should not feel separate from the calculation.

For each reporting period, the export should show the expected journal entries for interest expense, lease payments, depreciation and any initial recognition or adjustment entries. The amounts should be traceable back to the liability and ROU asset schedules.

A practical export should help the finance team answer questions such as:

• where did the interest expense come from?
• does depreciation agree to the ROU asset schedule?
• does the lease payment reduce the liability correctly?
• are the commencement entries separate from monthly entries?
• are remeasurement or modification journals clearly labelled?

This is where an export becomes more than a calculation. It becomes a bridge between the lease model and the general ledger.

Assumptions and review notes are part of the evidence

An audit-ready workbook does not need to be complicated, but it should explain the important assumptions.

The export should give the reviewer somewhere to see or add notes for judgments such as the lease term, discount rate, extension options, termination options and any unusual payment terms. It should also record when CPI changes, lease incentives or modifications have been included.

IFRS Connect has a separate guide to IFRS 16 working papers if you want to think about the evidence trail around assumptions, checks and sign-off.

What a clean export should help the reviewer do

The best test is simple: can someone who did not build the calculation review the file?

A clean IFRS 16 Excel export should help a reviewer:

• confirm the lease inputs against the contract
• check the discount rate and payment timing
• follow the lease liability from opening balance to closing balance
• check the ROU asset and depreciation schedule
• trace journal entries back to the schedules
• identify any CPI adjustment, modification or lease incentive
• save the workbook as evidence for month-end or audit review

If the export cannot support those steps, the team may still have to rebuild the working paper manually. That reduces the value of using a calculator in the first place.

When Excel export is not enough by itself

Excel export is helpful, but it does not remove the need for review.

The finance team still needs to decide whether the lease term is correct, whether the discount rate is supportable, whether payments have been interpreted properly and whether unusual lease terms need additional judgment.

The export should make those judgments easier to review. It should not hide them.

IFRS Connect publishes its calculation methodology so teams can see the calculation logic rather than treating the output as a black box.

Practical checklist before sign-off

Before saving an IFRS 16 export into a close or audit file, check the following:

• the input dates agree to the lease contract
• the payment amount and frequency are correct
• payment timing is clearly marked as advance or arrears
• the annual discount rate is visible
• the lease liability schedule reconciles each period
• the ROU asset schedule shows depreciation and carrying amount
• journal entries agree to the liability and asset schedules
• any CPI, incentive, rent-free period or modification is visible
• the workbook contains enough notes for someone else to review later

This is the point of a good export. It should make review easier, not simply move a calculation from one screen to another.

Try the calculator

If you want to generate the core schedules first and then review the workbook output, try the free IFRS 16 calculator.

It calculates the lease liability, ROU asset, depreciation, journal entries and schedules. You can start free with no sign-up. Excel export is available on Pro when you need the workbook for review, archive or audit evidence.

This is general IFRS 16 education, not accounting advice. Review material judgments, assumptions and unusual lease terms with your adviser or auditor.