CenterPoint® Payroll - Payroll Employee Mass Update

Related Help

View or Print as PDF


This document provides examples for using the Setup > Payroll Details > Employee Mass Update menu can be used to update more than one employee's information at the same time. You can mass update various types of information deductions and benefits, earnings, payroll information, or taxes. You can update employees currently assigned to the item, update existing information and if the item is not assigned to an employee it can be added, or items can be added if they are not already assigned to employees.

Change Rates for Multiple Employees

Enter Pay Increases

Assign New Deduction/Benefit Rates

Add a new Earning to Multiple Employees

Add an existing Workers' Compensation Class to Multiple Employees where the Tax is Missing

Note: The Setup > Payroll > Employees menu selection also has a Mass Update button that can be used to update more than one employee's information at the same time. You can mass update various types information, including deductions and benefits, earnings, payroll information, leave, or taxes for employees that already have the specified information assigned. This option does not allow you to add information if it is missing or not previously assigned. For more information, see the Employee Mass Update topic.

 

 

Important Note: It is recommended to perform a backup of your database prior to completing the Payroll Employee Mass Update. For more information, see the Backup and/or Restore a Single User Database topic.

 

Change Rates for Multiple Employees

Rate changes for one employee can be done from the employee detail screens. When you have multiple employees with pay increases or insurance premium changes, save time using Employee Mass Update.

Enter Pay Increases

  1. Select Setup > Payroll Details > Employee Mass Update.
  2. The list of employees display. Select the employees you wish to update.
    • Click Select All to select all employees or select multiple employees by pressing the CTRL key while you make your selections.
    • When you select the earnings to update, an option is available to update only existing records. That means only employees already assigned to this earnings will be updated.
  3. Click Mass Update.
  4. In the Category box, select Earnings.
  5. In the Employer box, select the employer you want to update earnings for.
  6. On the right side of the screen, in the Method box, select the mass update method. In this example, we will select Update Existing Records Only.
    • Update Existing Records Only - Updates the earnings information on employees currently assigned to the earnings.
    • Update Existing/Add Missing Records - Updates all selected employees with the details. If the earning is not assigned to an employee, it is added. If the earning is currently assigned, it updates the details.
    • Only Add Record if Missing - Updates all selected employees that currently are NOT assigned to the earnings. If the employee is currently assigned, no changes are made.
  7. Select the earnings account you wish to update. The earnings detail displays at the right.

  1. Enter the changes for this earning. For example, in this example the new rate of $10.55 should replace the existing Hourly Pay rate effective 8/1/19.
  2. The Effective Date allows you to track past earnings rates for each employee.
    • In the Effective Date box, select the date the new rate begins. The new rate is applied in a pay run with a pay date on or after the effective date.
  1. In the Rate Update Method, select the method you want to use to update the rate.
  • Add to Existing Rate - Adds the amount entered in the rate field to the existing rate of an employee. The result is the employees can have different rates but all selected employees are increased by the specified amount.
  • Replace Existing Rate - Assigns the new amount entered in the rate field to each selected employee. The result is all selected employees would have the same rate.
  1. Enter other details you want updated to each selected employee.
    • Detail fields with no change should remain empty or not set. For example, an empty Expense Account box will not remove the expense account previously assigned to each employee. It will remain unchanged.
    • Details entered in other earnings fields will update all employees with the same detail. For example, if Salary Expense is entered in the Expense Account box then all employees Expense Account for this earning is updated to Salary Expense.
  2. Click Update when changes are completed.
  3. A list of changes displays for verification.
    • Each change lists an employee with the original information and the new information. The status indicates "Update".
    • Each added detail lists the employee with the new information and the status "Added.
    • If more than one detail is updated or added, the employee is listed for each change.

  1. Click Accept.
    • Click Reject to cancel the changes.
    • Click Print to print the list.

Assign New Deduction/Benefit Rates

  1. Select Setup > Payroll Details > Employee Mass Update.
  2. The list of employees display. Select the employees you wish to update.
    • Click Select All to select all employees or select multiple employees by pressing the CTRL key while you make your selections.
    • When you select the deduction/benefit to update, an option is available to update only existing records. That means only employees already assigned to this deduction/benefit will be updated.
  3. Click Mass Update.
  4. In the Category box, select Deductions/Benefits.
  5. In the Employer box, select the employer you want to update deduction/benefit for.
  6. On the right side of the screen, in the Method box, select the mass update method. In this example, we will select Update Existing Records Only.
    • Update Existing Records Only - Updates the deduction/benefitinformation on employees currently assigned to the deduction/benefit.
    • Update Existing/Add Missing Records - Updates all selected employees with the details. If the deduction/benefit is not assigned to an employee, it is added. If the deduction/benefit is currently assigned, it updates the details.
    • Only Add Record if Missing - Updates all selected employees that currently are NOT assigned to the deduction/benefit. If the employee is currently assigned, no changes are made.
  7. Select the deduction/benefit account you wish to update. The deduction/benefit detail displays at the right.

  1. Enter the changes for this deduction/benefit. For example, in this example the new rate of $14.56 should replace the existing Employee rate effective 9/30/19.
  2. The Effective Date allows you to track past deduction/benefit rates for each employee.
    • In the Effective Date box, select the date the new rate begins. The new rate is applied in a pay run with a pay date on or after the effective date.
  1. In the Rate Update Method, select the method you want to use to update the rate.
  • Add to Existing Rate - Adds the amount entered in the rate field to the existing rate of an employee. The result is the employees can have different rates but all selected employees are increased by the specified amount.
  • Replace Existing Rate - Assigns the new amount entered in the rate field to each selected employee. The result is all selected employees would have the same rate.
  1. Enter other details you want updated to each selected employee.
    • Detail fields with no change should remain empty or not set. For example, an empty Expense Account box will not remove the expense account previously assigned to each employee. It will remain unchanged.
    • Details entered in other earnings fields will update all employees with the same detail. For example, if Insurance Expense is entered in the Expense Account box then all employees Expense Account for this earning is updated to Insurance Expense.
  2. Click Update when changes are completed.
  3. A list of changes displays for verification.
    • Each change lists an employee with the original information and the new information. The status indicates "Update".
    • Each added detail lists the employee with the new information and the status "Added.
    • If more than one detail is updated or added, the employee is listed for each change.

  1. Click Accept.
    • Click Reject to cancel the changes.
    • Click Print to print the list.

Add a new Earning to Multiple Employees

  1. Select Setup > Payroll Details > Employee Mass Update.
  2. The list of employees display. Select the employees you wish to update.
    • Click Select All to select all employees or select multiple employees by pressing the CTRL key while you make your selections.
    • When you select the earnings to update, an option is available to update only existing records. That means only employees already assigned to this earnings will be updated.
  3. Click Mass Update.
  4. In the Category box, select Earnings.
  5. In the Employer box, select the employer you want to update earnings for.
  6. On the right side of the screen, in the Method box, select the mass update method. In this example, we will select Only Add Record if Missing.
    • Update Existing Records Only - Updates the earnings information on employees currently assigned to the earnings.
    • Update Existing/Add Missing Records - Updates all selected employees with the details. If the earning is not assigned to an employee, it is added. If the earning is currently assigned, it updates the details.
    • Only Add Record if Missing - Updates all selected employees that currently are NOT assigned to the earnings. If the employee is currently assigned, no changes are made.
  7. Select the earnings account you wish to update. The earnings detail displays at the right.

  1. Enter the changes for this earning. For example, in this example a new Bonus earning should be added to all employees.
  2. The Effective Date allows you to track past earnings rates for each employee.
    • In the Effective Date box, select the date the new rate begins. The new rate is applied in a pay run with a pay date on or after the effective date.
  1. In the Rate Update Method, select the method you want to use to update the rate.
  • Add to Existing Rate - Adds the amount entered in the rate field to the existing rate of an employee. The result is the employees can have different rates but all selected employees are increased by the specified amount.
  • Replace Existing Rate - Assigns the new amount entered in the rate field to each selected employee. The result is all selected employees would have the same rate.
  1. Enter other details you want updated to each selected employee.
    • Detail fields with no change should remain empty or not set. For example, an empty Expense Account box will not remove the expense account previously assigned to each employee. It will remain unchanged.
    • Details entered in other earnings fields will update all employees with the same detail. For example, if Salary Expense is entered in the Expense Account box then all employees Expense Account for this earning is updated to Salary Expense.
  2. Click Update when changes are completed.
  3. A list of changes displays for verification.
    • Each change lists an employee with the original information and the new information. The status indicates "Update".
    • Each added detail lists the employee with the new information and the status "Added.
    • If more than one detail is updated or added, the employee is listed for each change.

  1. Click Accept.
    • Click Reject to cancel the changes.
    • Click Print to print the list.

Add an existing Workers' Compensation Class to Multiple Employees where the Tax is Missing

  1. Select Setup > Payroll Details > Employee Mass Update.
  2. The list of employees display. Select the employees you wish to update.
    • Click Select All to select all employees or select multiple employees by pressing the CTRL key while you make your selections.
    • When you select the tax to update, an option is available to update only existing records. That means only employees already assigned to this tax will be updated.
  3. Click Mass Update.
  4. In the Category box, select Taxes.
  5. In the Employer box, select the employer you want to update tax for.
  6. On the right side of the screen, in the Method box, select the mass update method. In this example, we will select Only Add Record if Missing.
    • Update Existing Records Only - Updates the tax information on employees currently assigned to the earnings.
    • Update Existing/Add Missing Records - Updates all selected employees with the details. If the tax is not assigned to an employee, it is added. If the tax is currently assigned, it updates the details.
    • Only Add Record if Missing - Updates all selected employees that currently are NOT assigned to the tax . If the employee is currently assigned, no changes are made.
  7. Select the tax account you wish to update. The tax detail displays at the right.

  1. Enter the changes for this tax. For example, in this example Minnesota Workers' Compensation Class Bike Tour Guide should be added to multiple employees.
  2. The Effective Date allows you to track past taxes for each employee.
    • In the Effective Date box, select the effective date for the workers' compensation class.
  3. Enter other details you want updated to each selected employee.
    • Detail fields with no change should remain empty or not set. For example, an empty Expense Account box will not remove the expense account previously assigned to each employee. It will remain unchanged.
    • Details entered in other earnings fields will update all employees with the same detail. For example, if Tax Expense is entered in the Expense Account box then all employees Expense Account for this earnings is updated to Tax Expense.
  4. Click Update when changes are completed.
  5. A list of changes displays for verification.
    • Each change lists an employee with the original information and the new information. The status indicates "Update".
    • Each added detail lists the employee with the new information and the status "Added.
    • If more than one detail is updated or added, the employee is listed for each change.

  1. Click Accept.
    • Click Reject to cancel the changes.
    • Click Print to print the list.

Document: 3380