Time in Lieu Spreadsheet | Sprintlaw Australia

Time off in lieu (often shortened to “time in lieu” or “TOIL”) can be a great way to manage overtime in a practical, flexible way - especially for small businesses where workloads can spike unexpectedly.

But it can also become a compliance headache if it’s tracked inconsistently, agreed to informally, or recorded in a way that doesn’t match what the Fair Work Act, a modern award or an enterprise agreement requires.

That’s where a clear time in lieu spreadsheet comes in. Done well, it helps you keep accurate records, communicate clearly with your team, and reduce the risk of underpayments and disputes.

Below, we’ll step through what time in lieu means in Australia, what your obligations are as an employer, and how to build a time in lieu spreadsheet that’s actually useful (and defensible if questions ever come up). This article is general information only - because TOIL rules can vary significantly depending on whether an employee is covered by a modern award, enterprise agreement, or specific contract terms (and whether they’re award-free), you should check what applies to your workplace and get advice if you’re unsure.

What Is Time In Lieu (TOIL) And When Can You Offer It?

Time in lieu generally means an employee works extra hours and, instead of being paid overtime rates, they take paid time off later.

Whether you can offer time in lieu - and the exact rules that apply - depends on the legal framework that covers your employment relationship, such as:

a modern award
an enterprise agreement
an employment contract (but only to the extent it’s consistent with the award/enterprise agreement and the Fair Work Act)

For many businesses, the key point is this: time in lieu is not always interchangeable with overtime pay. In a lot of cases, it must be:

agreed (sometimes in writing, and sometimes on each occasion, depending on the applicable instrument)
accrued at a specific conversion rate (for example, 1 hour overtime may convert to more than 1 hour of time off)
taken within a set timeframe
paid out if not taken in time or on termination

If your approach is “we’ll just give them a day off next week”, it can sound reasonable operationally, but it may not match the legal requirements that apply to your business.

Why A Time In Lieu Spreadsheet Matters

A time in lieu spreadsheet gives you a single source of truth. It helps you:

track extra hours worked and TOIL accrued (including any loading or penalty equivalents where required)
avoid informal “handshake” arrangements that later become disputed
show clear records if an employee queries their balance
support payroll and termination calculations (including final pay)

It’s also a practical tool for managers - not just payroll - because TOIL impacts rostering, resourcing and labour costs.

What Are Your Legal Obligations When Managing Time In Lieu?

In Australia, TOIL is often linked to overtime arrangements, but the precise rules will depend on the relevant modern award, enterprise agreement, and/or contract terms (including whether the employee is award-free). In practice, those instruments may set when additional hours attract overtime rates, when TOIL can be used instead, and what record-keeping is needed.

As an employer, your core obligations typically include:

Paying employees correctly (including overtime, penalty rates, allowances, and minimum rates where applicable)
Keeping proper employee records (including hours worked, pay, and leave records, as required)
Applying the correct instrument (award/enterprise agreement/contract terms)
Acting consistently (so one team isn’t getting TOIL in a way that breaches the applicable rules, while another is treated differently)

Many employers run into trouble because TOIL arrangements are agreed informally and tracked inconsistently. If you can’t demonstrate what was worked, what was agreed, and what was taken, you can end up with disputes, underpayment risk, or payroll corrections later.

Award And Agreement Rules Can Be Specific

Different awards have different requirements for time off in lieu. For example, they may deal with:

whether TOIL is allowed at all
whether it must be agreed in writing
the overtime-to-TOIL conversion rate
how quickly TOIL must be taken
what happens if it isn’t taken (including payout at overtime rates)

This is why it’s important to look at your award coverage and ensure your system matches it. A spreadsheet is only as compliant as the rules behind it.

Your Contracts And Policies Still Matter

Even if an award allows TOIL, you’ll usually want clear wording in your employment documents so everyone understands how your business handles overtime approvals, TOIL accrual and TOIL requests.

This often sits inside an Employment Contract and/or workplace policies (for example, rules around when overtime must be approved, and how TOIL requests are made).

If your documents are vague, you may find managers approving TOIL inconsistently, or employees expecting TOIL when the overtime hasn’t been authorised.

How To Build A Time In Lieu Spreadsheet That Actually Works

The best time in lieu spreadsheet is one your business will consistently use. It should be simple enough for a manager to update, but detailed enough for payroll to rely on.

Here’s what we typically recommend including.

1. Employee Details (Enough To Identify The Person)

Employee name
Employee ID (if you use one)
Role/title
Employment type (full-time/part-time/casual)
Award/enterprise agreement coverage (or at least a reference)

This matters because TOIL rules often differ depending on coverage. If you’re running multiple roles under different awards, you’ll want the spreadsheet to make that obvious.

2. Overtime Worked (With The Right Level Of Detail)

Your spreadsheet should capture overtime in a way that lets you verify it later. Common columns include:

Date of overtime
Start time and end time (or total overtime hours)
Reason for overtime (brief)
Manager approval (name/initials)

If you already use a timesheet system, you can record a reference number and keep the spreadsheet as your TOIL ledger. The key is consistency.

3. Conversion Rate (The Compliance “Make Or Break” Column)

This is where many businesses accidentally underpay.

If an award says overtime is paid at (for example) time-and-a-half or double time, the TOIL accrued may need to reflect that loading. In other words, 1 hour of overtime might convert to 1.5 or 2 hours of TOIL.

Your time in lieu spreadsheet should include columns like:

Overtime hours worked
Applicable overtime rate (e.g. 1.5x, 2x)
TOIL hours accrued (calculated)

This helps you show that your TOIL system is not just “hour-for-hour” unless that’s genuinely permitted by the applicable instrument.

4. TOIL Taken (So Balances Don’t Drift)

It’s not enough to track accrual - you need to track when TOIL is used, and how much.

Date TOIL taken
Hours taken
Payroll period processed
Balance after deduction

Many disputes happen because an employee believes they “still have” TOIL, while a manager believes it was already taken informally. A spreadsheet helps remove that ambiguity.

5. Expiry / Time Limits (If Your Award Requires It)

Some instruments set a timeframe for taking TOIL. If that’s the case for your business, add:

Accrual expiry date
Status (e.g. open / taken / paid out)
Notes (e.g. “paid out in PP14”)

This supports proactive management. Instead of finding out later that TOIL should have been paid out at overtime rates, you can deal with it in time.

6. A Running Balance (So You Can Audit Quickly)

Each row should flow into a running balance for each employee. This is what managers and payroll usually care about day-to-day:

Opening balance
Plus accrued
Minus taken
Closing balance

If you’re using Excel or Google Sheets, this is usually a straightforward formula - but it’s important to protect those cells so they aren’t accidentally overwritten.

Common Compliance Risks (And How A Spreadsheet Helps You Avoid Them)

Even if you have good intentions, TOIL can create hidden risk. Here are some common pitfalls we see in small businesses, and how a proper time in lieu spreadsheet helps.

“We Didn’t Realise The Award Required Written Agreement”

Some awards require the employer and employee to agree to TOIL (sometimes in writing), and may also require this agreement to be made each time overtime is worked or within a set period.

A spreadsheet can include a column for:

TOIL agreement confirmed (Y/N)
Agreement date
Where it’s stored (e.g. email, HR system)

This is a simple process improvement that can save you a lot of stress later.

“We Accrued TOIL Hour-For-Hour When Overtime Was 1.5x”

This is one of the most common underpayment issues with TOIL.

A spreadsheet that forces you to record the overtime rate and calculates TOIL based on that rate reduces the chance of:

accidental under-accrual
inconsistent treatment between managers
having to do big back payments later

“TOIL Built Up And Nobody Managed It”

If TOIL isn’t actively managed, employees can accumulate large balances. That can become:

an operational risk (too much leave taken at once)
a cashflow risk (if it needs to be paid out)
a termination risk (large final pay amounts)

When you’re calculating final pay, TOIL may be one of several items you need to account for alongside unused annual leave and notice arrangements. Having clear systems around final pay and payment in lieu of notice reduces the chance of an expensive mistake.

“We Don’t Have A Clear Overtime Approval Process”

Your spreadsheet should support (not replace) your process.

If overtime needs pre-approval, document that in your policy and contract, and make the spreadsheet reflect it with a manager approval field. If overtime doesn’t require pre-approval in your business, be clear on what does (for example, overtime beyond a certain number of hours, or overtime on public holidays).

This is also where broader rostering practices matter. If you’re changing shifts or rosters regularly, you’ll want systems that comply with notice rules and reduce disputes about hours worked.

Practical Tips For Managing TOIL Day-To-Day (Without Creating Admin Overload)

A time in lieu spreadsheet isn’t just about compliance - it’s a tool to run your business smoothly. Here are practical ways to make it manageable.

Set A Single Source Of Truth

Pick one system as the “official” TOIL record - whether it’s the spreadsheet itself or a payroll/HR platform - and train managers to use it consistently.

If you’re using a spreadsheet, keep it:

centralised (one master file, not multiple versions)
access-controlled (so not everyone can edit formulas)
backed up (version history helps if an entry is disputed)

Review Balances Regularly

TOIL should be reviewed like any other leave balance. A monthly check is usually enough for a small business.

During your review, look for:

balances growing faster than they’re being taken
TOIL nearing expiry (if applicable)
patterns of repeated overtime (which might indicate resourcing issues)

Document Your TOIL Rules In Plain English

Even if your award has rules, your team still needs to understand how TOIL works in your workplace.

At a minimum, explain:

when overtime is allowed and how it is approved
whether TOIL is available and how it is accrued
how employees request TOIL
how quickly TOIL should be taken
what happens on resignation/termination

This kind of clarity often sits alongside other employment basics, like your approach to breaks and safe hours. If you’re reviewing your compliance generally, it may also be worth checking your practices around Fair Work breaks and maximum hours.

Make Sure Your Record-Keeping Matches Your Payroll

Your spreadsheet shouldn’t contradict your payslips or payroll records.

If TOIL is taken, ensure it’s reflected correctly in payroll so the employee is paid as normal for that time (and you can show it was time off in lieu, not unpaid leave).

If TOIL is paid out instead of taken, record:

the payout date
the number of hours paid out
the rate used
the payroll period

Being able to reconcile your spreadsheet to payroll is one of the best ways to reduce disputes.

Consider The “Human” Side Of TOIL

TOIL is often used to keep teams motivated and flexible, but it can backfire if employees feel they’re always doing extra hours and never getting time back.

Clear tracking and prompt scheduling of TOIL builds trust. It also helps managers plan coverage, which is important for small teams.

Key Takeaways

A well-built time in lieu spreadsheet helps you track overtime and TOIL accurately, reduce disputes, and support payroll compliance.
Time in lieu rules in Australia depend on the applicable modern award or enterprise agreement (if any) and can also be affected by contract terms, including whether written agreement is required and what conversion rate applies.
Your spreadsheet should record overtime worked, approval, the overtime-to-TOIL conversion rate, TOIL taken, running balances, and any expiry or payout requirements.
Common TOIL risks include under-accruing TOIL (by ignoring penalty loadings), failing to document agreement where required, and allowing large balances to build up unmanaged.
Align your TOIL process with your broader employment documentation, including your Employment Contract, so managers and employees understand how TOIL works in your business.
Regular reviews and consistent record-keeping make it easier to handle resignations, terminations and payroll reconciliations without last-minute surprises.

If you’d like help setting up a compliant overtime and time off in lieu process (including employment contracts and workplace policies), you can reach us at 1800 730 617 or team@sprintlaw.com.au for a free, no-obligations chat.

Time In Lieu Spreadsheet: Tracking And Managing TOIL Compliance In Australia