The Hours Worked by Employee and Activity Code report provides a breakdown of the hours worked by each employee, with total hours and the value of time spent itemised by activity codes.
You can choose to view this report for all hours, or only hours for selected activities.
How to generate the Hours Worked By Employee and Activity Code Report
From Reports >> Performance Reports >> search for or select Hours Worked by Employee and Activity Code from the Timesheet Entries section >> select the required date range.
This report can be filtered by Employee Office, Client, Job and Employee.
Tick the ‘Current’ box for ‘Client’ to select a specific client from the current clients’ list in the dropdown. Untick the box to choose from all clients, whether current or noncurrent.
Tick the ‘Current’ box for ‘Job’ to select a specific job from the current jobs’ list in the dropdown. Untick the box to choose from all jobs, whether current or noncurrent.
Similarly, tick the ‘Current’ box for ‘Employee’ to select a specific employee from the current employees’ list in the dropdown. Untick the box to choose from all employees, whether current or non-current.
Once the dates and filters have been chosen, click on the Report Options button and select either of the options to view the ‘Select Activity Codes’ box.
Select Activity Codes options
‘Select Activity Codes’ box has the following options:
Show Activity Codes
Select to show activity codes for current jobs, non-current jobs or all jobs.
Show Details or Summary
Choose to show details or summary in the report.
Sorting
You can also sort the report by Client, then Date or by Date, then Client.
Show Disbursements
Tick this box to show disbursements in the report.
Start a new page for each employee
Tick this to start a fresh page for each employee.
Hide Negative Units
Negative units can be hidden when you tick this box.
The only instance where an employee might have negative units for hours is by agreement – for example if an employee takes 4 hours annual leave on a Tuesday, but then works 4 additional hours non-paid overtime on the Thursday.
Select Activity Codes to show in report:
Select from the given list the required activity codes to show in the report.
Select from the options in the box and click on the print button to preview the Hours Worked by Employee and Activity Code report.
Note that the percentages for this report will only calculate correctly when the report period is equal to a complete timesheet period/s
Understanding the Data
The Hours Worked By Employee and Activity Code Report has the following information:
- Employee Name
- Activity Code
- Client (name)
- Job Code
- Job Description
- Date
- Hours Worked and
- Value of Time
- Chargeable Hours
- Non-Chargeable Hours
- Percentage of Chargeable hours and
- Percentage of Chargeable hours At Work
Employee Name
Employee name comes from Administration >> Employees >> Employee Details screen.
Activity Code
Activity codes for your business can be set up from Administration >> Maintenance >> Activity. An activity can then be selected from the dropdown when an employee enters time in their timesheet.
Learn how to add Activities and Activity Groups here.
Client (name)
From Clients, Contacts & Jobs >> Search Clients and Jobs >> click on any ‘Contact Name’ to view the client Details for page.
The client name for this report comes from the ‘Details’ tab in the Details for client page.
Job Code and Job Description
From Clients, Contacts & Jobs >> Search Clients and Jobs >> Job Code and Job Description can be found here, corresponding to the contact name.
Date
This is the date of timesheet entry.
Hours Worked
These are the hours worked by the employee for each activity/activities between the selected dates.
Value of Time
This is the value of time for the hours worked by the employee between the selected dates.
The Value of Time is calculated as:
Hours Worked x Charge Rate
Report Totals
Non-chargeable Hours
These are the total hours spent by the employee on non-billable jobs in the selected date range.
Learn about Nonchargeable work here.
Chargeable Hours
These are the total hours spent by the employee on billable jobs in the selected date range.
Percentage of Chargeable hours
Percentage of Chargeable hours is given as based on Total Hours and is calculated as below.
The calculation for the Percentage of Chargeable hours based on Total Hours is:
(Chargeable hours ÷ Total hours) x 100
Percentage of Chargeable hours At Work
The calculation for the Percentage of Chargeable hours based on ‘At Work’ Hours is:
(Chargeable hours ÷ At Work hours) x 100
The other Hours Worked Reports in Abtrac are:
Hours Worked by Employee Report
Hours Worked by Employee and Client Report
Hours Worked By Employee, Contact and Job Report
Hours Worked by Date, Employee, Client and Job Report
Hours Worked by Employee, Client and Job by Month Report
Hours Worked by Employee, Client, Job, Task and Date Report
Hours Worked by Client and Job Report
Hours Worked by Employee, Client, Job and Task Report and
Hours Worked by Employee, Job Office Report
Abtrac KB # 2108