Export your team's time sheet report in Shifts

Export your team's time sheet report

In the schedule, select the arrow next to Clock in, and then select Export time sheet.
In the Export time report dialog, choose the start and end dates for the report you want to export.
Select Export. Your report is exported to an Excel workbook. By default, the file is saved to the Downloads folder on your computer with the following name: TimeSheetExport_<start date>-TO-<end date>_<team ID>.xlsx.

Note: Employees can edit their time sheets on mobile for up to one month or until confirmed. All original and edited times will appear in the report.

View your team’s time sheet report

The Excel workbook contains the following worksheets:

Final Time Clock Report: Data in this worksheet includes the edits made by team members to their time sheets.
Original Time Clock Report: Shows the original time sheet data (before team members edit their time sheets).
Daily Total: Shows the daily totals for each team member.
Total <start date to end date>: Shows the totals of each team member for the date range of the report.

Final Time Clock Report and Original Time Clock Report worksheets

Each clock-in entry by a team member appears as a row with following columns.

Column	Column name	Description
A	Legend
B	Date	Date of shift
C	Employee Name	Team member name
D	Clock In Time	Clock in date and time
E	Clock Out Time	Clock out date and time
F	Shift Start Time	Schedule start time of shift
G	Shift End Time	Scheduled end time of shift
H	Unpaid Hours	Number of unpaid hours
I	Paid Hours	Number of paid hours
J	Hours Scheduled	Hours scheduled
K	Hours Worked	Hours worked
L	Break Start Time	Break start date and time
M	Break End Time	Break end date and time
N	Break Notes	Any break notes entered by the employee
O	Break Hours Taken	Total break hours taken including paid and unpaid
P	Clocked In On Location	Indicates whether the employee clocked in at their assigned work location based on GPS data
Q	Clocked Out On Location	Indicates whether the employee clocked out at their assigned work location based on GPS data
R	Break Started On Location	Indicates whether the employee started their break at their assigned work location based on GPS data
S	Break Ended On Location	Indicates whether the employee ended their break at their assigned work location based on GPS data
T	Hours Worked Minus Break Hours	Total hours worked, calculated from the employee's clock in and clock out times, excluding paid and unpaid breaks
U	Notes	Any notes entered by the employee when editing their time sheet
V	Confirmed	Indicates whether the employee confirmed their time sheet
W	¹Parental Leave	Total time off hours
X	¹Sick Day	Total time off hours
Y	¹Vacation	Total time off hours
Z	¹Off	Total time off hours
AA	¹Unpaid	Total time off hours

¹Default time-off reason in Shifts. The time-off reasons that you see in your report depend on the time-off reasons set up in Shifts settings for your team schedule.

Daily Total worksheet

Each row represents a team member with the following columns.

Column	Column name	Description
A	<Blank>
B	Row Labels
C	Hours Worked	Hours worked
D	Hours Scheduled	Hours scheduled
E	Unpaid Hours	Number of unpaid hours
F	Paid Hours	Number of paid hours
G	Break Hours Taken	Total break hours taken including paid and unpaid
H	Hours Worked Minus Break Hours	Total hours worked, calculated from the employee's clock in and clock out times, excluding paid and unpaid breaks
I	¹Parental Leave	Total time off hours
J	¹Sick Day	Total time off hours
K	¹Vacation	Total time off hours
L	¹Off	Total time off hours
M	¹Unpaid	Total time off hours

¹Default time-off reason in Shifts. The time-off reasons that you'll see here in your report depend on the time-off reasons set up in Shifts settings for your team schedule.

Total <start date to end date> worksheet

Each row represents a team member with the following columns.

Column	Column name	Description
A	Row Labels
B	Hours Worked	Hours worked
C	Hours Scheduled	Hours scheduled
D	Unpaid Hours	Number of unpaid hours
E	Paid Hours	Number of paid hours
F	Break Hours Taken	Total break hours taken including paid and unpaid
G	Hours Worked Minus Break Hours	Total hours worked, calculated from the employee's clock in and clock out times, excluding paid and unpaid breaks
H	¹Parental Leave	Total time off hours
I	¹Sick Day	Total time off hours
J	¹Vacation	Total time off hours
K	¹Off	Total time off hours
L	¹Unpaid	Total time off hours

¹Default time-off reason in Shifts. The time-off reasons that you'll see here in your report depend on the time-off reasons set up in Shifts settings for your team schedule.

For IT admins

Shifts for your frontline organization

Export your team's time sheet report in Shifts

In this article