Examples for business, study, careers, love, and more...
Examples :: Excel Templates :: Example of Vacation Tracking

Example of Vacation Tracking


Vacation Tracking


Company Name
Department
Employee Name _____________________
Employment Start Date 05/12/2010____________
Pay Period 2 Week Period


Employee Vacation Details
Sick Personal Vacation
Hours Available per Year 40 40 80
Maximum Hours Available 50.000 60.000 80.000
Hours Accrued per Pay Period 1.538 1.538 3.077
Rate Accrued per Pay Period 1 1 1
Accrual Start 1 1 1


Vacation Time Earned Vacation Time Used Accumulated Time
Payment Period Sick Personal Vacation Sick Vacation Personal Sick Personal Vacation
0 Starting Amounts 0 0 40
1 5/12/10-5/25/10 1.538 1.5384615 3.077 1.538 1.538 43.077
2 5/26/10-6/08/10 1.538 1.5384615 3.0769231 3.077 3.077 46.154
3 6/09/10-6/22/10 1.538 1.5384615 3.0769231 4.615 4.615 49.231
4 6/23/10-7/06/10 1.538 1.5384615 3.0769231 6.154 6.154 52.308
5 7/07/10-7/20/10 1.538 1.5384615 3.0769231 7.692 7.692 55.385
6 7/21/10-8/03/10 1.538 1.5384615 3.0769231 9.231 9.231 58.462
7 8/04/10-8/17/10 1.538 1.5384615 3.0769231 10.769 10.769 61.538
8 8/18/10-8/31/10 1.538 1.5384615 3.0769231 12.308 12.308 64.615
9 9/01/10-9/14/10 1.538 1.5384615 3.0769231 13.846 13.846 67.692
10 9/15/10-9/28/10 1.538 1.5384615 3.0769231 15.385 15.385 70.769
11 9/29/10-10/12/10 1.538 1.5384615 3.0769231 16.923 16.923 73.846
12 10/13/10-10/26/10 1.538 1.5384615 3.0769231 18.462 18.462 76.923
13 10/27/10-11/09/10 1.538 1.5384615 3.0769231 20.000 20.000 80.000
14 11/10/10-11/23/10 1.538 1.5384615 0 21.538 21.538 80.000
15 11/24/10-12/07/10 1.538 1.5384615 0 23.077 23.077 80.000
16 12/08/10-12/21/10 1.538 1.5384615 0 24.615 24.615 80.000
17 12/22/10-1/04/11 1.538 1.5384615 0 26.154 26.154 80.000
18 1/05/11-1/18/11 1.538 1.5384615 0 27.692 27.692 80.000
19 1/19/11-2/01/11 1.538 1.5384615 0 29.231 29.231 80.000
20 2/02/11-2/15/11 1.538 1.5384615 0 30.769 30.769 80.000
21 2/16/11-3/01/11 1.538 1.5384615 0 32.308 32.308 80.000
22 3/02/11-3/15/11 1.538 1.5384615 0 33.846 33.846 80.000
23 3/16/11-3/29/11 1.538 1.5384615 0 35.385 35.385 80.000
24 3/30/11-4/12/11 1.538 1.5384615 0 36.923 36.923 80.000
25 4/13/11-4/26/11 1.538 1.5384615 0 38.462 38.462 80.000
26 4/27/11-5/10/11 1.538 1.5384615 0 40.000 40.000 80.000
27 5/11/11-5/24/11 1.538 1.5384615 0 41.538 41.538 80.000
28 5/25/11-6/07/11 1.538 1.5384615 0 43.077 43.077 80.000
29 6/08/11-6/21/11 1.538 1.5384615 0 44.615 44.615 80.000
30 6/22/11-7/05/11 1.538 1.5384615 0 46.154 46.154 80.000
31 7/06/11-7/19/11 1.538 1.5384615 0 47.692 47.692 80.000
32 7/20/11-8/02/11 1.538 1.5384615 0 49.231 49.231 80.000
33 8/03/11-8/16/11 0.769 1.5384615 0 50.000 50.769 80.000
34 8/17/11-8/30/11 0.000 1.5384615 0 50.000 52.308 80.000
35 8/31/11-9/13/11 0.000 1.5384615 0 50.000 53.846 80.000
36 9/14/11-9/27/11 0.000 1.5384615 0 50.000 55.385 80.000
37 9/28/11-10/11/11 0.000 1.5384615 0 50.000 56.923 80.000
38 10/12/11-10/25/11 0.000 1.5384615 0 50.000 58.462 80.000
39 10/26/11-11/08/11 0.000 1.5384615 0 50.000 60.000 80.000
40 11/09/11-11/22/11 0.000 0 0 50.000 60.000 80.000
41 11/23/11-12/06/11 0.000 0 0 50.000 60.000 80.000
42 12/07/11-12/20/11 0.000 0 0 50.000 60.000 80.000
43 12/21/11-1/03/12 0.000 0 0 50.000 60.000 80.000
44 1/04/12-1/17/12 0.000 0 0 50.000 60.000 80.000
45 1/18/12-1/31/12 0.000 0 0 50.000 60.000 80.000
46 2/01/12-2/14/12 0.000 0 0 50.000 60.000 80.000
47 2/15/12-2/28/12 0.000 0 0 50.000 60.000 80.000
48 2/29/12-3/13/12 0.000 0 0 50.000 60.000 80.000
49 3/14/12-3/27/12 0.000 0 0 50.000 60.000 80.000
50 3/28/12-4/10/12 0.000 0 0 50.000 60.000 80.000
51 4/11/12-4/24/12 0.000 0 0 50.000 60.000 80.000
52 4/25/12-5/08/12 0.000 0 0 50.000 60.000 80.000
50.000 60.000 80.000


Notes on Vacation Tracking Example

To use this Vacation Tracking template, fill in Start Date, Pay Period and Employee Vacation Details chart.
As Vacation time is used, fill in the amounts for each Payment Period.

Disclaimer: Examplesof.com makes every effort to ensure the functional integrity of all downloadable materials posted on the site. The information, methodologies and processes contained in these materials are provided according to built-in software and formulas. We are unable to guarantee that these materials will necessarily be suitable for individual purposes. We are unable to guarantee that these materials will necessarily be free of functional issues which may affect their performance. Important: These materials are offered for purchase and use in good faith in "as is" condition. Full disclaimer is here disclaimer

Limited Use Policy : These templates provided by ExamplesOf.com, may be downloaded and customized for your personal or company use only. You may download copies, make archival copies and customize the template to be distributed and used within your company. This template or any document produced from this template may NOT be sold, redistributed, or uploaded to the internet for distribution.EULA

Download Excel Version of Vacation Tracking Example
Download Example Vacation Tracking Template