Partner Zone

Discrepancy in YTD Verification Report and Payroll Summary

BessSMC
Contributing User
9 Posts
Contributing User
Contributing User

9Posts

0Kudos

0Solutions

Discrepancy in YTD Verification Report and Payroll Summary

Hello,

 

I am having issues with My Payroll Activity (Summary) report (wages total = $89,750.17) and YTD Verification Report (wages total = $81,405.31) not matching.  Resulting in employees receving incorrect figures on their pay advice.

I have checked categories and all are correct. I have done $0 pay runs, still no help.

I get an error message of "The derived aggregated gross YTD amount must not be a negatice amount (ATO error code: CMN.ATO.PAYEVNTEMP.000389)

 

Please help!

5 REPLIES 5
gavin12345
Ultimate User
4,007 Posts
Ultimate User
Australia
Ultimate User

4,007Posts

1,168Kudos

533Solutions

Re: Discrepancy in YTD Verification Report and Payroll Summary

Hi @BessSMC 

 

Do any of your employees salary sacrifice? - there is a problem with MYOB and how Salary Sacrifice is reported, this could explain the error you mention, and perhaps the discrepancy as well.

 

My understanding is the Verification Report shows what is being reported to the ATO. First check your Payroll Register Summary YTD report matches the Payroll Activity Sumary report for the period 1 July 2021 to 30 June 2022. If yes then problem likely lies with a Payroll Category you have used but not Assigned to an ATO Reporting field, or it has been assigned to Not Reportable.

 

Hope this helps narrow down the search.

 

Regards

Gavin

BessSMC
Contributing User
9 Posts
Contributing User
Contributing User

9Posts

0Kudos

0Solutions

Re: Discrepancy in YTD Verification Report and Payroll Summary

Thanks Gavin.

 

My EOFY payroll reports all matched as to what was reported to the ATO for FY 20221-22.

This error has only occured this FY and has not effected the employee who uses salary sacrifice, mind you, it does effect all employees AFTER in the report.

I am not getting any help from MYOB help line, as the same effected employees YTD balance is completely wrong and were the only ones effected by the error code, throwing base hourly YTD balance figures into disarray. We have approx 20 employees but only 7 have been effected.

gavin12345
Ultimate User
4,007 Posts
Ultimate User
Australia
Ultimate User

4,007Posts

1,168Kudos

533Solutions

Re: Discrepancy in YTD Verification Report and Payroll Summary

Hi @BessSMC 

 

You mentioned FY 2021/22 was reported correctly - was this using Phase 2 (or Phase 1). Most of the problems MYOB users are experiencing relates to Phase 2. 

 

Remember also that with Phase 2 the total paid to an employee will be Gross Amount plus things like overtime, bonuses, leave etc which now must be reported separately.

 

MYOB have tried to fix some of the bugs (including the salary sacrifice bug) and some of these changes may have caused the issues you are having. 

 

To be fair to MYOB, many of the errors users report are actually user errors, but certainly not all. If the issue you are experiencing is caused by a bug in the software, this would be affected all users, not just a few.

 

For example starting to use a new (or old) payroll category that has not yet been assigned to an STP Reporting field etc. As such it would be helpful if you could provide an example, for example a screenshot of an employee's Payroll Register Detail YTD report in MYOB, and the Verification report for the same employee. Blur out or cover any employee name or TFN etc but show all the details.  Or if not a screenshot, simply list the details from both reports in a post. Someone seeing the figure might be able to identify the issue.

 

Regards

Gavin

 

 

BessSMC
Contributing User
9 Posts
Contributing User
Contributing User

9Posts

0Kudos

0Solutions

Re: Discrepancy in YTD Verification Report and Payroll Summary

Hi Gavin,

 

Yes we are currently using STP Phase 2 and have not had any issues until this FY.

 

I have attached our current Payroll Register / Payroll Activity / YTD Verification Report FYI. 

 

We do have an employee who salary sacrifices but the YTD figure for this employee is not effected, only employees named after???

 

Thanks

Bess

gavin12345
Ultimate User
4,007 Posts
Ultimate User
Australia
Ultimate User

4,007Posts

1,168Kudos

533Solutions

Re: Discrepancy in YTD Verification Report and Payroll Summary

Hi @BessSMC 

 

Based on your documents, the Verification DOES agree with your Payroll Register YTD Summary. The problem is the Payroll Register Report does not agree with the Payroll Activity Report - this suggests either someone has changed some figures in the Payroll Register manually, or MYOB has failed to record correctly. 

 

See this article for more information. 

 

MYOB's article suggests the only way this can happen is if someone manually changed the figures. Anyone who has access to the payroll history could change this. OR it could have been a fault in MYOB. 

 

Fortunately there is a way to tell if the change has been made by a user or was caused by a MYOB glitch, however a specialist would need to examine the file. Let me know if this becomes an issue.

 

Regards

Gavin

 

Didn't find your answer here?

Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post