holiday entitlement

[Allen0805]

hi everyone,

Does any have or know where i can get a holiday entitlement spreadsheet to work out how much is accrued and how much is owed.

Thanks

 

[Employment Law Clinic]

This will depend on the employment contract, and I don't know of any that covers all possible circumstances, so can't help except to remind you to check that any you do obtain meets the Working Time Regulations.




Karl Limpert

 

[KM-Tiger]

It's not particularly hard to do your own. I remember doing one when I employed people. We ran holiday on an accrual basis and it worked really rather well.

A template tab, and then a tab for each employee. Enter an 'x' for each month worked and the days taken, and the spreadsheet adjusted the totals. We printed the summary for each employee monthly, so they knew days accrued, days taken and the balance.

I *might* be able to dig into archives and find it if you are stuck.

 

I don't know if this will help you at all?

Calculate your employees holiday pay

Kind regards

Zöe

 

[gouldie0]

You can also use this: http://www.direct.gov.uk/en/Employment/Employees/Timeoffandholidays/DG_184563

I have a spreadsheet that works on an accrual basis but it would need to be amended to your own holiday structure etc.

Send me a wee PM with your email address and I'll see if I can dig it out.

Kind Regards

Neil

 

[pcross]

you might be interest in our online staff leave planner at WhosOff.com to help administer and manage staff leave and absence.

 

[Tom McClelland]

12Pay can calculate accrued holiday hours for variably entitled workers, based on hours worked @12.1% or any higher rate that you enter. It can also calculate the rate at which to pay those hours when taken, based on a weighted average of the last 12 weeks payments.

12Pay can also calculate accrued holidays for salaried staff who have a fixed annual entitlement (eg 28 days) where you enter the holidays that they've taken and as long as they don't exceed their entitlement they get paid their normal salary regardless.