Using Reports > Employees Reports > Compensation Reports
Related topics

Use Standard Reports

Define Report Criteria

Define Custom Criteria

Preview, Print or Export Reports 

Compensation Reports

These reports track reviews, new hires and terminations, a variety of salary analyses and job code statistics.

Many compensation reports include the compa-ratio statistic. The compa-ratio is the employee’s percent-of-midpoint within a salary range. This is the formula for calculating compa-ratio:

Compa-ratio = Employee’s salary / Midpoint for Salary Grade * 100

Note: Compa-ratio calculations do not print unless you enable the Salary Grade Table Validation during employer setup.

These are the Compensation reports

Report Name Report Description
Ranked Salary List This report ranks, in descending order, the annual salaries of all your employees. The report includes annual salaries, unit rate, employees, employee titles, and organization level. You can select to include all, exempt or nonexempt employees.
Reviews Due

This report provides a list of performance and salary reviews by month. You can include performance or salary reviews and sort by organization level or supervisor.

If you request open reviews, Sage HRMS includes reviews with a Next Review Date that is earlier than the one specified. The system considers reviews open until the Next Review Date field is updated.

Review Forms for Reviews Due This report lets you view employee job and salary history. It also provides a section of requested changes for the reviewer to fill out and management to sign. The options are identical  to those for the Reviews Due report. When the form is completed, it is intended for use in updating the employee information affected by the review.
Salary Analysis by Employee Name The Salary Analysis by Employee Name report lets you evaluate salaries categorized by individual employees, job title, all employees, or your own search criteria. This report includes pay rates, hours, annual salaries, longevity, and compa-ratio.
Salary Analysis by Job Code The Salary Analysis by Job Code Report lets you evaluate salaries by job code, individual employee, all employees, or your own search criteria. This report includes job titles, salary grades, pay rates, annual salaries, and other data. It is sorted by exempt and nonexempt employees.
Salary Analysis by Job Title The Salary Analysis by Job Title Report lets you evaluate salaries by job title, job code, individual employee, all employees, or your own search criteria. This report includes pay rates, hours, annual salaries, longevity, compa-ratio, and other data.
Salary Analysis by Organization This report lists employees’ salaries by organization level. The employee’s pay rate, hours, annual salary, years of service, rating, and compa-ratio are listed. The employees’ average annual salary, total annual salary, and number of employees are totaled for the organization level as well as for the entire employer at the end of the report.
Salary Analysis by Salary Grade The Salary Analysis by Salary Grade Report lets you evaluate salaries by salary grade, individual employee, all employees, or your own search criteria. This report includes job titles, salary grades, pay rates, annual salaries, and other data. The report averages and totals the annual salaries for each salary grade.
Salary As Of Use this report to view a list of employees and their respective salaries at a given point in time. The report lists the employee name, job title, unit pay rate, and annual salary as of the selected date, the total of the salaries displayed and a calculated salary average. You can select individual employees, all employees, or define your own search criteria.
Salary Grade Range Exceptions Use this report to generate a list of employees whose rate of pay is different (more or less) from their assigned salary grade range. This report works only if Salary Grade Validation is enabled during setup of Sage HRMS. Grouped by organization levels, the report lists employee, title, salary, normal salary grade range (minimum and maximum), and the difference in dollar amount between the salary grade range and what the employee is paid.
Salary History Use this report to produce an employee compensation history. It lists employees, effective dates, reasons for change, salary rates, and annual salaries.
Salary Increase Analysis by Job Code The Salary Increase Analysis by Job Code report lets you evaluate salary increases by job code. This report includes previous versus current salaries, effective dates, reasons for adjustments, and actual and percentage amounts of increases.
Salary Increase Analysis by Organization Use this report to analyze employee salary increases by organization level. The report includes previous versus current salaries, effective dates, reasons for adjustments, and actual and percentage amounts of increases.
Salary Increase Analysis by Reason Use this report to analyze employee salary increases by reason. The report includes previous versus current salaries, effective dates, reasons for adjustments, and actual and percentage amounts of increases.
Statistics by Job Code This report groups statistical data into exempt and nonexempt employee categories. For each job code, the report shows titles, number of employees in each category, average unit rate, and average and total salaries.
Terminated Employee Log This report lists terminated employees for a specified date range. It searches the Employee Status field for all employee records tagged as terminated. The report provides dates of hire and termination, name, employee number, reason for termination, title, organization levels, employee type, longevity, pay rate and frequency, and annual salary. It sorts the records by termination date, gives a headcount and calculates average and total terminated salaries.
Turnover Performance vs. Longevity Matrix This report provides information about turnover rate within your organization. It might indicate a problem if employees with a high performance rating consistently leave your company, while poor performers have remained with the company a long time. The matrix lists performance ratings vs. length of time employed for terminated employees.
Turnover Statistics This report lets you view turnover statistics and calculates service length by Adjusted Seniority Date, Original Hire Date, or Last Hire Date. For each terminated employee, this report includes termination type, termination date, employee name, title, service length, salary grade, and termination reason.