There are several reports that you can use at End of Financial Year to verify and reconcile your employee data and entered values.
IQB-Emp008 - Payroll Employee Tax Details
IQB-Emp008 - Payroll Employee Tax Details collates information from employee Personal, Tax and Termination Details. Columns in this IQ reflect settings and details relevant to employee tax calculations and STP Reporting. You can use this report to verify the Tax setup of your employees.
The IQ has one parameter, Include Terminated Employees from Tax Year ending. Enter the Tax Year as 0 to included Employees who were terminated in current Tax Year.
IQB-STP - STP Audit Report
IQB-STP - STP Audit Report will review Employee records looking for potential STP Errors, e.g. Incorrect or missing address information or employees with 000000000 as the TFN. Review the data on the report and correct any errors.
The IQ has one parameter, Include Terminated. Enter 1 to Include them or 0 to exclude. For End of Year, enter 1 to review all employees not just current.
IQ-YTDVAL - YTD Totals with Reporting and Subgroups
IQ-YTDVAL - YTD Totals with Reporting and Subgroups compiles the Year-to-Date amounts per Pay Component broken down into Reporting Groups and Subgroup details. This report could be used to balance to STP Update.
The IQ has three parameters:
Tax Year - enter the Tax Year ending you want to review.
Payroll Company Code - enter the Company Code to review the company individually or leave the parameter blank to include all companies. If you are comparing this information to STP Update you should enter the same code as you use in STP Update, as STP Update is run one Company at a time.
Pay Frequency Code - enter the Frequency Code to review the frequency individually or leave the parameter blank to include all. If you are balancing to STP Update, leave this blank to include all employees.
For details see STP Update and IQ-YTDVAL.
IQ-RFB - Display RFB for all financial years
IQ-RFB will extract FB (Reportable Fringe Benefit Tax) details that were entered onto the Employee record in Tax Year ending 2020 and onwards. You can use this report to review the specific year or all financial years.
There is one parameter for this report, which is Financial Year. You can enter the year in the Value column or 0 for all years. For End of Year reconciliation enter the current Tax Year.
IQ-STP2FEI - STP 2 FEI Report by Financial Year
IQ-STP2FEI - STP 2 FEI Report by Financial will extract STP2 FEI (Foreign Employment Income) details that were entered into the Employee record in Tax Years after you enabled STP2. You can use this report to review the current tax year or a previous tax year. Filter the data in the grid if required, e.g. if data for more than one Tax Year appears, you can filter the Tax Year column to show only the year you need.
The IQ has five parameters:
Tax Year - enter the Tax Year ending you want to review.
Payroll Company Code - enter the Company Code to review the company individually or leave the parameter blank to include all companies.
Pay Frequency Code - enter the Frequency Code to review the frequency individually or leave the parameter blank to include all.
Include Terminated - Enter 1 to Include them or 0 to exclude. For End of Year, enter 1 to review all employees not just current.
ETP Cap for Death Benefits - is subtracted from the employee's ETP (post June 83) to show an amount in the ETP D - Taxable column of the report if Death Benefit ETPS were processed. The field defaults to 230000, which was the cap for 2022/2023. Refer to the ATO for death benefit ETP Cap amounts for other years.
IQ-FBFEI - FB & FEI Values
IQ-FBFEI - FB & FEI Values will extract FB (Reportable Fringe Benefit Tax) and STP1 FEI (Foreign Employment Income) details that were entered onto the Employee record in Tax Year ending 2020 and onwards. You can use this report to review the current tax year or a previous tax year.
There is one parameter for this report, which is Financial Year. For End of Year reconciliation enter the current Tax Year.
Note: Any FEI information that was reported after you enabled STP2 won't appear on this report. You can use IQ-STP2FEI to see these values, refer above.
IQ-FEISTP1 - Display FEI for selected STP1 financial year
IQ-FEISTP1 - Display FEI for selected STP1 financial year will extract STP1 FEI (Foreign Employment Income) details that were entered onto the Employee record in Tax Year ending 2020 and onwards. You can use this report to review previous tax year data.
There is one parameter for this report, which is Financial Year, enter the year you want to extract details for.
Note: Any FEI information that was reported after you enabled STP2 won't appear on this report. You can use IQ-STP2FEI to see these values, refer above.