← Back to dashboard
rent roll upload guide

What we need from your rent roll

One spreadsheet, one row per unit or tenant. Fill in what you have — the dashboard fills in the rest as you go.

1. Start from the template

It's already got the right column headers and a filled-in example row, so you can just overwrite the example and add your own rows underneath.

Go to Dashboard

2. Fill in these columns

ColumnWhat it means
Property AddressFull street address — groups rows into one property automatically.Required
UnitUnit or suite number.Optional
Tenant NameLeave blank for a vacant unit.Optional
Square FeetLeasable square footage of the unit.Optional
Monthly RentCurrent monthly rent, in dollars (numbers only, no "$").Optional
Lease StartFormat: YYYY-MM-DD (e.g. 2026-01-01).Optional
Lease EndSame date format as above.Optional
Annual Escalation %Yearly rent increase built into the lease, if any (e.g. 3 for 3%).Optional
Only Property Address is required to get a property listed. The rest fills in your occupancy %, NOI, and cap rate numbers — the more you fill in, the more the dashboard can calculate for you.

3. Upload it

From the dashboard, click Import Rent Roll and choose your file. You'll see a preview of what we read from it before anything is saved — nothing is added to your portfolio until you confirm.

Multiple properties in one file are fine — just repeat the Property Address for every row that belongs to that property, one row per unit.

Questions?

Send Christian a note directly — christian@roacre.com — or use the "Request a Feature" link in the site footer if something about this format doesn't fit how your portfolio is organized.