Thank you for visiting our Partner Zone. This area is an exclusive space for MYOB Partners. Find out how to Partner with MYOB.
March 2020
March 2020
Each month once i have finalsied payroll I check that the totals on the Year to Date Verification report match the totals on the Payroll Activity Statement.
LAst month (Jan) it was fine, I have now run a report again today to check and i can't get the GRoss payments to match. All other categories matcs
I have not set up any new payroll codes this month, it was a normal payroll. So I am unsure as to why things balanced last month, but not this month.
Any ideas on where or what I should look at to find the problem?
Thanks,
PS - I finish work shortly for the week, so will hopefully be sorting this out first thing Monday morning
Solved! Go to Solution.
March 2020
March 2020
Hi @LisaGSA
Thanks for your post. When reconciling payroll the first reports I used to check were the Payroll Activity Summary and Payroll Register Summary. This is because the Activity report gets it's data from pays recorded through Process Payroll. The Register report gets it's data from the Pay History tab in the employee card. STP reports also get their figures from the Pay History tab in the employee card.
When the Activity and Register reports don't match it generally means that a manual adjustment has been made in the Pay History tab of the employee card.
If the Activity and Register reports do match, then it's time to look at the ATO reporting categories. Check for any payroll categories that you've paid for the first time in that month, eg, annual leave, leave loading, personal leave. You can run the Activity Detail report to get a break up of the payroll categories. Check the different categories to see if one of them is the amount you are out of balance by.
Please let me know if you need further help.
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.
Cheers,
Tracey
Previously @bungy15
MYOB Community Support
Online Help| Forum Search| my.MYOB| Download Page
Did my answer help?
Mark it as a SolutionHelpful? Leave a to tell others
March 2020
March 2020
Hi Tracey,
Thanks for the reply. I have run the Payroll Register and Payroll Activity Summary reports and checked these against each other. Both match.
I have now run the payroll summary and checked these totals against the Year to Date Verification report and all of the ATO reporting categories match the totals on the payroll summary (i have grouped everything into the applicable category) except for the "ETP - Tax Free Component"
The issue here is, this is not a new item, it has been used previoulsy and up until this month, it was always balanced. IT was used for 1 emplouee this pay, and the difference i have is not related to that particular employees payment.
I have now run the Payroll Category Transactions report and cross checked these against the employee totals in the YTD Verficiation report and have found the employee record that is causing this issue
I will need to run a zero pay for the employee to send through updated YTD's to correct this.
Im not sure why this has happened though, so if you have any insights that would be good to know.
Thanks
Lisa
March 2020
March 2020
Hi Tracy, I should have checked this before I hit reply, but running a zero pay has not worked.
For some reason the YTD Verification Report is overstated for this employee and is causing this issue.
But after looking at her YTD income and comparing this to the Payroll Register/Activity Summary and the YTD Veriifcaiton Reports there are discrepancies.
Who would be the best person to talk to to get this sorted?
Thanks,
Lisa
March 2020
March 2020
Hi @LisaGSA
Sorry to hear you haven't been able to resolve this. You can send me screenshots of those reports by private message and I'll have a look into it for you.
Cheers,
Tracey
Previously @bungy15
MYOB Community Support
Online Help| Forum Search| my.MYOB| Download Page
Did my answer help?
Mark it as a SolutionHelpful? Leave a to tell others
March 2020
March 2020
Hi Tracey,
Just checking to make sure my private message came through and if you have had a moment to look into my query.
Ta.
Lisa
March 2020
March 2020
Hi @LisaGSA
I do apologise for the delay in replying. I have looked at your reports and responded to your private message.
Cheers,
Tracey
Previously @bungy15
MYOB Community Support
Online Help| Forum Search| my.MYOB| Download Page
Did my answer help?
Mark it as a SolutionHelpful? Leave a to tell others
March 2020
March 2020
Hi @LisaGSA
Thanks so much for working with me, I'm glad we were able to resolve your issue.
For the benefit of other users who may see this post:
If you delete and reprocess a termination pay with ETP, you also need to delete that ETP payment from the Payroll Reporting Centre by following the steps below:
Please don't hesitate to post again if you need further help.
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.
Cheers,
Tracey
Previously @bungy15
MYOB Community Support
Online Help| Forum Search| my.MYOB| Download Page
Did my answer help?
Mark it as a SolutionHelpful? Leave a to tell others
July 2020
July 2020
After the debarcle with YTD figures not reconciling to the Summary of Reports I am now down to just two employees to sort out.
1. Last pay advice has a YTD figure for unused RDO of $157.28 and ETP -Tax withheld of -$50, however Summary of Payments has taken these two figures and multiplied them x4?
2. Last pay advice has a YTD figure for unused RDO of $416.46 and ETP-Tax withheld of -$133.00, however Summary of Payments has taken these two figures and multiplied them x2?
Any suggestions on how to fix please.
July 2020
July 2020
Tracey,
Thank you so much for the instructions on removing ETP payments through the Payroll Reporting Centre. This has explained how two of my employess had their ETP double and quadrupled because he person who termianted them obviously took several attempts.
I just with the person I spent 1.75 hours on a chat with last Tuesday could have told me this, would have saved me hours of reading.
41
|
2514
|
|||
by
H-TS
a month ago
1
137
|
1
|
137
|
||
7
|
554
|
|||
1
|
189
|
|||
1
|
534
|