The Rent Roll Report is a report that lists each in-house and forward-booked reservation in the selected date range with a single-row summary of revenue, charges, deposits, receipts and the current account balance.
Overview
The Rent Roll Report is a Financial Revenue report which provides a snapshot of all reservations active in a chosen date range, summarising the financial position of each reservation on a single line. It is typically used by finance teams and property managers to review accommodation revenue, Deposits, Receipts and reservation account balances at a glance, and to reconcile guest accounts on a daily, weekly or monthly basis.
The report uses the standard RMS report viewer and supports printing, emailing and exporting (PDF, Excel, CSV).
When to Use This Report
The Rent Roll Report is useful when you need to:
- Produce a daily or end-of-period snapshot of reservations and their financial position.
- Review accommodation revenue, sundry charges, discounts and tax across active reservations in a single view.
- Identify reservations with unpaid balances or unreceipted deposits.
- Reconcile receipts and deposits against charges for a date range.
- Sort reservations by Reservation Number, Area or Arrive Date for audit and review purposes.
- Filter the report to a specific Category (or set of Categories) to focus on one part of the property.
Prerequisites
Before running the Rent Roll Report, ensure that:
- The user has access to Reports > Management > Financial in their Security Profile.
- Reservations exist in the date range being reported on.
- Categories are set up and assigned to the reservations you want to include.
- Charges, Receipts and any applicable Discounts have been raised against the reservations as part of normal day-to-day operations - the report summarises whatever has been posted to each Reservation Account.
Guide
In the side menu of RMS, go to Reports > Management > Financial > Rent Roll.
- Select the Date Range.
- Select the Category.
- Select a Sort By option.
- Select a Revenue By option:
- Select Build.
Report Options
The following parameters are available on the Report Options panel.
| Option | Description |
|---|---|
| Date | The date range to report on. Defaults to today; supports any custom range. |
| Category | One or more property Categories to include. Defaults to All Selected. |
| Sort By | The sort order for rows in the report. Options: Reservation No (default), Area, Arrive Date. |
| Revenue By | Determines how revenue is calculated across the date range. Options: Total (default) or Pro Rata. |
Report Columns
The Rent Roll Report includes the following columns, listed in display order from left to right.
| Column | Description |
|---|---|
| Res No | The Reservation Number assigned by RMS to the booking. |
| Arrive Date | The arrival date of the reservation. |
| Depart Date | The departure date of the reservation. |
| Name | The guest name on the reservation. |
| Area | The Area allocated to the reservation. |
| Accomm Revenue | The accommodation revenue for the reservation in the selected date range. Calculated as Total or Pro Rata based on the Revenue By option. |
| Other Charges | Sundry and other (non-accommodation) charges raised on the reservation in the selected date range. |
| Discount & Credits | Discounts and credits applied to the reservation account in the selected date range. |
| Tax Charges | The tax portion of charges on the reservation in the selected date range. |
| Total Res Charges | The total of charges raised on the reservation account in the selected date range. |
| Initial Deposit | The initial deposit recorded against the reservation. |
| Receipts | Receipts (payments) allocated to the reservation in the selected date range. |
| Current Balance | The current balance on the reservation account at the time the report is built. |
Related Articles
- Reservation Accounts
- Monthly Income Summary Report
- Cash/Charge Report
- Financial Revenue
- Scheduled Reports
Comments
0 comments
Please sign in to leave a comment.