QuickBooks Time users report overlap confusion in overtime calculations
QuickBooks Time users are seeing one overtime rule win when shifts match daily, weekly, holiday, or time-of-day rules. Here is how that works.
QuickBooks Time users in the UK are reporting confusion when a single timesheet matches more than one overtime rule. The Pay Rate Engine does not stack those rules. Instead, it selects one rule for each block of regular time, and the accepted community guidance makes clear that this is by design.
The symptom teams notice
Pay runs look wrong even when every overtime rule has been configured. A night shift that also falls on a holiday may receive the evening premium but not the holiday premium. A long week may show daily overtime only, with no weekly overtime added. Users checking their reports see one rule applied and assume the settings are broken.
The pattern is easiest to spot in mixed schedules. A worker may be entitled to several premiums in theory, but the engine will not combine them on the same hours. The accepted answer confirms that once a timesheet has had a rule applied, another rule cannot be applied to that same time.
How competing rules are assessed
The Pay Rate Engine calculates daily, consecutive days, time of day, and holiday rules on the day the timesheet is created. If more than one of those rules could apply, the rule with the highest rate multiplier wins. Weekly overtime is handled differently. It waits until the regular-hour threshold has been met, usually 40 hours, before it applies.
Shift differential and holiday hours are treated as overtime by the engine even when a business does not classify them that way. If one of those rules applies first, no other rule will be applied to that time. Users often find this surprising because the payroll system may treat the same hours differently.
Daily rules arrive before weekly rules
Because daily rules are applied before weekly rules, a week that crosses the 40-hour mark on a final day may not produce the weekly overtime you expected. For example, a schedule of eight hours on four days and nine hours on the fifth shows one hour of daily overtime on that fifth day, not a combined daily and weekly amount.
Overtime rules only apply to regular time. Time off, breaks, and time already marked as overtime are not eligible for a second rule. That is why a timesheet cannot carry both a shift differential and weekly overtime. It has one or the other.
The QuickBooks Online Payroll limit
When time exports to QuickBooks Online Payroll, mapping creates another constraint. The payroll needs the employee pay types added, and the overtime exported from QuickBooks Time needs to be mapped to the right pay type in the rule editor.
The accepted solution notes that the Pay Rate Engine supports rates of 1.5x or 2.0x for mapping to the Overtime Pay Type and Double Overtime Pay Type in QuickBooks Online Payroll. A custom multiplier outside those two will not map cleanly to the standard overtime and double overtime pay types.
How teams get the calculation back on track
Review the rules with the highest multiplier first, because that is the one the engine will choose when daily-style rules compete. If you expect weekly overtime on top of a daily or holiday premium, the current design will not do that. Adjust the weekly threshold or the daily rule so the intended rate is the one that wins.
When payroll is involved, add the corresponding pay types and map each overtime rule before you run a pay period. The accepted answer walks through a setup with a daily rule, a holiday rule, a time-of-day rule, and a weekly rule. In a mixed week, the higher daily-style multiplier takes precedence on the day it applies, and weekly overtime only enters after the regular-hour threshold is satisfied.