Skip to main content

Hi, How can we calculate what the payroll figures will be for the end of April and May (if possible)?

Comments

13 comments

  • Sophie Waters

    Hi AJ,

     

    Thank you for your questions. The development team are working on an export with information about hours and earnings that may help you with your payroll figures, this is due to be released next week. Please keep an eye on the Release notes area of the community as this will have all the information about what fields are included.

     

    The support team may have been referring to the 52 week holiday calculation, or our updates to the furlough functionality which are set for release tomorrow: https://fc.force.com/customer/s/article/WFM-Release-Note-Furloughed-Status-for-Employees

     

    Many thanks,

     

    Sophie.

    0
  • Rebecka Mustajarvi

    Hi AJ<

    0
  • Rebecka Mustajarvi

    ...and per government guidance we will select the higher of these amounts to pay staff. Will the furlough function be updated to included an option to input average earnings per payroll period rather than just "average hours" worked? And will this then pull through to the payroll module or will payments have to then be added manually also? I have read all the update notes but still unclear about this. Thanks for your help.

    0
  • Rebecka Mustajarvi

    Hi Sophie, as a follow up to this question, I have manually calculated average earnings for our furloughed staff ready for our next payroll based on the average of 2019-20 tax year and same period in previous year

    0
  • AJ Geach

    Hi Rebecka,

     

    Out of interest, did you use employees gross pay or number of hours worked? Personally, I think it should be based on pay.

     

    I carried out a similar exercise. Salaried staff is relatively simple, 80% of Feb.

    For the hourly paid employees, I spilt into two categories; those who have been employed for more than one year and less than one year. I exported pay details for all employees and then:

    • calculated an average over the year
    • compared with what they earned in April 2019
    • took the highest of these two values

     

    it would be interesting to know your thoughts?

    0
  • Rebecka Mustajarvi

    Sorry pressed enter too soon! Yes, I have followed the same method as this is to me in line with the government recommendations. I have used gross pay over tax year 2019-20 to calculate average earnings and compared this with the same pay period in 2019 - selected highest number of these and then taken 80% of that as the amount an employee should be paid. For employees who have worked a shorter period of time, I have taken average earnings over the period they have worked to get a correct average monthly pay. Until further guidance is issued from gov.uk I have included all basic gross pay (including SSP, ShPP, SMP and similar). I was hoping the Fourth functionality would allow for simply setting the 80% value of average gross earnings over each pay period for furloughed staff. If we have to base pay on average hours per week, then I have to calculate this in a somewhat artificial manner. Our reading of gov.uk guidance is also that employee furlough pay can change from period to period, to be in line with whatever the highest amount is per pay period (e.g. we expect staff to work more hours in May than April for example) - what are your thoughts on this?

    0
  • Sophie Waters

    Hi Rebecka,

     

    We have published an article today on the average pay calculation, I have linked to this below in case that helps you. It was created by our Product team now more information, including the average pay field, is available in the furlough page. The payments made will need to be made manually through payroll- we have some customers that are 'topping up' to 90 or 100% so couldn't make this an automatic feed through to payroll.

    https://fc.force.com/customer/s/article/WFM-Average-Pay-Calculation

     

    Many thanks,

    Sophie

    0
  • Rebecka Mustajarvi

    Thanks Sophie, that's a helpful update. Understood re: payments needing to be manually put through payroll. Can you clarify what the purpose of setting the average hours worked in the Covid function is please? Is that to ensure that holiday continues to accrue based on average hours worked prior to being put on furlough? Just want to understand what implications of that figure is on other calculations within the HR or Payroll module. Thank you!

    0
  • Sophie Waters

    Hi Rebecka,

     

    We added that figure so that it was easy to have for reporting, we've also added these fields into our API so that any 3rd parties our customers use that need this information can use these figures. There are no implications of the figure on the rest of the system, it's there to help reporting and to calculate furlough payments.

     

    Many thanks,

     

    Sophie

    0
  • Natalija Cristea

    @Sophie Waters​ Hello Sophie, can these figures be exported somehow so we do not need to add payments manually for every employee?

    0
  • Sophie Waters

    Hi Natalija,

     

    We are releasing an export later this week so that you have this information to use for your payroll uploads. Please check the release note area tomorrow .

     

    Many thanks,

     

    Sophie

    0
  • Rebecka Mustajarvi

    {@005D0000001bZlVIAU}​ Hi Sophie, I just wanted to flag a data error I encountered when using the custom report that Fourth has suggested for the average pay calculation in the article you linked to (https://fc.force.com/customer/s/article/WFM-Average-Pay-Calculation). I have set up the custom report and downloaded data as csv and then manipulated in Excel - unfortunately the data throws up an error when an employee is paid the same amount twice on one payslip. For example we have employees that have worked the same hours two weeks in a row generating the same gross pay amount twice on the same payslip (for example £361) - when this has happened the csv data only includes one of the gross pay amounts in the payslip period (i.e. just £361 rather than two counts of £361), not two - i.e. showing the employee as having earned less than they did. I am able to correct this manually but someone with a larger staff may not - and this could throw someone's earnings out by quite a large amount if it happens on several occasions during the year. Just wanted to make you aware in case this is system wide and will affect other customers also. Best, Rebecka

    0
  • Sophie Waters

    Hi Rebecka,

     

    Thank you for the information- would you be able to raise this as a case with our service team so we can look into this- if you go to your profile in the top right hand corner and click 'new case' you'll be able to do this.

     

    Many thanks,

     

    Sophie

    0

Please sign in to leave a comment.