Hotel Profit and Loss statement for December 2023 showing actual vs. budgeted revenue and expenses.

Dynamic Hotel USAH Profit & Loss Report:

This report will enable you to track your monthly Hotel Profit & Loss reports to see Actual/Forecast performance versus budget for both Month-to-Date and Year-to-Date.

The USAH Profit & Loss report also includes key ratios as below:

– Rooms Available
– Rooms Occupied
– Occupancy Percentage
– Average House Rate (AHR)
– Revenue Per Available Room (RevPAR)
– Rooms Profitability Percentage
– Food & Beverage Profitability Percentage
– Other Operating Department Profitability Percentage
– Energy Costs Per Available Room
– Energy Costs Per Occupied Room
– Gross Operating Profit Percentage
– EBITDAR Percentage
– EBT Percentage
– Net Operating Profit Percentage

Visual graphs will aid in seeing business trends and help with key decision-making.

This template is simple and easy to use with the following steps below:

– Input Actuals / Forecast: In this sheet input your monthly actuals or forecast
– Input Budget: In this sheet input your monthly budget
– Dynamic USAH Report: Simply select the month from the drop down list to instantly see your Hotel P & L for the month to date as well as year to date
– Graphs dashboard: Covers visuals for key amounts and figures such as revenues and ratios as below:

– 1st Graph: Toggle from the drop-down list to view the following:
Rooms Revenue
F & B Revenue
M & E Revenue
OOD Revenue
Total Revenue
AHR
RevPAR

– 2nd Graph: Toggle from the drop-down list to view the following:
Occupancy
Rooms Profit
F & B Profit
OOD Profit
GOP
EBITDAR
EBT
NOP

Sit back.. Relax and get on top of your Hotel’s Financial performance!