Commercial rent roll: what goes in it, how to build one, and a free Excel template
A rent roll is one table that lists every tenant in a building with their space, rent and lease dates. Buyers, lenders, appraisers and your own accountant all ask for one. This page explains what goes in a commercial rent roll, how to build it from the leases so it holds up, and the mistakes that most often make one wrong. A free Excel template is below.
What goes in a commercial rent roll
A useful commercial rent roll has one row per lease and at least these columns:
- Suite or unit
- Tenant, using the legal name on the lease
- Leased square feet
- Lease start and lease end
- Current monthly base rent and annual base rent
- Annual rent per square foot
- Next rent step: the date and the new rent
- Renewal options, and the deadline to give notice
- Who pays property tax and insurance: tenant direct, reimbursed to you, or you
- Security deposit
- Source: the document and page each figure comes from
At the top: the property name, the date the rent roll is "as of", and the building's total rentable square feet. At the bottom: totals, and occupancy (leased square feet divided by rentable square feet).
Many rent rolls also show reimbursements for shared costs (CAM), percentage rent and arrears. Those come from billing records more than from the lease, so keep them in a separate column or a separate table.
How to build a rent roll from the leases
- Gather every lease document for each tenant. That means the lease, every amendment, renewal and extension letters, commencement-date letters, and any assignment. A rent roll built from the original lease alone is often out of date.
- Put the documents in date order. The latest signed amendment usually wins on rent, area and dates. Read each one for what it changed.
- Find the rent schedule. Many leases set rent steps in a table: a fixed amount per period, a percentage each year, or a CPI formula. Find which step is in effect on your "as of" date.
- Check the square feet. An amendment may re-measure the space. Use the area the latest document states.
- Write down the next step. The date and the new monthly rent.
- Find the renewal options and the notice deadline. Notice is usually a set number of days or months before the lease ends. Work out the date and write it down.
- Note who pays tax and insurance. The lease says whether the tenant pays directly, reimburses you, or neither.
- Cite the page. Write down where the rent, area and dates came from: which document, which page. If a number is ever questioned, you can show where it came from in seconds.
Common mistakes
- Using the original lease when an amendment changed the rent. The most common error.
- Missing a rent step that already took effect. If rent stepped up last month, the rent roll and the tenant's automatic payment may both still show the old figure.
- Square feet that no longer match. An amendment re-measured the space but the rent roll still shows the old area, so rent per square foot is wrong.
- Missed option deadlines. A renewal notice date is easy to lose because it sits months before the lease end.
- Month-to-month tenants given a made-up end date. Leave the end date blank and say month-to-month.
- Annual rent typed in by hand. Use a formula, monthly rent times 12, unless the lease states its own annual figure.
- No source. A rent roll nobody can check is a rent roll nobody fully trusts.
Free commercial rent roll template (Excel)
Download the free commercial rent roll template (Excel)
The workbook has two tabs.
How to Use explains how to fill in the sheet.
Rent Roll is the sheet itself.
- At the top, three inputs: property name, as-of date, and building rentable square feet.
- One row per lease, with these columns: Suite · Tenant · Lease documents (original + amendments) · Leased sq ft · Lease start · Lease end · Monthly base rent now · Annual base rent · Annual rent per sq ft · Next rent step date · Next monthly rent · Renewal option (yes/no + terms) · Option notice deadline · Who pays tax · Who pays insurance · Security deposit · Source (document and page) · Notes.
- Formulas fill in annual base rent and annual rent per square foot for you.
- A totals row adds up leased square feet, monthly base rent and annual base rent, and works out occupancy as leased square feet divided by the building's rentable square feet.
- Two example rows show how a filled row looks. They are marked "Example — replace". Type over them or delete them.
The template is a blank form. It does not read your leases for you.
How REOI totals rent from the leases
REOI reads your leases and their amendments and builds the rent figures from them. In the sample portfolio, this shows up in three places.
Each tenant's window (Tenants tab). Opening a tenant shows the current base rent, the next rent change, the lease term and the renewal options. A base rent table lists each rent period with its monthly and annual rent, rent per square foot, the step, and a "Set by" column that names the clause behind it, for example "4th Amendment §9 rent table". Those names are links. In the sample, clicking one opened the amendment itself, a PDF, in a new browser tab. Key figures carry a "Show the source of this figure" link. The window also flags things worth checking, such as a rent step that took effect while an automatic payment may still be set at the old amount.
The Rent Roll worksheet (Reports tab). One row per tenancy with square feet, monthly rent, annual rent, lease structure, term start and end, days to term end, options, the option or renewal deadline, and the next rent step and its monthly amount. The sample worksheet totals $100,727.10 a month and $1,208,725.27 a year of documented rent across its tenancies. The worksheet states its own rules: annual rent is "the stated monthly rent × 12", shown as a live formula; where a lease states its own annual figure and it differs by rounding, the lease's figure is used; a month-to-month tenancy "states no end date and is left blank rather than assigned one." You can type over a white cell to test a change, and nothing is saved. The worksheet also has a Download .xlsx button.
The portfolio screen. A "Where the rent is" panel ranks the tenancies by documented rent, and a lease expiration chart shows rent rolling off by year.
What the sample rent roll does not show: security deposits, who pays tax and insurance, or a source column. In the sample, who pays what and the source links are in each tenant's window, not in the worksheet.
The written report, the Excel workbook (which includes the Rent Roll worksheet) and the briefing are part of the paid Owner plan. The free plan shows findings on screen.
REOI is an analytical service. It does not give legal, tax, accounting or investment advice. Always confirm a figure against the lease itself and act with your own advisors.
What the free plan includes
From the REOI pricing page (all prices in US dollars):
- Price: $0, to try REOI on one commercial property
- Intelligence: Standard
- What you get: findings on screen and deadline reminders
- Support: Help and FAQ pages
- Tenants: one tenant
- Documents read at set-up: 15
- New documents a year: 5
- Updates a year: 2
The full written report, the Excel workbook and the briefing are part of the paid Owner plan, not the free plan.
See it, then try it
Frequently asked questions
What is a commercial rent roll?
A commercial rent roll is a table of every lease in a building, showing each tenant's space, current rent, lease dates and key terms. Buyers, lenders and appraisers use it to see the income the leases support. It should be built from the signed leases and their amendments.
How do I create a rent roll?
List every tenant, then read each lease with all its amendments in date order. Take the current rent, area, dates, next rent step and renewal terms from the latest signed document. Write the document and page beside each number, then total the rent and work out occupancy.
What is the most common rent roll mistake?
Using the rent from the original lease after an amendment changed it. A close second is missing a rent step that already took effect. Both are fixed by reading every amendment and checking which rent period you are in.
Is the rent roll template free?
Yes. The Excel template on this page is free to download and use. It is a blank form with formulas for annual rent, rent per square foot, totals and occupancy.
How does REOI build a rent roll?
In the sample portfolio, REOI takes rent from the leases and amendments and shows each period with the clause that sets it, linked to the document. Its Rent Roll worksheet computes annual rent as monthly rent times 12 and leaves month-to-month end dates blank. The worksheet is part of the Excel workbook on the paid Owner plan.
Is a rent roll the same as net operating income?
No. A rent roll shows rent the leases call for. Net operating income also takes off operating expenses, which come from your books, not the leases. Check any figure against your documents and act with your own advisors; this page is not accounting or investment advice.