FN - Enter Direct Retro Funding Distribution

GENERAL DESCRIPTION:

This process is used for employees that have been paid the correct amount but have been paid by the wrong funding source(s). A Direct Retro Funding Distribution process is performed to correct their funding distribution. These transactions are commonly referred to as "Direct Retros." On the Madison campus, these are often called "Salary Cost Transfers."
This process will not update funding for future payrolls. To affect future payroll funding, funding for the employee/job needs to be updated using the HRS Budget Funding Data Entry page. See 29976 .

All adjustments will be made to Earnings and the effects will flow through to Deductions and Taxes proportionately. Adjustments that would have tax implications will be performed via the Paycheck Adjustment process and be performed by the Service Center.

PROCESS CONSIDERATIONS:
  • Information needed to process: Employee ID, Employee Record, affected pay period(s), correct funding data
  • You will only be able to select payrolls for employees that have been fully processed through HRS and posted in SFS (Shared Financial System).
  • There are two HRS pages that can be accessed to view Direct Retros:
    • Review Retro Distribution Page
      HRS Security Role Required: FI Campus Direct Retro VW
    • Direct Retro Distribution Page
      HRS Security Role Required: FI Campus Direct Retro Approvr; FI Campus Direct Retro Entry; or FI RSP Approval Direct Retro



PROCEDURE STEPS:

Process Direct Retro Distribution

  1. From the HRS Main Menu, navigate to Payroll for North America > Payroll Distribution > Commitment Accounting USA > Direct Retro Distribution
    warning sign  Before adding a new Direct Retro for an employee, first verify whether one has already been created.
    • To search for an existing Direct Retro enter a business unit on the Find Existing Value tab or click the Advanced Search hyperlink to enter additional search criteria.
      NOTE: if you have the Direct Retro ID on the advanced search list, there is no need to enter other criteria
      NOTE: To see previously processed Direct Retros, click the box Include Completed
    • Click Search
      • If you receive the message, No matching values were found, this means no Direct Retro Funding Distribution exists for the information entered in your search criteria.
      • If multiple records are returned, click the desired record.

  2. Click the Add a New Value tab

  3. Click the Add Payment button
    (Direct Retro ID displays as NEW; system will automatically assign Direct Retro number DRXXXXXXXX)

    https://kb.wisc.edu/images/group61/16415/9.2directretronewentry.jpg

  4. Enter the employee's Business Unit in the Bus Unit field (found on Work Location tab of Job Data record)

  5. Enter the 'Date Range' for the paycheck you are processing the direct retro for.
    • Enter Begin Date that is before or equal to the earnings end date of the payroll you will be creating the direct retro for
    • The End Date will automatically be populated based on the last payroll processed through to SFS General Ledger

  6. Enter the Employee ID and tab out of field

  7. Enter the Empl Rcd# and tab out of field
    warning sign  Search button will not display until Business Unit, Employee ID, and Empl Rcd# are populated and user has tabbed out of the fields.

  8. Click the Search button.

    https://kb.wisc.edu/images/group61/16415/9.2directretroentry.jpg

  9. A Payroll Data grid will display at the bottom of the screen with payrolls that are available for direct retro processing.

  10. Select the box next to the payroll that you want to perform the direct retro for
    • Notice payroll 2016BW01B in screen shot below where Direct Retro has already been completed.  For the steps to review previously entered Direct Retros, see below.
    NOTE: You will receive an error message if a Direct Retro is already in process for the selected payroll.

  11. Click Save.

  12. A Run button will appear. Click Run.

    https://kb.wisc.edu/images/group61/16415/9.2directretroselection.jpg

The Retro Distribution Transaction page will appear after processing is complete (NOTE: this may take a minute).



Updating New Funding Data on Retro Distribution Transaction Page

  • Funding distribution will be displayed with 'Old Data' that was used to fund the employee paycheck for the selected payroll. A grid with 'New Data' funding distribution rows will also appear and is editable for entry of new funding values for this employee.

  • You may make several types of updates to the New Data section:
    • You can delete a row to reduce the number of funding sources
      • Note: Do not delete if row is the only row with a particular Earn Code (Earnings Code)
    • You may add additional rows to increase the number of funding sources or to break-out funding based on Earn Code. To add a row for a specific Earn Code, click the + on an existing row with the same Earn Code
    • You may change values on funding rows, except for Empl Record, Earn Code, appointing department, Position and Job Code

  • You MAY NOT change the total of the distribution funding rows. The 'New Data' total must equal the 'Old Data' total in order to save or submit the Direct Retro.

  • The Direct Retro Funding Distribution page is driven by SFS accounting periods during a fiscal year. SFS Accounting Periods begin the 1st calendar day of the month and end the last calendar day of the month. Accounting Period 1 is the month of July, Accounting Period 2 is August, and so on. Accounting Period 12 is June. If an HRS pay period covers two Accounting Periods (months), the Direct Retro page will display separate funding rows for each period.
  1. Enter 'New Data' funding information. (Values from 'Old Data' section are replicated in 'New Data' section as a starting point)
    • GL Business Unit: User can edit field, but will be limited to their own business unit unless they have security for cross-business unit entry. In most cases funding entry for cross-business unit Direct Retros must be done by the Service Center.
    • Fund (e.g., 144)
    • DeptID (e.g., 576847): 6-digit funding department number; does NOT have alpha character
    • Program code (e.g., 7)
    • Project (e.g., PRJJR13): Project field implies employee is funded by grants; if this field is populated 'Project End Date' will display
    • Project End Date: view-only
    • Account: Change if necessary (rarely changed)
    • Earnings: Enter the amount of earnings that you want distributed to this particular funding line

  2. Click 'Calculate Distribution' button
    Note: This step will confirm the funding information the user has entered is valid and that the total payment amount has not changed.

    Warning sign If the Total for the 'New Data' funding being entered does not equal the Total for the 'Old Data', you will receive an error message and will not be able to save the page. Correct the entered amounts as necessary so the Old and New totals match. If you have entered any invalid funding values, the funding line will be highlighted in red and an error message will appear. Make appropriate corrections and click Calculate Distribution again. Once errors are resolved, click Save.

    If you encounter error messages that prevent you from finalizing the Direct Retro other than the errors mentioned above, contact your Affinity Group.

    https://kb.wisc.edu/images/group61/16415/9.2directretronewdata.jpg

  3. Click on the Earnings Messages, Deduction Messages and Tax Messages tabs to verify no errors exist.
    • If errors appear it means that someone else is entering a direct retro for this employee as well.
    • Navigate back to the Direct Retro Pay without saving and you should see data appearing.
    • If the error message is message number 600, you must then delete the duplicate direct retro entry (see below) otherwise contact the service center
      • Click on the Retro Distribute Earnings tab
      • Click the Delete button in the top right.
      • You will be taken back to the Process Direct Retro Distribution page, click delete again.

    https://kb.wisc.edu/images/group61/16415/9.2drerrormsg.jpg


  4. After clicking 'Calculate Distribution' a drop down Distribution Status box will appear. Set status to "Ready for Batch Processing" or "Ready for Supervisor Approval." (Based on user security.) All Direct Retros set to "Ready for Batch Processing" will be picked up in the nightly batch process and be sent to SFS Financials and posted to the General Ledger.
    warning Any errors on the Earnings Messages, Deductions Messages and Tax Messages tabs will prevent the status from being changed to "Ready for Batch Processing".
    • Select "Return to Processing" from the Distribution Status.
    • Follow step 3 above.

    https://kb.wisc.edu/images/group61/16415/9.2drerrormsgreadyforbatch.jpg

  5. Enter any necessary comments in 'Requester Comments' text box. (Optional

  6. Click Save.

    https://kb.wisc.edu/images/group61/16415/9.2directretroreadyforbatch.jpg


Custom Process Exceptions

Direct Retros for Employees on Work Study

  • User will enter funding values in New Data grid that reflect funding distribution, INCLUDING Fund 145 entries (federally-funded work study) and SFS account 1781, depending on type of work study applicable.

Direct Retros on Fringe Exceptions

  • The Direct Retro process for fringe exceptions WILL update the funding according to the Custom Fringe Distribution Process.


Viewing through the Review Retro Distribution Page

On this page, you can search for a Direct Retro using the process states of Complete, Delete, Editing, Initiated. When the status of the Direct Retro is Complete you can view the old data and new data of the employee's funding combination code for earnings, deductions, and taxes.

  1. From the HRS Main Menu, use navigation path: Payroll for North America > Payroll Distribution > Commitment Accounting USA > Review Retro Distribution

  2. In the Review Retro Distribution screen, the Find an Existing Value tab displays searchable fields
      Run Control ID: enter all or part of the unique Direct Retro ID number that begins with DR000, if known. (e.g., DR00000048893).
      • Note: For UW-Madison, the unique Direct Retro ID number displays on the Posting tab of the Cost Transfer web tool when the Status of the salary cost transfer is Completed.


      Salary Cost Transfer entered

    • Last Operator to Update: enter the 8-digit Employee ID of the person who most recently updated the Direct Retro record in HRS, if known (e.g., 00314331). Otherwise, leave blank.
    • Creation Date: enter the date the Direct Retro was created in HRS, if known (e.g., 10/15/2012). Otherwise, you can select the between parameter and enter a beginning date and ending date range.
    • Date of pay: enter the Pay Period End Date when the updated funding information for the employee's salary expense was posted in HRS, if known.
      Note:
      To locate Pay Period End Dates for employees paid monthly and bi-weekly, refer to the online UW Payroll Calendar.
    • Transaction Source: select from the list of available choices (e.g., Direct Access Changes), or leave blank.
    • Process State: select from the list of available choices (e.g., Complete), or leave blank.
    • Process Date: enter the date the Direct Retro was processed in HRS, if known.  Otherwise, you can select the between parameter and enter a beginning date and ending date range.

    1. Search for Retro Distribution

  3. Click Search
    • If you receive the message, No matching values were found, this means no Direct Retro Funding Distribution exists for the information entered in your search criteria.
    • If multiple records are returned, click the desired record.
    • You will be taken to the "Retro Distribution Earning" tab.



Deleting Direct Retro

  1. From the HRS Main Menu, navigate to Payroll for North America > Payroll Distribution > Commitment Accounting USA > Direct Retro Distribution

  2. Enter the Direct Retro number, or use the search feature.

  3. Select the Direct Retro with a status of Not Started or In Progress

  4. If you are taken to the Process Direct Retro Distribution page click the Delete button in the upper right corner.

  5. If you are taken to the Retro Distribution Earnings Page, click the Delete button in the upper right corner.
    • You will then be taken back to the Process Direct Retro Distributions page, click the Delete button in the upper right corner.


ADDITIONAL RESOURCES:

Related KBs

Related Links



Keywords:Direct Retro Funding Distribution SCT salary cost transfer   Doc ID:16415
Owner:Christine G.Group:Human Resource System (HRS)
Created:2011-01-04 19:00 CDTUpdated:2017-04-06 07:44 CDT
Sites:Human Resource System (HRS)
Feedback:  1   2