Employees' holiday pay has to be calculated over 52 weeks and has to not include any weeks where the employee has worked less than their normal hours (sickness and as of the last year, furlough). I'm struggling to find an easy way to calculate this using our current software which is Sage 50 Payroll, as there isn't a report which will allow me to put a 'from and to' date for average hours and average earnings. For example, when an employee that was on furlough is on holiday, the Sage 52 week averages report will include the furlough hours and pay. To discount these weeks i must run several other reports and enter them into a spreadsheet to find the average. I would be interested to know how other payroll clerks calculate the holiday pay and what software is best for this aspect of payroll. Also how do you enter it on their payslip. Thank you.