Unable to reconcile STP

Question

Hi MYOB&nbsp;I am stuck - 1 client cannot reconcile STP Reporting with ATO figures.&nbsp;I have tried everything - all the tricks that have fixed things and nothing works.&nbsp;Yes this client started late in the year - no problem except for terminated before this date - these fixed - untick termination date run $0 payroll - voila fixed.&nbsp;9 employees - half these figures match - have ticked and finalised&nbsp;5 remaining refuse to budge no matter what I do.&nbsp;When problem 1st noticed - difference between last payroll run report accepted by ATO and final figures - no logical reason.&nbsp;So ran a zero payrun for staff member (single to test if fixed) - no change.&nbsp;Then ran payroll for 29/6/20 for single staff member which was difference between ATO figure (which was correct) and finalisation figure in STP Payroll reporting - this fixed it for this staff member.&nbsp;Great - then ran it for other staff members same method - didn't fix/change/alter anthing in Payroll centre.&nbsp;Did it individually - adjustment, then $0 - nothing worked.&nbsp;STP Payroll centre now stuck with 5 staff I cannot reconcile.&nbsp;This is MYOB problem I suspect not ATO.&nbsp;Urgent assistance please?&nbsp;The Doc

tracey_h · Accepted Answer

Hi&nbsp;The_Doc&nbsp;
&nbsp;
It's great to hear you've resolved the issue, sometimes it's just one seemingly small thing that makes all the difference.
&nbsp;
Thanks for letting us know it worked.
&nbsp;
Enjoy the rest of your week.

the_doc · Answer

Hi&nbsp;Tracey_H&nbsp;,&nbsp;Emily_B&nbsp;&nbsp;Finally - thank you.&nbsp;Sending the correct $0 to the ATO (even though they had it) initiated the reporting centre to get it right.&nbsp;Once I sent a $0 payrun for all staff that the reporting centre was getting wrong - it sorted its proverbial and now all balances finally and the EOY Reconciliation for this client is complete.&nbsp;Thank you - and you two kept your cool - I ALMOST didn't.&nbsp;That was hard work.&nbsp;Regards The Doc&nbsp;

emily_b · Answer

Hello&nbsp;The_Doc&nbsp;
&nbsp;
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.

the_doc · Answer

Emily_B&nbsp;&nbsp;Yes I ran the post twice - and I have followed Tracey's checklist even though I do all that anyway.&nbsp;The problem remains and none of your posts or checklists cover the problem&nbsp;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.&nbsp;I am not sure you are reading my post correctly - just assuming there is something wrong with the setup (which I cannot trace)&nbsp;To reiterate&nbsp;&nbsp;1. The last payroll report sent to the ATO actually for all staff is correct.&nbsp;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 correct4. All payroll reports - YTD totals, summaries etc show everything correctly processed in MYOB&nbsp;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).&nbsp;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.&nbsp;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.&nbsp;This sits unsent.&nbsp;I then deleted that paycheque&nbsp;&nbsp;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.&nbsp;MYOB there is a problem or I am missing something!!!!&nbsp;The Doc

emily_b · Answer

Hello&nbsp;The_Doc&nbsp;
&nbsp;
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.&nbsp;
&nbsp;
Based on the troubleshooting steps advised in this post:&nbsp;AccountRight reports don't match STP, you could let me know how the following turned out:
&nbsp;
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.&nbsp;Noted that you did mention you have checked this.
Check if the payroll category has been ticked exempt from PAYG in error (Payroll Categories&gt;&gt;open the category&gt;&gt;click on the 'Exempt' button). Untick PAYG Withholding and click Ok.
Once you have made the necessary changes to the payroll category,&nbsp;process a $0 pay&nbsp;dated 30/06/20 to update STP.

2.&nbsp;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&nbsp;process a $0 pay&nbsp;dated 30/06/20 to update STP.&nbsp;
&nbsp;
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.

the_doc · Answer

Hi&nbsp;Emily_B&nbsp;&nbsp;I will try to answer all the questions you have asked again and will upload a collated file of screenshots.&nbsp;Let me give you real figures - I will refer to a person called DB - (an actual staff member).&nbsp;DB is the 2nd line down YTD 45898.30 PAYG YTD 10,924 - these are wrong&nbsp;Screenshot 2 is the Summary of Payment for this staff member.&nbsp;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.&nbsp;Now lets us goto the Payroll Activity Summary report Screenshot 4 - the top red arrows points to this staff member.&nbsp;&nbsp;Look at screenshot 3 - add back the&nbsp; meal allowance and the Gross on the Summary Report is exactly correct - as is the Report that has been transmitted to the ATO.&nbsp;I have checked ALL staff members and what has been sent with the last payrun to the ATO is absolutely to the cent - correct.&nbsp;Screenshot 5&nbsp;&nbsp;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.&nbsp;This report has been checked for all staff members.&nbsp;For this staff member the difference between the correct amount&nbsp;&nbsp;Gross 78954.80; Allowance 878.85; PAYG 18972&nbsp; &nbsp;Super $6487.47&nbsp;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.&nbsp;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.&nbsp;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.&nbsp;Screenshot 6 is the Payroll Register Summary report exactly matching&nbsp; the Payroll activity&nbsp;Screenshot 7 is a $0 payrun for DB to flush the figures&nbsp;Send Payroll info to the ATO - CANCEL - continue without Declaring&nbsp;Screenshot 8 - zero payrun&nbsp;Screenshot 9 - the unsent YTD totals created from this $0 payrun to flush the figures correctly.&nbsp;It matches what has already been sent to the ATO - they match the MYOB payroll summary&nbsp;Go to the payroll reporting centre - and the figures for that staff member haven't changed remaining fixed on the wrong figures&nbsp;Screenshot 10&nbsp;I believe I have answered all of your questions in 1. below&nbsp;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.&nbsp;THE PAyroll Reporting Centre is just not updating correctly despite getting inputs from MYOB.&nbsp;Please look at the 1st person on this report - YTD 70,344.80&nbsp; &nbsp;PAYG 15,932 ; meals 1395; Super 5291.12 for staff BS. - screenshot 11 - which is correct now - but was previously wrong and low by&nbsp;$30,397.50 Gross; meals 558; PAYG 7166; Super 2887.76&nbsp;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.&nbsp;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.&nbsp;&nbsp;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.&nbsp;However. the same process did not work on any of the other employees no matter what I did - $0 pays or adjustment pays.&nbsp;The Payroll Reporting Centre is just not getting things right.&nbsp;The Doc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Unable to reconcile STP

8 Replies

Related content

Reconcile Payroll reports to STP reports

Unable to Report STP

Unable to set up STP

STP reporting

stp

Error STP Deletion and Reconciling

Unable to Open file

stp