Report on the number of Sundry Charge units sold within a specific date range.
Overview
The Sundry Usage Report provides a summary of Sundry Charges used for the selected date range.
The Sundry Usage Report includes the Report Type options of Detailed and Summary.
Please Note! Users will be prompted to select 'Export to CSV' if the Detailed Report Type is selected and more than 9,000 transaction records exist for the selected date range.
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
- Reconcile sundry sales - Run over a period to list every Sundry Charge posted, with quantity and amount, to reconcile incidental revenue.
- Review a single sundry - Filter to one Sundry Charge to see how many units were sold and the total value over the period.
- Handle large exports - Use the Detailed type with Export to CSV when a period has more than 9,000 transactions.
Report Options
The options below appear on the Sundry Usage Report parameter panel. Additional options are available by clicking More Options.
Tip! Report build screens default to a common use configuration, and selections can be made as required.
| Report Option | Type | Description |
|---|---|---|
| Transactions Between | Date range | The date range used to select the Sundry Charge transactions to include. |
| Report Type | Radio |
Sets the level of detail:
|
| Sort By | Dropdown | Sets the sort order of the Detailed report. Options include Trans Id, Name, Area, Account No and Date. |
| Group By | Dropdown | Sets how the report groups the results. Options include Sundry, Surname, Property, Account No. |
| Show Associated Discount Transactions | Checkbox | On the Detailed report, includes the transaction record of any Discount associated with the Sundry Charge. |
| Include Voided Transactions | Checkbox | Includes Sundry Charges created in the period that were later voided, changing the reported Quantity and Amount. |
| Sundries | Multi-select | Limits the report to the selected Sundry Charges. |
| Property | Multi-select | For multi-property (Enterprise) databases. Limits the report to the selected Properties. |
| Loyalty Membership Type | Multi-select | Limits the report to reservations with the selected Loyalty Membership Types. |
How to Access
In the side menu of RMS, go to Reports > Accounting > Sundry Usage.
- Select a Date Range.
(Optional) Select a Sundry Charge. - Select the Report Type.
(Optional) Select a Group By option (Optional).
(Optional) Select the checkbox 'Show Associated Discount Transactions'.
(Optional) Select the checkbox 'Include Voided Transactions'. - Select Build.
Column Headers
The Sundry Usage Report includes the following information.
| Report Column | Description |
|---|---|
| Detailed | |
| Description | Sundry Charge Description. |
| Transaction ID | Unique identifier of the transactions record. |
| Date | Accounting Date is the transaction date (Financial Revenue date) when the Sundry Charge was created on the account. |
| Account Number | Account Number the Sundry Charge was created on. |
| Reservation Number | Reservation Number associated to the Account where the Sundry Charge was created. |
| Area | Area associated to the Reservation of the Account where the Sundry Charge was created. |
| Guest Name | Primary Guest's full name from the Reservation of the Account where the Sundry Charge was created. |
| User | Username of the user that created the Sundry Charge on the Account. |
| Quantity | Quantity entered when the Sundry Charge was created on the Account. |
| Amount | Total value of the Sundry Charge created on the account. |
| Summary | |
| Description | Sundry Charge Description. |
| Quantity | Total quantity entered for all Sundry Charges created on accounts in the selected period. |
| Amount | Total value for all Sundry Charges created on accounts in the selected period. |
Information
• By selecting Show Associated Discount Transactions, the report will include the transaction record of any Discount associated to the Sundry created on the account on the Detailed Report Type.
• By selecting Include Voided Transactions, the report will change the Quantity and Amount reported to include any Sundry Charges created on an account during the selected period and have since been voided.
Related Reports
- Sundry Rental Change Report - changes made to recurring Sundry (rental) charges.
- Daily Charge Report - all charges posted for a selected date.
Related Articles
- Sundry Charges - what Sundry Charges are and how they are set up.
- Financial Revenue - the accounting basis for the transaction Date column.
Comments
0 comments
Please sign in to leave a comment.