For individuals:
Open Excel and go to Insert > Get Add-ins. Search for "Lease Accounts" in Microsoft AppSource, click Add, and follow the prompts. Once installed, the add-in will appear under the Home tab in your ribbon. When clicked, it opens as a task pane on the right-hand side.
For organisations:
In many organisations, users are not permitted to install Excel add-ins themselves. If this applies to your setup, please ask your IT team or Microsoft 365 administrator to centrally deploy the add-in across your organisation.
For detailed guidance, see this Microsoft article.
To deploy the add-in, go to Microsoft 365 Admin Center > Settings > Integrated Apps, click Get Apps, then search for Lease Accounts and follow the prompts to deploy it to users.
Central deployment enables seamless access through Single Sign-on (SSO), allowing employees to use the add-in without any manual installation or additional log in.
Download the Excel template using the button below. This file powers your lease accounting calculations.
Download templateThis tab contains your core report settings, including:
You must also enter at least one:
Missing or invalid entries will be highlighted in red.
Complete a Lease Accounting Sheet ("LAS") for each of your leases. These are protected sheets which contain all the data needed to produce accounting entries and reports. Duplicate an existing sheet to create a new lease. Name each sheet in the format "LAS-XXXX", e.g. LAS-0001, LAS-0002, and so on.
Press Calculate in the task pane to instantly generate lease balances, journals, and disclosures — ready for your financial reporting or general ledger import.
The data will be saved to the table on the tab 'Settings & Output Table' (this is located below the settings described in Step 3). The output is structured in double-entry form and serves as the source for the pivot table reports provided in our standard template.
These reports include reconciliations from opening to closing balances of lease liabilities and right-of-use assets, a payment maturity analysis, and a journal entry summary.
Pivot tables are ideal for these reports because they allow you (and your accountants or auditors) to clearly trace the numbers back to individual subsidiaries and contracts. This not only improves transparency but also saves time and reduces the risk of errors.
Try Lease Accounts free for 30 days. Experience the easiest way to manage lease accounting inside Excel.
Per user per year — billed securely via Paddle.
Streamline your lease accounting and reporting — all inside Microsoft Excel, supporting IFRS 16, FRS 102, and ASC 842.
Operate within Microsoft Excel, a familiar and highly accessible tool ensuring ease of adoption and review.
All data remains within your spreadsheet, ensuring that sensitive financial information is never uploaded to the cloud.
Quickly generate necessary reports and journals, saving time and reducing the potential for error.
Easily consolidate leases from multiple subsidiaries.
Access advanced reporting capabilities that offer deep insights and compliance with IFRS 16 and ASC 842 standards.
Customize templates as per the specific needs of your business, enhancing flexibility and control.
Lease Accounts automates lease accounting under IFRS 16, FRS 102, and ASC 842 — inside Excel. Generate calculations, journals, and disclosures with ease.
Currently Lease Accounts supports only Lessee accounting.
No! The system is designed to be accessible for finance teams and business users. With just a few inputs, you can generate compliant accounting outputs — no deep technical knowledge required.
We aim to respond to support queries where possible. However, we do not guarantee response times. Lease Accounts does not provide accounting advice and accepts no liability for loss or damages resulting from use of the tool.
Try Lease Accounts free for 30 days. After that, it’s just £109 per user per year, billed securely via Paddle.
Lease Accounts is billed securely via Paddle, our Merchant of Record. Paddle processes your payment and handles taxes like VAT or sales tax where applicable.
You can choose the number of licenses you wish to purchase initially, and manage your subscription at any time via our customer portal.
Explore our example workbook designed to help you master the Excel add-in quickly. Each workbook guides you through a lessee accounting scenario and shows you exactly how to use the template to comply with IFRS 16, FRS 102 and ASC 842.
FRS 102 users can refer to the IFRS 16 example workbooks.
The lessee extends the term of the lease by re-assessing the probability that it will exercise an extension option. See the initial measurement and the impacts on the lease liability and ROU asset which result from the expected extension.
These workbooks have been prepared for general informational purposes, and do not constitute professional advice on facts and circumstances specific to any person or entity. You should not act upon the information contained therein without obtaining specific professional advice. No representation or warranty (express or implied) is given as to the accuracy or completeness of the information contained in these workbooks.
The information contained was not intended or written to be used, and cannot be used, for purposes of avoiding penalties or sanctions imposed by any government or other regulatory body. Lease Accounts Ltd, its employees, and agents shall not be responsible for any loss sustained by any person or entity that relies on the information contained in these workbooks.
Certain aspects of this information may be superseded as new guidance or interpretations emerge. Financial statement preparers and other users of this publication are therefore cautioned to stay abreast of and carefully evaluate subsequent authoritative and interpretative guidance.
The lease payment profile includes variable payments which depend on an index. See the intitial measurement and the accounting treatment when the payment profile changes according to the index.
IFRS 16 Workbook ASC 842 WorkbookThe lessee agrees with the lessor to reduce the leased office space. See how we introduce the revised payment schedule and treat the existing ROU asset on contract modification.
IFRS 16 Workbook ASC 842 Workbook
Lease Accounts