Daily Payroll Summary

Owned by Julie Leake (Unlicensed)
Last updated: Jul 05, 2019 by mhigginbotham (Unlicensed)

The Daily Payroll Summary provides a property-wide summary of paid hours and standard hours, and the variance between the two in three categories: Today, Payroll Period-to-Date and Month-to-Date. This report summarizes the use of hours, as related to established task standards, by labor category, department, division and total property. It also sums data by payroll period and month-to-date hours to help you in long range labor evaluation and strategizing. The report can be run to show dollars or hours. The dollars are calculated using the average wage input during job configuration.

  Click image to view a sample of this report.

Key information

  • Provides a list of the selected hourly positions, departments, or divisions.
  • Compares paid hours to standard hours. Variances are displayed in percent form.
  • Evaluates property performance as a whole, in terms of paid to standard hours, on a daily, payroll period, and month-to-date basis.
  • Pulls data from your time and attendance system and the LMS generated standards.


Configuration options for the Daily Payroll Summary report

OptionDescription

Mode

Determine whether the information is filtered by Division/Department or by Operating Code.

  • Division/Department—Display employees by Division(s) and Department(s).
    • Summarize By—Choose the level of detail displayed in the report.
  • Operating Code—Generate a report that displays operating codes. For example, chefs from three different departments can be included in the report as compared to having to look at three different department reports.

Date

Designate the time period for the report.

Units

Choose whether the report totals display as hours or costs.

Running the report

To run the report:

  1. Choose Labor from the Reports menu.
  2. Click Analysis and select Daily Payroll Summary. The Options dialog box appears.
  3. Select a Mode.
    • If Division/Departments selected:
      • Choose the appropriate Division and Department.
      • Choose the appropriate summarization method you want to use, in the Summarize By field.
    • If Operating Codeis selected
      • Choose the appropriate code.
  4. Designate the appropriate Date by entering a date, clicking the calendar icon and selecting a date or using the date forward and date backward arrows.
  5. Select either Hours or Costs in the Units field.
  6. Click the Run icon. The report is displayed.

Report Terms & Definitions

TermDefinition

Today             

Summarizes the hours paid for each position (or department or division) as well as the standard hours. The Variance % column contains the difference between actual hours and standard hours as a percentage. A positive number indicates that actual hours were greater than standard hours. This column also contains the variance percentage between actual hours and standard hours.

  • Actual—Displays actual hours worked.
  • Standard—Displays the LMS generated standards.
  • Variance %—Displays the variance percentage between actual hours and standard hours.

Period-to-Date

Summarizes the actual and standard hours for the current payroll period. For example, if your current pay period began on the 5th and today is the 12th, your data will be for the seven days between the 5th and 12th. The variance column contains the difference between actual hours and standard hours. A positive number indicates that actual hours were greater than standard hours.  This column also contains the variance percentage between actual hours and standard hours.

  • Actual—Displays actual hours worked.
  • Standard—Displays the LMS generated standards.
  • Variance %—Displays the variance percentage between actual hours and standard hours.

Month-to-Date

Displays the actual and standard hours used for the month. The variance column contains the difference between actual hours and standard hours.  A positive number indicates that actual hours were greater than standard hours.  This column also contains the variance percentage between actual hours and standard hours.

  • Actual—Displays actual hours worked.
  • Standard—Displays the LMS generated standards.
  • Variance %—Displays the variance percentage between actual hours and standard hours.


Related topics: