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 |
|
Rate Plan Code |
Identifies the unique code for every rate plan |
Not Applicable |
Not Applicable |
|
Rate Plan Name |
Name of the Rate Plan |
Not Applicable |
Not Applicable |
|
Travel Agent Name |
Name of associated travel agent |
Not Applicable |
Not Applicable |
|
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) |
|
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 |
|
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 |
|
Market Segment Name |
The name of the market segment |
Not Applicable |
Not Applicable |
|
Local Market Segment Code |
The code of the local market segment associated to the reservation |
Not Applicable |
Not Applicable |
|
Local Market Segment |
The name of the local market segment associated to the reservation |
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.