A History Of Hours Worked report shows the total days and average days worked for each employee over a selected period of time, along with their contracted hours.
In this article you will learn:
Note: You must have access to 'Attendance Reports' to use this report. If you do not have access, please contact an account administrator to edit your permissions. Zero-hour days and weeks are excluded from this report. You will also have the option to include or exclude 'Paid Time Off' in the calculations of this report.
Information Included In Report:
Below is a list of all of the information included in the History Of Hours Worked report.
Existing Information:
Bizimply Unique ID
First Name
Last Name
Employee Number
Employee Start Date
Start Date of Selected Period for this Employee
Salary/Hourly
Current Hourly Rate
Regular Hours
Sunday Hours
Paid Sick Hours
Paid Time Off Hours
Public Holiday Hours
OT1 Hours
OT2 Hours
Information calculated by the report:
Total Hours Worked in Period
Total Number of Days Worked in Period
Avg Hours per Working Week in Period
Avg Hours per Working Day in Period
Avg Days per Week in Period
Weeks in Period
Contracted Hours in Period
How to pull the History Of Hours worked report:
Click the 'Reports' icon on the top of your screen
On the left of the screen click on 'Attendance Reports'
Click on 'History of Hours Worked'
4. Select the 'End Date' for the report. The report will then generate calculations from this selected date back 'x' amount of weeks depending on what you choose in the next step
5. Enter the number of weeks previous to the 'End Date' that you would like this report to calculate. This can be from 1 - 104 weeks
6. Continue to select your locations, payroll departments, and employees
7. You now have the option to 'Include all paid time off-types in the report?' This will include any type of paid time off including holiday, sick or other. If you choose to exclude this paid time off, then the weeks that show paid time off on the timecards but no other paid hours (e.g. someone is on a paid holiday for a week) will be excluded from this report
8. Click on the 'Export' button
9. Your CSV report will download
'Start date of the selected period for this employee' column
It is important to note that in this report, the previous X weeks is not going to be within the same date range for every employee. It is the previous X weeks from the 'End Date' selected and it excludes 0 or null hour weeks (based on the timecard). So the start date of the selected period for this employee of this 'X' week period will differ for all employees.
For example, You may select April 26th as the 'End Date' for the report and you want the history of the previous 13 weeks worked from every employee. John’s 13 week period may be from January 27th - April 26th. But Mary’s 13 week period may start from January 6th as there were 3 weeks that she was not working and therefore didn’t appear with hours on the timecard.
Note: Even reports for a specific location will list the total hours worked by each employee. If an employee is shared between multiple locations, their cumulative hours across all locations will be shown on reports for specific locations.
Related Articles: