Rate Report .ng
Rate Report
Report Description: The Rate Report provides detailed information about room rates, guest details, reservation statuses, and financial data for each in-house guest, including rate, taxes, guest balance, rate plan, market segment, and company name, aiding in revenue analysis and management.
Date Range: For a specific date selected up to 365 days in the past or future
Available Report Columns for Following Sections:
Column Name | Column Description | Amount Includes Taxes and Fees | Calculation |
Room Number | Identifier for the room | Not Applicable | Not Applicable |
Room Type | Type or category of the room | Not Applicable | Not Applicable |
Guest Name | Name of the primary guest associated with the reservation | Not Applicable | Not Applicable |
Adults | Number of adult guests in the reservation | Not Applicable | =sum(adults) |
Children | Number of children in the reservation | Not Applicable | =sum(children) |
Reservation Status | Status of the reservation (e.g., confirmed, canceled) | Not Applicable | Not Applicable |
Nights | Number of nights for the reservation | Not Applicable | =sum(nights) |
Room Rate | Rate charged for the first night of the stay. | NO | Not Applicable |
Room Taxes | Taxes associated with the room rate | YES | =sum(room taxes) |
Room Fees | Additional fees associated with the room | YES | =sum(room fees) |
Total Guest Balance | Total amount owed by the guest | YES | =sum(charges) + (taxes + fees) |
Auto Charges | Automatically applied charges associated with the reservation | YES | =sum(auto charges) |
Rate Plan | Rate plan associated with the reservation | Not Applicable | Not Applicable |
Market Segment | Segment of the market to which the reservation belongs | Not Applicable | Not Applicable |
Company Name | Name of the company associated with the reservation (if applicable) | 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:
Not Applicable