This article describes the Company / Travel Agent Stays report, which lists the nights and revenue for each Company or Travel Agent over a selected period.
Overview
The Company / Travel Agent Stays report lists, for a selected date range, the nights stayed and the revenue attributed to each Company or Travel Agent, broken down by Category.
You choose whether to report by Company or Travel Agent, rank by nights or revenue, optionally limit to the top results, and optionally group by General Ledger Account Code. The report heading reads Company Stays Report or Travel Agent Stays Report to match the option chosen. Finance and sales staff use it to see which Companies or Travel Agents are driving stays and revenue.
Use Cases
- Rank top accounts - set Based On to Revenue and a Top value to list the highest-revenue Companies first.
- Travel Agent production - switch to Travel Agent to see the nights and revenue produced by each agent.
- Category mix - see which Categories a Company or Travel Agent books.
Report Options
The report options control the period, whether to report by Company or Travel Agent, and how the results are grouped and ranked. Additional grouping options are available by clicking More Options.
| Report Option | Type | Default | Description |
|---|---|---|---|
| Date Range | Date range | Today | The period to report on. Reservations that fall within the range are included (prorated). |
| Company / Travel Agent | Radio | Company | Reports by Company or by Travel Agent. You can optionally limit the report to specific Companies or Travel Agents using the selector below the option. |
| Category | Multi-select | All Selected | Limits the report to the selected Categories. |
| Based On | Dropdown | Night |
Sets the basis used to rank and limit the results. Options:
|
| Top | Number | 0 | Limits the report to the top results by the Based On value. 0 shows all. |
| Report By GL Account Code Grouping (More Options) | Checkbox + dropdowns | Off | Groups the results by GL Account Code, using up to three GL Account Code Grouping levels. See Set up General Ledger account codes. |
| Property | Multi-select | All | Multi-property databases only. Limits the report to the selected properties. |
Guide
In the side menu of RMS, go to Reports > Management > Financial > Company / Travel Agent Stays.
- Select the Date Range.
- Select either Company or Travel Agent, then choose the required Company or Travel Agent.
- Select the Category.
- Select the Based On option.
(Optional) Enter the Top figure.
Select More Options for additional report selections. - Select Build.
Column Headers
One row is listed for each Company (or Travel Agent) and Category combination, with a Total per Company and a Grand Total.
| Column | Description | Source / Calculation |
|---|---|---|
| Company | The Company (or Travel Agent, when reporting by Travel Agent). | The property's configured Companies / Travel Agents. |
| Contact | The contact recorded for the Company or Travel Agent. | Company / Travel Agent profile. |
| Category | The Category stayed in. | The property's Categories. |
| Nights | The number of nights stayed in the date range. | Prorated to the reservation nights that fall within the range. |
| Revenue | The accommodation revenue for those nights. | Base Tariff Quote only (see Data Sources & Calculations). |
Data Sources & Calculations
The report includes reservations that fall within the selected date range, prorated to the nights inside the range. The Revenue figure includes the Base Tariff Quote only - it does not include sundry charges or extras. Switching the report between Company and Travel Agent changes which profile the stays are grouped under.
Related Reports
- Company Revenue Report - revenue by Company broken down by month.
- Travel Agent Performance Report - performance metrics by Travel Agent.
- Occupancy Report - by Company - occupancy and revenue grouped by Company.
Related Articles
Comments
0 comments
Please sign in to leave a comment.