Payroll Timesheet - Excel

Document Sample
Payroll Timesheet - Excel Powered By Docstoc
					  DUE11TH
                                                           Mt. San Jacinto Community College
        TO
  PAYROLL
                                      TIME SHEET FOR TEMPORARY EMPLOYEES - PAID ON THE (A) PAYROLL                                                                                               A
Name:                                                                                                     Department:
                                                                                                          Job Title:
Employee #:                                                                                                                               SU      M           T    W         TH              F     S
                                                                                                          Daily Schedule in # of Hours:
(Located on your pay stub)




  Time Period:                                                         12th through                                                        11th         2011
                 IF NOT COMPLETED ON-LINE, TIME SHEET MUST BE COMPLETED IN INK
 DATE                              REGULAR HOURS WORKED




                                                                                             Straight
                                                                                             Excess
                                                                                              Time
                                                                                   TOTAL
                                                                                                            OT
               IN            OUT       IN        OUT           IN        OUT       HOURS


  EX        8:00 AM      12:00 PM 12:30 PM      2:00 PM     3:00 PM     4:30 PM    7.00                     0.00
  12
  13
  14
  15
  16
  17
  18
  19
  20
  21
  22
  23
  24
  25
  26
  27
  28
  29                                                                                                                   Comments:
  30
  31
   1
   2
   3
   4
   5
   6
   7
   8
   9
  10
  11
TOTAL HOURS:                                                                       0.00      0.00           0.00

ACCOUNT CODE FROM APPROVED HRSR                                                             If employee is requesting OT to be paid, please provide the appropriate budget code,
XX - XXX - XXXX - X - XXXX-XXXX - XXXX                                                                                 with object code ending in 40.
Fund-School-Resource-PY-Goal-Function-Object

                                                                                    %      Total Reg Hrs:                          0.00        Total Excess Hrs:    0.00   Total OT Hrs:           0.00

                                                                                    %      Rate of Pay:                                        Rate of Pay:        $0.00   Rate of Pay:           $0.00

                                                                                    %      Total Earnings:                        $0.00        Total Earnings:     $0.00   Total Earnings:        $0.00

                                                                                                                        Total Gross Pay                                                          $0.00


Employee statement: I recognize and agree that falsifying any information
supplied to the District, including, but not limited to, information supplied on
time sheets or cards is grounds for disciplinary action. Accordingly I certify
                                                                                                          Supervisor statement: I certify that I have reviewed the above
that the information submitted herewith is true and accurate.
                                                                                                          information for accuracy.




Employee Signature                                                                         Date           Supervisor Signature                                                                   Date




                        A
                        B
                        C
                        C




            7:00 AM
            7:15 AM
            7:30 AM
            7:45 AM
            8:00 AM
            8:15 AM
            8:30 AM
            8:45 AM
            9:00 AM
            9:15 AM
            9:30 AM
            9:45 AM
           10:00 AM
           10:15 AM
           10:30 AM
           10:45 AM
           11:00 AM
           11:15 AM
           11:30 AM
           11:45 AM
           12:00 PM
           12:15 PM
           12:30 PM
           12:45 PM
            1:00 PM
            1:15 PM
            1:30 PM
            1:45 PM
            2:00 PM
            2:15 PM
            2:30 PM
            2:45 PM
            3:00 PM
            3:15 PM
            3:30 PM
            3:45 PM
            4:00 PM
            4:15 PM
            4:30 PM
            4:45 PM
            5:00 PM
            5:15 PM
            5:30 PM
            5:45 PM
            6:00 PM
            6:15 PM
            6:30 PM
            6:45 PM
            7:00 PM
            7:15 PM
            7:30 PM
            7:45 PM
            8:00 PM
            8:15 PM
            8:30 PM
            8:45 PM
            9:00 PM
            9:15 PM
            9:30 PM
            9:45 PM
           10:00 PM
           10:15 PM
           10:30 PM
           10:45 PM
           11:00 PM
           11:15 PM
           11:30 PM
           11:45 PM
           12:00 AM
           12:15 AM
           12:30 AM
           12:45 AM
            1:00 AM
            1:15 AM
            1:30 AM
            1:45 AM
            2:00 AM
            2:15 AM
            2:30 AM
            2:45 AM
            3:00 AM
            3:15 AM
            3:30 AM
            3:45 AM
            4:00 AM
            4:15 AM
            4:30 AM
            4:45 AM
            5:00 AM
            5:15 AM
            5:30 AM
            5:45 AM
            6:00 AM
            6:15 AM
            6:30 AM
            6:45 AM
                             Instructions for Completing Payroll Time sheets
*Tips for use of Excel form:
               Tab until box forms around area of input OR move cursor to area and click.

               The form under Payroll - Time sheet (revised) will auto-calculate.
               The form under Payroll - Time sheet NO FORMULA will not calculate.
               Fill in as completely as possible. Missing information may cause return of form.

Select the correct Time sheet from the tabs at the bottom:
       A-Payroll = Temporary Employees
       M-Payroll = Certificated Subs, Certificated Hrly, Professional Experts with another position
       Substitute Attachment = Attach to your Timesheet
       Stipend Timesheet = Time sheet for a Stipend or Project


Time sheet due dates:
       A-Payroll = Temporary Employees and Student Workers = Due the 11th to Payroll
       M-Payroll = Certificated Subs, Certificated Hrly, Professional Experts with another position =
       Due the 18th to Payroll

Time sheet information:
       Name/Employee #/Department/Job Title = VERY IMPORTANT, MUST HAVE
               Time Period = VERY IMPORTANT, MUST HAVE
               Account Code from Approved HRSR
               Fund-School-Resource-PY-Goal-Function-Object = VERY IMPORTANT, MUST HAVE
       Galaxy account code = enter accordingly being careful to separate digits
       Substitute Employee's, need the Sub-Attachment with their Time sheets = VERY IMPORTANT


       Employee Signature = VERY IMPORTANT, MUST HAVE
       Supervisor Signature = VERY IMPORTANT, MUST HAVE


       If any of the above items are not complete the time sheet may be returned to the department.
       However, Payroll will e-mail the department and the employee for any incomplete time sheet.
                                                             Mt. San Jacinto Community College
  DUE18TH
        TO
  PAYROLL
                                             TIME SHEET FOR CERTIFICATED SUBS, CERTIFICATED HRLY, PROFESSIONAL EXPERTS WITH ANOTHER POSITION.
                                                          Paid on the last business day of each month                  - PAID ON THE (M) PAYROLL
                                                                                                                                                                                                               M
Name:                                                                                                                  Department:
                                                                                                                       Assignment:
Employee #:                                                                                                            Daily Schedule in # of
                                                                                                                                                  SU       M            T          W          TH           F             S
(Located on your pay stub)                                                                                             Hours:




  Time Period:                                                            19th through                                                              18th          2011
                              IF NOT COMPLETED ON-LINE, TIME SHEET MUST BE COMPLETED IN INK
 DATE                              REGULAR HOURS WORKED                                                                                                                 Exception Hours Codes




                                                                                                                                   Straight
                                                                                                          EXCEPTION




                                                                                                                                   Excess
                                                                                                                                    Time
                                                                                                                        CODE
                                                                                                            HOURS
                                                                                        TOTAL HOURS                                               OT                    S   Sick Leave
              IN             OUT        IN         OUT           IN          OUT

  EX        8:00 AM     12:00 PM 12:30 PM         2:00 PM      3:00 PM      4:30 PM         7.00            1            P                        0.00
  19
  20
  21
  22
  23
  24
  25
  26
  27                                                                                                                                                                                   HR USE ONLY
  28                                                                                                                                                                         Contact HR prior to assigning these codes
  29                                                                                                                                                                    CL     Catastrophic Leave
  30                                                                                                                                                                FMLA       Family Medical Leave
  31                                                                                                                                                                FSP        Family School Partnership Act
   1                                                                                                                                                                    ML     Military Leave
   2                                                                                                                                                                PDL        Pregnancy Disability Leave
   3                                                                                                                                                                 WC        Workers' Compensation
   4
   5                                                                                                                                                           Comments:
   6
   7
   8
   9
  10
  11
  12
  13
  14
  15
  16
  17
  18
TOTAL HOURS:                                                                                0.00            0.00                     0.00         0.00

ACCOUNT CODE FROM APPROVED HRSR                                                                        If employee is requesting OT to be paid, please provide the appropriate budget code, with
XX - XXX - XXXX - X - XXXX-XXXX - XXXX                                                                                                 object code ending in 40.
Fund-School-Resource-PY-Goal-Function-Object

                                                                                        %             Total Reg Hrs:                       0.00          Total Excess Hrs:          0.00   Total OT Hrs:                     0.00

                                                                                        %                                                  0.00          Rate of Pay:              $0.00   Rate of Pay:                  $0.00

                                                                                        %             Total Earnings:                     $0.00          Total Earnings:           $0.00   Total Earnings:               $0.00

                                                                                                                                Total Gross Pay                                                                          $0.00

Employee statement: I recognize and agree that falsifying any information
supplied to the District, including, but not limited to, information supplied on time
sheets or cards is grounds for disciplinary action. Accordingly I certify that the
information submitted herewith is true and accurate.
                                                                                                                       Supervisor statement: I certify that I have reviewed the above
                                                                                                                       information for accuracy.



Employee Signature                                                                                    Date             Supervisor Signature                                                                    Date




                       A
                       B
                       C
                       C




            7:00 AM
            7:15 AM
            7:30 AM
            7:45 AM
            8:00 AM
            8:15 AM
            8:30 AM
            8:45 AM
            9:00 AM
            9:15 AM
            9:30 AM
            9:45 AM
           10:00 AM
           10:15 AM
           10:30 AM
           10:45 AM
           11:00 AM
           11:15 AM
           11:30 AM
           11:45 AM
           12:00 PM
           12:15 PM
           12:30 PM
           12:45 PM
            1:00 PM
            1:15 PM
            1:30 PM
            1:45 PM
            2:00 PM
            2:15 PM
            2:30 PM
            2:45 PM
            3:00 PM
            3:15 PM
            3:30 PM
            3:45 PM
            4:00 PM
            4:15 PM
            4:30 PM
            4:45 PM
            5:00 PM
            5:15 PM
            5:30 PM
            5:45 PM
            6:00 PM
            6:15 PM
            6:30 PM
            6:45 PM
            7:00 PM
            7:15 PM
            7:30 PM
            7:45 PM
            8:00 PM
            8:15 PM
            8:30 PM
            8:45 PM
            9:00 PM
            9:15 PM
            9:30 PM
            9:45 PM
           10:00 PM
           10:15 PM
           10:30 PM
           10:45 PM
           11:00 PM
           11:15 PM
           11:30 PM
           11:45 PM
           12:00 AM
           12:15 AM
           12:30 AM
           12:45 AM
            1:00 AM
            1:15 AM
            1:30 AM
            1:45 AM
            2:00 AM
            2:15 AM
            2:30 AM
            2:45 AM
            3:00 AM
            3:15 AM
            3:30 AM
            3:45 AM
            4:00 AM
            4:15 AM
            4:30 AM
            4:45 AM
            5:00 AM
            5:15 AM
            5:30 AM
            5:45 AM
            6:00 AM
            6:15 AM
            6:30 AM
            6:45 AM
                             Instructions for Completing Payroll Time sheets
*Tips for use of Excel form:
               Tab until box forms around area of input OR move cursor to area and click.

               The form under Payroll - Time sheet (revised) will auto-calculate.
               The form under Payroll - Time sheet NO FORMULA will not calculate.
               Fill in as completely as possible. Missing information may cause return of form.

Select the correct Time sheet from the tabs at the bottom:
       A-Payroll = Temporary Employees
       M-Payroll = Certificated Subs, Certificated Hrly, Professional Experts with another position
       Substitute Attachment = Attach to your Timesheet
       Stipend Timesheet = Time sheet for a Stipend or Project


Time sheet due dates:
       A-Payroll = Temporary Employees and Student Workers = Due the 11th to Payroll
       M-Payroll = Certificated Subs, Certificated Hrly, Professional Experts with another position =
       Due the 18th to Payroll

Time sheet information:
       Name/Employee #/Department/Job Title = VERY IMPORTANT, MUST HAVE
               Time Period = VERY IMPORTANT, MUST HAVE
               Account Code from Approved HRSR
               Fund-School-Resource-PY-Goal-Function-Object = VERY IMPORTANT, MUST HAVE
       Galaxy account code = enter accordingly being careful to separate digits
       Substitute Employee's, need the Sub-Attachment with their Time sheets = VERY IMPORTANT


       Employee Signature = VERY IMPORTANT, MUST HAVE
       Supervisor Signature = VERY IMPORTANT, MUST HAVE


       If any of the above items are not complete the time sheet may be returned to the department.
       However, Payroll will e-mail the department and the employee for any incomplete time sheet.
DUE 11th or 18th                          Mt. San Jacinto Community College
      TO Payroll
Depending on your payroll                 SUB-ATTACHMENT FOR BOTH A & M PAYROLL




Name:                                              Department:

Employee #:                                        Job Title:
(Located on your pay stub)




      Time Period:
 FROM DATE                   TO DATE       SUBSTITUTE FOR
 FROM DATE                   TO DATE       SUBSTITUTE FOR
 FROM DATE                   TO DATE       SUBSTITUTE FOR
 FROM DATE                   TO DATE       SUBSTITUTE FOR
 FROM DATE                   TO DATE       SUBSTITUTE FOR
 FROM DATE                   TO DATE       SUBSTITUTE FOR
 FROM DATE                   TO DATE       SUBSTITUTE FOR
 FROM DATE                   TO DATE       SUBSTITUTE FOR




                                       ATTACH TO YOUR TIMESHEET
                             Instructions for Completing Payroll Time sheets
*Tips for use of Excel form:
               Tab until box forms around area of input OR move cursor to area and click.

               The form under Payroll - Time sheet (revised) will auto-calculate.
               The form under Payroll - Time sheet NO FORMULA will not calculate.
               Fill in as completely as possible. Missing information may cause return of form.

Select the correct Time sheet from the tabs at the bottom:
       A-Payroll = Temporary Employees
       M-Payroll = Certificated Subs, Certificated Hrly, Professional Experts with another position
       Substitute Attachment = Attach to your Timesheet
       Stipend Timesheet = Time sheet for a Stipend or Project


Time sheet due dates:
       A-Payroll = Temporary Employees and Student Workers = Due the 11th to Payroll
       M-Payroll = Certificated Subs, Certificated Hrly, Professional Experts with another position =
       Due the 18th to Payroll

Time sheet information:
       Name/Employee #/Department/Job Title = VERY IMPORTANT, MUST HAVE
               Time Period = VERY IMPORTANT, MUST HAVE
               Account Code from Approved HRSR
               Fund-School-Resource-PY-Goal-Function-Object = VERY IMPORTANT, MUST HAVE
       Galaxy account code = enter accordingly being careful to separate digits
       Substitute Employee's, need the Sub-Attachment with their Time sheets = VERY IMPORTANT


       Employee Signature = VERY IMPORTANT, MUST HAVE
       Supervisor Signature = VERY IMPORTANT, MUST HAVE


       If any of the above items are not complete the time sheet may be returned to the department.
       However, Payroll will e-mail the department and the employee for any incomplete time sheet.
                                        Mt. San Jacinto Community College
DUE18TH TO                            TIME SHEET FOR A STIPEND OR PROJECT
    PAYROLL




DEPARTMENT                                                                        NAME
ASSIGNMENT
                                                                                  EMPLOYEE #
DESCRIPTION



                                           DATES

 STIPEND:
           COORDINATOR                                                                    WRITING CENTER COORDINATOR
           DEPARTMENT CHAIR                                                               ON-LINE COURSE DEVELOPMENT
           MATH CENTER COORDINATOR                                                        COACH

 PROJECT:
           COURSE DEVELOPMENT                                                             OTHER- please explain
* TO BE USED WHEN A FLAT RATE HAS BEEN ASSIGNED TO THIS PARTICULAR PROJECT.




                     STIPEND/PROJECT AMOUNT
       $
ACCOUNT CODE FROM APPROVED HRSR
XX XXX XXXX X XXXX-XXXX XXXX
Fund School Resource PY Goal/Function Object

                                                                              %
                                                                              %
                                                                              %
                                                                              %
                                                                              %
NOTE - Payroll cannot process payment without appropriate Human
Resources-approved employment documents.


I certify that the above information is correct                                   I certify that I have reviewed the above information for
                                                                                  completion of assignment and accuracy




Employee Signature                                           Date                 Supervisor Signature                          Date



Dean, Vice President (IF NEEDED)                             Date                 Superintendent/President (IF NEEDED)          Date
                             Instructions for Completing Payroll Time sheets
*Tips for use of Excel form:
               Tab until box forms around area of input OR move cursor to area and click.

               The form under Payroll - Time sheet (revised) will auto-calculate.
               The form under Payroll - Time sheet NO FORMULA will not calculate.
               Fill in as completely as possible. Missing information may cause return of form.

Select the correct Time sheet from the tabs at the bottom:
       A-Payroll = Temporary Employees
       M-Payroll = Certificated Subs, Certificated Hrly, Professional Experts with another position
       Substitute Attachment = Attach to your Timesheet
       Stipend Timesheet = Time sheet for a Stipend or Project


Time sheet due dates:
       A-Payroll = Temporary Employees and Student Workers = Due the 11th to Payroll
       M-Payroll = Certificated Subs, Certificated Hrly, Professional Experts with another position =
       Due the 18th to Payroll

Time sheet information:
       Name/Employee #/Department/Job Title = VERY IMPORTANT, MUST HAVE
               Time Period = VERY IMPORTANT, MUST HAVE
               Account Code from Approved HRSR
               Fund-School-Resource-PY-Goal-Function-Object = VERY IMPORTANT, MUST HAVE
       Galaxy account code = enter accordingly being careful to separate digits
       Substitute Employee's, need the Sub-Attachment with their Time sheets = VERY IMPORTANT


       Employee Signature = VERY IMPORTANT, MUST HAVE
       Supervisor Signature = VERY IMPORTANT, MUST HAVE


       If any of the above items are not complete the time sheet may be returned to the department.
       However, Payroll will e-mail the department and the employee for any incomplete time sheet.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:58
posted:7/4/2012
language:
pages:8