Rent roll template
Commercial and multifamily, with what every column is for. Free CSV, no signup.
Turns on lease terms. A buyer reads this to find rollover risk and whether the recoveries are real.
Opens in Excel, Google Sheets or Numbers. No signup, no email.
What each column is for
- Suite
- Unit or suite identifier
- Tenant
- Legal entity, not the trade name
- SF
- Rentable square feet
- Lease Start
- Commencement, not signature date
- Lease End
- Expiry — this column is the rollover schedule
- Base Rent (Monthly)
- Current contract rent
- Rent PSF (Annual)
- Base rent x 12 / SF — how the market compares it
- Recovery Type
- NNN, MG, FSG. Changes what NOI means
- Escalation
- Fixed %, CPI, or stepped
- Options
- Renewal and termination rights, with notice windows
- Security Deposit
- Cash or LOC
- Notes
- Free rent, TI outstanding, holdover, anything unusual
Common questions
- What should a rent roll include?
- For commercial: suite, tenant, square footage, lease start and end, base rent, rent per square foot, recovery structure, escalations, options, deposit and notes. For multifamily: unit, unit type, square footage, status, lease dates, market rent, actual rent, other income and deposit. The two are different documents and a template that merges them is wrong for both.
- What is the difference between a commercial and multifamily rent roll?
- A commercial rent roll turns on lease terms — recovery structure, escalations, options and expiry — because those determine what the income is worth and when it is at risk. A multifamily rent roll turns on unit mix and the gap between market and actual rent, because that gap is the value-add thesis.
- What is loss to lease?
- The difference between what units would rent for today at market and what current tenants actually pay. On a multifamily rent roll it is the single most examined number, because it is the income a buyer expects to capture as leases roll.
- Why does recovery type matter on a rent roll?
- Because it changes what the rent means. Under NNN the tenant reimburses taxes, insurance and common area maintenance, so base rent is close to net income. Under a full service gross lease the landlord absorbs those costs out of the same rent. Comparing an NNN rent to a gross rent without adjusting is one of the more expensive mistakes in commercial underwriting.
- Should vacant units appear on a rent roll?
- Yes, always. A rent roll that only lists occupied space overstates the property and will be caught immediately. Show vacant units with the asking rent so the reader can see both in-place income and the upside.
The rest of the analyst’s job
The arithmetic is the easy part. Everre does the offering memoranda, the broker opinions of value, the lease abstracts and the rent rolls — the work that usually costs you an analyst. The CRM is free and there are no per-seat fees.
Try it free