Overtime vs. Leave Entitlement: Separate Pay and Policy Scenarios

The overtime worksheet is a limited pay scenario

Compact mode applies one entered weekly threshold, base rate, and multiplier. Advanced mode deducts entered breaks, rounds daily totals by the selected increment, and applies no-premium, simple weekly, simple daily, or simple combined thresholds. Those modes are publisher-defined scenarios, not jurisdictional legal rules.

The worksheet does not determine exemption, compensable time, the fixed workweek, statutory regular rate, multiple-rate treatment, double time, seventh-day rules, alternative schedules, premium stacking, taxes, deductions, or final payroll.

The leave worksheet is a policy-based estimate

Compact mode uses an entered annual amount, completed eligible months, and leave taken. Advanced mode also applies working days divided by a full-time baseline and adds the lesser of entered opening carryover and an entered scenario cap before subtracting leave taken.

Presets are illustrative employer-policy scenarios, not statutory regional entitlements. Eligibility, exact dates, irregular-hours methods, public holidays, protected carryover, expiry, bucket order, accrual frequency, advance leave, rounding, and official system balances remain outside the model.

A relationship between the results must be demonstrated, not assumed

The overtime estimate does not prove that leave caused premium hours, that staffing is inadequate, or that overtime is legally due. The leave estimate does not prove that time off was taken, coverage was unavailable, or payroll cost increased.

To review a possible relationship, align employee group, schedule, pay period, leave dates and categories, time records, coverage decisions, applicable law, agreements, and payroll results. Preserve privacy and qualified review for employee-specific decisions.

Method, scope, and sources

Compact/weekly mode uses max(total included hours − entered weekly threshold, 0) at one entered base rate and multiplier. The advanced worksheet deducts entered breaks from daily hour totals, rounds each daily total by the selected increment, and applies no-premium, simple weekly, simple daily, or simple combined thresholds. Weekly extra overtime is calculated at the scenario level rather than allocated to specific days.

A planning estimate only. Daily and combined modes are not jurisdictional legal rules and do not calculate exemption, compensable time, punch rounding, double time, seventh-day rules, alternative schedules, multiple rates, statutory regular rate, premium stacking, taxes, deductions, or final payroll. Confirm the fixed workweek, policy or agreement, and applicable law outside this tool.

Method status: Partially supported.

Worked example

Hypothetical advanced weekly scenario: entered daily hours less entered breaks produce 44.00 rounded paid hours. With a user-confirmed 40-hour weekly threshold, $20.00 single base rate, and 1.5 multiplier, the scenario prices 40.00 regular hours and 4.00 overtime hours. This does not establish that the worker or hours are legally overtime-eligible.

Sources

• U.S. Department of Labor, Wage and Hour Division — Fact Sheet #23: Overtime Pay Requirements of the FLSA: For covered, nonexempt employees, supports at least 1.5 times the regular rate after 40 hours in a fixed 168-hour workweek; it bars averaging across workweeks and says weekends/holidays do not themselves trigger federal overtime.
• U.S. Department of Labor, Wage and Hour Division / eCFR — 29 CFR § 778.109 — The regular rate is an hourly rate: Defines regular rate as total remuneration subject to exclusions divided by hours actually worked, which limits an entered base hourly wage to a proxy in this scenario.
• California Department of Industrial Relations — Overtime: Shows why a weekly federal-style calculation is not universal: California has general daily overtime after eight hours and double time after 12 hours, subject to exceptions.

Method, scope, and sources

The compact view uses an entered annual policy amount × completed eligible months ÷ 12, then subtracts leave taken. The advanced regular-schedule scenario multiplies the annual amount by entered working days ÷ full-time baseline and by eligible months ÷ 12, then adds the lesser of entered opening carryover and the entered scenario cap before subtracting leave taken.

All presets are illustrative employer-policy scenarios, not statutory regional entitlements. The model does not determine worker eligibility, irregular-hours or part-year methods, exact dates, public-holiday treatment, protected carryover, expiry, bucket order, accrual frequency, rounding, advance leave, or an official HRIS/payroll balance. Confirm the governing policy and system of record.

Method status: Partially supported.

Worked example

Hypothetical advanced policy scenario: an entered 24-day annual amount, a 4-day regular week against a 5-day baseline, and 9 eligible months produce 14.4 calculated days. Two entered carryover days within the selected cap produce 16.4 before usage; after 6 days taken, the calculated balance pending policy and system review is 10.4 days.

Sources

• GOV.UK — Calculate leave entitlement: Supports one-twelfth monthly accrual for regular-hours workers in the first year and identifies leave-year, start-date, irregular-hours/part-year, and carryover qualifications.
• GOV.UK — Holiday entitlement: Supplies UK statutory context for 5.6 weeks, part-time treatment, the 28-day cap, bank-holiday treatment, and additional contractual leave.
• U.S. Department of Labor — Vacation Leave: Supports the non-universality warning: the FLSA does not require paid vacation or holiday leave and benefits are generally a matter of agreement.