Which owner relationships are worth keeping. Which to fire. Multi-owner consolidated reporting for STR property managers running 10+ properties across multiple owners. Per-owner $/hour profitability + relationship ranking + fire-vs-keep recommendations. Excel + Google Sheets. You manage 12 properties for 5 owners. One owner is a dream — high revenue, low communication burden. One is a nightmare — constant emails, 10% of your time for 3% of your revenue. The other three are somewhere in between. Without consolidated data, you can’t tell which relationships are worth keeping vs firing. This workbook is the Pro Pam dashboard: per-owner total managed revenue, total commission earned, time allocated per owner, profitability per owner relationship, and a ranked fire-vs-keep recommendation list. WHAT’S INCLUDED 📋 Owner Roster + properties + commission model + relationship start date 📋 Time Allocation Tab (hours per owner per month — admin / comms / issues / distributions) 📋 Per-Owner Revenue + Commission (pulls from PAM-001 if owned) 📋 Per-Owner $/Hour Effective Rate 📋 Owner-Relationship Ranking (sorted by profitability) 📋 Fire-vs-Keep Recommendations (bottom-quartile flagged) 📋 Trend View — is this owner getting more profitable or less?
Related
- Multi-Entity Consolidated P&L
- Cleaner CRM + Payroll
- 3-Property Side-by-Side Comparison
- STR vs LTR Yield Comparison
- Commission / Split Calculator for Co-Hosts
Get the workbook
Format: Excel .xlsx + how-to PDF. Excel 2016+, Excel 365, Google Sheets compatible. Instant download after checkout. 14-day refund, no questions. Lifetime updates within v1.