Worked Hours & Wages Report

The Worked Hours & Wages report in 7shifts provides a summary of all recorded worked hours and wages from your time clocking system. Use this report to see when an employee last worked and their total hours for a specified date range.

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 doesn't 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.
• Overtime calculations may not appear on this report for 7shifts Payroll users but are correctly reflected within the payroll run.
• The Tips column may appear even when Include Tips is disabled, if Declare Tips is enabled in your Time Clocking settings. The totals shown in this state won't reflect all tip sources. Enable Include Tips for complete tip data.

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. 

   Note: Pay Periods will populate, but you may also choose the Custom Date Range option from the drop-down and use the date selector. 

   

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. The table below outlines how to print by file format.

Report contents

The Worked Hours & 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.
• Shift flags display any system or custom flags applied to a shift to track attendance events (e.g., Sick, Late, or custom reasons).
• Financial data includes the wage rate, hour totals, and pay totals.
• Tips information includes tips collected, tip pooling, and tip earnings if the Include Tips filter is enabled.
• Qualified Overtime (US accounts only) includes optional columns for pay period and year-to-date federal Qualified OT earnings under the One Big Beautiful Bill Act (OBBBA). These columns can be enabled via checkbox to help track tax-deductible overtime premiums for reporting purposes.

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.

• The Schedule page (including the Labor budget tool) display $0 for employees who are assigned to a location but not set to appear on the schedule for that specific department.
• Labor reports split salary based on salary allocation settings.
• Paid With Tip Payouts are only calculated and displayed as a weekly sum. They won't appear in the Worked Hours & Wages report if you run it for any period less than a full week, and aren't included in the CSV export, as the export doesn't 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.
• Tip totals may differ depending on the state of the Include Tips setting:
  • When Include Tips is enabled, 7shifts applies its full tip calculation formula to produce fully processed totals. This includes tips from time punches, POS data, and the credit card tips bucket.
  • When Include Tips is disabled, the report reads only tips tied directly to time punches (from 7punches and POS) and declared tips. The tip calculation formula isn't applied, so totals won't include all tips coming from your POS.

Next steps