RevPAR Dashboard – STR Revenue Tracker (Excel, Google Sheets)

The one metric that catches what ADR and occupancy hide. RevPAR dashboard for Airbnb and STR hosts. Tracks revenue per available night so a "great" ADR with empty calendar days stops fooling you. Editable Excel.

Your ADR looks strong — $260 a night. Your occupancy looks fine — 68%. So why is the bank account flat? Because neither number alone tells you what the property actually earns per night it sits available. RevPAR does. It is ADR and occupancy multiplied into a single honest number, and it is how every hotel revenue manager on earth measures a property.

This dashboard turns 12 months of bookings into your RevPAR, month by month, and shows whether the trend is climbing or quietly sliding.

═══════════════════════════════════════════
WHAT'S INCLUDED
═══════════════════════════════════════════

Excel workbook (3 tabs):

- Dashboard — the answer lives here. Trailing-12-month RevPAR, ADR, and occupancy with a climbing/flat/declining trend gauge color-coded red / parchment / gold
- Monthly Input — drop in nights booked, nights available, and revenue per month; the workbook computes RevPAR for each month automatically
- Benchmark — compare your RevPAR against your own prior year and against a market figure you enter, so you can see if you are gaining or losing ground

RevPAR is calculated the way a revenue manager calculates it: total room revenue divided by available nights — not divided by booked nights. Most host spreadsheets quietly use booked nights, which inflates the number and hides empty inventory. This one does not.

═══════════════════════════════════════════
WHY IT PAYS FOR ITSELF
═══════════════════════════════════════════

A host with a $260 ADR at 68% occupancy has a RevPAR of about $177. A host with a $215 ADR at 88% occupancy has a RevPAR of about $189 — and earns more, with less wear, fewer turnovers, and lower cleaning spend. Without RevPAR you would have chased the wrong number. The dashboard makes that comparison in one cell.

═══════════════════════════════════════════
WHO IT'S FOR
═══════════════════════════════════════════

- Airbnb and VRBO hosts who want one performance number instead of ten
- Hosts deciding whether to raise rates or raise occupancy
- Hosts testing a dynamic-pricing change and wanting proof it worked
- Anyone who has a strong ADR and a weak bank balance and cannot explain the gap

═══════════════════════════════════════════
HOW IT WORKS
═══════════════════════════════════════════

1. Purchase → instant download
2. Open Monthly Input. Enter nights available, nights booked, and revenue for each month
3. Read the Dashboard — RevPAR, ADR, occupancy, and the trend gauge
4. Open Benchmark. Enter last year's figures and a market RevPAR to see if you are ahead or behind

═══════════════════════════════════════════
FAQ
═══════════════════════════════════════════

Does it use booked nights or available nights?
Available nights — the correct denominator. The workbook says so on the Dashboard tab. This is the integrity differentiator vs templates that inflate RevPAR.

Can I use it for multiple properties?
One property per workbook. For portfolio-level reporting, use the Multi-Property Master P&L at thestrledger.com.

What if I block dates for personal use?
Those count as unavailable, not vacant. There is an input cell for owner-blocked nights so your RevPAR is not punished for time you took off the market.

═══════════════════════════════════════════
GUARANTEE
═══════════════════════════════════════════

14-day refund, no questions asked. If the file doesn't work on your setup, email hello [!at] thestrledger.com — real humans, fast replies.

Not financial or tax advice. Consult your CPA for your specific situation.

═══════════════════════════════════════════
UPGRADE PATH
═══════════════════════════════════════════

Want the full money picture? Get the Single-Property P&L Tracker (TAX-002) at thestrledger.com — Schedule E-ready.

This is a digital product. No physical item will be shipped.