The Daily Charge Report shows charges raised against General Ledger Account Codes for a seven day period, grouped by GL Acc Code, Area Grouping or Area Detailed.
Overview
The Daily Charge Report identifies charges raised against General Ledger Account Codes (GL Acc Code) and is not influenced by Receipts posted. The charge totals indicate the rise in debtors for any given period.
The report displays one row per GL Acc Code (or per Area, depending on the selected grouping) with separate amount and tax columns for each of the seven days following the selected start date. A Grand Total row sums every row across all seven days.
Use Cases
- Daily revenue review - Run the report each morning to see the charges that posted in the previous day, grouped by GL Acc Code.
- Weekly chart of accounts reconciliation - Use the seven day totals to reconcile charge revenue back to the property's chart of accounts.
- Multi-property consolidation - For enterprise databases, tick Group By Property to see each property's charges separately within a single run.
- Area-level analysis - Switch to By Area Grouping or By Area Detailed to see charges by physical area rather than by GL Acc Code.
How to Access
In the side menu of RMS, go to Reports > Accounting > Daily Charge.
Guide
- Select Seven Day Breakdown or Date Range, and set the required date range.
- Select the Category.
(Optional) Select the Loyalty Membership Type.
(Optional) Select a Group By option. - Select By GL Account Code, By Area Grouping or By Area Detailed.
(Optional) Select Group By Property. - Select Build.
Report Options
| Report Option | Type | Default | Description |
|---|---|---|---|
| Seven Day Breakdown | Radio + Date | Selected | Reports charges for the seven days starting from the selected date. This is the default mode. |
| Date Range (CSV Export Only) | Radio + Date range | Not selected | Reports charges for a custom date range. Output is available only when exporting to CSV. |
| Category | Multi-select | None selected | Restricts the report to charges raised on selected Categories. Leave as None Selected to include all categories. |
| Loyalty Membership Type | Multi-select | None selected | Restricts the report to charges raised on reservations linked to selected loyalty membership types. |
| By GL Account Code | Radio | Selected | Groups the report by General Ledger Account Code. This is the default report-by mode. |
| Group By | Dropdown | No Grouping | Adds a secondary grouping under each GL Account Code. |
| By Area Grouping | Radio | Not selected | Groups the report by Area Grouping rather than by GL Account Code. |
| By Area Detailed | Radio | Not selected | Groups the report by individual Area, providing the most detailed breakdown. |
| Group By Property | Checkbox | Unticked | For multi-property databases, separates totals per property within the same report. |
| Property | Multi-select | Current property | Limits the report to the selected properties. Shown on multi-property (Enterprise) databases only. |
Column Headers
| Column | Description | Source / Calculation |
|---|---|---|
| Description | The name of the GL Acc Code, Area Grouping or Area, depending on the selected report-by mode. | GL Acc Code description (see General Ledger Account Codes), or the Area Grouping / Area name when run in an Area mode |
| GL Code | The General Ledger Acc Code identifier. Shown when the report is run by GL Acc Code. | GL Account Code setup |
| Amt (per day) | Total charge amount raised against the row for that day, excluding tax. One column per day across the seven day window. | Sundry charge per night |
| Tax (per day) | Total tax amount on the charges raised for that row on that day. One column per day across the seven day window. | Calculated |
| Total Amt | Sum of the Amt columns across all seven days for that row. | Calculated |
| Total Tax | Sum of the Tax columns across all seven days for that row. | Calculated |
| Grand Total | Final row that sums every row above for each daily and total column. | Calculated |
Data Sources & Calculations
The following concepts govern the data shown in this report.
Charges vs Receipts
Every Amt and Tax column on this report counts charges raised, not money received. The report is not influenced by receipts posted, so its totals represent the rise in debtors for the period. To see the receipts side of the same period, run the Daily Cash Report, which identifies receipts allocated to charges by GL Acc Code.
General Ledger Account Codes
Each charge posted in RMS is assigned to a General Ledger Account Code. The Description and GL Code columns, and the row grouping of every daily Amt and Tax column, come from that assignment. When the report is run By Area Grouping or By Area Detailed, the rows group by Area instead and the same charge amounts are redistributed across the physical areas they were raised against.
Related Reports
- Daily Cash Report - Receipts allocated to charges, grouped by GL Acc Code, for the same seven day window.
- Cash/Charge Report - Combined cash and charge totals across a custom date range, grouped by GL Acc Code.
- Cash Transaction Report - Receipts grouped by payment method rather than by GL Acc Code.
Comments
0 comments
Please sign in to leave a comment.