RECKON EOY PAYG Summaries not including Unsued Holiday Pay

Liza Oates
Liza Oates Member Posts: 74 Reckoner Reckoner

I am trying to reconcile my summaries before having to process new payroll on Monday 1 July.

The unusued holiday pay is not appearing on my payroll summaries gross wages. The tax is calculating correctly but gross wages does not include the amount of pay which has been paid to ex- employees. I set this up as a payroll item called Unusued Annual Leave Paid.

I think this may have something to do with STP2 migraton but I urgently need to get my Payroll Summaries reconcilled and uploaded to STP for my EOY Final Report.

Can Someone help?

I have not recorded unused annual leave in termination payments on my payroll tax returns either

In addition I used the same payroll item when someone was made redundant - should I have used a LUMP SUM R for his unused annual leave.

His redundancy pay was set up using Lump Sum D.

Thank you

Liza

Comments

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

    Hi Liza

    STP replaced the old PAYG Payment Summaries - These forms only have minimal labels so are unable to report all of the new STP2 categories. Therefore, they will usually not display the correct amounts.

    Hopefully, you've been checking your submission figures each time. I use a customised Payroll Summary for my regular submissions & also another version for finalising. You'll find my instructions on how to create the per-submission one in this thread here:

    The finalise version is just a further modification of this Payroll Summary - set with Display columns by Employee (rather than by pay frequency eg Week, Two Weeks etc)

    Check the overall FY total & PAYGW on this finalise version against the totals for these in your RAH Process Single Touch Payroll window (NOTE: You need to select Finalise Year, NOT the usual Pay Event option in the dropdown!)

    Upload your finalise STP submission - ensuring you select the SECOND Report Type option in Reckon's portal:

    Once the submission is uploaded, it's in Draft status (& therefore can be deleted if needed) , click on the Detail link at the end of the submission line to display each employee's total pay breakdown. Check these amounts against each employee's totals on your modified Finalise Year report in RAH.

    Once you're happy that everything matches, you can Submit this draft.

    Your setup for Unused AL looks fine apart from the leave accrual - it doesn't continue to accrue on payout as the worker is no longer "employed".

    A "Genuine Redundancy" has specific conditions which determine how it's configured, reported & taxed. It can be complex & can also vary considerably between employers so this is something I would recommend 1-on-1 assistance with. In summary though, it definitely needs to be reported under a separate Payroll Item as it will either be an ETP or a Lump Sum D. Unused AL paid out as part of a genuine redundancy is also categorised differently & reported as Lump Sum A.

    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!)
  • This content has been removed.
  • Liza Oates
    Liza Oates Member Posts: 74 Reckoner Reckoner

    Hi Shaz

    Thank you for your advice appreciate this.

    I know PAYG Employee Summaries now go to MyGOv sites but I wanted to have a printable file which matches what is correct and not very good RECKON is not able to produce this as I believe you cant print reports from STP.

    Kind regards

    Liza

  • Liza Oates
    Liza Oates Member Posts: 74 Reckoner Reckoner

    Hi Shaz

    Further to your advice, I have now creatd finalise year end report to upload to STP.

    Unfortunately my figures in reckon and STP are correct for PAYG Tax but the Gross pays are still not being recorded in the gross pays in STP but the figures are in RECKON Employee Summaries.

    I do not understand why this is the case.

    Can anyone else help

    My gross wages ais $7,911,615.06

    Kind regards

    Liza

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,820 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited June 28

    Hi Liza

    The Gross Pay shown in Reckon's portal for each employee represents the ordinary Gross Payments-mapped Payroll Items only. You need to also ADD to this any amounts showing under the Leave, Overtime, Allowances, Bonuses & Commissions & Directors Fees columns, to match with the Gross totals in RAH. (This is one of the reasons why I recommend using the Payroll Summary - rather than Payroll Totals - report to reconcile against, as it shows the breakdown, including these other types of payments)

    Reckon have advised they are working on developing STP-specific reports but we don't know yet when they will be available 😬

    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!)
  • Liza Oates
    Liza Oates Member Posts: 74 Reckoner Reckoner

    Hi Shaz

    Thank you can you explain how I add ADD to this any amounts showing under the LeaveOvertimeAllowancesBonuses & Commissions & Directors Fees columns I am not sure how I do this to correct this. I export a file in RAH from the single touch payroll which creates a .json file and then I upload this file into STP RECKON portal. Are you saying I can upload an excell or csv file which has this information in as I have over 60+ staff to report on every fortnight

    I have run a payroll summary file before so now how to do this.

    Are you saying you upload the reports then edit the payroll items on an individual basis every time you upload a file into STP Reckon portal.

    Regards

    Liza

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

    No, I just mean if you manually add (eg with a calculator) those additional column amount totals - in the Reckon portal STP screen - to the Gross Pay column amount shown, they should match your customised Payroll Summary 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!)
  • Ann_10524711
    Ann_10524711 Member Posts: 42 Reckoner Reckoner

    Hi Shaz, your advice also helped me with my problem, Thank you.

    Liza - I found with STP, if I right click mouse, it brings up option to print and I am able to print a copy of what I am submitting to STP. Hope this might help you also.

    Ann

  • Liza Oates
    Liza Oates Member Posts: 74 Reckoner Reckoner

    Thank you Ann. Appreciate your help.

    Thank you Shaz I have now submited my STP file. I really appreciate your help and advice and sorry if I was asking silly questions.

    I have one more query can you please help with Novated Lease set up as not sure my version is currenlty set up correctly.

    Thank you.

    Kind regards

    Liza

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

    Hi @Liza Oates

    No question is a silly one here 😊

    I have a guide I've written up on Novated Lease setup & processing in RA/RAH so if you'd like to shoot me an email, I'm happy to send it to you 😊

    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!)