Add On Revenue
Report Description: The Add On Revenue Report provides a list of all add on transactions including charge type name, charge type code, amount and when the add on was purchased (check in time or on Demand).
Date Range: This report can render the data for up to 94 days in the past or future
Details section: Provides a list of reservations with purchased add on, fulfillment date and price.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Date |
Date of the transaction |
Not Applicable |
Not Applicable |
|
Property Code |
Unique identifier for the property |
Not Applicable |
Not Applicable |
|
Confirmation Number |
Confirmation number associated with the reservation |
Not Applicable |
Not Applicable |
|
Guest Name |
Name of the primary guest on the reservation |
Not Applicable |
Not Applicable |
|
Loyalty Tier |
Loyalty tier or membership status of the guest |
Not Applicable |
Not Applicable |
|
Arrival Date |
Date of guest arrival |
Not Applicable |
Not Applicable |
|
Arrival Time |
Estimated time of the guest arrival provided by the guest |
Not Applicable |
Not Applicable |
|
Departure Date |
Date of guest departure |
Not Applicable |
Not Applicable |
|
Departure Time |
Estimated time of the guest departure provided by the guest |
Not Applicable |
Not Applicable |
|
Room Number |
Room assigned to the guest |
Not Applicable |
Not Applicable |
|
Guest |
Number of guests included in the reservation |
Not Applicable |
=sum(adults) + (children) |
|
Nights |
Number of nights the guest stayed |
Not Applicable |
=sum(nights) |
|
Status |
Status of the reservation |
Not Applicable |
Not Applicable |
|
Digital Check In |
Indicates if the guest utilized digital check-in |
Not Applicable |
Not Applicable |
|
Digital Key |
Indicates if the guest used a digital key |
Not Applicable |
Not Applicable |
|
Fulfillment Date |
Date when the add-on was fulfilled |
Not Applicable |
Not Applicable |
|
Add On Name |
Name of the add-on service or item |
Not Applicable |
Not Applicable |
|
Add On Code |
Code associated with the add-on service or item |
Not Applicable |
Not Applicable |
|
Posting Type |
How the charge is posted to folio (example: daily, first day, etc) |
Not Applicable |
Not Applicable |
|
Quantity |
Quantity of the add-on purchased |
Not Applicable |
=sum(quantity) |
|
Unit Price |
Price per unit of the add-on |
NO |
Not Applicable |
|
Amount |
Total amount charged for the add-on |
NO |
=sum(quantity) x (unit price) |
|
Purchased At |
Time when the add-on was purchased |
Not Applicable |
Not Applicable |
Summary section: Provides a summary of quantity and amount by add on.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Property Code |
Unique identifier for the property |
Not Applicable |
Not Applicable |
|
Add On Name |
Name of the add-on service or item |
Not Applicable |
Not Applicable |
|
Add On Code |
Code associated with the add-on service or item |
Not Applicable |
Not Applicable |
|
Quantity |
Quantity of the add-on purchased |
Not Applicable |
=sum(quantity) |
|
Amount |
Total amount charged for the add-on |
NO |
=sum(quantity) x (unit price) |
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.
-
Bar Graph: ability to view total add on amounts by date in a bar chart.
-
Grouping: ability to view the data grouped by: All, Confirmation No or Charge Code
-
Pie Chart: ability to view grouped data in a Pie Chart view.
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:
-
Digital Key
-
Digital Check In
-
Property Code
-
-