A person counting cash beside documents and a laptop
Finance use case · Real estate

Lease data is scattered across the property team

The accounting model is well understood. The difficulty is that the inputs live in filing cabinets, inboxes and a spreadsheet that one person maintains.

Key Takeaways
  • Lease accounting requires term, payment schedule, options, indexation and discount rate for every agreement in scope.
  • The population is the hardest part, because leases are signed locally and never reach a central register.
  • Modifications and option exercises are events that change the accounting, and they are communicated operationally rather than to finance.
  • Embedded leases inside service contracts are the most commonly missed category.
  • A maintained register with a change notification process is the control, and the calculation is comparatively straightforward once it exists.

The lease accounting model has been in force long enough that the calculation is routine. Right of use asset, lease liability, unwinding of the discount, and a straightforward set of disclosures.

What has not become routine is the data. The calculation needs term, payments, options, indexation and a discount rate for every lease, and those live in the agreements themselves.

The agreements are signed by property teams, regional managers and operational leads, and they arrive centrally when somebody remembers. For the people signing them, a lease is a commitment to be negotiated well rather than an accounting event with a measurement consequence, and nothing in the process tells them otherwise.

Lease AccountingReal EstateDataCompletenessReporting
01

Completeness is the real problem

Most lease accounting failures are not measurement errors. They are leases that were not in the population, which means nothing was calculated for them at all.

That happens because leases are entered into locally, for property, vehicles and equipment, by people who see them as operational commitments rather than as accounting events.

Embedded leases are the most commonly missed category. A service arrangement that grants the right to use an identified asset can contain a lease even where the contract is described as a service. Warehousing and logistics arrangements are a frequent example, which is one reason the cost analysis in per load profitability sometimes surfaces them before finance does.

This is a register problem, and registers fail in the ways described in data quality having no owner.

Hands reviewing balance sheets over a desk
The calculation is routine. Finding every lease is not.
02

Four inputs that have to be captured

For each lease in the population, four categories of information drive the numbers.

Term and options: Commencement, end date, renewal and termination options, and the assessment of whether exercise is reasonably certain.
Payments: Fixed payments, in substance fixed payments and any variable elements, which are treated differently.
Indexation: How payments change over time and on what basis, since index linked increases affect the measurement at remeasurement points.
Discount rate: The rate implicit in the lease where determinable, otherwise an incremental borrowing rate, which has to be supportable and documented, as the missing document problem applies here too.
03

Modifications are the ongoing problem

The initial exercise is finite. Someone gathers the agreements, the calculation runs and the balances appear.

What follows is ongoing. Leases are renegotiated, options are exercised or allowed to lapse, space is added or given back, and each of those is an accounting event.

The people who make those decisions are operational, and they communicate them to landlords and to their own management rather than to finance.

So the register decays, quietly, and the first evidence is usually an auditor asking about a property that is no longer occupied. Where construction or fit out work is involved the position is more complicated again, since the arrangements interact with the job costing described in the work in progress schedule, which is the same pattern as balances nobody is tracking.


The first exercise is a project. Keeping it right is a process, and only one of the two usually gets built.
04

Where leases hide

Three categories that are routinely missing from the initial population.

CategoryWhy it is missedHow to find it
Embedded leasesThe contract is described as a service, so nobody reads it as a lease.Review recurring payments to suppliers of equipment and facilities.
Small equipment leasesIndividually immaterial and numerous, arranged locally.Search payables for regular payments to leasing and rental companies.
Short term and rolling arrangementsTreated as ordinary expenses, and sometimes correctly.Confirm whether the arrangement is genuinely short term or has been rolling for years.

Lease identification, measurement and exemptions depend on the applicable framework and the specific contract terms. Confirm the treatment with your auditors.

"

The accounting is settled. The population is not.

ChatFin
05

Building a register that stays current

Four steps, and the third is what distinguishes a register that holds from one that decays.

Find the population from payments

Recurring payments to landlords, leasing companies and equipment suppliers, which is more reliable than asking people what they have signed.

Capture the four input categories

Term, payments, indexation and rate, with the agreement referenced rather than summarised from memory.

Create a notification obligation

Anyone signing, renewing or ending a lease notifies finance, as a stated requirement with a named recipient.

Reconcile the register to payments quarterly

Payments without a lease in the register, and leases without payments, which catches both additions and terminations, as any continuous tracking does.

Two people analysing financial documents with a calculator
Recurring payments are a better way to find leases than asking people.
06

Two failure modes after implementation

Both appear a year or two after the initial exercise, once the project team has moved on.

Failure

The register stopped growing

No new leases have been added for eighteen months, which almost never means none were signed. It means the notification process does not exist.

Failure

Rates never revisited

Incremental borrowing rates set at transition and applied unchanged to new leases years later, which is difficult to support when challenged.

07

How ChatFin supports lease data

Our contribution is completeness and reconciliation rather than the lease calculation itself.

Finds candidates from payments: Recurring payment patterns consistent with lease arrangements surfaced from the ledger for review, which is how missing leases are usually found.
Reconciles register to ledger: Payments matched against registered leases, with unmatched items in both directions raised as exceptions.
Prepares the supporting schedules: Movement schedules and disclosure inputs assembled from the register and the ledger for review and approval.

Lease identification, term assessments, discount rates and the accounting judgements remain with your team and your auditors.

Free tool

AI Cost Estimator for the CFO Office

Four inputs. A first year range, a timeline, and three delivery models compared. No login required.

Frequently Asked Questions

What is the hardest part of lease accounting now?

Completeness, in most organisations. The measurement model is well established, and the recurring difficulty is ensuring every lease is in the population, including embedded leases inside service contracts and small equipment arrangements entered into locally.

How do we find embedded leases?

By reviewing arrangements that grant the right to use an identified asset, which often means reading service contracts for equipment, facilities and logistics. Searching recurring supplier payments for those categories is a practical starting point when the contract population is large.

How do we keep the register current?

By creating an explicit notification obligation with a named recipient, and by reconciling the register to payments periodically. The reconciliation catches what the notification process misses, which is always some of it.

Do incremental borrowing rates need updating?

Rates should reflect the circumstances at the relevant date for each lease, so applying a rate set at transition to leases commencing years later is difficult to support. The basis for each rate should be documented at the time it is used.

Find it from the payments

The calculation is settled. The population is the work.

Identifying the population from recurring payments, capturing the four input categories and reconciling the register to payments quarterly is what keeps this from decaying.

If you want a first year range for lease register reconciliation and schedule preparation, the estimator gives one in about a minute. The practical test is whether someone outside the team could reach the same answer from the records you keep, which is usually a stricter standard than the one applied internally.

Open the estimator
Book a Demo
Put it on your own numbers

See what this looks like in your ERP.

We will walk through the workflow behind this article on the system you already run, using your own data, and show what a first phase would actually cover.

✓Runs on the ERP you already have, on the version you already run
✓Every action prepared as a draft that a person approves before it posts
✓A first phase scoped against your real workflows, not a generic package
Schedule a Demo
Confidential & private

This article is general information for finance and accounting teams. It is not legal, tax, accounting or investment advice. Dates and thresholds are given as published at the time of writing and several of these timelines have moved before, so confirm the current position with your advisers and with the relevant authority before acting.

Photos by Artem Podrez and Pavel Danilyuk, free to use under the Pexels License (commercial use, no attribution required).