Rent Roll Dashboard

About this template

The Rent Roll Dashboard gives property managers a comprehensive, real-time view of their rental portfolio. Built for teams managing 50 to 5,000+ units, it consolidates rent roll data into clear visuals that surface the metrics that matter most. **What you get:** - **Occupancy tracker** — unit-level vacancy status with trend lines and portfolio-wide occupancy rate - **Lease expiration timeline** — visual calendar showing upcoming expirations by month, flagging units expiring within 30/60/90 days - **Rental income summary** — gross potential rent vs. actual collected rent, loss-to-lease analysis, and month-over-month revenue trends - **Unit mix breakdown** — rent distribution by unit type, floor plan, and building - **Delinquency snapshot** — outstanding balances by tenant with aging buckets (0-30, 31-60, 61-90, 90+ days) **How it works:** Export your rent roll as a CSV from your property management software (AppFolio, Buildium, Yardi, or any system with CSV export). Open the template in Power BI Desktop, point it at your CSV, and your dashboard is ready in under 5 minutes. The template includes pre-built column mappings for AppFolio rent roll exports. For other platforms, a simple column-mapping guide is included in the documentation.