Horizon Hospitality Management · Controllers' Office

Housekeeping Payroll Audit Console

Work the weekly submission through every SOP checkpoint, validate productivity against the hourly minimum, log discrepancies in approved format, and generate the submission email — then assign final status.

USE IT TWO WAYS Work the console manually below, or hand the embedded build brief to Claude Code.
CLAUDE CODE — ENGINEERING BRIEF

    
SOP CHECKPOINTS
0%
2·3
Room-Level Service Ledger
Who · What Room · What Service

Attribute every room to a housekeeper and a service type. This is the pay record: it drives each housekeeper's credited rooms and productivity, and auto-flags duplicates, DND conflicts, and zero-DND days — naming who claimed each room.

Add rooms

Housekeeper names autofill from the roster in Productivity below. One room per record — paste a whole assignment at once.

Ledger

DateHousekeeperRoomService

By Housekeeper

HousekeeperDepartureStayoverRefreshDNDOOOCreditedHrsRms/HrFlag

By Day

DateOccupiedCredited cleanedDNDOOOFlags
07
Productivity Validation
Rooms ÷ Hours
Rooms Sold (W.E.)
Rooms Cleaned (W.E.)

HHMI Housekeepers

Rooms cleaned
Hours worked
Rooms / hour

Temp / Agency

Rooms cleaned
Hours worked
Rooms / hour

Housekeeper Roster — enter each housekeeper & their hours; rooms come from the Service Ledger above

HousekeeperPay typeHoursRooms (ledger)Rms/hrFlag

Rooms and Rms/hr are pulled from the Service Ledger by name — attribute rooms there. Per SOP 2025: HHMI hourly housekeepers must clean a minimum of 2 rooms/hour; the minimum does not apply to agency staff (paid per contract).

05
Staffing Agencies Used
Contractor Report

Select every agency appearing on this week's Contractor Report. Agency contact & invoicing is handled by the Controllers' Office only.

⚠ New Agency Flagged A new agency this week requires: contract, rate information, and contact information before payroll can be released. Final status should be set to "Missing Contract / Rate" until received.
08
Discrepancy Log
Approved Format

Logged in SOP format: MM/DD/YYYY – [issue]. Please confirm which is correct.

No discrepancies logged.

10
Final Status
Assign One
Copied to clipboard