Skip to main content

Report to compare Superable Earnings to the calculated Superannuation

Report I can use that shows the Superable Earnings and the amount of super paid or the reason super didn't calculate for a period

Updated over 2 months ago

There may be times when you need a report that displays an Employee's superannuable earnings and the amount of employer superannuation calculated per period, for example, when you need to pay an additional percentage or when reviewing the superannuation values. There are two reports you can use:

  • SGL Report

  • IQB-SUPER

SGL Report

The SGL Report includes superable earnings, employer contributions made, SGL calculation and if there is a liability (the difference between the SGL calculation and employer contributions made). This report will also indicate why an employee didn't receive Super in a period, e.g. they have reached the SGL Contribution Cap. The report is run after the pay end process. To run the report:

  1. Go to Payroll, Reports, End of Pay, SGL Report.

  2. Select the Payroll Company and Location or run for <All>.

  3. In From Employee and To Employee, select the range of employees to include. For all employees, leave both fields blank. For one employee, enter the same employee in both fields.

  4. Enter the date range in From Date and To Date. Records are selected where the pay advice date (not the period end date) falls within the date range.

  5. SGL Selection - The SGL Selection field lets you choose the SGL group or groups for which you want to produce a report. The options are:

    • SGL Employees Only - only employees attached to an Employer Contribution with Apply SGL exceptions will be included.

    • Exempt Employees only - only employees who are exempt from super based on SGL legislation will be included

    • Liability Employees only - employees whose Employer Contributions are more or less than the SGL calculation will be included.

    • Both Exempt and Liability Employees only - employees who are linked to an Employer Contribution on which the SGL percentage value is specified, but the SGL exceptions are not necessarily applied.

    • All Employees

  6. Click Print or Preview.

IQB-SUPER

The SGL Report includes superable earnings, employer contributions made, and hours worked and displays the results in a grid that can be saved to Excel. To run the report:

  1. Go to Common, IQ.

  2. Double-click on IQB-SUPER - Payroll Superable Earnings by Pay Period.

  3. To Include Terminated, enter 1 in Value. To exclude, enter 0.

  4. Enter the Period End Date From and Period End Date To.

  5. Click OK.

Did this answer your question?