The Booking By Travel Agent report provides a summary of reservations linked to each Travel Agent, allowing properties to track booking volumes, revenue, and commission data by agent over a specified period.
Â
Overview
The Booking By Travel Agent report is a management statistics report that displays reservation and revenue data grouped by Travel Agent.
This report is commonly used by property managers, revenue managers, and accounts teams to analyse the volume of bookings each Travel Agent has generated, review the associated revenue, and track commission obligations. It is particularly useful for evaluating agent performance, reconciling commission payments, and identifying top-producing agents during any specified period of time.
The report offers two distinct reporting modes - Report on Reservation and Report on GL Code - which determine how the data is sourced and displayed. Selecting the appropriate mode is important, as each returns a different level of detail and may display different results depending on the invoicing status of reservations.
Â
Â
Guide
In the side menu of RMS, go to Reports > Management > Statistics > Booking By Travel Agent.
- Select the Date Range.
Select the Travel Agent (Optional). - Select the Report On option.
- Select the Sort By option.
- Select Build.
Â
Report Build Options
Before running the report, configure the following parameters to filter the results:
| Parameter | Description |
|---|---|
| Reservation Between | The date range the report covers. Only reservations within this period are included in the results. |
| Travel Agent | Filter results to a specific Travel Agent, or leave as None Selected to include all agents |
| Report On | Determines how the report data is sourced — either from reservation records or from General Ledger transaction records |
| Sort By | Controls the order in which results are displayed in the report output |
Report On Options
The Report On options controls which reservations appear in the results:
Â
| Report On | Description |
|---|---|
| Reservation | Displays reservation-level details for each Travel Agent booking, including guest name, arrival and departure dates, and reservation totals. This mode shows reservations that have at least one invoice on the Reservation Account. |
| GL Code | Displays a transaction-level financial breakdown grouped by General Ledger Account Code. This mode includes reservations regardless of invoice status. |
Â
Report Columns
The columns displayed in the report output vary depending on the Report On option selected.
Report on Reservation
When Report on Reservation is selected, the report displays the following columns:
| Column | Description |
| Guest Name | Full name of the primary guest on the reservation |
| Reservation No | The unique reservation identifier |
| Arrival Date | The reservation check-in date |
| Departure Date | The reservation check-out date |
| Status | The current Reservation Status (e.g., Confirmed, In House, Departed, Cancelled) |
| Area | The assigned Area on the reservation |
| Category Type | The room or site Category assigned to the reservation |
| Guest Status | The assigned Guest Status on the reservation |
| Adult | The number of adults on the reservation |
| Child | The number of children on the reservation |
| Area Rate | The base nightly room rate charged for the stay (excluding extras) |
| Additional Tariff 1 | Any extra charges mapped to Additional Tariff 1 (custom configuration field) |
| Additional Tariff 2 | Any extra charges mapped to Additional Tariff 2 (custom configuration field) |
| Additional Tariff 3 | Any extra charges mapped to Additional Tariff 3 (custom configuration field) |
| Additional Tariff 4 | Any extra charges mapped to Additional Tariff 4 (custom configuration field) |
| Additional Tariff 5 | Any extra charges mapped to Additional Tariff 5 (custom configuration field) |
| Daily Rate | The total nightly rate including room and any included extras for that day |
| Nights | The total number of nights in the stay |
| Invoice No | The invoice number issued for the reservation’s charges. |
| Total Charge | The total value of the reservation |
Â
Report on GL Code
When Report on GL Code is selected, the report displays a financial breakdown grouped by General Ledger Account Code. This view includes:
Column |
Description |
|---|---|
Res No |
The unique reservation identifier |
Guest Name |
Full name of the primary guest on the reservation |
Status |
The current Reservation Status (e.g., Confirmed, In House, Departed, Cancelled) |
Arrive |
The reservation check-in date |
Depart |
The reservation check-out date |
Area |
The assigned Area on the reservation |
Category |
The room or site Category assigned to the reservation |
Guest Status |
The assigned Guest Status on the reservation |
Pax |
The total number of people included in the reservation (adults + children). |
Night |
The total number of nights for the stay. |
Tax Invoice No |
The invoice number issued for the reservation’s charges. |
Â
Report Sub-headings
| Column | Description |
|---|---|
| Travel Agent | The name of the Travel Agent assigned to the reservation |
| GL Code | The General Ledger Account Code associated with the transaction |
| Amount | The total transaction amount for the GL Code |
| Commission | The commission amount associated with the transactions |
Â
Understanding the Report
The Booking By Travel Agent report provides insight into the contribution of each agent to the property's bookings and revenue:
- Booking volume — Review the number of reservations each Travel Agent has generated during the selected Reservation Between period to identify top-performing agents.
- Revenue contribution — Compare the total reservation value by agent to understand the revenue each agent is driving.
- Commission tracking — Use the commission column to reconcile amounts owed to each Travel Agent and verify commission accuracy against your agreements.
When comparing results between the two Report On modes, keep in mind that the GL Code option may return a larger dataset because it includes transactions from reservations that have not yet been invoiced. The Reservation option provides cleaner, booking-level detail but only includes reservations that have at least one invoice on the account.
Â
Common Questions
Why are some reservations missing from the report when using Report on Reservation?
When using Report on Reservation, only reservations that have at least one invoice on the account are displayed. If a reservation has not yet been invoiced, it will not appear in this view. Switch to Report on GL Code to see all reservations, including uninvoiced ones.
Why does Report on GL Code show more results than Report on Reservation?
The Report on GL Code option queries the transaction table directly, which includes all transactions regardless of invoicing status. The Report on Reservation option only includes reservations with at least one invoice. This means the GL Code view may return additional rows for uninvoiced reservations.
Can I export this report?
Yes. Click the Export button at the top of the report to download the results as a CSV or PDF file.
Which mode should I use for commission reconciliation?
For commission reconciliation, Report on Reservation is generally preferred as it provides booking-level detail including guest names, dates, and individual commission amounts. However, if you need to account for all transactions including uninvoiced reservations, use Report on GL Code for a more comprehensive financial view.
Â
Â
Comments
0 comments
Please sign in to leave a comment.