Hotel Financial Report

This report displays a base dataset and three comparative datasets with variances between the comparatives and the base, % of Line and POR or PAR statistics for the selected datasets, for a single period. An optional flow through calculation appears at the bottom of the report.

The lines displayed on the report are configured in the Report Builder.

Click the image to view a sample report.

Formulas

• Flow through calculation = Value 1 (sum of all lines with a tag of "value1") ÷ Value 2 (sum of all lines with a tag of "value2").
  Conditions:
  • If Values 1 and 2 are both positive, flow through = Value 2 ÷ Value 1
  • If Values 1 and 2 are both negative and Value 2 is greater than Value 1, flow through = 1 - (Value 2 ÷Value 1)
  • If Value 1 is negative and Value 2 is positive, flow through = 1 - (Value 2 ÷ Value 1)
  • If Values 1 and 2 are both negative and Value 2 is less than Value 1, flow through = -(Value 2 ÷ Value 1)
  • If Value 1 is positive and Value 2 is negative, flow through = Value 2 ÷ Value 1 - 1
  • If Values 1 and 2 are negative and Value 1 is equal to Value 2, flow through = 0.0.
• POR/PAR = (total dollars for each budget line) ÷ (total occupied rooms/available rooms)
• Variances = (base - comparative) ÷ comparative × 100

Report Options

Related topics:

• Labor Reports
• T&A Reports
• Budgeting Reports
• Revenue Reports