You can download the STP Excel report directly from the update event. Click the Download button from within the event to choose between two reporting options:

• Excel

  Contains information for only the employees included in the update event. The totals in this report will match the totals that appear at the bottom of each column in the user interface for the finalisation event.

• Excel (YTD)

  Use this report to reconcile what will be reported via STP for the financial year against the payments processed in your finalised pay runs. It lists all employees included in a successfully lodged STP event for the specified pay schedule used to create the finalisation event — including any employees you previously marked as final during the financial year who are no longer appearing in the finalisation event. Those employees will also be listed in the finalisation event wizard.

Upon opening the Excel (YTD) report, you will notice five worksheets:

• STP year to date

  Contains all payroll earnings reported via STP for the financial year, for all employees attached to the selected pay schedule.

• Itemised gross

  Contains the same STP earnings as above, but broken down by individual payment classifications.

• ETP

  Contains all Employment Termination Payment (ETP) earnings reported via STP for the financial year, for all employees attached to the selected pay schedule.

• Payroll YTD

  Contains all payroll earnings processed in your finalised pay runs for employees whose primary pay schedule matches the one selected when creating the event. For example, if you created an event for the Monthly pay schedule, all employees with Monthly as their default pay schedule will appear here — including any earnings processed in ad hoc pay runs during the financial year.

  This worksheet also includes closely held employees reported on a quarterly basis. Although they are reported separately to non-closely held employees, they must still be reported via STP.

• Variance

  Compares the total YTD taxable earnings between the STP YTD and Payroll YTD worksheets — in other words, what you reported via STP versus what you processed in your pay runs.

  • If the variance is $0, all figures match and you can proceed with lodging your finalisation event.
  • If the variance is greater than a few dollars (allowing for rounding), you will need to investigate and resolve the discrepancy before proceeding.

A positive variance occurs when the figures in the STP YTD tab are higher than the figures in the Payroll YTD tab. Which of the below reasons does your variance relate to?

• Incorrect classification of Pre-Tax Deductions

  If the STP YTD tab includes an amount other than zero in the Pre-Tax Deductions (Not classified) column, this is due to the classification settings for your pre-tax deduction categories. STP2 requires salary sacrifice amounts to be itemised, so you should review all pre-tax deduction categories that reduce taxable earnings and map them to either:

  • Salary sacrifice (superannuation); or
  • Salary sacrifice (other employee benefits).

  Once updated, refresh the data in your STP Event (or create a new event) to confirm the variance has been cleared. For more information, refer to: Deduction category classification options defined on Payroll classic

• Pay category payment classification

  If you have PAYG-exempt pay categories where the payment should not form part of an employee's wages/salary, review the payment classification of those pay categories. Any category with a classification of Default will be reported as ordinary earnings via STP.

  Export your pay categories to a spreadsheet or review them within the platform, then update the Classification field to reflect the correct option for each payment type. Once updated, refresh the data in your STP Event (or create a new event) to confirm the variance has been cleared. For more information, refer to:

  • Reference list for STP Phase 2 pay category payment classifications on Payroll classic
  • Download my pay category data on Payroll classic

• Duplicated/overlapping data from an Employing Entity change

  In the STP YTD tab, some employees may show two STP records. This is expected for employees who worked across multiple Employing Entities during the year. However, if the combined amounts are overstated compared to the Payroll YTD amounts, the Employing Entity change was not completed correctly.

  For any employees with duplicate data, refer to the subheading Process of rectifying incorrect STP reporting following a retrospective employing entity change for an employee in: Retrospectively changing an employee's employing entity during the financial year and the interaction with STP

A negative variance occurs when the figures in the STP YTD tab are lower than the figures in the Payroll YTD tab. Which of the below reasons does your variance relate to?

• Closely Held Employees

  If you have employees classified as Closely Held Payees reporting on a quarterly basis, confirm that all of their lodgements have been submitted through STP. Compare the earnings between the Payroll YTD and STP YTD worksheets to verify this is the cause. For instructions on submitting quarterly earnings, refer to: Closely held employees: reporting STP on a quarterly basis

• Failed or partially successful pay events

  Review your STP lodgement list by navigating to Reports > Single Touch Payroll. If any lodgements show a status of Failed or Partially Successful, some earnings data was not submitted successfully to the ATO. Create an Update Event to refresh the YTD amounts with the ATO. For instructions, refer to: Process a Single Touch Payroll (STP) update event on Payroll classic

  Once the update event is lodged, return to the finalisation event, refresh the data, and download an updated Excel (YTD) report to confirm the variance has been resolved before proceeding.

If none of the above causes apply, we recommend comparing each employee's earnings between the STP YTD and Payroll YTD worksheets line by line. This will help identify the specific employee(s) where the discrepancy originates so you can investigate further.

Once you have identified the affected employees, contact our support team for further assistance if required.