The 30-second pitch
You raised your nightly rate 15% last year. Revenue is up. You feel good. But occupancy dropped 22% — and your RevPAR is actually down 6%. You’re working harder, taking on the same costs, and netting less.
RevPAR is the number that catches this. This dashboard surfaces it next to ADR and Occupancy with a sensitivity simulator that shows you what happens before you change pricing — not after.
Who it’s for
- Hosts running 1–8 properties who haven’t been calculating RevPAR explicitly
- Anyone with a dynamic pricing tool who can’t tell whether it’s winning
- Operators comparing to AirDNA market data and wanting an apples-to-apples gap analysis
Math that earns the price
Spotting a 6% RevPAR underperformance on a property doing $50,000/year = $3,000 of recoverable revenue. Workbook costs $27. Pays for itself the first month you act on what the dashboard surfaces.
Related
- Break-even Occupancy Calculator
- Competitor Rate Tracker
- Dynamic Pricing Calculator
- Year-Over-Year P&L Comparison
- The Deal Analyzer
What's inside
- Bookings Log — date, channel, gross, cleaning, nights, occupancy flag. 1,000-row capacity per property.
- RevPAR Dashboard — monthly RevPAR + ADR + Occupancy with 12-month rolling trend and YoY delta. Conditional formatting on the deltas.
- AirDNA Comp Block — paste your AirDNA market RevPAR; see your gap (above/below market, % delta). Color-coded.
- Sensitivity Simulator — what happens to RevPAR if you (a) raise ADR 10%, (b) drop occupancy 5%, (c) add 30 days of off-season inventory. See revenue impact instantly.
- Channel-mix view — Airbnb vs VRBO vs Booking.com vs Direct revenue share. RevPAR by channel. Net-of-fees recalc.
- Pricing-strategy block — when to raise ADR, when to drop occupancy, when to extend min-stay. Heuristics, not generic 'consult PriceLabs' advice.
- Settings — property + season definitions, AirDNA market input, currency.
FAQ
- What's RevPAR and why does it matter?
- Revenue per Available Night. ADR × Occupancy. It's the one number that catches the bug where you raised price but dropped bookings net-negative. Big-hotel-industry standard; STR adopting fast.
- Excel or Google Sheets?
- Both. Dashboard charts, conditional formatting, and the sensitivity simulator work natively in either.
- Does it integrate with AirDNA?
- It accepts AirDNA market RevPAR as a paste-in input (export from your AirDNA subscription, paste into Settings). No live API integration.
- Multiple properties?
- Yes. Per-property sheets feed a portfolio RevPAR view. Up to 8 properties before performance degrades.
- How is this different from PriceLabs / Wheelhouse?
- Those are dynamic-pricing engines that set nightly rates. This is the dashboard that tells you whether the dynamic-pricing engine is actually doing the right thing — or quietly underperforming the market.
- What's your refund policy?
- 14 days, no questions. Email hello@thestrledger.com.
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.