Platform

Industries

Resources

Updates & Security

Company

/

Knowledge work automation

Rent roll analysis: how to test a seller's roll against leases, estoppels and AR aging

Rent roll analysis: how to test a seller's roll against leases, estoppels and AR aging

17 min read

—

Cluster of residential apartment towers at golden hour against a blue sky
Cluster of residential apartment towers at golden hour against a blue sky

Date the roll against the T-12 and AR aging, test each suite against its lease, amendments and estoppel, and hand underwriting a versioned tenant record with every variance priced and sourced.

Man with dark hair and beard, wearing a grey shirt.

Casimir Rajnerowicz

Content Creator

Summarize

V7 Go

A smarter way to manage due diligence and underwriting

The seller's rent roll for a 14-suite suburban office building puts contract rent at $116,527.50 a month. The property manager's August AR aging shows $94,087.50 billed to the same tenants for the same month. The $22,440 gap is 19% of the roll. Either one document is wrong or a third document explains the difference. The building and every figure here are hypothetical.

Rent roll analysis on an acquisition decides which, suite by suite, before anyone prices the rent. The roll is dated August 16 and the T-12 runs to September 30, 45 days later. The LOI review with your VP is tomorrow at nine, and $1.40 million of annual rent sits behind the price you will recommend.

The roll is a statement the seller signed, so it gets tested like any other representation. Test it against the documents that can contradict it, in order of authority. The lease and its amendments say what the tenant agreed to pay. The estoppel says what the tenant believes it owes. The AR aging shows what the manager billed, and the T-12 shows what the books recorded. By morning you need figures you can defend, written questions for the seller and a first version of the tenant record.

Real Estate

Turn leases and loan documents into portfolio decisions.

Real Estate

Turn leases and loan documents into portfolio decisions.

How to analyze a rent roll when the roll, the AR aging and the T-12 carry three different dates

Three cut-offs create gaps that look like errors and are sometimes only timing. Put the dates in a table before comparing any rent.

Date

Document

Covers

Gap risk

Request tonight

Aug 16, 2026

Seller rent roll

Leases and rent on one day

Changes signed after the 16th

Seller’s list of lease changes since August 16

Aug 1-31, 2026

AR aging

Charges, receipts and balances by tenant

Mid-month moves, late credits

Tenant ledgers for August and September

Sep 30, 2026

T-12 cut-off

Income, Oct 2025 to Sep 2026

45 days the roll cannot see

Rental income ledger detail, August and September

Oct 15, 2026

LOI review

Price recommendation

Roll is 60 days old

Updated roll, if the manager has one

A move-out or a rent relief letter between August 17 and September 30 reaches the T-12 and the September ledger. It never reaches the roll. The ledger and lease-change requests in the last column close that window before the morning meeting.

Lenders treat the roll as a signed claim. In agency multifamily lending, Fannie Mae’s Form 4243, Certification to Project Rent Roll, is co-signed by the borrower and the management agent. Chapter 40 of the Freddie Mac Multifamily Guide requires tenant name, unit ID, contract rent and lease start date on a certified roll. It also caps the roll’s age at six months for annual financial submissions. Fannie Mae wants the roll dated within 60 days of the appraiser’s inspection.

These rules govern apartment loans, and an office purchase answers to its PSA. By the Fannie Mae yardstick, the August 16 roll turns 60 days old on LOI day, with a $22,440 gap already showing.

Six tests the roll has to pass on its own figures

The roll gets tested against itself first. A footing or date failure found here costs one formula, while the same failure found after lease review costs a second pass through the file.

Test

Condition

Failure usually means

Footing (test 1)

Rows sum to the summary tab and the stated GPR

Hidden row or stale summary tab

Suite count (test 2)

Rows match the appraisal suite count, vacancies included

An omitted vacant suite inflates occupancy

Date order (test 3)

Commencement precedes expiration

Keying error or a renewal typed over the lease

Expired leases (test 4)

Expiration falls after the as-of date

Holdover carried as term income

Rent step (test 5)

Rent equals base rent stepped by the stated escalation

Step skipped or applied early

Rent per sq ft (test 6)

Within two standard deviations of the building mean (our working band)

Transposed digits or a concession folded into rent

The step test computes base rent × (1 + step rate) raised to the full lease years elapsed. A 3% step on a $24.00 base should read $25.46 after two years. A roll showing $24.00 or $26.23 has a skipped or early step.

On the example, 14 rows foot to $116,527.50 and match the summary tab, and vacant suite 330 is listed. Test 4 fails at suite 320. Its lease expired June 30, 47 days before the roll date, yet the roll carries its $5,200 a month as term income. Rent runs from $23.40 a foot at suite 300 to $28.00 at suite 410, inside the band. None of the six tests touches the $22,440, because the roll agrees with itself.

Rent roll analysis against the five documents that can contradict the roll

Each outside document answers one question per suite, and the answers go in one row so each variance sits beside its proof. The variance column is AR billed less roll rent, so it sums to the opening gap. The lease and estoppel columns catch two failures that billing never shows.

Suite

Lease rent (Aug)

Roll rent

Estoppel rent

AR billed (Aug)

Variance (AR less roll)

Source

Owner

100

$9,100

$9,100

$9,100

$9,100

$0

Lease p. 4, estoppel p. 1

Associate

150

$11,600

$13,340

$11,600

$11,600

-$1,740

First Amendment §2, p. 2

Associate

200

$0 free (face $7,500)

$7,500

$0 through Aug 31

$0

-$7,500

Lease §4.3, p. 6

Associate

240

$5,800

$5,800

$4,300 ($1,500 credit claimed)

$5,800

$0

Estoppel ¶5, p. 2 (lease silent)

Counsel

300

$12,480

$12,480

Not returned

$0

-$12,480

AR aging p. 3

VP Acquisitions

320

$7,800 holdover

$5,200

Not returned

$5,200

$0

Lease §22, p. 18

Asset manager

410

$11,200 gross

$11,200

$11,200

$12,320

+$1,120

Lease §6, p. 7 and AR aging p. 4

Asset manager

430

$7,000

$7,000

Not returned

$5,160

-$1,840

None found

Associate

Other 6 (330 vacant)

$44,907.50

$44,907.50

$44,907.50

$44,907.50

$0

Leases and estoppels

Associate

Total

$116,527.50

$94,087.50

-$22,440

The owner column says who acts next. Counsel takes the estoppel conflict at suite 240, and the VP takes suite 300, where the tenant may be gone. Suite 430 has no document behind its $1,840, so it becomes a question for the seller.

The executed lease: rent at the as-of date, term and tenant entity

The executed lease is the first authority on the rent step in force on August 16, commencement, expiration and the tenant’s legal entity. A roll that shows a trade name where the lease names an LLC raises a credit question, because only the signing entity can be pursued. Suite 320’s lease ended June 30. Section 22 sets holdover rent at 150%, or $7,800, while the roll and the AR aging carry $5,200.

Lease abstraction interface with a lease document beside extracted terms such as lease commencement date

Commencement and expiration on the roll get tested against terms read from the executed lease, shown here as an illustration of lease-term extraction.

Agency lenders sample instead of reading everything. Fannie Mae’s multifamily lease audit has the lender review the greater of 5 leases or 10% of leases at 10 to 100 units. The sampling table sets 40 leases at 301 to 900 units and 50 above 900, each reconciled to the roll before commitment. A buyer of a 14-suite building reads all 13 occupied leases, since one tenant here carries 13% of roll rent. Tool choice for the abstract itself is covered in our guide to choosing a lease abstraction tool.

Amendments: the last rent the tenant signed

The roll should carry rent from the latest effective amendment, with the source column citing its section and page. Suite 150’s First Amendment is dated March 1, 2026. It cut rent from $27.60 to $24.00 a foot from April 1 and extended the term to March 31, 2032. The roll still shows the base-lease figures. It overstates rent by $1,740 a month, or $20,880 a year, and understates remaining term by five years.

The AR aging and the estoppel both match the amendment, which marks the roll as the outlier. When an estoppel or a later document refers to an amendment the data room lacks, log it as missing. An unseen amendment can change rent, term or options.

Estoppels: the tenant’s own version of the lease

An estoppel is the tenant’s signed account of its lease, and the one document in the file written from the tenant’s side. Compare rent and steps, commencement and expiration, prepaid rent or credits, claimed landlord defaults, options and co-tenancy rights against the lease.

Suite 240’s estoppel agrees on $5,800 of rent but claims a $1,500 monthly credit through December for unfinished landlord work. The lease is silent and the AR aging bills the full amount. Counsel and the seller get that conflict, since $7,500 of rent through year-end and a possible landlord default depend on the answer.

Suites 300, 320 and 430 returned no estoppel. They carry $24,680 of monthly roll rent, so returned estoppels cover 78.8% of roll rent. Office and retail lenders commonly look for 80% to 90%, which is market practice and appears in no published rule. The three missing certificates are a data room job, covered in our real estate data room analysis guide. Our estoppel certificate review automation handles field extraction. Multifamily deals replace per-unit estoppels with a certified roll and a lease audit.

AR aging: what the property manager actually billed in August

The AR aging shows charges billed, receipts applied and balances by age bucket for each tenant. Differences from the roll fall into four categories, and two of them change underwriting.

  • A timing difference starts or ends inside the month. Suite 200’s three free months ended August 31, so its $7,500 returns in September.

  • Unapplied cash is a receipt not yet posted to a tenant. It makes a payer look late but leaves billed rent alone, so none of the $22,440 sits here.

  • A billing error is a charge the lease does not allow. Suite 410’s gross lease recovers no operating expenses, yet August shows $1,120 of CAM, a $13,440 refund claim if it ran all year.

  • True delinquency is rent owed and unpaid. Suite 300 was billed nothing in August, carries a balance past 60 days and returned no estoppel.

Suite 150’s $1,740 is a roll error the aging exposed, and suite 200’s $7,500 is an undisclosed concession that ends as timing. Suite 300’s $12,480 is delinquency or vacancy, and suite 410’s $1,120 runs the other way as a billing error. The last $1,840, at suite 430, has no explanation. Pass-through tests against each lease’s recovery clause are covered in our guide to CAM reconciliation.

The T-12: contract rent annualized against booked income

The T-12 comes last because it sits furthest from any single suite. Annualize the reconciled contract rent, set it beside booked rental income and bridge the difference through vacancy, free rent, bad debt and collection loss. Here, suite 200’s free months remove $22,500 from booked income, and suite 300’s balance moves to bad debt once the tenant’s departure is confirmed. Our T-12 analysis guide carries the full income tie-out and the adjustment register.

The five source tests as a V7 Go workflow, with Python for the math and a lease page behind every variance

In V7 Go for commercial real estate teams, the five tests run as a defined workflow in the same order on every deal. Each step returns a declared output type. One property workspace holds the seller roll (xlsx), the 13 leases and amendments (PDF), the returned estoppels, the August AR aging and the T-12.

Lease documents being imported into V7 Go for processing

Leases, amendments and estoppels sit in the same property workspace as the seller roll, so each variance can point to the page that supports it.

The workflow for this building has five steps.

  1. A Python step reads the roll and runs the six internal tests, returning pass or fail for each suite.

  2. A model step reads every lease and amendment and returns the rent schedule, dates, holdover terms and tenant entity as typed fields.

  3. A second Python step computes rent in force on August 16 and its variance against the roll, the estoppel and the AR aging.

  4. A model step compares each estoppel with its lease on rent, credits, defaults and options, citing both pages for any conflict.

  5. Every variance lands in an exceptions queue with its type, monthly dollar value, severity and owner.

Architecture diagram of a V7 Go agent turning document inputs into structured outputs through a five-step workflow

Each source test runs as a fixed step with a typed output, so the August reconciliation has the same shape on every deal.

Arithmetic and dates stay in Python steps, so a rent step or a day count comes out the same on every run. The model reads language, and each figure it returns opens the sentence that states it. An associate who clicks suite 150’s $11,600 lands on page 2 of the First Amendment.

The associate works the queue and corrects or assigns each item, and the VP signs off before v1 is released. The reviewed dataset exports as Excel or CSV, or reaches a property system through the API, the V7 Go MCP server or a scoped integration. Built once with the deal team on a live file, the same rent roll extraction and checks run on the next acquisition.

What the corrected roll says about occupancy, WALT and the top three tenants

Every metric gets recomputed on v1, and the move from the seller’s v0 is what a VP reads first. Two metrics fall sharply, one rises and the top-three list changes.

Metric

Seller roll (v0)

Reconciled (v1)

What moved it

Physical occupancy (by NRA)

94.3%

83.3%

Suite 300 treated as vacant

Economic occupancy (August)

94.4%

76.4%

Suites 300 and 200 billed nothing

Rent-weighted WALT

2.29 years

2.99 years

Suite 150’s amendment adds five years

Top-3 share of rent

35.4%

37.3%

Suite 410 replaces suite 300

Top-3 share of NRA

33.1%

30.3%

Same change, smaller suite

Rent expiring in 12 months

24.7%

20.1%

Suite 150 leaves, holdover suite 320 enters

The economic figure follows the Wall Street Prep definition, rent collected divided by gross potential rent. August billed rent stands in until receipts post. GPR is $123,402.50 on v0 and $121,662.50 on v1, with vacant suite 330 at an assumed $25.00 a foot. When suite 200’s free rent ends, v1 reaches 82.6%, still 11.8 points below the seller’s figure.

WALT uses the rent-weighted formula from PropertyMetrics. Multiply each lease’s annual rent by its remaining term in months, sum the products, divide by total annual rent and convert to years. It rises from 2.29 to 2.99 years because suite 150’s amendment cut its rent 13% and pushed expiration to 2032. Report the 0.70-year lift in the IC memo with the same First Amendment citation as the $1,740 rent cut.

CREFC’s IRP Servicer Watchlist code 4D looks at the top three tenants with leases expiring within six months. It flags the loan when each holds at least 5% of NRA and together they exceed 30%. On v1, the largest expiring tenant holds 12.1% of NRA, with a lease ending January 31, 2027. Holdover suite 320 holds 4.3%, below the per-tenant 5% floor. The building stays off the list, and the servicer of any new loan will rerun that test after closing.

The 12-month expiry figure falls from 24.7% to 20.1%, which reads as good news until you check what moved. Suite 150 left the window because its amendment extended the term. Suite 320 entered as a holdover that can leave on short notice. The v1 figure is smaller and less certain, so the memo should name both suites.

V7 Go chat panel where a user asks about the financial impact of termination clauses for leases expiring within 12 months

In V7 Go, rollover and termination questions like this one return usable figures only once they run against the reconciled v1 leases.

Loss-to-lease runs next, on v1 rents. Our piece on loss-to-lease and concessions in multifamily covers that analysis for apartment deals.

An exception log with one row per variance, priced in monthly rent and closed by a named person

Each exception becomes a record that a VP, an asset manager and outside counsel can work from without asking what a row means. Three rows from the reconciliation show the fields.

Field

Suite 150

Suite 240

Suite 300

Filled by

Property

Office, 58,000 sq ft

Same

Same

Workflow

Exception type

Amendment supersedes roll

Estoppel credit not in lease

Billing stopped, tenant may be gone

Workflow, associate confirms

Roll value

$13,340, expires 3/31/2027

$5,800

$12,480, occupied

Workflow

Source value

$11,600, expires 3/31/2032

$4,300 net of credit

$0 billed, balance past 60 days

Workflow

Source document and page

First Amendment §2, p. 2

Estoppel ¶5, p. 2

AR aging p. 3

Workflow

Monthly rent impact

-$1,740

-$1,500

-$12,480

Python step

Severity

Price or PSA item

Blocks underwriting

Blocks underwriting

Associate, VP confirms

Owner

Associate

Counsel

VP Acquisitions

VP Acquisitions

Status

Corrected in v1

Open, seller asked

Open, site visit set

Owner

Sign-off and date

VP, Oct 14, 2026

Pending

Pending

VP Acquisitions

Impact is always computed against the roll value, so rows add up and the total checks against the reconciliation. Status changes only when the owner attaches the closing document. For suite 300 that means a surrender agreement, a default notice or a site visit report. The associate proposes severity and the VP confirms it.

What underwriting, the lender and asset management receive in version 1 of the tenant record

Tonight’s deliverable is a normalized, reconciled and versioned dataset with one row per suite. The seller’s file is v0. The reconciled dataset, with its as-of date, reviewer and exception log attached, is v1. A seller update becomes v2, and the workflow reports its deltas against v1 suite by suite.

Suppose the seller’s update shows suite 430 at $5,160 with a rent relief letter attached. v2 records the new rent, the letter and the closed exception, and the IC memo cites v2. Without the version trail, the same $1,840 would reach the memo as a fresh number with no history.

Each row carries the fields that underwriting and downstream systems use.

  • Suite, area, tenant legal entity and trade name, with status as occupied, vacant or holdover.

  • Commencement, expiration, rent in force, next step date and amount, and recovery structure.

  • Estoppel status, security deposit and renewal, expansion and termination options.

  • Source document and page for every value, plus the exception IDs that touch the row.

Those fields are shaped like the tenant and unit records a Yardi or MRI setup expects. The dataset goes in by export or through a scoped integration. The IC memo and the lender package cite “rent roll v1, as of August 16, 2026” and never a filename. The underwriting team takes the rent, term and recovery fields into its input tab, where the three sizing tests in our real estate underwriting guide read them. The lender package takes the as-of date and top-tenant rows. Asset management takes the whole file as its opening tenant history.

V7 Go table view with one row per apartment and extracted rent, deposit and availability columns

A typed table with one row per unit and rent and deposit fields is the shape v1 takes, shown here in V7 Go on a sample apartment-listings project.

Lenders already work in dated versions. The CREFC Investor Reporting Package records the effective date of the roll it uses in a field called “Date Lease Rollover Review”. Its property file reports only the top 5 tenants plus 4 years of rollover. Fannie Mae requires unit-level rent roll data on a template developed with the MBA and aligned to C-MISMO within 5 business days of origination.

After closing, v1 is the baseline the asset manager tests the first post-acquisition roll against. In V7 Go the suites, tenant entities, leases, amendments and approved values stay linked as the firm’s approved property record. The next stage of this deal, and the next deal with a shared tenant, retrieves records the team already approved. None of them trains a model. A question such as which tenants across three buildings hold 2027 termination options then runs on reviewed data.

AI Implementation

Start with one workflow, then roll it out across the firm.

AI Implementation

Start with one workflow, then roll it out across the firm.

Which exceptions stop the model and which go back to the seller

Severity decides what happens before the LOI. These thresholds are our suggested starting points, to be calibrated by asset type and deal size, and they carry no industry standing.

Severity

Trigger

Effect on underwriting

Owner

Deadline

Blocks underwriting

Unexplained variance above 2% of monthly GPR, an estoppel that contradicts the lease on rent or term, a missing amendment, or a top-3 tenant with unresolved status

Figure stays out of the model and the LOI states the assumption

VP Acquisitions, with counsel on estoppel conflicts

Before LOI

Price or PSA item

Confirmed rent shortfall, undisclosed concession, pass-through billed against the lease

Model uses the source value, and price, a PSA representation or a credit covers the difference

VP Acquisitions

Before PSA

Seller question

Timing difference, unapplied cash, holdover status, unexplained variance under 2% of GPR

Model carries the documented value with a flag

Associate

Before PSA, escalated if unanswered

Recorded only

Rounding under $25 per suite, suite ID formatting

None

Associate

Before close

Items with a PSA deadline then join the deal’s wider CRE due diligence checklist.

On the August numbers, suites 240 and 300 block underwriting, and $12,480 a month stays out of the model until the VP has an answer. Suites 150, 200 and 410 become price or PSA items. Suites 320 and 430 go to the seller as written questions. Suite 430’s $1,840 is the one figure in the $22,440 gap that nobody can yet explain.

What fields does a Fannie Mae or Freddie Mac multifamily lender expect on a rent roll?

Freddie Mac's Multifamily Guide defines a borrower-certified rent roll as including, at minimum, the tenant name, the unit number or physical ID, the contract rent and the lease start date. Fannie Mae asks for the roll to be certified on Form 4243, which the borrower and the management agent both sign, and it requires unit-level rent roll data on a template developed with the MBA and aligned to C-MISMO within five business days of origination. Those are the floors for agency apartment loans. An acquisitions team usually carries more columns than the lender minimum, because the reconciliation needs lease expiration, rent steps, concessions, security deposits and vacancy status to test each unit against its lease. Adding the source document and page for each value costs little at intake and saves a second pass when the lender's lease audit asks where a figure came from.

+

How old can a rent roll be before you request an updated one?

For agency multifamily loans there are two published limits. Freddie Mac caps a certified roll at six months old for annual financial submissions, and Fannie Mae wants the roll dated within 60 days of the appraiser's inspection. Commercial acquisitions have no equivalent rule, so the practical test is what could have changed since the as-of date. A roll dated in mid-August and used for an October decision misses every move-out, new lease, amendment and rent relief letter from the intervening weeks. Many deal teams ask for an update once a roll passes 30 days at the decision date. Whatever the age, ask the property manager for tenant ledgers covering the gap period and ask the seller for a written list of lease changes since the roll date. Those two documents usually explain more than a fresh roll would on its own.

+

What do you do when a tenant estoppel contradicts the executed lease?

Record the conflict as an exception with both sources cited, the estoppel paragraph and the lease section, and price it in monthly rent. Then route it to counsel and the seller, because which document governs and what remedy follows is a legal question that the deal team should not settle on its own. Common explanations include a side letter or amendment that never reached the data room, a tenant misreading its own lease, or a genuine landlord default such as unfinished tenant improvements. Until the conflict is resolved, keep the disputed amount out of the underwriting model and state the assumption in the LOI or the IC memo. If the estoppel claims a rent credit, compute the total exposure through the credit's end date so the VP sees a dollar figure. Keep the exception open until a document closes it, whether a corrected estoppel, a produced amendment or a negotiated PSA credit.

+

Why would the rent roll and the AR aging show different rent for the same month?

The difference usually falls into a handful of causes. Timing items come from move-ins, move-outs or free-rent periods that start or end within the month. Unapplied cash affects balances, so it explains a tenant that looks late but leaves billed rent unchanged. Billing errors include pass-through charges a lease does not permit, such as CAM billed on a gross lease. True delinquency or vacancy shows up when the manager stops billing a tenant who has left while the roll still lists the suite as occupied. A fifth cause is a roll error that the AR aging exposes, typically an amendment that changed rent while the roll kept the base-lease figure. Decompose the gap suite by suite until every dollar sits in one category, and treat anything left over as a written question for the seller, with the property manager's tenant ledger requested as support.

+

What is the difference between physical and economic occupancy on a rent roll?

Rent-weighted WALT multiplies each lease's annual rent by its remaining term, sums the results across all leases and divides by total annual rent. Area-weighted WALT uses square feet in place of rent and is useful for comparing physical exposure. Measure remaining term from the roll's as-of date, and run the calculation on the reconciled roll, because the inputs that most often move it are exactly the ones reconciliation corrects. An amendment that extended a lease will raise WALT, while a holdover tenant should count as zero remaining term and a vacated suite should drop out entirely. Report the top three tenants separately so the VP can see whether a single expiration drives the number. A building can show a comfortable WALT while one large tenant expires within months, which is why lenders also look at near-term expirations by tenant share of rentable area.

+

How do you calculate WALT from a rent roll?

Go is more accurate and robust than calling a model provider directly. By breaking down complex tasks into reasoning steps with Index Knowledge, Go enables LLMs to query your data more accurately than an out of the box API call. Combining this with conditional logic, which can route high sensitivity data to a human review, Go builds robustness into your AI powered workflows.

+
Man with dark hair and beard, wearing a grey shirt.

Casimir Rajnerowicz

Content Creator at V7

Casimir is a seasoned tech journalist and content creator specializing in AI implementation and new technologies. His expertise lies in LLM orchestration, chatbots, generative AI applications, and computer vision.

Build once.
Deploy across teams.
Improve over time.

Constance Freedman
Founder and Managing Partner
Moderne Ventures

Build once.
Deploy across teams.
Improve over time.

Constance Freedman
Founder and Managing Partner
Moderne Ventures

Build once.
Deploy across teams.
Improve over time.

Constance Freedman
Founder and Managing Partner
Moderne Ventures