Start a Part Time Business

Document Sample
Start a Part Time Business Powered By Docstoc
					                             INSTRUCTIONS- EXCEL2007
                               Part Time "A" Contract Faculty
     Employee should track their leave separately from Leave Keeper for comparison
                                        purposes.
Step 1: Activate Excel's Add-Ins




Step 2: Enter Employee Information
Start by entering the employee's name, employee number, date of hire, agency and either the
beginning balance or the carry-over balance of unused annual and sick leave from the prior year
in the Employee Information worksheet . Note: This is the only worksheet that will allow you to
enter employee information and leave balances. Part-time "A" contract faculty begin their initial
12 months of hire with 240 hours of sick leave prorated by their FTE. No additional sick leave is
accrued for new hire faculty in their initial 12 months of service.

Step 3: Enter employee's FTE in the Quarterly worksheet
Enter the employee's FTE in cell I5. The leave earned will automatically calculated based on the
FTE entered for the employee. FTE should be enter in percent using the % sign (i.e. 100%). Only
enter the FTE on the quarters the employee worked during the year. If the employee is hired or
has an FTE change in either mid-quarter or mid-month you will need to manually over ride the
earned column with the correct accrual.
Step 4: Begin entering leave taken
Leave for part time faculty is used in one hour increments. Record the leave by first finding the
day of the month in cells A8 through A38, then enter the amount of leave used in either the Sick,
Family Sick or Annual column for the corresponding month. Other Leave (Civil, Military, Other
Paid Leave, Leave Without Pay) should be recorded by the hours used and the initial for the kind
of leave. Example: 4-C for 4 hours of Civil leave. Note: If the employee is on FMLA the leave
should also be tracked on the FMLA worksheet.
The carry-over balances for the 3rd Quarter will reflect the Board of Regents rules that state that no
more than 384 hours (48 days) of annual leave and 768 hours (96 days) of sick leave can be carried
over from one fiscal year to another. Leave balances over these limits will be forfeited on June 30th
each year. The allowable carry-over is also prorated by the employee's FTE. Example: Employee at
60% FTE maximum annual leave carry-over is 230.4 hours. (384 hours x 60% fte = 230.4)
PART TIME "A" CONTRACT FACULTY LEAVE POLICIES


Leave policies for Part time faculty can be found in the University of Nevada, Reno Administrative M
 http://www.unr.edu/business_finance/forms/uam.pdf
no Administrative Manual, section 2,670
         EMPLOYEE INFORMATION
                         *Required fields
              Name:                                 *
    Employee Number:                        *
      UNR Hire Date:                        *
             Agency:


   BEGINNING OR PRIOR YEAR LEAVE
             BALANCES

                Sick:                       *
              Annual:                       *




BEGINNING SICK LEAVE CALCULATOR FOR
         NEW HIRE FACULTY
           Enter FTE:
 Beginning Sick Leave:                      Hours
                                                                               1ST QUARTER


                                   ATTENDANCE AND LEAVE RECORD 2009                                                                BEGINNING OR               SICK
                                                                                                                                      PRIOR YEAR            ANNUAL
Employee:                                                                            Hire Date:                                  LEAVE BALANCES
Employee Number:                                                         Annual Leave Rate: 16
Agency:                                                                                   FTE:
                   JANUARY                         FEBRUARY                                MARCH                                      SICK LEAVE            ANNUAL LEAVE
                 Family                           Family                                Family
DAYS      Sick    Sick    Annual   Other   Sick    Sick    Annual   Other     Sick       Sick     Annual   Other                ERN'D   USED      BAL.     ERN'D   USED    BAL.

   1       H       H        H       H                                                                              1/31/2009
   2                                                                                                               2/28/2009
   3                                                                                                               3/31/2009
   4
   5                                                                                                                           Work schedule:
   6
   7
   8
   9
  10
  11
  12                                                                                                                           Please sign below if you are in agreement and return this form to you
  13                                                                                                                           leave keeper. If you do not agree with the balances above, please noti
  14                                                                                                                           your leave keeper as soon as possible.
  15
  16                                        H       H        H       H
  17
  18                                                                                                                           Signature
  19       H       H        H       H
  20
  21                                                                                                                           Date
  22
  23
  24
  25                                                                                                                           Signature of leave keeper
  26
  27                                                                                                                           Notes:
  28
  29
  30
  31


  OTHER CODES: C - CIVIL           M - MILITARY   OL - OTHER PAID LEAVE        W - LEAVE WITHOUT PAY

                                                                                      Page 5
                                                        1ST QUARTER




                                                        FAMILY SICK
                                                         USED TO DT




Please sign below if you are in agreement and return this form to your
leave keeper. If you do not agree with the balances above, please notify
your leave keeper as soon as possible.




                                                            Page 6
                                                                                            2ND QUARTER




                               ATTENDANCE AND LEAVE RECORD 2009                                                                  PRIOR QUARTER               SICK
                                                                                                                                 LEAVE BALANCE             ANNUAL
Employee:                                                                        Hire Date:
Employee Number:                                                        Annual Leave Rate: 16                                                                                          FAMILY SICK
Agency:                                                                               FTE:                                                                                             USED TO DT
                       April                                  May                         June                                   SICK LEAVE                 ANNUAL LEAVE
              Family                                 Family                             Family                                ERN'
DAYS   Sick    Sick       Annual    Other     Sick    Sick     Annual   Other    Sick    Sick    Annual   Other                D   USED BAL.            ERN'D USED         BAL.
   1                                                                                                              4/30/2009
   2                                                                                                              5/31/2009
   3                                                                                                              6/30/2009
   4
   5                                                                                                                          Comments:
   6
   7
   8
   9
  10
  11
  12                                                                                                                          Please sign below if you are in agreement and return this form to your leave
  13                                                                                                                          keeper. If you do not agree with the balances above, please notify your leave
  14                                                                                                                          keeper as soon as possible.
  15
  16
  17
  18                                                                                                                          Signature
  19
  20
  21                                                                                                                          Date
  22
  23
  24
  25                                           H       H            H    H                                                    Signature of leave keeper
  26
  27                                                                                                                          Notes:
  28
  29
  30
  31


OTHER CODES: C - CIVIL         M - MILITARY     OL - OTHER PAID LEAVE           W - LEAVE WITHOUT PAY




                                                                                                 Page 7
                                                                                         3RD QUARTER


                           ATTENDANCE AND LEAVE RECORD 2009                                                                   BEGINNING                SICK

                                                                                                                              FISCAL YEAR            ANNUAL
Employee:                                                                  Hire Date:                                     LEAVE BALANCE
Employee Number:                                                 Annual Leave Rate: 16                                                                                        FAMILY SICK
Agency:                                                                          FTE:                                                                                          USED TO DT
                    July                         AUGUST                          SEPTEMBER                                    SICK LEAVE              ANNUAL LEAVE
              Family                           Family                           Family
DAYS   Sick    Sick    Annual   Other   Sick    Sick    Annual   Other   Sick    Sick    Annual    Other               ERN'D USED         BAL.    ERN'D USED         BAL.
   1                                                                                                       7/31/2009
   2                                                                                                       8/31/2009
   3      H     H          H     H                                                                         9/30/2009
   4
   5                                                                                                                   Work Schedule:
   6
   7                                                                      H       H        H        H
   8
   9
  10
  11
  12                                                                                                                   Please sign below if you are in agreement and return this form to your
  13                                                                                                                   leave keeper. If you do not agree with the balances above, please notify
  14                                                                                                                   your leave keeper as soon as possible.
  15
  16
  17
  18                                                                                                                   Signature
  19
  20
  21                                                                                                                   Date
  22
  23
  24
  25                                                                                                                   Signature of leave keeper
  26
  27                                                                                                                   Notes:
  28
  29
  30
  31


OTHER CODES: C - CIVIL          M - MILITARY     OL - OTHER PAID LEAVE            W - LEAVE WITHOUT PAY

                                                                                               Page 8
                                                                                                                                                            4TH QUARTER
                         ATTENDANCE AND LEAVE RECORD 2009                                                                   PRIOR QUARTER                SICK
                                                                                                                            LEAVE BALANCE              ANNUAL
Employee:                                                                  Hire Date:
Employee Number:                                                  Annual Leave Rate: 16                                                                                             FAMILY SICK
Agency:                                                                          FTE:                                                                                               USED TO DT
             OCTOBER                             NOVEMBER                         DECEMBER                                      SICK LEAVE              ANNUAL LEAVE
              Family                            Family                            Family                                                             ERN'
DAYS   Sick    Sick    Annual    Other   Sick    Sick    Annual    Other   Sick    Sick    Annual   Other                ERN'D USED        BAL.       D   USED    BAL.
   1                                                                                                        10/31/2009
   2                                                                                                        11/30/2009
   3                                                                                                        12/31/2009
   4
                                                                                                                         Work Schedule:
   5
   6
   7
   8
   9
  10
  11                                      H       H        H         H
  12                                                                                                                     Please sign below if you are in agreement and return this form to your leave
  13                                                                                                                     keeper. If you do not agree with the balances above, please notify your leave
  14                                                                                                                     keeper as soon as possible.
  15
  16
  17
  18                                                                                                                     Signature
  19
  20
  21                                                                                                                     Date
  22
  23
  24
  25                                                                        H       H        H        H                  Signature of leave keeper
  26                                      H       H        H         H
  27                                      H       H        H         H                                                   Notes:
  28
  29
  30    H       H        H         H
  31


OTHER CODES: C - CIVIL          M - MILITARY    OL - OTHER PAID LEAVE             W - LEAVE WITHOUT PAY




                                                                                                                                                                 Page 9
                                           2009 FMLA Summary
                                                                         Current Year           Previous Year
                                     Employee's FTE:                        100%
       Regular FMLA Allowable hours according to FTE:                        480

                                FMLA 1: Total hours used:                     0.00                   0.00
                                FMLA 2: Total hours used:                     0.00                   0.00
                                FMLA 3: Total hours used:                     0.00                   0.00
                      Roll back hours from prior 12 months:                   0.00

                              Summary of hours used:
                             Regular FMLA hours used:     0.00
                   Military Caregiver FMLA hours used:    0.00
          Total combined (Reg & Military) hours used:     0.00
           Regular FMLA Remaining Hours Available: 480.00


    Military Caregiver Allowable hours according to FTE:                    1040.00         Equivalent to 26 weeks
           Summary of Military Caregiver hours used:
                      *Military Caregiver FMLA Hours Used:       0.00                                 0.00
                Military Roll back hours from prior 12 months:   0.00
            Military Caregiver Remaining Hours Available: 1,040.00

*Military Caregivier leave is available during "a single 12 month period" during which an
eligible employee is entitled to a combined total of 26 weeks of all types of FMLA.
                                                                                                                   2009 - FMLA 1




       Employee:                                                                          Enter FTE:        100%                    Total Roll back hours:                  (hours rolled back from previous year)
       Employee #:                                                            Enter carry-over hours:                   (Carry over from previous year)
       Enter FMLA Start Date:                                                 Total hours used YTD:                     (Current year)
                        Remaining hours available: 480.00                        FMLA #1 total used:                    (Carry-over hours + current year hours for 1st FMLA event minus roll-back hours)


                     JANUARY                                FEBRUARY                                    MARCH                                      APRIL                                      MAY                                        JUNE
                                        Roll                                   Roll                                      Roll                                        Roll                                        Roll                                   Roll
DAY     Sick   Annual    LWOP   Other   Back   Sick   Annual   LWOP   Other    Back    Sick   Annual     LWOP   Other    Back     Sick    Annual   LWOP      Other   Back     Sick   Annual   LWOP      Other    Back    Sick   Annual   LWOP   Other   Back
   1     H       H         H     H       H
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15
  16                                            H       H       H      H        H
  17
  18
  19     H       H         H     H       H
  20
  21
  22
  23
  24
  25                                                                                                                                                                           H        H       H          H         H
  26
  27
  28
  29
  30
  31



               Notes:




                                                                                                                   Page 11 of 21                                                                                                   printed: 11/15/2010 5:45 PM
                                                                                                              2009 - FMLA 1




                       JULY                                  AUGUST                            SEPTEMBER                                   OCTOBER                               NOVEMBER                              DECEMBER
                                      Roll                                    Roll                                   Roll                                    Roll                                  Roll                                     Roll
DAY    Sick   Annual   LWOP   Other   Back   Sick   Annual    LWOP    Other   Back   Sick   Annual   LWOP   Other    Back    Sick    Annual   LWOP   Other   Back   Sick   Annual   LWOP   Other   Back   Sick   Annual    LWOP    Other    Back
   1
   2
   3    H       H       H      H       H
   4
   5
   6
   7                                                                                  H       H       H      H        H
   8
   9
  10
  11                                                                                                                                                                 H       H       H      H       H
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25                                                                                                                                                                                                       H       H         H       H       H
  26                                                                                                                                                                 H       H       H      H       H
  27                                                                                                                                                                 H       H       H      H       H
  28
  29
  30                                                                                                                             H     H       H      H       H
  31




                                                                                                                 Page 12 of 21                                                                                         printed: 11/15/2010 5:45 PM
                                                                                                                  2009 - FMLA 2




       Employee:                                                                                                                    Total Roll back hours:                  (hours rolled back from previous year)
       Employee #:                                                            Enter carry-over hours:                   (Carry over from previous year)
       Enter FMLA Start Date:                                                 Total hours used YTD:                     (Current year)
                        Remaining hours available: 480.00                        FMLA #2 total used:                    (Carry-over hours + current year hours for 2nd FMLA event minus roll-back hours)


                     JANUARY                                FEBRUARY                                    MARCH                                      APRIL                                      MAY                                        JUNE
                                        Roll                                   Roll                                      Roll                                        Roll                                        Roll                                    Roll
DAY     Sick   Annual    LWOP   Other   Back   Sick   Annual   LWOP   Other    Back    Sick   Annual     LWOP   Other    Back     Sick    Annual   LWOP      Other   Back     Sick   Annual   LWOP      Other    Back    Sick   Annual   LWOP   Other    Back
   1     H       H         H     H       H
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15
  16                                            H       H       H      H        H
  17
  18
  19     H       H         H     H       H
  20
  21
  22
  23
  24
  25                                                                                                                                                                           H        H       H          H         H
  26
  27
  28
  29
  30
  31



               Notes:




                                                                                                                   Page 13 of 21                                                                                                    printed: 11/15/2010 5:45 PM
                                                                                                              2009 - FMLA 2




                       JULY                                  AUGUST                            SEPTEMBER                                   OCTOBER                               NOVEMBER                              DECEMBER
                                      Roll                                    Roll                                   Roll                                    Roll                                  Roll                                     Roll
DAY    Sick   Annual   LWOP   Other   Back   Sick   Annual    LWOP    Other   Back   Sick   Annual   LWOP   Other    Back    Sick    Annual   LWOP   Other   Back   Sick   Annual   LWOP   Other   Back   Sick   Annual    LWOP    Other    Back
   1
   2
   3    H       H       H      H       H
   4
   5
   6
   7                                                                                  H       H       H      H        H
   8
   9
  10
  11                                                                                                                                                                 H       H       H      H       H
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25                                                                                                                                                                                                       H       H         H       H       H
  26                                                                                                                                                                 H       H       H      H       H
  27                                                                                                                                                                 H       H       H      H       H
  28
  29
  30                                                                                                                             H     H       H      H       H
  31




                                                                                                                 Page 14 of 21                                                                                         printed: 11/15/2010 5:45 PM
                                                                                                                  2009 - FMLA 3




       Employee:                                                                                                                    Total Roll back hours:                  (hours rolled back from previous year)
       Employee #:                                                            Enter carry-over hours:                   (Carry over from previous year)
       Enter FMLA Start Date:                                                 Total hours used YTD:                     (Current year)
                        Remaining hours available: 480.00                        FMLA #3 total used:                    (Carry-over hours + current year hours for 3rd FMLA event minus roll-back hours)


                     JANUARY                                FEBRUARY                                    MARCH                                      APRIL                                      MAY                                        JUNE
                                        Roll                                   Roll                                      Roll                                        Roll                                        Roll                                   Roll
DAY     Sick   Annual    LWOP   Other   Back   Sick   Annual   LWOP   Other    Back    Sick   Annual     LWOP   Other    Back     Sick    Annual   LWOP      Other   Back     Sick   Annual   LWOP      Other    Back    Sick   Annual   LWOP   Other   Back
   1     H       H         H     H       H
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15
  16                                            H       H       H      H        H
  17
  18
  19     H       H         H     H       H
  20
  21
  22
  23
  24
  25                                                                                                                                                                           H        H       H          H         H
  26
  27
  28
  29
  30
  31



               Notes:




                                                                                                                   Page 15 of 21                                                                                                   printed: 11/15/2010 5:45 PM
                                                                                                              2009 - FMLA 3




                       JULY                                  AUGUST                            SEPTEMBER                                   OCTOBER                               NOVEMBER                              DECEMBER
                                      Roll                                    Roll                                   Roll                                    Roll                                  Roll                                     Roll
DAY    Sick   Annual   LWOP   Other   Back   Sick   Annual    LWOP    Other   Back   Sick   Annual   LWOP   Other    Back    Sick    Annual   LWOP   Other   Back   Sick   Annual   LWOP   Other   Back   Sick   Annual    LWOP    Other    Back
   1
   2
   3    H       H       H      H       H
   4
   5
   6
   7                                                                                  H       H       H      H        H
   8
   9
  10
  11                                                                                                                                                                 H       H       H      H       H
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25                                                                                                                                                                                                       H       H         H       H       H
  26                                                                                                                                                                 H       H       H      H       H
  27                                                                                                                                                                 H       H       H      H       H
  28
  29
  30                                                                                                                             H     H       H      H       H
  31




                                                                                                                 Page 16 of 21                                                                                         printed: 11/15/2010 5:45 PM
                                                                                                      2009 FMLA - FMLA Military Caregiver




       Employee:                                                                             Enter FTE:       100%                    Total Roll back hours:                  (hours rolled back from previous year)
       Employee #:                                                             Enter carry-over hours:                    (Carry over from previous year)
       Enter FMLA Start Date:                                                   Total hours used YTD:                     (Current year)
                        Remaining hours available: 1040.00                    Military FMLA total used:                   (Carry-over hours + current year hours for Military FMLA event minus roll-back hours)


                     JANUARY                                FEBRUARY                                      MARCH                                      APRIL                                       MAY                                       JUNE
                                        Roll                                                                               Roll                                        Roll                                        Roll                                    Roll
DAY     Sick   Annual    LWOP   Other   Back   Sick   Annual   LWOP   Other   Roll Back   Sick   Annual    LWOP   Other    Back      Sick   Annual   LWOP      Other   Back     Sick    Annual   LWOP     Other    Back    Sick   Annual   LWOP   Other    Back
   1     H       H         H     H       H
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15
  16                                            H       H       H      H         H
  17
  18
  19     H       H         H     H       H
  20
  21
  22
  23
  24
  25                                                                                                                                                                              H        H       H        H          H
  26
  27
  28
  29
  30
  31



               Notes:




                                                                                                                     Page 17 of 21                                                                                                   printed: 11/15/2010 5:45 PM
                                                                                                     2009 FMLA - FMLA Military Caregiver




                       JULY                                  AUGUST                            SEPTEMBER                                     OCTOBER                               NOVEMBER                              DECEMBER
                                      Roll                                    Roll                                     Roll                                    Roll                                  Roll                                     Roll
DAY    Sick   Annual   LWOP   Other   Back   Sick   Annual    LWOP    Other   Back   Sick   Annual     LWOP   Other    Back    Sick    Annual   LWOP   Other   Back   Sick   Annual   LWOP   Other   Back   Sick   Annual    LWOP    Other    Back
   1
   2
   3    H       H       H      H       H
   4
   5
   6
   7                                                                                  H       H         H      H        H
   8
   9
  10
  11                                                                                                                                                                   H       H       H      H       H
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25                                                                                                                                                                                                         H       H         H       H       H
  26                                                                                                                                                                   H       H       H      H       H
  27                                                                                                                                                                   H       H       H      H       H
  28
  29
  30                                                                                                                               H     H       H      H       H
  31




                                                                                                                   Page 18 of 21                                                                                         printed: 11/15/2010 5:45 PM
 CALCULATES LEAVE FOR MID-MONTH FTE CHANGE


Enter first day of month (mm/dd/yy):
Enter date of FTE change (mm/dd/yy):
Enter current FTE:
Enter new FTE:


Total hours earned for the month:      #N/A
 LEAVE CALCULATOR FOR MID-MONTH
             START

Enter start date (mm/dd/yy):
Enter employee's FTE:

Total Annual Leave Hours Earned:   #N/A
Total Sick Leave Hours Earned:     #N/A
                   ANNUAL LEAVE PAY OUT

Professional staff on an “A” contract appointment who resign or retire may
be entitled to be paid for unused accumulated annual leave up to the
maximum of 384 hours (48 days), unless the supervisor or other appropriate
administrative officer directs the employee, in writing, to use all or a portion
of the accumulated leave prior to the final date of employment. The Terms of
Employment will indicate if faculty is not eligible for leave pay out.

Note: Employee will not be paid for any unused sick leave.


Enter Base Salary:                           $           -
Enter number of hours to pay:

Total pay out amount:                        $           -

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:50
posted:11/15/2010
language:English
pages:21
Description: Start a Part Time Business document sample