401K Match is not included in Certified Cash Fringe Rate
Description
Formula modified as the flat amount deduction lookup is not reducing the Cash Fringe Pay.  A percent of Gross pay will reduce the Cash Fringe Pay.
Cause

401K is marked as a certified fringe in Setup fringes but is not included in the certified fringes hourly rate calculations.

This causes an over calculation of the cash fringe pay rate and pay.

Resolution

Correct the formula for the 401K Fringe.

Change the formula to calculate the 401K deduction within the 401K match formula rather than look up the 401K deduction from the check record.

When the 401K deduction calculates within the 401K match formula, then the 401K match fringe is included in the certified fringe hourly rate.

This formula should be created and inserted into the 401K Matching Fringe formula. It will replace the part of the original formula that looks to the amount of the deduction on the PR Check Deduct record. This will make the 401K matching fringe amount calculate the 401K deduction amount within the fringe calculation.  This formula will calculate correctly if the default is gross pay.  This will not decrease the Cash Fringe Pay if the employee elects a flat amount to be deducted.

401K Deduct Amt

IF(LOOKUP(Calc Method (PR Employee Deduct), Employee (PR Check),"401K") = "Default", Gross Pay (PR Check) * LOOKUP(Amount (PR Employee Deduct), Employee (PR Check), "401K") / 100)

You must create a formula to meet your company's specific setup and needs. Refer to the link below for steps and considerations on 401K matching fringe formulas.

DocLink: How do I set up a 401K matching fringe formula?
Steps to duplicate
Related Solutions