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.

Need a standalone calculation? Download our free Excel lease accounting calculator — no add-in required.

For the full version, 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.

Standalone Excel workbook · Completely free

Free Excel Lease Accounting Calculator

Calculate lease liabilities, right-of-use assets and annual accounting summaries in Microsoft Excel. Complete the familiar lease input form, enter your cash flows and view disclosures for each financial year of the lease.

No Excel add-in No registration No payment

Choose a dedicated IFRS 16 lease calculator, FRS 102 lease accounting template or ASC 842 lease calculator. Each free workbook is supplied separately and is subject to its stated limitations. Requires a compatible edition of Excel with FILTER and LET functions.

Your lease calculation in three steps
01
Enter initial lease detailsComplete the required fields in the input form.
02
Add assumptions & cash flowsInclude revised payment profiles where relevant.
03
Review annual accounting outputsUse the accounting summary and disclosures in the workbook.
Need more functionality? The full version uses the same input form plus the Lease Accounts add-in.

How to Get Started with the Full Version

The full version combines the structured lease input workbook with the Lease Accounts Excel add-in and calculation script. Install the add-in first, then download a full-version workbook. Want a standalone template instead? Download the free calculator.

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 full-version workbook

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

These are full-version workbooks. They require the Lease Accounts Excel add-in to calculate lease accounting entries. The separate free Excel calculator calculates without the add-in.

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.

Free Excel Calculator
£0

Standalone Excel workbook with annual lease accounting summaries for supported scenarios.

No add-in, login or subscription required. Compatible Excel version needed.

Full Version — 30-Day Trial
Trial

Try the full Lease Accounts add-in free for 30 days. 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.

Full Version — Annual Licence
£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

Full-Version Lease Accounting in Excel for IFRS 16, FRS 102 & ASC 842

The full Lease Accounts product combines the structured Excel input workbook with the Lease Accounts add-in and calculation script, unlocking advanced calculations, journals and disclosure reporting.

  • 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


The free version is a standalone Excel workbook. It uses Excel formulas to calculate supported lease accounting scenarios and provide annual accounting summaries. You do not need the Lease Accounts add-in.

The full version is the structured workbook PLUS the Lease Accounts Excel add-in (calculation script). The add-in performs advanced calculations and generates journals and reports, including features such as multi-lease reporting, more complex remeasurements and consolidated disclosures.

Download the free calculator or see how to use the full version.

Yes. No payment, licence, Microsoft sign-in or add-in installation is required. Download the workbook and use a compatible version of Microsoft Excel. The full add-in is a separate product with a 30-day trial and paid annual licences.

Download the separate free workbook for FRS 102, IFRS 16 or ASC 842. In its Settings & Data tab, check the accounting standard and enter the asset classes and financial year-end month.

It is intended for the accounting scenarios supported by the free workbook, not every specialised treatment under these standards. Review the limitations before relying on the figures.

Complete Initial Data, Calculation Inputs and Cash Flows. Required cells are highlighted pink. Configure the accounting standard, asset classes and month of year-end in Settings & Data. The accounting summary then shows the relevant financial-year calculations and disclosures.

If cash flows change, enter the remeasurement date and revised cash flow profile as described in the workbook guidance.

The free workbook covers a defined range of scenarios. Features available only in the full version include:

  • ASC 842 lease reclassifications and multiple remeasurements within a financial period;
  • transition options, dismantling provisions, purchase options and practical expedients;
  • right-of-use asset impairments, initial direct costs and certain modification gains or losses;
  • intercompany transfers, foreign subsidiary accounting and consolidated journals, reports and disclosures.

This is not an exhaustive list. See the notes within the free workbook for further detail.

The free workbook uses the FILTER and LET functions extensively. Use Excel for Microsoft 365 (desktop, Windows or Mac), Excel 2021 or Excel 2024 (desktop, Windows or Mac). Excel 2019 and earlier do not support the required functions.

Excel for the web has not been verified for this particular workbook, so use a supported desktop version for the free calculator. The full Lease Accounts add-in has separate system requirements.

Yes. Both use the same familiar lease input form, making it easier to move to the full version. The full version adds the Lease Accounts Excel add-in/script, which enables advanced functionality. Some additional setup or data organisation may be needed, depending on your use case.

Currently both the free calculator and the full Lease Accounts product support lessee accounting only.

The structured inputs simplify the process, but lease accounting still requires judgement about contracts, assumptions, adjustments and disclosures. You remain responsible for reviewing the inputs and verifying the results; neither version provides professional accounting advice.

Each paid full-version licence includes 5 hours of expert product support per user per year for onboarding, setup and troubleshooting. The standalone free calculator does not include those paid support hours.

We help users operate the software; we do not provide financial, accounting, tax, audit or legal advice. You remain responsible for your accounting conclusions and disclosures.

Free standalone calculator: £0. No sign-in or payment is needed.

Full version: £319 per user per year, billed in advance via Paddle. You can try the full add-in for 30 days before purchasing. Paid licences include 5 hours of expert support per user per year.

The free calculator has no checkout or subscription.

Full-version paid licences are billed securely through Paddle, our Merchant of Record. Paddle handles payments, invoices and applicable taxes. You can manage subscriptions through the customer portal.

The full Lease Accounts Excel add-in supports Excel for Microsoft 365 on Windows or Mac, Excel 2021 on Windows or Mac, and Excel for the web. Earlier perpetual versions such as Office 2016 are not supported. We recommend Microsoft 365 for the best experience.

For the standalone free calculator, use the desktop Excel versions listed in the separate free-calculator compatibility question above.

No add-in installation is required for the free calculator.

For the full version, the easiest route is to install Lease Accounts from Microsoft AppSource. You can also open Excel and choose Insert > Get Add-ins, search for "Lease Accounts" and select Add.

For organisations, IT can deploy it centrally via Microsoft 365 Admin Center > Settings > Integrated Apps. See Microsoft's deployment guidance.


Full-Version Lessee Accounting Example Workbooks

Explore worked examples for the full Lease Accounts Excel add-in. These workbooks require the add-in; if you want calculations directly in Excel without the add-in, download the standalone free calculator instead. The examples cover lease remeasurements, modifications, variable 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