This article describes the Bill Revenue Breakdown report, which lists invoiced bills for a selected period and breaks each bill down by revenue category alongside its settlement details.
Overview
The Bill Revenue Breakdown report shows each invoiced bill within a date range, split across revenue categories so you can see how a guest's total bill was made up.
For every bill the report lists the nights, Invoice details, Area, guest, the amount in each revenue category, the total bill amount, and how the bill was settled. Totals are subtotalled and summed at the bottom of the report.
Use Cases
- Night audit revenue reconciliation - Run the report as part of the night audit to confirm that invoiced bills reconcile against the revenue posted for the period.
- Settlement review - Review how bills were settled (for example, by payment type) to cross-check takings against expected revenue.
- Revenue category analysis - Use the per-category breakdown to see how much of each bill came from accommodation versus other charges.
- Rate type grouping - Group the report by Rate Type to compare invoiced revenue across different rate types.
How to Access
In the side menu of RMS, go to Reports > Night Audit > Bill Revenue Breakdown.
Report Options
Use the options below to set the date range, choose how reservations are matched to the period, and filter by property and rate type. The Group By and date-basis options are found under More Options.
| Option | Type | Default | Description |
|---|---|---|---|
| Date | Date range | Today | The period the report covers. Choose a preset range (for example, This Month or This Calendar Year) or a custom range. |
| Group By | Dropdown | No Grouping |
Controls how bills are grouped on the report. Options:
|
| Date basis | Radio buttons | Depart Falls Between These Dates |
Determines how a reservation is matched to the selected date range. Options:
|
| Property | Multi-select dropdown | All Selected | Filters the report to one or more properties. Appears on multi-property databases only. |
| Rate Type | Multi-select dropdown | All Selected | Limits the report to bills on the selected rate types. |
Report Columns
The columns below appear on the report output. Each row represents one invoiced bill, with the bill amount split across revenue category columns before the totals.
| Column | Description |
|---|---|
| Nights | The number of nights on the reservation the bill relates to. |
| Invoice Date | The date the invoice was generated. |
| Invoice No | The invoice number assigned to the bill. |
| Area No | The area or site the reservation was allocated to. |
| Guest | The name of the guest the bill belongs to. |
| Accommodation | The total accommodation charges on the invoice. |
| Food & Beverage | The total food and beverage charges on the invoice. |
| Expenses | The total expense charges on the invoice. |
| Miscellaneous | The total accommodation charges on the invoice. |
| Shop Sales | The total POS charges on the invoice. |
| Utilities | The total utility charges on the invoice. |
| Other | The portion of the bill posted to revenue categories not shown in their own column. |
| Bill Amount | The total amount of the bill. |
| Settlement Mode | How the bill was settled (for example, the payment type used). |
| Remarks | Any remarks recorded against the bill. |
Related Reports
- Bill Settlement - shows how bills were settled, useful alongside the settlement detail in this report.
- EOD Report - end of day report used during the night audit process.
- Night Audit - the main night audit report and its breakdown.
Comments
0 comments
Please sign in to leave a comment.