Payroll Report Customization doesn't work

We have modified our Payroll "Deduction by Credit Account" report to show a "Basis" in order to calculate 401k match.  There are two problems with this:

#1 - The basis must look at the first processing of a check and not the final check. (example I entered a check with a gross of 15,000 and not $1.500.  I reprocessed this before printing the check but the report still sees $15,000 as the basis)

#2- If there is no basis (ie, the deduction is a flat amount) then that employee's deduction does not show up on this report at all.

I am not good at writing formulas but can usually figure out Report Designer. 

ANY help is appreciated!!!

Parents
  • 0

    I would first want to know why you're running a report to manually calculate your employer match for the 401K deduction rather than create a FRINGE ID for the 401K match, using "Calc Method" = Formula. Then create a formula that calculates the 401k matching amount at the time of processing the check.

Reply
  • 0

    I would first want to know why you're running a report to manually calculate your employer match for the 401K deduction rather than create a FRINGE ID for the 401K match, using "Calc Method" = Formula. Then create a formula that calculates the 401k matching amount at the time of processing the check.

Children