Essentials reports don't match my STP reports?

[Tracey_H]

Hi everyone

You're reconciling payroll and the payroll reports don't match the STP reports, where do you begin to look for what's causing those out of balance issues?  

In Essentials, you can start by running the Payroll Detail report and the Summary of payments to check the YTD amounts on an employee level. Narrow down which pay items don't match and then check that the correct ATO reporting category has been assigned to those pay items. If you make any changes to ATO reporting categories you will need to process a $0 pay to update STP.

Another thing to check for is pay items that have Non-Taxable selected in error. To fix this you will need to change the Tax field to Taxable and process a $0 pay for affected employees.

Where do you find these reports: 

• Payroll detail is found in Reports>>Payroll reports
• Summary of payments is found in the Payroll Reporting Centre>>EOFY finalisation tab>>click on the ... button for the individual employee

If you're still having problems reconciling for EOFY or need further assistance, please feel free to start a new post.

[Amelia_P]

Hi Tracy,

Appreciate the suggestion however, it would be extremely helpful when reconciling to have a Summary of payments sent through STP for ALL employees in the Payroll Reporting Centre>>EOFY finalisation tab. And also be able to extract the sumaary into excel format.

It has been a very frustrating process trying to identify incorrect ETPs. We have over 500 employees.

Amelia

[Tracey_H]

Hi @Amelia_P 

Thank you for that feedback. I understand that would be beneficial for users and have passed it on to the relevant teams.

Please do let me know if you need assistance.

[befly_b]

Hi,

Thanks for the reply. The payroll detail report has the correct amount earned, correct tax paid. The summary of payments is wrong, it only shows the first week of July 2019, the employee worked another 12 weeks and it's not showing. I can't get a hold of the bookkeeper who installed MYOB and I'm finding it frustrating as I'm new to all this. 

[Tracey_H]

Hi @befly_b 

Can you please try processing a $0 pay with payment date 30 June, wait until that report is accepted in the Payroll reporting centre and then check the YTD verification report?

Please let me know how you go with this.

[befly_b]

Hi, do I do this just for the one employee I'm having the problem with?

[befly_b]

I've already tried that and it didn't work.

[Tracey_H]

Hi @befly_b 

If you compare the Payroll activity report and the Summary of payments, as explained above, are you able to work out which pay item is missing from the summary of payments?

[befly_b]

Hi, I can get the Payroll Detailed Report and it shows all the correct pays. The Summary of Payments is wrong and only shows the employees first pay of the financial year (2019/20), there should be another 12 weeks of pay showing. I don't understand why it's not. 

[Tracey_H]

Hi @befly_b 

The summary of payments and YTD verification report use the ATO reporting categories to filter the amounts in the MYOB payroll reports. If the ATO reporting categories are wrong, the summary of payments and YTD verification report won't be filtering the YTD amounts correctly.

First thing to try is a $0 pay as it can refresh the YTD verification report so that the correct amounts are reported, if this doesn't work there is a problem in your setup. Can you process a $0 pay with payment date 30 June, wait until the STP report has been accepted in the Payroll reporting centre, then check the YTD verification report. If the YTD verification report is still showing the wrong amounts, please do the following:

Use the Payroll Detailed report and Summary of payments to work out which pay items are not on the Summary of payments. Once you know which pay items are missing check that the correct ATO reporting category has been assigned to those pay items. If you make any changes to ATO reporting categories you will need to process a $0 pay to update STP.

Another thing to check for is pay items that have Non-Taxable selected in error. To fix this you will need to change the Tax field to Taxable and process a $0 pay for affected employees.

Once you have worked out which pay items are missing let me know and we'll troubleshoot further.