Hospitality: Using the Revenue and Expense Categories Sheet
Jen McGee
This sheet allows you to report the history for the chart of accounts for the subject and report all the departments' revenue and expenses. This sheet is a prerequisite for the Revenue + Expense Operating History sheet.
This guide shows you how to use the Revenue and Expense and Revenue and Operating History sheets in your Hospitality Workbook.
Step 1: Review the Revenue and Expense categories enabled by default and update as needed
Use the yellow-shaded cells to update category names or add new categories if needed
Make sure to update the dropdowns to the right of the category names to enable or disable the category
Revenue History
Step 1: Start by entering the ADR, Occupancy, and RevPAR for your subject property at the top of the Operations section
The Rooms row will populate using your Subject Property’s unit count
Use the dropdowns at the top of this section to hide the columns for any unused years from the presentation table on the next sheet (H_IE)
Step 2: Select whether you want to present Trailing Twelve Months values or Year to Date values
Step 3: Review the Assigned Revenue Names you will be using
We default to standard revenue names: Rooms, Food & Beverage, Other Operated Departments, and Rentals & Others.
You can adjust them as necessary in the table at the top of the sheet.
Step 4: Enter the borrower's information, and those items are associated with the chart of accounts.
If the borrower has multiple line items associated with the Assigned Revenue Name, select the same Assigned Revenue Name again in the appropriate blue field.
Step 5: Enter the historical data for each line item
Step 6: Enter the Budget
Pro-Tip: The tables on this sheet do not have link names for your Word Report, but feed into the Revenue and Operating History sheet, which can be added to your Word Report.
Step 7: Enter your summary of conclusions for this section (Optional)
Use the yellow box at the top of the table to enter your summary for the reader.
Operated Department Expenses History
Step 1: Identify the Assigned Expenses Names you will be using.
We default to standard revenue names: Rooms, Food & Beverage, and Other Operated Department
You can adjust them as necessary in the table at the top of the sheet.
Step 2: Enter the borrower's information, and those items are associated with the chart of accounts.
If the borrower has multiple line items associated with the Assigned Expenses Name, select the same Assigned Revenue Name again in the appropriate blue field.
Step 3: Enter the historical data for each line item
Step 4: Enter the Budget
Pro-Tip: The tables on this sheet do not have link names for your Word Report, but feed into the Revenue and Operating History sheet, which can be added to your Word Report.
Step 5: Enter your summary of conclusions for this section (Optional)
Use the yellow box at the top of the table to enter your summary for the reader.
Undistributed Expenses History
Step 1: Identify the Assigned Expense Names you will be using
We default to standard revenue names: Administrative & General, Info & Telecom, Marketing, Franchise, Property Operations & Maintenance, and Utility Costs.
You can adjust them as necessary in the table at the top of the sheet.
Step 2: Enter the borrower's information, and those items are associated with the chart of accounts
If the borrower has multiple line items associated with the Assigned Revenue Name, select the same Assigned Revenue Name again in the appropriate blue field.
Step 3: Enter the historical data for each line item
Step 4: Enter the Budget
Pro-Tip: The tables on this sheet do not have link names for your Word Report, but feed into the Revenue and Operating History sheet, which can be added to your Word Report.
Step 5: Enter your summary of conclusions for this section (Optional)
Use the yellow box at the top of the table to enter your summary for the reader.
Fixed Expenses & Costs History
Step 1: Identify the Assigned Revenue Names you will be using
We default to standard revenue names: Real Estate Taxes, Property Insurance, and Reserve for Replacement.
You can adjust them as necessary in the table at the top of the sheet.
Step 2: Enter the borrower's information, and those items are associated with the chart of accounts.
If the borrower has multiple line items associated with the Assigned Expense Name, select the same Assigned Expense Name again in the appropriate blue field.
Step 3: Enter the historical data for each line item
Step 4: Enter the Budget
Pro-Tip: The tables on this sheet do not have link names for your Word Report, but feed into the Revenue and Operating History sheet, which can be added to your Word Report.
Step 5: Enter your summary of conclusions for this section (Optional)
Use the yellow box at the top of the table to enter your summary for the reader.
Revenue and Operating History Sheet
This table will include the Revenue and Expense information provided in the Revenue and Expenses sheet.
Step 1: Access the Revenue and Operating History
Select H_IE from the bottom or left-side menu.
Step 2: Review the data
The data will be broken out into two separate tables:
Step 3: Summarize the data displayed in the charts (Optional)
Use the yellow boxes above the tables to enter your summary for the reader.
Step 4: Add the tables to your Report, if not already added.
Use the Insert Link feature to insert the tables using the names below each table:
HIA_Historical
HIA_Historical2
Once you have completed all necessary information in the Income and Expenses sheet and reviewed the Revenue & Expense Operating History sheet, you can move on to the STR Profitability Reportsheet in the Hospitality Workbook.
Additional Questions? Valcre Support is ready to help with all your Valcre product questions! You can connect to us via phone, email, or chat!
Comments
0 comments