Guestline has a New Actual and Forecast report within the system with lots of additional features.
Overview of the report
The Actual and Forecast report is a summary report, providing the ability to report on both actual revenue and forecast revenue in one report. The Actual & Forecast Report is used to view Actual & Forecasted revenue by the main three revenue types:
Accommodation
F & B (food and beverage items)
Other - which can include, NRA, Post Cash or a manual invoice/credit raised on a Debtor account.
This report can be used to view ‘business on the books’ of how many rooms have been sold & how many are still available.
How to run the report
To run the report, follow the steps below:
Navigate to Rezlynx, Reports, and then select Actual & Forecast.
Complete any of the following fields to return the information you require:
Start date - click to type date or select icon to search the calendar to select date
End date - click to type date or select icon to search the calendar to select date
Booking Status - multi-select drop-down menu
Group / Room block status - multi-select drop-down menu
Show as - select how the values are shown Gross or Nett
Revenue - multi-select drop-down menu with selections including bedroom, function and other
Include - multi-select drop-down menu
Room type - select all or specific room types
Property - if you are part of the group you will see this option
Click the View drop-down to select the output format.
📌 Note: Export to CSV to see additional fields.
Report output
In the report output, figures above the grey line are Actual & figures below the line are Forecast. Please note that the current day will be below this line and is therefore forecasted revenue until the End of Day runs and completes the "actual" revenue taken. The output is displayed in Nett or Gross figures based on the selection made when running the report. All values are totalled at the end of the report.
Example of report output:
ARR or Average Room Rate: accommodation revenue divided by room nights sold
APR or Average rate Plan Revenue: rate plan revenue divided by room nights sold
Yield: accommodation revenue divided by (total room stock minus rooms out of service).
Additional output options:
Export to CSV with new fields
Day of Week
In Stock
Rate Plan Revenue
Blocked
Cumulative Revenue
Troubleshooting
Differences between the old Actual and Forecast Report and the new report: The old and new reports should be broadly comparable, but there can be minor discrepancies due to a difference in how the data is used. Within the new report to find more detail on a value, click the value to bring up the detail and then click the magnifying glass icon. For large discrepancies between the old and new reports, or where you suspect incorrect data, please file a bug report using the button provided within the new report.
Remove the groups revenue: when running the report select or deselect the group statuses - any selected will add to the report.
ARR not showing lower as expected: Complimentary rooms will affect the calculation of the ARR as they are still shown as rooms sold.