Available Reports

Allows you to view the funding sources and uses data across a three-year timeframe: previous year, current year, and budget year. 

See KB0010604 3-Year Sources & Uses Report.

The Account Monitor/Account Inquiry Tool displays General Ledger balances and allows you to drill through to journal entry and sub-ledger details. You can also create and save customized searches.

This tool is similar to some functions on the DS-1 (you can find chart string balances for a given period), DS-48 (you can see balances by period for a specific natural account), and DS256 (you can see year-over-year comparisons).

See KB0009756 Review GL Balances & Drill through to Sub Ledger Balances: Account Monitor/Inquire on Detail Balance.

The AE Chart of Account Segment Report in Cognos displays the value set and hierarchy for the Chart of Accounts (CoA). The report facilitates viewing the parent/child relationship between values in each CoA segment. 

This report is similar to the DS10, DS11, DS37 and DS50.

See:

• KB0010251 Run the AE Chart of Account Segment Report in Cognos
• Introduction to Data and Reporting Tools demo (at 5:45)

Run the Report

The General Ledger Interface Details Engine, or GLIDE Report, provides transaction details transferred from boundary applications to the Aggie Enterprise database. Use the report to reconcile financial data between the Aggie Enterprise general ledger and applicable subledgers.

This report is similar to the DS2 and DS212.

For more information, see KB0010222 Understanding the GLIDE Report. 

See also:

• GLIDE Reporting Demo
• Cognos and GLIDE Reports: Viewing AggieExpense, Card, Preferred Booking Program Expenses (Concur data missing from GLIDE reports)

Run the Report

Allows you to view the current approver for a given department or employee. Use the report after making department approver changes to verify that the update is correct.

See KB0010799 AggieExpense: Viewing and Taking Approval Action on Requests and Reports.

Run the Report

Displays complete details of the expense report of interest. You can search for the report using the report key, located in the upper-left corner of the reporter page.

For additional information, see KB0010827 AggieExpense: Creating an Expense Report.

Displays outstanding cash advances made in AggieExpense Request. Use the report to reconcile any outstanding cash advances after your trip concludes.

For additional information, see KB0010785 AggieExpense: Creating a Request for Travel or Cash Advance and Reconciling Cash Advances.

Run the Report

Displays outstanding Travel Card and Procurement Card transactions. Use the report to reconcile any outstanding Travel Card transactions before or after your trip.

For additional information, see KB0010840 AggieExpense: Creating a Procurement Card Reconciliation Report.

Run the Report

Allows you to look up Travel and Entertainment reports by a variety of parameters, including Division, Department, Traveler Name, Report Name, or Report Type.

For additional information, see KB0010827 AggieExpense: Creating an Expense Report.

Run the Report

Displays outstanding Preferred Booking Program transactions. Use the report to reconcile any outstanding Preferred Booking Program transactions before or after your trip.

Allows you to look up Expense Reports by a variety of parameters. Output will include the allocation (chart string) details from the report. 

For additional information, see KB0010743 AggieExpense: Allocating Accounts to Expenses.
 

Run the Report

Displays travel and entertainment-related expense data. You can use the report filters to search for expenses grouped by month and employee for an approver's designated employees.

See KB0010827 AggieExpense: Creating an Expense Report.

Run the Report

Provides a consolidated list of all users who are assigned to the Approver groups in Aggie Enterprise.

The Aggie Enterprise Department P&L Crosswalk report recreates the Department P&L report in the Aggie Enterprise Planning application to help you verify that the general ledger actuals in the Aggie Enterprise application matches the actuals data in the Planning application. Features in the report facilitate the verification process. This article describes the purpose of the report and its contents.

See KB0011340 - Aggie Enterprise Department P&L Crosswalk Report for details.

Run Aggie Expense reports in Cognos.

See related KBA for more information.

Visit the Reports Page

Allows you to share and review a rollup view of your budget plan or the most recent forecast while the plan is being developed during the annual budget cycle. You can also use the report to preserve the finalized budget for your records.

See KB0010612 Annual Budget Report.

The Applied Receipt Register Report provides customer receipt application information by business unit and accounting date for a specified period. This information can also be found within the customer Refund Receipt Report.

See KB0009634 Run the Applied Receipt Register Report.

(Asset representatives only)

Lists transactions processed on fixed assets. The report is automatically generated and emailed daily to asset representatives to notify them of their moveable asset transactions, including additions, adjustments, retirements, transfers, and any updates to the descriptive details, including descriptive flex fields. Use the report to review the asset transactions processed by the Central Equipment Management team.

See KB0009651 Run Asset Notification.

Allows you to visualize the total annual sources, total annual uses, and contract and grants expenditures data graphically. Viewing the graphical version of the data can help you check revenue and spending patterns at a glance and quickly discover anomalies.

See KB0011440 Budget Context Charts.

Allows you to view three years of carryforward data for a specific financial department so that you can identify carryforward trends, surpluses, and deficits.

See KB0010637 Carryforward Balances Report.

Allows you to view carryforward amounts by financial department. In addition, within each financial department, you can view the percent ownership by owner type and any carryforward with no ownership. Reviewing carryforward data by financial department provides a more granular view of resources for ongoing financial accountability and stewardship.

See KB0011373 Carryforward Ownership by Financial Department.

The Customer Billing History Report provides an overview of a financial department's transactions and billing activities. Reviewing the report can help identify invoices that were billed, which have been paid, and any adjustments made to the invoices.

This report replaces Decision Support report FIS408.

See KB0009611 Run the Customer Billing History Report.

Run the Report

The Customer Listing Report displays the list of customer names, account numbers, and when the accounts were established in the Aggie Enterprise database. 

See KB0011035 Run the Customer Listing Report.

Allows you to determine the financial department fund categories that require deficit plans, using actual data from the general ledger.

See KB0010626 Deficit Management Reports.

The Department Billing Report lists complete and incomplete invoices and includes transaction numbers, transaction dates, financial departments, and customer names. You use the report primarily to track and review incomplete invoices for month-end closing.

See KB0009636 Run the Department Billing Report.

Run the Report

Allows you to conduct side-by-side analysis of two data sets for a financial department and its children departments. You can select the dataset contents: fiscal year, scenario, version. You can also select one or more account categories to use for the comparison.

See KBA0011155 Department Comparison Report.

The Department P&L provides a summary of financial operations at a point in time with beginning balance, total revenue, total expenditures, and total ending balance. You can select multiple parent or posting-level financial departments and use the report to monitor the departments' financial positions and perform financial analysis.

This report is similar to some functions on the DS-1 and the DS-210.

See KB0009758 Run the Department P&L Report.

Shows actuals data from the general ledger, using Planning data categories. 

See KB0010641 Detailed Actuals Report.

This version of the Faculty and Department Portfolio Report is available in Cognos. Cognos provides additional functionality, better report performance and allows for future enhancements with data outside of Aggie Enterprise.

See KB0011932 Running the Faculty and Department Portfolio Report in Cognos

To see information about the Aggie Enterprise version of this report, please see the UCD Faculty and Department Portfolio Report.

Run the Reports

Allows you to compare the sources, uses, net position, and financial aid data for a selected financial department across three years. If the high-level comparison reveals pattern of interest or concern, you can investigate further using the detailed list of net positions by chart of account segments.

See KB0011686 Financial Aid Balances Monitor Report.

Allows you to find or report information that is otherwise not found in the abbreviated Detailed Actuals Report and run ad hoc analysis after exporting the report to Microsoft Excel.

See KB0011680 Full-Detail Actuals Report.

The General Ledger Summary Report shows department P&L data by fund categories. You can use this report to monitor the financial position of a department and perform financial analysis. Unlike the Department P&L Report, you can only select a single value for each report filter (for example, a single parent or posting-level financial department).

This report is similar to some functions of the DS-1, DS-55, and Aggie Budget Sources & Uses report.

See KB0009759 Run the General Ledger Summary Report.

Allows you to compare the funding sources and uses data in the Final version of your budget plan against the imported actuals from the general ledger for a single month and year to date.

See KB0010609 Monthly Variance Report.

The Planned Carryforward Use Report allows you to view three years of carryforward data for a specific financial department and the planned uses for the carryforward by commitment level. Use the report to analyze carryforward trends and planned uses of carryforward by ownership, type, and commitment level across the planning fund categories. 

See KB0010640 Planned Carryforward Use Reports.

The PPM Task Listing Report allows Project Managers and Functional Users to extract high-level task information for projects or group of projects. The report is accessed through Cognos.

See KB0011773 Running the PPM Task Listing Report in Cognos.

The Receivables Departmental Adjustment Approval Report shows adjustment approval status, names of the approvers, and adjustments made to individual financial transactions. You can use the report to locate previously approved or rejected invoices and for auditing purposes.

See KB0009635 AR Run and Export Receivables Departmental Adjustment Approval Report

Run the Report

Allows you to trace the sources and expenses within a selected financial department and its lower-level departments.

See KB0012081 Sources & Uses by Department Report.

Allows you to compare the funding sources and uses data in your plan against the actuals data from the general ledger.

See KB0010602 Sources and Uses Report.

Shows two views of the sources and uses data:

• Compares the funding sources and uses data in your plan against the actuals data from the general ledger.
• Compares the final funding sources and uses data against the working version of the data in your full-year plan.

See KB0011648 Sources and Uses Report (Full Projected Year Comparison).

The Transaction Listing Report lists journal entries by period, journal source, journal category and chart of account segments; also provides commitments, obligations, and actual balances. You can use the report to monitor the accuracy and completeness of GL postings, review financial transactions, and perform financial analysis.

This version of the Transaction Listing Report is available in Cognos. Cognos provides additional functionality, better report performance and allows for future enhancements with data outside of Aggie Enterprise.

See KB0012493 Cognos Run Transaction Listing Reports.

To see information about the Aggie Enterprise version of this report, refer to UCD Transaction Listing Report or UCD Transaction Listing Report - GL and Subledger Detail.

Run the Report

Displays the list of invoices associated with contracts (clinical trials, contracts and grants). The report shows the award budget, contract amount, invoice date, invoice due date, and the amount due.

Note: This report was enhanced and reissued as the UCD Sponsored Project Receivables Report in March 2025.

The UCD Award Personnel Report provides a comprehensive list of all individuals assigned to a sponsored project, along with their roles, dates, and key project details. Roles include Grants Administrators, Principal Investigators, and Project Administrators.

This report is useful for project administrators and team members to review staffing and responsibilities.

Users can run the report by:

• Organization
• Award
• Status
• Type
• Contract Administrator
• Personnel's Role
• Personnel's Status
• Personnel's Name

See KB0012583 Running the UCD Award Personnel Report.

Run the Report

Lists all collection activities in your department. You can use the report to determine whether other collection agents claimed one or more of your activities (for example, to assist when you were out of the office).

See KB0012255 UCD Collections Assigned Activities Report.

The UCD Collections Customer Aging Report allows financial department collections agents to track the status of Customer Aging activity. Report prompts allow you to run by Collector, Customer, Award Number, Transaction Number, Days Late, and Current Amount ranges. 

There is both a Summary and Detail view. 

See KB0012244 CC UCD Collections Customer Aging Report.

Provides high level and detailed Purchase Order data, including supplier and category spend. 

As of January 2025, additional report fields have been added that break out PO-level detail at the line distribution level, including PO Line Number, PO Line Amount, PO Line Distribution Number, PO Line Distribution Spend Amount to Date, and Requester.

See KB0009767 Purchasing Reports.

Run the Report

Lists capital equipment and associated financial activities. The report provides a high-level summary (beginning balance, new additions, disposals, adjustments, and ending balances) and lists detailed transactions. As a Central Account Office user or financial department user, you can use the report to ensure that movable assets are properly recorded in the Aggie Enterprise Fixed Assets subledger. 

This report replaces Decision Support reports 283, 370, and 371.

See KB0009653 Run the UCD Equipment Activity Report.

Run the Report

Lists moveable equipment assets and includes asset details, such as date placed in service, manufacturer, fund number, asset building location, useful life, and current period and accumulated depreciation. As a Central Accounting Office or financial department user, you can use the report to monitor the accuracy and completeness of the university’s moveable equipment inventory and ensure the university meets physical inventory and sponsor requirements.

This report replaces Decision Support report 375 and 379.

See KB0009582 UCD Equipment Inventory Listing Report.

The Equipment Inventory Listing Report provides a record of the university's mobile equipment assets.

See KB0009582 FA - UCD Equipment Inventory Listing Report

Run the Report

Shows all PPM activities for an individual Faculty (PI), and individual Project Manager or a project-owning organization (Financial Department).

This report is similar to the DS 325-PI Ledger Review.

See KB0009574 Run and Review the PPM Faculty and Department Portfolio Report.

Run the Report

An Accounting and Financial report that displays active gift fee, revenue, expense, and endowment accounts. You can run the report monthly for posting allocations.

The UCD GL Monitoring Report provides details of journal entries by period, journal source, journal category, and chart of account attributes to help track journal lines that cross Level D Funds or Level C Financial Departments, or where the Financial Department of the Journal Category differs from the Financial Department in any of the journal lines to ensure accuracy and policy compliance. 

See KB0010206 Run the UCD GL Monitoring Report (General Ledger Monitoring Report).

Run the Report

The UCD GL Summary Balances Report lists different balances by chart of account segment values. Use this report to help you quickly locate surplus or deficit balances and report remaining funds or funds that have shortfalls.

This report is similar to the DS-1 report.

See KB0010865 Run the UCD GL Summary Balances Report.

Run the Report

The UCD GL Trial Balance Report displays debit and credit entries for beginning balances, period activity, and ending balances that are listed by chart of account segments that you specify. You use the report to check credit and debit entries in the general ledger for accuracy and determine the correct Net Position values.

See KB0011257 Run the UCD GL Trial Balance Report.

Run the Report

(College of Agriculture and Environmental Sciences only)

Provides detailed data to be included in the mandatory annual reports you submit to the National Institute of Food and Agriculture (NIFA).

See KB0009579 Running the NIFA Report.

The UCD Payables Report assists with meaningful data that can be used to track current purchasing and payment activity and inform future purchasing decisions.

See KB0011208 SC Accounts Payable Reports

Run the Report

The UCD PGM Master Data Report provides details about PPM awards, such as award purpose, award start date, primary sponsor, award principal investigator, award organization, grant administrator, contract administrator, sponsor award number, Sponsor LOC, LOC document number, and so on. You use the report to review PPM award information to ensure all award data has been captured.

As of January 2025, the UCD PGM Master Data Report has been enhanced to add Award Close Date, Post Reporting Period, Contract Line Number, Project Status, FFR Date, and FFR Amount fields.

See KB0009577- PPM-5.06 Running the UCD PGM Master Data Report for more information.

Run the Report

The Purchase Order Aging Report is used to track the status of open Purchase Orders and to identify orders that may need to be closed due to non-fulfillment. 

See related KBA for more information.

Run the Report

Use the PPM Cost Transfer Report to review costs that were transferred from one PPM project or task to another.

Note: The Aggie Enterprise cost transfer report uses the report developed by UC Riverside. The reports you generate might not yet contain all fields that are useful for UC Davis. Future enhancements are planned to include more relevant fields. In addition, the search feature will be improved so that you can search by specific project numbers and the Project Manager name.

See KB0010195 - PPM-5.04 Run the UCD PPM Cost Transfer Report for more information.

Run the Report

Lists Department Kickout (DKO) projects and balances by chart of account segments. You can use the report to identify DKO projects that require review and transfer.

See KB0010958 Run the PPM Department Kickout Project Balances Report.

Run the Report

This report helps to identify where DKO balances reside and displays month-over-month trends for a given Fiscal Year.

See KB0011954 Running the UCD PPM Department Kickout Project Balances Trending Report.

Run the Report

The UCD PPM Expenditure Type Listing by Burden Structure Report displays a list of Expenditure Categories and Expenditure Types by Burden Structure. This report is useful for those who need to verify if a specific expenditure type is subject to burdening (indirect costs) for a given burden structure.

Users can run the report by Expenditure Type or Expenditure Category. 

See KB0012799 Running the UCD PPM Expenditure Type Listing by Burden Structure Report.

Run the Report

The UCD PPM Expenditure Type Listing By Project Report displays a list of Expenditure Categories and Expenditure Types by Project Type. Since certain expenditure types are restricted to specific project types, users can consult this report before initiating a cost transfer.

Users can run the report by Project Type, Expenditure Category, and/or Expenditure Type.

See KB0012796 Running the UCD PPM Expenditure Type Listing by Project Type Report.

Run the Report

The UCD PPM to GL Non-Sponsored Projects Reconciliation Report is used to reconcile Project balances between the General Ledger (GL) and PPM, allowing users to research discrepancies and make necessary adjustments where variances exist.  

For additional information, see KB0011609 Running the PPM to GL Non-sponsored Projects Reconciliation Report.

See also: KB0011780 Resolving GL-PPM Discrepancies in the PPM to GL Reconciliation Report.

Run the Report

The UCD Project Team Members Report provides a comprehensive list of all individuals assigned to a project, along with their roles, dates, and key project details. This report is useful for project administrators and team members to review staffing and responsibilities.

The report displays 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.

Users can run the report by:

• Project Owning Organization
• Project Number
• Project Status
• Project Type
• Project Team Member Role
• Project Role Status (e.g., Active, Inactive)
• Person Name

See KB0012550 Running the UCD Project Team Members Report.

Run the Report

This is an expanded version of the existing UCD Receivables Aging Report, adding the following details:

• Customer Account
• Bill and Ship-To information
• Transactional details
• Chart string details

See KB0012384 AR Run the UCD Receivables Aging Detail Report

Run the Report

The UCD Receivables Aging Report is designed to provide information about unpaid invoices. The report shows the list of customers and their unpaid invoices in 30-day (non-CGA) or 60-day (CGA) segments. Reviewing the report can help identify customers who might be of financial risk and allow your department to adjust revenue forecasts accordingly.

See KB0010564 AR Run and Export Receivables Aging Report KBA.

Run the Report

The Requisition and PO Activity Report allows a user to view transaction activity on a Requisition, as well as on any related Purchase Order document(s).

See related KBA for more information.

The UCD Sponsored Project Receivables Report displays the list of invoices associated with all sponsored award projects. This report has invoices initiated from PPM for Sponsored Awards, including clinical trials, and contracts and grants. The report shows the award budget, contract amount, invoice date, invoice amount, payment applied, AR adjustment, AR credits and the amount due.

See KB0011822 Running the UCD Sponsored Project Receivables Report

Lists journal entries by period, journal source, journal category and chart of account segments; also provides commitments, obligations, and actual balances. You can use the report to monitor the accuracy and completeness of GL postings, review financial transactions, and perform financial analysis.

This report is similar to the DS-2, DS54, DS-17 Object Transaction Detail reports. Note that it contains summarized transactions from subledgers. You might need to run the UCD Transaction Listing Report - GL and Subledger Detail or go to the subledger directly to see individual transactions.

See KB0009757 Run the UCD Transaction Listing Report.

Run the Report

Shows subledger and general ledger journal data with chart of account details. You can use the report to review general ledger transactions and reconcile differences between the subledger and the general ledger.

This report is similar to FISDS-2.

See KB0010829 Run the UCD Transaction Listing Report - GL and Subledger Detail.

Run the Report

The UCP-339 Distribution of Payroll Expense Report is used to view detail payroll actuals information.  Users can use the report to review and analyze detail payroll transactions as well as use the paycheck number, and fringe benefit information for cost transfers.

Instructions to run Cognos Reports.

Run the Report

Displays receipts in unapplied, unidentified, or On Account status.

See KB0009645 Run the Unapplied Receipt Register Report.