Compensation reports
These reports track reviews, new hires, and terminations, as well as a variety of salary analyses and job code statistics.
Note: Many compensation reports include the compa-ratio, which 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
Compa-ratio calculations do not print unless you enable Salary Grade Table Validation during employer setup.
Report name | Description |
---|---|
Ranked Salary List |
Displays the annual salaries of all your employees in descending order. The report includes annual salaries, unit rate, employees, employee titles, and organization level. You can include all, exempt, or nonexempt employees. |
Reviews Due |
Displays performance and salary reviews by month. You can include performance or salary reviews—and sort by organization level or supervisor. If you select open reviews, the report includes reviews with a Next Review Date that is earlier than the one specified; the program considers reviews open until the Next Review Date is updated. |
Review Forms for Reviews Due |
Displays 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 |
Displays salaries categorized by individual employees, job title, all employees, or your search criteria. The report includes pay rates, hours, annual salaries, longevity, and compa-ratio. |
Salary Analysis by Job Code |
Displays salaries by job code, individual employee, all employees, or your search criteria. The 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 |
Displays salaries by job title, job code, individual employee, all employees, or your search criteria. The report includes pay rates, hours, annual salaries, longevity, compa-ratio, and other data. |
Salary Analysis by Organization |
Displays employees’ salaries by organization level. The report includes the employee’s pay rate, hours, annual salary, years of service, rating, and compa-ratio. The report also displays the employees’ average annual salary, total annual salary, and number of employees. The report includes the subtotals for each organization level; the totals for the employer appear at the end the report. |
Salary Analysis by Salary Grade |
Displays salaries by salary grade, individual employee, all employees, or your search criteria. The 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 |
Displays employees and their respective salaries at a given point in time. The report includes the employee name, job title, unit pay rate, and annual salary as of the selected date. The report also includes the total of the salaries displayed and a calculated salary average. You can select individual employees, all employees, or specify search criteria. |
Salary Grade Range Exceptions |
Displays 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 includes the 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 |
Displays employee compensation history, including the employees, effective dates, reasons for change, salary rates, and annual salaries. |
Salary Increase Analysis by Job Code |
Displays salary increases by job code, including previous versus current salaries, effective dates, reasons for adjustments, and actual and percentage amounts of increases. |
Salary Increase Analysis by Organization |
Displays 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 |
Displays 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 |
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 |
Displays terminated employees for a specified date range. The report searches the Employee Status for all employees 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. The report sorts the employees by termination date, gives a headcount, and calculates average and total terminated salaries. |
Turnover Performance vs. Longevity Matrix |
Displays information about the turnover rate within your organization. The report 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 report lists performance ratings vs. length of time employed for terminated employees. |
Turnover Statistics |
Displays 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. |