Thanks for the detailed information.
I have identified the cause of this issue. It’s because exported data in Excel file is using round-half-up method, which is causing the inconsistency with payslip result.
To resolve this issue, I have decided to change existing rounding method to round-half-up method too, so that the final results between payslips and exported Excel data will be consistent: Rounding Method Used for Payroll Calculation
You may check your result to confirm.
If the rounded figures in calculations and those shown on the payslip keep causing discrepancies, why not display amounts up to 3 decimal places on the payslip? This way, people won’t get confused when the rounded figures don’t exactly tally with the net salary calculation.
- That’s a potential way to go, but 3 decimals may not seem like a common display for most people
- Instead, I think I might provide an option for rounding off methods in future
That’s sound great! Appreciated
Hi Admin, new problem occurred on rounding figure again.
- Payroll excel file that generated, the net salary figure is 3 decimals.
- Not tally the net salary figure show on website payslip vs excel payroll file.
Salary A:
Website: RM 1125.22
Excel: RM 1125.225
Salary B:
Website: RM694.46
Excel: RM694.455
Problems:
- Some net salary on website are rounded up, some are not (Salary A vs Salary B).
- Payroll excel net salary generate 3 decimals figure.
Hi,
Kindly visit this post: Rounding Method Used for Payroll Calculation
As explained:
All the original decimal points are preserved. The rounding up is only for consistent display only.
Please refer to the 2 photos that I have attached.
Staff A net salary is total RM1125.225 in excel file, but on HR.my payslip showing RM1125.22, which should be rounding up to RM1125.23.
For example like the salary of the another staff that showing in photos. Staff B net salary is total RM 694.455, and HR.my payslip showing RM 694.46, and this has round up, **BUT staff A didn’t round up.
**
Staff A: Excel file RM1125.225; while payslip showing RM1125.22 (THIS DIDN’T ROUND UP)
Staff B: Excel file RM694.455; while payslip showing RM694.46 (BUT DID THIS ROUND UP)
Can you give me the payslip details, so that I could try to repeat and see what happens.
Thanks for sharing the payslip details.
I have fixed this issue, please try again.