Point this dashboard at a different Google Sheet or tabs. The new sheet must use the same column layout, and be shared as "Anyone with the link โ Viewer".
Paste the full sheet link โ the ID is extracted automatically.
Live operational view of 44 units across the AreaYield, Auben, PMI Eagles, and Deca PM portfolios. Pulled directly from the Google Sheet โ refreshes automatically on load, and on demand via the button.
Occupancy
93.2%
41 of 44 units occupied
Monthly Rent Roll
$47,831
$573,972 annualized run-rate
Turnover Rate
11.4%
5 tenants left recently
Avg Days on Market
34.8d
From 5 recent turnovers
Vacant Units
3
Flagged "Vacant" in the rent roll
Renewals โ 60 days
5
Lease expiring within 60 days
Renewals โ 90 days
10
Lease expiring within 90 days
Lease Renewal Rate
โ%
renewed vs. not renewed
Lease status
Live from the rent roll's Status column. Focus on units that are vacant, about to be vacant, or under renewal review.
Share of tenants who renewed / stayed vs. those who left or are leaving. Live from the "Lease renewal rate" tab. Units still under review are shown as pending and excluded from the rate.
โ%
renewed รท (renewed + not renewed)
Renewals due soon
Tenants whose lease ends in the next 60 / 90 days. Reach out before expiry to lock renewals and limit turnover.
Property & Unit
Tenant
Lease Ends
Days Left
Monthly Rent
Manager
Turnover & vacancy detail
Each unit that turned over recently โ how long it sat vacant before being re-leased. Bars below show days on market.
Unit
Days on Mkt
Currently vacant
Units actively being marketed or offline. Status notes pulled from rent roll.
Financial performance โ period comparison
From the QuickBooks "Profit and Loss by Class" exports.
Pick any two periods to compare below โ a single month vs. the same month last year, or a full year-to-date roll-up.
The second row of buttons controls how uncategorized and one-time costs are treated.
compared to
compared to
Prior
Current
Change
%
R&M % of Revenue
โ%
Revenue per unit / mo
โ
Expense ratio
โ%
NOI margin
โ%
Trend across all periods
Every month loaded, in order. Add another P&L export and it simply appears here โ โ periods loaded.
Period
Revenue
Expenses
NOI
Margin
R&M %
vs. same month prior yr
What drove the change
Every expense category, prior period vs. current. Green means you spent less this year; red means more.
Expense category
Prior
Current
Change
Year over year by property
Every property's revenue, expenses, NOI, margin and R&M ratio โ current period vs. the same period last year. Click any row to see its expense breakdown. Uncategorized amounts are excluded and flagged.
Property
Revenue
ฮ Revenue
Expenses
ฮ Expenses
NOI
Margin
R&M %
Metrics requiring additional data
Collection Rate & On-Time Payment
โ
% of rent collected vs. owed and % paid on time needs payment-date / AR-aging data. Not in the rent roll (scheduled rent only) and not in a P&L. To unlock: add an A/R Aging Summary or Invoice list export alongside the P&L files.