How to adjust Total Gross Value in Single Touch Payroll for Reckon Hosted?

skhong
skhong Member Posts: 3 Novice Member Novice Member

I need to adjust the total gross value showing in Single Touch Payroll to align to the Total Year Payroll Summary for FY22 to finalize EOFY, how do I change this value to show the correct amount, the Total PAYG is correct but the Total Gross is different, please assist thanks.

Comments

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,703 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    Any adjustments for corrections need to be done in your Paycheques within your Hosted program. However, it sounds more like your STP mapping isn't quite right (eg one or more of your Payroll Items that should be linked to Gross Payments, isn't ?)

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Kathyd
    Kathyd Member Posts: 99 Reckoner Reckoner

    HI , I have the same problem. I'm only new to Reckon but I also noticed our Gross Figure is different to the Gross Figure on Reckon Payroll Total.

    What should make up the Gross Figure? thanks

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,703 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    " ... our Gross Figure is different to the Gross Figure on Reckon Payroll Total ..."

    @kathyd Where are you looking at the Gross Figure that's different ?

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Kris_Williams
    Kris_Williams Member Posts: 3,579 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    Check the totals in your payroll for the year, then go to Gov Connect and compare the figures in the details section of your last submission for June, they should match

  • skhong
    skhong Member Posts: 3 Novice Member Novice Member

    Thanks for all your feedback, the discrepancy emanates from a employee who was a casual and then worked extra hours past the threshold requiring the payment of super for part of the financial year. Therefore in the Payroll Summary for the year the total gross pay amounted to $11,418 and the super amount is $656 totaling $12,074. When I print out the PAYG Payment Summary, it shows $12,074 and the Total Gross Pay is $12,074 in STP for this Casual Employee so is this amount correct or do I need to adjust the Payment Summary to show $11,418 excluding the Super payment. If I need to adjust it to $11,418 in the Payment Summary, do I make this adjustment using Set Up YTD amounts for this casual employee only to $11,418 and then run the STP payroll again, is that correct solution? If that is, then I need some guidance on how to Set Up YTD Amounts to make this correction, any video on this, shall explore this approach if it is the correct approach thanks.

  • Kris_Williams
    Kris_Williams Member Posts: 3,579 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    Super payment is not included in the gross figure on the payment summary. As Shaz says it sounds like something is not entered correctly in the payroll items. Have a look at the account the super (SGC) is linked to, it may be incorrectly linked to gross wages. You can’t just adjust the payment summary

  • skhong
    skhong Member Posts: 3 Novice Member Novice Member
    edited July 2022

    😀Thanks Kris and Shaz, I just rectified the error checking the Payroll Item List and had the Super Account set with tax tracking to Gross Payment instead of None. All other Super funds were set to none, this was incorrectly set to Gross Payment. I tried YTD Setup but felt that was an incorrect approach. Problem solved and lodged STP just then. Thanks ladies for your contribution, hope this solution will benefit others as it was a configuration error that I didn't pick up and now rectified, thanks and hope you'll have received a top up in a zillion karma credits!

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,703 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    Good to hear you got it sorted ☺️

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Kris_Williams
    Kris_Williams Member Posts: 3,579 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    You’re very welcome, always a relief to get a problem sorted

  • JillO
    JillO Member Posts: 16 Novice Member Novice Member

    Hi, I've just generated an EOFY report but notice that the gross payment amount is incorrect for 1 employee. This seems to be because the salary sacrifice amount back in the third quarter of last year (entered under RESC) was deducted from the gross earnings amount, creating a seemingly false earnings amount. (Please note, I am only required to submit quarterly STP reports, being a small business). No salary sacrifice payments were made in the other quarters, so those figures are fine. I am wondering if I need to go back and somehow adjust the September quarter gross payment amount or can I just adjust the EOFY gross payment amount to the correct figure or will it automatically adjust after submission?

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,703 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited July 2023

    Hi @JillO

    Salary Sacrifice super is deducted from gross. Under STP1, the Adjusted Gross in your report is the amount that should be reflecting under Gross in the portal.

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • JillO
    JillO Member Posts: 16 Novice Member Novice Member

    Ok thanks, so just leave it as is then to submit EOFY report?

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,703 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    Click on the Detail link of your uploaded Draft STP submission. This shows the further breakdown (with the Detail link there showing the specific category reflections for each employee)

    These figures should match with your report totals ☺️

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • JillO
    JillO Member Posts: 16 Novice Member Novice Member

    I have the unsubmitted EOFY report for the employee on my screen and it lists the total gross pay (the 'incorrect ' figure by me) , tax withheld, super & RESC amounts. Is this what you mean by 'details'? I can't see any reference to draft or details on the screen.

    I thought the gross pay should not include the salary sacrifice amount as it is an extra employer payment in addition to the what I regard as the gross payment. When I calculate the gross payment I don't include the salary hours and simply add them as a separate amount under RESC. Is this correct then?

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,703 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    The gross pay in the report shows the gross Payroll Items added so there needs to be a gross amount to deduct the RESC from. But the Adjusted Gross is the amount that reflects as Total Gross in the portal (as per the old “Gross” figure that would show on the old Payment Summaries eg less RESC):

    The above summary initially has a Draft button to the far right, which you click on to Submit

    If you click on the Detail Link, it shows each employee's specific totals:

    ... & clicking on an employee's Detail link will show their individual category breakdown:


    If the adjusted Gross is not reflecting as Gross Pay in the portal, it means it’s not mapped correctly in your RESC Payroll Item.

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)