How to Export Your Rent Roll
To export your rent roll report, navigate to your Payments dashboard. At the bottom of the page, you will see the option to generate and export your report. Simply click and select the format you’d like you export to be generated as a CSV.
What is a Rent Roll?
A rent roll is a snapshot report of your rental portfolio's current status. It gives you — and anyone reviewing your properties, like a lender or investor — a clear picture of occupancy, lease terms, tenant information, rent amounts, security deposits, and any outstanding balances across all of your units.
TurboTenant makes it easy to export your rent roll as a CSV, so you can share it, import it into Excel or a Google Sheet, or keep it on file.
What's Included in the Export
The rent roll breaks down your portfolio by property and unit, along with key lease details. It includes the following columns:
Property | Full property address |
Unit | Unit identifier, if applicable |
Room | Room name, if applicable |
Tenants | Current tenant name(s) on the active lease |
Lease Start | Lease start date (MM/DD/YYYY) |
Lease End | Lease end date (MM/DD/YYYY), or "Month-to-month" if there's no set end date |
Security Deposit | Security deposit amount on file |
Rent Amount | Monthly rent amount |
Total Unpaid | Total outstanding balance |
Total Past Due | Any portion of the balance that is past due |
A few things to know about how data appears:
Vacant units will show "Vacant" in the Tenants column and dashes (—) for all date and dollar fields.
Properties with units or rooms will show the “child” units and rooms. The parent property does not show up on the rent roll.
Month-to-month leases (no set end date) will display "Month-to-month" in the Lease End column.
Multiple active leases on the same listing will each appear as their own row.
The first row of the file shows the date the report was pulled, and properties are sorted alphanumerically by address.
Where Does the Data Come From?
Everything in your rent roll is pulled directly from the lease profile(s) associated with each of your units. This includes:
Tenant names: pulled from the tenants added to the active lease
Lease dates: pulled from the lease start and end dates in the lease profile
Rent amount: pulled from the rent charge(s) in the lease
Security deposit: pulled from the security deposit charge(s) in the lease
Balance due / past due: pulled from any outstanding charges associated with the lease
Note: Only active leases and vacant units are included in the export (leases with a start date in the past and either no end date or a future end date). Draft and upcoming leases are not included.
Seeing Something Unexpected?
If any data looks off in your rent roll, the best place to start is the lease profile for that unit. Here's what to check:
Tenants missing or incorrect? → Add or update tenants on the lease
Lease dates wrong? → Edit the lease start/end date in the lease profile
Rent or deposit amount incorrect? → Review and update the payment charges within the lease
Making updates in the lease profile will be reflected the next time you generate a rent roll export.