Reading a Rent Roll and Checking It Against Actual Income

A buyer or lender verifies a rent roll by bridging it to cash: contract rent from the leases, less concessions, less billed rent that went unpaid, tested against a trailing 12 months of actual income and expenses. The rent roll states what tenants owe on one date, so only collections show what the property earned. A complete check also dates each document, separates assumed vacant-space rent from received rent, and puts the expense side through the same test.

What a rent roll can prove and what only collections can

A rent roll is a schedule of obligations on a single date. It lists each space, the tenant, the lease dates and the contract rent. It shows what tenants owe if every lease performs as written, and it says nothing about what reached the bank.

Annualizing the current month multiplies one month by 12 and assumes that month held for the whole year. A trailing 12 months of income and expenses, usually called the T12, records what happened. The distance between those two figures is where verification work sits.

Net effective rent is the third figure in play. It accounts for concessions and discounts, so a tenant paying a stated rent during a term that includes free months produces a lower effective rent than the stated number. Reviewing it, together with actual collections, can show that an asset generated less income than its rent roll suggests.

Sellers often overestimate revenue and underestimate expense. That tendency is why trailing actuals carry more weight than a proforma: they record events, while a proforma records a forecast.

“Beyond the rent roll, scrutinize the actual collections, including a trailing 12 months (T12) of income and expenses. Review the net effective rent, which accounts for concessions and discounts that affect the rent figures.”

“Sellers overestimate revenue and underestimate expense. Check against the trailing actual numbers, not proformas. 29.”

Building the bridge from scheduled rent to deposited cash

The bridge has five steps, and each one isolates a different kind of gap.

The first step totals contract rent for every month of the period from the rent roll and the lease terms. The second subtracts concessions and discounts, which gives the rent actually due under the agreed economics. The third subtracts rent that was billed for the period and never paid. What remains is the rent collected for that period.

The fourth step sorts the bank deposits. Cash received for earlier unpaid charges and cash received in advance for future months both land in the period without satisfying the period’s own charges. Removing them from the period leaves a clean collection figure.

The fifth step compares that figure with the T12. A difference that survives all four adjustments is an unresolved item, and it stays open until a ledger entry or a lease document explains it.

Keeping concessions and unpaid rent in separate lines matters. A concession is a lower agreed payment. Unpaid rent is an obligation still owed. They answer different questions about the lease and the tenant, and a single combined deduction hides which question applies.

Dating the documents: two freshness clocks in multifamily appraisals

Multifamily appraisal files put two separate clocks on the record. The appraisal rent roll is asked to be dated within 30 days before the effective date of value. Concluded unit rents are asked to be supported by subject-property leases commencing within 90 days of that date.

The first clock tests the snapshot of who is in place and at what contract rent. The second tests whether the rent level is supported by leases signed recently enough to reflect current pricing. A fresh roll full of older leases supports occupancy, and it leaves the rent level resting on aged evidence.

A lender file holds more than a rent roll. Supervisory guidance for institutions with CRE concentrations lists recent property cash flow statements, rent rolls, guarantor personal statements and tax return data among the financial records to maintain.

The pairing matters for scope. A rent roll that agrees with a property cash flow statement confirms a fact about the property. Guarantor statements and tax return data speak to who stands behind the loan, which is a separate question that a clean rent roll does not touch.

Vacant space, occupied space and office utilization change what a total means

A conventional multifamily definition of gross rental income uses actual rents for occupied units and current market rents for vacant units, multiplied by 12. The total therefore holds two kinds of dollars. Occupied units carry rent that a tenant is obligated to pay. Vacant units carry an assumption about what the space could rent for.

Only the occupied portion can be tested against leases and collections. The vacant portion needs its own support, such as recent leases at the property. Reading the combined total as collected income gives an assumption the same standing as a receipt.

Office adds a different layer. In office financing, lenders look at rent-roll detail alongside office utilization and building class. The rent roll shows who owes rent and when the obligation ends. Utilization shows how the space is used, which bears on whether a tenant keeps the space. Neither document answers the other’s question.

Each total used in a comparison should carry its definition: occupied only, occupied plus vacant at market, or collected cash. Two figures built on different definitions cannot be subtracted to find a discrepancy.

The expense side needs the same trailing test

Net operating income is income minus operating expenses, so a reconciled revenue line leaves half of the figure untested. Broker expense estimates are qualified against actual revenue and actual costs before they support a value.

The arithmetic shows why. Value at a given cap rate equals NOI divided by that rate, so each dollar of NOI overstated lifts indicated value by the reciprocal of the cap rate. Revenue that is too high and expenses that are too low push NOI in the same direction, and the errors add together.

Actual expense history is the check. A line that falls well below its trailing level in the seller’s presentation needs a stated reason, such as a contract change or a completed project, before it carries into underwriting.

Worked example: a hypothetical $10,000,000 building with identical rent rolls and different collections

This hypothetical example uses a fully occupied building offered at a price of $10,000,000. The rent roll shows $100,000 of contract rent per month. Trailing actual operating expenses are $480,000. Both cases share the price, the rent roll and the expenses. Only collections differ.

The seller’s view multiplies $100,000 by 12 to reach $1,200,000 of annual rent. Subtracting $480,000 of expenses gives NOI of $720,000. Dividing $720,000 by the $10,000,000 price gives 7.2 percent. The cap rate here is one year of NOI over price.

In the base case, the T12 shows concessions of $60,000 and billed rent of $30,000 that went unpaid. Rent collected for the period is $1,200,000 minus $60,000 minus $30,000, or $1,110,000. NOI is $1,110,000 minus $480,000, or $630,000. The yield on price is 6.3 percent.

The base-case bank statements hold a trap. Deposits also include $20,000 received for earlier arrears and $10,000 paid in advance. Total deposits are $1,110,000 plus $20,000 plus $10,000, or $1,140,000. Charges after concessions are $1,200,000 minus $60,000, also $1,140,000. The totals match even though $30,000 of the period’s rent was never paid.

The stressed case keeps the same $20,000 of arrears and $10,000 of prepayments but has concessions of $120,000 and unpaid rent of $90,000. Rent collected for the period is $1,200,000 minus $120,000 minus $90,000, or $990,000. NOI is $990,000 minus $480,000, or $510,000. The yield on price is 5.1 percent. Deposits are $990,000 plus $20,000 plus $10,000, or $1,020,000, against charges after concessions of $1,200,000 minus $120,000, or $1,080,000, so the mismatch now shows in the totals.

Against the seller’s $720,000, the base case is short by $90,000 and the stressed case by $210,000. The price is fixed, so every lost dollar of NOI lowers the yield on price one for one. The yield falls from 7.2 percent to 6.3 percent in the base case and to 5.1 percent in the stressed case.

Common mistakes in reading a rent roll against income

Labeling an annualized rent roll as trailing income mixes a point-in-time contract position with a record of events. Multiplying one month by 12 assumes that month applied to every month of the year. A T12 captures the actual months, including any with concessions, vacancy or unpaid rent, so the two figures answer different questions.

Folding concessions and unpaid rent into one deduction hides the mechanism. A concession lowers the agreed payment and affects net effective rent. Unpaid rent leaves the full obligation outstanding and points to the tenant’s payment performance. The underwriting consequences differ, so a single line cannot support either.

Accepting matching deposit totals as proof of collection ignores allocation. Arrears from earlier months and prepayments for later months raise deposits without paying the period’s charges. In the example, deposits equal charges after concessions at $1,140,000 while $30,000 of period rent stayed unpaid.

Counting market rent on vacant units as collected income treats an assumption as a receipt. The conventional gross rental income definition legitimately includes vacant-unit market rent. The error occurs when that amount moves into a collections claim without separate support.

Treating a fresh rent roll as proof of rent levels confuses two tests. A roll dated within the checklist window supports the snapshot. Concluded rents are tied to subject-property leases commencing within their own, longer window, and older leases at a fresh roll leave that second test unmet.

Finishing the revenue reconciliation and accepting the seller’s expense lines leaves NOI unsupported. Because value equals NOI divided by the cap rate, an understated expense moves value as much as an overstated rent.

Questions that close out a rent roll reconciliation

What date and period does each income figure cover? A rent roll is a snapshot, while a T12 spans twelve months, and every comparison starts from that distinction.

Which lease terms support the rent shown for each occupied space? The lease is the source for contract rent and for the timing of any free months.

How much do concessions and discounts reduce stated rent over the same period? The result is net effective rent, which can sit well below the number on the roll.

How much rent billed for the period remains unpaid? That balance separates payment performance from lease economics.

Which deposits belong to earlier charges or to future months? Allocation explains why total deposits can equal charges while a shortfall exists.

Does any gross rent total include market rent on vacant space? That portion is an assumption and needs its own support.

Are the rent roll and the supporting leases within the dates the lender or appraiser requires? Different documents run on different clocks.

Do operating expense lines match the trailing actual costs? NOI is only as reliable as its weakest line.