Payment Summaries not showing Salary Sacrifice

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

Heather

344 Points

Posted 1 year ago

1 year ago

Linda Putland, Accredited Partner

15,952 Points

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)

Comment

2 people like this

2018-06-28T02:58:53+00:00

Heather

344 Points

Thanks so much - I have been doing this but still out - will keep trying with all pays - lucky it is only two people.

2018-06-28T03:01:20+00:00

Heather

344 Points

Linda - not sure if you have the answer - but in the report the Super an the RESC column agree now - but it is still different to what shows on the payment summary - for example:
$5200 in SS Balance and $5200 in the RESC balance - however Payment Summary shows $5500 - I am at a loss

2018-06-28T03:07:07+00:00

Linda Putland, Accredited Partner

15,952 Points

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..

2018-06-28T03:09:35+00:00

Heather

344 Points

thanks will try that :)

2018-06-28T03:17:28+00:00

Heather

344 Points

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)

2018-06-28T06:42:35+00:00

Linda Putland, Accredited Partner

15,952 Points

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

2018-06-29T00:05:54+00:00

Heather

344 Points

Thanks Linda - I have at last reconciiled :) Thanks so much for your input and help.

1 year ago

Natalie

606 Points

Linda. Thank you so much for this reply. I had the same problem today and this has fixed the issue for me.

Comment

1 person likes this

1 year ago

Karen

334 Points

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

Comment

1 year ago

Linda Putland, Accredited Partner

15,952 Points

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?

Comment

1 year ago

Karen

334 Points

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.

Comment

1 year ago

Greta Collins

176 Points

Thank you Linda for this reply! Excellent solution to this!

Comment

1 person likes this

5 months ago

Brown Steel

70 Points

I had the same problem balancing my 2018/2019 PAYG summaries. The above steps solved my problem. However I am wondering why Reckon have not rectified this issue that keeps coming up every year.

Comment

2019-07-04T03:43:12+00:00

Linda Putland, Accredited Partner

15,596 Points

Its very hard to fix something that can't be replicated consistently... some files have the issue, some dont. When you are working with code and architecture thats over 20 years old, one needs to be very careful that fixing something doesn't break two other things!

Payment Summaries not showing Salary Sacrifice

Related Categories

Accounts Business Range