User Defined Queries are available to assist in STP2 balancing and breaking down further what is displayed on STP2 update.
To access and run these queries save the WE STP2 EOFY User Defined Queries zip file to your desktop and unzip the files.
Refer to Save a User Defined Query for more information.
YTD Company STP2 Reporting Breakdown Summary
This report will give you the breakdown at the Company level broken down by STP2 reporting groups, this report can be used in conjunction with your STP Update, it will breakdown further individual reporting groups that make up the total amount on STP Update if you are using totals in your grid header.
YTD Employee STP2 Reporting Breakdown Summary
This report will give you further breakdown at the Employee level, this report can be used in conjunction with your STP Update and the YTD Company STP2 Reporting Breakdown Summary, it will break down further individual reporting groups at the employee level.
In the example below I have filtered on the heading of STP2 Reporting Group and selected Paid Leave, in the actual report you would see the individual employee names, you can filter on all headings in this report.
This report is also great for filtering on just one employee to get their YTD breakdown.
Payslip STP2 Reporting Details
This report/query can be run at any time of the year for a single PPE, multiple PPE's, or the entire financial year. When the report has been run it has the ability to be filtered and customized by the grid headings.
In the below grid, I have filtered on First Name, Payslip Item, then Type. This is another option for drilling further into an employee's figures.
YTD Employee Non-Payslip STP2 Reporting Details
This report/query provides non-payslip specific STP2 reporting payment information in the nominated financial year. The report gives financial year figures:
Tax - total of tax for all income types excluding ETP Tax
FBT or FBT Exempt
Termination Lump Sum A
Termination Lump Sum B
Termination Lump Sum D
ETP
Unused Termination Leave
Union