Rent Roll Template for Landlords

Track every unit, tenant, lease and rent balance in one place. Use Excel for automatic totals and lease alerts, print the fillable PDF, or download the CSV to import into other tools.

Illustration of two yellow houses with a tree between them

Download the Free Rent Roll

‍

A rent roll is a portfolio snapshot: every unit, who lives there, what they pay and what they owe, on one sheet. Update it each month and the Excel version works out balances, leases ending soon and how full your portfolio is. Lenders and buyers ask for one when you refinance or sell, so it pays to keep it current.

‍

With this free template, you'll be able to:

‍

  • List every unit, tenant, lease date, rent and deposit in one sheet
  • See balances due and leases ending within 60 days at a glance (Excel)
  • Get occupancy, vacancy loss and gross potential rent worked out automatically (Excel)
  • Open it in Excel or Google Sheets, print the fillable PDF, or download the CSV to import into other tools

‍

Want to see it filled in? Download the example CSV (6 fictional units).

‍‍

This template is general information, not financial or legal advice. Check your figures before sharing them with a lender or buyer.

‍

Produced by Landlord Studio

Cover of Landlord Studio's Rent Roll template for landlords in the United States
Download the Excel Template

Other resources you might be interested in

Landlord Studio icon

Free Landlord Rent Ledger Template

Track rent due, late fees and payments for one tenancy, with a running balance that stays current.

Landlord Studio icon

Rental Property Accounting Spreadsheet

Track income, expenses and mileage for every property, coded to IRS Schedule E lines as you go.

Landlord Studio icon

Rent Increase Notice Template

Set the new rent and effective date, with guidance on state notice periods and rent caps.

FAQs

Which version of the rent roll template should I download?

Plus Icon

Use the Excel file if you want balances, lease alerts and totals worked out for you. Use the fillable PDF to print or send a clean copy. Use the CSV to move your data into other software.

Can I use the rent roll template in Google Sheets?

Plus Icon

Yes. Upload the Excel file to Google Drive and open it in Google Sheets. It also opens in Apple Numbers.

How often should I update my rent roll?

Plus Icon

At least once a month, after rent is due, and whenever a tenant moves in or out. Keep it current before you refinance or sell: a lender may ask for a signed or certified copy, along with supporting records such as leases or evidence of rent deposits.

What's the difference between gross potential rent and scheduled rent?

Plus Icon

In this template, gross potential rent is what every unit would earn at today's market rent. Scheduled rent is the monthly base rent your current leases charge on occupied units. The gap is your vacancy loss plus any loss to lease, less any gain where a lease is above market. Lenders may use their own definitions.

What is a rent roll used for?

Plus Icon

Landlords use it to track income and spot problems early. Lenders and buyers use it to check a property's income. For a fuller explanation, read what is a rent roll.