FN - Salary Funding Lifecycle for Payroll Processing

This document provides an overview of the salary funding lifecycle (e.g. what happens when) during a payroll processing week. Helpful funding reports and job aids are listed at the bottom of this document.

 You may click on the links below to navigate directly to that section:



Explanation of Salary Funding Lifecycle during a Payroll Processing Week

  1. Add Salary Funding. An HR personnel action of Hire, Transfer, Change Department, Return from Leave (in different fiscal year) or Rehire (into different department in same Fiscal Year) triggers the need to add funding for the employee's job in HRS. Funding needs to be added via the Funding Data Entry page, Add a New Value tab, before the Payroll Confirmation deadline in order to take effect for the current payroll period.

    a. If you are funding the salary expense for one person in one appointment, see KB FN - Add or Change Appointment Level Funding for Employee's Salary Expense ;
    b. If you are funding the salary expense for multiple employees in one Position Number, see KB FN - Add or Change Position Level Funding for Employees' Salary Expense ;
    c. If you are funding the salary expense for multiple employees in one Department, see KB FN - Add or Change Department Level Funding for an Appointing Department.

    Note: For more information about the different levels of salary funding (e.g. Appointment, Position, Department, etc.) distributed to employees' earnings during payroll processing, refer to HRS KnowledgeBase document, FN - Salary Funding Levels Assigned During Payroll Processing.

  2. Prelim Payroll Calcs (Preliminary Payroll Calculations).   After each preliminary payroll calculation during a payroll processing week (refer to UW Payroll Calendar), several funding-related queries or reports are available. You should run these queries/reports each Monday, Tuesday, Wednesday, Thursday of a payroll processing week to determine whether or not you need to add or change funding for an employee's job before the Payroll Confirmation deadline:

    a. Payroll Edit Report/Query. You can run the Payroll Edit Report as a query within HRS to view payroll dollars and funding level for employees scheduled to be paid; identifies funding level of Appointment, Position, Department or Suspense. If your employee is also working for other departments on campus, or at another campus, these jobs are also displayed on the Payroll Edit Report. The query results can be downloaded to an Excel spreadsheet to sort and filter as needed.

    b. Funding Edit Errors Inquiry Report - Identifies whether employee jobs have payroll funding errors for the current Pay Run ID.  If the errors are not corrected by the Payroll Confirmation deadline, the payroll funding for the employee's job goes to Fund 128, Funding Dept PRDFLT (Payroll Default), Program code 1.  Note: A Direct Retro Funding Distribution (also known as Salary Cost Transfer) would be needed to correct the payroll funding retroactively.

    c. Suspense Funding Report/Query - Identifies employee jobs without any payroll funding for all or part of their pay period. If funding is not added before the Payroll Confirmation deadline, the payroll funding for the employee's job goes to Fund 128, Funding Dept PRSUSP (Payroll Suspense), Program code 1. Note: A Direct Retro Funding Distribution (also known as Salary Cost Transfer) would be needed to correct the payroll funding retroactively.

  3. d. No Appointment Level Funding Report/Query - Identifies employee jobs without Appointment-level or Position-level funding for part or all of their pay period for the current Pay Run ID. If Department level funding has previously been entered for the current Fiscal Year, the salary expenses will be charged to the Department level funding chartfield of the employee's appointing department. If Department level funding has not been entered for the current Fiscal Year, the salary expenses will be charged to the Payroll Suspense (PRSUSP) chartfield of Fund 128, Funding Dept PRSUSP, Program code 1.

  4. Change Salary Funding.  You can change funding for an employee's job on the Funding Data Entry page, Find an Existing Value tab in HRS.  Funding changes need to be made before the Payroll Confirmation deadline, in order to take effect for the current pay period.

    a. If you want to change the funding for one person in one appointment, see KB FN - Add or Change Appointment Level Funding for Employee's Salary Expense
    b. If you want to change the funding for multiple employees in one Position Number, see KB FN - Add or Change Position Level Funding for Employees' Salary Expense ;
    c. If you want to change the funding for multiple employees in one Department, see KB FN - Add or Change Department Level Funding for an Appointing Department .

  5. Final Payroll Calc. In general, the Final Payroll Calculation process begins on Thursday around noon during a payroll processing week. Refer to the UW Payroll Calendar for the current schedule.

  6. Payroll Confirmation. This is the final deadline to add or change payroll funding for an employee's job, in order to take effect for the current pay period. In general, the Payroll Confirmation process begins on Thursday afternoon and ends on Thursday evening during a payroll processing week. Refer to the UW Payroll Calendar for the current schedule.

  7. HRS Actuals Distribution. After payroll post-confirmation processing (and before HRS payroll is posted to the General Ledger), you can view funding for an employee's earnings, deductions, and taxes for a particular payroll by navigating to the Review Actuals Distribution page in PeopleSoft HRS.  In general, the Review Actuals Distribution page is ready to view on Friday of a payroll processing week. The Review Actuals Distribution page will also show whether the funding for an employee's job will be distributed to Payroll Suspense (PRSUSP) or Payroll Default (PRDFLT).

  8. Final Batch EditsThe final batch edit process prepares the HRS information to be interfaced to the Shared Financial System (SFS) and WISDM (Wisconsin Data Mart for PeopleSoft Financials) for financial reporting. If funding errors were found during the final batch edit process, HRS distributes payroll funding to Fund 128, Funding Dept PRDFLT (Payroll Default), Program code 1.  If payroll funding was missing for an employee's job during the final batch edit process, HRS distributes the funding to Fund 128, Funding Dept PRSUSP (Payroll Suspense), Program code 1.

  9. Interface to SFS Financials General LedgerThe HRS payroll data is interfaced to the Shared Financial System (SFS) and posted in the General Ledger approximately 2 to 3 business days after payroll post-confirmation processing.  You can use WISDM (Wisconsin Data Mart for PeopleSoft Financials) to see general ledger account information for the HRS Payroll. 

    If funding information is incorrect for an employee's job, non-Madison campuses would need to create a Direct Retro Funding Distribution in HRS to change the funding retroactively.  The UW-Madison campus uses the Salary Cost Transfer Workflow tool as their web-based form and routing system for changing payroll funding retroactively.

Helpful Funding Reports 

  • Employee Funding Summary Report - The Employee Funding Summary Report can be run for a specified funding effective date for a business unit, division or department. The funding effective date can be the current date, future date or historical date. It lists the funding level (Appointment, Position, Department, No funding), funding combination codes and funding percentage for all employees as of your specified funding effective date. The report results also display whether a payroll earnings code is funded differently than regular earnings. The Employee Funding Summary Report can be downloaded to an Excel spreadsheet.

  • Employee Funding Becoming Inactive Report - You can run this report by funding division or department for a future date range to identify employees' funding becoming inactive due to a Project/Grant expiring or funding department closing. The report can be downloaded to an Excel spreadsheet.

  • Funding Change Report - You can run the Funding Change Report by appointing Department to view funding changes for one or more employees, date and time the change occurred, and the name of the person who made the change. The report lists funding level changes for appointment, position or department level funding entered on the Funding Data Entry page in HRS. The Funding Change Report can also be downloaded to an Excel spreadsheet.

  • View Payroll Default Funding (PRDFLT) - After the payroll confirmation has been completed for the current Pay Run ID, you can run a finance query by Pay Run ID, division or department to identify employees who had salary expenses charged to the Payroll Default Funding account (128-PRDFLT-1) because funding errors were not corrected in time. 

 

Related Job Aids: 

UW Payroll Calendar - online

UW Payroll Calendars (pay schedule, 9 Month and Summer)

FN - Salary Funding Levels Assigned During Payroll Processing



Keywords:training funding overview salary payroll processing hierarchy levels appointment position department suspense default PRSUSP PRDFLT earnings placeholder precedence preliminary payroll calc Payroll Edit Report query Funding Edit Errors Inquiry Report no appointment level funding report appt Suspense Funding Report change salary funding final payroll calc payroll confirmation HRS Actuals Distribution Review Actuals Distribution Final Batch Edits WISDM General Ledger SFS   Doc ID:27023
Owner:Christine G.Group:Human Resource System (HRS)
Created:2012-10-24 11:07 CSTUpdated:2016-11-29 16:18 CST
Sites:Human Resource System (HRS)
Feedback:  0   0