Reconcile Payroll and STP Data

As a part of your STP finalisation process, you should reconcile your payroll and STP data. This step is important as it helps you keep accurate accounting records and ensures that the data you're sending to the ATO matches your payroll data.

In this article we will cover:

  • Running your reports
  • Reconciling gross wages
  • Reconciling PAYG withholding
  • Reconciling superannuation
  • What to do if you find a discrepancy

  Refer to the Troubleshooting STP article for information what discrepancies you can resolve yourself!

Run Reports

To reconcile your data you will need to run 2 reports:

  • Advanced Payroll Activity Report
  • STP2 YTD Report

Both reports can be found by navigating to Reports > Financial

Advanced Payroll Activity Report

  1. Set your duration to 'Last Financial Year' (assuming you are running this report after June 30).
  2. Group by Paying Entity & Employee ID (in that order).
  3. To the right, select the following checkboxes:
    • Cash Basis
    • Split Deductions
    • Display Non-Reported STP Amount Separately
    • Separate Superannuation Contribution Types
  4. Select Submit
  5. Export CSV

STP Report

  1. Select 'Last Financial Year' as your timeframe (assuming you are running this report after June 30).
  2. Select Create Report.
  3. Select Export > YTD Summary

Reconcile Gross Wages

To reconcile your gross wages, you'll need to calculate various columns of data in both the Advanced Payroll Activity Report and the STP Report and confirm that your calculated totals match.

If your totals for each report do not match, please refer to the troubleshooting section of this article for the next steps. 

  Gross wages (payroll data) = Gross wages (STP data)

The table below identifies which columns need to be included in your calculation to work out the total for each report. The 2 columns on the left are for the Advanced Payroll Activity Report and should be calculated separately. The 2 columns on the right are for the STP Report and should be calculated separately. 

  Advanced Payroll Activity Report     STP 2 YTD
  Gross Wages     Exempt foreign income
+ Gross Deduction   + Gross
+ Non-Taxable Allowances   + Overtime
+ Salary Sacrifice   + Bonuses and commissions
- Non-STP Reported Total   + Directors fees
= Gross wages (payroll data)   + Other paid leave
      + Paid parental leave
      + Workers compensation
      + Ancillary and defence leave
      + Cash out of leave in service
      + Unused leave on termination
      + Cents per kilometre
      + Award transport allowance
      + Laundry allowance
      + Overtime meal allowance
      + Travel and overseas accommodation allowance
      + Tool allowance
      + Task allowance
      + Qualification allowance
      + Other: Non-deductible
      + Other: Uniform
      + Other: Private vehicle
      + Other: Home office
      + Other: Transport/Fares
      + Other: General
      + Lump sum A: Type R
      + Lump sum A: Type T
      + Lump sum B
      + Lump sum D
      + Lump sum E
      + Lump sum W
      + ETP type O: Tax free
      + ETP type O: Taxable
      + ETP type R: Tax free
      + ETP type R: Taxable
      + ETP type S: Tax free
      + ETP type S: Taxable
      + ETP type P: Tax free
      + ETP type P: Taxable
      + ETP type D: Tax free
      + ETP type D: Taxable
      + ETP type B: Tax free
      + ETP type B: Taxable
      + ETP type N: Tax free
      + ETP type N: Taxable
      + ETP type T: Tax free
      + ETP type T: Taxable
      = Gross wages (STP data)
Reconcile PAYG Withholding

To reconcile your PAYG withholding, you'll need to calculate various columns of data in both the Advanced Payroll Activity Report and the STP Report and confirm that your calculated totals match. 

If your totals for each report do not match, please refer to the troubleshooting section of this article for the next steps. 

  PAYG Withholding (payroll data) = PAYG Withholding (STP data)

The table below identifies which columns need to be included in your calculation to work out the total for each report. The 2 columns on the left are for the Advanced Payroll Activity Report and should be calculated separately. The 2 columns on the right are for the STP Report and should be calculated separately. 

  Advanced Payroll Activity Report     STP 2 YTD
  PAYG Withholding     PAYGW
= PAYG Withholding (payroll data)   + ETP type O: Tax
      + ETP type R: Tax
      + ETP type S: Tax
      + ETP type P: Tax
      + ETP type D: Tax
      + ETP type B: Tax
      + ETP type N: Tax
      + ETP type T: Tax
      = PAYG Withholding (STP data)

 

Reconcile Superannuation

To reconcile your superannuation, you'll need to calculate various columns of data in both the Advanced Payroll Activity Report and the STP 2 YTD report and confirm that your calculated totals match. 

If your totals for each report do not match, please refer to the troubleshooting section of this article for the next steps. 

  Superannuation (payroll data) = Superannuation (STP data)

The table below identifies which columns need to be included in your calculation to work out the total for each report. The 2 columns on the left are for the Advanced Payroll Activity Report and should be calculated separately. The 2 columns on the right are for the STP Report and should be calculated separately. 

  Advanced Payroll Activity Report     STP 2 YTD
  Super Guarantee     Super liability
+ Salary Sacrifice   + RESC
+ Employer Additional Super Contribution   = Superannuation (STP data)
= Superannuation (payroll data)      

Additional Processes

Review STP categories

Outside of reconciling your values, it is also a good idea to ensure that you are reporting payroll items correctly. The items that are worth checking are the ones that are customsiable. These include:

  • Leave entitlements
  • Deductions
  • Pay items & Allowances

These items can be checked before your reconciliation process which will give you the confidence that you are reconciling correct data. 

For leave entitlements and deductions, you can simply review their respective menus. For allowances though, it is recommended that you refer to the Pay Item and Allowance schedule as this will save you a lot of time. 

 

Troubleshooting discrepancies

If you find that your payroll and STP data are not reconciling, please follow the below process. 

  1. Determine what is incorrect. Is the data in the Advanced Payroll Activity or the STP data correct?
  2. Determine which employees' data is wrong
  3. Determine which payslips are causing the discrepancy
  4. Determine which line items are causing the discrepancy
    • The Advanced Payroll Activity Report with additional groupings of Line Item and Payslip will help to identify this. 
    • The STP Report, looking at the line item data for the employee, is another good option for investigating discrepancies on an employee-by-employee basis. 
  5. Once identified, determine whether it's something you can resolve yourself or require assistance with.

  This article has information on resolving the most common issues encountered. 

 

Requesting Assistance

Requesting assistance

When requesting assistance from support with a reconciliation discrepancy, please include details of the discrepancy you have identified and relevant supporting details such as:

  • Your spreadsheets with workings
  • Confirmation of what value is correct and what is incorrect (payroll report or STP)
  • Details of each employee with the affected payslips or line items

Including all the required information will mean the support team can investigate your query sooner.