Hospitality & Resorts Dashboard in Google Sheets

A resort group’s PMS will tell you last month’s revenue. What it rarely tells you, on one screen, is which property earns most per room night rather than in total, what an OTA booking is really worth against a direct one, and how much of the year walks away as no-shows. The Hospitality & Resorts Dashboard in Google Sheets is built for exactly those questions: 6 pages, 16 KPI cards, 16 charts, 4 named slicers per page and a reservation lookup, all running on native Google Sheets pivot tables and slicers rather than a wall of formulas. The sample file carries 500 reservations across 8 resorts, 9 room types, 8 packages and 10 booking channels, and everything is pre-wired for 1,000 rows. Built by PK, a Microsoft Certified Professional with 15+ years in spreadsheets and 300K+ subscribers across two YouTube channels. Your download is a PDF with a Make a copy link: one click and an editable copy is in your own Google Drive, with no add-on and no monthly fee.Hospitality

Key Features of the Hospitality & Resorts Dashboard in Google Sheets

• Pivot-and-slicer architecture. Every chart reads a native pivot table parked to the right of its page. No hidden helper formulas sit behind the visuals, which is what keeps the file quick as the reservation history grows.
• Named slicers on every analysis page. Month, Resort, Room Type and Status on Overview; Resort, Package, Month and Loyalty Tier on Properties; Package, Room Type, Booking Channel and Guest Type on Bookings; Loyalty Tier, Guest Type, Payment Method and Month on Guests. Click one and all four charts, the pivots and the sidebar move together.
• Sixteen KPI cards. Four per page, matched to the question that page answers – total revenue and average booking value on Overview, room nights and average guests per stay on Properties, package revenue and largest booking on Bookings, unique guests and no-show rate on Guests.Hospitality
• A full sidebar on every page. A three-stat snapshot, a 12-month revenue sparkline, a Top 5 ranking, a share-of-revenue bar list, a six-row At a Glance panel and a 12-month reservation volume sparkline.
• Property comparison built in. All eight resorts ranked on revenue, guests, package mix and share of portfolio revenue, so a property carrying more than its size suggests is visible immediately.Hospitality
• Booking channel economics. Revenue by Booking Channel ranks all ten routes – direct website, mobile app, loyalty app, travel agent, phone, corporate portal, group sales, front desk, email and walk-in – which is the analysis that drives commission decisions.Hospitality
• Package and room type performance. Revenue by Package and Room Type Revenue vs Reservations, so you can see which packages earn per booking rather than just filling rooms.
• Loyalty tier analysis. Revenue and reservation counts across Bronze, Silver, Gold, Platinum, Member and Corporate, with tier revenue share on the sidebar.
• Reservation status mix. Checked-out, Confirmed, In-house and No-show tracked as shares, so a rising no-show rate is a number rather than a feeling.
• Reservation lookup page. Pick any Reservation ID and read the full record: check-in date, resort, room type, package, guest name, loyalty tier, revenue, guests, nights, booking channel, payment method, status, guest type, month and quarter.

What’s Inside the Hospitality & Resorts Dashboard

Six pages, linked by a navigation bar across the top of each.

1. Overview – portfolio-wide performance. Total Revenue, Total Reservations, Total Guests and Avg Booking Value across all resorts and channels, with Monthly Revenue Trend, Revenue by Room Type, Revenue by Loyalty Tier and Resort Revenue vs Reservations. The sidebar adds check-out rate, average party size, room nights and the top five resorts by revenue.

2. Properties – revenue, occupancy and package mix by resort. Completed Stays, Room Nights, the selected resort’s revenue and Avg Guests per Stay, with Revenue vs Guests, Revenue by Resort & Package, Monthly Guest Volume and Reservations by Status. The sidebar carries average length of stay, revenue per night and no-show rate, plus each property’s share of portfolio revenue.

3. Bookings – package, room type and channel performance. All Inclusive Revenue, Honeymoon Stays, Spa Retreat Revenue and Largest Booking, with Revenue by Package, Room Type Revenue vs Reservations, Revenue by Booking Channel and Guests by Guest Type. The sidebar adds revenue per guest, average party size, packages offered and the top five channels by revenue.

4. Guests – loyalty tiers, guest types and payment behaviour. Platinum Revenue, Family Stays, Unique Guests and No-Show Rate, with Reservations by Loyalty Tier, Guest Type Revenue vs Guests, Revenue by Payment Method and Monthly Reservation Volume.

5. Search – reservation lookup. Choose a Reservation ID and the page returns that booking’s full record in one clean table – the fastest way to settle a query about a single stay without scrolling the data sheet.

6. Instructions – a ten-point user guide. How the pivots and slicers are wired, why the KPI cards deliberately show unfiltered totals while the charts are slicer-aware, how to replace the sample data, and how to raise the row limit past 1,000 in the Apps Script file.

Behind those sits the Data sheet, one row per reservation with the columns the pivots expect. Replace the sample rows with your own PMS export, keep the headers, and every page follows.

Hospitality & Resorts Dashboard vs. an Excel Report vs. PMS Analytics – Where This Fits

The honest position: a PMS knows tonight’s availability and this sheet does not – it reports rather than operates. It earns its place when properties sit on different systems, when an owner wants a single portfolio view, or when you want measures the PMS does not calculate, such as revenue per guest by channel or package revenue share across the group.

Who This Template Is For – and Who It’s Not For

A good fit if you are: a resort or hotel group with two or more properties; a general manager whose PMS reports stop at occupancy and ADR; an owner or investor who wants a monthly portfolio pack rather than a vendor login; a revenue manager comparing channel and package performance; a boutique operator whose properties run on different booking systems.

Not the right tool if you are: looking for a property management system – this reads reservations rather than taking them; needing live availability, rate parity or channel-manager pushes, which are operational jobs a reporting sheet cannot do; or running one small property with a handful of bookings a month, where the dashboard is more machinery than the question needs.

How to Use the Hospitality & Resorts Dashboard

1. Open the PDF in your download and click the Make a copy link. Google Drive creates your own editable copy.
2. Read the Instructions page first. Ten points, two minutes, and it explains why the KPI cards show unfiltered totals while the charts respond to slicers – the one thing people misread.
3. Export your reservations from the PMS and paste them onto the Data sheet, keeping the existing column headers so the pivots, slicers and charts stay connected.
4. Check the Overview page immediately. Total revenue, reservations and guests will tell you within seconds whether the import landed correctly.
5. Use the slicers to ask questions. Filter to one resort, one month or one booking channel and all four charts plus the sidebar move together.
6. Clear a slicer by opening it and choosing Select all. Slicers are per page, so each page keeps its own view.
7. Use the Search page for single reservations when a guest or an owner queries one stay.
8. Going past 1,000 rows? Open the Apps Script file, raise DATA_ROWS and re-run main(). Everything below that limit already works with no setup at all.

Real-World Use Cases

A group deciding which property to refurbish. Harbour Point Hotel showed 19.2% of portfolio revenue against Alpine Chalet Lodge at roughly 9%. But revenue per night and average length of stay put the chalet’s shortfall down to volume rather than rate, which moved the conversation from repositioning the property to filling its shoulder season.

A revenue manager pricing channel commission. The Bookings page ranked the direct website at 102,791 against travel agent at 61,705 and the loyalty app at 63,727. Seeing owned channels carry the majority of revenue is what makes a commission negotiation with an intermediary a numbers conversation rather than an argument.

An owner working out the cost of no-shows. A 10.4% no-show rate against an average booking value of 1,055 across 500 reservations is a large, specific figure – and it is one KPI card rather than a week of reconciling PMS exports. The group used it to justify a deposit policy on the two packages where no-shows clustered.

Frequently Asked Questions

Do I need a paid Google Workspace account?

No. A free personal Google account is enough. Click the copy link in the PDF and the dashboard lands in your own Drive with the pivots, slicers and charts working.

Does it connect to my property management system?

No, and that is deliberate. You export reservations and paste them onto the Data sheet, which means the dashboard works with any PMS – and keeps working after you switch systems, which an API-based tool does not. It also lets you combine properties that run on different software.

How many reservations can it hold?

The pivots, slicers and formulas are pre-wired for 1,000 rows, so anything up to that needs no setup. To go further, open the Apps Script file, raise the DATA_ROWS value and re-run main().

Why don’t the KPI cards change when I click a slicer?

By design. The KPI cards and the At a Glance list use SUMIFS and COUNTIFS on the Data sheet so they always show unfiltered totals – the constant you compare against. The charts, pivots and Top 5 panels are slicer-aware and do respond.

Can I add my own resorts, room types or packages?

Yes. They are values in your data, not hard-coded lists. Paste in your own rows and the pivots, slicers and charts pick up whatever property, room type, package or channel names you use.

Does it calculate ADR, RevPAR or occupancy?

It gives you revenue per night, average booking value, revenue per guest, room nights and average length of stay directly. True RevPAR and occupancy need a room-inventory count per property, which is not in the reservation data – add an inventory column and both are a short formula away. If you want RevPAR out of the box, the Hotel Revenue RevPAR Dashboard in Excel is built around it.

Can I share it with an owner without giving them edit rights?

Yes. Use the normal Google Sheets Share button and give view or comment access – which is one of the practical advantages over a PMS whose reports usually need a paid seat per person.

About the Author

Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.

Explore Related Templates

• Hotel Revenue RevPAR Dashboard in Power BI – RevPAR and ADR analysis with drillthrough.
• Hotel and Hospitality Revenue Dashboard in Excel – the same questions in Excel.
• Marina Management Dashboard in Google Sheets – the same architecture for berth and marina operations.
• Boutique Hotels Dashboard in Excel – built for a single independent property.
• Hospitality & Restaurant Bundle – seven templates covering rooms and food service together.
• Browse every Google Sheets dashboard or the full Google Sheets template catalogue.

Get Your Copy

Export last year’s reservations, paste them in, and open the Bookings page. Most operators find one channel or one package doing something they had not priced for. If anything does not work as described, contact us and we will put it right.

Watch the step-by-step video Demo:

Last updated: 12 August 2026.