This article describes the Charges By Category report, which shows the total value of charges posted during a selected date range, grouped by Category and subtotalled by General Ledger Account Code.

Overview

The Charges By Category report groups charge transactions posted within a selected date range by Category, then subtotals each Category by the General Ledger Account Code the charges were posted against.

It gives a property a category-level breakdown of charge activity, which is useful for reconciling postings against the general ledger or comparing charge activity across different accommodation types.

The Charges by Category report includes both accommodation charges and Sundry charges, not just accommodation charges alone. Non-accommodation charges (such as minibar, parking, POS postings, package add-ons, or incidental fees) posted to reservation accounts linked to the category are also captured in the totals for that category.

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

• End-of-period reconciliation - the accounts team runs this report at the end of a reporting period to see how much has been charged against each Category, broken down by General Ledger Account Code, before reconciling to the general ledger.
• Comparing charge activity across accommodation types - a property compares the report's Category sections to see which accommodation types are generating the most activity against a particular General Ledger Account Code, such as Food & Beverage or another Sundry charge type.

How to Access

In the side menu of RMS, go to Reports > Management > Financial > Charges By Category.

Report Options

The report options below control which transactions are included on the report and how they are filtered by Category.

Report Output

Charges By Category does not produce a column/row table. It renders as a statement-style summary, in this order:

• The property name and the report title, followed by the applied date range.
• One section per Category that has charge activity in the selected date range (Categories with no activity are omitted, not shown with a zero subtotal).
• Within each Category section, one line per General Ledger Account Code that charges were posted against, showing the GL code and account name on the left and the total amount on the right.
• A Sub Total line for the Category.
• A single Grand Total line at the end of the report, summing all Category sections.
• A footer showing when the report was generated, who generated it, and the page number.

Data Sources & Calculations

The following concepts govern how the report groups and totals charges.

Category

Each reservation, and the Area it is booked into, belongs to a Category, configured under Setup > Category Setup. The report groups charge transactions by the Category of the reservation or Area the charge was posted to.

General Ledger Account Code

Every charge is posted against a General Ledger Account Code, configured under Setup > Accounting > GL Acc Codes. Within each Category section, the report subtotals charges by the GL Account Code they were posted against, so a Category with charges posted to several different GL Account Codes shows one line per code

Please Note! Categories with no charge activity in the selected date range are left off the report entirely - they do not appear with a zero Sub Total.

Related Reports

• Cash/Charge Report - shows charge and cash transaction activity for a period.
• Facility Usage and Revenue Report - shows usage and income for Facility Categories over a date range.

Related Articles

• Category/Categories
• Set up General Ledger Account Codes