---
title: How to run the Optimise Overtime and Cycle Overtime reports
description: Run the Optimise Overtime and Cycle Overtime reports to check how hours were split between ordinary and overtime.
---

[Skip to content](https://university.guardhousehq.com/how-to-run-overtime-reports#main-content)

English

Show submenu for translations

[![Text\_gradient gold-1-2](https://university.guardhousehq.com/hs-fs/hubfs/Text_gradient%20gold-1-2.png?width=225&height=30&name=Text_gradient%20gold-1-2.png)](https://university.guardhousehq.com/?hsLang=en)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Contact Support](mailto:support@guardhousehq.com)

[Contact Support](mailto:support@guardhousehq.com)

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Guardhouse Knowledge Base](https://university.guardhousehq.com/?hsLang=en)
2. [Paysheets](https://university.guardhousehq.com/paysheets?hsLang=en)
3. [Award Overtime](https://university.guardhousehq.com/paysheets?hsLang=en#award-overtime)

# How to run the Optimise Overtime and Cycle Overtime reports

Two reports show pre-allocated overtime: the **Optimise Overtime** report, run from the Paysheet, and the **Cycle Overtime** report, run from Reports. Use them to check how hours were split between ordinary and overtime before you run pay.

> **Remember:** pre-allocated overtime only shows in these two reports. Other reports don't show it.

#### Before you start

- Award overtime is turned on, and your award employees are on an Award Overtime pay group. See [How to set up award overtime](https://university.guardhousehq.com/how-to-set-up-award-overtime?hsLang=en).
- To pre-allocate overtime, see [How to pre-allocate overtime](https://university.guardhousehq.com/how-to-pre-allocate-overtime?hsLang=en).

### 1. Run the Optimise Overtime report

This report is generated from the paysheet data. It shows how each award employee's hours were split between ordinary and overtime for a pay period, including pre-allocated overtime.

1. Go to **Paysheets** and choose the pay calendar and period.
2. To see only award employees, select the **Award OT** staff filter.
3. Select the employees, open the **Export** menu and select **Optimise Overtime**.
4. An Excel file (**OptimisedOT.xlsx**) downloads.

![](https://university.guardhousehq.com/hs-fs/hubfs/undefined-Nov-18-2026-06-54-34-6404-AM.png?width=1424&height=727&name=undefined-Nov-18-2026-06-54-34-6404-AM.png)

The file has three sheets:

| Sheet | What it shows |
| --- | --- |
| **OT summary** | One row per shift: ordinary hours by category (Day, Morn, Night, Sat, Sun, PH), leave, overtime by category (OTMF \<2, OTMF \>2, OTSat \<2, OTSat \>2, OTSun, OTPH), and totals for ordinary (Ord) and overtime (OT). The Settings column shows the employee's ordinary hours, Include Leave Hours and Allow Overflow settings (y/n). |
| **Detail** | Each pay line with its pay category, units, rate and cost. These are the lines that go to payroll. |
| **Allowance** | Allowances paid in the period. |

> **Note:** running the Optimise Overtime report doesn't update the paysheet. The paysheet keeps its original hours and pay categories. The optimised split of ordinary and overtime hours is only in the downloaded Excel file.

### 2. Run the Cycle Overtime report

This report shows each staff member's ordinary and overtime hours, shift by shift, across one full overtime cycle. Use it to check that overtime has been worked out correctly before you run pay.

1. Go to **Reports** and select **Cycle Overtime Report**.
2. Under **Report Options**, choose the **Cycle** length (for example 1 Week or 4 Weeks).
3. Choose the **Staff**, or **Select All**. Only staff whose Overtime Cycle matches the cycle you chose are listed.
4. Pick the **Cycle Start Date**. Only dates that start a cycle can be picked, counted from the company's Overtime Cycle Start Day.
5. Select **Generate report**. An Excel file named *Allocated OT Report \[start date\] - \[end date\].xlsx* downloads.

![](https://university.guardhousehq.com/hs-fs/hubfs/undefined-Nov-18-2026-06-54-35-0001-AM.png?width=1848&height=707&name=undefined-Nov-18-2026-06-54-35-0001-AM.png)

The report includes active staff with an overtime cycle set, covering both rostered shifts and unscheduled timesheet entries. Rejected entries are left out.

| Column | What it shows |
| --- | --- |
| FirstName, LastName, EmployeeID | The staff member |
| Type, Site, Position, JobCode, Paygroup | Where the shift was worked and the pay group used |
| Cycle, Week | The cycle length, and which week of the cycle the shift falls in |
| Day, Date, StartTime, EndTime, Break | The shift times. Break is in minutes |
| OTstart, OTend, OTall | Pre-allocated overtime: start hours, end hours, or the whole shift (All day) |
| OTdaily | Hours past the Daily Threshold. Only used when the shift has no pre-allocated overtime |
| SchUnschOT | Whether the hours came from a scheduled shift or an unscheduled timesheet entry |
| TotOrdHrs, TotOTHrs, TotHrs | Ordinary hours, overtime hours and total hours for the shift, after breaks |
| Status | The entry's approval status |

A bold totals row follows each staff member, adding up their hours for the whole cycle. If a shift's pay group isn't an Award Overtime pay group, its overtime is shown as 0 and all its hours count as ordinary.

**Example: a 4-week cycle.** A guard has a 4-week Overtime Cycle and a Daily Threshold of 10 hours. They work 12 shifts of 06:00–18:00 with a 30-minute unpaid break (11.5 hours each).

| Shifts | Pre-allocated overtime | OT columns | Overtime hours | Ordinary hours |
| --- | --- | --- | --- | --- |
| 10 | None | OTdaily 1.5 each | 15 | 100 |
| 1 | 1h start + 1h end | OTstart 1, OTend 1 | 2 | 9.5 |
| 1 | All day | OTall 11.5 | 11.5 | 0 |
| **12 (totals row)** |  |  | **28.5** | **109.5** |

Total hours for the cycle are 138 (12 × 11.5), which is 109.5 ordinary hours plus 28.5 overtime hours.

### Payroll systems (Xero, MYOB and others)

Your payroll export or integration, such as the Xero sync or the MYOB export, sends the hours and pay categories saved on the paysheet. Running the Optimise Overtime report doesn't update the paysheet, so the optimised results from that report aren't pushed automatically to your payroll system. Any other report built from the paysheet won't include the optimised results either.

To make sure overtime lands correctly, map each award pay category (including the OT categories) to a matching earnings or pay item in your payroll system.

#### Related articles

- [How to set up award overtime](https://university.guardhousehq.com/how-to-set-up-award-overtime?hsLang=en)
- [How to pre-allocate overtime](https://university.guardhousehq.com/how-to-pre-allocate-overtime?hsLang=en)
- [Webinar #004 – Security Award and Overtime Calculations](https://university.guardhousehq.com/webinar-004-security-award-and-overtime-calculations?hsLang=en)

- [Dashboard](https://university.guardhousehq.com/dashboard?hsLang=en)
- [Schedule](https://university.guardhousehq.com/schedule?hsLang=en#main-content)

    - [Cycle Schedules](https://university.guardhousehq.com/schedule?hsLang=en#cycle-schedules)
- [Timesheets](https://university.guardhousehq.com/timesheets?hsLang=en#main-content)

    - [Timesheets v1](https://university.guardhousehq.com/timesheets?hsLang=en#timesheets-v1)
    - [Timesheets v2](https://university.guardhousehq.com/timesheets?hsLang=en#timesheets-v2)
- [Paysheets](https://university.guardhousehq.com/paysheets?hsLang=en#main-content)

    - [Payroll Extracts](https://university.guardhousehq.com/paysheets?hsLang=en#payroll-extracts)
    - [allowance/s](https://university.guardhousehq.com/paysheets?hsLang=en#allowance-s)
    - [Award Overtime](https://university.guardhousehq.com/paysheets?hsLang=en#award-overtime)
- [Invoicing](https://university.guardhousehq.com/invoicing?hsLang=en#main-content)

    - [New Zealand](https://university.guardhousehq.com/invoicing?hsLang=en#new-zealand)
- [Reports](https://university.guardhousehq.com/reports?hsLang=en#main-content)

    - [Staff Reports](https://university.guardhousehq.com/reports?hsLang=en#staff-reports)
- [Incidents](https://university.guardhousehq.com/incidents?hsLang=en)
- [Company Settings](https://university.guardhousehq.com/company-settings?hsLang=en#main-content)

    - [Timeclock](https://university.guardhousehq.com/company-settings?hsLang=en#timeclock)
    - [Onboarding](https://university.guardhousehq.com/company-settings?hsLang=en#onboarding)
    - [Integrations](https://university.guardhousehq.com/company-settings?hsLang=en#integrations)
- [Customers](https://university.guardhousehq.com/customers?hsLang=en#main-content)

    - [Customer Portal](https://university.guardhousehq.com/customers?hsLang=en#customer-portal)
- [Sites](https://university.guardhousehq.com/sites?hsLang=en)
- [Tours & Patrols](https://university.guardhousehq.com/tours-patrols?hsLang=en)
- [Staff](https://university.guardhousehq.com/staff?hsLang=en)
- [Subcontractor](https://university.guardhousehq.com/subcontractor?hsLang=en#main-content)

    - [Subcontactor Sharing](https://university.guardhousehq.com/subcontractor?hsLang=en#subcontactor-sharing)
- [Frequently Asked Questions](https://university.guardhousehq.com/frequently-asked-questions?hsLang=en)
- [Getting Started](https://university.guardhousehq.com/getting-started?hsLang=en)
- [Holidays](https://university.guardhousehq.com/holidays?hsLang=en)
- [Documents](https://university.guardhousehq.com/documents?hsLang=en)
- [Leave / Unavailability](https://university.guardhousehq.com/leave-unavailability?hsLang=en)
- [Guardhouse Support Topics](https://university.guardhousehq.com/guardhouse-support-topics?hsLang=en)
- [Invoicing Integrations](https://university.guardhousehq.com/invoicing-integrations?hsLang=en)
- [Payroll Integrations](https://university.guardhousehq.com/payroll-integrations?hsLang=en)
- [Product Updates](https://university.guardhousehq.com/product-updates?hsLang=en)
- [Release Notes](https://university.guardhousehq.com/release-notes?hsLang=en)
- [Webinars](https://university.guardhousehq.com/webinars?hsLang=en)
- [Xero](https://university.guardhousehq.com/xero?hsLang=en)
- [Guides for Guards](https://university.guardhousehq.com/guides-for-guards?hsLang=en)
- [API Integration](https://university.guardhousehq.com/api-integration?hsLang=en)
- [Integrations](https://university.guardhousehq.com/integrations?hsLang=en)
- [Tablet Clock-in/Clock-out](https://university.guardhousehq.com/tablet-clock-in-clock-out?hsLang=en)

[![Text\_gradient gold-1-2](https://university.guardhousehq.com/hs-fs/hubfs/Text_gradient%20gold-1-2.png?width=150&height=20&name=Text_gradient%20gold-1-2.png "Text_gradient gold-1-2")](https://guardhousehq.com)

[mailto:support@guardhousehq.com](mailto:support@guardhousehq.com) <https://www.linkedin.com/company/33246750/>

Copyright © 2025, Guardhouse