Housekeeping Sheet .ng
Housekeeping Sheet
Report Description: The Housekeeping Sheet Report provides a detailed overview of activity in each room of the hotel, including occupancy status, housekeeping requirements, guest details, preferences, and remarks. This report is essential for creating efficient housekeeping task assignments. The Housekeeping Sheet Report offers a comprehensive overview of activity in each room of the hotel, facilitating the creation of housekeeping task assignments.
Date Range: This report is available for the current business day only.
Housekeeping Sheet Section: Provides a list of all activities (occupancy status, room status, service type, assignments, service times, etc.) for every room of the hotel.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Room Number | Unique identifier for each room | Not Applicable | Not Applicable |
Room Type | Category or classification of the room | Not Applicable | Not Applicable |
Room Size | Dimensions or square footage of the room | Not Applicable | Not Applicable |
Rate Plan | Pricing structure or tariff applicable to the room | Not Applicable | Not Applicable |
Zone | Specific area or section of the hotel where the room is located | Not Applicable | Not Applicable |
Occupancy Status | Current occupancy status of the room (occupied, vacant, etc.) | Not Applicable | Not Applicable |
Room Status | Current condition or state of the room (clean, dirty, under maintenance, etc.) | Not Applicable | Not Applicable |
Service Type | Type of housekeeping service required for the room (check-out, stay over, etc.) | Not Applicable | Not Applicable |
Housekeeping Team | Team or staff responsible for housekeeping duties in the room | Not Applicable | Not Applicable |
Assigned To | Staff member to whom the room is assigned for cleaning | Not Applicable | Not Applicable |
Service Time | Estimated time required to complete the housekeeping service | Not Applicable | Not Applicable |
Arrival Date | Date of guest arrival | Not Applicable | Not Applicable |
Arrival Time | Time of guest arrival | Not Applicable | Not Applicable |
Departure Date | Date of guest departure | Not Applicable | Not Applicable |
Departure Time | Time of guest departure | Not Applicable | Not Applicable |
Current Stay | Indicates if the room is currently occupied by a guest | Not Applicable | Not Applicable |
Upcoming Stay | Indicates if there is an upcoming reservation for the room | Not Applicable | Not Applicable |
Loyalty Tier | Loyalty program tier or status of the guest | Not Applicable | Not Applicable |
Guests | Number of guests staying in the room | Not Applicable | =sum(adults) + (children) |
Pets | Indicates if pets are accompanying the guest | Not Applicable | Not Applicable |
Preferences | Guest preferences or special requests | Not Applicable | Not Applicable |
Comments | Additional comments or instructions related to the room | Not Applicable | Not Applicable |
Remarks | Any specific remarks or notes regarding the room | Not Applicable | Not Applicable |
Composite Room | Indicates if the room is part of a composite room setup | Not Applicable | Not Applicable |
Component Rooms | Lists component rooms if the room is part of a composite setup | Not Applicable | Not Applicable |
Connected Rooms | Indicates if the room is connected to other rooms | Not Applicable | Not Applicable |
VIP Guest | Indicates if the guest staying in the room holds VIP status | Not Applicable | Not Applicable |
Ready Rooms Section: Provides a list of all rooms in “Ready” status.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Room Number | Unique identifier for each room | Not Applicable | Not Applicable |
Room Type | Category or classification of the room | Not Applicable | Not Applicable |
Room Size | Dimensions or square footage of the room | Not Applicable | Not Applicable |
Rate Plan | Pricing structure or tariff applicable to the room | Not Applicable | Not Applicable |
Zone | Specific area or section of the hotel where the room is located | Not Applicable | Not Applicable |
Occupancy Status | Current occupancy status of the room (occupied, vacant, etc.) | Not Applicable | Not Applicable |
Service Type | Type of housekeeping service required for the room (check-out, stay over, etc.) | Not Applicable | Not Applicable |
Arrival Date | Date of guest arrival | Not Applicable | Not Applicable |
Arrival Time | Time of guest arrival | Not Applicable | Not Applicable |
Departure Date | Date of guest departure | Not Applicable | Not Applicable |
Departure Time | Time of guest departure | Not Applicable | Not Applicable |
Current Stay | Indicates if the room is currently occupied by a guest | Not Applicable | Not Applicable |
Upcoming Stay | Indicates if there is an upcoming reservation for the room | Not Applicable | Not Applicable |
Loyalty Tier | Loyalty program tier or status of the guest | Not Applicable | Not Applicable |
Guests | Number of guests staying in the room | Not Applicable | =sum(adults) + (children) |
Pets | Indicates if pets are accompanying the guest | Not Applicable | Not Applicable |
Preferences | Guest preferences or special requests | Not Applicable | Not Applicable |
Housekeeping Remarks | Any specific remarks or notes regarding the room | Not Applicable | Not Applicable |
Comments | Additional comments or instructions related to the room | Not Applicable | Not Applicable |
Composite Room | Indicates if the room is part of a composite room setup | Not Applicable | Not Applicable |
Component Rooms | Lists component rooms if the room is part of a composite setup | Not Applicable | Not Applicable |
Connected Rooms | Indicates if the room is connected to other rooms | Not Applicable | Not Applicable |
VIP Guest | Indicates if the guest staying in the room holds VIP status | Not Applicable | Not Applicable |
Summary by Assignment Section: Provides an assignment summary of the day by individual.
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Assigned To | Staff member to whom the room is assigned for cleaning | Not Applicable | Not Applicable |
Total Room | Total number of rooms assigned | Not Applicable | =sum(number of rooms) |
Vacant | Total number of vacant rooms assigned | Not Applicable | =sum(number of vacant rooms) |
Occupied | Total number of occupied rooms assigned | Not Applicable | =sum(occupied rooms) |
Clean | Total number of clean rooms assigned | Not Applicable | =sum(clean rooms) |
Dirty | Total number of dirty rooms assigned | Not Applicable | =sum(dirty rooms) |
Ready | Total number of ready rooms assigned | Not Applicable | =sum(ready rooms) |
Pets | Total number of pet rooms assigned | Not Applicable | =sum(pet rooms) |
VIP | Total number of VIP rooms assigned | Not Applicable | =sum(vip rooms) |
Adults | Total number of adults within the room assigned | Not Applicable | =sum(adults) |
Children | Total number of children within the room assigned | Not Applicable | =sum(children) |
Misc Report Information:
Available Features:
Export: ability to download and save the file into an alternate format.
Filter: filter a range of data based on criteria defined by the user.
Highlight: also known as conditional formatting is the ability to highlight certain values making them easier to identify.
Available Configuration:
User Preferences: allows the user to customize their report view by repositioning or removing columns.
Property Preferences: allows the property to customize the report view for all users by repositioning or removing columns.
Baseline Configuration:
Property Preferences Settings:
Following columns to be disabled for initial deployment:
Room Size
Rate Plan
Composite Room
Component Rooms
Connected Rooms
Preferences