The Timesheet details report is one of the reports available for free as part of Deputy Analytics.

How can this report help my organisation?

Use the Timesheet details report to track employee shift patterns and ensure compliance with schedules.

What questions can this report help me answer?

How many shifts has a team member completed?
How many hours were worked in a specific date range?
How often were scheduled hours exceeded, and how many hours were unscheduled?
How many hours were scheduled versus actual?
How many hours have team members worked since their start date?

What is in the Timesheet details report?

Filters

All tables in this report will be acted upon using the built-in drop-down menus to select specific:

Timesheet start date (This defaults to the last 30 days but you can select to filter a specific date range if required) Note: select both a start and end date of the range to calculate averages.
Timesheet status (Upcoming, On shift, Absent, Late, Pending, Time Approved, Pay Approved, Exported)
Timesheet location
Timesheet location status (Active or archived locations)
Timesheet area
Team member name
Team member status (Employed or Archived)

timesheet details filters.png

Table of Team member work patterns

A table displaying a count of total shifts and hours worked alongside average shifts per week and average hours per week for team members by location, area and team member.

The table will default to show data from the last 30 days but can be edited as required using the filters.

team memeber work patterns table.png

The table of Team member work patterns contains the following data fields:

Location / Area / Team member name
Total shifts worked
Total hours worked
Average shifts worked per week
Average hours worked per week

Table of Timesheet details

A table displaying all timesheet details.

The table will default to show data from the last 30 days but can be edited as required using the filters.

timesheet details table.png

The table of Timesheet details contains the following data fields:

Timesheet ID (a unique number assigned to thentimesheet by Deputy)
Team member name
First name
Last name
Timesheet status (Upcoming, On shift, Absent, Late, Pending, Time Approved, Pay Approved, Exported)
Timesheet Start Time YYY- MM-DD HH:MM:SS
Timesheet End Time YYY- MM-DD HH:MM:SS
Timesheet Total Time 0.00 h
Shift Start Time YYY- MM-DD HH:MM:SS
Shift End Time YYY- MM-DD HH:MM:SS
Shift Total Time 0.00 h
Timesheet Location
Timesheet Area
Timesheet Leave Policy
Timesheet Employee Comment
Timesheet Cost
Timesheet Custom Fields (see below)

Display custom shift questions on the Timesheet details report

If you have created custom timesheet fields to set up shift questions for your team members to complete at the end of your shift then this field is where the data is collected.

You will need to modify the table within the report to extract the data from the custom fields.

For example, let's look at an example where a custom timesheet field was set up to allow team members to enter a value for the amount of tips they received at the end of their shift and this value was then recorded on their timesheet as a custom field.

To extract this custom field data you need to scroll to the far right of the table and right click on the column labelled Timesheet Custom Fields.

Click to highlight and select the relevant fields from the list on the right. The order you select them determines the sequential order the field is added to the table of data. Once you have added the fields you require, click Confirm.

The custom field data will now be displayed in the report table.

extract custom field data.gif

FAQs on using this report