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.

Hi LAPayroll! 

I would approach this from a different angle. Instead of looking at the employees' deductions, I would ask how you company is going to match the 401k amounts in general. Will you be matching the employees’ full 401k deduction up to a certain amount? Will it be a stepped or tiered match? 

Typically you will be able to get what you need from a report on gross pay or by reporting on certain pay IDs. 

If you have any more details, we can probably point you in the right direction.

Thanks!

Hi Art Minds,

We have too many "special cases" where this would not work.  Although this may be the lesser of two evils.

Thanks

By creating a FRINGE ID for the 401k match, you can set up that fringe ID on each employees record [PR > Setup > Employees, then click the FRINGE button] and then through the use of Calc Methods, the "Amount" field and custom formulas, each employee's match could easily be calculated automatically and will be accrued on the employee record in the MTD, QTD and YTD fields.