Unable to reconcile STP
Hi MYOB I am stuck - 1 client cannot reconcile STP Reporting with ATO figures. I have tried everything - all the tricks that have fixed things and nothing works. Yes this client started l...
Forum Discussion
Hello The_Doc
I did notice you posted a similar issue on Friday and that post has been answered this morning by one of our moderators. The posts are slightly different, but I wanted to check if the troubleshooting advised in your other post has assisted you with this issue? To reiterate that advice here, when AccountRight reports are not matching STP reports, the first place to start is in comparing the Payroll Activity Report and Payroll Register Report summaries. I would recommend checking the articles linked in your other post and the advice re: comparing your reports to help narrow down why those particular employees are still not reconciled.
Yes I ran the post twice - and I have followed Tracey's checklist even though I do all that anyway.
The problem remains and none of your posts or checklists cover the problem
I set their STP up - all categories are allocated correctly (however if they weren't the figure missing from the EOY reconciliation would be match and unmatched category) it does not.
I am not sure you are reading my post correctly - just assuming there is something wrong with the setup (which I cannot trace)
To reiterate
1. The last payroll report sent to the ATO actually for all staff is correct.
2. However - the EOY in the PAyroll reporting centre for 6 out of 11 staff is incorrect (even though what has been sent to the ATO is correct)
3. All payroll categories are correct
4. All payroll reports - YTD totals, summaries etc show everything correctly processed in MYOB
5. If I run a $0 payroll for these staff - it does not correct the figures in the reporting centre yet the Summary report that goes with that payrun is correct (which the ATO has with the last pay run done and authenticated and sent).
On each staff members in the reporting centre - if I click and download the EOY report (similar to the old PAYE Summary - they are wrong for 6 of the 11 staff - yet the amounts wrong include Gross payments, PAYG and super.
If I run a paycheque for eg. 1 member correcting these figures - for 1 member their Gross was low 24139.50, their PAYG low by 5712 and their super low by 2274.30 - so I ran a paycheque for these amounts - but didn't declare and send to the ATO.
This sits unsent.
I then deleted that paycheque
The report that goes with that paycheque incorrectly reports the YTD totals in excess of the real values (as expected) for Gross, PAYG, Super - however - the Reporting centre for this staff members does not update to the correect amount.
MYOB there is a problem or I am missing something!!!!
The Doc
Hello The_Doc
I do apologise that none of the linked articles or troubleshooting steps in your other post have assisted. I understand you have gone through the steps advised and I don't doubt that you have spent a great deal of time trying to solve this. But in order to better assist you, it would be very helpful if I could hear what the outcomes of those steps were. I do appreciate the information you have given, but without being in front of your software and reports, it can be a challenge to visualise exactly what may have happened in order to pinpoint the issue.
Based on the troubleshooting steps advised in this post: AccountRight reports don't match STP, you could let me know how the following turned out:
1. Do the Payroll Activity Report summary and Payroll Register Report summary match? If they do match, how did it go when you:
- Run the Payroll Activity Detail report to narrow down which payroll categories are causing the problem.
- Check that the correct ATO reporting category has been assigned. Change the ATO reporting category as required. Noted that you did mention you have checked this.
- Check if the payroll category has been ticked exempt from PAYG in error (Payroll Categories>>open the category>>click on the 'Exempt' button). Untick PAYG Withholding and click Ok.
- Once you have made the necessary changes to the payroll category, process a $0 pay dated 30/06/20 to update STP.
2. If they do not match (this indicates a manual adjustment was made in the Employee Card), please refer to the Employee Cards of the employees in question and ensure no data there has been edited throughout the year. If it has, you will want to change the figures back to the correct amounts and process a $0 pay dated 30/06/20 to update STP.
Please let me know how the above looks in your reports and I will do my best to help determine where something may have gone wrong.
Hi Emily_B
I will try to answer all the questions you have asked again and will upload a collated file of screenshots.
Let me give you real figures - I will refer to a person called DB - (an actual staff member).
DB is the 2nd line down YTD 45898.30 PAYG YTD 10,924 - these are wrong
Screenshot 2 is the Summary of Payment for this staff member.
Screenshot 3 is the payment summary YTD for the same employee that went out on the last payroll run for this client whose reports were sent to the ATO.
Now lets us goto the Payroll Activity Summary report Screenshot 4 - the top red arrows points to this staff member.
Look at screenshot 3 - add back the meal allowance and the Gross on the Summary Report is exactly correct - as is the Report that has been transmitted to the ATO.
I have checked ALL staff members and what has been sent with the last payrun to the ATO is absolutely to the cent - correct.
Screenshot 5
Payroll Activity Detail - for the staff member which matches the ATO report exactly - just subtract meal allowance from the gross to get the ATO gross.
This report has been checked for all staff members.
For this staff member the difference between the correct amount
Gross 78954.80; Allowance 878.85; PAYG 18972 Super $6487.47
is Gross $33056.50; Allowance $418.50; PAYG 8048; Super $2697.06 (which suggests some pays didn't get transmitted) - but that isn't how it works because each payrun sends YTD figures.
Also if a particular category wasn't correctly allocated to Gross Payments (ie left unassigned) that would be obvious - because only the Gross would be out - but PAYG is correctly allocated; Super is correctly allocated, allowances are correctly allocated - they must be because some of it is showing.
Also the screeshot 5 would make it easy to see which category is not allocated - but following my reasoning the problem is not a category allocation problem - it cannot be.
Screenshot 6 is the Payroll Register Summary report exactly matching the Payroll activity
Screenshot 7 is a $0 payrun for DB to flush the figures
Send Payroll info to the ATO - CANCEL - continue without Declaring
Screenshot 8 - zero payrun
Screenshot 9 - the unsent YTD totals created from this $0 payrun to flush the figures correctly.
It matches what has already been sent to the ATO - they match the MYOB payroll summary
Go to the payroll reporting centre - and the figures for that staff member haven't changed remaining fixed on the wrong figures
Screenshot 10
I believe I have answered all of your questions in 1. below
Question 2 is not relevant - there are no differences between the flushed report on a $0 pay and the actual ATO received reports - MYOB is correct and allocating correctly - the reports to the ATO are correct.
THE PAyroll Reporting Centre is just not updating correctly despite getting inputs from MYOB.
Please look at the 1st person on this report - YTD 70,344.80 PAYG 15,932 ; meals 1395; Super 5291.12 for staff BS. - screenshot 11 - which is correct now - but was previously wrong and low by
$30,397.50 Gross; meals 558; PAYG 7166; Super 2887.76
To correct this - I 1st ran a $0 payrun on this staff member - this didn't fix it and it should according to your instructions.
I then ran a payrun for this staff member BS with a Gross of $30,397.50 ; meal $558; PAYG 7166 and super for $2887.76 - ran the pay - cancelled the declaration - then deleted that pay in MYOB leaving the MYOB figures correct.
Screenshot 12 is the unsent Payroll Report - which should have flushed the Payroll Reporting centre to these figures (which are in excess) - but what it did was correct the PAyroll Reporting to the correct figures for this employee.
However. the same process did not work on any of the other employees no matter what I did - $0 pays or adjustment pays.
The Payroll Reporting Centre is just not getting things right.
The Doc
Hello The_Doc
Thank you so much for the additional information and the screenshots; both are very helpful in trying to understand what is happening behind another screen. While I am happy to continue assisting you, I've kept my eye on your other posts as well and can see those conversations have continued. I believe that you receiving troubleshooting steps across three different posts will only muddle things further, which is certainly not what we want. As far as this thread goes, I will respectfully let you know that Tracey will be working through this with you from this point on for clarity's sake. I've referred her to this thread and she has accessed the screenshots you have provided in your last post here.
