Rent Roll

A rent roll is a dated schedule of the spaces, occupants and lease economics at a property. It usually shows each unit or suite, tenant, occupancy status, contract rent, lease dates and selected balances or concessions. It is a management representation assembled from other records. It does not amend a lease, prove that rent was collected or establish that a tenant is current.

Freddie Mac's Multifamily Seller/Servicer Guide requires a submitted rent roll to state its “as of” date and, for applicable multifamily properties, include tenant and unit identifiers, unit type and size, occupancy status, monthly contract rent, concessions, arrearages, subsidies and lease dates, among other fields. [1] Those requirements illustrate the information needed for that underwriting program; they are not a universal form for every property or lender.

Read it as a snapshot, not an income statement

The roll answers “what does management say is in place on this date?” A trailing twelve months operating statement answers “what income and expense was recorded during the preceding period?” The two should connect, but they should not be forced to match. A newly leased unit appears on today's roll before it contributes twelve months of collections. A tenant that vacated last month can still appear in historical revenue. Delinquency can leave contract rent unchanged while collected cash falls.

Preserve every rent roll received with its date and source. Replacing an earlier version destroys evidence of leasing changes during diligence. Compare versions by unit so that new leases, move-outs, rent changes, concessions and status changes are visible.

Reconcile the roll to four record sets

Start with completeness. Reconcile the property's legal and physical unit inventory to the rent roll. Identify vacant, model, employee, corporate, down, storage and office units separately. A unit should appear once under one current status. Duplicate records and omitted offline units can distort both occupancy and potential rent.

Then test lease economics. Compare a sample or the full population, depending on scale and risk, against executed leases and amendments. Verify contract rent, commencement and expiration dates, renewal status, recurring charges, concessions and security deposits. A signed amendment supersedes a convenient number in the management system.

Finally, reconcile billed rent to collections. Separate current charges from prior-period arrears, deposits, one-time fees and non-rent receipts. A rent roll can report $1,800 of contract rent for a tenant that has paid nothing for three months. Treating $1,800 as current cash flow without the ledger and aging converts a legal claim into assumed income.

Convert the snapshot into a dated income bridge

Multiplying the occupied contract rent of $6,300 by twelve produces $75,600. That arithmetic is neither trailing collections nor a defensible next-twelve-month forecast. The result ignores the concession, delinquency, mid-month expiration and vacancy. The $2,325 October amount is also incomplete because later collections, recoveries and renewals remain uncertain. The point of the bridge is to expose those assumptions rather than bury them in one annualized total.

Build expiration and collection views separately

Lease expiration risk and credit loss are different. An expiring tenant may be fully current but create future downtime and leasing cost. A delinquent tenant may have years remaining on the lease but contribute little current cash. Maintain both an expiration schedule and an accounts-receivable aging.

For commercial property, also capture suite area, expense-recovery method, options, percentage rent, co-tenancy exposure and guaranty information when material. For residential property, preserve lawful rent restrictions, subsidies and unit designations. Do not mix market rent with contract rent in one unlabeled column; loss to lease is an analytical comparison, not an existing lease charge.

Investigate changes that are economically inconsistent

Useful exception tests include identical tenant names in multiple units, occupied units with zero rent, vacant units with deposits, expirations before the as-of date, commencement dates after the as-of date, rents that disagree with the ledger, unexplained manual credits and occupancy that does not reconcile to the stated unit count. Fannie Mae's multifamily fraud-prevention guidance identifies discrepancies between rent-roll occupancy and inspections, incomplete rolls, advertised availability for units reported occupied, and conflicting overlapping rent rolls as warning signs. [2]

The objective is not a clean-looking spreadsheet. It is a traceable schedule whose unit-level status agrees with the controlling documents, payment records and physical property. Once reconciled, the roll can support current occupancy, contractual revenue, expiration concentration and a forecast. Until then, it remains an unverified management report.

Control changes after the as-of date

A reconciled rent roll begins aging immediately. Between the stated date and closing, tenants may pay arrears, default, renew, vacate or sign amendments. Establish a cut-off procedure for material changes and require an updated roll before the analysis is finalized.

The update should preserve the prior version and explain each changed line. If occupancy rises from 92% to 96%, identify the units and executed leases behind the increase. If receivables fall, distinguish cash collection from a write-off or credit. This version history turns a changing management report into an auditable diligence record.