Weird Sage 300 US payroll rounding

Sage 300 2019 PU2 + UP73A PU18 + UT73G PU1

We found a rounding error in the payroll pre-check register.

A time card was entered for 15 hours @ 62.2743 = 934.1145

Normal round would give 934.11 but the pre-check register shows to 934.12

Yeah I know it's 1 penny off.... but try explain that to a genius ;)

Is this "normal" payroll behavior?

  • 0

    In my experience, yes this is normal behavior, that is just how the software works. Once the time cards are calculated the UPCHKD table converts the calculation to 2 digits and always rounds up. Believe me, so much time can be wasted chasing fractions of pennies that it really is not worth it and you may want to consider not having pay rates that are a fraction of a penny.

  • 0 in reply to angel g

    Ha! Tell that to the client LOL.

    You will not believe the strange stuff they do, they have hourly rates to 6 decimals. This comes from union rates negotiated for a season (6 months) at a set rate for the period, say $10,000 for the season worked, divided by the number of hours in the season to get the hourly rate.

  • 0 in reply to ettiennes

    Sage, please look into an enhancement for this. What examples like this end up doing to accruals is even more of an issue. What I have seen happen is that since accruals are paid using the extended amount, the software has to recalculate the pay rate and may end up recalculating a pay rate that is a a penny or more off. The math for pay rate X hours stills works out, but clients just want the correct pay rate to print on checks.