There are several filter and report options within this screen to obtain a selected data set as per the user’s needs. This report can also be exported directly as an Excel Document, using the Export to Excel option.
Authorised Users can access the report by selecting:
Payroll > Superannuation > Guarantee Listing
The Guarantee Listing Report provides a detailed listing of superannuation guarantee contributions for employees over a selected reporting period.
It allows administrators to verify which employees qualify for superannuation payments based on their earnings and hours worked, in line with ATO and superannuation thresholds.
Filter and Selection Options
| Field | Description |
|---|---|
| From Cut Off Date | Selects the start date of the reporting range. This defines the earliest superannuation cut-off date to include. |
| To Cut Off Date | Selects the end date of the reporting range. This defines the final cut-off date to include in the report. |
| State | Filters results by state (e.g. VIC, NSW, QLD) to reflect region-specific payroll data. |
| Office | Filters the report by office or branch, where applicable. Useful for multi-location organisations. |
| Member Group | Option to include “All Members” or a specific group of employees (for example, a department or cost centre). |
| Superannuation Company Group | Determines which superannuation funds to include. Selecting “All Companies” includes every fund configured in the system. |
| Show Superannuation Summary Report | Displays the summary of contributions made during the selected period for easy reconciliation. |
| Qualified / Not Qualified / Both |
-
Qualified: Displays employees who meet the minimum superannuation guarantee eligibility (based on threshold and hours).
-
Not Qualified: Displays employees who do not meet the minimum eligibility requirements.
-
Both: Displays all employees regardless of qualification status. |
Buttons and Actions
| Button | Description |
|---|---|
| Export to Excel | Exports the generated report to an Excel file for further analysis, record keeping, or submission. |
| Show Report | Displays the Guarantee Listing Report directly on-screen within the system. |
| Close | Closes the window without generating or exporting the report. |
Important Tip
Filter dates represent superannuation cut-off periods.
Selecting these dates determines the period of data retrieved based on payroll end dates processed after the previous month’s cut-off and before the selected “To Cut Off Date.”
Example:
If From Cut Off Date = 27 November and To Cut Off Date = 25 December,
the system retrieves superannuation data from all pay periods processed after the November cut-off and up to 25 December (covering roughly two months of contributions).
Usage Example
This report is typically used by payroll or finance teams to:
-
Verify employee eligibility for super contributions.
-
Identify employees who fell below the SG threshold in the reporting period.
-
Confirm compliance with ATO-mandated superannuation contribution requirements.
-
Export data for audits or clearing house submission.
Report Example - Per Fund Summary
Header Details
| Field | Description |
|---|---|
| Report Title | Displays the report name: Super Guarantee Report. |
| Period End Between | Indicates the reporting period covered (e.g. 27-Mar-2022 to 22-Sep-2025). This corresponds to the date range selected in the Guarantee Listing Report filters. |
| For Member Qualified | Specifies the report view, showing only employees who met SG eligibility. (Options during generation: Qualified, Not Qualified, or Both). |
Fund Information Section
This section displays the super fund details applicable to the listed employees.
| Column | Description |
|---|---|
| Fund Name | The name of the superannuation fund to which the contributions were made (e.g. AMP Invest Link Superannuation). |
| ABN | The Australian Business Number associated with the superannuation fund. |
| Fund Number | The identifier or member reference number used by the fund for the employee’s account. |
Employee Listing Section
Each row represents an individual employee record within the selected fund and reporting period.
| Column | Description |
|---|---|
| ID | Unique employee identification number from the payroll system. |
| Name | Employee’s full name as recorded in the system. |
| Address | The employee’s residential address (street, suburb, and postcode). |
| Date of Birth | Employee’s date of birth, used for fund verification and compliance. |
| Hired Date | The employee’s hire/start date within the company. |
| TFN | The employee’s Tax File Number used for ATO reporting. |
| Fund Number | The employee’s unique membership number for the nominated super fund. |
| Super Amount | The total superannuation contribution amount paid for the employee during the reporting period. |
| Member Qualified | Indicates whether the employee qualifies for SG contributions (checked if they meet ATO thresholds). |
| Qualified Amount | The confirmed amount payable as part of the SG contribution for qualified employees. |
Totals Section
At the bottom of the report, the system displays:
-
Total Records: The number of employees listed in the report.
-
Super Amount Total: The cumulative total of all SG contributions in the period.
-
Qualified Amount Total: The total SG value confirmed as payable to super funds.
Footer Information
| Field | Description |
|---|---|
| Printed On | Shows the date and time when the report was generated (e.g. 27-Oct-2025 12:14 PM). |
| Printed By | Displays the user or system ID responsible for generating the report (e.g. XEOGGA). |
| Page Number | Indicates the page sequence within the report (e.g. Page 1 of 5). |
Summary Page - Final Page
Header Information
| Field | Description |
|---|---|
| Report Title | Displays Super Guarantee Report as the title. |
| Period End Between | Shows the date range for the reporting period (e.g. 27-Mar-2022 to 22-Sep-2025). |
| For Member Qualified | Indicates that this report includes only employees who qualified for superannuation contributions during this period. |
Superannuation Summary Report Table
| Column | Description |
|---|---|
| Super Name | The name of the superannuation fund (e.g. AMP Invest Link Superannuation, HESTA, REST Super Fund). |
| ABN Number | The Australian Business Number associated with the superannuation fund. Used to identify each fund for compliance and clearing house reporting. |
| Super Amount | The total superannuation contributions processed for that fund within the reporting period. This includes only qualified members. |
| Qualified Amount | Confirms the amount that qualifies for the Superannuation Guarantee (SG) payment. Typically matches the Super Amount unless adjustments or exclusions apply. |
Totals Section
At the bottom of the summary, the system automatically calculates:
-
Total Super Amount: The combined contribution amount across all super funds for the selected date range.
-
Total Qualified Amount: The total SG value confirmed as payable (should generally equal the total Super Amount unless there are unqualified amounts).
Example from the report:
-
Total Super Amount: $247.99
-
Total Qualified Amount: $247.99
Footer Information
| Field | Description |
|---|---|
| Printed On | Shows the date and time the report was generated (e.g. 27-Oct-2025 12:14 PM). |
| Printed By | Displays the system user or operator who generated the report (e.g. XEOGGA). |
| Page Number | Identifies the report’s page sequence (e.g. Page 5 of 5). |
Structure of the Full Report
-
Each superannuation fund is listed on a separate page of the report, showing the detailed breakdown of employees contributing to that fund.
-
The final page provides this Summary Report, consolidating all contributions across funds into one reconciliation view.
Exporting to Excel Format
To export to Excel, select the option below, save to your computer, and you’ll receive a success message.
Sample Excel - Click to to download
This Excel report summarises all employee superannuation guarantee contributions for a selected period, typically generated from the Guarantee Listing Report or Super Guarantee Report module in Entire OnHire.
It provides a consolidated export of employee-level contribution details, fund information, and qualification status for audit, reconciliation, and ATO compliance purposes.
Sheet Name
Superannuation – contains all contribution records for the period.
Column Breakdown
| Column | Description |
|---|---|
| Name | The full name of the employee as recorded in the payroll system. |
| Address | Employee’s residential address (used for verification or fund matching). |
| Date of Birth | Employee’s date of birth, used for identification and super fund validation. |
| Fund Number | The member number or account identifier assigned by the superannuation fund. |
| Hire Date | The employee’s start date with the organisation. |
| TFN | Tax File Number of the employee, used for ATO and superannuation reporting. |
| Super Name | The name of the superannuation fund receiving contributions (e.g. HESTA, REST, AMP). |
| Member Qualified | Indicates whether the employee met ATO requirements for Superannuation Guarantee (qualified = eligible for SG contributions). |
| Super Amount | The total SG contribution calculated for the employee during the selected period. |
| ID | Internal employee identifier from the payroll system. |
| ABN Number | The Australian Business Number (ABN) associated with the superannuation fund. |
| Qualified Amount | The confirmed amount of superannuation payable for qualified employees. Typically matches the Super Amount unless exclusions apply. |
Typical Usage
-
Payroll Teams: To reconcile SG payments against clearing house uploads.
-
Finance Teams: To verify fund totals and prepare for quarterly super submissions.
-
Auditing & Compliance: To confirm SG eligibility and ensure contributions meet ATO thresholds.