TOIL balance
calculator & ledger.
Record time off in lieu earned, used, adjusted, and expiring. See the running balance, catch use-by dates, and download a clean CSV—without uploading employee data.
Set your TOIL policy
Use the rate and expiry rule written in your own policy.
TOIL rules vary. Check the employee's contract, your policy, any applicable award or collective agreement, and local law before treating time as earned or expired.
Add a ledger entry
| Date | Entry | Hours | Expiry | Balance | Actions |
|---|
Usage is allocated to the earliest-expiring available credit first. Credit remains usable on its expiry date and is removed the following day.
A transparent TOIL calculation
The ledger applies your inputs consistently and makes every change visible. It does not decide which hours legally qualify.
Credit eligible hours
Extra hours worked × your policy multiplier. Four eligible hours at 1.5:1 adds six TOIL hours to the ledger.
Deduct use and corrections
Time used reduces the earliest-expiring credit first. Signed adjustments let you record approved corrections without rewriting history.
Surface expiry risk
The default window sets a use-by date for new credit. A specific entry date can override it, and warnings show only the unused remainder.
Build the rule before the spreadsheet: read our TOIL policy template, TOIL agreement template, and guide to tracking TOIL. These resources are general guidance, not legal advice.
TOIL calculations,clearly answered
earning rates, expiry rules, and the records a useful time-in-lieu ledger should keep.
Talk to our team01What is a TOIL balance?
A TOIL balance is the time an employee has earned by working agreed extra hours, less any time they have taken in lieu and any credits that have expired under the organisation's policy. TOIL is also called time off in lieu, time in lieu, or banked hours.
02How do I calculate time off in lieu?
Apply the earning rate in your TOIL policy to the eligible extra hours. At a 1:1 rate, four extra hours earns four TOIL hours. At 1.5:1, four extra hours earns six. Then subtract TOIL used, policy adjustments, and expired unused credit.
03Does TOIL have to be earned at time and a half?
Not universally. The earning rate depends on the applicable contract, workplace policy, award, collective agreement, and local law. This calculator supports configurable rates so you can model the rule that applies to your organisation; it does not determine legal entitlement.
04Can TOIL expire?
Some workplace policies set an expiry window or a specific use-by date, while others allow balances to remain available. Check the governing policy and local requirements before removing credit. The ledger treats credit as available through its stated expiry date and expires any unused remainder the following day.
05What should a TOIL ledger record?
Keep the date, eligible hours worked, earning rate, credited hours, time used, adjustments, expiry date, running balance, and a short approval or work reference. A consistent audit trail makes balance queries much easier to resolve.