The CSV Export report is a versatile download file that allows you to get all the data tracked for each shift worked by an employee. These data points include:
- Employee first name
- Employee last name
- Employee ID
- Employee email
- Customer : Job
- Job number
- Task
- Task code
- Start time
- End time
- Total break minutes
- Total paid minutes
- Total minutes (including break)
- Start GPS latitude
- Start GPS longitude
- End GPS latitude
- End GPS longitude
- Total billable time in decimals
- Timesheet notes
- Regular time minutes
- Overtime minutes
- Double time minutes
- Time off minutes
- Unpaid time off minutes
- Approved status
- Associate OID (ADP users)
- File Number (ADP users.)
Run the CSV Export report
To run the report:
- Go to Reports > CSV Export.
- Select a Date Range.
- If the shifts in this date range are not approved, a warning is displayed.
- To only include specific employees in this report, select Filter Employees and then select the employees, departments or locations. If this option is not selected, the report includes all employees.
- Optionally, select Include Notes to include notes from the employees’ timesheets.
- Click Download CSV.
The CSV can be opened and edited in Excel, Google Sheets or other spreadsheet programs.