How can I run a report on the average pay that is shown in the Furlough page as this is shown in Hours and I need the calculation in Hours so I can apply the new NMW/LW rates to the average hours.
-
Thank you I have read the notes however my concern is around exporting what is in the furlough page out of the system into Excel. Am I correct in thinking that if we pay our employees hours x NMW then I need to pay the furlough pay on the average of the 52 weeks hours x the April 20 NMW?
0 -
Hi Laura,
Thanks for the question. We have published an article this afternoon on the average pay calculation and some reporting that may help you, the link is below. Alternatively, you could run a custom report in the HR module to find the employee's average hours.
https://fc.force.com/customer/s/article/WFM-Average-Pay-Calculation
Many thanks,
Sophie.
0 -
Hi Laura,
Thanks for the follow up. That is our understanding, that the employees should be paid on the April updated NMW/NLW. The export we are working on for the furlough page and information is currently in testing and should be released at some point next week.
Many thanks,
Sophie.
0 -
The guidance on gov.uk is to use the average earnings, not the average hours and that even if the 80% takes them below NMW this is not relevant as they are not working.
Therefore my understanding is that furlough pay would be based on 2019/20 pay (be it salaried pay for Feb or variable being the higher of 19/20 average or amount paid in same month last year).
The only time the new rates will be applied is if the employee completes any training or returns to work.
0 -
I have this question too - why is the furlough status screen focusing on average hours at all? Furlough pay that can be reclaimed is based on average pay so hours would appear to be irrelevant - they may have been on a different pay rate during the YTD or the same period last year, especially given timing of NMW changes.
Is there going to be a way to calculate average pay YTD or do we need to manually do this?
Does the hours/£ in the furlough status actually feed through to anywhere?
We are currently not setting any flexible workers as furloughed in the system, despite 100% of them having been furloughed for the past at least 3 weeks, purely because we still don't think we have the information required to understand what setting this status will do. If it will impact amounts we can claim and or amounts staff will be paid we cannot use the furlough status screens until they have the correct average pay information.
0 -
Hi Tsara,
We have updated the employee's furlough page with earnings, I'm not sure if you've seen that release but the updated release note is here: https://fc.force.com/customer/s/article/WFM-Release-Note-Furloughed-Status-for-Employees
When the functionality was first released we were awaiting more information on the calculation so used the hours at that point, we have now enhanced the calculation.
The information in the furlough page doesn't feed through to anywhere, we released our batch update page and our furlough export this morning so that the export could be used, if needed, to help calculate payroll figures.
Any furlough payments will need to be loaded into the payroll module (in lieu of any hours coming from rotas) so whether you want to use the export linked to the furlough page, or work out figures yourselves, either are fine.
Many thanks,
Sophie
0 -
Sorry {@005D0000001bZlVIAU} , I have another related questions.
I can see the average pay calculation in the batch furlough export, however the figures we calculated originally when we just needed something for weekly payroll (we did a 12 week average employee by employee calculation) are in some cases very different to the figure in the export. It's most notable on newer employees.
For example we have an employee that started 9th Feb who's average pay per the Furlough export is over £100 a week less than we have calculated and been paying. How can I see what the figure in the report is based on? As he has only been with us a short time I have checked each payslip and tried adjusting the average calculation over shorter number of weeks etc but I can't work out what the export is based on.
I am hoping we can rely on the export as the basis for our CJRS claim but with variances this large on some employees I can't do that without understanding why it might be different. If it is an anomaly on newer starters we can perhaps continue with our calculations for these but use the export average pay for people that have been with us for the whole 2019/20 tax year?
Thanks,
Tsara
0 -
Hi Tsara,
Here is the link to the article our Product team has written on the average pay calculation: https://fc.force.com/customer/s/article/WFM-Average-Pay-Calculation
We appreciate that for some new starters you may need to work out their furlough pay manually as if the employee has only been paid for a part pay period the calculation would just look at that. The export can be used for those that have been in the business longer.
Many thanks,
Sophie
0
Please sign in to leave a comment.
Download Our App
Comments
8 comments