Blog · Board and management reporting · Hospitality
Build a hotel front office manager report from daily room, arrival, staffing, and service records. Compare shifts, reconcile the handoff, and identify the exceptions that need action.
Front office managers report occupancy, arrivals, staffing, and service exceptions so the next shift knows where help is needed. A useful hotel report compares workload across shifts and reconciles the open issues passed between them. It ends with named owners and next actions for the unresolved items.
This is the hotel reception role. O*NET's description of hotel, motel, and resort desk clerks includes keeping room-availability and guest-account records, recording guest complaints, and balancing accounts. Those duties explain why the report needs both operating counts and a checked handoff.
Start with the property's approved daily room summary, room arrival and departure counts, actual front-desk staffing hours, and service exception log. Preserve the original export names and the time each file was produced.
Map all three shifts to the same hotel business date. Overnight work can cross a calendar-date boundary, and the property's operating day may differ from midnight to midnight. Do that mapping before grouping the records, using the hotel's existing convention.
Use room movements rather than individual guests in this example. A room occupied by multiple people is still one room arrival. A room checked out and checked in on the same day creates both a departure and an arrival; those are separate desk events.
Retain only the fields needed for the management comparison. Summarize service exceptions by reference ID, category, owner, status, and target action date. Guest names, payment details, and complaint narratives do not belong in this summary.
Pine Harbor Hotel, a fictional US property, reports the following September 30, 2026, room inventory. Its approved daily summary excludes out-of-order rooms from available room nights. The example has no complimentary or day-use rooms and no inventory changes during the day.
| Room measure | Calculation | Room nights |
|---|---|---|
| Physical capacity | Source inventory | 80 |
| Out of order | Source inventory | 5 |
| Available | 80 - 5 | 75 |
| Sold | Approved daily summary | 60 |
| Unsold available | 75 - 60 | 15 |
Occupancy = Sold room nights / Available room nights
With available room nights in B2 and sold room nights in C2, the Excel formula is:
=IF(B2=0,"",C2/B2)
Occupancy is 60 / 75 = 80.0%. The inventory check is 60 sold plus 15 unsold available plus 5 out of order equals 80 physical room nights. Use the same availability convention when comparing days.
For a wider property review, put this summary into the hotel dashboard. Broader commercial measures belong in hospitality KPIs; they need different inputs from the shift handoff below.
These three shift exports use actual worked front-desk hours, excluding unpaid breaks. A staffed hour means one employee working for one hour, so it differs from the shift's elapsed clock time.
| Shift | Room arrivals | Room departures | Staffed hours | Room movements | Movements per staffed hour |
|---|---|---|---|---|---|
| Overnight | 8 | 4 | 16 | 12 | 0.75 |
| Day | 18 | 42 | 32 | 60 | 1.88 |
| Evening | 34 | 6 | 24 | 40 | 1.67 |
| Total | 60 | 52 | 72 | 112 | 1.56 |
Place this table in A1:F5. Calculate E2 and F2, filling down through row 4:
=B2+C2
=IF(D2=0,"",E2/D2)
Calculate the daily rate from totals:
=SUM(E2:E4)/SUM(D2:D4)
The day shift handled 60 / 32 = 1.88 movements per staffed hour, while evening handled 40 / 24 = 1.67. Rates are rounded to two decimal places; calculations use unrounded values. The total is 112 / 72 = 1.56, not an average of the displayed shift rates.
Evening has the most arrivals: 34 / 24 = 1.42 arrivals per staffed hour, compared with 18 / 32 = 0.56 in the day shift. But departures reverse the picture for total movements. Review both tasks before moving staff from day to evening.
For a detailed arrivals file with shift labels in B and room-arrival quantities in C, the summary formula can be:
=SUMIFS(Arrivals!$C$2:$C$500,Arrivals!$B$2:$B$500,A2)
Microsoft documents SUMIFS as adding values that meet specified criteria. Filter that source to the approved business date first, and make sure it contains actual arrivals rather than future reservations or canceled bookings.
The room movement check uses the opening occupied-room position from the previous approved report:
| Occupied-room bridge | Rooms |
|---|---|
| Opening occupied rooms | 52 |
| Arrivals | 60 |
| Departures | -52 |
| Closing occupied rooms | 60 |
The closing 60 equals the daily sold room nights under this example's stated assumptions. A difference needs investigation for timing, room moves, day-use activity, or inconsistent units before the report is approved.
Service exceptions need a separate rollforward. Count each unresolved reference once, even if multiple departments are involved.
| Shift | Opening open items | New items | Resolved items | Closing open items |
|---|---|---|---|---|
| Overnight | 2 | 3 | 4 | 1 |
| Day | 1 | 5 | 3 | 3 |
| Evening | 3 | 7 | 6 | 4 |
In E2, then filled down:
=B2+C2-D2
Each shift's opening count must equal the previous shift's closing count. The daily check is 2 opening plus 15 new minus 13 resolved equals 4 closing. Do not add the opening or closing columns across shifts: the same unresolved item can appear in successive handoffs.
Attach the four closing item IDs, owners, next actions, and escalation needs. The front office manager confirms the operational handoff; the relevant service owner confirms resolution. Use an operational dashboard when comparing the same measures across several operating teams.
For tool-selection questions beyond this worksheet, see choosing analytics software for hospitality. Covirage is not affiliated with Microsoft.
Bring approved room summaries, shift staffing files, or service exception exports to Covirage; it maps the columns, and its tools compute and check the figures. The external AI model explains the comparison with every figure traced to its rows, helping the manager review workload and unresolved handoffs. Create a free Covirage account and bring a sample of your own data.
See Covirage for hospitality teams for the supporting industry context.
A front office manager report organizes workload, staffing, and service follow-up for operating decisions. A night audit includes checks of guest accounts and daily transactions under the property's procedures. The manager report can use approved audit outputs while keeping its own focus on shift performance and handoff.
Choose the unit required for the decision and label it. Room arrivals help reconcile occupied rooms, while guest counts may help plan welcome activity or group handling. Do not combine room arrivals from one shift with guest arrivals from another in the same workload measure.
No. Occupancy describes rooms used, while desk workload also depends on arrival timing, departures, group handling, requests, and unresolved issues. Compare shift-level room movements and exceptions with worked staff hours. Use local observations to interpret tasks that a simple movement count cannot capture.