In House .ng
In House
Report Description: The In House Report provides a current list of in-house guests, including details such as confirmation number, loyalty tier, group number, group code, PO number, guest name, company, number of adults and children, license plate, check-in date, check-out date, total nights stayed, room number, room type, rate plan, package, room rate, add-ons, status, ARR (Average Room Rate), remarks, make and model of vehicle, VIP guest status, guest tier, and virtual credit card information.
This report offers real-time information on guests currently staying at the property, facilitating efficient management and guest service.
Date Range: This report is available for the current business day only
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Confirmation Number | Unique identifier for the reservation confirmation | Not Applicable | Not Applicable |
Loyalty Tier | Tier or level of loyalty membership for the guest | Not Applicable | Not Applicable |
Group Number | Unique identifier for the group reservation, if applicable | Not Applicable | Not Applicable |
Group Code | Code representing the group reservation, if applicable | Not Applicable | Not Applicable |
PO Number | Purchase order number associated with the reservation, if applicable | Not Applicable | Not Applicable |
Guest Name | Name of the primary guest on the reservation | Not Applicable | Not Applicable |
Company | Name of the company associated with the reservation | Not Applicable | Not Applicable |
Adults | Number of adult guests in the room | Not Applicable | =sum(adults) |
Children | Number of children guests in the room | Not Applicable | =sum(children) |
License Plate | License plate number of the guest's vehicle | Not Applicable | Not Applicable |
Check In Date | Date when the guest checked into the accommodation | Not Applicable | Not Applicable |
Check Out Date | Date when the guest is scheduled to check out of the accommodation | Not Applicable | Not Applicable |
Nights | Total number of nights stayed by the guest | Not Applicable | =SUM(Nights) |
Room Number | Identifier for the room assigned to the guest | Not Applicable | Not Applicable |
Room Type | Type or category of the guest's room | Not Applicable | Not Applicable |
Rate Plan | Plan or rate associated with the guest's reservation | Not Applicable | Not Applicable |
Package | Any package or special offer associated with the reservation | Not Applicable | Not Applicable |
Room Rate | Rate charged for the guest's room | NO | Not Applicable |
Add On | Any additional services or amenities added to the reservation | Not Applicable | Not Applicable |
Status | Current status of the reservation | Not Applicable | Not Applicable |
ARR | Average Room Rate for the reservation | NO | =average rate (room revenue) / (number of nights) |
Remarks | Any additional remarks or notes related to the guest's stay | Not Applicable | Not Applicable |
Make and Model | Make and model of the guest's vehicle | Not Applicable | Not Applicable |
VIP Guest | Indicates whether the guest is a VIP or not | Not Applicable | Not Applicable |
Guest Tier | Tier or level of the guest | Not Applicable | Not Applicable |
Virtual CC | Virtual credit card information associated with the reservation, if applicable | Not Applicable | Not Applicable |
Local First Name | Guest first name in local language | Not Applicable | Not Applicable |
Local Last Name | Guest last name in local language | Not Applicable | Not Applicable |
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:
VIP Guest
Guest Tier
Virtual CC
Local First Name
Local Last Name
Make and Model
License Plate
PO Number