QuickBooks HelpQuickBooksHelpIntuit

Set up Pay Conditions using Rule Sets

SOLVEDby QuickBooksQuickBooks Online2Updated November 26, 2021

Learn how to use Rule Sets to create pay conditions for selected employees.

Most industries have some form of pay conditions – whether it be 150% hourly rate on a Saturday, a tool allowance or overtime for working past midnight.

In order to support these complex requirements, we’ve designed an easy-to-use rules engine that supports a variety of different conditions and actions.

The pay conditions engine is not designed to work on its own. Instead, it works in partnership with the following other features in order to provide comprehensive pay conditions support:

Create a rule set

To get started with pay conditions, let's create a rule set.

  1. Select Employees, then select Payroll Settings.
  2. Select Rule Sets under Pay Conditions.
  3. Select Add.
  4. Name the rule set, and define the period for the rule set (example given below).
  5. Select Save.

 

Create

Defining Rules

Next, you can define rules to be included in your rule set. Select the Edit Rules button to go into the rules editor. The rule example below shows assigning the ‘public holiday overtime’ pay category to any hours worked outside of ordinary hours on a Sunday.

Note that to use the ‘Public Holiday’ condition, you must be sure to check your public holidays in the Public Holiday calendar interface and to configure the states for your locations accordingly.

The system will provide an up to date set of State and Federal public holidays in each business, automatically. Local/regional and company authorised (e.g. picnic days) public holidays will need to be added manually.

Defining

There are a number of actions and conditions that you can use already (with more to come). We’ve created a separate page that documents each of the conditions and actions.

After selecting Save, the editor will be replaced with a display-version of the rule:

full

You can define as many rules as necessary. Note that when rules are evaluated, they are done so in the order shown on the page, from top to bottom.

draft

If you need to re-order the rules, select the Reorder button and then you can drag the rules around to re-order them.

Testing rules

Once we’ve defined our rules, the next step in the workflow is to test them. Select Test Rules next to the rule set to apply your rules to a set of sample shifts so that you can verify that the output and shift costings are as expected.

Testing

Once you select the timesheet period and enter the shifts, you can choose to cost the shifts using either a pay rate template or to simulate the costings using an actual employee. Select Run Test and then the results will be shown below.

Run

You can go back and edit the rules until you’re satisfied that the output from the test interface is correct. Once you’re satisfied, select Activate Draft Rules.

Activate

The system will keep an active rule set and a draft rule set for you so that you can continue working on changes to a rule set without inadvertently impacting any employees that are associated with the rule set.

Once you’re happy with your changes, select Activate Draft Rules again and any future pay runs will use the new version of the rules.

Applying rules

The next step is to assign the rule set to your employees.

  1. Select Employees, then select the employee's name to enter their settings.
  2. Select Pay Run Defaults.
  3. Navigate to the Pay Condition Rule Set dropdown menu and select the rule set you created.

Applying

This rule set, in combination with a pay rate template and a leave allowance template, mean that setup for an employee is streamlined and consistent.

Now, whenever we import timesheets into a pay run, if the employee is associated with a rule set, their timesheets will be processed through the pay condition engine.

Once the timesheets are imported and the shifts interpreted, there will be an indicator in the pay run to show the rule set that was applied for the employee.

Timesheets.png

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Online Payroll Advanced

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this