Leave liability report and leave accrual summary don't agree

  • 2
  • Problem
  • Updated 3 days ago
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.
Photo of Wendy Phelps

Wendy Phelps

  • 250 Points 250 badge 2x thumb

Posted 1 month ago

  • 2
Hi Wendy

This is likely due to the real-time-display change to leave balances implemented a few years ago.  You should find when you do the next Pay run that the balances on those Pays - & corresponding Payslips - match again.

Note that the "Leave Liability Report" displays in real-time only & can't be configured for an "as at" date, whereas the "Leave Accrual Summary" report can be modified for a specific timeframe.   
Photo of Wendy Phelps

Wendy Phelps

  • 250 Points 250 badge 2x thumb
Hi Shaz

and many thanks for responding to my post.  Unfortunately several pay runs have been processed since the LSL balance was changed in the employee's record however the discrepancy between the 2 reports is still the same.  

Regards

Wendy
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?
Photo of Wendy Phelps

Wendy Phelps

  • 250 Points 250 badge 2x thumb
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.
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.
Photo of Wendy Phelps

Wendy Phelps

  • 250 Points 250 badge 2x thumb
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.
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 ...
(Edited)
Photo of Wendy Phelps

Wendy Phelps

  • 250 Points 250 badge 2x thumb
No Shaz and the hours used this year are correct
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?
Photo of Wendy Phelps

Wendy Phelps

  • 250 Points 250 badge 2x thumb
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.
Photo of Robyn Kelly

Robyn Kelly, Accredited Partner

  • 3,918 Points 3k badge 2x thumb
Does this sound like what your issue is: http://kb.reckon.com.au/issue_view.asp?ID=5623
Regards, Robyn Kelly
Photo of Wendy Phelps

Wendy Phelps

  • 250 Points 250 badge 2x thumb
Yes Robyn this could be the cause of the issues I am currently experiencing so I will try this work around and let you know the outcome.

Many thanks
Photo of Wendy Phelps

Wendy Phelps

  • 250 Points 250 badge 2x thumb
Hi Robyn

Just wanted to let you know that I've now run through the workaround you suggested and this has solved my problem - thank you so much for your assistance - it's greatly appreciated!!

Photo of Robyn Kelly

Robyn Kelly, Accredited Partner

  • 3,898 Points 3k badge 2x thumb
Great work Wendy, long process but at least it does get resolved.
Regards, Robyn Kelly