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 which should be included in the 2020-21 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
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 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 the PAYG tax was 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 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 Payment Summary 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:
The Pay Item Balance Report will also report on your current STP Reporting Settings. These settings will be used in place of the Payment Summary Settings when reporting via STP from FY 2021-22. |
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:
|
ETP Lump Sum Pays |
Reports > Payroll > ETP Lump Sum Pays Report Details all ETP Payments and their associated ETP Code Filter the Report Settings to show payment based on the below criteria:
The report shows the total of each ETP Payment made, Tax amount and ETP Code. |
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 |
|
---|---|---|---|---|---|
Gross Payments |
Gross INB + Gross WHM + Gross LH + ETP Taxable Amount + Lump Sum |
Taxable Wages - Total Allowances (Reportable) - Taxable Pay Items set to ‘Not Applicable’ - Taxable Lump Sum totals |
Taxable Wages** |
All items under: + Gross Payments + Gross Payments ETP + Total Allowances (Taxable) + Taxable Pay Items set to ‘Not Applicable’) + Taxable Lump Sum totals - Deductions (Pre-Tax) |
|
Reportable Super |
Reportable Super |
All Items under: Reportable Super |
|||
Total Allowances |
Total Allowances (Reportable) |
Total Allowances (Reportable) |
|||
Pre-Tax Deductions |
Pre-Tax Deductions |
Pre-Tax Deductions |
Pre-Tax Deductions |
||
PAYG |
Tax Withheld (including ETP) |
PAYG Tax + PAYG Tax Deductions |
PAYG Tax + PAYG Tax Deductions |
All PAYG items (Including ETP) |
*Payroll Report (Detailed CSV) totals should reconcile against Pay Item Balance Summary Total.
**Taxable Wages in the PAYG Report should balance to the Taxable Wages in the Payroll Report
Comments
0 comments
Please sign in to leave a comment.