cancel
Showing results for 
Search instead for 
Did you mean: 
QuickBooksHelp
Intuit

How to update employee pay rates

Learn how to update pay rates for individual employees and in bulk through QuickBooks Payroll powered by KeyPay.

Update an individual employee's pay rate

  1. Select Employees from the left menu.
  2. Select the employee's name, then select Pay Rates from the left menu.
  3. You will be presented with a list pay categories. Select the field under the Rate column next to the pay rate you want to update and enter the new pay rate.
  4. Navigate to the bottom of the page and select Save.

Notes:

  • Changes to pay rates apply from the day after the end date of the most recent pay run the employee has been included in. This date will be displayed below the Save button.
  • If the rate field is locked, this means all pay rate changes need to be made from the Pay Rate Template. To update the pay rate template:
    1. Select Employees from the left menu.
    2. Select Payroll Settings, then select Pay Rate Templates under the Pay Conditions column.
    3. Select the pay rate template associated with the employee, then update the pay rates accordingly.
    4. Select Save once complete.

Update employee pay rates in bulk

You can update up to 200 employees' pay rates at a time using the Update pay rates feature:

  1. Select Employees from the left menu.
  2. Select Payroll Settings, then select Update pay rates under the Pay Conditions column.
  3. Select Add employees, then use the Search by drop-down menu to select a category
  4. Select the second drop-down menu to narrow down the selection, and then you'll be presented with a list of employees that fit the criteria. You can also use the Search employee box to find specific employees who are not part of the list.
  5. Tick the employees you wish to update pay rates for.
  6. Select Save once you've finished selecting employees.

You will now be presented with a table of all selected employees. Here's how to make edits to their pay rates:

  1. In the Adjustment column, select the drop-down menu to choose if you want to update by a fixed amount ($) or percentage (%). The drop-down next to Adjustment will apply the settings to all employees, while the drop-down next to each employee's adjustment field will only apply to that particular employee.
  2. Update the fields with the adjustment amount (up to 5 decimal places) or percentage and hit the Enter key on your keyboard. The Future pay rate column will be updated with the new pay rate amount.
  3. Select the down arrow ↓ to apply the adjustment amount or percentage to all employees if needed.
  4. Enter the Commencement date of the new pay rate.
  5. Select the down arrow ↓ to apply the same commencement date to all employees if needed.
  6. Select Save new pay rates once done.

Employee file changes after bulk pay rate updates

Once bulk pay rates have been saved AND if the commencement date is the current date, the following applies:

  • The future pay rate value will be set as the employee's pay rate in their Pay Run Defaults screen
  • This will be effective from the current date and therefore not be set up as an "upcoming" rate change

Once bulk pay rates have been saved AND if the commencement date is a future date, the following applies:

  • The future pay rate value and the commencement date value will be used to create an upcoming rate change:
    upcomingratechange2_qbop_au_ext_010721.jpg

Upcoming Rate Change

If an existing upcoming rate change has been set up for an employee, and you add them to the list again, an indicator will display, as shown below:

Then, if you try to add another rate change with the same commencement date, the below warning will display when save is selected (and the new rate will override the existing rate change):

Linked Pay Rate Template

If an employee is linked to a pay rate template, and their pay rate is updated via this process, a warning will display and the pay rate will display as 'overridden' in the pay run defaults screen:

Existing Pay Run

If an employee is included in an existing pay run that includes the commencement date, the new pay rate cannot be applied. A warning will display to advise of this:

In this scenario, if you click 'OK', the employees listed in the warning will be excluded from the update and no change will be applied to their existing pay rates. Employees who were not displayed in the warning and have a ‘future pay rate’ listed in the grid, will have the rate change applied.

If you select 'Cancel', you will be taken back to the ‘update pay rates screen’ with no changes saved. The values previously displayed will continue to display for editing.

Content sourced from KeyPay

Was this helpful?

You must sign in to vote, reply, or post