Travel Agent Revenue Details
Report Description: Provides a list of reservations made by travel agencies. Report includes IATA number, guest name, stay details, rate details and details.
Date Range: This report is available for 365 days in the past
Details section: Provides a list of reservations made by travel agencies.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
IATA Number |
Travel agent IATA number |
Not Applicable |
Not Applicable |
|
Travel Agent Company Name |
Travel agency name associated to the IATA number |
Not Applicable |
Not Applicable |
|
Address |
Travel agency address associated to the IATA number |
Not Applicable |
Not Applicable |
|
Guest Name |
Name of the primary guest on the reservation |
Not Applicable |
Not Applicable |
|
Confirmation No |
Reservation confirmation number |
Not Applicable |
Not Applicable |
|
Arrival Date |
Reservation arrival date |
Not Applicable |
Not Applicable |
|
Nights |
Reservation number of nights |
Not Applicable |
=sum(nights) |
|
Departure Date |
Reservation departure date |
Not Applicable |
Not Applicable |
|
Rate Plan |
Reservation rate plan |
Not Applicable |
Not Applicable |
|
Total Room and Package Revenue |
Total room revenue including package element revenue |
NO |
=sum(room revenue) + (package revenue) |
|
Room Revenue |
Total room revenue excludes package revenue |
NO |
=sum(room revenue) |
|
Package Revenue |
Total package revenue excludes room revenue |
NO |
=sum(package revenue) |
|
Tax |
Total taxes from all tax types on the reservation (City, Lodging, etc. or VAT and VAT Long Stay, etc.) |
YES |
=sum(tax) |
|
Status |
Status of commission eligibility NC = Non Commissionable (not eligible) NO = No Commission |
Not Applicable |
Not Applicable |
Summary section: Provides a summary of revenues for the defined period by IATA number / agency name.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
IATA Number |
Travel agent IATA number |
Not Applicable |
Not Applicable |
|
Travel Agent Company Name |
Travel agency name associated to the IATA number |
Not Applicable |
Not Applicable |
|
Address |
Travel agency address associated to the IATA number |
Not Applicable |
Not Applicable |
|
Total Room and Package Revenue |
Total room revenue including package element revenue |
NO |
=sum(room revenue) + (package revenue) |
|
Room Revenue |
Total room revenue excludes package revenue |
NO |
=sum(room revenue) |
|
Package Revenue |
Total package revenue excludes room revenue |
NO |
=sum(package revenue) |
|
Average Room Rate |
The average daily rate for the room |
NO |
=sum(total room revenue / number of nights) |
|
Nights |
Number of nights in the reservation |
Not Applicable |
=sum(nights) |
|
Tax |
Total taxes from all tax types on the reservation (City, Lodging, etc. or VAT and VAT Long Stay, etc.) |
YES |
=sum(tax) |
|
Status |
Status of commission eligibility NC = Non Commissionable (not eligible) NO = No Commission |
Not Applicable |
Not Applicable |
Summary by Status section: Provides a summary of revenues for the defined period by status type.
Available Report Columns for Following Sections:
|
Column Name |
Column Description |
Amount Includes Taxes and Fees |
Calculation |
|
Status |
Status of commission eligibility NC = Non Commissionable (not eligible) NO = No Commission |
Not Applicable |
Not Applicable |
|
Total Room and Package Revenue |
Total room revenue including package element revenue |
NO |
=sum(room revenue) + (package revenue) |
|
Room Revenue |
Total room revenue excludes package revenue |
NO |
=sum(room revenue) |
|
Package Revenue |
Total package revenue excludes room revenue |
NO |
=sum(package revenue) |
|
Tax |
Total taxes from all tax types on the reservation (City, Lodging, etc. or VAT and VAT Long Stay, etc.) |
YES |
=sum(tax) |
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.