Dynamics Community Forum Thread Details

Calculating Vacation Pay - Canadian Payroll

We have a long time client that now wants to track Vacation Pay and we wanted to ask for some suggestions on how to best configure the Canadian Payroll system. We have it working for a number of clients but they are pretty simple hourly situations.

Situation

Client Employees are all Salary Pay code - however we have calculated the hours and the hourly rate and that is how they have been entering the Payroll. So each week they enter 40 hours at $xxx.xx per hour and it gets to the right 'Weekly' pay for the employee.

Now they want to start getting the Vacation information entered into the system and have it available to to the employee as we move forward.

Client has a WEEKLY pay cycle from Sunday to Saturday - paid the following Friday.

Example

Employee Bill (Salary) earns $72.12 per hour x 2080 hours per year for annual salary.

He has 20 Days or 160 Hours Vacation (units) as his entitlement for 2015 which calculates as

- 1.67 days or 13.33 hours per month

- .38 days or 3.08 hours per week

(edited for testing)

Question

How do we enter this information in to the following fields

Vacation Earning on the Salary Pay code card for each employee

The details on the Employee Card >> Vacation Pay summary button

Desired Outcome

The client would like to have the employee know the number of hours / days of Vacation they have earned to date - and this would include what they have not used from the prior period - sorry - what they earn in the prior year does not go away it rolls over to the new year. We would like to print the values on the Payroll Advice slip and think we have the fields figured out.

Suggestions?

After a bunch of hours and many coffee - this is what I came up with. If this is incorrect, can I get someone to post a correction please.

Solution

First needed to calculate what the Yearly Vacation entitlement was, as a percentage of the of the Hours Worked Per year.

160 hours / 2080 hours = 7.6923%

Just for additional confirmation - I figured out what the Weekly values would be, and adjusted for rounding - pretty close.

3.08 hours / 40 hours = 7.7%

Now where to enter

In the Payroll - Canada >> Control window - make sure that Vacation Pay is turned on. All the setup in the world makes no difference if this is not done.

Next, after figuring out the %'s you need to enter the 7.6923% into each of the Income Codes on which the person is going to earn Vacation Pay - yes all of them.