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

Forms and booking

Take a booking

Form
Take a bookingThe reservations desk keys in a booking from a phone call or a walk-in.
What is the confirmation number? *Looks like HR-4137.
Who is the stay for? *
Which kind of room did they choose? *
What day do they arrive? *
What day do they leave? *
How did the booking come in?Direct websiteBooking sitePhoneCorporate account
What kind of stay is it? *LeisureBusinessGroup blockExtended stayPackage
What rate did we quote per night?
Save the booking

Dashboards

The hotel's week

Stays
Room revenue by stay type
  • Leisure$8,355
  • Business$2,030
  • Group block$3,380
  • Package$4,354
  • Extended stay$5,335
Stays by channel
  • Direct website11
  • Corporate account11
  • Phone7
  • Booking site7

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