Worked Hours & Wages Report

Updated December 15, 2025 16:30

The Worked Hours & Wages report provides a summary of all recorded worked hours and wages from your time clocking system. It's also the best way to see when an employee last worked and their total hours for a specified date range.

Prerequisites

⚠️To access this report, your time clocking data must sync into 7shifts through 7punches, or a POS integration with Actual Labor enabled.

⚠️ To run this report, Managers and Assistant Managers need the "Can run reports" permission. Once enabled, they do have the option to pull the report for "All departments", regardless of individual department assignments.

Running the Report:

In the left navigation bar, go to Reports > Worked Hours & Wages.
Apply filters (e.g., Date Range, Location, Department, Role, Layout) to refine results.
(Optional) Check Include Tips if you want to display employee tip information from 7punches, POS integration, or Tip Pooling.
Select View as to display the report in your web browser or download it to your device.
Click on Get Report to generate the data based on your selected criteria.

⚠️ Important Notes:

This report will open in a new window. If your web browser blocks pop-ups, you may not be able to view or download this report properly. Click here to learn how to enable pop-ups for 7shifts.
The CSV export does not support break information and is unavailable in Compact Layout.

Example WH&W Report:

(click on the image to expand it!)

Troubleshooting Tip Information

💡 If your reported tip data appears inaccurate, it is often due to Tip Calculation settings Review and adjust these settings to ensure your tip calculations align with your payroll preferences. Learn how to setup/edit your tip calculation here.

Printing the Report:

File Format	How to Print
Web (view)	Use your browser's print function: Ctrl+P (Windows) or CMD+P (Mac).
Excel (download)	Open the Excel file, and press Ctrl+P (Windows) or CMD+P (Mac).
CSV (download)	Open the CSV file, and press Ctrl+P (Windows) or CMD+P (Mac).

⚠️ Printing steps may vary depending on the program you are using.

Report Contents:

The Worked Hours & Wages may include:

Employee ID
Employee
Date
Shift Time
Location
Role
Wage
Hour totals
Pay totals
Tips Collected (if "Include Tips" is selected)
Tip Pooling (if "Include Tips" is selected)
Tip Earnings (if "Include Tips" is selected)

⚠️ Additional Considerations:

Only approved punches are included in the report. If the report appears blank, check for unapproved punches in Time Clocking.
Overtime & Holiday Hours: Displayed if enabled in Company Settings. Double Overtime is included under the Overtime column if enabled in Overtime Settings.
'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.