+ Reply to Thread
Results 1 to 3 of 3

employee vacation accrual and tracking template

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    employee vacation accrual and tracking template

    I'm looking for a vacation spreadsheet that tracks vacation has a column that lists the carryover and the yearly accrual. Ive seen several that list all employees but I am looking for one that is by employee. Where you can list the dates and it totals the days and links back to current available and deducts the days. I saw one online for purchase I like but was not able to download.

    I'm not excel savvy enough to make myself...Anyone have one similiar to this?vacation-accrual_weekly.gif

  2. #2
    Valued Forum Contributor
    Join Date
    Eastbourne, England
    MS-Off Ver
    Excel 2010

    Re: employee vacation accrual and tracking template

    Hi Lundberg99

    I have just written the attached. It works on the principle that you fill in the details of the employees for each pay period, together with any time that they have taken and it will post everything on to their own sheet. You can then set up a sheet for the next pay period.

    Is this the sort of thing that you were looking for?

    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    Valrico, FL USA
    MS-Off Ver
    Excel 2016

    Re: employee vacation accrual and tracking template

    Try downloading Attendance History 2012.xlsm from the site below:
    HTML Code: 

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Vacation accrual tracking
    By nettexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-22-2014, 03:42 PM
  2. Replies: 3
    Last Post: 10-16-2013, 09:05 PM
  3. Course template for tracking employee training
    By C Holmes in forum Access Tables & Databases
    Replies: 1
    Last Post: 10-28-2010, 09:35 AM
  4. Vacation accrual and tracking
    By pwinters in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-20-2010, 03:14 PM
  5. [SOLVED] Template for Managing accts while employee is on vacation
    By Bill Hendrick in forum Excel General
    Replies: 0
    Last Post: 01-06-2006, 12:10 PM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1