To install the Lease Accounts Excel add-in, open Excel and navigate to Insert > Get Add-ins. Search for “Lease Accounts” in Microsoft AppSource, click Add, and follow the prompts. Once installed, it will appear under the Home tab in your ribbon. When clicked, the add-in shows as a task pane on the right side of the Excel window.
Download the Excel template using the button below. This file powers your lease accounting calculations.
Download templateThis tab contains your report settings as well as your list of subsidiaries and asset classes. You must add at least one subsidiary and one asset class for the template to work correctly.
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.
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 £29 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.
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