A Suspected Rounding Issue in Payslip Calculation

I’d like to report a minor issue found in a staff’s payslip. We suspect the discrepancy may be caused by the daily rate of RM119.35 multiplied by 4.5 days, which gives RM537.075.

It seems one calculation rounded this to RM537.08 (though the payslip still shows RM537.07), while another calculation didn’t round up at all. This caused a mismatch in the final amount shown.

Appreciate your help to review and clarify if there’s a rounding rule being applied inconsistently.

Sorry for the inconvenience caused.

This is very likely due to my oversight on the front end, that some values were based on server calculations, while others were “re-calculated” on the fly AGAIN on the front end.

Will look into this when I am free later as I am currently working on another task.

May i please to have an update notice if this has been fixed?

Hi,

Sorry for the late reply, as I was caught up in another task.

Anyhow, I have already fixed the issue and also prepare a new documentation on the rounding off method used for payroll calculation.

Here’s my fixed payslip:

The amount in individual title has adjusted to rounded-off amount, but the sub-total amount didn’t. 2267.65+537.08 should be equal to 2804.73 right?

Same old problem that I have reported last time under title “The calculation figure showing wrongly if round-off involved”.

Thanks for assist on this. :folded_hands:

Please read the explanation Rounding Method Used for Payroll Calculation

Hi Kapchew, here’s a suggestion: should we round off the individual figures first before calculating the total? This way the result will be more accurate, and the payslip figures will tally with the calculations.

May ignore me if you didnt agree on this. Thanks.

I am ignoring :sweat_smile:

Your accuracy is only for visual purpose.

My accuracy is the employee’s final total.

For your consideration, there is no issue with applying rounding to each individual figure before calculating the total, as this is also regarded as an accurate approach. However, under the current method, the payslip figures and the overall total may not tally, which could potentially raise questions from staff in the future, particularly for legal or banking purposes.

1 Like

For the avoidance of confusion, a special note is also added to the end of each payslip that reads:

“Note: The total has been calculated based on the unrounded amounts to ensure accuracy. Due to rounding, the sum of the displayed amounts may differ slightly from the total.”

It may not help on explain to banker i guess. :sweat_smile:
End up the payslip may not valid to be supporting document. Please take consideration on this, and will be appreciated.

But this payslip calculation didnt round up at total figure.
3700+85.48-537.075-372.05=2876.355
Total should be 2876.36 is it?

Will look into this later.

Need some rest now.

I agree with this approach. this is simple and easy to understand

Noted with thanks.

Hi,

This issue is now fixed, you may check again:


Now has become the Net Salary amount show in payslip and the Net Salary amount in payroll report not same.

OMG :person_facepalming:

Can you show me the complete payslip so that I could try to reproduce?