Interactive Hotel Profit & Loss Financial Dashboard

Description
Interactive Hotel P & L Finance Dashboard:
This dashboard will help navigate the financial performance of your hotel with ease. Great visual graphs will aid in seeing key business trends easily and quickly compared to the budget in a flash.
The workbook contains the key below sheets:
1. Main menu: Buttons setup to navigate to your desired sheet in a flash
2. Dashboard: Visualize hotel financial performance and view KPI performances and key deviations just by selecting the month. Not only numbers vs. budget but also see interactive graphs to further visualize key segment lines and track their performance vs. budget
3. Dynamic USAH: be able to view full hotel P & L for any month in one sheet simply by selecting the month and instantly view hotel month and year-to-date performances vs. budget
4. Only 2 sheets need to be updated with your data: your actual / forecast figures in the input actual / forecast and your budget figures in the input budget sheet


This workbook also contains user guide sheet detailing step by step usuability and functionality of the various sheets included in the workbook for ease of understaning and use of the workbook


Sit back and visualize financial analysis and visualization to the next level!