Rent Roll vs. Lease Reconciliation: Catching the Discrepancies

A rent roll is a summarized ledger of every occupied and vacant space in a property, listing tenant names, unit identifiers, contractual rent, square footage, lease dates, and recurring charges as of a single point in time. Lease reconciliation is the verification process that checks each of those summary values against the underlying lease documents, amendments, and estoppel certificates to confirm the rent roll reflects what the parties actually agreed to. The rent roll states what a property manager believes is true. Lease reconciliation proves whether that belief holds. The gap between the two is where most operational and valuation errors live.

What a Rent Roll Actually Contains

A rent roll is a derived artifact. Someone, or some accounting system, entered its values from leases at signing and updated them as amendments arrived. Over a multi-year hold, those updates pass through property managers, asset managers, accounting staff, and often two or three different property management systems. Each handoff introduces the possibility of transcription error, omitted amendment, or misapplied escalation.

The typical rent roll carries a consistent set of fields, though the labels vary by platform and asset class.

The rent roll is only as accurate as the last person who touched it. Nothing in the document itself signals whether a value was verified against the lease or copied forward unexamined. That absence of provenance is the core problem.

Why the Two Diverge

Rent rolls and leases drift apart because they update on different schedules and through different people. A lease is a static contract, amended occasionally through formal documents. A rent roll is a living operational record touched monthly. The lease is authoritative but hard to read. The rent roll is readable but not authoritative.

Divergence accumulates through a small number of recurring mechanisms.

Escalations that never fire

Many leases carry scheduled base rent increases tied to a date or an index. If the escalation is entered as a one-time value rather than a recurring rule, the increase happens once and then stalls. Years later the rent roll shows a number well below the contractual rate, and no one notices until a reconciliation compares the roll against the escalation schedule in the lease.

Amendments applied to the wrong field

An amendment might extend a term, expand the premises, and reset base rent in a single document. If accounting captures the new rent but misses the square footage change, the rent roll now shows an internally inconsistent record: rent per square foot that matches neither the old nor the new premises.

Options treated as certainties

Renewal and expansion options are contingent. A rent roll often records the option as if it were exercised, or fails to flag an approaching option deadline. Either error distorts weighted average lease term and future cash flow assumptions.

Recurring charges left at estimate

Pass-through charges such as CAM, taxes, and insurance are frequently billed on estimates and reconciled annually. If the annual true-up is not posted back to the recurring charge fields, the rent roll carries stale estimates that misstate effective rent.

The Fields Most Likely to Be Wrong

Not all rent roll fields fail at the same rate. Verification effort should concentrate where error is both common and consequential. The following table ranks fields by how often they diverge from the lease and how much a divergence matters to valuation.

Base rent, escalations, term dates, and options carry the most weight because they drive net operating income and weighted average lease term directly. A single missed escalation compounds every month it goes uncorrected. A missed renewal option can misstate the remaining term of an anchor lease by years.

A Reconciliation Sequence That Catches Them

Reconciliation works best as an ordered pass rather than a scattered check. The goal is to move from the most authoritative document to the summary, field by field, and record every mismatch with its source citation. The sequence below assumes access to the full lease file including amendments and the current rent roll.

1. Assemble the complete document set for each tenant: original lease, every amendment, any assignment or estoppel. A reconciliation against an incomplete file produces false discrepancies.

2. Establish the current premises. Read forward through amendments to determine present square footage and suite configuration. This anchors every per-square-foot check.

3. Rebuild base rent from the escalation schedule. Compute what current rent should be given commencement and every scheduled increase, then compare to the rent roll.

4. Confirm term and options. Verify commencement, expiration, and the status of any renewal or termination option, including notice deadlines.

5. Reconcile recurring charges. Match the pass-through methodology and base year in the lease against the charges on the roll, and confirm the last true-up was posted.

6. Log concessions. Confirm free rent periods and abatements have expired or remain active as the lease states.

7. Record every mismatch with a citation to the specific document, section, and date. A discrepancy without a source cannot be resolved.

The output of a good reconciliation is not a corrected rent roll alone. It is a list of exceptions, each traceable to a lease provision, that an asset manager or buyer can act on.

Manual, Assisted, and Automated Approaches

The method used to reconcile scales with portfolio size and stakes. A single asset can be reconciled by hand. A portfolio in due diligence cannot, at least not within a diligence window. The tradeoffs are consistent across approaches.

Manual reconciliation gives a careful reader full context but does not scale and varies with attention and expertise. Spreadsheet-assisted methods speed the arithmetic but still depend on a human transcribing lease terms accurately. AI-assisted extraction reads leases and amendments, pulls the governing values, and compares them to the rent roll at portfolio scale. It is strongest on structured, well-defined fields such as base rent and dates, and weakest on ambiguous drafting that requires legal judgment. The practical pattern is to let automation handle the high-volume structured comparison and route genuinely ambiguous provisions to a human.

Reading Discrepancies Correctly

A discrepancy is a signal, not a verdict. When a reconciliation flags a mismatch, the rent roll is not automatically wrong. The lease file might be incomplete, an amendment might be missing, or the flagged value might reflect a side agreement not captured in the documents provided. Every exception needs a disposition.

Discrepancies generally resolve into one of a few categories, and the category determines the action.

The value of reconciliation comes from resolving exceptions to a disposition, not from generating a long list of flags. A reconciliation that ends with two hundred unexplained discrepancies has moved the problem, not solved it. A reconciliation that ends with two hundred flags, each labeled and assigned an action, has done the work.

Materiality also governs how hard to press each exception. A one dollar difference in a security deposit does not warrant the same effort as a mismatch in anchor tenant base rent. A practical reconciliation sets a threshold below which small differences are noted but not investigated, and concentrates resolution effort on the exceptions that move income, term, or risk. Spending equal time on every flag is a failure of prioritization that slows the work without improving the result. The discipline is to sort exceptions by consequence and resolve the consequential ones completely before touching the trivial.

Where This Matters Most

Reconciliation carries the highest stakes at moments of transaction and reporting. During acquisition due diligence, a buyer prices the asset off the rent roll and the leases behind it. An unverified rent roll can overstate in-place income, and the correction surfaces after closing when it is expensive to address. Estoppel certificates collected during diligence are, in effect, a tenant-confirmed reconciliation of the key economic terms, which is why buyers weight them heavily.

The same logic applies to lender reporting, portfolio valuation, and internal asset management. Any decision that treats the rent roll as ground truth inherits every unverified error inside it. Reconciliation is the step that converts a rent roll from a claim into a verified statement.

Conclusion

A rent roll and the leases behind it answer different questions. The rent roll answers what a property currently believes tenants owe. Lease reconciliation answers whether that belief is supported by the contracts. They diverge through predictable mechanisms: escalations that never fire, amendments applied to the wrong field, options treated as certainties, and pass-throughs left at estimate. Catching those discrepancies requires an ordered pass from the authoritative documents to the summary, concentrated on the fields where error is both common and consequential, with every mismatch cited to its source and resolved to an action. Done well, reconciliation turns a rent roll from an assertion into evidence, which is exactly what a buyer, lender, or asset manager needs before making a decision on it.

Related Reading

• Automating Lease Reconciliation Without Losing the Audit Trail

• CAM Reconciliation: A Step-by-Step Framework

• How to Read a Rent Roll and Reconcile It to the Leases

• What Is Lease Reconciliation? Definitions and Common Pitfalls

• CAM Reconciliation Explained: How to Audit the Landlord's Statement