Standard Canadian Report - ON Statutory Holiday Report_CA

Report Description

Like American holidays, some Canadian holidays, though recognized, do not garner paid days off. Along with federally recognized holidays, Canada also has provincial and territorial holidays. Even though they're celebrated nationally, vacation is not paid for Valentine's Day, Mother's Day, St. Patrick's Day, Father's Day, or Halloween. Statutory holidays - which include New Year's Day, Good Friday (Easter), Canada Day, Labour Day and Christmas Day - are celebrated nationwide and are paid days off for employees. Federally regulated employees also get Easter Monday, Victoria Day, Thanksgiving and Boxing Day off and it is common practice, however, not required, for non-federal employees to get these holidays off as well.

How to Use

The purpose of this report is to calculate holiday pay for an employee. The calculation for Ontario statutory holiday pay is described as:

"Total amount of regular wages earned and vacation pay four work weeks before the work week in which the public holiday occurred, divided by 20. The four weeks before the public holiday is based on the employer’s work week. For example, instead of a Monday to Sunday work week, it could be a Sunday to Saturday work week." - Push Operations

Therefore, users should run this report using an End Date of the beginning of the Week Worked that includes the holiday and a Start Date 4 weeks before. 

Example: To calculate holiday pay for Christmas Day 2020 for an assignment with a week worked start date of Sunday, December 20th, the Start Date should be 11/22/2020 and the End Date should be 12/20/2020. 

Parameters

Parameter Name	Options	Explanation
Branch	All branches available in the company.
Employee Name	Enter a specific employee's name or the "%" symbol which retrieves all employees qualifying for this report.
Start Date	Calendar date	The beginning date of the information period.
End Date	Calendar date	The ending date of the information period.
Assignment Date 1	Calendar date	This value is used to help single out a specific assignment date. Select a specific date for an assignment that falls between the start date and end date.
Assignment Date 2	Calendar date	This value is used to help single out a specific assignment date. Select a second specific date for an assignment that falls between the start date and end date.
Group By	Branch, None
Pay Codes	All, Reg, OT, DT, Bonus, etc.

Report Fields

Field Name	Explanation
Emp. ID	The employee's unique ID.
Employee Name	The name of the employee receiving holiday pay.
Wage Earned	The amount of pay earned by the employee during the time period.
Holiday Pay	The amount of holiday pay earned by the employee during the time period.
Assignment Date1	The Assignment Date 1 value is used to help single out a specific assignment date. This column displays “True” if the parameter Assignment Date 1 falls between the start date and end date of an assignment. If the parameter Assignment Date 1 falls outside of an assignment's start and end date, the value will display as "False." If the assignment has been deleted, there will be no performance code.
Assignment Date2	The Assignment Date 2 value is used to help single out a specific assignment date. This column displays “True” if the parameter Assignment Date 2 falls between the start date and end date of an assignment.  If the parameter Assignment Date 1 falls outside of an assignment's start and end date, the value will display as "False." If the assignment has been deleted, there will be no performance code.

3rd party link Disclaimer: These links are being provided as a convenience and for informational purposes only; they do not constitute an endorsement or an approval by [The author] of any of the products, services or opinions of the corporation or organization or individual. [The author] bears no responsibility for the accuracy, legality or content of the external site or for that of subsequent links. Contact the external site for answers to questions regarding its content.