Reports in Development

The Project Expense Report will provide actual Expense detail with prompts for users to run by:

• Accounting Period, Accounting Date, and Expenditure Item Date ranges
• Project Owning Organization
• Award Number or Status
• Project Number, Type, or Status
• Task Number or Status

OCF-7222
BIDS-3757

The UCD Collections Customer Listing Report allows financial department collections agents to:

• View all customers who have unpaid invoices.
• View the list of your department's customers who have unpaid invoices.
• Determine if your department's customers are receiving invoices from other UC Davis financial departments and need to be moved into the Campus Shared Customers category.

OCF-7722

The Cognos FA Value Sets Report allows campus departments access FA Value Sets.

BIDS-2405

Allows Project Managers and Functional Users to extract all historical budget details for projects or group of projects. Use this report to compare changes over time and to ensure the GL balance for the project aligns with the PPM Project budget.

OCF-3326

The UCD Workflow Approval Report allows users to have access to historical and pending approval data. This report provides a documented trail of approvals, showing where approval is pending and who approved what and when, which supports governance and promotes transparency within the organization. The report provides approval details for REQ, PO, and INV workflows. 

Report functionality allows users to run by approver (User), approved by date ranges, workflow status, transaction or document type, and by relevant transaction (Requisition, PO, Invoice) number. Reporting output displays the approval request, created, assigned, and approved by, related date references, and transactional details and amount.

OCF-5378

This report displays the GL balance by Segments at the Parent Account A-D levels. Users can run this report by Accounting Period, any of the Entity, Fund, Financial Department, Account, Purpose, Program, Project, and Activity Segments, and/or for a certain (absolute value) Period Activity or Ending Balance range.

A future enhancement will add drill-down functionality.

OCF-7268

The UCD Award and Project Income Statement Dashboard will report all financial information for the Award and/or Project and can be used for reconciling during the Award period or to prepare for close out of an Award or Project. 

The report can be run by an Award or by a Project, displaying Budget, Revenue, Expenses, Encumbrances, and overall Net Income/Loss Balances with and without Encumbrances.

OCF-7873

The UCD GL Department PL Report aligns GL Summary Balance data with the mapping for Department PL.

OCF-5382

Displays Award, Project, and Task expense details for sponsored projects. You can search the data by date range. Use this report as supporting document for sponsored-project invoices.

OCF-4232

The PPM Sponsored Project Cost Report will display Award and Project expenditure details for Sponsored Projects. The report will allow users to run by Project Owning Organization, Award Number, Project Number, Expenditure Category, PPM Invoice Number, Invoice Status, and Expenditure Item Date and Accounting Period ranges.

OCF-7221
BIDS-3612