Example of 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