super report & STP incorrect salary sacrifice YTD

Hi Reckon people. I have a problem with 2 STP files. Employee cash in of holiday pay, unscheduled payroll Monday 07.02.22, salary sacrifice $50 deducted. In a rush last Monday, i didn't lodge the STP file, and have done today before lodging the regular payroll STP for today. I also hadn't pulled all of the reports for the unscheduled payroll Monday 7th until today. Now that i have, i see the $50 salary sacrifice isn't in the super report by employee for the 7th, it IS included in the payroll totals and payroll summary for the 7th. It is also showing in the super report by employee for today's payroll 11th Feb. When i processed the leave cash in on Monday, i removed everything except the leave line in the employees 'paycheque' window, which i thought was the right way to do it, though now i'm not sure? Can someone please advise what i need to do, to fix the problem, so the correct YTD figure of $850 shows on the super report by employee, after the payroll run on the 7th, and the correct figure of $900 shows after the payroll run today 11th Feb. I imagine then, the STP file will pick up the correct salary sacrifice figures for the employee, and i can update to STP files lodged. Thanks in advance. Regards Sue

Comments

Acctd4

Hi Sue

I'm not sure if I'm clear on your query but STP submissions don't report each paycheque's amounts, they simply update the YTD balances each time. This means that the current YTD balances in your STP will be as per your most recent successful STP submission.

You can check an employee's YTD balances in the Reckon GovConnect portal by clicking on the submission's Details link 😊

Sue_10586997

Hi Shaz. I'm sorry, i wasn't very clear before, typical me..

The YTD figures are wrong in the STP file as well as the super report by employee, both for the 7th of FEB and YTD. The 'super report by employee' report DOES show the salary sacrifice amount in the 'amount' column, but DOES NOT show in the RESC column. This of course filters through to the payroll i ran today for the 11th for the YTD SS figure.

I'm wondering if it's something to do with the unscheduled payroll i ran for the leave cash in on the 7th?. I deleted all of the other payroll items in the review paycheque window when i ran the payroll, as it was a cash in of leave only, no salary etc.. for that date. But the SS was still being deducted, so i left it. I don't know if that had an impact on how the salary sacrifice gets picked up? but its the only way i can work it to process any cashed in annual leave, remove the other payroll items when processing the payroll, or it changes the rates etc on the other payroll items if they're left there, and it doesn't workout as needed.

The 'super by employee' report, YTD and for that pay period, the 7th of FEB, both INCLUDE the SS $50 in the 'amount' column, (column shows SGC & SS) but not in the 'RESC' column for the 7th. 'Amount' column YTD has 17 x $50 = $850 SS, the RESC column has 16 x $50 = $800 SS.

The 'payroll totals' and 'payroll summary' reports are correct, both for the payroll date, and the YTD figures.

The STP file is showing the incorrect YTD amount that is showing in the RESC column in the 'super by employee report' both $50 less than they should be.

I hope this is a bit clearer / better explained, i really need some help to sort it out so my reports are correct and the STP files are correct.

Thanks

Sue

Acctd4

Ah OK Sue ... this is a known link dropout glitch & is easily rectified 😀

Generate the Super Report by Employee
Click on Modify Report & on the Display tab, scroll down the Columns list & tick the RESC Amount to add this column to your report
Open each Paycheque that has a RESC/SS Payroll Item amount that is not displaying in the RESC Amount column
Unlock the Paycheque, delete the RESC Payroll Item line, then re-add it again
Save the updated Paycheque & Refresh the report to check - You should now see the RESC amount correctly displaying in the RESC Amount column

It's a good idea to run this report each time to check as this will alert you to when it happens & allow you to correct it prior to your STP submission 😊

Sue_10586997

Hi Shaz

I pull that report for each payroll i process because of an issue i had a while back you helped me with (thanks) and i always add the RESC column as a check point because of it

i've deleted and re-added the SS payroll item (a few times) and yes, it pulled the SS amount across HOWEVER now it's also pulling the SCG amount into the RESC column as well?? and not only that, it's calculating the SGC on the regular gross salary for the person, not the cashed in leave amount only, which is the only payroll item i've got in the 'earnings' window, i deleted all others for this specific unscheduled payroll, because it's just a leave cash in only, not a regular salary payroll.

super should be $200 only, but it's calculated well above that?

can i manually adjust the SGC amount in the paycheque window without it causing any issues?

as far as the salary sacrifice goes, i'm going to pull it from the leave cash in payroll, work out the difference owing in tax and add it to the next payroll, just manually adjust the tax payable if i can do that without it causing any issues. We pay super monthly, so it's not an issue

all agreed to by the employee, it's only $18 diff in tax

but, i'm very interested to know why the SGC is being pulled across to the RESC column now as well as the SS amount

? very confused

sue

Acctd4

Hi Sue

Sometimes the glitch can impact the regular SGC Super too - just do the same (delete & re-add) on the affected SGC lines & that should correct it 😊

DMH

I would like to know when this issue is going to be fixed.

About one in ten of my payroll runs/STP files get the numbers correct. Most often, it is the RESC amount that is incorrect with some random number calculated for several of our employees.

I understand the way to "get around" this issue, but when is a permanent fix going to be seen as a priority?😫

AISptyLTD74

i HAVE A SIMIALR PROBLEM

THE SALARY SACRIFICE IS SHOWING IN THE SUPER REPORT HOWEVER IT IS NOT FLOWING ON TO THE REPORTING TO STP i HAVE TRIED THE ABOVE BUT IT HAS NOT FIXED THE PROBLEM,

Seems to happen intermittingly

Acctd4

@AISptyLTD74

The previous instructions should fix the specific problem above. If it doesn't, it may be something else eg a configuration/mapping issue for one (or more) of you SS Payroll Items. (This might also explain why it only happens intermittently as it's only when using the relevant one(s))

You need to ensure ALL the SS Payroll Items are correctly configured for STP mapping:

They need to be set up as Super Contribution (Company & Employee Contribution) NOT as Company Contribution:

They also need to be categorised as the correct type eg Employer Additional (EA) or Salary Sacrifice (SS):

They need to be mapped correctly for Tax tracking type (STP). NOTE: SS should have Gross Payments selected here (whereas EA should be set to None):

Additionally, PAYG Tax under Taxes need to be impacted (to specifically reduce PAYG) for SS ONLY (not EA):

AISptyLTD74

Thank Shaz,

The stp report has removed a balance of SS from a previous pay and is less than the SS amount for that employee on the STP reported last pay week.

Acctd4

Which "STP report" are you referring to ? Are you just meaning the amounts displayed on Reckon's STP portal in GovConnect ?

STP updates YTD balances each submission, rather than reporting that specific pay run's amounts. Therefore, it sounds like the previous SS amount has been overridden on a subsequent submission.

I never lodge an STP submission without checking against my customised Payroll Summary first for what the totals should be. Configure this report as This Payroll Year-to-date & to Display columns by [your applicable pay run frequency - eg Week, Two Week etc] This will ensure the latest column displays your latest STP submission. Name this report & Memorise it. You can also add it to your Icon Bar for one-click checking. In addition, I also Modify & Memorise a 2nd version of this report to Display columns by Employee & use this to match my employee totals for my Finalise Year submission.

AISptyLTD74

It is the weekly STP report fromthe GOvt Connect submission.

I balance it every week against the payroll totals & payslip amount.

It was correct up to this pay week paid today. Now last weeks Salary sacrifice amount for only one employee appears not to have carried over to the STP govt connect report today.

AISptyLTD74

I have noted that the Gov Connect report you can print off has changed in readiness for Phase 2 so am not sure if that is the problem on govt connect side.

Acctd4

It shouldn't be as the current (2022) RA is not yet reporting under STP2 for those additional columns.

(Just an FYI ... I don't use the Payroll Totals report as the column amounts are not always broken down in enough detail for reconciling with STP - for instance, it doesn't display EA Super or Deductions - & this report has also been known to be a bit glitchy 😬)

Check the Payroll Summary as per my previous suggestion instead, as well as the specific SS Payroll Item. Feel free to get in touch with me direct if you'd like further assistance with this issue 😊