Follow these steps to submit faculty-related teaching payments via spreadsheets to the Payroll Center for processing. By utilizing the spreadsheet, payroll is able to merge the information directly into Smartsheet Faculty Contractor system to leverage approval workflow, payroll processing and reporting purposes. Approved Smartsheet contracts will be extracted and processed in MaineStreet allowing the payroll office to work more efficiently and accurately with a more favorable outcome for the faculty member. Spreadsheets can be submitted if the following requirements are met: - Approvers are identified with @maine.edu email address
- Approvers may have already approved the contract via another authorized method (see template instructions tab for details)
- A minimum of 10 rows per spreadsheet; otherwise enter one at a time via Smartsheet Form
| Warning |
|---|
It is not recommended that contracts that are ready to be processed be delayed... therefore, if you have less than 10 that are ready to go, please use the Smartsheet Form link above to submit right away so as to not hold up the approval and/or payroll process. |
Spreadsheet must be in accordance with the template. See Instructions tab of template for requirements. - Spreadsheets should be uploaded directly to payroll's secure Box SharePoint account:
| Excerpt Include |
|---|
| HumanRes:How to Submit Paperwork, Forms and SpreadsheetsHumanRes: |
|---|
| How to Submit Paperwork, Forms and Spreadsheets |
|---|
| nopanel | true |
|---|
|
- Spreadsheets will be uploaded to Smartsheet by payroll team within 2 business days.
- If approval status(s) are not "Approved", the Smartsheet will trigger the workflow.
| Info |
|---|
| title | Query to get you started.... |
|---|
| An HR query can be run by Term and Instituion that includes classes scheduled to be taught (from Campus Solutions) along with the individual faculty member's HR information such as rank and service list. The query also is the the format required by the Smartsheet Upload process - just fill in the blanks. The public query name is: UMS_PR_TEACHING_CLASS_LIST |
| Note |
|---|
| title | Tips for optimal service... |
|---|
| - To avoid duplication of payments to faculty members, please do not input contracts manually in Smartsheet and send payroll a spreadsheet.
- To avoid overpayments, do not include on the spreadsheets any payments that are included in academic year appointments.
|
Use of the Contract Generator (CG) allows payroll to leverage that data to automate processing of payments resulting in an overall better experience for faculty members. All contracts entered in to the Contract Generator will be converted in to a spreadsheet uploading into Smartsheet. The USM Faculty Contract Generator is a Web-based Teaching Contract processing tool (for USM Staff Only) it is available here - USM Faculty Contract Generator. The tool is managed by Tamara Saarinen - tamaras@maine.edu, 207/581-5439 who should be contacted with access or function questions. | Note |
|---|
| title | Tips for optimal service... |
|---|
| All editing/deleting/updating contracts must be entered into the Contract Generator and/or Smartsheet depending on where in the process the contract currently resides. To avoid duplication of payments to faculty members, please do not send signed contracts to payroll or add manually to Smartsheet and CG. Cancellations: should be cancelled in the CG AND Smartsheet to avoid payment errors and duplication. Important: The number of payments indicated will be spread over the class dates for payroll processing. For example, if the class dates are 1/22/2019 - 3/5/2019 and number of payments is 3, the payment will be spread over January, February and March. Here are some other examples:
| Expand |
|---|
| title | Here are some other examples: |
|---|
|
Pmts | Start | Stop | Payroll Dates |
|---|
| 3 | 3/14/2019 | 5/2/2019 | March-May | | 5 | 1/1/2019 | 5/31/2019 | January-May | | 3 | 1/1/2019 | 5/31/2019 | January-March | | 2 | 3/11/2019 | 4/29/2019 | March-April | | 2 | 1/23/2019 | 2/20/2019 | January-February | | 2 | 2/27/2019 | 4/3/2019 | February-March | | 4 | 2/5/2019 | 5/3/2019 | February-May |
|
|
Faculty Contract Generator (FCG) Activity: Create contracts per usual. All editing/deleting/updating contracts must be entered into the Contract Generator and/or Smartsheet depending on where in the process the contract resides. Download: All activity completed in the Faculty Contract Generator will be converted to a spreadsheet weekly on Thursdays and sent to payroll for uploading into Smartsheet system. See additional information regarding Smartsheet processing. |