Description

Out of the box, Harmony provides a Statutory Holiday Pay report that automatically calculates statutory holiday pay for employees according to the provincial rules. You do not need to use this method if you are using the statutory holiday pay payroll category. If you are using this method, review this article instead. 

Warning: We strongly recommend for you to review a handful of employees to ensure calculations are as expected prior to inserting the values into your pay run.

Prerequisites

  • Created a statutory holiday pay payroll category as a regular earning (do not use the Statutory Holiday Pay payroll category class)

Solution

  1. Navigate to Payroll > Reports > Reports. 
  2. Look for the Statutory Holiday Pay report. Click the three (3) dots to select the report. 
  3. The filters and parameters will appear on the right side. Enter the required parameters. You may also use the filters provided if necessary.

    1. "Department" is a filter so you can filter the report by department. This is optional.
    2. "Payroll Group" identifies the payroll group of which you want to generate this report for.
    3. "EI Group" refers to the EI group or business number of which you want to generate this report for. This is optional.  
    4. "Holiday Date" refers to the date of the holiday. For example, enter "July 1" of the current year for Canada Day. Ensure that you enter the date of which the holiday is observed.
    5. "Wages" refer to the payroll categories that contribute to statutory holiday pay calculation, such as hourly wages and overtime. You may have other payroll categories that contribute to the calculations, so ensure that you select all possible payroll categories. 
    6. "Working Week Start Date" refers to the day of the week of which your working week starts. 
    7. "Province and Rule" identifies the province/territory and rule that you want to generate the report for. Beware that some provinces and territories may have more than one rule, so ensure that you are selecting the correct rule. 
    8. "Include all employees regardless of tax province" is a checkbox that you can tick or untick depending on your preference. If ticked, all employees (even if they do not belong to the select "Province and rule" from the point above) will be included in the report. If unticked, the report will only show the employees whose tax province is the same as the "Province and rule" that you selected above. 
  4. Click the "Open" button to generate the report. 
  5. The report viewer will open and provide the dollar values for each employee. 
    Tip: We recommend generating this report in the middle of your pay run for accuracy (after processing paycards), if the holiday date falls in the middle of your pay period. The report will take into consideration the wages for the current pay period. 
  6. You may use this report when you are processing a payroll. In Step 3 of the Payroll Wizard (Process Payroll), after processing the paycards, open a paycard and click the "Edit" button. Insert the value from the report into the statutory holiday pay payroll category earning. Click "Process" to save your changes and reprocess the taxes. Repeat this step for each applicable employee.