The Annual Advance & Recoup Calculation Process may be used to calculate an advance amount to be paid for a defined number of payments as a negative deduction amount. This process is then run a second time to flip the deduction to a positive amount to reclaim the total advance amount over a defined number of periods. An example of how this process may be used is when an advance is to be paid over the summer periods with reclaim of the advance to take place throughout the school year.
The advance amount is calculated based on a percentage of total function line earnings and loaded onto a standard Group 4 Type 0 deduction as a negative deduction amount. The advance amount multiplied by the number of advance payments is defined as the total negative deduction limit, per employee.
The Recoup process takes the negative deduction limit amount, flips it to a positive value and divides the deduction limit by the number of reclaim payments to determine the new positive deduction amount.
Advance amounts on employees that are On Leave or Terminated will not be paid out.
DEFAULT PROMPT STORAGE & RETRIEVAL
This process includes the option to maintain multiple sets of stored prompts.
Name the prompt sets by defining a title up to 10 characters, with a 30 character description.
On the first prompt click the Report Defaults icon to select an existing set of prompt values. You can delete prompt sets or change the description from the Report Default icon.
BATCH AND PRINT QUEUE SCREEN
Process Advance Calculation Or Reclaim Adjustment
Enter 'A' to calculate the advance amount.
Enter 'R' to calculate the reclaim amount based on the previously loaded advance amount.
Enter Advance/Reclaim Deduction Code
Enter the deduction code to be used for the advance and reclaim. A Group 4 Type 0 deduction is recommended. Only employees with the deduction on their deduction master will be included on this process.
When Calculate of 'A'dvance was selected:
Enter Advance Percentage
Enter the percentage of accumulated function line salary to be used in determining one payment of the advance.
Enter The Number Of Advance Payments
Enter the number of advance payments to be paid out. The calculated advance amount multiplied by this number of payments will determine the total advance amount to be loaded as the negative deduction limit.
Round Advance To The Nearest Dollar
Enter 'Y' to indicate the employee's advance amount should be rounded to the nearest whole dollar. It is recommended that the advance amount be rounded to the nearest whole dollar to avoid unbalanced reclaim amounts.
Enter 'N' to indicate the employee's advance amount should not be rounded.
When Calculate of 'R'eclaim was selected:
Enter The Number Of Reclaim Payments
Enter the number of reclaim payments. The existing deduction limit (as a positive) will be divided by this number of reclaim payments to determine the deduction amount or reclaim payment amount per period, per employee.
Employee Selection By Salary Grid Or Employee Number
Enter 'S' or to select employees for this process based on a range of salary grids.
Enter 'E' to select employees for this process based on employee numbers.
When Selection by 'E'mployee number was selected:
Report All Or Selected Employees
When Selection by 'S'alary Grid was selected:
Enter Starting Grid For Range
Enter the specific 6-character salary grid for a range of salary grid to determine employee selection. Only employee with a function line containing a salary grid within the grid range will be included on this process run.
Enter to include all salary grids.
Enter Ending Grid For Range
This prompt appears only if you entered a specific starting point in response to the previous prompt. If you select ALL, this prompt is not displayed.
Enter the 6-character salary grid for a range of salary grids for employee selection.
Enter Pay Cycle Codes For Function Line Selection
Enter omit function line selection by pay cycle code.
Enter one or up to 30 pay cycle codes, one at a time, to determine which function lines are to be included for employee selection as well as for salary inclusion.
Report Terminated / On Leave / On Leave With Benefits / All
Enter without selection to exclude all inactive employees.
Enter 'A' when all inactive employees should be included on this process.
Select specific employee status types followed by 'enter' to indicate which employees should be included on this process.
Select clear icon to clear the selected status types.
Report Only Or Process
Enter 'R' to generate a report of the advance or reclaim calculation.
Enter 'P' to generate a report and update the employee's deduction values.
The Advance report lists the following:
-
Employee number and name
-
Advance deduction and employee's deduction frequency
-
Employee master function line salary grid
-
Total gross earnings
-
Advance amount as a negative
-
Total advance amount as a negative, deduction limit
-
Employee status, if applicable
-
Total employees updated
-
Total employees with no Advance Deduction
The Reclaim report lists the following:
-
Employee number and name
-
Advance deduction and employee's deduction frequency
-
Employee master function line salary grid
-
Reclaim amount
-
Total reclaim amount, deduction limit
-
Employee status, if applicable
-
Total employees updated
-
Total employees with no Advance Deduction