Building a portfolio dashboard you will actually check

By Austin Zehnder, San Francisco finance and real estate professional, founder of Zehndra.

At Mynd, I built dashboards for portfolio analysis across a multi state portfolio. And I learned something pretty quickly: the dashboards people actually use are the short ones. Most dashboards fail the same way. Too many charts, too many metrics, updated too rarely to trust. A dashboard you check weekly beats a perfect dashboard you check never. My rule is simple: one page, five numbers, updated on a schedule you can actually keep.

The five numbers

Occupancy and vacancy. Empty units are the fastest leak. Track it by property and in total.
Collected rent vs. expected rent. Billed rent is not collected rent. The gap is where problems hide.
Cash flow after everything. Rent minus taxes, insurance, maintenance and capex reserves, vacancy, and debt service. It is the same "after everything" discipline as underwriting a rental deal.
Cash-on-cash return. Annual cash flow divided by cash invested. It answers the only question that really matters for a hold: what is this money doing for me?
One forward looking number. Leases expiring in the next 90 days, or a major repair due this quarter. A dashboard that only looks backward is a report, not a tool.

What to leave out

Leave out vanity metrics, daily price noise, and any chart nobody has acted on in a month. If a number never changes a decision, it is decoration. Delete it, and the dashboard gets more trustworthy, not less. That feels wrong the first time you do it. It feels great the second time.

Build it in a spreadsheet first, not in software. A spreadsheet you understand beats a platform you fight, and it forces you to define every number yourself. That is the philosophy behind Zehndra by Austin Zehnder: templates I actually use, including the Rental Deal Analyzer with a 10 year projection. Also read: What a mortgage rate does to a monthly payment.