Spreadsheet instructions:
Use the sheet that applies to how your employee accures vacation. In the top cell enter any balance that was carried over from Employee Name For Calendar Year Starting: Jan-2007
Hire Date Override Annual Vacation
80
VACATION Jan-1899 Feb-1899 Mar-1899 Apr-1899 May-1899 Jun-1899 Jul-1899 Aug-1899 Sep-1899 Starting Bal. 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1 Holiday Sun Sun Sat
SICK Jan-99 Starting Bal. 0.00 1 Holiday
Feb-99 0.00
Mar-99 0.00
Apr-99 0.00 Sun
May-99 0.00
Jun-99 0.00
Jul-99 0.00 Sun
Aug-99 0.00
Sep-99 0.00 Sat
If your employee uses a vacation day you enter -8 in the date that they took for example if they took off January 2nd you would VACATION Jan-1899 Feb-1899 Mar-1899 Apr-1899 May-1899 Jun-1899 Jul-1899 Aug-1899 Sep-1899 Starting Bal. 24.00 22.68 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1 Holiday Sun Sun Sat 2 -8.00 Sat Sun 3 Sat Sat Sun Holiday 4 Sun Sun Holiday Sat 5 Sat Sun 6 Sat Personal Sun
If you are using the personal day for vacation and you just want to keep track of it but not deduct any hours from the total you c The sick time is used the same way.
You can copy the worksheet tabs attached to this and use the correct one for each employee you have. If you have any quest Annette
e that was carried over from the previous year for both Vacation and for sick time
Oct-1899 Nov-1899 Dec-1899 0.00 0.00 0.00 Sat
Oct-99 0.00
Nov-99 0.00
Dec-99 0.00 Sat
off January 2nd you would put in -8 in the following cell and it will deduct 8 hours from their balance. Oct-1899 Nov-1899 Dec-1899 0.00 0.00 0.00 Sat Sun Sat Sun Sat
y hours from the total you can write in the cell personal
ave. If you have any questions please feel free to ask me.
Name Hire Date Override Annual Vacation
For Calendar Year Starting: Jan-2009
120
VACATION Starting Bal. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Accrual 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Accrual Ending Bal.
Jan-2009 0.00 Holiday
SICK Starting Bal. 1 2 3 4 5 6
Feb-2009 6.68 Sun
Mar-2009 13.36 Sun
Jul-2009 40.08
Holiday Sat Sun
Sat Sun Sat Sun
Sat Sun
Sat Sun Sat Sun
Sat Sun
Sat Sun Sat Sun 3.34 Holiday
Sat Sun 3.34
Sat Sun Holiday
Sat Sun Sat Sun
3.34
3.34 Sat Sun
3.34
Sat Sun Sat Sun
Sat Sun
Sat Sun
Sat 3.34 6.68
Sat na na na 3.34 13.36
3.34 20.04
Jan-09 0.00 Holiday
Feb-09 3.34 Sun
Mar-09 6.68 Sun
3.34
Sat Sun
Sat Sun
Sat Sun
Sat Sun
May-2009 Jun-2009 26.72 33.40 Sat Sun
Sat Sun
3.34
Apr-2009 20.04
Sat Sun Holiday
Sat Sun Sat Sun
Sat Sun na 3.34 26.72
Sat Sun 3.34 33.40
na 3.34 40.08
3.34 46.76
Apr-09 10.02
May-09 13.36
Jun-09 16.70
Jul-09 20.04
Sat Sun
Holiday Sat Sun
Sat Sun Sat
7 8 9 10 11 12 13 14 15 Accrual 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Accrual Ending Bal.
Sat Sun
Sat Sun Sat Sun
Sat Sun
1.67
Sat Sun Sat Sun 1.67 Holiday
Sat Sun 1.67
Sat Sun Holiday
Sat Sun Sat Sun
1.67
1.67 Sat Sun
1.67
Sat Sun Sat Sun
Sat Sun
Sat Sun Sat na na na 1.67 6.68
Sat Sun Holiday
Sat Sun Sat Sun
Sat Sun
1.67 10.02
1.67
Sat Sun
Sat Sun
Sat Sun
Sat 1.67 3.34
Sun
na 1.67 13.36
Sat Sun 1.67 16.70
na 1.67 20.04
1.67 23.38
Aug-2009 46.76 Sat Sun
Sep-2009 53.44
Oct-2009 60.12
Nov-2009 66.80 Sun
Dec-2009 73.48
Sat Sun Sat Sun
Sat Sun
Holiday Sat Sun
Sat Sun Sat Sun Sat Sun
Sat 3.34 Sun
3.34
Sat Sun
3.34
Sat Sun 3.34
3.34
Sat Sun Sat Sun
Sat Sun Sat Sun
Sat Sun Sat Sun Sat Sun
Holiday Holiday Sat Sun
Sat Sun 3.34 53.44 Aug-09 23.38 Sat Sun
na 3.34 60.12
Sat 3.34 66.80
na 3.34 73.48
Sep-09 26.72
Oct-09 30.06
Nov-09 33.40 Sun
Holiday Sat Sun
3.34 80.16 Dec-09 36.74
Sat Sun Sat Sun
Sat Sun
Holiday Sat Sun
Sat Sun Sat Sun Sat Sun
Sat 1.67 Sun
1.67
Sat Sun
1.67
Sat Sun 1.67
1.67
Sat Sun Sat Sun
Sat Sun Sat Sun
Sat Sun Sat Sun Sat Sun
Holiday Holiday Sat Sun
Sat Sun 1.67 26.72
na 1.67 30.06
Sat 1.67 33.40
na 1.67 36.74
Holiday Sat Sun
1.67 40.08
Name Hire Date Override Annual Vacation
For Calendar Year Starting: Jan-2009
120
VACATION Starting Bal. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Accrual 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Accrual Ending Bal.
Jan-2009 0.00 Holiday
SICK Starting Bal. 1 2 3 4 5 6
Feb-2009 10.00 Sun
Mar-2009 20.00 Sun
Jul-2009 60.00
Holiday Sat Sun
Sat Sun Sat Sun
Sat Sun
Sat Sun Sat Sun
Sat Sun
Sat Sun Sat Sun 5.00 Holiday
Sat Sun 5.00
Sat Sun Holiday
Sat Sun Sat Sun
5.00
5.00 Sat Sun
5.00
Sat Sun Sat Sun
Sat Sun
Sat Sun
Sat 5.00 10.00
Sat na na na 5.00 20.00
5.00 30.00
Jan-09 0.00 Holiday
Feb-09 3.34 Sun
Mar-09 6.68 Sun
5.00
Sat Sun
Sat Sun
Sat Sun
Sat Sun
May-2009 Jun-2009 40.00 50.00 Sat Sun
Sat Sun
5.00
Apr-2009 30.00
Sat Sun Holiday
Sat Sun Sat Sun
Sat Sun na 5.00 40.00
Sat Sun 5.00 50.00
na 5.00 60.00
5.00 70.00
Apr-09 10.02
May-09 13.36
Jun-09 16.70
Jul-09 20.04
Sat Sun
Holiday Sat Sun
Sat Sun Sat
7 8 9 10 11 12 13 14 15 Accrual 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Accrual Ending Bal.
Sat Sun
Sat Sun Sat Sun
Sat Sun
1.67
Sat Sun Sat Sun 1.67 Holiday
Sat Sun 1.67
Sat Sun Holiday
Sat Sun Sat Sun
1.67
1.67 Sat Sun
1.67
Sat Sun Sat Sun
Sat Sun
Sat Sun Sat na na na 1.67 6.68
Sat Sun Holiday
Sat Sun Sat Sun
Sat Sun
1.67 10.02
1.67
Sat Sun
Sat Sun
Sat Sun
Sat 1.67 3.34
Sun
na 1.67 13.36
Sat Sun 1.67 16.70
na 1.67 20.04
1.67 23.38
Aug-2009 70.00 Sat Sun
Sep-2009 80.00
Oct-2009 90.00
Nov-2009 100.00 Sun
Dec-2009 110.00
Sat Sun Sat Sun
Sat Sun
Holiday Sat Sun
Sat Sun Sat Sun Sat Sun
Sat 5.00 Sun
5.00
Sat Sun
5.00
Sat Sun 5.00
5.00
Sat Sun Sat Sun
Sat Sun Sat Sun
Sat Sun Sat Sun Sat Sun
Holiday Holiday Sat Sun
Sat Sun 5.00 80.00 Aug-09 23.38 Sat Sun
na 5.00 90.00
Sat 5.00 100.00
na 5.00 110.00
Sep-09 26.72
Oct-09 30.06
Nov-09 33.40 Sun
Holiday Sat Sun
5.00 120.00 Dec-09 36.74
Sat Sun Sat Sun
Sat Sun
Holiday Sat Sun
Sat Sun Sat Sun Sat Sun
Sat 1.67 Sun
1.67
Sat Sun
1.67
Sat Sun 1.67
1.67
Sat Sun Sat Sun
Sat Sun Sat Sun
Sat Sun Sat Sun Sat Sun
Holiday Holiday Sat Sun
Sat Sun 1.67 26.72
na 1.67 30.06
Sat 1.67 33.40
na 1.67 36.74
Holiday Sat Sun
1.67 40.08
Name Hire Date Override Annual Vacation
For Calendar Year Starting: Jan-2009
120
VACATION Starting Bal. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Accrual 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Accrual Ending Bal.
Jan-2009 0.00 Holiday
SICK Starting Bal. 1 2 3 4 5 6
Feb-2009 13.34 Sun
Mar-2009 26.68 Sun
Jul-2009 80.04
Holiday Sat Sun
Sat Sun Sat Sun
Sat Sun
Sat Sun Sat Sun
Sat Sun
Sat Sun Sat Sun 6.67 Holiday
Sat Sun 6.67
Sat Sun Holiday
Sat Sun Sat Sun
6.67
6.67 Sat Sun
6.67
Sat Sun Sat Sun
Sat Sun
Sat Sun
Sat 6.67 13.34
Sat na na na 6.67 26.68
6.67 40.02
Jan-09 0.00 Holiday
Feb-09 3.34 Sun
Mar-09 6.68 Sun
6.67
Sat Sun
Sat Sun
Sat Sun
Sat Sun
May-2009 Jun-2009 53.36 66.70 Sat Sun
Sat Sun
6.67
Apr-2009 40.02
Sat Sun Holiday
Sat Sun Sat Sun
Sat Sun na 6.67 53.36
Sat Sun 6.67 66.70
na 6.67 80.04
6.67 93.38
Apr-09 10.02
May-09 13.36
Jun-09 16.70
Jul-09 20.04
Sat Sun
Holiday Sat Sun
Sat Sun Sat
7 8 9 10 11 12 13 14 15 Accrual 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Accrual Ending Bal.
Sat Sun
Sat Sun Sat Sun
Sat Sun
1.67
Sat Sun Sat Sun 1.67 Holiday
Sat Sun 1.67
Sat Sun Holiday
Sat Sun Sat Sun
1.67
1.67 Sat Sun
1.67
Sat Sun Sat Sun
Sat Sun
Sat Sun Sat na na na 1.67 6.68
Sat Sun Holiday
Sat Sun Sat Sun
Sat Sun
1.67 10.02
1.67
Sat Sun
Sat Sun
Sat Sun
Sat 1.67 3.34
Sun
na 1.67 13.36
Sat Sun 1.67 16.70
na 1.67 20.04
1.67 23.38
Aug-2009 93.38 Sat Sun
Sep-2009 106.72
Oct-2009 120.06
Nov-2009 133.40 Sun
Dec-2009 146.74
Sat Sun Sat Sun
Sat Sun
Holiday Sat Sun
Sat Sun Sat Sun Sat Sun
Sat 6.67 Sun
6.67
Sat Sun
6.67
Sat Sun 6.67
6.67
Sat Sun Sat Sun
Sat Sun Sat Sun
Sat Sun Sat Sun Sat Sun
Holiday Holiday Sat Sun
Sat Sun 6.67 106.72 Aug-09 23.38 Sat Sun
na 6.67 120.06
Sat 6.67 133.40
na 6.67 146.74
Sep-09 26.72
Oct-09 30.06
Nov-09 33.40 Sun
Holiday Sat Sun
6.67 160.08 Dec-09 36.74
Sat Sun Sat Sun
Sat Sun
Holiday Sat Sun
Sat Sun Sat Sun Sat Sun
Sat 1.67 Sun
1.67
Sat Sun
1.67
Sat Sun 1.67
1.67
Sat Sun Sat Sun
Sat Sun Sat Sun
Sat Sun Sat Sun Sat Sun
Holiday Holiday Sat Sun
Sat Sun 1.67 26.72
na 1.67 30.06
Sat 1.67 33.40
na 1.67 36.74
Holiday Sat Sun
1.67 40.08