This guide provides information on Guestline Insights Posted Revenue and Additional Spend report metrics and their equivalent data sources in Guestline Rezlynx PMS.
⚠️ Important: Actual revenue reporting works best in both Insights and Rezlynx PMS when properties make use of system date and preconfigured fiscal periods. You would also be able to take advantage of scheduled day-end functionality to automate the closing of fiscal periods.
Posted Revenue & Additional spend totals and breakdowns
Rezlynx equivalent report and navigation to report: | Detailed period end extracts. Navigate to: Accounting, Period End, Period End Archive, then select Detailed Extract for the required period. |
Rezlynx report filter setting: |
|
Rezlynx report column: | BookRef (Total row). |
Instructions to aid comparison: | Click Detailed Extract to export to CSV. Compare total counts directly to Insights. |
PMS report is cross-property - in group mode: | Yes. |
Exceptions: | No media course filter. No channel filtering. |
Alternative reports: | Actual & Forecast report. |
All items in this section are used to construct Posted revenue & Additional spend totals and breakdowns. Insights currently shows only Net revenue totals, so you will need to compare values in the Nett Total column of the detailed extract to Insights reports. You can further take advantage of Pivot Table functionality in Excel to evaluate breakdowns of these totals, for example by Package Code or Market segment.
If your site uses preconfigured fiscal periods & system date: you can directly compare daily & date range totals, filtering on the TimeStamp column in the detailed extract. The Actual & Forecast report's revenue columns should also match exactly.
If your site does not use preconfigured fiscal periods & system date: in most cases you will be able to use the Actual & Forecast report to compare revenue totals. The ForDate column of the detailed extract can be used to filter on specific dates, but be aware that revenue from Deposits Retained due to cancellations will show with the date "1899-12-31"; you will have to use the timestamp column for such transactions instead.
Total Bookings, Average Daily Rate and RevPAR
Rezlynx equivalent report and navigation to report: | Actual & Forecast report. Navigate to: Reports, Revenue, then Actual & Forecast.
|
Rezlynx report filter setting: |
|
Rezlynx report column: | BookRef (Total row). |
Instructions to aid comparison: | Open Actual & Forecast report for required period. Optional: filter Insights to include only revenue from Bedroom booking types in calculations. Compare values directly to Insights.
|
PMS report is cross-property - in group mode: | Yes. |
Exceptions: | No media course filter. No channel filtering. |
Alternative reports: | Actual and Forecast report. |