Purpose and scope
What this dashboard measures
Forecast compensatory-time balance from overtime, accrual rate, and planned use.
Opening comp-time hours, Eligible overtime hours, Accrual hours per overtime hour, Planned comp-time use, and Balance cap feed the component values beneath the Comp-Time Accrual and Usage Calculator headline; Store Balance cap in its entered unit for comparison.
Instructions
How to use this calculator
Define Opening comp-time hours and Eligible overtime hours from the Comp-Time Accrual and Usage Calculator supplied schedule, then store Accrual hours per overtime hour, Planned comp-time use, and Balance cap in their recorded units.
- Define Opening comp-time hours and Eligible overtime hours from one Comp-Time Accrual and Usage Calculator reporting period.
- Define Accrual hours per overtime hour, Planned comp-time use, and Balance cap without changing the Balance cap unit.
- Assemble the Comp-Time Accrual and Usage Calculator and reconcile its headline with component values.
- Record Balance cap beside the Comp-Time Accrual and Usage Calculator output whenever it changes precision or scope.
Interpretation
Interpreting the headline metric
The forecast separates earned, capped, and used hours but does not establish that the overtime is eligible.
Verify Opening comp-time hours, Eligible overtime hours, and Accrual hours per overtime hour beside the Comp-Time Accrual and Usage Calculator headline; Balance cap reveals rounding across the component values.
Pair this Comp-Time Accrual and Usage Calculator result with the Overtime Threshold Tracker when you also need to estimate regular and overtime hours from completed and planned work.
Calculation
Method used
Eligible overtime is multiplied by the accrual rate, added to the opening balance, and reduced by planned use.
The Comp-Time Accrual and Usage Calculator evaluates Opening comp-time hours, Eligible overtime hours, and Accrual hours per overtime hour separately; store Balance cap visible outside any percentage, rate, or total.
Calculation method last reviewed: June 21, 2026.
Worked scenario
Example calculation
Reconcile Balance cap with the Comp-Time Accrual and Usage Calculator component values before judging the Balance cap headline scale or units.
Visual audit
Reading the supporting metrics
The Comp-Time Accrual and Usage Calculator dashboard places component values beside Opening comp-time hours, Eligible overtime hours, Accrual hours per overtime hour, Planned comp-time use, and Balance cap. Verify Balance cap in its original unit before accepting the component values or headline status.
Boundaries
Important edge cases and limitations
Eligibility, expiry, cash-out, caps, and approval rules must come from the applicable policy.
Alter Balance cap in the Comp-Time Accrual and Usage Calculator before reading the component values or headline.
Input audit
Checklist for this calculation
- Verify the Comp-Time Accrual and Usage Calculator period and Opening comp-time hours and Eligible overtime hours units.
- Reconcile Balance cap with the Comp-Time Accrual and Usage Calculator component values.
- Assemble a fresh Comp-Time Accrual and Usage Calculator after any Balance cap alter.
- Store Accrual hours per overtime hour, Planned comp-time use, and Balance cap beside the Comp-Time Accrual and Usage Calculator; include Balance cap in any saved or shared record.
Practical use
Recommended workflow
Verify accrual, cap, expiry, and approval rules, then reconcile the modeled balance with the official ledger.
A useful follow-up is the Flextime Balance Calculator, which can compare worked time with a period target and distribute the remaining balance.
Questions
Frequently asked questions
Can comp time be lost at the balance cap?
Under some policies, accrual above the cap is blocked, paid out, or handled differently; the selected policy controls.
Should a Balance cap update refresh the
A revised Balance cap makes the older Comp-Time Accrual and Usage Calculator stale unless Opening comp-time hours uses the same supplied schedule. Assemble a new Comp-Time Accrual and Usage Calculator output for the revised Balance cap case.
How should Opening comp-time hours be recorded for the
Reconcile Opening comp-time hours with Balance cap inside the Comp-Time Accrual and Usage Calculator reporting basis. Store the Balance cap unit aligned with the Opening comp-time hours period before reading the headline.
How can Balance cap be sensitivity-tested in the
Store Opening comp-time hours and Eligible overtime hours unchanged and alter Balance cap once in the Comp-Time Accrual and Usage Calculator. Reconcile the Balance cap component with component values to identify a proportional or threshold effect.