Hospitality Template


The Hospitality template combines some of the key metrics hospitality businesses should focus on. These metrics are split across the Hospitality Financial Metrics and Hospitality Sales Metrics pages in Spotlight.

To make the most of the template, you will need to:

  1. Source non-financial data.
  2. Assign specific report codes to key accounts.
  3. Evaluate the formulae and customise using the formula builder if necessary.
    Note: Some Hospitality businesses may measure these metrics differently due to seasonality, setup of accounts or other factors.

Non-financial data required

Most hospitality metrics require financial and non-financial data. Therefore, you will need to collate and enter the following non-financial information into Spotlight:

  • Customer satisfaction
  • Sales transactions
  • Sales enquiries
  • Staff total
  • Staff departures
  • Billable Hours

You can manually enter the data into the non-financial tab under Customise Data. Alternatively, enter the data into this Excel template and import it into Spotlight using the Excel import function on the Import tab.

Assign specific report codes to key accounts

Most report codes needed for the template are automatically assigned by Spotlight. However, for the metrics to calculate correctly you may need to assign some financial report codes manually. To do this, open Customise Data and locate the following accounts, then to assign the specified report code click the report code button:

  • Direct Wages - EXP.COS.WAG (Expenses > Cost of goods sold > Direct wages)

Hospitality Financial Metrics

Average Revenue per Transaction

average revenue per transaction2

Formula: Trading Revenue / Sales Transactions

Report codes used: TRA.REV, SAL.TRA

Average Revenue per Seated Hour

average revenue per seated hour

Formula: Trading Revenue / Time - billable

Report codes used: TRA.REV, TIM.BIL

Food Cost to Revenue

food cost to revenue

Formula: (Cost of Goods Sold - Direct Wages) / Trading Revenue * 100

Report codes used: EXP.COS, EXP.COS.WAG, TRA.REV

Labour Cost to Revenue

direct wages cost to revenue3

Formula: Direct Wages / Trading Revenue * 100

Report codes used: EXP.COS.WAG, TRA.REV

Current Ratio Trend

current ratio trend

Formula: Current Assets / Current Liabilities

Report codes used: ASS.CUR, LIA.CUR

Hospitality Sales Metrics

Sales Transactions

sales transactions2

Formula: Sales Transactions

Report codes used: SAL.TRA

Customer Satisfaction

cs rating2

Formula: Customer Satisfaction

Report codes used: OPR.CSR



Formula: Sales Enquiries

Report codes used: SAL.ENQ

Staff Turnover

staff turnover

Formula: Staff Departures [Past 11 months] / Average staff total [Past 11 months] * 100

Report codes used:  STA.DEP, STA.TOT

Still need help?
Get in touch!