Estoppel, Rent Roll and Lease Reconciliation with AI: A Due Diligence Variance Checklist

A seller's rent roll, a signed estoppel certificate and the underlying lease file can diverge on fields that matter at closing: wrong in-place rent, a missed option, an undisclosed default. This article sets out a three-way reconciliation method, a variance checklist to run it with, and where AI-assisted extraction helps with the comparison without replacing anyone's judgment.

In short

Estoppel rent roll reconciliation checks each material lease field -- rent, term, options, deposits, defaults -- across the lease file, the tenant's signed estoppel, and the seller's rent roll. Start from the lease as your baseline data source; which document should prevail in a conflict is a question for counsel, not this workflow. Unresolved gaps go back to the seller before closing.

On this page
  1. How do you reconcile an estoppel certificate to the lease?
  2. The due diligence variance checklist
  3. What rent roll discrepancies matter most in an acquisition?
  4. Can AI review estoppels faster than attorneys or analysts?
  5. Which variances require seller follow-up before closing?
  6. Where to start: a first scoped workflow
  7. When this doesn't apply
  8. Frequently asked questions
  9. Related reading
  10. Sources

At a glance

  • Start from the lease and its amendments as the baseline source, then check the estoppel and rent roll against it; which document should prevail in a conflict is a question for counsel, not this checklist.
  • The variance checklist below pairs each material lease field with what the lease, the estoppel and the rent roll each show, a tolerance, and an escalation owner -- usable on its own as a closing-file tool.
  • Rent, term and option dates drive in-place income, so start there; confirm unamortized TI allowances and free-rent balances from the lease file when the rent roll has no field for them.
  • AI-assisted extraction can compare the three sources at once and flag disagreements for review, instead of someone holding all three documents open side by side; deciding what a flag means, and whether it's acceptable, stays with the acquisitions team and counsel.
  • A first workflow reconciles one or two fields across a sample of leases before the full rent roll, so the exception process is proven before volume hits.

How do you reconcile an estoppel certificate to the lease?

An estoppel certificate is a short, signed statement from a tenant confirming specific facts about their lease: the rent currently due, the lease's start and end dates, any renewal options, the security deposit held, and whether either party is in default. A buyer or lender asks for it because the lease, however detailed, only shows what the parties agreed to at signing and in later amendments -- not what either side says is true today.

Reconciliation means putting the lease file, the signed estoppel, and the seller's rent roll side by side for each material field, starting from the lease and its amendments as the baseline source and checking the other two against it. Which document should prevail when they genuinely conflict is a legal question for your counsel, not something this workflow determines.

Work field by field, not tenant by tenant. A single lease can pass on rent and term but fail on an option date or a default disclosure, and treating a tenant's file as reconciled once the obvious fields match is how smaller fields get missed.

The due diligence variance checklist

The table below is a starting checklist, not a complete list of every lease provision an acquisition might need to confirm. Treat the tolerance column as a default, filling in the bracketed thresholds with your own materiality policy. Freddie Mac Multifamily lists a Rent Roll Template, dated 10/01/2020, under References & Tools on its Originate & Underwrite page [2].

Due diligence variance checklist: lease, estoppel and rent roll by field
FieldLease file showsEstoppel certificate showsRent roll showsTolerance and escalation owner
Base rent (current period)Scheduled rent per the lease and any amendmentsTenant-certified current rentRent roll line itemExact match expected; escalate anything beyond your own rounding tolerance (e.g., ±$[X]/month) to the acquisitions analyst
Lease commencement and expiration datesDates in the lease and any amendmentsTenant-certified term datesRent roll term columnExact match expected; any variance not explained by a dated amendment escalates to the acquisitions analyst
Renewal or extension optionsOption language: notice period, rent basisTenant confirms options remain, were exercised, or were waivedConfirm whether tracked; if absent, source from the lease fileAny conflict on option status escalates to the acquisitions lead
Security depositAmount and form (cash or letter of credit) per the leaseTenant-certified deposit heldDeposit column, where trackedAny amount or form mismatch escalates to the property accountant
TI allowance or free rent remainingRemaining unamortized allowance or free-rent scheduleTenant confirms none outstanding, or discloses a balanceConfirm whether tracked; if absent, source from the lease fileAny unresolved balance escalates to acquisitions counsel
CAM or expense reimbursement methodPro-rata share and reimbursement basisTenant confirms current charges, notes any disputeRent roll reimbursement columnA disputed charge escalates to the property manager; a gap within your own threshold (e.g., ±[X]% of charges) doesn't
Lease default disclosuresLease default provisionsTenant certifies no default, or lists exceptionsConfirm whether tracked; if absent, source from the lease fileAny noted default or qualified answer escalates to acquisitions counsel
Assignment, sublease or guarantorAssignment clause; guarantor, if anyTenant confirms current occupant and guarantor match the leaseRent roll tenant nameAny name mismatch or unresolved sublease escalates to acquisitions counsel

The escalation owner chases the seller or tenant for a resolution, not the final legal call. A flagged default or an unresolved SNDA question still goes to counsel, regardless of who first raised it.

What rent roll discrepancies matter most in an acquisition?

Not every mismatch carries the same risk. A rent roll is the seller's own summary, not a tenant-certified document, so treat it as a starting point to verify, not a settled record: some drift from the lease file is minor, and some signals a bigger problem.

  • Base rent and any scheduled increase already in effect -- a mismatch here changes the deal's in-place income directly.
  • Lease expiration and renewal option status -- a rent roll that shows a tenant as month-to-month when the lease shows a live renewal option changes leasing risk and valuation.
  • Security deposit amount and form -- cash held versus a letter of credit affects what's actually recoverable if a tenant defaults.
  • Unamortized tenant improvement allowance or remaining free-rent period -- confirm from the lease file, since the rent roll may have no field for it, and missing it changes the deal's economics without warning.
  • CAM, tax and insurance reimbursement method -- a rent roll's summary label doesn't always match the lease's actual reimbursement formula.

Can AI review estoppels faster than attorneys or analysts?

Document-intelligence tools can read a batch of estoppels, lease files and rent roll rows, extract the same fields from each, and flag where the three disagree -- comparison work that otherwise falls to an analyst working through documents one at a time. What it can't do is decide whether a disclosed default is serious, whether a nonstandard estoppel qualification is acceptable, or what an SNDA provision means for financing. Those calls need a person who understands the deal.

Where extraction and matching help:

  • Pulling the same fields -- rent, dates, options, deposit, default language -- from differently formatted leases, estoppels and rent rolls into one comparable table.
  • Flagging a field where the three sources disagree, instead of requiring someone to hold all three documents open at once.
  • Surfacing language, such as an estoppel qualification or an SNDA exception, that isn't a plain confirmation, so it gets a person's attention rather than being read past.

Decisions that stay with people:

  • Whether a flagged variance is within tolerance or needs seller follow-up.
  • The legal meaning of a disclosed default, a qualified estoppel, or an SNDA term.
  • Final sign-off that the closing file's reconciliation is complete.

ARGUS Enterprise, for example, supports "lease by lease modeling for a transparent view of all assured income" [1], so the fields this checklist confirms -- rent, term, options -- are the kind of inputs such a model uses. Confirm with ARGUS's own documentation how to enter reconciled data into your model; this article claims no import or integration feature.

Which variances require seller follow-up before closing?

Some variances are easy to close out without going back to the seller, such as a rounding difference in a CAM reimbursement estimate. Others change what the buyer is acquiring and need a resolved answer, in writing, before closing:

  • Any disclosed default, whether landlord or tenant, that the rent roll and lease file don't show.
  • A rent, term or option date the estoppel contradicts, where the contradiction isn't explained by a dated amendment.
  • A security deposit amount or form the estoppel states differently from the lease file.
  • An unamortized TI allowance, outstanding landlord obligation, or free-rent period the estoppel discloses but the rent roll omits.
  • A tenant that qualifies its estoppel -- striking language or adding exceptions -- instead of signing the standard form.

Check whether your purchase agreement sets a minimum estoppel-delivery threshold, measured by leased square footage or rent. Where it does, an uncooperative or qualified estoppel from a large tenant can put that threshold at risk, so surface these variances early, not at a final review.

Where to start: a first scoped workflow

Scope a first pass narrowly: one or two fields, across a sample of leases, before the full rent roll and variance table.

  1. Pick the fields first

    We recommend starting with base rent and lease expiration: they drive in-place income and appear on all three sources.

  2. Set tolerances before you start

    Agree what counts as a match, a rounding difference, and an escalation for each field, in writing, before the exception queue fills up.

  3. Run the sample

    Reconcile a sample of leases end to end, through estoppel and rent roll, including at least one anchor or large tenant.

  4. Route every flag to a named owner

    Every unresolved variance gets an owner and a deadline tied to the closing date, not a shared queue with no owner.

  5. Expand field by field

    Add the remaining fields once the first pass's exception rate and escalation process are working, rather than reconciling everything on day one.

When this doesn't apply

  • The deal has few enough leases that a manual read-through is already fast and accurate; a new workflow's overhead isn't worth it for a handful of tenants.
  • The seller's rent roll and lease files are already well maintained and rarely drift, so the variance rate doesn't justify building a new reconciliation step.
  • The open question is a legal one -- what a disclosed default means, whether an SNDA term is acceptable -- rather than a data-matching one; that stays with counsel regardless of any tooling.
  • Lease files are incomplete or unsigned at the point of diligence; reconciliation needs a signed lease to reconcile against, not a draft.

Frequently asked questions

What evidence should the diligence file keep?

Keep the reconciliation output itself: the lease file, the signed estoppel, the rent roll line, and a note of the outcome for every field in the variance checklist. Record who resolved each flagged variance and how. That evidence trail matters more at closing, and later if a dispute arises, than a summary memo alone.

What's the difference between an estoppel certificate and an SNDA?

An estoppel certificate is the tenant's written confirmation of specific lease facts -- rent, term, defaults -- addressed to a buyer or lender. An SNDA (subordination, non-disturbance and attornment agreement) instead addresses what happens to the tenant's lease if a lender forecloses. They serve different purposes; confirm which your transaction requires with counsel.

Which source should the reconciliation start from?

Start from the signed lease and its amendments as your baseline data source for the reconciliation, then check the estoppel and rent roll against it field by field. Which document should legally prevail when they conflict is a question for your counsel to resolve, not something this checklist determines on its own.

How do you handle a rent roll field the estoppel doesn't address?

Treat a silent field as unresolved, not as confirmation. An estoppel confirms only what it states; it isn't a certification that every other rent-roll line is correct. A field with no tenant confirmation still needs a lease-file check before it's accepted, flagged the same way you'd flag an outright conflict.

Can one tenant's uncooperative estoppel delay a closing?

Check your purchase agreement for a minimum estoppel-delivery threshold, measured by leased square footage or rent, that the seller must meet before closing. Where one exists, a missing or qualified estoppel from a large tenant can put that threshold at risk, so escalate it well before the closing date, not after.

Does an AI review replace legal review of the estoppel?

No. AI-assisted extraction and comparison can surface where the lease, estoppel and rent roll disagree without requiring someone to hold all three documents open at once, but the meaning of a disclosed default, a nonstandard clause, or an SNDA provision stays with counsel. This article covers the reconciliation step, not the legal judgment step.

Sources

  1. [1] — ARGUS Enterprise product page, feature list (accessed 2026-09-30)
  2. [2] — Originate & Underwrite page, References & Tools section, Rent Roll Template dated 10/01/2020 (accessed 2026-09-30)

More in Document intelligence

340B Program Documentation: Where AI Agents Reduce Audit Risk (Not Replace Compliance Officers)

How AI agents can assemble 340B program documentation, from split-billing records to contract pharmacy files, while your compliance officer keeps each decision.

Pharmacy Chains
·9 min read

Chargeback and Returns Dispute Document Automation for E-Commerce Brands

Chargeback and returns dispute automation for e-commerce: a step-by-step dispute-document workflow and evidence table, with submission kept with your staff.

Ecommerce Operations
·11 min read

Joint Interest Billing and Land/Lease Administration Document Automation for Independent Energy Operators

Joint interest billing automation for independent operators: a lease-to-distribution workflow showing what an agent drafts and what staff approve.

Utilities and Energy Companies
·11 min read