Usual hours
For the new flexible furlough scheme from 1st July we need to be able to get employee's usual hours in the 2019/20 tax year by calendar day (not rota/pay week) - how can we report on this?
E.G. 6-12 Jul 2020 is a pay week Monday to Sunday for us this year. The comparative period for usual hours in the new scheme is 6-12 Jul 2019, which was Saturday to Friday so included 2 days in one pay (rota) week and 5 days in the next. How do we get this data out of the payroll system?
-
Official comment
Hi Tsara Taylor
Thank you for your question.
We have recently published the following article around the new guidance for flexible furlough, which outlines the changes Fourth are planning to develop - this includes a function to extract the data for usual hours worked on specific dates. A release date hasn’t been confirmed just yet, however, this is one of our top priorities so please keep an eye out for release notes with further details.
In the meantime, should you wish to report on hours worked during a specific date range, outside of the rota dates, you can use one of the rota exports. Either the Employee Hours Worked export or the Forecast vs Actual vs Paid Hours – Daily export should provide this detail, both can be found in Rotas/Labour Productivity > Reports > Exports.
I hope this helps.
Best,
Lucy
Fourth
-
Hi Lucy
The export "Employee Hours Worked" doesn't help as it excludes holidays hours which have to be included in the reporting to HMRC
0 -
Hi Jamie Flarry
Thank you - yes, you're absolutely right, the rota reports don't include holiday hours, which is why we're working on some new functionality to make sure that all the necessary data can be extracted.
Best wishes,
Lucy
Fourth
0 -
HI Lucy Cunningham,
Is there any update on when we might be able to report on paid holiday hours yet? I haven't seen any relevant release notes yet.
Having to manually calculate for all employees week by week currently is super time consuming and we are aware we're not using the correct usual hours for the 2019/20 tax year until these hours are included.
Thanks,
0 -
Hi Tsara Taylor,
Thank you for this question.
The "Employee Hours Worked" export, in the Payroll Module, does report on holiday hours.
Perhaps this will be suitable?
Hope this helps.
Best,
Lauren
0 -
HI @...,
Thanks for the reply.
I've tried running this report today but it doesn't look right. Some people hardly have any increase in hours vs the rota version, despite having taken hols, some are being reported as having worked hours before they joined the business and some employees are duplicated on the reports each date range they are run for.
How can I submit a request for this to be checked?
Thanks,
Tsara
0 -
Sorry @... have just re-run a test report without ticking the furlough employees only and it potentially works correctly like that - do you know if there is an issue when ticking the furlough employees only?
These are the only employees we need the data for but if the data is corrupted when ticking that of course we won't do so and will filter out the excess manually.
0 -
Hey Tsara Taylor
In this instance, we would need to create a technical case in order to get some assistance with checking this.
You should receive an email notification shortly with a reference number, as I have raised a technical case on your behalf. Please do let us know if need anymore assistance.
Best,
Lauren
0
Please sign in to leave a comment.
Download Our App
Comments
8 comments