Travel Agent Revenue Details Report .ng
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.