Rent Roll Template: Fields, Occupancy Metrics, and Lender Use

A rent roll template is a spreadsheet that lists every unit in a rental property on its own row, with columns for the tenant, lease dates, rent, deposit, and status, so an owner, lender, buyer, or appraiser can see the property’s income picture at a glance. Build it once around the fields lenders actually require and it will carry you through underwriting, a sale, and tax season without rework. The sections below walk through what to put in each column, how to structure the file, and what the people on the receiving end will check.

Core Fields for a Residential Rent Roll

A residential rent roll needs enough detail to tell an outsider exactly who is paying what, for how long, and which units are empty. Fannie Mae’s multifamily rent roll template is the closest thing to an industry standard, and conventional lenders often model their own requirements around it. Each row represents one unit and, at minimum, should include:

  • Unit identifier. A unique label for each apartment or house so there is no ambiguity when cross-referencing leases.
  • Bedroom count. Fannie Mae requires this field because it drives market-rent comparisons.
  • Tenant name. The legal name on the lease, not a nickname or business alias.
  • Lease status. Whether the unit is occupied, vacant, or used as a model or rental office. Units serving as a model or rental office are reported as vacant.
  • Contract rent. The dollar amount the tenant pays under the lease.
  • Market comparable rent. The asking rent for that unit type based on neighborhood comparables or an appraisal. Lenders use this field to spot below-market leases.
  • Utilities included. A yes-or-no indicator showing whether utilities are bundled into rent or billed separately.
  • Lease start and end dates. These define when the tenant’s obligation begins and when rollover risk kicks in.
  • Security deposit. The amount held, typically one to two months of rent depending on the jurisdiction.
  • Rent roll as-of date. The snapshot date for the data, which must not be a future date.

Fannie Mae’s template requires each of these fields and validates them on submission, rejecting files with missing data in required columns.1Fannie Mae. Multifamily Rent Roll Template Lender Guidance Even if you never submit to Fannie Mae, building around these fields means you won’t have to rebuild when a lender asks.

Add columns for ancillary income like pet fees, parking charges, storage rentals, or laundry revenue. These secondary streams flow into gross income and affect valuation. A notes column is useful for flagging month-to-month tenancies, pending evictions, or rent concessions that an outsider wouldn’t catch from the numbers alone.

Additional Fields for Commercial Properties

Commercial rent rolls carry everything a residential template does plus several fields residential landlords never think about. Lease type matters enormously. A triple-net (NNN) lease where the tenant pays taxes, insurance, and maintenance on top of base rent produces a fundamentally different income picture than a gross lease where the landlord absorbs those costs, so the template needs a column identifying each tenant’s lease structure.

Key additions for commercial properties:

  • Base rent per square foot. Commercial leases price space by the foot, and this figure is how investors compare deals across markets.
  • NNN or CAM reimbursements. The tenant’s share of property taxes, insurance, and common area maintenance, billed monthly as an estimate of their annual obligation.
  • Annual escalation rate. Most commercial leases include built-in rent increases, often 2% to 3% per year or tied to a consumer price index.
  • Renewal options. Whether the tenant can extend, and at what rate. A five-year lease with two five-year renewal options reads very differently to a buyer than a five-year lease with no renewal rights.
  • Tenant credit quality. For industrial and retail properties, lenders want to know whether they’re looking at a publicly traded company or a sole proprietorship.
  • Expense caps and exclusions. Some leases cap annual expense increases or exclude structural items like the roof and foundation from tenant responsibility. These carve-outs affect actual reimbursement income.

Commercial rent rolls also need to account for annual reconciliation. Landlords typically charge tenants one-twelfth of estimated annual expenses each month, then true up against actual costs at year-end. Tracking both the estimated charges and the actual expenses in the template prevents reconciliation surprises.

How to Structure the Spreadsheet

Put the unit identifier on the far left, followed by tenant name, lease status, and lease dates, then financial columns (contract rent, market rent, additional income), and finally notes. This left-to-right progression moves from identification to economics, which is how most people scan a spreadsheet.

Fannie Mae’s template locks column headings and the top section in rows one through ten, with unit-level data starting on row eleven. The workbook tab must be named “Rent Roll,” and the file must be saved as .xlsx without formulas or macros in the data fields.1Fannie Mae. Multifamily Rent Roll Template Lender Guidance If you need formulas, build them on a separate worksheet and paste values into the rent roll tab. The restriction exists because Fannie Mae’s system validates raw data, not calculated outputs.

Add summary rows at the bottom for total monthly income, total square footage, weighted average rent per square foot, and the count of vacant versus occupied units. These aggregates are the first thing a lender or buyer reads. In Excel or Google Sheets, conditional formatting that highlights vacant units or expiring leases in a different color makes the document scannable in seconds.

How the Numbers Get Used

The rent roll is the starting point for virtually every income-based property valuation. Gross potential rent is what the property would earn if every unit were occupied and every tenant paid full market rent. Subtract the gap between in-place and market rents, vacancy loss, and concessions like free-rent periods, then add back ancillary income from parking, laundry, and pet fees. The result is effective gross income. Subtract operating expenses and you have net operating income, which divided by the market capitalization rate for the property type and location produces the implied value. A rent roll error that overstates income by a few hundred dollars a month can inflate the implied value by tens of thousands once divided by a cap rate in the 5% to 7% range.

Economic Occupancy Versus Physical Occupancy

Physical occupancy measures how many units have tenants: occupied units divided by total units. A property with 95 out of 100 units filled has 95% physical occupancy. But if ten of those occupied units are getting two months of free rent, or five tenants are chronically behind, the cash coming in is far lower than the headcount suggests.

Economic occupancy captures this gap by dividing rent actually collected by gross potential rent. A building that is 95% physically occupied but only 82% economically occupied has a collections or concessions problem. Lenders care about economic occupancy more than physical occupancy because it reflects cash flow rather than headcount. Your rent roll should make both calculations possible by including columns for contract rent, market rent, concessions, and outstanding balances.

Lease Expiration Concentration

A rent roll also reveals rollover risk. If 30% of leases expire in the next 90 days, the property faces immediate renewal pressure and a real chance of vacancy spikes. Twenty-five leases expiring in the same month is a potential mass-turnover event that could hammer income if the market softens at the wrong time. Month-to-month tenancies add another layer because those tenants can leave with 30 days’ notice. Sort or filter by lease end date and you can see immediately whether expirations are spread evenly across the year or bunched into a single quarter. Buyers will run this analysis whether you present it or not.

What Lenders Check

Lenders don’t just glance at a rent roll during underwriting. They validate it. Fannie Mae requires lenders to submit rent roll data within five business days of the mortgage loan origination date, and the data must be certified as of that origination date.1Fannie Mae. Multifamily Rent Roll Template Lender Guidance HUD’s Multifamily Accelerated Processing guide requires the rent roll to be current within 30 days of the application submission date for FHA-insured loans.2U.S. Department of Housing and Urban Development. Multifamily Accelerated Processing (MAP) Guide A rent roll dated two months ago will get kicked back.

During verification, lenders compare rent roll income against the property’s bank statements. A mismatch between reported rent and what hits the account raises red flags that can delay or kill a loan. Converting the rent roll to a non-editable PDF before sharing is standard practice to prevent alterations, but keep the live Excel file so you can update and resubmit if the lender spots discrepancies.

Fannie Mae’s formatting rules trip up first-time submitters. Columns and headings cannot be moved or hidden. The file must be uploaded as .xlsx with no macros. Fields that don’t apply to a specific property should be left blank rather than filled with zeros or placeholders.1Fannie Mae. Multifamily Rent Roll Template Lender Guidance Read the submission guide before uploading.

What Buyers and Estoppels Check

During a sale, the buyer’s due diligence team will cross-reference your rent roll against the actual lease files. Any discrepancy erodes trust and gives the buyer leverage to renegotiate or walk.

Estoppel certificates add a verification layer. An estoppel certificate asks each tenant to confirm the current status of their lease, including whether rent is current, the amount of any security deposit, and whether there are any unresolved claims against the landlord.3U.S. House of Representatives. Estoppel Certificate Once a tenant signs, they are generally bound by the statements the certificate contains, so buyers and lenders can rely on those confirmations rather than taking the seller’s word.

A tenant who tells you they’re current but tells the estoppel form they’ve been promised an undocumented rent reduction is a problem you want to find before closing, not after. An accurate, current rent roll makes the estoppel process smoother because there are fewer surprises for anyone.

Keeping the Rent Roll Current

A rent roll is only useful if it reflects reality on the date someone reads it. Specific events should trigger an immediate update rather than a monthly or quarterly batch.

  • New lease execution. Add the tenant’s name, lease dates, rent amount, deposit, and any concessions the day the lease is signed.
  • Tenant move-out. Change the unit status to vacant immediately. Leaving a departed tenant on the roll overstates income and understates vacancy.
  • Rent increase. Update the contract rent amount as soon as the new rate takes effect.
  • Lease renewal or extension. Update the end date, any new rent amount, and note whether the renewal was at market or below.
  • Concession granted. If you offer free rent, a reduced rate, or waived fees, document the concession and its duration so it shows up in economic occupancy calculations.
  • Security deposit change. If a deposit is collected, increased, or partially applied to damages, update the deposit column.

Property management software automates most of this. In a spreadsheet, the rule to adopt is simple: no lease-related action happens without a corresponding rent roll edit the same day.

Retention for Tax Reporting

Rent roll data feeds directly into Schedule E (Form 1040), where property owners report income or loss from rental real estate.4Internal Revenue Service. About Schedule E (Form 1040), Supplemental Income and Loss The rent roll is the underlying documentation for the rental income figures on that form. If the IRS questions a return, a rent roll that matches your bank deposits and lease files is the cleanest way to substantiate reported income.

The IRS generally requires you to keep records supporting items on a return for three years after filing. That period extends to six years if you underreport income by more than 25% of gross income, and there is no expiration if you never file or file fraudulently. For rental property specifically, the IRS instructs taxpayers to keep records related to the property until the statute of limitations expires for the year the property is sold or disposed of, because those records are needed to calculate depreciation and gain or loss on sale.5Internal Revenue Service. How Long Should I Keep Records

In practice, keep every version of your rent roll for as long as you own the property, plus at least three years after you sell it and file the return reporting the sale. Digital storage costs almost nothing, so keeping historical rent rolls indefinitely is the safest approach and removes any risk of being caught without documentation during an audit or a dispute with a former tenant.