Overview
You’ll need to check that all STP events for your entity have been submitted and accepted by the ATO. To do this:
- Go to Payroll > Process Payroll > STP Submissions.
- In Report Settings, select Select status from the Pay Run Message Status drop-down list.
- Tick the checkbox for all the listed statuses > Go.
- In the Status column of the report, confirm that all STP submissions are marked as ‘Accepted by ATO’.
If there are STP events still pending that should be included in the 2023/24 financial year, these will need to be submitted.
If there are STP events with errors, you will need to amend the errors, then regenerate the events and submit them to the ATO.
Regenerate STP Updates
Before you start reconciling, make sure the values in the STP Update are current by regenerating them.
-
Go to Payroll > Process Payroll > STP Update
-
Report Settings > choose the relevant financial year > select any other filters > Go
-
Select everyone
-
With selected... > Regenerate > Go.
Reconcile Payroll Activity Against Update Event
Important Note relating to reporting of Salary Sacrifice in STP2.0
Salary Sacrifice deductions are reported twice in STP 2.0:
- Once as a deduction
- Once under salary sacrifice
This is reflected in the Pay Item Balance Report.
For example, for RESC and salary sacrifice type S:
- Johnny earns $60,000 per annum. During the employment process, he negotiated an extra 2% (ie $1,200) super above the super guarantee (SGC) rate. Because he negotiated to pay extra super, this must be reported as RESC. Johnny also salary sacrifices $10,000 into super.
This is reported in STP 2.0 as:- Gross: $60,000
- Salary sacrifice type S (super): $10,000
- RESC: $11,200 (ie the salary sacrifice amount of $10,000 + the $1,200 of employer super he negotiated
More information on reporting of Salary Sacrifice and STP 2.0 is available here.
Reports for Reconciling Payroll
STP Update Event |
Payroll > Process Payroll > STP Update Lists the earnings for each employee who has been paid during the financial year. Payments are categorised as one of the below Types:
In Report Settings, you can filter the report to show data based on the below criteria:
We recommend that you export all STP update records as a Detailed CSV and compare the exported data with:
If changes are made to an employee’s payroll data for the financial year once the message preview has been generated, click With selected... > Regenerate > Go. This will update the data that pulls through to the .csv export. |
Payroll Report |
Reports > Payroll > Payroll Report Details of what was paid to each employee Filter the Report Settings to show all payments based on the below criteria:
Export the ‘Export Payroll Summary’ file. This file shows a summary of all pay activity for the entity in the selected period including:
|
PAYG Tax Report |
Reports > Payroll > PAYG Tax Report Details of the PAYG tax withheld for each employee Filter the Report Settings to show all payments based on the below criteria:
Shows a summary of all taxes withheld by the entity in the selected period, including:
|
Pay Item Balance Report |
Reports > Payroll > Pay Item Balance Report Details of each pay item paid to an employee Filter the Report Settings to show pay items based on the below criteria:
Summarise the report by Pay Item to show a total of all units and amounts paid for each Pay Item by the selected entity. You can also summarise the report by STP Reporting Settings (ie the item type that each Pay Item is reported as in your STP Update). Shows each pay item paid to an employee with the corresponding:
|
Deductions Report |
Reports > Payroll > Deductions Report Details all pre-tax and post-tax deductions for an employee over a specified period Filter the Report Settings to show deductions based on the below criteria:
Export this report as a Normal CSV. The report shows each deduction made to an employee, with the corresponding:
|
Superannuation Report |
Reports > Payroll > Superannuation Report Details superannuation contributions for an employee over a specified period. Filter the Report Settings to show superannuation amounts based on the below criteria:
Export the Normal CSV to show the superannuation guarantee, additional employer, and salary sacrifice amounts for each employee. |
Please remember:
- If your company has employees under multiple entities, you will need to run and reconcile these reports for each entity.
- If you have starting balances, these totals will need to be added to the Payroll Report, PAYG Report and Deduction Report.
The table below will assist you in reconciling your payroll for the financial year. Each column displays the report to be reconciled, with each row showing the payment type to be reconciled.
|
STP Update CSV |
Payroll Report* (Summary) |
PAYG Tax Report |
Pay Item Balance Summary |
Deduction Report |
Superannuation Report |
---|---|---|---|---|---|---|
Gross Payments |
Sum of: 'Code' Gross Do Not Include Salary Sacrifice |
Gross Wages |
Gross Wages |
Sum Pay Type = Pay Items |
N/A |
N/A |
Superannuation (Liability) |
Type = Super and Code = Superannuation Liability |
Super |
N/A |
Pay Type = Superannuation and STP Report Settings = Superannuation Liability |
N/A |
Total Employer SG |
Reportable Super |
Type = Superannuation and Code = Reportable Employer Superannuation Contribution |
N/A |
N/A |
All Items under: STP Setting 'Reportable Super' |
Sum of Deductions where STP setting = Reportable Super |
Onscreen Report Summary: 'Additional Employer + Total Super (Deductions)' |
PAYG |
Tax Withheld (including ETP) |
Withholding Tax + PAYG Tax Deductions |
PAYG Tax + PAYG Tax Deductions |
All PAYG items (Including ETP) |
N/A |
N/A |
Deduction - Union Fees |
Type = Deduction and Code = Union Fees |
N/A |
N/A |
Pay Type = Deductions and STP Setting = Union Fees |
Sum of Deductions where STP setting = Union Fees |
N/A |
Deduction - Workplace Giving |
Type = Deduction and Code = Workplace Giving |
N/A |
N/A |
Pay Type = Deductions and STP Setting = Workplace Giving |
Sum of Deductions where STP setting = Workplace Giving |
N/A |
Deduction - Child Support (Deduction) |
Type = Deduction and Code = Child Support Deduction |
N/A |
N/A |
Pay Type = Deductions and STP Setting = Child Support (Deduction) |
Sum of Deductions where STP setting = Child Support (Deduction) |
N/A |
Deduction - Child Support (Garnishee) |
Type = Deduction and Code = Child Support Garnishee |
N/A |
N/A |
Pay Type = Deductions and STP Setting = Child Support (Garnishee) |
Pay Type = Deductions and Payment Summary Setting = Child Support (Garnishee) |
N/A |
*Payroll Report (Detailed CSV) totals should reconcile against Pay Item Balance Summary Total.
NOTE: If an employee has an Engagement Type of Labour Hire, their Gross is not disaggregated. All their earnings will be reported under Gross Amount, regardless of their STP settings.
Comments
0 comments
Article is closed for comments.