← All skills & workflows

finance

lease-register

Manage IFRS 16 lease accounting: recognise ROU assets and lease liabilities at commencement, generate amortisation schedules, post monthly interest and depreciation JEs, and handle modifications and early terminations.

Inputs

  • lease_details — Lessor, asset description, start/end date, annual payment, payment frequency, IBR
  • period_id — Period id used to post interest on lease liability and ROU depreciation JEs for all active leases
  • lease — Existing lease note to remeasure.
  • modification_details — New end date, revised payment amount, modification date
  • lease — Lease being terminated early — derecognises ROU and liability.
  • termination_date — Termination date used to derecognise the ROU asset and lease liability before the contractual end date

How you ask

  • New lease
  • Monthly IFRS 16 entries
  • Modify a lease

Outputs

  • (two JEs per lease)
  • lease (markdown)
  • lease-journal-entries (markdown)
  • termination-je (markdown)
  • updated-lease (markdown)
Levelbeginner
Inputdata
Outputspreadsheet
Setup[none]
Roles[Finance Manager]