Templates

Boutique hotel: Hazelmere Ridge Hotel

Boutique hotel · Bozeman, MT

Jarrah Ravensworth is the front office manager at Hazelmere Ridge Hotel, a forty-room boutique hotel in Bozeman, and she uses this to read each Monday's room nights and revenue by stay type without building a spreadsheet.

Food and hospitalityReportingDimensions4 tables · 5 views · 1 form · 2 dimension sets · 1 dashboard · 1 drill-down · 1 digest · 1 notification · 1 agent
Use this template

Arrivals

Stays
November 2026
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1HR-4110
2
3HR-4111
4HR-4112
5HR-4113
6HR-4114
7HR-4115
8HR-4116
9HR-4117HR-4135
10HR-4118
11HR-4119
12HR-4120
13HR-4121HR-4136
14HR-4122
15HR-4123HR-4125
16HR-4124
17HR-4126HR-4127
18HR-4128
19
20HR-4129
21HR-4130
22HR-4131HR-4132
23
24HR-4133
25
26
27HR-4134
28
29
30

Tables

Stays

36 sample rows · 15 columns

Every reservation from booking to departure: who, which room type, which nights and what it brought in.

ConfirmationGuestRoom typeRoomArrivalDepartureExtras billed
HR-4134Cordelia Achterberg-LoweLoft Suite—Nov 27, 2026Dec 2, 2026—
HR-4133Caspian Thornbury-RuizCottage Room—Nov 24, 2026Nov 26, 2026—
HR-4131Lucian Marchetti-OwusuDouble Queen227Nov 22, 2026Nov 26, 2026—
HR-4132Ottilie BrenneckeDouble Queen228Nov 22, 2026Nov 26, 2026—
HR-4130Evander Khalil-FenwickQueen Garden Room—Nov 21, 2026Nov 24, 2026—
HR-4129Ingrid Fairweather-ChoKing Suite307Nov 20, 2026Nov 22, 2026—
HR-4128Tamsin Bergstrom-QuistDouble Queen226Nov 18, 2026Nov 21, 2026$14
HR-4126Anneliese Petrovic-HaleKing Suite304Nov 17, 2026Nov 20, 2026$22
HR-4127Lorcan Pellegrini-MbekiQueen Garden Room220Nov 17, 2026Nov 19, 2026$0
HR-4124Dashiell Rutherford-SenLoft Suite404Nov 16, 2026Nov 22, 2026$38
HR-4123Marguerite Solheim-OkaforAccessible King111Nov 15, 2026Nov 17, 2026$16
HR-4125Maren Oyelowo-StrandCottage Room503Nov 15, 2026Nov 20, 2026$57

24 more rows

Guests

26 sample rows · 7 columns

Everyone who has booked with the hotel, how to reach them and every stay they have had.

GuestEmailPhoneLoyalty tierHome cityStays
Anneliese Petrovic-Haleanneliese.petrovic-hale@thistlepostbox.org(406) 555-0133NoneGreat FallsHR-4126
Aubrey Castellanos-Reidaubrey.castellanos-reid@thistlepostbox.org(406) 555-0111GoldMissoulaHR-4101
Bartholomew Quillfeatherbartholomew.quillfeather@ferndalemailhub.net(406) 555-0128NoneAustinHR-4119
Caspian Thornbury-Ruizcaspian.thornbury-ruiz@ferndalemailhub.net(406) 555-0120GoldBozemanHR-4110, HR-4133
Cordelia Achterberg-Lowecordelia.achterberg-lowe@thistlepostbox.org(406) 555-0123PlatinumChicagoHR-4113, HR-4134
Cornelius Abernathy-Itocornelius.abernathy-ito@ferndalemailhub.net(406) 555-0130NoneIdaho FallsHR-4121
Dashiell Rutherford-Sendashiell.rutherford-sen@ferndalemailhub.net(406) 555-0132PlatinumSeattleHR-4124
Evander Khalil-Fenwickevander.khalil-fenwick@ferndalemailhub.net(406) 555-0136GoldRenoHR-4130
Ezekiel Moreau-Tranezekiel.moreau-tran@ferndalemailhub.net(406) 555-0124NoneCalgaryHR-4115
Henrietta Kowalczyk-Boatenghenrietta.kowalczyk-boateng@thistlepostbox.org(406) 555-0125GoldSacramentoHR-4116
Ingrid Fairweather-Choingrid.fairweather-cho@ferndalemailhub.net(406) 555-0114NoneBillingsHR-4104, HR-4129
Leopold Santangelo-Pryceleopold.santangelo-pryce@ferndalemailhub.net(406) 555-0126SilverDenverHR-4117

14 more rows

Room types

6 sample rows · 5 columns

The six kinds of room the hotel sells, how many of each it has and the posted price.

Room typeRoomsPosted rateStays
King Suite6$289HR-4101, HR-4108, HR-4111, HR-4117, HR-4121, HR-4126, HR-4129, HR-4136
Queen Garden Room12$189HR-4102, HR-4107, HR-4112, HR-4114, HR-4118, HR-4122, HR-4127, HR-4130, HR-4135
Double Queen10$209HR-4103, HR-4104, HR-4105, HR-4115, HR-4120, HR-4128, HR-4131, HR-4132
Accessible King4$199HR-4110, HR-4123
Loft Suite4$329HR-4106, HR-4113, HR-4119, HR-4124, HR-4134
Cottage Room4$249HR-4109, HR-4116, HR-4125, HR-4133

Also included

  • Revenue by week and stay typeDrill-down
  • Monday numbersDigest
  • No-showNotificationTells the front office manager when a reservation is marked a no-show so the room can be resold.

Questions

What is included in the Boutique hotel: Hazelmere Ridge Hotel template?
3 tables (Stays, Guests and Room types), filled with 68 sample rows so every view opens with realistic data.
Is the Boutique hotel: Hazelmere Ridge Hotel template free?
Yes. Sign up free, press Use this template, and a full copy is added to your workspace.
Can I change the template after I use it?
Yes. Every page, table, column and view in your copy is yours to rename, edit or delete, and the sample rows can be cleared.