Free Rent Roll Template (Excel)
A clean, lender-ready rent roll layout: one row per unit, self-computing totals, ISO dates, and a proper occupancy column. No email gate — just download it.
Free · no signup · works in Excel, Google Sheets, and LibreOffice
What's in the template
| Column | Why it matters |
|---|---|
| Unit | Unique identifier — duplicates are the #1 rent roll error |
| Tenant Name | Blank = vacant; used to cross-check occupancy |
| Unit Type | Retail / office / 2BR etc., for mix analysis |
| Square Feet | Sums into total SF for $/SF metrics |
| Lease Start / End | ISO dates; end must follow start |
| Monthly Rent | Sums into gross scheduled rent |
| Market Rent | Loss-to-lease calculation |
| Security Deposit | Liability schedule at closing |
| Occupancy Status | Occupied / Vacant / Model / Down / NoticeGiven |
The TOTAL row computes itself with formulas, and an occupied-unit counter is included — so the sheet reconciles the same way a lender will reconcile it.
Rent roll best practices
- One row per unit, always. Stacked charge codes and merged cells are why rent rolls are painful to analyze.
- Keep subtotals out of the data. Mixed-in subtotal rows silently double-count in SUM formulas.
- Date the document. A rent roll without an as-of date can't be trusted in underwriting.
- Reconcile stated totals. If the bottom-line rent doesn't equal the sum of the units, something's wrong — that's the first thing a reviewer checks.
Going the other direction? If you already have a rent roll as a PDF or a messy Yardi / RealPage / AppFolio export, convert it to this clean format automatically — with the totals reconciliation done for you on every document. Free, 3 documents/day, no signup.