AI Matrx Logo

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
October 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
31

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—Oct 27, 2026Nov 1, 2026—
HR-4133Caspian Thornbury-RuizCottage Room—Oct 24, 2026Oct 26, 2026—
HR-4131Lucian Marchetti-OwusuDouble Queen227Oct 22, 2026Oct 26, 2026—
HR-4132Ottilie BrenneckeDouble Queen228Oct 22, 2026Oct 26, 2026—
HR-4130Evander Khalil-FenwickQueen Garden Room—Oct 21, 2026Oct 24, 2026—
HR-4129Ingrid Fairweather-ChoKing Suite307Oct 20, 2026Oct 22, 2026—
HR-4128Tamsin Bergstrom-QuistDouble Queen226Oct 18, 2026Oct 21, 2026$14
HR-4126Anneliese Petrovic-HaleKing Suite304Oct 17, 2026Oct 20, 2026$22
HR-4127Lorcan Pellegrini-MbekiQueen Garden Room220Oct 17, 2026Oct 19, 2026$0
HR-4124Dashiell Rutherford-SenLoft Suite404Oct 16, 2026Oct 22, 2026$38
HR-4123Marguerite Solheim-OkaforAccessible King111Oct 15, 2026Oct 17, 2026$16
HR-4125Maren Oyelowo-StrandCottage Room503Oct 15, 2026Oct 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.

Related templates