What a hotel owner's Monday morning report should show
· reporting, owners, labor
A hotel owner’s Monday morning report needs six numbers on one page: last week’s labor cost, worked hours against scheduled hours, overtime hours, hours per occupied room, anything still unapproved, and anything unusual that happened. Most of what else gets reported, such as daily breakdowns by department or a dozen ratios, is detail you should pull only when one of those six moves. The report exists to let you decide in ten minutes whether anything needs your attention this week.
The six numbers
1. Labor cost for the week, and the same week last year if you have it. One dollar figure. If last week was a holiday week, compare it with last year’s equivalent week, not with the week before it.
2. Worked hours against scheduled hours. If the clock says 412 hours and the schedule said 395, you want to know that before you read anything else. A growing gap means the schedule is no longer the plan. Hotel labor variance explained covers the usual causes.
3. Overtime hours. In hours, not dollars. The dollar amount depends on the rate; the hours tell you whether the schedule is pushing people past the threshold.
4. Hours per occupied room. Total paid hours divided by occupied room-nights. It lets you read a slow week and a full week on the same scale.
5. Items waiting on a person. Punches not yet approved, missing clock-outs, an open issue. These are the numbers that become a payroll problem on Friday if nobody sees them on Monday.
6. One line of exceptions. Whatever the manager would tell you if you were standing in the lobby: a sick call week, a roof leak, a new hire’s first week. The numbers cannot say this, and it often explains them.
An invented example
Take an invented owner of a 56-room motel, placeholder wage $16/hr.
Last week: 478 hours worked against 455 scheduled; 11 hours of overtime; 301 occupied room-nights (about 43 a night); 6 punches unapproved; the manager’s note says “two housekeepers out Tue-Thu, covered by overtime.”
| Item | Last week | Read |
|---|---|---|
| Worked vs scheduled | 478 vs 455 | +23 hours, about 5% |
| Overtime | 11 hours | Explains about half the gap |
| Hours per occupied room | 478 / 301 = 1.59 | Check against recent weeks |
| Unapproved punches | 6 | Ask for them by Wednesday |
| Exceptions | Two out, covered | Plausible cause of the overtime |
At a labor cost of roughly 478 x $16 = $7,648 straight-time equivalent, the 11 overtime hours add a half-time premium of 11 x $8 = $88. Eleven hours is not a crisis, and the owner’s reading is: the cause is in the note, the cost is small, the six unapproved punches need a nudge. Total time on this: about five minutes, which is the intent.
Reading the report in order
Read it top to bottom once, and stop at the first line that looks wrong. The order is deliberate. Cost tells you whether there is a question; worked against scheduled tells you whether it is about planning or about execution; overtime and hours per occupied room tell you whether the schedule or the volume explains it; and the last two lines tell you who to ask. If every line looks ordinary, close the report. A report that routinely gets closed after a minute is a report doing its job, and the habit of reading it every Monday is worth more than any single week’s figure.
It also helps to write down, once, what “ordinary” means for your property: the range of worked-over-scheduled you have seen in a normal month, the usual overtime, the usual hours per occupied room. Without that, every number is a fresh puzzle. With it, a reading outside the range is the signal, and everything inside the range is noise you can stop spending attention on.
What to ignore
You can safely skip these from a Monday report:
- Per-employee hours for every employee. Look only when a total looks wrong.
- Daily breakdowns when the weekly number is normal. Dailies are for investigation, not for reading.
- Labor as a percentage of revenue, in isolation. It moves with room rate and occupancy regardless of how efficiently people worked; what the labor cost percentage means shows how. It is worth watching monthly, not as a Monday driver.
- Ratios nobody has defined for your property. If you cannot say what a good number is, it is not yet a report line.
- A rolling average that smooths away the week you care about.
Where the data should come from
The report should be assembled for you, not by you. If it takes an hour of copying between a time clock, a schedule and a PMS report, it will stop happening in a month, which is the usual failure. The daily labor flash email ProfitClock sends each morning covers the hours side and is where reading a daily labor report picks up; ProfitClock does not read your PMS. On the Smart plan, labor per occupied room is reported from the room statuses your team keeps. Room revenue, if you want it, is entered separately. If you are choosing what to track before choosing any tool, write the six lines above on a card and see which you can already fill in.
How to use Monday’s report
- Read it before you open the email that will distract you.
- For each line that looks off, write the one question you would ask the manager.
- Send the questions by noon, so the answers come back while the week is still young.
- Look at the trend each month: four Mondays side by side show more than any single one.
If you have more than one property, the same six lines apply per property, with a roll-up beneath; multi-property labor reporting shows how to stack them, and the regional manager weekly labor review turns them into a 30-minute meeting. For the daily version of this report, see what goes in a daily hotel flash report.
When this breaks
A one-page report assumes the underlying records are reasonably clean. If punches are routinely missed, if managers’ hours are not in the data at all (see salaried manager hours missing from labor metrics), or if occupied room-nights are an estimate, the six numbers will look precise and be wrong. Fix the inputs before refining the report. And if your state has daily overtime rules, make sure the overtime figure reflects them, not just the 40-hour weekly line.
Start seeing what labor actually costs
Set up your property, put staff on the clock, and read tomorrow morning’s labor number.
14-day free trial · No credit card · Cancel anytime