Finance Reports

iReports

Data Source: Banner
Function: Student Receivables
Navigation: iReport > General Operating Reports > SIS Monthly Activity

Show entries

Search:

Report Name	Description
Banner Billing Receivables - New Activity	Shows current month’s activity that was billed by the department. Departments should review and compare to general ledger to ensure that all charges billed on
Banner Billing Receivables - Outstanding	Lists charges that are still outstanding and have not been paid by account, detail code, amount, and date billed. Departments should review these accounts.
Banner Billing Receivables - Recently Paid	Lists bills that were paid that month by account, charge billed, and amount.
Course Material Fee Reconciliation	Lists all Course material fees Assessed by quarter, College, Subject, Course, COA value, and students. Generated at 3rd week each quarter.
Course Material Fees Rate Tables	Lists Course material fees by Quarter for each College, Subject, Course, COA value that will be billed. Generated Fall - Aug 1, Winter - Nov 1, Spring - Feb. 1, and Summer June 1
Dept Chargeback Report	Lists accounts and charges by bill type and department that will chargedback (reversed) and not collected.

Showing 1 to 6 of 6 entries

Data Source: Concur
Function: Travel and Expense
Navigation: iReport > General Operating Reports > Concur Departmental Reports

Show entries

Search:

Report Name	Description
Card Aging	Displays all outstanding charges (older than 30 days from the charge date) for PCard and T&E Cardholders, both those that are assigned and unassigned to an Expense Report. This report is a monthly Concur report that details aging card transactions: card transactions not assigned to an expense report as well as status of transactions that have been assigned to an expense report.
Concur Approved Cards	This report gives a weekly output of the approved Card Type (T&E Card or PCard) by department. This includes legacy PCard holders, the last four card numbers, the Name on Card, Card Provider status (Account Cancelled, Account Active, etc.), and more!
Concur Expense Allocation Details	Monthly output of Concur that displays Concur Expense Reports by month, by department, that are pending, submitted, and/or completed (paid), including distribution and allocation details.
Concur Expense Details	Displays by Department all Concur Expense Reports to date that are submitted and/or completed (paid). This report gives department support teams better visibility into the status of expense reports associated with their unit. This report gives a daily output of Concur expense details for department review.
Concur PCARD Expense Details	This report shows Concur PCARD Expense Details.

Showing 1 to 5 of 5 entries

Financials Web Reports

Data Source: Oracle Budget & Financials
Function: Pre-run Monthly Financial Reports
Navigation: Financials Web Reports

Show entries

Search:

Report Name	Description
Financial Transaction Detail Reports	This is the official departmental general ledger. Departmental ledgers reconciliations must be based on this report. This report provides detailed transactional information on the Budget, Actuals and Encumbrance ledgers for a given COA combination with subtotals at the Budget Category level.
PO Encumbrance Reports	Provides PO encumbrance balances by PO, supplier, and COA.
Prime PI Summary Reports	Provides Summary (project level) and detail (expenditure category level) budgets commitments and expenses with views by Principal Investigator or Department.* *Available as a pre-run report in September. Users can run the report in Oracle Financials, under Reports and Analytics, until the report is published on a monthly basis.

Showing 1 to 3 of 3 entries

Oracle Budget

Show entries

Search:

Report Name	Description
Activity Summary for Expenses	This report compares budgeted expenses to actual expenditures for activities within your organizational structure.
Activity Summary for Expenses Multiple Selection	This report compares budgeted expenses to actual expenditures for activities within your organizational structure, with the option to select multiple activities.
Activity Summary for Expenses with Flex Detail	This report displays expense budget to actuals for activities within your org structure with the option to filter by Flex codes.
Activity Summary for Revenue and Expense with Flex Details	This report provides detailed information on both revenue and expense budgets compared to actuals, categorized by activity, using Flex Detail. You will see the specific revenue that you manage and own.
Budget Model Values	This report lists the Chart of Accounts (COAs) for which the budget office has made adjustments in the budget model column across three scenarios: temporary budget, permanent budget, and target budget. The values should correspond with the backup provided by the budget office.
Budget Process- Perm Budget	This report displays the Chart of Accounts (COAs) with permanent (PERM) budgets according to the budget process PERM budget projection form. We are using a snapshot of the FY24 PERM budget as the base, so the reports will show at least that value plus any projections.
Budget Process- Temp Budget	This report lists the Chart of Accounts (COAs) for which you have entered credit and debit entries in the direct input TEMP budget process form. This will distribute budget rollover in the new year and activate COAs.
Budget Requests Report by Fund	This report displays the Chart of Accounts (COAs) impacted by approved budget requests in execution, distinguishing between temporary (TEMP) and permanent (PERM) allocations. The details of the budget requests that make up these numbers must be reviewed in the Budget Request for BE module; this report only shows the amounts. Additionally, this report allows sorting by FUND.
Budget Requests Report	This report displays the Chart of Accounts (COAs) impacted by approved budget requests in execution, distinguishing between temporary (TEMP) and permanent (PERM) allocations. The details of the budget requests that make up these numbers must be reviewed in the Budget Request for BE module; this report only shows the amounts.
Carryfoward Report*	This report displays a three-year view of rollover data by organization and department fund group details.

Showing 1 to 10 of 39 entries

Oracle Financials

Show entries

Search:

Report Name	Description	Central Office / Department Use
AAC Conflict Results	/shared/Custom/UCR/Reports/Risk Management	Central Office
Award Projects Aging Report (Email Notification)	Provides a list of awards and projects that are expired will be expiring within the number of days selected. This will also be scheduled to notify department analysts and PI’s of awards expired, expiring in 60 or expiring in 90 days	-
Central Office Supplier_Payee Operational Report	This report contains filters for supplier/payee name and number. /shared/Custom/UCR/Reports/Supply Chain/Procurement/BI	Central Office
Changes in Budget and Award Status Report (Email Notification)	Scheduled daily to notify department analysts, plant manager, central accounting of awards approved and budgeted or where a budget was updated.	-
ePay and Guest Traveler Supplier API Exception Report	This report contains filters for supplier/payee name and number. /shared/Custom/UCR/Reports/Supply Chain/Procurement/BI	Central Office
Equipment/Capital Expenditure report	This report contains filters for accounting year and COA values. /shared/Custom/UCR/Reports/Financials/Fixed Assets/OTBI	Central Office
Expense Detail Report	Provides the details of all expenses incurred by award organization/PI	-
Prospective Supplier_Payee Status Summary Report (Department)	This report contains filters for Supplier/Payee name and number. /shared/Custom/UCR/Reports/Supply Chain/Procurement/BI	Department
UCR Agency Financial Report	This report contains filters for award number, to date, direct questions to name, interim or final, and direction questions to contact email. /shared/Custom/UCR/Reports/Projects/BI	Central Office
UCR Agreement Usage Report	This report contains filters for Procurement BU, Supplier, Buyer, Agreement, Status, Date from, Date to, and include closed documents. /shared/Custom/UCR/Reports/Supply Chain/Procurement/BI	Central Office

Showing 1 to 10 of 57 entries

Looker

Structure: Looker is a reporting tool that contains multiple data sets. It can be used to filter, sort, analyze, and export data.
Resources: eLearning and Guide

Show entries

Search:

Data Source	Description
Finance	Contains information that was previously in UCRFSTotals
Payroll Distribution	Contains information that was previously in SuperDope

Showing 1 to 2 of 2 entries

Impact23

Finance Reports (Go to Reports)

BUSINESS AND FINANCIAL SERVICES