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