Lease Accounting Software for Microsoft Excel

Automate complex IFRS 16, FRS 102 and ASC 842 lease accounting calculations, journals and reports.

Lease Accounts combines structured Excel workbooks with an Excel add-in, helping you manage remeasurements, modifications, impairments and reporting outputs in a familiar Excel environment.

Follow the 5-step setup guide to install the add-in, download a workbook and start your 30-day trial.

Paid licences include 5 hours of expert support from accountants with real-world lease accounting implementation experience.

How to Get Started with Lease Accounts

Lease Accounts combines an Excel add-in with structured Excel workbooks. Install the add-in first, then download a blank template or example workbook to begin.

Step 1: Install the Lease Accounts add-in for Excel

Please follow all 5 steps to get up and running with Lease Accounts.

The easiest way to install Lease Accounts is from Microsoft AppSource - Microsoft’s official marketplace for Excel add-ins. This provides a secure, verified installation with automatic updates.

Install from Microsoft AppSource

No sign-up is required. Your 30-day trial starts automatically when you first use the add-in.

Need to install from within Excel or deploy it centrally through IT? See the FAQ: Alternative installation methods.

Step 2: Download a Lease Accounts workbook

Choose a blank template to enter your own leases, or download an example workbook to see Lease Accounts in action.

These workbooks require the Lease Accounts Excel add-in — they cannot perform lease accounting calculations on their own.

More detailed worked examples are available in the example workbook section.

This tab contains your core report settings, including:

  • Start and end dates of the reporting period
  • The accounting standard to apply (e.g. IFRS 16 or ASC 842)
  • The reporting currency
  • Any applicable FX rates

You must also enter at least one:

  • Asset class (e.g. property)
  • Currency
  • Subsidiary

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 & Data' (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.

30-Day Trial
Trial

Try Lease Accounts free for 30 days. No sign-up is required — your trial starts automatically when you first use the add-in.

Follow the 5-step setup guide to install the add-in, download a workbook and start using Lease Accounts in Microsoft Excel.

Annual License
£319

Per user per year - billed securely via Paddle.

Includes 5 hours of expert support per user, per year.

Excel IFRS 16 ASC 842 lease accounting add-in screenshot

Lease Accounting in Microsoft Excel for IFRS 16, FRS 102 & ASC 842

Calculate lease liabilities, right-of-use assets, journal entries and disclosure reports inside Microsoft Excel.

  • Intuitive Excel Input
  • Automated Journals
  • Full Disclosure Reporting
  • Foreign Subsidiaries & Consolidation

Familiar Excel Environment

Work in Microsoft Excel using structured workbooks designed for finance teams, accountants and reviewers.

Data Privacy

Your lease data remains within your spreadsheet and is not uploaded to the cloud as part of the calculation process.

Automated Lease Journals

Calculate lease accounting entries for initial measurement, remeasurements, modifications, impairments, interest, depreciation and payments.

Group & Foreign Subsidiaries

Manage leases across multiple subsidiaries and currencies, including foreign entities, then consolidate for group reporting.

Lease Reporting Outputs

Generate lease liability reconciliations, right-of-use asset reconciliations, payment maturity analyses and journal summaries for IFRS 16, FRS 102 and ASC 842 reporting.

Structured & Customisable Workbooks

Use structured templates for consistent inputs while retaining the flexibility to adapt Excel workbooks to your reporting process.


Why choose Lease Accounts?

IFRS 16, ASC 842 and FRS 102 compliance in Excel - with hands-on support to get you live faster.

Best-in-class onboarding & support

Every user license includes 5 hours of expert support per year. Work with accountants who have implemented and run lease accounting projects - accelerate setup, validate outputs, and resolve edge cases quickly.

Built for groups and foreign subsidiaries

Track leases across multiple entities and currencies, then consolidate into group reporting. See our example workbooks to learn typical scenarios.


Lease Accounts FAQs


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.

Each user license includes 5 hours of expert support per year. Our support is delivered by accountants who have implemented and run lease accounting projects, helping you set up the template/add-in correctly and resolve queries quickly.

Note: Lease Accounts does not provide financial, accounting, tax, or legal advice. We help you achieve the outcomes you want using the software correctly, but you remain responsible for your accounting conclusions and disclosures.

£319 per user per year, billed in advance securely via Paddle. Each license includes 5 hours of expert support per year.

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.

The Lease Accounts add-in works with the following versions of Microsoft Excel:

  • Excel for Microsoft 365 (Windows or Mac, subscription versions)
  • Excel 2021 (Windows or Mac, perpetual license)
  • Excel Online (the browser-based version of Excel)

Earlier versions such as Office 2016 (non-subscription/perpetual) are not supported. We recommend using Microsoft 365 to ensure the best experience and latest updates.

Yes. While the easiest way is to install from Microsoft AppSource , you can also install directly inside Excel or have your IT team deploy it centrally.

Install from within Excel (individuals)

Open Excel and go to Insert > Get Add-ins. Search for "Lease Accounts", click Add, and follow the prompts. Once installed, the add-in appears under the Home tab.

Central deployment (organisations)

Many organisations restrict add-in installs. IT administrators can centrally deploy the add-in through the Microsoft 365 Admin Center:

Go to Settings > Integrated Apps, click Get Apps, search for Lease Accounts, and follow the prompts. This enables seamless access with Single Sign-on (SSO).

For Microsoft’s full instructions, see this article.


Lessee Accounting Example Workbooks

Explore worked example workbooks designed to help you master the Excel add-in quickly. Each workbook walks through a lessee accounting scenario, including lease remeasurements, lease modifications, variable lease payments and partial terminations.

FRS 102 users can refer to the IFRS 16 example workbooks.


These workbooks show a range of scenarios which a lessee may encounter in their lease portfolio and how to compute the accounting treatment using the Lease Accounts add-in. Examples include combining lease and non-lease components, exercising purchase options, lease remeasurements, lease extensions and variable lease payments.

The lessee extends the term of the lease by re-assessing the probability that it will exercise an extension option. See the initial measurement, IFRS 16 lease remeasurement and the impacts on the lease liability and right-of-use asset which result from the expected extension.

IFRS 16 Workbook ASC 842 Workbook

The lease payment profile includes variable payments which depend on an index. See the initial measurement and the accounting treatment when the payment profile changes according to the index.

IFRS 16 Workbook ASC 842 Workbook

The lessee agrees with the lessor to reduce the leased office space. See how to introduce the revised payment schedule and account for the existing right-of-use asset on lease modification and partial termination.

IFRS 16 Workbook ASC 842 Workbook