Add On Revenue .ng
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