Salary Cap Analysis Report (GM468)

Run Salary Cap Analysis Report (GM468) to compare actual pay to salary cap for selected employees and dates. The employee salaries can come from Lawson or non-Lawson payroll.

Note: You can run this report at any time. It is recommended that you run it in conjunction with Effort Variance Report (GM465) or Labor Cost Transfer Template Creation (GM466) to expose individuals whose pay exceeded the salary cap for an effort reporting period.

At a minimum, you must select the HR company and effort reporting period for which you want to run the report. You can also limit the report to a process level or processing group and/or to an employee group or range of employees. You can exclude certain pay codes (for example, bonuses) from the report by selecting up to ten exclude pay codes, or by selecting an exclude pay class (which will exclude all the pay codes that are associated with the pay summary groups that comprise the pay class).

This report is designed for .csv output so users can easily extract and analyze data. For each employee selected, the report prints the following information:

  • Each paycheck ID for the selected period.

  • The pay frequency the check is based on (for example weekly or biweekly).

  • The detail of each distribution line, including:

    • The transaction date

    • The pay code (if applicable)

    • The HR company

    • The accounting unit, account and subaccount

    • The grant (posting) activity and account category

    • The distribution line amount

    • The annualized earnings

      For example, 1,000.00 weekly, means 52,000 annualized.

    • The employee's FTE status on the date of the transaction

    • The annual salary cap in effect for the activity on the transaction date

    • The salary cap adjusted for FTE (salary cap * FTE)

      For example if FTE is .5 and salary cap 100,000, the salary cap for FTE is 50,000.

    • An "Over Cap" message if the annualized earnings exceed the salary cap