Summarize the total compensation the employer pays for each employee. This report may be helpful when it's time to plan the budget so you can see how much is being spent on wages and benefits. The report prints the grand total at the end of the report.

Employee compensation report by employee name

You can set up the report to

• print the employee wage expenses, employer expenses, or both the employee wage expenses and employer expenses. 

• list employee wage and benefit amounts for terminated employees. 

The master reports include, 

• Employee compensation report by department

• Employee compensation report by employee name

• Employee compensation report by employee number

The employee compensation report was updated with a new look and feel in the 2023.11 release. The report is included in the Payroll and Human Resources application and the updated report supports exporting and importing report definitions for this report in both applications. 

Printing an employee compensation report

1. Open Connect Payroll > Reports > Employee Compensation Report.

2. Select a report definition. 

Employee Compensation Report, Definition

3. Click Print (CTRL+P). 

Printing an employee Compensation report for terminated employees

1. Open Connect Payroll > Reports > Employee Compensation Report.0

2. Select a report definition. 

3. Click to select the Include Terminated Employees checkbox. 

4. Click Print (CTRL+P). 

Options

Some of these options may be selected with the report definition. 

Include employee wage amounts

The employee wage amounts will include transactions for gross, expense, and 1099 type. Selecting this option will print one record per employee, position, pay code, and GL account. 

Include fringe benefit amounts

Include pay code amounts for transactions for fringe benefits. The pay code amount is flagged as a fringe benefit when the pay code type is set to fringe benefit and the pay code is assigned to the employee. 

Include employer paid amounts

Include pay code amounts for amounts paid by the employer to the employee. 

Include terminated employees

Include employees with a termination date recorded in the employee file. The termination date isn't the same as position end date. An employee position can end without terminating the employee, only employees who have a termination date will be included in the report. 

Modify Existing Employees, Termination Date

Include zero amounts entries if YTD amounts exist

Include employee or employer entries that do not have transactions in the current report date range and the employee or employee has transactions with a year-to-date amount. Selecting this option will print additional records for pay codes, positions, and GL account combinations that have a zero amount for the report date range and a YTD amount for the calendar year. 

Summarize by employee and pay code

Total the employee and employer records by employee and pay code. When there is more than one entry for a pay code in the date range, this option will total the entries for the pay code in the date range and print the total on the report instead of printing the amount on a separate line for each entry that was made for the pay code. 

This option will ignore the position and GL account. If this option and position or GL account is included, the report column will display "Multiple". 

For example, George has four entries for regular pay in the two month date range. Selecting the option to summarize by employee pay code, totals the four entries (3,343.68+3,343.68+3,343.68+1,114.56=11,146.60) and prints one line for the pay code showing the pay code total.

Summarize by employee and pay code, example

Copyright © 2025 Caselle, Incorporated. All rights reserved.