Payment Summaries not showing Salary Sacrifice

  • 1
  • Question
  • Updated 4 months ago
  • Answered
Wondering if anyone has the same problem or if anyone can help me. I have reconciled wage, payg to the Payment Summary from my COA. The three employees that Salary Sacrifice are out in the Reportable Empoyee contributions - which is their paid SS contributions. These amounts just don't agree and I cannot see where it is. Anyone got a heads up of where to look and why the payment summary is different to every single report I have run. I have also checked Payroll Item List to check what is linked - cannot work it out. Thanks
Photo of Heather

Heather

  • 304 Points 250 badge 2x thumb

Posted 5 months ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,284 Points 5k badge 2x thumb
This happens for some users every year.... solution:
You can run the Super by Employee Report or Super by Fund Report and add the column to display for RESC Amount - but these reports take forever to run...  so I did a fix yesterday - where I went to the Payroll Item list - selected the Salary Sacrifice payroll item I knew was the offender - right clicked and choose Fast Report - then I modified this report to show - This Payroll Year - then I added the RESC Amount column and also removed the tick for Amount and added the ticks for Debit and Credit - then ran this report - the RESC Amount should total the same as the Credit column... if it doesnt (and in your example it wont)... find where it doesnt match... then double click into this Paycheque and the Details... Unlock it (taking note of the Net Pay amount so you are sure it doesnt change)... then what I do is go to line for the Salary Sacrifice... add a 1 to the front of whatever the amount is...Click Ok - this takes you back to the Paycheque - now click into the detail again...Remove the 1 from the front of the line for Salary Sacrifice... Click OK... then click Save and Close - this will take you back to the Fast Report and the amount should now appear in the RESC column correctly - repeat until everything balances and then check your payment summaries again.  Hope this helps...PS!!! Make sure the Net Pay does not change!!!
(Edited)
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,284 Points 5k badge 2x thumb
ok - so there must be another super payroll item used for that person - where it has picked up the RESC of $300 in error... modify the fast report in my first example - and select their normal SGC super item... or any other super items used for that person throughout the year - one of them will have the offending RESC amounts in them and the same unlock, change, save, unlock revert, save process should fix it..
Photo of Heather

Heather

  • 304 Points 250 badge 2x thumb
thanks will try that :)
Photo of Heather

Heather

  • 304 Points 250 badge 2x thumb
Gosh Linda - there just isn't it is so bizarre - there are no other payroll items or amounts besides the ss which has the same amount in SS and RESC - all the other payroll items are 0 in RESC  Another quick note - a list of the ss has also been kept in a spreadsheet and it agrees to my quickbooks records and not the Payment Summary.
(Edited)
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,284 Points 5k badge 2x thumb
ok - it will be there somewhere - you might need to run the Super by Fund report with the RESC column - which takes ages - but is usually the surefire way to find it... if you want me to teamviewer in to your desktop and see if I can find it for you - email me and we can work out a time to do this.  linda@abcomputing.com.au
Photo of Heather

Heather

  • 304 Points 250 badge 2x thumb
Thanks Linda - I have at last reconciiled :)  Thanks so much for your input and help.
Photo of Natalie

Natalie

  • 606 Points 500 badge 2x thumb
Linda.  Thank you so much for this reply.  I had the same problem today and this has fixed the issue for me.
Photo of Karen

Karen

  • 334 Points 250 badge 2x thumb

Hi Linda

This happened with me as well and you information worked perfectly for when the RESC was too low on the payment summaries.  I also have a payment summary showing the RESC above what it should be and the report you suggest has no errors.  Do you know what I can do in this situation?

Thanks

Karen

Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,284 Points 5k badge 2x thumb
this will mean another payroll item has inadvertently picked up some RESC when it shouldnt have - so try a Fast report on the other super items used for that person - where you might see some RESC sitting where it shouldnt be?  
Photo of Karen

Karen

  • 334 Points 250 badge 2x thumb

Thanks Linda

I ran a super by employee report with the RESC amount field added and was able to identify the errors.  I then went in and proceeded as above.  This fixed the RESC errors.  I now just have one gross payment error.

Photo of Greta Collins

Greta Collins

  • 176 Points 100 badge 2x thumb
Thank you Linda for this reply! Excellent solution to this!