Rounding is necessary in payroll for several reasons:
- You can only actually "pay" an employee to 2 decimal points (you won't see any more than 2 decimal places on the list of transactions in your bank account).
- An employee's hourly rate might be calculated from an annual salary figure.
- A pay category can be set to have a rate precision of up to 5 decimal places.
In the pay run
The rounding in the pay run happens when the gross earnings total is calculated. Meaning, all of the employee's earnings lines are totalled and then that figure is rounded to two decimal points.
Note in this example, the sum of the earnings lines is RM5,000.00055, so this is rounded to RM5,000.00.
This rounding is necessary because we give users the option to set a pay category to use up to 5 decimal places when calculating employee earnings in the pay run (the rate precision field is in the pay category settings, click here for more information on pay category settings).
If you're calculating earnings to 5 decimal places in the pay run then at some point you need to round the earnings down to 2 decimal points (so you can pay your employee net earnings with 2 decimal places).
In the Pay Run Journal
The rounding for pay run journals happens on each line...
... but as you can see in this example, the total earnings figure in the journal will vary (by 1sen) from the gross earnings figure in the pay run so when that happens, the system will add a 1sen balancing entry (because the journal has to balance).
By default, the earnings line that we choose to put the 1sen balancing entry on in the journal is an earnings line using the employee's Primary Pay Category (as set on the Pay Run Defaults page). If there are no earnings lines using the Primary Pay Category we'll put the 1sen against the pay category/earnings line with the highest earnings total. If there are multiple earnings lines using different pay categories with the equal highest total, one is chosen at random.
Year to date (YTD) figures
On the pay slip YTD figures displayed on the pay slip are rounded once only, at the end of the most recent pay period. Meaning, the YTD figure you see on the pay slip is calculated by totalling up all unrounded earnings lines from all pay runs for the basis period to date for that employee, and then rounding that total to 2 decimal points. So, the rounding on the last pay slip (at the end of the basis period) is the total of all earnings lines for the whole basis period. This is why you'll occasionally see a small variation between the total earnings figure for the basis period on the reports when compared to the YTD figure on the pay slip.
In Reports
Reports and payslips round each earnings line individually - as per the pay run journal method, using bankers rounding. So reports and payslips will show the total of all of the (already rounded) earnings figures from each pay run.
Leave Requests
Bankers rounding rounds to the nearest even number rather than always rounding up. This is a standard approach that provides a more accurate total when rounding multiple values. However, the leave request and balance pages round to 2 decimal places using bankers rounding, i.e., rounding up.
Here’s an example using an employee’s leave balance:
- Accrual (20/06/2024 to 03/07/2024): 3.5384 hours
- Accrual (04/07/2024 to 17/07/2024): 2.47688 hours
- Opening Balance: 251.13 hours
- Balance Total: 257.14528 hours (actual balance)
The leave balances page rounds to 2 decimal places using bankers rounding, so the available balance would be 257.15 hours.
If we enter 257.14528 hours into the leave request, it’s green because that is the employee's actual balance. Anything above that turns red. If we enter 257.15 hours (displayed balance), the leave request appears as insufficient.