No. Every calculation is a formula you can trace. There is no VBA in the file.

Which Excel versions does it work in?

It is built without macros or dynamic-array functions and tested in Excel 365 for Windows. The Excel 2019, Mac and Google Sheets checks are listed on the How we test page as they are completed.

Can I use Google Sheets?

Every tier, Lite included, is an Excel file today. A Google Sheets copy of Lite is planned; until the Google Sheets check is listed as done on the How we test page, use Excel.

Is my data uploaded anywhere?

No. The workbook runs on your computer. We never see your leases.

Can it handle more than one modification on a lease?

Version 1.0 handles one remeasuring modification per lease, and check C11 tells you if a second one is entered.

Why not ask an AI assistant to build the schedule?

You can, and you then need to check what it built. This workbook is the checked version: the same formulas in every file, every check visible, and each release tested against an independent recompute before it ships.

What does the licence allow?

Lite and Pro: one named user, for their own organisation. Team: up to 10 named users in one organisation, for its own work. Practice: up to 5 named users in one accounting or audit firm, for any number of clients. You may give completed files to your auditors and reviewers. Outputs you create are yours.

When we release an update, it is free within the same major version for as long as we sell it. You get an email and download it from your library.

What if it does not work for me?

Ask within 14 days of purchase for a full refund, for any reason.

IFRS 16 Lease Schedule Builder

Build an IFRS 16 schedule with the checks a reviewer looks for.

Enter your leases once. The workbook builds the liability and right-of-use schedules, the journals and the disclosures, and shows every check as PASS or FAIL.

Up to 250 leases, month by month for up to 30 years, in one Excel file with no macros.
Modifications: term or payment change, index change, and scope decrease with the gain or loss. Separate scope increases are logged against their new lease row.
Journals and disclosures that tie: maturity analysis, ROU movement by class, liability reconciliation.

See pricing Sample output (PDF)

Who it is for

Financial controllers and group accountants with 5 to 250 leases.
Small audit and accounting firms preparing or reviewing IFRS 16 schedules for clients, under the Practice licence.
Reporters under AASB 16 (Australia) or Ind AS 116 (India), which are based on IFRS 16. Check any local differences yourself.
Teams moving off a fragile in-house spreadsheet before year end.

Who it is not for

Lessor accounting.
Entities reporting under IFRS for SMEs: its lease section is a different model.
Groups that need multi-currency lease consolidation in one file.
Anyone looking for advice on lease term or discount rate judgements: those stay yours.

Tab by tab

Settings: Reporting date, currency, day count (monthly 30/360 or actual/365), journal frequency, tolerance.
Lease Register: One row per lease: dates, payments, frequency, timing, escalation, IBR, costs, incentives, options. Validated inputs.
Modifications: One remeasuring modification per lease, with the effective date and revised terms or rate.
Engine: Protected month-by-month schedules: cash, discount factors, liability, interest, ROU and depreciation.
Results: Per lease: initial liability and ROU, balances at the reporting date, current and non-current split, the year's movements.
Journals: Commencement, interest, payments, depreciation, remeasurement and scope decrease entries by month or quarter.
Disclosures: Undiscounted maturity analysis, ROU movement by class, liability reconciliation, short-term and low-value expense.
Checks: Every check visible, PASS or FAIL, with one cell that tells you whether everything passes.

The checks

Every check is visible on the Checks tab and shows PASS or FAIL.

C01The liability rollforward ties to the closing liability, per lease and in total.
C02The right-of-use asset is never negative.
C03Undiscounted remaining payments equal the maturity analysis total.
C04Current plus non-current equals the total liability.
C05Modifications are complete and valid: dates inside the term, revised payment and rate entered where needed.
C06Every IBR is between 0% and 30%.
C07Register rows are complete and valid, and each term fits its payment frequency.
C08Journals balance, debits equal credits, in every period.
C09The disclosure reconciliations and the total cash outflow cross-foot.
C10The lease count is within your tier.
C11Each lease has at most one remeasuring modification.
C12Undiscounted cash recomputed in closed form equals the schedule, per lease.
C13A forward rollforward from commencement equals the liability at the reporting date, per lease.
C14The number of payments in the schedule equals the number expected from the lease terms.
C15Every register row is picked up by the engine and the Results tab.
C16Settings hold allowed values.
C17Warning only: a negative current portion is flagged for review.

How we test each release

How it compares

Typical setups, not a review of any one product.

	Free template	Lease accounting software	This workbook
Modifications and remeasurement	Varies by template	Usually	Yes, one per lease
Checks you can show a reviewer	Varies by template	Varies, often inside the system	Every check visible, PASS or FAIL
Disclosures that cross-foot	Varies by template	Usually	Yes
Where your data lives	Your machine	Usually cloud hosted	Your machine
Price	Free	From about USD 350 to 4,000 a year	From USD 39, once

Sample output

Download the sample output (PDF): the Checks summary and key outputs from the sample leases.

Pricing

Lite

USD 39

USD 29.25 with code FOUNDING25 until 1 December 2026.

Excel, up to 25 leases, no modifications, one named user

Choose this if you have up to 25 leases without modifications.

I want immediate access to the download. Where the law gives me a right to withdraw, I understand I lose it once the download is available. Hayatiq's voluntary 14-day refund still applies.

Pro

USD 79

Founding price until 31 January 2027, then USD 99.

USD 59.25 with code FOUNDING25 until 1 December 2026.

Excel, up to 250 leases, one named user

Choose this if you work in Excel and need modifications, journals and disclosures, for one named user.

I want immediate access to the download. Where the law gives me a right to withdraw, I understand I lose it once the download is available. Hayatiq's voluntary 14-day refund still applies.

Team

USD 159

Founding price until 31 January 2027, then USD 199.

USD 119.25 with code FOUNDING25 until 1 December 2026.

Pro for up to 10 named users in one organisation

Choose this if up to 10 colleagues in one organisation need the same file.

I want immediate access to the download. Where the law gives me a right to withdraw, I understand I lose it once the download is available. Hayatiq's voluntary 14-day refund still applies.

Practice

USD 299

USD 224.25 with code FOUNDING25 until 1 December 2026.

Pro for up to 5 named users in one accounting or audit firm, any number of clients

Choose this if your firm prepares or reviews lease schedules for clients.

I want immediate access to the download. Where the law gives me a right to withdraw, I understand I lose it once the download is available. Hayatiq's voluntary 14-day refund still applies.

One-time price. Updates within the same major version are free for as long as we sell it.

You can ask for a full refund for any reason within 14 days of purchase. This is our own promise. The statutory withdrawal right you give up at checkout is a separate legal right.

Prices are in USD. Depending on your country, sales tax is either included in the price or added at checkout, and Paddle shows the total before you pay. Your checkout may show a local price.

After a purchase we may email you tips for your tool and about similar Hayatiq tools; every email has an unsubscribe link.

This is a tool, not tax, accounting or financial advice.

Questions

Does it need macros?: No. Every calculation is a formula you can trace. There is no VBA in the file.
Which Excel versions does it work in?: It is built without macros or dynamic-array functions and tested in Excel 365 for Windows. The Excel 2019, Mac and Google Sheets checks are listed on the How we test page as they are completed.
Can I use Google Sheets?: Every tier, Lite included, is an Excel file today. A Google Sheets copy of Lite is planned; until the Google Sheets check is listed as done on the How we test page, use Excel.
Is my data uploaded anywhere?: No. The workbook runs on your computer. We never see your leases.
Can it handle more than one modification on a lease?: Version 1.0 handles one remeasuring modification per lease, and check C11 tells you if a second one is entered.
Why not ask an AI assistant to build the schedule?: You can, and you then need to check what it built. This workbook is the checked version: the same formulas in every file, every check visible, and each release tested against an independent recompute before it ships.
What does the licence allow?: Lite and Pro: one named user, for their own organisation. Team: up to 10 named users in one organisation, for its own work. Practice: up to 5 named users in one accounting or audit firm, for any number of clients. You may give completed files to your auditors and reviewers. Outputs you create are yours.
How do updates work?: When we release an update, it is free within the same major version for as long as we sell it. You get an email and download it from your library.
What if it does not work for me?: Ask within 14 days of purchase for a full refund, for any reason.

Who built it

Omer Hayat Khan, FCCA. 8 years in Big Four audit. Every workbook is generated from source code written for Hayatiq and checked by an independent test suite before release.

How we test | About

Changelog

v1.0.0 (2026-10): First release.

Full changelog