What's inside
5 sheets. Everything your revenue
reporting needs.
reporting needs.
Built for hotel owners and GMs who want a clear weekly picture without hiring a revenue analyst or paying for BI software.
Start Here — instructions
Colour-coded guide explaining what to enter, where, and how the sheets connect. Takes 2 minutes to read.
Monthly Input
Your data entry sheet. Enter room nights, revenue, channel breakdown, and OTA commissions for each month. All other sheets update automatically.
KPI Dashboard
Calculates all 12 key metrics automatically — occupancy, ADR, RevPAR, TRevPAR, direct share, OTA share, commission cost, and comp set index.
Budget vs Actual
Enter your annual targets once. The sheet compares actual performance against budget for every KPI — with red/green conditional formatting for at-a-glance status.
Trend Charts
Four 12-month charts — RevPAR, occupancy, OTA share, and commission cost — built automatically from your monthly inputs. No manual chart updates needed.
Metrics tracked
Every KPI that matters.
Occupancy rate
ADR
RevPAR
TRevPAR
Total room revenue
F&B revenue
Direct booking share
OTA share
Booking.com nights
Expedia nights
Airbnb nights
Total OTA commission
Commission % of revenue
ADR Index vs comp set
RevPAR Index (RGI)
Budget vs actual variance
Want this done for you?
RevenueLabs manages revenue performance for hotels across Europe — including weekly reporting, OTA strategy, and channel mix optimisation. First audit is always free.
Free tool by RevenueLabs · EXPODITION GROUP Ltd · © 2025–2026
This template is free for hotel owners and managers. No email required. Works with Microsoft Excel 2016+ and Google Sheets.
This template is free for hotel owners and managers. No email required. Works with Microsoft Excel 2016+ and Google Sheets.