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.

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
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

Other resources you might be interested in
Free Landlord Rent Ledger Template
Track rent due, late fees and payments for one tenancy, with a running balance that stays current.
Rental Property Accounting Spreadsheet
Track income, expenses and mileage for every property, coded to IRS Schedule E lines as you go.
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?
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?
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?
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?
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?
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.

