Leave liability report and leave accrual summary don't agree

[Deleted User]
[Deleted User] Posts: 0 Novice Member Novice Member
edited October 2024 in Accounts Hosted
I needed to manually adjust an employee's LSL balance as an error had been made - the accrual screen in the employee's record and the leave liability report both show the correct entitlement balance however both the leave accrual summary report and the employee's payslip record both reflect a 'bizarre" negative value.  Can anyone explain this discrepancy?  I'm using the Hosted version of Reckon.

Comments

  • Acctd4
    Acctd4 Accredited Partner Posts: 3,830 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited September 2019

    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!)
  • [Deleted User]
    [Deleted User] Posts: 0 Novice Member Novice Member
    edited September 2019
  • Acctd4
    Acctd4 Accredited Partner Posts: 3,830 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited November 2018
    Hi Wendy

    Make sure you have the "Leave Accrual Summary" set to "This Payroll Year-to-date" when comparing ...
    Are they still different?  Can you identify what the difference is?

    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!)
  • [Deleted User]
    [Deleted User] Posts: 0 Novice Member Novice Member
    edited November 2018
    Yes the leave accrual summary is set to 'this payroll year-to-date' but the reports still differ - the accrual summary report is (396) hours whereas the leave liability report is 188 hours (which is correct) - I only reduced the LSL balance in the employee record by 104 hours so the discrepancy is quite bizarre.
  • Acctd4
    Acctd4 Accredited Partner Posts: 3,830 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited November 2018
    That's very interesting because that difference is exactly double ...

    You can drill down on the "396" hours figure in that Leave Accrual Summary & view each pay's leave accruals/balance.
    Have a look at that & see if that sheds a bit more light on what's happened.

    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!)
  • [Deleted User]
    [Deleted User] Posts: 0 Novice Member Novice Member
    edited November 2018
    Drilling down shows me the change in the entitlement across two pay slip - the first being the LSL entitlement before I made the change in the employee record (ie 292 hours) and the second showing the incorrect entitlement of (396) hours after I amended the balance in the employee record but no other information Shaz.  Agree the discrepancy between the 2 reports is strange as it's twice the 292 hours that were accrued before I reduced the balance to 188 hours.
  • Acctd4
    Acctd4 Accredited Partner Posts: 3,830 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited November 2018
    Hmmm .... When you amended the balance, you didn't also amend the "Hours used this year" as well did you?

    I had to do a LSL balance adjustment back last year across all employees for one business & didn't have any problems with the balances not matching afterwards ...

    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!)
  • [Deleted User]
    [Deleted User] Posts: 0 Novice Member Novice Member
    edited November 2018
    No Shaz and the hours used this year are correct
  • Acctd4
    Acctd4 Accredited Partner Posts: 3,830 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert
    edited November 2018
    Without seeing it all, it's hard to pinpoint what's causing it ....

    Do the Pay v Payslip balances match on the last current pay run?
    If not, is the discrepancy exactly the same leave type/qty as you stated above?

    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!)
  • [Deleted User]
    [Deleted User] Posts: 0 Novice Member Novice Member
    edited November 2018
    Do you mean the payslip and leave accrual summary report Shaz? - these are both showing (396) hours and the leave liability report shows 188 hours.
  • Robyn Kelly (Partner)
    Robyn Kelly (Partner) Accredited Partner Posts: 498 Accredited Partner Accredited Partner
    edited September 2019
  • [Deleted User]
    [Deleted User] Posts: 0 Novice Member Novice Member
    edited November 2018
  • [Deleted User]
    [Deleted User] Posts: 0 Novice Member Novice Member
    edited September 2019
  • Robyn Kelly (Partner)
    Robyn Kelly (Partner) Accredited Partner Posts: 498 Accredited Partner Accredited Partner
    edited December 2018
    Great work Wendy, long process but at least it does get resolved.
    Regards, Robyn Kelly
This discussion has been closed.