Hotel KPI Dashboard Template

Start by setting up the Goals & Benchmarks sheet with your property's annual targets — total revenue, ADR goal, occupancy rate target, RevPAR, and GOP%. If you have last year's actuals, use those as a baseline and adjust for any rate increases or occupancy improvements you're planning. Then move to the Monthly Input sheet and enter your numbers for the most recent completed month. You'll need your property management system (PMS) occupancy and revenue reports and your departmental expense summaries. The entry process takes about 15 minutes once you know where to pull the numbers.

Each month, return to the Monthly Input sheet and add your new data. The KPI Dashboard, Revenue by Department, and Goals & Benchmarks sheets all update automatically. The Competitive Set Tracker is worth updating at the same time — enter your comp set's ADR, occupancy, and RevPAR from your STR or benchmarking report, and the sheet calculates your market indices. General managers who review their RGI monthly catch pricing and channel mix problems earlier than those who rely on end-of-quarter reports.

Once you have 3–4 months of data, the dashboard reveals patterns that individual PMS reports don't show clearly. You'll see whether ADR growth is outpacing occupancy or whether you're filling rooms by discounting. You'll see which departments are contributing growing shares of revenue and which are contracting. Use the Goals & Benchmarks sheet in monthly ownership calls to show progress, and use the trend charts to explain to stakeholders why RevPAR moved the way it did — not just what happened, but whether it was a rate or occupancy story.

Hotel performance management comes down to three numbers that interact with each other constantly: ADR, occupancy, and RevPAR. RevPAR (revenue per available room) is the product of the other two — a $150 ADR at 70% occupancy produces the same RevPAR as a $105 ADR at 100% occupancy, but the profitability is very different. Full houses at discounted rates fill the building but exhaust staff, strain facilities, and often produce worse GOP% than a partially occupied property at strong rates. Understanding whether your RevPAR movement is driven by ADR or occupancy is the difference between managing a hotel and just reacting to one.

Beyond RevPAR, GOP% is the metric ownership cares about most. Gross operating profit percentage measures how much of total revenue flows through to operating profit after all departmental and undistributed expenses — but before fixed charges like debt service and management fees. For full-service hotels, a healthy GOP% typically falls between 30–45% depending on market, segment, and labor costs. For select-service properties with leaner F&B operations, 40–55% is achievable. Tracking GOP% monthly alongside RevPAR tells you whether your top-line performance is actually reaching the bottom line, or whether cost increases are eroding the gains.

The most effective hotel KPI reviews look backward and forward at the same time. Backward: compare this month's ADR, occupancy, and RevPAR to the same period last year and to your comp set — this tells you whether you're growing share or losing it. Forward: look at your pace and pickup data to see whether next month's bookings are tracking ahead or behind. This template handles the backward-looking side — tracking trends, measuring performance against targets, and benchmarking against your competitive set. Operators who build this review into a monthly management meeting find it changes the quality of their pricing and staffing decisions for the months ahead.