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.

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 KBA0009756 Review GL Balances & Drill through to Sub Ledger Balances: Account Monitor/Inquire on Detail Balance.

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.

For more Information, see the Introduction to Data and Reporting Tools demo (at 5:45).

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)

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.

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.

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.

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.

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

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.

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

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.

For additional information, see KB0010612 Annual Budget 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 view three years of carryforward data for a specific financial department so that you can identify carryforward trends, surpluses, and deficits.

For additional information, see KB0010637 Carryforward Balances 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.

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

For additional information, see KB0010626 Deficit Management Reports.

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.

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.

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.

This report is necessary to create a location where Projects and Grants users can easily review necessary project and award information and ensure that award creation meets standards. This will help central users look for inconsistency in the award data – to confirm quality of creation / maintenance of awards applications to generate a mandatory Sponsor Annual Report.  

See related KBA for more information.

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. 

For additional information, see KB0010640 Planned Carryforward Use Reports.

Lists 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 Run the Receivables Aging Report.

Shows invoice 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 Run the Receivables Departmental Billing Adjustment Approval Report.

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

For additional information, see KB0010602 Sources and Uses Report.

Displays Aggie Enterprise user data and access role. Central FOA teams and General Campus/DVMED/ANR business customers use the report to track, manage, and audit user access.

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.

10/10/24 - Enhancements to the report include a new prompt for Award Org and new fields for Award Org, Paid Amount, Adjustment Amount, Credit/Refund Amount, and LOC Document (letter of credit or draws). The report output is adjusted to show the report grand total and Unpaid Amount.

Provides the data required to analyze category spend, Small Business First, and 5402 Reporting ("Covered Services") compliance, and spend by time period.

See KB0009767 Purchasing Reports.

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.

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.

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.

This Federal Cash Transaction report will provide the necessary information for completing the Federal Quarterly Reports. Federal Report requires Quarterly activity in addition to Cumulative to Date detail.

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 FISDS-1 report.

See KB0010865 Run the UCD GL Summary Balances 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.

10/10/24 - Completed development and moved to Production on 10/10/24.

(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.

Allows you to review PPM award information to ensure all award data has been captured.

10/10/24 update - Enhancements to the report adds report headers, run dates, and other information to increase the usability of the report. Search prompts for Award Org and Project Org are adjusted so that parent values are also available, and search prompts are added for grand administrator and contract administrator. Other improvements are added to ensure consistency across the application and improve usability.

See KB0009577 Run the UCD GL Summary Balances 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.

Shows summary costs and budgets for individual PPM projects and tasks. You can use the report to research detailed costs on PPM projects and tasks and export transaction listing to a Microsoft Excel file.

This report is similar to the DS-2 Transaction listing report, but it will only return results for costs on PPM Projects.

See KB0009658 View Summary and Detailed Costs for Individual Sponsored and Non-sponsored PPM Projects. 

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.

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.

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.

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.

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 Trial Balances Report.