Running the Time Clock Report
(For managers or supervisors and AP personnel)

Run the Time Clock Report to gather information about Time Clock entries. You can include up to four different pay periods in a single report.

To run a Time Clock Report, you need to complete the following tasks:

Note: Use the Time Clock Report function to generate Equipment Profit Reports that detail the amount of time an employee used a piece of equipment.

For a description of the report, see What the Report Shows at the end of the topic.

To limit the report results:

  1. From the A/P > Time Clock menu, select Time Clock Report to display the Time Clock Report screen.

  2. Use the following fields to limit the report time frame on which you want to report:

Field

Description

Start Date

Enter the date for which you want to start the report data collection.

Start Time

By default, the system uses 12:00am for the date you entered in the previous field. Change this time, if needed.

For example, if you have no shifts beginning until 6:00am, you can enter 06:00am in this field.

End Date

By default, the system uses the date seven days from the start date.

For example, if you enter 02/26/2008 in the Start Date field, the system populates the end date with 03/03/2008.

End Time

By default, the system uses 11:59pm for the date entered in the End Date field. Change this time, if needed.

For example, if you have no shifts clocked in after 8:00pm, you can enter 08:00pm in this field.

Period 1 - 4

Populate the above fields for each pay period for which you would like to report.

  1. In the Daily OT field, enter the number of hours equal to a full work day in order to calculate overtime.

For example, enter 8 if your company's full work day equals eight hours. When your report generates, any amount of time greater than eight hours in a single day displays as overtime for that pay period.

Note: To see a daily total on the report, select Break on Day when formatting your report.

  1. In the Period OT field, enter the number of hours equal to a full work week in order to calculate overtime.

For example, enter 40 if your company's work week equals 40 hours. When your report generates, any amount of time greater than 40 hours in one week displays as overtime for that pay period.

  1. Use the following fields for each pay period, as needed:

Field

Description

Br/Tr/All

Enter the branch or territory you want to include the report:

  • Enter multiple branches or territories separated by commas.

  • Enter All to include all branches and territories in the report.

Department

Enter the department you want to include in the report:

  • Enter All to include all departments on the report.

  • Use the Departments hot key to include multiple departments.

Time Off

Enter the time off category for which you want to include in the report. For example, if you only want to view a report including only the time off category of SICK, then enter SICK. Leave this field blank to run the report for all time off codes.

Employee

Enter an employee ID if you want to limit the report to one user. Leave this field blank to run the report for all employees.

Sort By

Indicate how you want to sort the report: Department or Employee.

Employee Type

Enter the employee type for which you want to limit the report. For example, if you want to run a report for just your seasonal employees, select Seasonal. Leave this field blank to run the report for all employee types.

Employee Status

Enter the employee status for which you want to limit the report, such as Hourly. Leave this field blank to run the report for all employee statuses.

  1. Use the Additional Data hot key to further limit the report by Employee # or user defined data labels.

  2. Use the Format hot key to set how you want to report to print.

  3. Set options, if needed, and generate the report.

To format the Time Clock Report:

  1. From the A/P > Time Clock menu, select Time Clock Report to display the Time Clock Report screen.

  2. Limit the report options, as described above.

  3. Use the Format hot key to display the Time Clock Report Format screen and populate the fields as follows:

Field

Description

Summary/Detail

Determines what type of report runs, a Summary report or a Detail report.

If you have Break of Day set to Y, the Summary report lists the total and grand total hours for the selected user names, branch numbers, departments, employee types, and dates.

The Detail report lists the daily and total hours for the selected user names, branch numbers, departments, employee types, adjustments, and dates. The Detail report also includes any notes you enter on the Time Clock Detail screen.

The default is Detail.

Break on Day? (Y/N)

Indicates how to display the total hours per person. Type Y to total the hours daily per person, or N to total the hours per person for the selected time period. The default is No.

Note: The Break on Day field must be set to Y for the Daily OT option to display the amount of overtime per day on your report.

Break on Branch? (Y/N)

Determines if the report includes total hours for the selected branch. Enter Y to total the hours, or N to omit this total from your report. The default is No.

Break on Department? (Y/N)

Determines if the report includes the total hours for the selected department. Enter Y to total the hours, or N to omit this total from your report. The default is No.

Page Break on User? (Y/N)

Determines where the page breaks occur in a Detail report. Enter Y to run a Detail report with each user is printed on a separate page, or N to run a Detail report with multiple users on a single page, and page breaks occurring naturally at the bottom of a page. The default is No.

This option is not applicable to reports run in Summary mode.

Show Clocking Times? (Y/N)

Determines if users' clock in and clock out times are included in a Detail report. The default is No.

This option is not applicable to reports run in Summary mode.

Show Hours and Minutes? (Y/N)

Determines how clocked-in time displays in the report. Enter Y to display clocked-in time in an hour/minute format, or enter N to display the times in decimal format. The default is No.

For example, if an employee is clocked in for five hours and fifteen minutes and you enter Y, the time displays as 5:15. If you enter N, the time displays as 5.25.

Display adjustment code columns? (Y/N)

Enter one of the following to determine whether the report displays adjustment code columns on the report:

  • Yes –The report displays detail information:

  • No – The report does not display detail information and includes only the following columns .

  • Total Reg – Regular time plus adjustment time.

  • Total Ovr – Hours to pay at overtime pay rates using the selected overtime boundary.

The default is No.

  1. Press Esc to save your changes and return to the Time Clock Report screen.

What the Report Shows

The Time Clock Report shows the following information:

Column

Description

Reg Tm

Hours to pay at regular pay rates.

Over Tm

Hours to pay at overtime rates.

Adj Reg

Regular adjustment hours.

Adj Ovr

Overtime adjustment hours.

Total Reg

Hours to pay at regular pay rates plus regular adjustment hours.

Total Ovr

Hours to pay at overtime rates plus overtime adjustment hours.

Day Reg

Hours to pay at regular pay rates using the daily overtime boundary.

Day Ovr

Hours to pay at overtime rates using the daily overtime boundary.

Per Reg

Hours to pay at regular pay rates using the period overtime boundary.

Per Ovr

Hours to pay at overtime rates using the period overtime boundary.

Total Day Reg

Total hours to pay at regular pay rates using the daily overtime boundary plus regular adjustment hours.

Total Day Ovr

Total hours to pay at overtime rates using the daily overtime boundary plus overtime adjustment hours.

Total Per Reg

Total hours to pay at regular pay rates using the period overtime boundary.

Total Per Ovr

Total hours to pay at overtime pay rates using the period overtime boundary.

See Also:

Checking Time Off Availability

Checking Employees Clocked-In Status