Leave Liability Report vs Leave Accrual Summary

  • 1
  • Question
  • Updated 2 months ago
I am currently using the latest version of Reckon Accounts Hosted.  In June this year one of our casual staff members became full time permanent.  During her first week full time she had a couple of days of sick - or so I was advised.  After the end of the financial year, I found out that the number of hours she had taken off were less than I was advised.  So, foolishly, I went back and changed her paycheque to show more hours worked and less hours personal leave. After the next payrun this employee advised that the number of personal hours owed to her was incorrect.  They were vastly overstated to the negative. After seeking Reckon assistance, I have tried deleting and re-entering each line item in the following pays that have personal leave. I don't think this has worked. Reckon advised that the Leave Liabililty Report shows the correct number of hours and I should just provide her with this. Her payslip DOES NOT agree with this report.  Her payslip DOES however agree with the Leave Accrual Summary Report.  So, which report is correct? Why would there be a difference in these two reports? Is her payslip correct?
Photo of Carolyn

Carolyn

  • 130 Points 100 badge 2x thumb
  • frustrated

Posted 3 months ago

  • 1
Photo of Linda Putland

Linda Putland, Accredited Partner

  • 6,632 Points 5k badge 2x thumb
This can be tricky Carolyn... are you able to bring up the Leave Accrual Summary and then zoom in on her name and then show all dates - then you can see pay by pay how it has accrued and been used... you may find where its gone wrong by looking at this....  that may then help to work out where to start trying to fix this... remember that you wont be able to recreate the payslip with the leave as it was on that particular pay date - but what you want is to have the correct leave on the last pay date...so its correct going forward...
Photo of Carolyn

Carolyn

  • 130 Points 100 badge 2x thumb
Hi Linda. The payslip agrees with the Leave Accrual Summary but not with the Leave Liability Report and since I can't pick a date on that report I can't really see when the problem started.
Hi Carolyn

The Leave Liability Report is in real time which is why you can't select a date range whereas the Leave Accrual Summary allows you to view Leave balances as at a specific point in time. 

With this in mind, have you processed Pays to be "paid" this week?  This will affect your real-time Liability report.
Photo of Carolyn

Carolyn

  • 130 Points 100 badge 2x thumb
Hi Shaz.  No I have not processed any pays to be "paid" this week.  I only ever process pays when I am actually paying them.
Sorry Carolyn - It's a valid question as some people set it up in their online banking for say, the next day & process that Pay Run post-dated.

Also, check that you have Sick Leave carrying forward (Make sure the "Reset hours each new year?" checkbox is NOT ticked) in the employee's record.
(Edit Employee, then on "Payroll and Compensation Info" tab > "Leave Details"

As a last resort, you could delete this employee's Pays back to the starting point of going permanent FT - which will remove the leave accruals since - then re-do them.
TIP: Make sure you have the correct Pay info for every Pay handy first so the re-entry doesn't change any final totals!  (Print each Pay Slip before deleting the Pay)
(Edited)
Photo of Carolyn

Carolyn

  • 130 Points 100 badge 2x thumb
Hi Shaz.  Sorry for the late response but I don't work here every day and with the end of month it has been hectic. Also, didn't mean to sound short re the pays - just meant to say we keep it pretty simple.
Sick leave is fine - I double checked the reset hours box anyway though.
I think I will have to take your advice and re-enter all her pays - thanks for the idea to print the pay slips first, I thought I was going to have to write down the info for each week.  One reason I haven't wanted to do this previously was because I didn't know how it would affect my bank recs.
No worries Carolyn :)

Whilst deletion & re-entry of the Pays will mean re-reconciling the bank account .....
... IF you have a 'clean' & up-to-date file - by which I mean no old, unreconciled transactions - you already know it reconciles, so should be able to tick the "Hide transactions after the Statement's end date" checkbox & click on "Mark all" to re-reconcile each Statement very quickly :)