Hospitality KPI Dashboard

Monthly KPI dashboard for hotels, restaurants and cafés: occupancy or seat use, average rate, revenue per room or seat, and the change against last year.

Pick your business type, type one row per month, and the dashboard compares this year with the same months last year.

What's in the file

  • Start here — step-by-step guide and colour legend
  • Guide — How to read the numbers. Plain explanations of every number, how to read the result and the mistakes to avoid.
  • Settings — Your business in five answers. You fill in: Business type, Year, Currency, Rooms (hotel) or seats (restaurant, café), Target use of capacity.
  • Monthly data — Type one row per month. You fill in: Month, Open days, Revenue, =IF({settings.btype}="Hotel","Room nights sold","Guests served"), Revenue last year, =IF({settings.btype}="Hotel","Room nights sold","Guests served")&" · Last year".
  • Dashboard — This year against last year. Shows: Revenue so far, Same months last year, Change vs last year, =IF({settings.btype}="Hotel","Occupancy","Seat use"), =IF({settings.btype}="Hotel","ADR (average daily rate)","Average spend per guest"), =IF({settings.btype}="Hotel","RevPAR (revenue per available room)","Revenue per seat per day"), a chart.
  • Summary — What the numbers say. Shows: Revenue so far, Same months last year, Change vs last year, =IF({settings.btype}="Hotel","Occupancy","Seat use"), =IF({settings.btype}="Hotel","ADR (average daily rate)","Average spend per guest"), Best month for revenue, Months below your target use of capacity, Months below last year, Months filled in.
  • Action plan — What you will change next. Write what you will change, why, who owns it and by when; status shows in colour.
  • Checklist — Monthly KPI routine. 8 steps to tick off, with a progress bar.

How to use it

  1. Open Settings: choose Hotel, Restaurant or Café, then type the year, currency and number of rooms or seats.
  2. In Monthly data, type open days, revenue and room nights sold (hotel) or guests served (restaurant, café).
  3. Add last year's revenue and units so the file can compare.
  4. Leave future months empty: the totals only compare months you have filled in.

What it does

  • Hotel, restaurant or café: labels switch with one drop-down
  • Occupancy, ADR and RevPAR for hotels; seat use, average spend and revenue per seat for restaurants and cafés
  • Compares only the months you have filled in
  • Revenue chart: this year against last year
  • Two files in each language: a blank Template to fill in, and an Example filled with sample data
  • Available in several languages; Arabic files are laid out right-to-left
  • Formulas only, no macros or add-ins
  • Instant download after purchase

Included Files

  • A file in the language you choose
  • Arabic files laid out right-to-left
  • Step-by-step guide
  • Free updates for this version

Works With

  • Microsoft Excel
  • Excel for Mac

Support

Questions about setup? Send us a message from your account page and we reply by email.

Hospitality KPI Dashboard

The video tutorial for this template is coming soon.

No reviews yet. Reviews appear here after customers rate the template.

Write a review
Your rating
FAQ
  • Which language is the file in?

    You get the file in the language you pick at the top of the site. If a template is not available in that language yet, you get the English file. Arabic files are laid out right-to-left.

  • Do I need macros or add-ins?

    No. The templates use formulas and built-in charts only.

  • Can I change the template?

    Yes. Rename columns, add rows, change colours and add your logo.

  • How do I get the files after paying?

    The download link appears on the order page and in your account right after payment.

Personal License

For you, on your own projects and your own company reports.

Team License

Share the files with up to 10 people in your company.

$35.00

$45.00

Free

File language: English

Add To Cart
Mia Ready
39 templates in the shop
View All Templates
  • Last updateNov 17, 2026
  • PublishedNov 15, 2026
  • CategoryHospitality
  • File format.xlsx
  • LanguagesEnglish
  • LayoutLeft-to-right; Arabic right-to-left
  • MacrosNone
  • Works WithMicrosoft Excel, Excel for Mac
  • Tags Excel, Hospitality
Like this template?

Found it useful? Recommend it to other marketers and earn 30% of every sale you bring in.

Become an affiliate