FLSA Weekly Overtime Report
This report allows Corporate to track and identify the source of weekly overtime for each hourly employee. The report calculates simple weekly overtime, which is defined as all non-exempt hours worked beyond 40 in a designated 7-day work week. The user will be able to retrieve data for locations and weeks where Payroll has been exported, for up to four (4) weeks at a time, within the last 2 years (24 months). The report will retrieve data for employees who are linked to a Location within the selected Hierarchy and who have worked over 40 total hours within the selected period; salaried employees and those who work less than 40 hours are excluded. The retrieved hours will include all time worked from every location, even those outside of the currently selected Hierarchy. {Notes}
Report Controls
Week Start/End Date: Drop-downs; can select Post Period dates
Hierarchy: Select the desired hierarchy level from the drop-down
Funnel (Filters): Any report column
Printer (Export): PDF, Excel, CSV formats
Report Columns:
Click any column header to sort by the data in that column.
- Week Ending Date – The last day of the reporting period.
- Primary Location Code – The Code for the employee's Primary Location.
- Primary Location Name – The Name of the employee's Primary Location.
- Employee Number – The Employee Number from the employee record.
- Employee Name – The First and Last Name from the employee record.
- Total Hours Worked – The total number of hours that the employee worked during the period; this includes Paid Breaks.
- Weekly FLSA Overtime Hours – The total number of weekly overtime hours worked, calculated as [ Total Hours Worked – 40 ].
- Total Overtime Pay – The total pay for Overtime Hours worked, calculated as [ FLSA Overtime Worked Pay + FLSA Overtime Premium Pay ].
- FLSA Overtime Worked Pay – The total regular pay for weekly Overtime Hours worked, calculated as [ Weekly FLSA Overtime Hours x Employee's Regular Pay Rate ]
- FLSA Overtime Premium Pay – The premium paid for weekly Overtime Hours worked, calculated as [ (Weekly FLSA Overtime Hours x Employee's Overtime Pay Rate {Regular or Blended}) x 0.5 ].