Using the Income and Expenses Sheet in the Hospitality Workbook

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 pre-requisite 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.

Pre-Requisites 

  1. Subscription Tier: 
    • Enterprise Only
      • Please get in touch with your Client Success Manager if you wish to upgrade your subscription to access the Valcre Hospitality template. 
  2. Downloaded Hospitality Template from the Online App | Database
  3. Set up the Hospitality Valuation Workbook & complete all previous sheets. 

Table of Contents

  1. Video
  2. How-to Guide

 

Video

 

How-to Guide

Step 1: Access the Revenue and Expenses sheet by selecting H_IE_IN from the bottom or left-side menu. 

This sheet is set up to allow you to input data for: 

  1. Revenue History
  2. Operated Department Expenses History
  3. Undistributed Expenses History
  4. Fixed Expenses & Costs History

 

Revenue History

Step 1: Identify 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.

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

Note: Operators Pro Forma - this is not the year one forecast you would have in the Operations sheet 

Pro-Tip: The tables on this sheet do not have a Word file for your Word Report but feed into the Revenue and Operating History sheet, which can be added to your Word Report

 

Step 4: 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, Other Operated Departments, and Rentals & Others.  You can adjust them as necessary.

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

Note: Operators Pro Forma - this is not the year one forecast you would have in the Operations sheet 

Pro-Tip: The tables on this sheet do not have a Word file for your Word Report but feed into the Revenue and Operating History sheet, which can be added to your Word Report.

 

Step 4: 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.

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

Note: Operators Pro Forma - this is not the year one forecast you would have in the Operations sheet 

Pro-Tip: The tables on this sheet do not have a Word file for your Word Report but feed into the Revenue and Operating History sheet, which can be added to your Word Report

 

Step 4: 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: Management Fee, Real Estate Taxes, Property Insurance, and Reserve for Replacement.  You can adjust them as necessary.

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

Note: Operators Pro Forma - this is not the year one forecast you would have in the Operations sheet 

Pro-Tip: The tables on this sheet do not have a Word file for your Word Report but feed into the Revenue and Operating History sheet, which can be added to your Word Report

 

Step 4: 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 

Step 3: Summarize the data displayed in the chart (Optional)

Step 4: Add the table to the Word Report if not already added.

Use the Insert Link feature in the Word Report to insert the table using the table name HIA_Historical, at the bottom of each table.

 

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 Revenue and Expenses sheet in the Hospitality Workbook. 


For additional questions about using the Income and Expenses or Revenue & Expense Operating History sheet in the Hospitality Valuation Workbook, please get in touch with Valcre Support using the Online Chat using Valcre Online or Valcre Mobile.

Was this article helpful?
0 out of 0 found this helpful