finance

lease-register

Implements IFRS 16 lease accounting — calculates the opening Right-of-Use asset and lease liability, generates the full amortisation schedule, and posts monthly interest…

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.

Difficulty: beginner
Input: data
Output: spreadsheet
Needs: none
Used by: Finance Manager

What it needs

lease_details — Lessor, asset description, start/end date, annual payment, payment frequency, IBR
period_id
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

What you get

(two JEs per lease)
lease (markdown)
lease-journal-entries (markdown)
termination-je (markdown)
updated-lease (markdown)

Ask it like this

new lease
monthly IFRS 16 entries
modify a lease
terminate early
IFRS 16 methodology