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.

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 the 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 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 comprises all the pay codes associated with the pay summary codes assigned to the pay class).

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, 1000.00 for a weekly check corresponds to 52000 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 (determined by the salary schedule assigned to the activity on Activity (AC10.1).
  • The salary cap adjusted for FTE (salary cap * FTE)

    For example, if FTE is .5 and salary cap 100000, the salary cap for FTE is 50000.

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