UCPath Suspense Resource Guide | Scribe

UCPath Suspense Resource Guide

  • 2 months ago

    This page explains the purpose of suspense charges in UCPath and provides guidance to prevent, identify, and correct them.

    UCPath Suspense Overview

    UCPath charges a valid full accounting unit (FAU) whenever payroll is processed or salary expenses are transferred using a Salary Cost Transfer (SCT) transaction. The FAU for salary expenses is set up for each position number on the Funding Entry page in UCPath.

    In the event the fund source for a given position is invalid or missing, UCPath charges the FAU set up for the department that owns the position. The FAU for the department is referred to as the Suspense FAU. Charging the salary expense to the Suspense FAU ensures the department is still charged if there are issues with funding at the position level.

    NOTE: Each Organization or Department is responsible for monitoring, correcting, and updating all charges to Suspense. This includes adding or updating the FAU on the position’s Funding Entry page or moving charges from the Suspense FAU to the correct FAU by processing an SCT transaction.

    The difference between the Default FAU for the position and the Suspense FAU for the department is as follows.

    Default FAU

    • The Default FAU is a component of the funding entry at the position level.

    • The Default FAU is assigned by the department on the Funding Entry page and is designated by the blank value in the Earn Code field. UCPath charges the FAU on that line for all earnings not designated with a specific FAU for a specific Earn Code (also referred to as split-funding).

    Below is a screenshot displaying an example of a Default FAU. Zoom in using your browser settings to enlarge the image, as needed.

    Suspense FAU

    • The Suspense FAU is the department level funding entry.

    • The Suspense FAU is charged if the funding entry data on the position level is invalid or missing.

    Below is a screenshot displaying an example of the Suspense FAU. Zoom in using your browser settings to enlarge the image, as needed.

    Establishing or Updating the Suspense FAU

    To establish clear ownership and identify issues related to funding, all departments must have one Suspense FAU to use exclusively for capturing suspense charges (i.e., those with project codes COMBO, FUNDNG, and ENDDTE).

    To establish or change the Suspense FAU for your department, refer to the following step-by-step guide.

    Establish or Update the Suspense FAU

    Causes of Suspense Charges

    There are three key causes of Suspense charges in UCPath. UCPath assigns a distinct project code that signifies the type of funding entry error and indicates why the salary expenses were charged to the Suspense FAU.

    The three causes of Suspense charges are outlined in the following table.

    Project Code

    Significance

    Description

    FUNDNG

    Funding Entry Issue

    UCPath charges the Suspense FAU:

    • When there is no Default FAU on the position's Funding Entry page at the time payroll is processed.

    • During the Fiscal Year End Funding Rollover process if the FAU previously assigned to the position is no longer valid.


    NOTE: All positions with salary expenses are required to have funding in place prior to payroll processing as indicated on the UCPath Payroll Processing Schedule.

    ENDDTE

    Funding End Date Issue

    UCPath charges the Suspense FAU if the position's funding entry has a Funding End Date which has passed and the funding entry has not been updated.

    • For example, if a position's funding entry includes an FAU with an end date of 5/31, a new FAU with an effective date of 6/1 must be in place prior to payroll processing.

    • If possible, avoid using the Funding End Date field when setting up position funding.

    COMBO

    Invalid FAU Issue

    UCPath charges the Suspense FAU if the designated FAU on the position is no longer valid in the UCLA General Ledger.


    Possible reasons an FAU becomes invalid include:

    • Fund closed in Oasis

    • Account and Cost Center are no longer valid

    Preventing Suspense Charges

    As discussed in the Causes of Suspense Charges section above, charges to the Suspense FAU are the result of invalid or missing FAUs associated with the position on the Funding Entry page in UCPath. Suspense charges are visible to UCLA Chief Administrative Officers (CAOs), Corporate Financial Services, and UCLA Leadership. Departments must develop clear, efficient, and repeatable personal and departmental processes to decrease and manage Suspense charges to avoid negative impacts.

    Some negative impacts of Suspense charges include, but are not limited to, the following:

    • Hurts UCLA’s ability to obtain future funding due to:

      • Untimely charges to sponsored funds

      • Erroneous billing and reporting

    • Over or under states other FAU balances

    • Audit non-compliance

    • Lack of adherence to UC Policies including:

      • Month-end and Year-end Closing Responsibilities

      • Policy 910

    Prevention Tools

    Suspense charges can be diminished by using proactive measures. On a regular basis, use the following tools prior to upcoming payroll processing.

    NOTE: Access to COGNOS CDW Reports is granted by your department DSA.

    Type

    Name

    Description

    COGNOS Report

    ODS Funding Reporting - No Funding Info

    This report lists positions that don't have any funding sources. If the report returns results, add a valid FAU to any position on the report via the Funding Entry page in UCPath to ensure subsequent payroll processing charges the correct funding sources.


    Navigation in COGNOS CDW: Content > Team content > UCPath CDW > Funding - Payroll Ledger - Financial > Funding > ODS Funding Reporting - No Funding Info

    COGNOS Report

    ODS Funding Reporting - Current and Future Funding

    This report identifies the FAUs currently in place for all positions. Review the report to verify the FAUs are correct for upcoming payroll processing.


    Navigation in COGNOS CDW: Content > Team content > UCPath CDW > Funding - Payroll Ledger - Financial > Funding > ODS Funding Reporting - Current and Future Funding

    Calendar

    UCPath Payroll Processing Schedule

    The UCPath Payroll Processing Schedule identifies key dates and deadlines for payroll processing that impact account charges.


    NOTE: Deadlines on the schedule are for transaction approvals, not transaction submission.


    Allow adequate time for Funding Approvers to approve changes to funding entry transactions before the deadline on the processing schedule.


    NOTE: Missing schedule deadlines may cause charges to an incorrect or Suspense FAU.

    Identifying Suspense Charges

    As discussed in the Causes of Suspense Charges section above, UCPath charges the Suspense FAU and adds a specific Project Code (e.g., FUNDNG, ENDDTE, COMBO) that signifies the issue with the position’s funding.

    Use the Relating Labor Ledger data to General Ledger Accounting Period – Salary COGNOS report to determine if the Suspense FAU was charged and the cause of the charge.

    Navigation in COGNOS CDW: Team content > UCPath CDW > UCLA Internal Reports > Funding- Payroll ledger-Financial > Reconciliation > Relating Labor Ledger data to General Ledger Accounting Period – Salary

    NOTE: This report shows the detailed salary expenses with Trans ID xxP10 (i.e., charges from Sub Codes 00, 01, 02, 05, and 07) based on the ledger accounting period and can be used to reconcile your General Ledger to UCPath salary data.

    NOTE: The date range can be run from UCPath Go Live (September 2018) through today’s date.

    To make the report effective in identifying suspense activity, perform the following:

    1. When establishing the report parameters for ledger accounting period, use the UC Accounting Date.

    2. Run the report after month end closes and run from September 2018 to the previous calendar month. For example, if today’s date is in December, run the report through November.

    3. Download the data to Excel by clicking the yellow Play button in CDW and selecting Run Excel Data.

    4. Create a pivot table with employee data and salary amount.

    5. Add a filter to the pivot table for Project Code to identify the Suspense project codes (e.g., FUNDNG, ENDDTE, COMBO).

    6. The sum of each employee’s Suspense charges should net to zero. If not, refer to the following section: Correcting Suspense Charges.

    Correcting Suspense Charges

    After identifying charges to the Suspense FAU and their causes, use the following table to correct Suspense charges.

    Project Code

    Resolution

    FUNDNG

    NOTE: Some departments have updated their Suspense FAU and removed the FUNDNG project code. As a result, it is possible your department's suspense charges will not have this project code and instead will be charged to the FAU identified as the Suspense FAU.


    To correct Suspense FAU charges with the FUNDNG project code, perform the following:

    • Navigate to the Funding Entry Inquiry page in UCPath.

    • Enter the position number into the search criteria.

    • If there are no search results for the position, this means the position does not have a funding entry; add funding to the position.

    • If the Suspense FAU appears on the Funding Entry page, the position did not have an updated funding entry prior to the Fiscal Year End Rollover process; update the funding for the position.


    Refer to the list of step-by-step guides below this table for detailed instructions.

    ENDDTE

    To correct Suspense FAU charges with the ENDDTE project code, perform the following:

    • Navigate to the Funding Entry page in UCPath.

    • Enter the position number in the search criteria.

    • Add a new effective-dated row and update the funding for the position.

    • When updating the funding, do not use the Funding End Date field.


    Updating the position funding does not correct previous charges to the Suspense FAU. You must submit Salary Cost Transfer (SCT) transactions for all pay periods where the Suspense FAU was charged. When processing the SCT, remove the ENDDTE project code and provide the appropriate FAU.


    Refer to the list of step-by-step guides below this table for detailed instructions.

    COMBO

    To correct Suspense FAU charges with the COMBO project code, determine if the existing FAU is still valid and proceed with the appropriate actions below.


    If the existing FAU is still valid, contact the Central Office Fund Manager (i.e., EFM for Contract & Grant funds or General Accounting for all other funds) and request the FAU be re-opened.


    If the FAU is no longer valid, perform the following:

    • Navigate to the Funding Entry page in UCPath.

    • Enter the position number in the search criteria.

      Add a new effective-dated row and update the funding for the position.


    Updating the position funding does not correct previous charges to the Suspense FAU. You must submit Salary Cost Transfer (SCT) transactions for all pay periods where the Suspense FAU was charged. When processing the SCT, remove the COMBO project code and provide the appropriate FAU.


    Refer to the list of step-by-step guides below this table for detailed instructions.

    Step-by-Step Guides

    Click the appropriate title to view the step-by-step guide.

    What is the "Guide Me" option to view Scribes?

    Update Funding for a Position (after Fiscal Year End Rollover)Add Funding for a PositionUpdate Funding for a PositionAdd Funding for a Position with Salary Caps or Multiple Components of PayUpdate Funding for a Position with Salary Caps or Multiple Components of PayAdd Funding for a Position with NSP and with Salary Caps or Multiple Components of PayUpdate Funding for a Position with NSP and with Salary Caps or Multiple Components of Pay