vacation hours paid in stat holiday calculation

In calculating the total hours used in determining what to pay an employee for a statutory holiday, we need to accumulate the last 20 days of regular hours worked, plus vacation hours paid. Simply can tell me the hours worked, but I need to do a manual calculation to determine the vacation hours paid out.

 As an example:

Employee rate is $20.00 per hour
Hours paid week ending August 9        44
Vacation week ending August 16           Paid $800.00
Hours paid week ending August 23       40
Hours paid week ending August 30       44

 I owe him a stat day pay of (44+40+44+ ($800/$20)) = 168 hours. That is divided by 20 days to get the daily average of 8.4 hours. He is then paid 8.4 hours for the Labour Day Monday stat holiday. The way the system records things, I have to keep a separate ledger for all payroll transactions to ensure that we can pay the employees correctly. That seems to be a duplication of labour because of this. Can Simply not calculate this information without me keeping another set of books.
  • FormerMember
    FormerMember

    Hi there:  If the employee's normal daily hours are 8 and his normal weekly hours are 40, I believe you don't have to do all that calculating in order to pay him for the Stat.  Just pay 8 hours.  I have never heard of having to base the stat on all the hours worked, including overtime. Is it a union contract thing?   I know that Simply Basic 2008 cannot do this kind of calculating.  Maybe a higher version that uses Time Slips might be able to do it.  Anybody else out there know??        Rita Deering

  • Hello:

    I took this from the ESA site: "

    Public holiday pay is an amount equal to an employee’s regular wages earned in the four work weeks prior to Labour Day plus any vacation pay payable during that period, divided by 20.

    The staff work variable hours, so selecting 8 hours a day isn't accurate enough for my boss. I end up taking reg hours from Simply for 3 weeks pay and divide the vacation paid by his hourly rate to know the number of hours to include, when he wasn't here.

    I hope I am not repeating myself too much. I was hoping that this was a universal hiccup and that someone would have created a Crystal Report that combined the regular hours worked plus a calculation of vacation paid/hourly rate.

    Do you know of anyone who has ventured into this and created a report?

    Thanks

    Gary

  • FormerMember
    FormerMember

    Hi again:  What is an ESA site?     Rita Deering

  • Good Morning again:

    Thanks for sticking with me on this question. The ESA is the Employment Standards Act. I am in Ontario. The site is at http://www.labour.gov.on.ca/english/es/

    Gary

  • FormerMember
    FormerMember

    Gassels said:
    Public holiday pay is an amount equal to an employee’s regular wages earned in the four work weeks prior to Labour Day plus any vacation pay payable during that period, divided by 20.

    FYI the “vacation pay payable during that period” refers to the at least 4% of the wages earned during the period not the paid vacation time taken during the period

     

  • Hi:

    This section of the Act sounds different:

    Vacation pay payable includes any vacation pay owed to an employee who takes a vacation in the four work weeks before the public holiday (or substitute holiday). It also includes vacation pay owed to an employee who has agreed in writing that it will be paid either on each pay cheque or at any other time, if the payment is due during those four work weeks.

    Wouldn't that be vacation paid during this time period?

    Gary

  • FormerMember
    FormerMember

    Hi there:  Sometime after I asked you the question of what ESA was, it came to me that it was Employment Standards Act.  However, we have completely different rules here in B.C. than in Ontario so that's my confusion over your query.  You clearly are required to work out the entitlement it seems.  Simply cannot do that kind of calculation for you unless like I said before it has that capability in the Time Slips module.   What a lot of work to keep track of all that!  I don't envy you.   Rita

  • Thank you. I appreciate your condolences. I would like to know if anyone in Ontario has made a crystal report to handle this?

    Gary

  • FormerMember
    FormerMember

    Gassels said:
    Hi:

    This section of the Act sounds different:

    Vacation pay payable

    includes any vacation pay owed to an employee who takes a vacation in the four work weeks before the public holiday (or substitute holiday). It also includes vacation pay owed to an employee who has agreed in writing that it will be paid either on each pay cheque or at any other time, if the payment is due during those four work weeks.

    Wouldn't that be vacation paid during this time period?

    Gary

    No, it does not. The key word that you are overlooking  in those sentences is “owed”.