UK Payroll - Calculate hourly for leave/sick days
UK Payroll: Leave / Sick Days
Xero payroll nearly always miscalculates sick pay and absence deductions if staff are paid an annual salary for two reasons;
1) It works on average number of days in a month when month vary in working days every month and recalculates an inaccurate hourly rate from which it deducts absence (sometimes this is in favour of the employee but more commonly isn't) meaning that it often deducts too much from them and has to be manually recalculated.
2) It does not have the capability to deal with part-timers so if you have someone who works 3 days a week say (24 hours a week). If you post them as being off sick for those 3 days then unless you override the sick hours if will deduct 14.4 hours instead instead of their whole working week.
In response it would be better if Xero worked on actual hourly rate when deducting hours which can be quite easily re-programmed by taking the salary dividing by 52 and then dividing by hours worked in the week which is already input when putting in a salary which would solve the issue with full-time deductions being wrong.
Secondly, would be even better if you could enter a working pattern into Xero (as even full-timers often work different hours on different days) and then when you enter absence if used this and their actual hourly rate to compute the correct deduction.
As it stands at the moment it is getting pretty much 100% of absence deductions wrong.
Hi team, great to get your feedback and support through the idea here. We acknowledge the challenges with the current way we record leave hours and the impact this has on the calculation. We've started some work around this with the introduction of our new working patterns feature which support you in defining the actual hours worked each day
While in early stages at present we'll keep you updated on progress for this here.
-
Karl Adams commented
Xero defaults hours per day at 8 hours yet not all businesses have 8 hour working days. Need setting for user to confirm number of hours. Currently holiday allowance calculated incorrectly as a result and needs manually adjusting when approving. Also need option to select half day holiday, or set number of hours. It seems this option has disappeared from Xero Me app.