|
401K Matching Fringe |
IF ( (NEWDATE (Hire Date [PR Employee], 0, 182) < Period End Date [PR Check]), (MIN (LOOKUP (Amount [PR Check Deduct], Employee [PR Check], Period End Date [PR Check], Check Sequence [PR Check], "401K", Gross Pay [PR Check] * .06) ) ) ,0) |
This formula compares the employee's hire date to the period end date of the check being entered. It then verifies the employee's probationary period of 182 days has been completed. If the employee has been employed at least six months (or 182 days), a 401k fringe equal to the lesser of either 6% of the employee's gross pay or the amount of the employee's 401k deduction amount calculates on the check. |
|
Vacation Accrual |
IF (NEWDATE (Hire Date [PR Employee], 0, 30) < Period End Date [PR Check], .75) |
This formula compares the employee's hire date to the period end date of the check being entered. It then verifies the employee's probationary period of 30 days has been completed. If the employee has been employed at least 30 days, the specified .75 hours accrues for the vacation hours pay ID. This formula does not take into account any other limits. |