+ 0 Votes Make it part of payroll processing bschaettle 7 years ago 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 + 0 Votes Zombie alert - start a new question instead! TobiF 3 years ago Dear Tracy, Much better to start a new question thread: Just hit the "Ask a question" button and then paste your question there! + 0 Votes Edited by moderator luket Updated - 7 years ago Edited by moderator Message was edited by: beth.blakely@... + 0 Votes Edited by moderator HAL 90000 Updated - 7 years ago Edited by moderator Message was edited by: beth.blakely@... + 0 Votes Time off tracking tool m.reynolds.sr Updated - 7 years ago 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? + 0 Votes Possible solution... marj 7 years ago 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 + 0 Votes I'll be glad to share our current excel-based timesheet jeffrey.bollman 7 years ago 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 + 0 Votes Have another one you can try pianoguy 7 years ago 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 + 0 Votes Did you find a solution? drmaves 4 years ago 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 firstname.lastname@example.org + 0 Votes Excel timesheet to calculate accreud vacation tracy alam 3 years ago 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!