Skip to main content
Submit a Ticket

How can we help?

Marketing Cash/Rate By Reservation Arrival Report

This article describes the Marketing Cash/Rate By Reservation Arrival report, which shows cash receipts or charges from reservations with arrival dates in a selected period, with options to group by Travel Agent or Accounting Group.

 

Overview

The Marketing Cash/Rate By Reservation Arrival report combines two date range filters - when reservations were made and when they arrive - to give a marketing-focused view of revenue.

Run it in Cash Report mode to see cash receipts, or switch to Charge Report mode to see charges raised.

Use the Group By options to break the results down by Travel Agent or Accounting Group, making it useful for comparing how different booking sources or agent groups contribute to revenue from arrivals in a given period.

✎ Please Note: This report is not intended to balance with any other report.
The totals shown may differ from financial reports such as the Cash/Charge Report.
✎ Please Note: RMS is highly configurable. Some Terminology, User Access & Permissions, Images, Labels, and Functions used in these articles may differ from your setup. CLICK HERE to find out more.

Use Cases

  • Travel agent revenue by arrival period - enable Group By Travel Agent to see which agents generated the most cash receipts or charges from reservations arriving in a given month.
  • Advance booking analysis - set "Date Made From" to a prior marketing period and "For Reservation Arriving From" to a future arrival window to see how much revenue from those arrivals was booked during your campaign.
  • Accounting group performance - enable Group By Accounting Group to compare revenue contributions across different agent groups or booking categories.
  • Cash vs charge comparison - run once in Cash Report mode and once in Charge Report mode to compare cash collected against charges raised for the same set of arrivals.

 

How to Access

Go to Reports > Management > Statistics > Marketing Cash/Rate By Reservation Arrival.

 

Report Options

★ Tip: Report build screens default to a common use configuration, and selections can be made as required.
Report Option Type Default Description
Date Made From Date range Today Filters by when the reservation was created. Only reservations made within this date range are included in the report.
For Reservation Arriving From Date range Today Filters by the reservation arrival date. Only reservations with an arrival date within this range are included. The date range shown in the report output header is taken from this field.
Travel Agent Multi-select None Selected Restricts the report to reservations linked to the selected Travel Agents. When no Travel Agents are selected, all reservations are included regardless of Travel Agent.
Cash Report Radio On When selected, the report shows cash receipts allocated to the matching reservations. The output title reads "Marketing Cash by Reservation Arrival".
Charge Report Radio Off When selected, the report shows charges raised against the matching reservations instead of cash receipts.
Group By Property Checkbox Off When ticked, adds a Property-level grouping to the output rows. Available on multi-property databases.
Group By Travel Agent Checkbox Off When ticked, breaks the output down by Travel Agent with one row per agent. Group By options can be combined - for example, ticking both Group By Property and Group By Travel Agent produces nested groupings.
Group By Accounting Group Checkbox Off When ticked, breaks the output down by Accounting Group with one row per group.
Tax Exclusive Checkbox Off When ticked, revenue figures exclude tax amounts.

 

Report Output

The report header shows the property name, the report title (which changes based on the Type Of Report selected), and the "For Reservation Arriving From" date range.

When no Group By options are selected, a single totals row is shown for all matching reservations.

When Group By options are ticked, one row appears per entity (Travel Agent, Accounting Group, or Property). A Total row and Grand Total row appear at the end of each group and for the whole report.

The revenue column header is dynamic and shows the month and year of the date range (for example, "Jun 2026" for a June date range). For date ranges that span multiple months, a separate column appears for each month.

Column Description
[Month Year] Revenue for the selected period - cash receipts in Cash Report mode, charges in Charge Report mode. The column header shows the month and year (for example, "Jun 2026"). For multi-month date ranges, one column per month appears.
Total Res The total number of reservations with an arrival date in the selected period that match all filters.
Total The sum of all revenue across all month columns for this row.

 

Related Reports

  • Marketing Report - a broader marketing performance report covering revenue across multiple metrics and date dimensions.
  • Performance III Report - shows accommodation and revenue metrics grouped by Company, Travel Agent, Booking Source, or other entities for a selected period.
  • Cash/Charge Report - the financial revenue report showing Cash or Charge breakdowns grouped by GL Account Code.

 

 

Related to:

Was this article helpful?

We're sorry to hear this article was not helpful, please let us know why here, so we can make it better.

Thanks for the positive feedback! We'd love to hear more, let us know here.

Return to top

Comments

0 comments

Please sign in to leave a comment.

Contact us