Applies to:          Stayntouch PMS          

Comparison To Budget Report

OVERVIEW

To complete our Budgets functionality, we’ve added a Comparison to Budget Report to show statistical and forecasted comparison to budget data by date range.

Items to Note:

• This report only pulls budget data for markets, not charge codes.
• You need to be using the Budgets functionality from Financials > Budgets. (Enable the BUDGETS toggle from Settings > Financials > Financial Settings and assign necessary user roles the Financials Budgets permission from Settings > Hotel & Staff > Permissions.)

REPORT FILTERS

REPORT OUTPUT

The Comparison to Budget Report can be printed, and it will appear in the Reports Inbox as pictured below. 

You will see the following fields on the report:

• Variance Toggle: The variance toggle is labeled % / ACTUAL and allows the user to view the variance in either percentage to budget or the actual amount to budget. Positive variances will always be green, and negative variances will always be red. By default, the variance toggle will be by percentage to budget (%).
• View Toggle: The view toggle is labeled SUMMARY / DETAILS. The SUMMARY view shows the user the variance to budget for each category. The DETAILS view expands the report, and the user is able to view each category’s variance, actuals, and budgeted numbers.
• Header: Total nights, total nights variance to budget, average occupancy, average occupancy variance to budget, total revenue, total revenue variance to budget, average ADR, average ADR variance to budget.
• Report with variance toggle set to DETAILS:
  • First column titled Markets
• Each market selected in the report configuration will be listed in the Markets column.
• The next columns in the report are tilted NIGHTS, OCCUPANCY, REVENUE, and ADR. Each of these columns are subdivided into three columns: DIFF. (variance), ACTUAL, and BUDGET for each market.
• Each row in the Markets column displays data related to NIGHTS, OCCUPANCY, REVENUE, and ADR for that corresponding market for the date range selected. Each of those columns is subdivided into three columns: DIFF. (variance), ACTUAL, and BUDGET for each market.
• NIGHTS
  • ACTUAL: The number of rooms occupied for the given date(s).
  • BUDGET: The number of rooms budgeted for the date(s).
  • DIFF. (as a currency amount): Actual room nights minus budgeted room nights for the date(s).
  • DIFF. (as percentage): Actual room nights minus budgeted room nights divided by budgeted room nights multiplied by 100 (rounded to the nearest 10th of a percent) for the date(s).
• OCCUPANCY
  • ACTUAL: The number of rooms occupied for the given date(s) divided by the total number of rooms for the date(s) (rounded to the nearest 10th of a percent).
  • BUDGET: The number of rooms budgeted for the given date(s) divided by the total number of rooms for the date(s) (rounded to the nearest 10th of a percent).
  • DIFF. (as a $): Actual occupancy minus budget occupancy for the date(s).
  • DIFF. (as a % ): Actual occupancy minus budget occupancy divided by budgeted occupancy multiplied by 100 (rounded to the nearest 10th of a percent) for the date(s).
• REVENUE
  • ACTUAL: The room revenue for the given date(s).
  • BUDGET: The budgeted room revenue for the date(s).
  • DIFF. (as a $ ): Actual room revenue minus budgeted room revenue for the date(s).
  • DIFF. (as % ): Actual room revenue minus budgeted room revenue divided by budgeted room revenue multiplied by 100 (rounded to the nearest 10th of a percent) for the date(s).
• ADR
  • ACTUAL: Room revenue divided by rooms occupied.
  • BUDGET: Budgeted room revenue divided by budgeted rooms occupied.
  • DIFF. (as a $ ): Actual ADR minus budgeted ADR for the date(s).
  • DIFF. (as % ): Actual ADR minus budgeted ADR divided by budgeted ADR multiplied by 100 (rounded to the nearest 10th of a percent) for the date(s).
• If the report range is 14 days or less, the daily summary of the report will be shown. If the report range is 15 days or greater, the daily summary will not display.
• The daily summary will have the same layout and calculations as the market segment, except instead of each row displaying calculations based on a market’s data, each row will display each day’s total figures from all markets selected from the report configuration (including undefined) for each day within the report’s date range.
• When the view toggle is switched the SUMMARY, the sub-columns for NIGHTS, OCCUPANCY, REVENUE, and ADR will not show, and the data shown will only be the variances.

REPORTS INBOX

PRINT REPORT