Room Service Requests .ng | HotelKey Knowledge Base

Room Service Requests Report Overview

Category: 🛏️ Room Status

Target Roles: Executive Housekeepers, Housekeeping Supervisors, Guest Services Leads, Front Office Managers, Concierge Leads, General Managers

Key Value: Monitor real-time guest amenity requests and special housekeeping service dispatches, track request fulfillment timelines, audit open vs. closed service tickets, enforce service level agreements (SLAs), and ensure exceptional in-room guest satisfaction.

Executive Summary

The Room Service Requests Report is an essential guest request tracking, housekeeping dispatch audit, and service fulfillment document within the 🛏️ Room Status category of the 🧹 Rooms & Facilities hub. Designed to deliver complete operational transparency over guest-initiated and front-desk-dispatched room requests, it itemizes every special service ticket logged across guest rooms during specified date windows.

By mapping physical room allocations (Room Number) to request classifications (Service Type, e.g., AMENITY DELIVERY, TURNDOWN SERVICE), reporting timeframes (Date From, Date To), ticket lifecycle timestamps (Opened At, Closed At), and operational fulfillment states (Status, e.g., OPEN, CLOSE), this report enables housekeeping managers, guest service supervisors, and front office leads to monitor active pending requests, dispatch floor attendants, measure ticket completion cycle times, and resolve fulfillment bottlenecks before guest satisfaction is impacted.

Key Capabilities

Real-Time Guest Request Ticket Monitoring: Tracks all active and historical guest service dispatches (Status = OPEN vs. Status = CLOSE) across property guest rooms.
Service Classification & Task Categorization: Identifies specific requested service types (Service Type, e.g., AMENITY DELIVERY, TURNDOWN SERVICE, extra linens, or towel dispatches) to route tasks to appropriate floor attendants.
Fulfillment SLA & Cycle Time Audit: Logs exact creation (Opened At) and completion (Closed At) timestamps to calculate fulfillment durations and measure staff responsiveness.
Floor Dispatch & Attendant Coordination: Serves as a live operational task list for floor supervisors to assign pending tasks (OPEN) to nearby room attendants or housepersons.
Historical Reporting & Service Trend Analysis: Filters requests across date ranges (Date From, Date To) to evaluate peak request hours and recurring amenity demand patterns.

Report Views & Functional Breakdown

The Room Service Requests Report presents task dispatch and fulfillment data in a unified single-table master matrix supporting three primary operational perspectives:

┌────────────────────────────────────────────────────────────────────────┐
│                   ROOM SERVICE REQUESTS REPORT                         │
├────────────────────────────────────────────────────────────────────────┤
│                         Unified Matrix View                            │
├──────────────────────────┬──────────────────────────┬──────────────────┤
│ 1. Guest Room & Service  │ 2. Ticket Timestamp &    │ 3. Fulfillment   │
│    Classification        │    Lifecycle Trace       │    Status Audit  │
└──────────────────────────┴──────────────────────────┴──────────────────┘

1. Guest Room & Service Classification

Monitors assigned physical room numbers, reporting date windows, and specific requested service categories.

Primary Use: Identifying which rooms require special attention and routing amenity or turndown tasks to floor attendants.
Key Metrics: Room Number, Service Type, Date From, Date To.

2. Ticket Timestamp & Lifecycle Trace

Tracks exact timestamps recording when a service request was initiated and when it was completed.

Primary Use: Measuring staff response times, auditing service level compliance, and identifying delayed tickets.
Key Metrics: Opened At, Closed At, Room Number, Service Type.

3. Fulfillment Status Audit

Audits real-time ticket states to distinguish pending active requests from resolved tickets.

Primary Use: Ensuring all open guest requests (OPEN) are resolved promptly before shift turnover or evening room inspections.
Key Metrics: Status, Room Number, Service Type, Opened At.

Image 10-17-26 at 1.18 PM.png — Room Service Requests Report

Data Dictionary (Dynamic View Columns)

Customize your default view using the Configure (⚙️) icon on the report page. Below is the full data dictionary representing all 7 dynamic columns available in this report:

Column Name	Description	Data Source / System Mapping	Includes Taxes & Fees?
Closed At	Timestamp recording when the request ticket was marked completed by staff (e.g., `13:09:25`, Blank if open).	Task Engine > Completion Timestamp	N/A
Date From	Starting date of the reporting window for logged service requests.	PMS Request System > Date Filter	N/A
Date To	Ending date of the reporting window for logged service requests.	PMS Request System > Date Filter	N/A
Opened At	Timestamp recording when the request ticket was created in the system (e.g., `10:25:08`).	Task Engine > Creation Timestamp	N/A
Room Number	Physical guest room number where the service was requested (e.g., `209`, `1002`).	PMS > Physical Room ID	N/A
Service Type	Classification of the requested housekeeping or amenity service (e.g., `AMENITY DELIVERY`, `TURNDOWN SERVICE`).	PMS Request System > Category Code	N/A
Status	Operational ticket status (e.g., `OPEN`, `CLOSE`).	Task Engine > Fulfillment Status	N/A

Customization & Platform Features

User & Property Preferences

Personal Preference: Tailor your individual view by hiding or dragging columns. Your preferences save automatically for future sessions.
Property Defaults: System Admins can configure standard default layouts across all property users to streamline operational reporting. To maximize audit efficiency, group the columns into the below logical blocks:
- hysical Locator & Request Type (Cols 1–2): Room Number | Service Type
- Task Status & Execution Timestamps (Cols 3–5): Status | Opened At | Closed At
- Request Validity Window (Cols 6–7): Date From | Date To

Use the top-right toolbar icons on the report page to manage and export your data view:

Icon	Action / Feature	Description
	Knowledge Article	Opens the knowledge base article to learn how to interpret this report.
	Saved Views	Saves your column filtering, sorting, and highlight preferences so you can easily reload your custom view later without reconfiguring the report.
	Filter	Opens filter controls to isolate specific data within a column based on your selected criteria.
	Highlight	Highlights column values in a designated color based on selected conditions.
	Export	Exports and downloads the report in various formats (Excel, PDF, CSV) for offline analysis or printing.
	Configure	Opens column selection controls to toggle visibility, reorder columns, or hide rows with all zeros.
	Additional Configuration	Provides advanced report configuration and display formatting options to customize data presentation.

Advanced Controls

Shift Dispatch Exporting: Schedule automated periodic exports throughout peak service hours (e.g., 10:00, 14:00, 18:00, 21:00) to generate live task dispatch sheets for floor housepersons.
Filtering: Filter data by Status = OPEN to generate an immediate priority dispatch list for floor supervisors, or filter by Service Type = TURNDOWN SERVICE.
Highlighting (Conditional Formatting): Apply custom rules to automatically highlight active pending tickets (Status = OPEN), tickets with extended open durations, or specific high-touch amenity requests.

Within 🧹 Rooms & Facilities & 🛏️ Room Status:

Housekeeping Sheet – Comprehensive multi-section daily housekeeping board, priority dispatch, and ready room matrix.
Housekeeping Room Log – Immutable audit trail tracking all room status changes and attendant cleaning actions.
Pending Room – Operational view of unready rooms pre-assigned to expected arriving guests.
All Rooms Report – Master physical room inventory, cleanliness state, and housekeeping schedule manifest.

Cross-Pillar Deep Dives:

🛎️ Front Desk & Guest Services: Reconcile closed amenity tickets (Status = CLOSE) with the Reminders Report and Service Recovery Report to ensure guest requests are completely resolved.