ifrs16-lease-workpaper

IFRS 16 Lease Workpaper

This skill turns a set of lease terms into a complete, audit-ready IFRS 16 lessee workpaper: it measures the initial lease liability and right-of-use (ROU) asset, builds the period-by-period liability amortization and ROU depreciation schedules, posts the initial and recurring journal entries, and handles a basic remeasurement when contractual payments change. It is for accountants, financial reporting teams, auditors, and controllers who need a defensible, reproducible lease calculation rather than a black-box tool.

When to use this

• A new or existing lease needs to be recognised on the balance sheet under IFRS 16 (lessee accounting).
• You need a lease liability and ROU asset amortization schedule for a disclosure note, audit file, or month-end close.
• A lease payment changes (e.g. a rent review, CPI-linked uplift that has crystallised, or a revised payment under the same term) and you need to remeasure the liability and adjust the ROU asset.
• You are preparing or reviewing a workpaper that must tie out to the standard's measurement rules.
• You want the journal entries (initial recognition plus periodic interest, depreciation, and cash payment) spelled out.

This skill is for lessees applying IFRS 16. It does not cover lessor accounting, short-term or low-value lease exemptions beyond flagging them, sale-and-leaseback, or sublease classification.

Inputs

Provide the lease terms as a small table or narrative. The bundled sample samples/lease_terms_sample.csv shows the expected shape. Useful fields:

• Lease/asset identifier and a short description (e.g. "Warehouse unit B").
• Commencement date (the date the underlying asset is available for use).
• Lease term in months (the non-cancellable period plus any periods covered by options reasonably certain to be exercised).
• Payment amount per period and payment frequency (monthly, quarterly, annual).
• Payment timing: in advance (annuity-due) or in arrears (ordinary annuity).
• Incremental borrowing rate (IBR) as an annual rate; or the rate implicit in the lease if readily determinable (IFRS 16.26).
• Initial direct costs, lease incentives received, and any estimated dismantling/restoration cost (for the ROU asset, IFRS 16.24).
• Any payment change: effective date and the new payment amount (for the remeasurement section).

If a field is missing, state the assumption you make (e.g. "payments assumed in arrears") rather than guessing silently.

How to do it

Work in the functional currency and keep full precision in calculations; round only for presentation. Follow these steps.

1. Confirm scope and exemptions (IFRS 16.5-8). If the lease term is 12 months or less with no purchase option, or the underlying asset is low-value when new, flag that the lessee may elect to expense payments straight-line and skip capitalisation. Otherwise proceed.

2. Determine the lease term (IFRS 16.18-19). Use the non-cancellable period plus periods covered by extension options the lessee is reasonably certain to exercise, less periods covered by termination options reasonably certain to be exercised. Document the judgement.

3. Identify the lease payments to include (IFRS 16.27). Include: fixed payments (and in-substance fixed payments) less incentives receivable; variable payments that depend on an index or rate, measured using the index/rate at commencement; amounts expected under residual value guarantees; the exercise price of a purchase option if reasonably certain; and termination penalties if the term reflects early termination. Exclude variable payments based on usage or sales (these are expensed as incurred).

4. Select the discount rate (IFRS 16.26). Use the rate implicit in the lease if readily determinable; otherwise the lessee's incremental borrowing rate. Convert the annual rate to the periodic rate: i = annual_rate / periods_per_year. (Use the simple division convention unless the user specifies effective/compounded conversion; state which you used.)

5. Measure the initial lease liability as the present value of the remaining lease payments. For level payments of PMT over n periods at periodic rate i:

   • Payments in arrears (ordinary annuity): PV = PMT * (1 - (1 + i)^-n) / i.
   • Payments in advance (annuity-due): PV = PMT * (1 - (1 + i)^-n) / i * (1 + i).
   • For uneven payments, discount each cash flow individually: PV = sum( CF_t / (1 + i)^t ).
   • If i = 0, PV = PMT * n.

6. Measure the ROU asset (IFRS 16.23-24) as: initial lease liability, plus lease payments made at or before commencement (less incentives received), plus initial direct costs, plus an estimate of dismantling/restoration costs. Record the components so the total is traceable.

7. Build the liability amortization schedule. For each period:

   • Opening liability.
   • Interest = opening liability (after any advance payment, for annuity-due) x i. For in-advance payments, reduce the liability by the payment at the start of the period before charging interest; for in-arrears, charge interest on the full opening balance then deduct the payment.
   • Payment (cash outflow).
   • Closing liability = opening + interest - payment. The final closing balance must be zero (allow a sub-unit rounding tolerance).

8. Build the ROU depreciation schedule (IFRS 16.31-32). Depreciate straight-line over the shorter of the lease term and the asset's useful life (or over the useful life if ownership transfers or a purchase option is reasonably certain). Period depreciation = ROU cost / number of periods. Track accumulated depreciation and net carrying amount.

9. Write the journal entries.

   • Initial recognition: Dr ROU asset; Cr Lease liability; Dr ROU asset / Cr Cash or Payables for initial direct costs; Cr ROU asset for incentives received.
   • Each period: Dr Interest expense, Cr Lease liability (interest); Dr Lease liability, Cr Cash (payment); Dr Depreciation expense, Cr Accumulated depreciation (ROU).

10. Handle a remeasurement on a payment change (IFRS 16.39-43). When future payments change (e.g. a crystallised index uplift or a revised fixed payment, with no change to scope or term):

    • Remeasure the liability as the PV of the revised remaining payments. Use an unchanged discount rate when only an index/rate-linked payment changes (IFRS 16.43); use a revised discount rate when the lease term or a purchase-option assessment changes (IFRS 16.40).
    • Recognise the difference as an adjustment to the ROU asset (IFRS 16.39). If the adjustment would reduce the ROU asset below zero, recognise the excess in profit or loss.
    • Re-derive the depreciation charge prospectively over the remaining term from the remeasurement date.
    • Show a clear "before / adjustment / after" bridge for both the liability and the ROU asset.

Output

Produce a Markdown workpaper (and, if the user wants a spreadsheet, describe an xlsx with one sheet per section). Include:

• Header: lease identifier, commencement date, term, currency, discount rate (annual and periodic), payment amount/frequency/timing, and the date prepared.
• Initial measurement: the lease liability PV with the formula and inputs shown; the ROU asset build-up table (liability + prepaid payments + initial direct costs + restoration - incentives = ROU cost).
• Liability amortization schedule with columns: Period | Date | Opening liability | Interest | Payment | Closing liability. Add a totals row; interest plus all payments minus opening should reconcile to the principal repaid.
• ROU depreciation schedule with columns: Period | Date | Opening NBV | Depreciation | Accumulated depreciation | Closing NBV.
• Journal entries: initial recognition and a representative period, each as Dr/Cr lines that balance.
• Remeasurement section (if a payment change is provided): revised PV, the ROU adjustment bridge, and the revised depreciation per period.
• Assumptions and judgements note: lease term, discount rate basis, payment timing, rate-conversion convention, and any exemptions considered.

Quality checks

• The final closing lease liability is zero within a small rounding tolerance (e.g. < 1 currency unit).
• Total interest expense over the term equals total payments minus the initial liability.
• ROU accumulated depreciation at end of term equals the ROU cost; closing NBV is zero.
• Every journal entry balances (total debits equal total credits).
• Payment timing (advance vs arrears) is applied consistently in both the PV formula and the schedule; a common error is discounting as in-arrears but charging interest as if in-advance.
• The periodic rate matches the payment frequency (do not mix an annual rate with monthly payments).
• Variable usage-based payments are excluded from the liability (expensed as incurred), not capitalised.
• On remeasurement, confirm the discount rate treatment matches the trigger (unchanged for index-only changes; revised for term/scope changes).
• Restoration provisions: only the IFRS 16 portion sits in the ROU build-up; the matching liability is an IAS 37 provision, not part of the lease liability.

Worked example

Using samples/lease_terms_sample.csv, take the warehouse lease for Aurora Components Ltd: commencement 1 Jan 2026, 36-month term, 12,000 per year payable annually in arrears, IBR 6.0% per annum, initial direct costs 1,500, no incentives or restoration cost.

• Periodic rate i = 6.0% (annual payments, so annual rate).
• Initial liability = 12,000 * (1 - 1.06^-3) / 0.06 = 12,000 * 2.673012 = 32,076.14.
• ROU asset = 32,076.14 + 1,500 = 33,576.14.
• Year 1: interest = 32,076.14 * 6% = 1,924.57; closing liability = 32,076.14 + 1,924.57 - 12,000 = 22,000.71.
• Annual depreciation (straight-line over 3 years) = 33,576.14 / 3 = 11,192.05.
• Initial entry: Dr ROU asset 33,576.14; Cr Lease liability 32,076.14; Cr Cash 1,500 (initial direct costs).

The sample also includes a payment change: from 1 Jan 2027 the annual rent rises to 12,600 (a crystallised index uplift). Remeasure the liability at the unchanged 6% over the two remaining payments, recognise the increase as an addition to the ROU asset, and re-spread depreciation over the remaining 24 months.

Disclaimer

Disclaimer: This skill is a drafting and analysis aid, not professional advice. It does not provide accounting, audit, tax, investment, or legal advice. All output must be reviewed and approved by a qualified professional before use or reliance.

---

Part of LedgerSkills - security-vetted Claude Code skills for finance teams. New skills scanned and tested weekly; subscribe on the site.