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 hourHours 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.