Reports in Development

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 Personnel Report will provide individuals working on an Award (Grant-funded) project. Users can run the report by Organization, Award, Status, Type, Contract Administrator, or by a Personnel’s Role, Status, or Name. 

The report will display the Award Organization, Award Number, Award Name, Award Status, Award Type, Contract Administrator, Award Personnel Role, Award Role Status, Person Name, Person Name, Person Name, Person Start Date, and Person End Date.

OCF-7726

The UCD Project Team Members Report will provide individuals working on a Project. Users can run the report by Project Owning Organization, Project Number, Project Status, Project Type, Project Team Member Role, Project Role Status, or Person Name. 

The report will display the Project Owning Organization, Project Number, Project Name, Award Number, Award Name, Contract Administrator, Project Status, Project Type, Project Team Member Role, Project Role Status, Person Name, Person Start Date, Person End Date, and Primary Organization.

OCF-7853

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

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

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

Provides a list of projects and expenditure types.

OCF-4769 CR

The UCD PPM Cost Transfer Report provides an audit trail of cost adjustments and transfers made on projects in PPM.

This enhancement will add prompts, including:

• Accounting Period From
• Accounting Period To
• Project Number - concatenated with description
• Project Manager
• Separation of Duties Verification field

Additionally, the Parent Level will be added to the Project Owning Organization prompt.

OCF- 4245

The UCD Collections Customer Aging Report will allow users to track the status of Customer Aging activity. Report prompts will allow users to run by Collector, Customer, Award Number, Transaction Number, and Days Late and Current Amount ranges. 

There will be a Summary and Detail view. The Detail view will provide:

• Transaction Number
• Due Date
• Days Late
• Original Amount
• Promise Amount
• Disputed Amount
• Adjusted Amount
• Pending Adjusted Amount

The Faculty and Department Portfolio Report in Cognos will be enhanced with detail to support actual Expense totals.

OCF-3538

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

The UCD 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-5451

The UCD PGM Master Data Report will be enhanced to add Award Close Date, Post Reporting Period, Contract Line Number, Project Status, FFR Date, and FFR Amount fields.

OCF-6467

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.

BIDS-3612

A new and summarized version of the Faculty Dashboard PI Report. The current plan for this report is to include:

• Budget for an Award
• Balance on Award
• Available Spend on the Award
• When the funds need to be used
• Period Performance

Adding burndown rate is planned, but may be added sometime after the report is initially released. 

(Burndown rate example: if an award is for 2 years - burndown rate would indicate how much money is left to spend and how much have a spent to date on the award)

OCF-5921

The UCD Sponsored Project Receivables Report will be enhanced to add a new Credited Invoice Amount column to reflect credited invoices which are currently referenced in the Payment Amount column.

OCF-6368

This enhancement modifies the UCD GL Summary Balances Report by aligning the reporting with the Department PL and General Ledger Summary. 

The Accounting Period will be adjusted to:

• Default to the Latest Open Period
• Add the option for Earliest Open Period 

OCF-5382

This enhancement modifies the UCD Comprehensive Spend Report by adding, adjusting and moving prompts and fields.

Report prompt updates will include:

• Renamed prompts:
  • Supplier will change to Supplier Name
  • Supplier ID will change to Supplier Number
  • Charge Natural Account will change to Charge Account
  • Task (Project Number) will change to Project Task
• The Project Award prompt will be adjusted to add the concatenation of description

Report field updates will include

• Renamed fields:
  • Supplier Address Line 1 will change to Payee Name
  • Supplier Address Line 2 will change to Supplier Address Line 1
  • Charge Natural Account will change to Charge Account
• Additional report fields added for:
  • PO Line Number
  • PO Line Amount
  • PO Line Distribution Number
  • PO Line Distribution Spend Amount to Date 

OCF-4603

The UCD PPM to GL Non-sponsored Projects Reconciliation Report will be updated to:

• Remove all DKO related projects from reporting
• Remove Assets & Liabilities from GL Balances, as these are not tracked in PPM

OCF-6880