How to calculate number of weeks worked/paid for Long Service Leave.

I have an employee retiring at 31st December after 7 years. Their set work hours have changed over this time.

However they have had several periods where they have taken unpaid leave, for various personal reasons.

Is there a report that can be run to show the number of weeks worked during their time with us, so I can work their average weekly hours. Or do I do this manually?

Accepted answers

All comments

Kris_Williams

I would do a report (Payroll Summary) and select all dates, or at least since he started till now that shows the number of hours he has worked as normal hours , no leave hours. Then multiply the hours by .0769 - which represents 4 weeks annual leave. I am assuming you are trying to calculate leave.

I see you are wanting LSL so simply dividing those hours by 38 would equal weeks worked.
There may be others ways to get this figure but that is how I would do it

Reeta

Hi @NevilleSteicke_10864379 ,

I've attached an article that provides a detailed explanation of long service leave.

I hope this resource is helpful in clarifying any questions or uncertainties you might have regarding long service leave.

https://help.reckon.com/article/thkakv6qbs-kba-4842-processing-long-service-leave-in-reckon-accounts

Please let me know if you need further information or assistance!!

Kind regards,

Reeta

NevilleSteicke_10864379

Thanks for the info, will do some reading. Very much appreciated.

Zappy

Long service leave is calculated as 1/60 or 0.016666 of normal hours as per the NES

Zappy

NevilleSteicke_10864379

Yep got sorted.

Did Payroll Summary, modified report to report on the employee only. This gave me the total of hours they had worked since beginning with us, that are required for calculating LSL in WA.

As they had changed their work hours, a couple of times, and had several unpaid times off work that is not continuous work and not 38 hour weeks, I needed to work out the number of actual pay periods they had worked. This was so I could average the hours worked for the entire time employed. The was achieved by modifying a Statement of Payments, under Employee Reports, to the single employee. This showed each payment made to the employee. This was downloaded as an Xcel spreadsheet to show each pay period and therefore the number of payments made.

Just had to find the reports to us.

Kris_Williams

Congratulations glad you sorted it out

Acctd4

Good to hear @NevilleSteicke_10864379 👏🏻

Just be aware that leave hours paid are also included in calculating entitlement 😁

This scenario is one of the reasons why I set up not just PL & AL, but also LSL in the default Payroll Preferences (Also, always accrued as “Every Hour” - This ensures accurate calculation if/when hours change during employment & eliminates this manual work now required, to determine entitlement! ☺️)

NevilleSteicke_10864379

Thanks Shaz, makes perfect sense to do it this way. Appreciate the advise.

Reckon Accounts Hosted Announcements & Important Info

Don't miss announcements and important info for Reckon Accounts Hosted

Button

Reckon Accounts Hosted Ideas & Feature Requests 💡

Do you have an idea for a feature in Reckon Accounts Hosted? Let us know here!

Button