Employee Vacation Tracking Sheet by PrestigeLegalDoc

VIEWS: 767 PAGES: 9

More Info
									                                          GUIDELINES

    GENERAL

    Definition: A vacation tracking spreadsheet is used by managers to track vacation time
    balances for employees during the calendar and/or fiscal year.

    Objective: The purpose of a vacation tracking spreadsheet is to properly document vacation
    time taken for each employee, as well as to keep an updated calculation of remaining unused
    vacation time. Managers utilize this spreadsheet to manage workloads and deadlines according

    The Spreadsheet:
    The spreadsheet contains a yearly vacation tracking schedule. Also included is an employee
    summary and full yearly calendar tab for reference. To see an example of how the spreadsheet

    Procedure to complete the spreadsheet:
    1. On the "Employee Summary" tab, replace the "Employee" entries with the names of
    employees being tracked in the spreadsheet. The names on the spreadsheet will automatically
    2. Beginning vacation balances should be entered in the "Accrued Vacation" column.
    3. On the "Vacation Tracking" tab, enter vacation used (in hours) under the proper month and
    day. The spreadsheet will automatically total used hours for the month in the rightmost column
    and totals will automatically be entered under the "Vacation Used" column on the Employee
    4. You can view the employee summary sheet after vacation time has been entered into the
    vacation tracking spreadsheet to view employee vacation balances.
    5. A full calendar is included in the calendar tab for reference.




© Copyright 2011 Docstoc Inc.
© Copyright 2011 Docstoc Inc.
                                               2012
                  January                       February                        March                NOTES
        Su   M    Tu   W    Th   F    Sa   Su M Tu W       Th   F    Sa   Su M Tu W Th     F    Sa
         1    2    3    4    5   6    7             1       2   3     4                1    2    3
         8    9   10   11   12   13   14    5 6 7 8         9   10   11   4 5 6 7 8         9   10
        15   16   17   18   19   20   21   12 13 14 15     16   17   18   11 12 13 14 15   16   17
        22   23   24   25   26   27   28   19 20 21 22     23   24   25   18 19 20 21 22   23   24
        29   30   31                       26 27 28 29                    25 26 27 28 29   30   31



                   April                          May                            June
        Su   M    Tu   W    Th   F    Sa   Su M Tu    W    Th   F    Sa   Su M Tu W Th F        Sa
         1    2    3    4    5   6    7          1    2     3   4     5                   1      2
         8    9   10   11   12   13   14    6 7 8     9    10   11   12   3 4 5 6 7 8            9
        15   16   17   18   19   20   21   13 14 15   16   17   18   19   10 11 12 13 14 15     16
        22   23   24   25   26   27   28   20 21 22   23   24   25   26   17 18 19 20 21 22     23
        29   30                            27 28 29   30   31             24 25 26 27 28 29     30



                   July                          August                       September
        Su   M    Tu   W    Th   F    Sa   Su M Tu W       Th   F    Sa   Su M Tu W Th F Sa
         1    2    3    4    5   6    7             1       2   3     4                      1
         8    9   10   11   12   13   14    5 6 7 8         9   10   11   2 3 4 5 6 7 8
        15   16   17   18   19   20   21   12 13 14 15     16   17   18   9 10 11 12 13 14 15
        22   23   24   25   26   27   28   19 20 21 22     23   24   25   16 17 18 19 20 21 22
        29   30   31                       26 27 28 29     30   31        23 24 25 26 27 28 29
                                                                          30

                  October                      November                        December
        Su M      Tu   W    Th   F    Sa   Su M Tu W Th         F    Sa   Su M Tu W Th F Sa
            1      2    3    4   5    6                1        2     3                      1
         7 8       9   10   11   12   13    4 5 6 7 8           9    10   2 3 4 5 6 7 8
        14 15     16   17   18   19   20   11 12 13 14 15       16   17   9 10 11 12 13 14 15
        21 22     23   24   25   26   27   18 19 20 21 22       23   24   16 17 18 19 20 21 22
        28 29     30   31                  25 26 27 28 29       30        23 24 25 26 27 28 29
                                                                          30 31



© Copyright 2011 Docstoc Inc.
       2012
                                                                                 January                                                                                             NOTES

                      1    2    3   4   5   6   7   8   9   10   11   12   13   14    15     16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31   Total
                                                                                                                                                                             Hours
  Employee 1                                                                                                                                                                  0.00
  Employee 2                                                                                                                                                                  0.00
  Employee 3                                                                                                                                                                  0.00
  Employee 4                                                                                                                                                                  0.00
  Employee 5                                                                                                                                                                  0.00
  Employee 6                                                                                                                                                                  0.00
  Employee 7                                                                                                                                                                  0.00
  Employee 8                                                                                                                                                                  0.00
  Employee 9                                                                                                                                                                  0.00
  Employee 10                                                                                                                                                                 0.00
  Employee 11                                                                                                                                                                 0.00
  Employee 12                                                                                                                                                                 0.00


                                                                                 February                                                                                            NOTES

                      1    2    3   4   5   6   7   8   9   10   11   12   13   14    15     16   17   18   19   20   21   22   23   24   25   26   27   28   29             Total
                                                                                                                                                                             Hours
  Employee 1                                                                                                                                                                  0.00
  Employee 2                                                                                                                                                                  0.00
  Employee 3                                                                                                                                                                  0.00
  Employee 4                                                                                                                                                                  0.00
  Employee 5                                                                                                                                                                  0.00
  Employee 6                                                                                                                                                                  0.00
  Employee 7                                                                                                                                                                  0.00
  Employee 8                                                                                                                                                                  0.00
  Employee 9                                                                                                                                                                  0.00
  Employee 10                                                                                                                                                                 0.00
  Employee 11                                                                                                                                                                 0.00
  Employee 12                                                                                                                                                                 0.00


                                                                                     March                                                                                           NOTES

                      1    2    3   4   5   6   7   8   9   10   11   12   13   14    15     16   17   18   19   20   21   22   23   24   25   26   27   28   29   30   31   Total
                                                                                                                                                                             Hours
  Employee 1                                                                                                                                                                  0.00
  Employee 2                                                                                                                                                                  0.00
  Employee 3                                                                                                                                                                  0.00
  Employee 4                                                                                                                                                                  0.00
  Employee 5                                                                                                                                                                  0.00
  Employee 6                                                                                                                                                                  0.00
  Employee 7                                                                                                                                                                  0.00
  Employee 8                                                                                                                                                                  0.00
  Employee 9                                                                                                                                                                  0.00
  Employee 10                                                                                                                                                                 0.00
  Employee 11                                                                                                                                                                 0.00
  Employee 12                                                                                                                                                                 0.00


                                                                                     April                                                                                           NOTES

                      1    2    3   4   5   6   7   8   9   10   11   12   13   14    15     16   17   18   19   20   21   22   23   24   25   26   27   28   29   30        Total
                                                                                                                                                                             Hours
  Employee 1                                                                                                                                                                  0.00
  Employee 2                                                                                                                                                                  0.00
  Employee 3                                                                                                                                                                  0.00
  Employee 4                                                                                                                                                                  0.00
  Employee 5                                                                                                                                                                  0.00
  Employee 6                                                                                                                                                                  0.00
  Employee 7                                                                                                                                                                  0.00
  Employee 8                                                                                                                                                                  0.00
  Employee 9                                                                                                                                                                  0.00
  Employee 10                                                                                                                                                                 0.00
  Employee 11                                                                                                                                                                 0.00
  Employee 12                                                                                                                                                                 0.00


                                                                                      May                                                                                            NOTES

                      1    2    3   4   5   6   7   8   9   10   11   12   13   14    15     16   17   18   19   20   21   22   23   
								
To top