How to Effectively Track Lease Accounting: A Guide for Real Estate Managers

Lease Accounting Is a Tracking Problem, Not Just a Standards Problem

Most real estate managers know the rules. ASC 842 and IFRS 16 have been in effect for years, and the concepts—straight-line revenue, right-of-use assets, lease liabilities—are well documented. What breaks in practice is tracking: rent schedules living in spreadsheets, escalations applied from memory, abatements missed, and a month-end close where the deferred rent balance no longer ties to the schedule that produced it.

Effective lease accounting is a data discipline. If the lease terms are captured accurately once, every downstream number—recognized revenue, accrued or deferred rent, lease liability, maturity disclosure, journal entry—falls out of the same schedule automatically. If they aren't, every close becomes a reconciliation exercise.

This guide lays out how to structure that tracking, whether you're on the landlord (lessor) side, the tenant (lessee) side, or both.

Start With the Data That Drives Everything

Every lease accounting output depends on a small set of fields. Capture them once, at abstraction, and audit them before they enter your schedules:

• Commencement and expiration dates — day-accurate, not month-rounded. A term entered as 60 months when it is actually 59 months and 12 days will misstate straight-line rent for the entire life of the lease.
• Base rent and rent steps — every escalation with its own effective date, whether a fixed dollar increase or a percentage bump.
• Free rent / abatement periods — which months are abated and whether the abatement is full or partial.
• Landlord incentives — tenant improvement allowances, landlord work, and leasing commissions, with the treatment for each.
• Percentage rent terms — breakpoint, percentage, and reporting frequency, where applicable.
• Recoveries and operating cost structure — net, gross, or modified gross, plus the recovery method.
• Options — renewal, termination, and expansion rights, along with whether exercise is reasonably certain.

A single source of truth for these fields is the foundation. Duplicating them across a rent roll spreadsheet, a budget model, and an accounting workbook guarantees they will diverge.

Track Lessor Accounting in Four Layers

For landlords and asset managers, operating-lease accounting under ASC 842-30 is best tracked as four connected layers rather than one monolithic report.

1. Rent Reconciliation

This is the bridge from contractual cash rent to recognized revenue. Total fixed consideration over the term—net of abatements—is divided by the number of periods to produce straight-line revenue. Each month, the difference between cash rent billed and straight-line revenue recognized is the period's deferred rent movement.

Two views matter here:

• Contractual — what the lease says should be billed. This is the basis for GAAP revenue.
• Actual — what was actually invoiced and collected. Comparing the two surfaces billing variances and outstanding A/R that pure accounting schedules hide.

Managers who only look at the contractual view can be fully compliant and still blind to a collections problem.

2. Deferred Rent Rollforward

The rollforward is your audit trail: opening balance, plus straight-line revenue, less cash rent billed, equals closing balance. Run it monthly and annually, per lease and in aggregate.

The discipline here is simple but non-negotiable: the closing deferred rent balance in the rollforward must equal the cumulative difference between recognized revenue and billed rent since commencement. If it doesn't, a term, escalation, or abatement was changed without rebuilding the schedule.

3. Maturity Analysis

Both standards require disclosure of undiscounted future lease payments by year, with a "thereafter" bucket. Two tracking rules keep this accurate:

• Start from the current period, not the start of the fiscal year—prior months are no longer future payments.
• Exclude variable consideration such as percentage rent and recoveries that aren't fixed, unless they are in-substance fixed.

4. Journal Entries

The output that closes the loop. Each month you need entries for straight-line revenue, the deferred rent movement, and cash received, per lease and per property, with memo detail that lets an auditor trace any line back to a lease and period. If your journal entries are re-keyed by hand from a report, you have an accuracy problem waiting to surface.

Don't Forget the Tenant Side

Corporate occupiers with many locations face the harder tracking problem, because the lessee model puts leases on the balance sheet.

• Lease liability is the present value of remaining fixed payments, discounted at the incremental borrowing rate. Track the rate used per lease and the date it was set—auditors will ask.
• Right-of-use asset for an operating lease equals the liability adjusted for accrued or prepaid rent and any incentives received.
• Single operating lease cost is recognized straight-line and split internally between liability accretion and ROU amortization.
• Obligation maturity is disclosed undiscounted, with imputed interest reconciling the total to the recorded liability.

Multi-location tenants should track all of this per site, then roll it up by region and entity. Portfolio-level totals with no site-level detail cannot be audited or renegotiated from.

Build a Month-End Close Routine That Ties Out

The habits that separate clean closes from painful ones:

1. Rebuild schedules on every amendment. An amendment, renewal, or blend-and-extend changes total consideration and remaining term. Editing a single month's number instead of rebuilding the schedule is the most common source of drift.
2. Reconcile to the rent roll monthly. Contractual rent per the schedule should equal billed rent per the rent roll, with any variance explained.
3. Reconcile deferred rent to the rollforward. Balance sheet to schedule, every period.
4. Review variable revenue separately. Percentage rent and recovery true-ups follow different recognition timing than fixed rent—track them alongside, not inside, the straight-line schedule.
5. Keep documentation attached to the lease. Executed leases, amendments, estoppels, and abstracts should be one click from the schedule they support.
6. Run a quarterly data audit. Spot-check terms, escalation dates, and abatement months against executed documents on a rotating sample.

Common Tracking Failures to Watch For

• Month-rounded terms that inflate or deflate the straight-line denominator.
• Escalations applied on anniversary instead of effective date, throwing off both cash rent and the deferred balance.
• Abatements modeled as reduced rent rather than zero-rent months, which distorts the free rent disclosure.
• Incentives expensed rather than amortized over the term.
• Percentage rent accrued straight-line, which overstates revenue before the breakpoint is met.
• Schedules that live only in one analyst's workbook, with no version history and no audit trail.

Where a Platform Changes the Math

Spreadsheets can produce correct lease accounting for a handful of leases. They fail at scale because the term data and the schedules are the same artifact—change one cell and nothing downstream re-derives.

Purpose-built lease management changes that relationship. In LeaseWare by Tenmark, the lease accounting module derives everything from the abstracted lease terms:

• Rent reconciliation with a toggle between contractual and actual collected rent, so revenue recognition and A/R are visible in one place.
• Deferred rent rollforwards that regenerate automatically when a lease is amended or renewed.
• Maturity analysis that always starts from the current period and excludes variable consideration.
• Month-end journal entries generated per lease and property, ready for export to your GL.
• A lessor / lessee toggle, so owners track revenue and deferred rent while multi-location tenants track ROU assets, lease liabilities, and obligations on the same underlying data.

Because escalations, abatements, TI, landlord work, commissions, and percentage rent are captured in the lease record itself, the accounting schedules and the leasing team's rent roll cannot drift apart.

The Bottom Line

Effective lease accounting tracking comes down to three things: capture the lease terms accurately once, derive every schedule and disclosure from those terms, and reconcile the balance sheet to those schedules every single period. Managers who get this right spend close week reviewing results instead of rebuilding spreadsheets—and they can answer any question about any lease, in any period, with evidence.