Sage is rounding time off calculations per payroll line, instead of rounding total hours per pay period, which causes rounding errors in time off totals.

When there are multiple lines in Payroll Data Entry, which is how they populate from Time Track, each line is calculated for the time off formula (hours * rate), rounded and added together for each line. This causes errors in time off calculations due to when the rounding occurs.

For example:
5 Hours x .025 Rate = .125 <---- Rounds here to .13
7 Hours x .025 Rate = .175 <---- Rounds here to .18
9 Hours x .025 Rate = .225 <---- Rounds here to .23
11 Hours x .025 Rate = .275 <---- Rounds here to .28
8 Hours x .025 Rate = .200 <---- Rounds here to .20
----------------------------------
Total = 1.02


These errors could be fixed if the system were to add all Payroll Data Entry lines first, then multiply total hours * rate, and then round. This method would allow for a more accurate time off calculation.

For example:
5 Hours x .025 Rate = .125
7 Hours x .025 Rate = .175
9 Hours x .025 Rate = .225
11 Hours x .025 Rate = .275
8 Hours x .025 Rate = .200
----------------------------------
Total = 1.000 <---- Rounds here to 1.00

by: Houston A. | 10 months ago | Payroll / Job Cost