Updated Campus Financial Reports and More

The Loan Fund Balances & Receivables report was updated to align with new Common Chart of Accounts (CCoA) guidelines from the Office of the President. This report is used to review loan fund balances and receivable activities recorded under the Sub Account Group Type Codes: LN - University Loan Fund and LF - Federal/University Matching Loan Fund.

UC Irvine’s Central Cashier sometimes receives customer checks that are left unclaimed. The Undistributed Check Payments Report helps campus departments locate these missing funds. It shows checks deposited and recorded in Object Code L407 that have not been distributed.

For more information, see Financial Services’ Undistributed Check Payments webpage.

This tool received two updates. First, the report filter was updated to include Invoice Dates and International Customer only. Second, developers added a report option to generate an Excel report with the following data fields: customer number, customer name, invoice number, invoice date, description, invoice amount, payment/credit amount, remaining balance, and invoice age.

UC Irvine’s Central Cashier sometimes receives customer checks that are left unclaimed. The Undistributed Check Payments Report helps campus departments locate these missing funds. It shows checks deposited and recorded in Object Code L407 that have not been distributed.

For more information, see Financial Services’ Undistributed Check Payments webpage.

The Recharges and Transfers Reconciliation Dashboard can be used to review transfers and recharge GL transactions. The most recent update added Origin Code and Object Consolidation Code to the Journal Details to help users who are reviewing recharge transactions.

This report was updated with a new toggle button that allows users to “Show/Hide Accounting Line Details” on the report page. This will help users to view org information linked to the Accounting Line tab on the KFS PCDO eDoc.

The PI Report was updated with the following changes and enhancements in recent months.

• The Organization Code prompt was added to The Budget Search page. Users can search for budgets by organization codes or roll-up organization codes.

• The Current CBR Rate link on the Budget Summary > Edit Projections > Subcategory - Benefits (BENF) page has been updated to link to Composite Benefit Rates page.

• The Award Transaction Summary Report link has been added to the 'Edit Projections' page. The link is located in the bottom left corner. When clicking the report link, the sponsor award number will automatically be transferred to the prompt page of the Award Transaction Summary Report. Users no longer need to copy and paste it manually.

• ABO Alternate PI UCInetID was added to the PI Report - Budget Summary page.

The ABO Report was also updated with several changes since the fall.

• Non-Sponsored Accounts. Removed the Project Director search box from the prompt page as non-sponsored awards do not have project directors. A note was also added at the top of the report filter box (prompt page): Award Balances for non-sponsored accounts are pulled only by Account Manager. 
• Developers also updated the Fund filter based on the Account Manager filter and added the following filters: Fiscal Officer, Account Closed Flag, Balance, and Expired Funds

• Current Overview (Sponsored). A note was added at the top of the report filter box (prompt page): Award Balances for sponsored accounts are pulled only by Project Director.
• The Actuals Drill Through for Target Recent Spending by Month was also updated to indicate the required KSAMS role for viewing salary object consolidation codes. The report now tells users the following: Please note, DS-KFS / ABO User role is needed to view salary details.