Question

Locked

Excel timesheet to calculate accreud vacation, personal time, sick time

By rallison ·
Hello,
We are a nonprofit with 7 staff and limited tech savviness. I have seen various threads about accruals of vacation days etc. Does anyone have a spreadsheet they'd kindly share, with such calculations (I could hopefully modify formulae to meet our requirements which are all hire date based, with different accrual rates depending on years of service. There is a carryover limitation. Sick days also have their own accrual rate and a carryover limitation. Personal days have a different accrual rate and no carryover.
Thanks so much.
Roslyn

This conversation is currently closed to new comments.

20 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Make it part of payroll processing

by bschaettle In reply to Excel timesheet to calcul ...

Roslyn,

Do you contract out your payroll processing? If so, ask them what it would cost to add vacation / time off tracking. I work for a non-profit, albeit much larger than yours, and that's how it's done here.

Since this is a compensation issue, and you've already said the staff has limited tech saviness, I'm very reluctant to endorse a spreadsheet solution for you -- it could very easily get messed up and cheat people out of vacation time that they are due.

--Bob

Collapse -

Part of Payroll Processing

by rallison In reply to Make it part of payroll p ...

Thank you, Bob, that's a good idea. I will pursue that with our payroll processor It'll do the trick provided it's VERY cheap.
Ros

Collapse -

Edited by moderator

by luket In reply to Excel timesheet to calcul ...

Edited by moderator

Message was edited by: beth.blakely@...

Collapse -

Edited by moderator

by HAL 90000 In reply to Excel timesheet to calcul ...

Edited by moderator

Message was edited by: beth.blakely@...

Collapse -

I'm surprised you can reach a keyboard

by HAL 9000 Moderator In reply to Edited by moderator
Collapse -

Time off tracking tool

by m.reynolds.sr In reply to Excel timesheet to calcul ...

Here is a tracking tool I put together for my managers to track each of their team members acrual of paid time off. There are three tabs, MSE is the general time off package; PFE is for tracking hours for people who do not get any paid time off, the On-Site Associate sheet takes into account date of hire to provide additional hours for each additional year of service.

I am not sure how I upload my spreadsheet to share?

Collapse -

Spreadhseet

by rallison In reply to Time off tracking tool

Thank you. I can't think of a practical solution at this stage of getting the spreadsheet.

Collapse -

Email me and I will send you the spreadsheet

by m.reynolds.sr In reply to Spreadhseet
Collapse -

Time off Tracking Tool

by debrap In reply to Time off tracking tool

Do you still have the excel spreadsheet to track paid time off?

Thank you.

Collapse -

Possible solution...

by marj In reply to Excel timesheet to calcul ...

I have a spreadsheet that may serve your purpose, since you have a small staff
It involves one spreadsheet per employee, however, you could modify it to suit your purposes
I'm not sure, however, how to send it to you

Back to Software Forum
20 total posts (Page 1 of 2)   01 | 02   Next

Software Forums