Question Locked

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

0 helpful
20 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

20 replies

by bschaettle

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

by rallison

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

by luket

Edited by moderator

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

by hal 90000

Edited by moderator

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

by m.reynolds.sr

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?

by rallison

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

by debrap

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

Thank you.

by Member 22209540

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

by kaptandrews

Microsoft has been kind enough to provided form basic templates that may suit you needs. here are a couple of links. I have used a couple of them in the past (i.e. Access database to track my trouble ticket time). Had to tweak it a bit but it served the purpose. Make sure you chosse the correct Office verison. Good Luck!

http://office.microsoft.com/en-us/templates/results.aspx?qu=access+2003%2C+time+tracking&av=TPL000

http://office.microsoft.com/en-us/templates/CT101172771033.aspx

by rallison

Thank you.
Perhaps you could email specifics of your company to rallison@metrointl.org
Pls don't send spreadsheet at this stage.
R

by jeffrey.bollman

Roslyn,
Please contact me via email: jbollman at neo.ne.gov.

I will be glad to forward a copy of our current weekly timesheet workbook. It includes 52 sheets, 1 for each week of the year, grouped into 26 bi-weekly pay periods.

Jeffrey

by orregoa

Jeffrey,

I would appreciate a sample copy of your xls if possible.

by pianoguy9

Hi, I have one that I developed and is used by others at my company. It doesn't track sick time (we're salaried and that's not necesssary), but it could be modified to do so. Email me at pianoguy"at"mailforce.net.

Timothy

by drmaves

Hi Roslyn,

I'm wondering if you ever found a solution to tracking PTO. If so, would your mind sharing your solution?

I would greatly appreciate it.

Thanks,

D. Roger Maves
drmaves@tkgi.com

by tracy alam

Hello,

I have been asked to adjust our vacation accrual method from Calendar Year to Anniversary Year. Our employees currently accrue one (1)vacation day per month up to 10 days per year for the first two years of employment.

On the employees second year anniversary, they begin to accrue (1.5) vacation days per month up to 15 days per year.

The challenge is how to calculate the change during the year rather than at the end, since we do not match two months out of the year.

I tried the 2 formulas below, but would like to know if I am on the right track and which is the preferred method or if not, can someone recommend a more common method.

Formula 1:
-10 days/12 months = .8333 vacation days per month for the first two years of employment
-15 days/12 months = 1.25 vacation days per month a 2nd anniversary
Therefore an employee with a 3/1 anniversary date would be calculated .8333 x 2 = 1.67 days and 1.25 x 10 = 12.5 for a total of 14.17 days during that year.

Formula 2:
Vacation days accrued per month prior to an anniversary adjustment, plus vacation days accrued per month after an anniversary adjustment, less the last 2 months of the year.
(ie: an employee with a 3/1 anniversary date.
-1 vac day x 2 mths = 2 accrued vac days
-1.5 vac days x 8 mths = 12 accrued vac days
For a total of 14 vacation days)

I would appreciate guidance and if available in an Excel spreadsheet that would greatly appreciated as well.

Thank you!

by tobif

Dear Tracy,

Much better to start a new question thread:
Just hit the "Ask a question" button and then paste your question there!

This discussion is closed to new replies.