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].
| Field | Lease file shows | Estoppel certificate shows | Rent roll shows | Tolerance and escalation owner |
|---|---|---|---|---|
| Base rent (current period) | Scheduled rent per the lease and any amendments | Tenant-certified current rent | Rent roll line item | Exact match expected; escalate anything beyond your own rounding tolerance (e.g., ±$[X]/month) to the acquisitions analyst |
| Lease commencement and expiration dates | Dates in the lease and any amendments | Tenant-certified term dates | Rent roll term column | Exact match expected; any variance not explained by a dated amendment escalates to the acquisitions analyst |
| Renewal or extension options | Option language: notice period, rent basis | Tenant confirms options remain, were exercised, or were waived | Confirm whether tracked; if absent, source from the lease file | Any conflict on option status escalates to the acquisitions lead |
| Security deposit | Amount and form (cash or letter of credit) per the lease | Tenant-certified deposit held | Deposit column, where tracked | Any amount or form mismatch escalates to the property accountant |
| TI allowance or free rent remaining | Remaining unamortized allowance or free-rent schedule | Tenant confirms none outstanding, or discloses a balance | Confirm whether tracked; if absent, source from the lease file | Any unresolved balance escalates to acquisitions counsel |
| CAM or expense reimbursement method | Pro-rata share and reimbursement basis | Tenant confirms current charges, notes any dispute | Rent roll reimbursement column | A disputed charge escalates to the property manager; a gap within your own threshold (e.g., ±[X]% of charges) doesn't |
| Lease default disclosures | Lease default provisions | Tenant certifies no default, or lists exceptions | Confirm whether tracked; if absent, source from the lease file | Any noted default or qualified answer escalates to acquisitions counsel |
| Assignment, sublease or guarantor | Assignment clause; guarantor, if any | Tenant confirms current occupant and guarantor match the lease | Rent roll tenant name | Any 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.
- Pick the fields first
We recommend starting with base rent and lease expiration: they drive in-place income and appear on all three sources.
- 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.
- Run the sample
Reconcile a sample of leases end to end, through estoppel and rent roll, including at least one anchor or large tenant.
- 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.
- 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.
Related reading
- document review with human approval covers a related extraction and sign-off pattern for contracts, leases and policies generally, not estoppels or rent rolls specifically.
- financial reconciliation automation covers a related pattern for financial records: deterministic matching rules first, AI for what's left, and exceptions routed to an owner.
- loan underwriting document workflow covers the adjacent diligence file that acquisition financing needs.
- For the fuller picture across lease and acquisition-diligence workflows, see our industry page, AI consultant for real estate and property management.
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 ChainsChargeback 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 OperationsJoint 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