This guide explains the Operations Recap Report, a financial revenue report that breaks down transactions by Category, charges, payments and voids for a selected date range, with optional filtering by Category and Loyalty Membership Type.
Overview
The Operations Recap Report is a comprehensive Financial Revenue report that provides a transaction breakdown for the selected date range. It includes Accommodation Revenue transactions posted to reservation accounts, the number of rate nights covered, as well as other charges and payments taken.
All figures included on this report are tax-inclusive where applicable. Exclusive taxes will include their own lines in the Other Charges section of the 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
- Daily revenue recap - at the end of trade, the duty manager runs the report for today to see accommodation revenue by Category, nights sold, and the average net rate per night in one page.
- Reconciling takings - the accounts team compares the Payments section against banking to confirm the day's receipts by payment type before closing off.
- Reviewing voids - a supervisor checks the Voids section to see which staff member voided transactions in a period and the total value involved.
Before You Begin
To access and use the Operations Recap Report, ensure you have:
- User permissions to view Revenue and Financial reports.
- Knowledge of your RMS setup's General Ledger Account Codes and Categories.
How to Access
In the side menu of RMS, go to Reports > Accounting > Operations Recap.
Report Options
Selecting the report opens the Report Options panel. Configure the filters below, then choose Build to run the report, Schedule to set up automated delivery, or Exit to close the screen.
Tip! Report build screens default to a common use configuration, and selections can be made as required.
| Report Option | Type | Description |
|---|---|---|
| Date | Date range | The transaction date range the report covers. Defaults to Today. |
| Category | Multi-select dropdown | Limits the Registration & Net Rev/Night section to the selected Categories. Defaults to All Selected. |
| Loyalty Membership Type | Multi-select dropdown | Limits the report to reservations linked to the selected Loyalty Membership Type. Leave as None Selected to include all reservations. |
Column Headers
The report output is divided into four sections: Registration & Net Rev/Night, Other Charges, Payments, and Voids. Each section has its own set of columns, listed below. Where a value depends on a property setting or another column, the Source / Calculation column points to the relevant concept under Data Sources & Calculations.
Registration & Net Rev/Night
The Registration & Net Rev/Night section includes all transactions posted on a reservation account for the selected date range with the General Ledger Account Code set as Accommodation Revenue. Each row represents a Category.
| Column | Description | Source / Calculation |
|---|---|---|
| Gross Amount | Total transaction value posted in the date range, including taxes. | See Accommodation Revenue. |
| Discount | Discount value applied to the rate in the date range. | Discounts applied to the reservation. |
| Net Amount | Value of the transactions after discounts. | Gross Amount less Discount. |
| Nights Sold | Number of rate nights for the date range against each listed Category. Not occupancy-based. | Count of rate nights, not the number of reservations or guests. |
| Net Amt/Nights Sold | Per-night value for each Category. | Net Amount divided by Nights Sold. |
Below the per-Category rows, the section displays three summary lines:
- Registration & Net Rev/Night Summary - column totals across all Categories.
- Registration Discounts - shows the total discount Amount, the Quantity of discounts applied, and the number of Nights they applied to.
- Net Registration - grand total: the Summary's Net Amount plus the Registration Discounts Amount.
Tip! Net Registration will correspond with the Management > Financial > Charge Report (Cash/Charge) on the listed Categories.
Other Charges
The Other Charges section includes all transactions posted to a reservation account during the selected date range that are not included as part of Accommodation Revenue in the report's top section.
| Column | Description | Source / Calculation |
|---|---|---|
| Gross Amount | Total transaction value posted in the date range, including taxes. | Sundry Charges posted to reservation accounts. |
| Discount | Discount value applied to transactions in the date range. | Discounts applied to the charge. |
| Net Amount | Value of the transactions after discounts. | Gross Amount less Discount. |
| Quantity | Number of transactions for the listed charge in the date range. | Count of posted transactions. |
| Code | General Ledger Account Code assigned to the listed Sundry Charge. | See General Ledger Account Codes. |
Each row represents a Sundry Charge. Sundry Charges grouped under a configured General Ledger Account Code grouping (for example, Store Sales) appear under that grouping label. Below the rows, the section displays:
- Total Other Charges - column totals across all Other Charges.
- Total Charges - the Net Registration value plus Total Other Charges.
- Deposits - a separate ledger row with four columns: Amount (deposits held), Rec/Adj (deposits received or adjusted), Honoured (deposits consumed), Forfeited (deposits refunded).
- Total Charges & Net Deposits - grand total combining Total Charges and Deposits movement.
Tip! Total Charges (excluding the Deposits section) will match the Other Charges section of the Management > Financial > Charge Report (Cash/Charge).
Payments
The Payments section provides a summary of receipts made onto reservation accounts within the selected date range, organised by payment type.
| Column | Description | Source / Calculation |
|---|---|---|
| Type | Payment method (for example, Mastercard, Visa, Direct Credit, On Account). | Receipt type recorded against the reservation account. |
| Quantity | Number of receipts of this type in the date range. | Count of receipts. |
| Amount | Total value of receipts of this type in the date range. | Sum of receipt values. |
Rows are grouped under two sub-headings:
- EFTPOS - one row per card type processed (for example, Mastercard, Visa, Amex), followed by a Sub Total line.
- Cash - cash receipts, included in the same sub-group as EFTPOS.
A Total Cash & Cards line follows, summing all EFTPOS and Cash receipts.
- Non-Cash - one row per non-cash payment type, including Direct Credit and On Account (receipts allocated to transactions not covered by other categories), followed by a Sub Total line.
A Total Payments grand-total line combines the Cash & Cards and Non-Cash subtotals. The DPS Credit Card Analysis appears as a separate summary of the Gateway Settlement Report for the date range.
Please Note! A payment sub-heading only appears when the date range contains receipts of that type. On a day with no card or cash receipts, the EFTPOS, Cash and Total Cash & Cards lines are not shown.
Voids
The Voids section provides a breakdown of transactions voided by RMS users in the date range. One row per Employee, with a Total line at the bottom.
| Column | Description | Source / Calculation |
|---|---|---|
| Employee | RMS user who actioned the voids. | The user recorded against the void transaction. |
| Quantity | Number of transactions voided by the employee in the date range. | Count of void transactions. |
| Amount | Total value of voided transactions by the employee in the date range. Displays as a negative value. | Sum of the voided transaction values. |
Data Sources & Calculations
The following concepts each govern more than one column on the report.
Accommodation Revenue
The Registration & Net Rev/Night section is driven by the General Ledger Account Code assigned to each transaction. Only transactions posted to a reservation account whose General Ledger Account Code is set as Accommodation Revenue appear in this section. Every other transaction posted to a reservation account falls into the Other Charges section instead.
General Ledger Account Codes
The Code column in the Other Charges section shows the General Ledger Account Code assigned to each Sundry Charge. Where several Sundry Charges share a configured grouping, the report lists them under the grouping label rather than individually. See Set up General Ledger Account Codes.
Tax Treatment
The report header states that all amounts are tax-inclusive where applicable. Inclusive taxes are already contained in the Gross Amount of each row. Exclusive taxes are not, and appear as their own lines in the Other Charges section.
Related Reports
- Cash Transaction Report - lists individual cash transactions for a date range.
- Daily Cash Report - summarises receipts taken each day.
- Daily Charge Report - summarises charges posted each day.
Related Articles
Comments
0 comments
Please sign in to leave a comment.