Union Detail Report screen

Use the Union Detail Report screen to create a report of union fringes and deductions for selected pay periods or payroll transaction dates. The report includes a breakdown of hours worked (the total of regular hours, overtime hours, and double time hours) as well the total of hours compensated, which is calculated as follows:

Hours Compensated = (1 × regular) + (1½ × overtime) + (2 × double time)

Let's say an employee worked 40 regular hours, 6 overtime hours, and 2 double time hours. In this case:

Hours Worked = 40 + 6 + 2 = 48

Hours Compensated = (1 × 40) + (1½ × 6) + (2 × 2) = 53

Note: Payroll transactions entered on the Edit Forms W-2 screen (U.S.) , the Edit Forms T4 screen (Canada), or the Enter Payroll Initial Balances screen are not included in the Union Detail Report.

You can print or save this report.

To open the Union Detail Report screen, go to Employees > Reports > Union Detail Report in the All Tasks pane.

You can control the output of the Union Detail Report by entering details in one or more of the following fields on the Options tab:

  • Select Format - If you have modified the format and layout of this report on the Modify Reports screen, select the version to use for this report. If you haven't modified the report, this field doesn't appear.
  • Company - Select one or more companies for the report. If no companies are selected, all companies appear in the report.
  • Pay Period Start Date - Enter the start date for the range of pay period dates for the report, choose the date from a date picker, or select to enter a date formula. If you want to save the information in the date field when you save the report options, you must use a date formula. If no pay period dates are entered, all pay period dates appear in the report. If the pay period dates are entered, but the payroll transaction dates are not, the detail lines in the report will show the pay period date. Otherwise, the detail lines will show the payroll transaction date.
  • Pay Period End Date - Enter the end date for the range of pay period dates for the report.
  • Check Start Date - Enter the starting payroll transaction date for the report.
  • Check End Date - Enter the ending payroll transaction date for the report.
  • Trade Union - Select one or more trades or unions for the report. If no trades or unions are selected, all trades and unions appear in the report.
  • Compensation Package - Select one or more compensation packages for the report. If no compensation packages are selected, all compensation packages appear in the report.
  • Pay Class - Select one or more pay classes for the report. If no pay classes are selected, all pay classes appear in the report.
  • Sort By - Select Trade Union to sort the report by trades and unions. Select Compensation Package to sort the report by compensation package.
  • Show Check Detail - Select the checkbox to show check details in the report. Deselect the checkbox to no show check details in the report.
  • Show Employee Totals - Select the checkbox to show totals for employees in the report. Deselect the checkbox to not show employee totals in the report.
Tip: You can use the Modify Reports screen to customize the format and layout of this report.
For more information on running the report, see Run and Print Reports.