Sign in with your authorized email. You'll receive a one-time magic link.
·— snaps·history·sign out
Upload History
refresh×
Loading…
Portfolio Revenue Outlook
Executive Revenue Review · prepared by Hotel Revenue Solutions
Portfolio Performance Dashboard
Snapshot —✓ validated
✓
All property reports are normalised per cycle. A full ADR audit runs across all four source formats: the IDeaS StrategicAnalysis exports place ADR, Revenue and RevPAR in different columns per file, which had distorted ADR on several hotels — ADR is now located by header and cross-checked against revenue ÷ rooms-sold on every row. Occupancy is reported on-the-books; forecast occupancy is shown where the source provides it. One source caveat: any consolidated PDF Outlook Reports carry a date axis labelled 4 days early — every figure here is built from the correctly-dated XLSX exports.
Executive Summary
Portfolio Heat Map
Markets & Brands
Trends & Pace
Soft Dates & Actions 0
STR / Comp Set
Data Validation — checks & balances
✓Data validated— all figures passed a 7-point integrity audit against source reports before publication.
Key Insights — portfolio read
Key Indicators — diagnostic scorecard
Variance Analysis
On-the-Books vs Forecast
demand the forecast still expects to capture
Pace vs Last Year
net rooms ahead / behind same time last year
Recommendations — revenue strategy
Portfolio Heat Map
on-the-books occupancy by night · click any property for the full pickup detail
<30
30–45
45–60
60–75
75–90
90+
Strongest — avg occupancy in window
Softest — avg occupancy in window
Performance by Market
RevPAR index = market RevPAR vs portfolio (100 = portfolio average)
Performance by Brand Family
Rate Power Map
occupancy vs ADR · each dot is a property
Booking Curve
portfolio on-the-books occupancy by arrival date · the sawtooth is the weekend cycle
Demand by Week
how the book thins as lead time extends
Occupancy by Day of Week
Pace vs Last Year — property detail
8 properties on IDeaS with same-time-last-year data
STR Strategic Alerts
hotels losing competitive share — from STR index data
Portfolio Demand Strip
weighted occupancy & count of soft properties per night
Tactical Action Queue
prioritised soft & compression nights — next 7 days, worst first
Data Import & Refresh
Restricted to the portfolio administrator. Imports are validated before they can be exported.
Administrator passphrase required
Importing new data is limited to the portfolio administrator. Executives viewing this dashboard do not need this step.
Drop raw .xlsx report files here, or click to browse
Drop the full Monday / Thursday batch — each file is parsed and audited in your browser
Flexible file matching — the importer matches by INN code, HTID, STR ID, or hotel name found in the filename. Examples that all work: HamptonEasley_GSPEL_051826.xlsx · GSPEL - Hampton Inn Easley - 051826.xlsx · 11987 - Hampton Easley - 051826.xlsx
The filename must include MMDDYY (optionally followed by letters such as EXT) for the pull date. Ambiguous matches are flagged for review, not force-mapped.
