The Employee Deduction Calculation and Update Report calculates both the employees and employer deduction amounts based on the employee's FTE. The employees FTE is determined by dividing the hours from the employee's master function line by the number of hours from the salary grid from the master function line.
The calculation of the deduction amount includes the calculation of a reserve amount to be taken each pay period. This additional reserve amount accommodates for example twelve month deductions taken over a ten month period. The adjustment to the deduction amount is determined based on the maximum number of periods and the number of periods taken from the employee's pay cycle code from the master function line.
This option may be setup on the Custom Users Reports Profile, for example,
EMPLOYEE DEDUCTION CALCULATIONS/SRB$OPSEXE:PRCUØB
This option would then be run from the Custom Users Report Menu.
Enter Deduction Code
-
Enter the deduction code to be calculated. Only employees with this deduction will be calculated and reported. Employees with suspended deductions are also omitted. Press <FIND> for a list of valid deductions.
When the deduction code enter is a table deduction (referring to the TABLE field in the Deduction Code Database) the following prompts will be included. This process allows a different calculation to be defined for each table entry.
Process One Or All Table Entries
-
Enter 'A' to enter rates for all deduction table entries currently in the Deduction Table Database.
-
Enter 'O' for enter rates for a specific deduction table entry.
When 'O'ne table entry was selected:
Entry Table Deduction
-
Enter a valid deduction table entry. Only employees who have their table entry equal to this table entry will be reported and/or updated.
This option will allow you to enter rates for the table entry of 'NONE'.
NONE is the default setting given by the system when an employee's deduction table entry has not been assigned a valid table entry.
Press <FIND> for a list of valid deduction table entries.
The prompt for total deduction amount and employers amount for a full FTE is repeated for each table entry when 'A'll table entries are selected.
Enter The Total Deduction Amount
-
Enter the total amount of the deduction, including employee/employer portions.
Enter Employers Amount For A Full FTE
-
Enter the amount the employer will pay for a full time employee, an FTE of 1.0000. This amount must be less than or equal to the total deduction amount. This amount cannot be greater than the total deduction amount.
Enter The Maximum Number Of Pay Periods
-
Enter the number of pay periods the deduction is to be calculated for. The number of pay periods an employee works (taken from the pay cycle code) determines the number of pay periods the deduction will be taken. The employee's deduction amounts will be calculated for the full number of pay periods and then adjusted to be taken over a shorter number of periods if necessary.
eg: If the deduction is calculated for a full year (12 months) and the employee only works 10 months, enter 12.
Report Employees Terminated/On Leave/Both
See Appendix AK.
Report By Employee Number Or Name
-
Enter 'E' to produce the report in employee number order.
-
Enter 'N' to produce the report in employee name order.
Report Only Or Process Employees
-
Enter 'R' or <CR> to only generate the report.
-
Enter 'P' to generate the report and also update the employee's deduction fields with the calculated amounts.
The report lists the following:
-
Employee number and name
-
The employee's table entry if applicable
-
The employees total FTE amount
-
The employee's per month deduction amount
-
The employer's per month deduction amount
-
The number of pay periods the employee is paid.
-
The employee's per pay period deduction amount including reserve
-
The employer's per pay period deduction amount including reserve
-
The employer's rate
-
The employees per pay period reserve amount
-
The employers per pay period reserve amount
-
Total number of employees
-
Totals per month, per pay period and total reserve