Hi everyone
We tell you which reports to run to reconcile your payroll, but why those reports? Let’s have look behind the scenes:
Payroll>>Employees>>Activity Summary – gets its data from the pays processed through Process Payroll, filters by payroll categories
Payroll>>Employees>>Register Summary – gets its data from the employee card>>Payroll Details tab>>Pay History, filters by payroll categories
Payroll Reporting Centre>>EOFY Finalisation tab>>YTD verification report – gets its data from the employee card>>Payroll Details tab>>Pay History, filters by the ATO reporting categories.
The Activity summary and Register summary should always be the same. The only reason for a difference is if you have started processing payroll in the software part way through the year and entered opening balances in the employee Pay History.
If they are different, it indicates that a manual change has been made to the employee Pay History. This means that the YTD verification report will never be right as it is getting the wrong amounts from the Pay History. You need to change the Pay History back to what it was, any changes or adjustments need to be made through Process Payroll. Once the Pay History has been corrected, process a $0 pay to update the YTD amounts in STP.
If they are the same, it indicates that the YTD verification report is not filtering the YTD amounts correctly. The first thing to check is the ATO reporting categories and that payroll categories haven't been exempted from PAYG Withholding in error.
This post has more information to help you: How does STP work
How can you work out which payroll categories are causing the issues with as little stress as possible? Try running these reports:
Payroll>>Payroll Categories>>Payroll Summary – gives you a breakdown of the YTD amounts for each payroll category. Compare this report to the YTD verification report
Payroll>>Employees>>Activity Detail – gives you a breakdown of the payroll categories for each employee.
Payroll Reporting Centre>>EOFY Finalisation tab>>click on ellipsis (…) button for an employee and select download to print the Summary of payments – compare this report to the Activity Detail report.
If you need further help please don't hesitate to start a new post.
