Skip to main content

How to use Payroll Analytics

Updated

Report Overview

The Payroll Analytics report provides comprehensive insights into labor costs and staffing efficiency by integrating data from connected payroll software with key hotel revenue metrics. 

This report helps in analyzing payroll percentages, comparing actual staffing against operational forecasts, and evaluating departmental labor costs.

⚠️ Prerequisites This section is only available if your property has connected its payroll software. Currently, Revenue Intelligence supports connections with compatible third-party payroll software systems such as Planday, Fourth, and Rotor Cloud.

 

Access Payroll Analytics

  1. Click on the Analytics tab in the Main menu.
  2. Select Payroll from the dropdown menu.

 

Analytics Page Settings

  1. Choose one or more properties using the "Property Selector" to display metrics.
  2. Select your preferred time frame from the preset options using the "Date Range Selector" to analyze data from different historical date ranges.
  3. Use the "Dashboard Settings" to display the desired departments and last year's comparison:
    • Last year comparison:
      • Last Year by Day: Default option, comparing day-to-day (e.g. Monday to the closest Monday last year).
      • Last Year by Date: Comparing date-to-date (e.g. 25 December 2025 to 25 December 2024).
    • Last years: 1 year ago or 2 years ago.
    • Forecast: "Show forecast" is unchecked by default.
    • By department type: Payroll Provider Departments or Hotel Departments.

You have the option to group dates by Day, Week, or Month to see totals charts, as well as have a table view of data, by selecting these options:

Review Payroll Summary and Performance

  1. Examine the Payroll Summary for a breakdown of total payroll per department.
  2. Use the Costs, Hours, Payroll %, and Housekeeping section to compare these metrics across all applicable property departments for the selected period.

 

Analyze Departments and Employee Groups

  1. View the Departments graphic, which displays data for different departments set in the PMS.
  2. To get a closer overview, select one department from the "Departments" graphic to display data in the "Employee Group" card. These groupings are defined in your payroll platform.
Payroll analytics - Departments and Employee Group sections.gif

 

Tips & Best Practices

  • Utilize this report for staffing optimization and forecasting by comparing scheduled staffing against forecasts to identify potential over-staffing or under-staffing.
  • Gain detailed departmental and employee group insights, including specialized metrics such as housekeeping time per room and cost per room, by combining payroll data with PMS data.
  • Calculate payroll percentage (labor costs relative to revenue) to understand the proportion of revenue going into payroll costs.
  • Define hotel departments in settings to group payroll items from your payroll system (e.g., chefs and restaurant staff) and compare them to specific revenue lines (e.g., F&B revenue).
  • Input an "on-cost percentage" if your payroll system doesn't provide tax figures, to get a rough estimate of total expected costs.
  • Load budgets per department to compare actual performance against your financial targets.
  • This feature is primarily reserved for bigger organizations who need this type of functionality.