Worked Hours & Wages Report

The Worked Hours and Wages report provides a summary of all recorded worked hours and wages from your time clocking system. This report is the best way to see when an employee last worked and their total hours for a specified date range, helping you stay on top of your labor costs!

Things to know

• Time clocking data must sync into 7shifts through 7punches, or a POS integration with Actual Labor enabled to appear in this report.
• Only approved punches from Time Clocking are included in the report results.
• The CSV export does not support break information and is unavailable in the Compact Layout.
• Pop-ups must be enabled in your web browser to view or download the report properly.
• Overtime calculations may not appear on this report for 7shifts Payroll users but are correctly reflected within the payroll run.

Run the report

1. In the left navigation bar, go to Reports > Worked Hours & Wages.
2. Apply filters such as Date Range, Location, Department, Role, and Layout to refine your results.
3. Check Include Tips to display employee tip information from 7punches, a POS integration, or Tip Pooling.
4. Select View as to choose between displaying the report in your web browser or downloading it to your device.
5. Click Get Report to generate the data based on your selected criteria.
   
   (click on the image to expand it!)
    

Print the report

You can print your report data after generating it by following the steps outlined in the table below.

Report contents

The Worked Hours and Wages report displays specific data blocks to help you analyze labor productivity and employee earnings.

• Employee details include the Employee ID and the employee name.
• Shift details include the date, shift time, location, and assigned role.
• Financial data includes the wage rate, hour totals, and pay totals.
• Tips information includes tips collected, tip pooling, and tip earnings if the tips filter is enabled.

Why report totals may differ

You may notice differences between this report and other areas of 7shifts, such as 7shifts Payroll, due to how specific data is calculated.

• Filtered reports display $0 for employees who are assigned to a location but not set to appear on the schedule for that specific department.
• 'Paid With Tip Payouts' are only calculated and displayed as a weekly sum. Therefore, they will not appear in the 'Worked Hours and Wages' report if you run it for any period less than a full week, nor will they be included in the corresponding CSV export, as the export does not support weekly sums.

• If you use 7shifts Payroll:

  • Overtime calculations may not appear on the Worked Hours & Wages report, but are calculated and reflected in Payroll.

  • The Worked Hours & Wages report only includes approved punches from Time Clocking.

  • Payroll pulls in all recorded hours, including unapproved punches, to ensure a complete and accurate payroll record.

  • This difference can cause totals in the Worked Hours & Wages report to differ from Payroll exports.