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