Access: Employee file > Tools > Mass update > Earnings and deductions
1Under Filters, if you have more than one company, select a Company, then select the search filters.
Tips and tricks For companies operating in the construction sector and offering non-CCQ employment, it may be useful to check the CCQ employee filter to target this group of employees. Working conditions may differ. |
2If needed, use the Criteria section to obtain a more precise employee list.
▪Select the Field to modify from the drop-down list.
▪If you select “Earnings/Deductions (Qty/%/Amt/Rt)”, you must select an earning or deduction code from the Earnings and deductions drop-down list as well as its Status.
▪Identify the Operator, and then enter a Value.
3Specify the Employees sort order under Sort.
4Under Earnings and deductions to be added or modified, select the earning or deduction in Selection.
▪The earnings related to a bank or a holiday are excluded from the mass update.
5Select an Operator for the Qty/%/Amt/Rt criteria, then enter a Value.
▪If you select the “Massive entry” operator, you will need to manually enter a value for each employee in the next screen.
6Fill in the fields as needed. Select an operator immediately or leave “massive entry” as it is to manually enter the values in the next screen.
Things to remember Field specifics: ▪Status: this field allows you to determine a modification status. If you select “skip” or “tempo”, the Start status and End status fields will allow you to specify the desired period. ▪Quantity: this field is available only if you selected an earning code which has a variable rate (e.g. training, premium, overtime, etc.). ▪Minimum and Maximum: this field is available only if the earning or deduction configured according to a minimum and a maximum (e.g. union, retirement fund). ▪Cumulated: this field allows you to update the year-to-date amounts of an earning or a deduction (e.g. an RRSP for a business acquisition). ▪% Distribution: this field is available only to cost distribution users. |
7Under Modification history, select the Modification reason.
▪The reason for the modification will be available in the history section of the Modifications to the employee file.
8Click on the one of the following three buttons:
▪Modify by page: To display the selected employee group modification list.
▪Batch simulation: To verify the data and the selected employee list before massively modifying the information. A report is generated including rejections and the associated error messages, where applicable.
▪Batch save: To directly carry out a mass modification to the employee files. A report is generated making it possible to view the rejections and the associated error messages, where applicable.
Modify by page:
| 9a | In the List of modifications, you can exclude employees from the mass modification by unchecking the box in front of each employee in question. |
| 9b | Ensure that the requested modifications are correct. Where necessary, modify the data in the modifiable fields and click on Save to save the changes and continue with the process. |
Things to remember ▪Click on the Selection criteria hyperlink to see the selection criteria defined at the previous step. ▪Check or uncheck the header box to select all employees. This may be useful when there are several pages and an entire page must be removed. ▪If your company uses cost distribution, the % dist. (Current and New) and CD columns are displayed. These columns allow you to check a box in order to distribute the cost percentage (only if the employee has cost distribution in their file) or to click on the ▪If there is an error, the |
Batch simulation:
| 10a | Click on Batch simulation. |
| 10b | In the Mass modification results screen, select the “Simulation” report type by clicking on the Earnings and deductions hyperlink. |
| 10c | If you are satisfied with the result, click on  . In the displayed window, click on Recover these criteria for a new mass update to carry out a batch save. |
Batch save:
| 11a | Click on Batch save to do an employee mass modification. |
| 11b | In the confirmation window, click on OK. |
| 11c | In the Mass modification results, select the “Execution” report type by clicking on the Earnings and deductions hyperlink. |
For more information