The Labor Actual vs Scheduled - Punch Details report runs the numbers for each employee's labor punches in a specified date range. This report helps users understand and analyze labor variances, particularly in regards to the actual punch details rather than the simple breakdown of hourly labor.
Article Topics
Navigation
- In the Reports section of the left navigation pane, select My Reports.
The My Reports screen appears. - At the top of the My Reports screen, select Labor.
The screen generates a list of reports in alphabetical order. - Locate Labor Actual vs. Standard - Punch Details.
- Select Customize to adjust the report parameters and run the report.
Report Parameters
| Field | Description | |
| 1 | Filter By | Location reporting category by which to filter the report. Options in the Filter By menu are configurable and specific to your organization. For more information, see System Preferences: Location Reporting Categories and Location Record: Reporting Categories. |
| 2 | Filter | Allows users to apply one or more filter options from the location reporting category that they selected in the Filter By menu. The selected filters determine which locations appear in the generated report. For example, if Filter By is set to Region, the Filter menu might include options such as North, South, East, and West. A user can select West to display all locations belonging to this reporting category. Options that appear in the Filter menu are configurable and specific to your organization. For more information, see System Preferences: Location Reporting Categories and Location Record: Reporting Categories. |
| 3 | Start | First date to include in the report. The Start and End fields create a date range for which to include data in the generated report. |
| 4 | End | Last date to include in the report. The Start and End fields create a date range for which to include data in the generated report. |
| 5 | Hide Job | If set to Yes, the report does not display jobs. |
| 6 | Employee | Employees to include in the report. |
| 7 | Job Code | Jobs to include in the report, by job code. |
| 8 | Report Format | If set to Collapsed, the report appears as a summary with rows that the user can expand to view more detailed information. If set to Expanded, the report displays the expanded rows by default, providing the user with a more detailed version of the report. |
| 9 | Burden | If set to Yes, burden is included in calculated labor costs. Burden is a configured percentage used to account for other costs related to the employee, such as insurance and other benefits. |
| 10 | Daily Salary | If set to Yes, the report displays the manager salary as configured in the Daily Manager Salary field on the Location record. |
| 11 | Include Penalties in Costs | If set to Yes, rule-based earnings are included in calculated labor costs. |
| 12 | Identify Minors | If set to Yes, the word 'Minor' appears next to all employees who are under a certain age. |
| 13 | Other Pay | If set to Yes, the report includes earnings that are not associated with a shift, and the Other Hrs and Other $ columns appear in the report. |
| 14 | View options | Provides the user with options to select, save, edit, or delete a report view. For more information about these controls, see My Reports: Using My Reports. |
| 15 | Run | Generates the report. The green arrow button opens a drop-down from which users can Export, Email, or Print the report.  |
Report Columns
Note: The calculations for these report columns include updates made for OT Exempt Employees.
| Column | Description |
| Collapsed | |
| Location | Location where the punch data was recorded. |
| Date | Date when the punch data was recorded. |
| Actual Hrs | Total number of actual hours worked at the location. |
| Sched Hrs | Total number of scheduled hours at the location. |
| Other Hrs | Number of other hours-based earnings that are not associated with employee shifts. This column appears only if the Other Pay parameter is set to Yes. |
| Var Hrs | Difference between actual hours and scheduled hours for the location. |
| Var Hrs (%) | Percentage of variance between actual hours and scheduled hours for the location. |
| Actual OT Hrs | Total number of actual overtime hours worked at the location. |
| Actual $ | Cost of actual labor for the location. |
| Sched $ | Cost of scheduled labor for the location. |
| Other $ | Amount for other labor costs not associated with employee shifts. This column appears only if the Other Pay parameter is set to Yes. |
| Var $ | Difference between the actual cost and scheduled cost of labor for the location. |
| Var $ (%) | Percentage of variance between actual cost of labor and scheduled cost of labor for the location. |
| Labor % | Actual cost of labor divided by total sales, shown as a percentage. |
| % Goal | Labor percentage goal for the location. |
| Var | Difference between Labor % and % Goal for the location. |
| Sales | Actual amount of sales for the location, for the given timeframe. |
| Fore Sales | Amount of forecasted sales for the location, for the given timeframe. |
| Expanded | |
| Job | Job for which the punch data was recorded. If Hide Job was set to Yes, this information does not appear in the report. |
| Employee | Employee who worked the hours shown. |
| Date | Date when the punch data was recorded. |
| Actual Hrs | Number of actual hours the employee worked the job on the given date. |
| Sched Hrs | Number of hours the employee was scheduled to work the job on the given date. |
| Other Hrs | Number of other hours-based earnings that are not associated with a shift. This column appears only if the Other Pay parameter is set to Yes. |
| Var Hrs | Difference between actual hours and scheduled hours for the employee. |
| Var Hrs (%) | Percentage of variance between actual hours and scheduled hours for the employee. |
| Actual OT Hrs | Number of overtime hours the employee worked the job on the given date. |
| Actual $ | Cost of actual labor for the employee. |
| Sched $ | Cost of scheduled labor for the employee. |
| Other $ | Amount owed to the employee for any reason not covered by regular pay, overtime pay, and penalty pay. This column appears only if the Other Pay parameter is set to Yes. |
| Var $ | Difference between the actual cost and scheduled cost of labor for the employee. |
| Var $ (%) | Percentage of variance between actual cost of labor and scheduled cost of labor for the employee. |
| Labor % | Actual cost of the employee's labor divided by total sales, shown as a percentage. |
| Act Start | Time when the employee punched in to the job. |
| Act End | Time when the employee punched out of the job. |
| Sched Start | Time when the employee was scheduled to punch in to the job. If this cell is blank, the employee was not scheduled to work. |
| Sched End | Time when the employee was scheduled to punch out of the job. If this cell is blank, the employee was not scheduled to work. |
Email, Export, or Print the Report
This report can be emailed, exported, or printed in custom formatting directly from the reporting window. Click here to learn how to send, export, or print this report.