Finance Reports
This finance report catalog provides an easy-to-use tool for accessing go-to financial reports, including the ability to filter, search, and sort reports.
Status: A = Active, D = In Development, G = Available at go-live
Status | Source(s) | Report Name | Report Details | Report Distribution |
---|---|---|---|---|
A | Concur | Concur Expense Details | Display by Department the approved Card Type (T&E Card or PCard), the Concur Request ID, and the cardholder's first and last name. This report gives department administrators better visibility to employees in their unit assigned the T&E and/or PCard. | iReport: General Operating Reports > Concur Departmental Reports |
A | Concur | Concur Approved Cards | 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. | iReport: General Operating Reports > Concur Departmental Reports |
D | Concur | Card Aging Report | Historical report of university card transactions (charges) by cardholders considered past due. | iReport: General Operating Reports > Concur Departmental Reports |
G | Oracle Financials & Budget | Financial Transaction Detail | 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. | Google Cloud: Pre-run month end report |
G | Oracle Financials Procure to Pay | PO Encumbrance Report | Provides PO encumbrance balances by PO, supplier, and COA. | Google Cloud: Pre-run month end report |
G | Oracle Financials PPM | Inception To Date, UCR Cumulative Report Of Contracts And Grants With Encumbrances | Provides inception to date budgets, actuals and commitment by award number at project, fund and expenditure category level. | Google Cloud: Pre-run month end report |
G | Oracle Financials PPM | Prime PI Summary Report | Provides Summary (project level) and detail (expenditure category level) budgets commitments and expenses with views by Principal Investigator or Department | Google Cloud: Pre-run month end report |
G | Oracle Financials PPM | Expense Detail Report | Provides the details of all expenses incurred by award organization/PI | |
G | Oracle Financials PPM | Award Projects Aging Report | 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 | Email notification |
G | Oracle Financials PPM | Changes in Budget and Award Status Report | Will be scheduled daily to notify department analysts, plant manager, central accounting of awards approved and budgeted or where a budget was updated. | Email notification |
A | Banner | 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 | iReport: General Operating Reports > SIS Monthly |
A | Banner | 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 | iReport: General Operating Reports > SIS Monthly |
A | Banner | Banner Billing Receivables - Recently Paid | Lists bills that were paid that month by account, charge billed, and amount. | iReport: General Operating Reports > SIS Monthly |
A | Banner | 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 | iReport: General Operating Reports > SIS Monthly |
A | Banner | 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 | iReport: General Operating Reports > SIS Monthly |
A | Banner | Dept Chargeback Report | Lists accounts and charges by bill type and department that will chargedback (reversed) and not collected | iReport: General Operating Reports > SIS Monthly |
A | UCPath | Position Funding Report | This report contains current and future effective dated funding/COA distributions organized by department, employee name and position. The department code is determined by the HR department associated with the position; the FAU information associated with the position will display all funding not just COAs under the HR department. Until future effective dated funding is available in HRDW, this report will be created on or about the 1st and 15th of each month and posted in iReport. The report will be accessible to all users with HRDW or SuperDOPE roles. This report should assist users with determining the timing of COA change requests and projecting expenditures. | iReport: UCPath Local > Position Funding |
G | Oracle Budget - Financial | EPM STAFFING FROM FINANCIALS BY FAU | To see all FAUs that contain staffing details from the financials cube in EPM. You can filter down to the FAU level or view it from any level of the activity tree including campus-wide. | |
G | Oracle Budget - Workforce | EPM STAFFING FROM WORKFORCE BY FAU INCLUDES VARIANCE | To see all FAUs that contain staffing details from the workforce cube in EPM and compare to financials to show a variance. You can filter down to the FAU level or view it from any level of the activity tree including campus wide. | |
G | Oracle Budget - Workforce | EPM STAFFING FROM WORKFORCE BY FAU BC SELECTION REQUIRED INCLUDES VARIANCE | To see all FAUs that contain staffing details from the workforce cube in EPM and compare to financials to show a variance. You can filter down to the FAU level or view it from any level of the activity tree including campus wide. This forces you to select a BC so that you only see one BC at a time. Used by Central Office when balancing staffing. | |
G | Oracle Budget - Workforce | EPM STAFFING FROM WORKFORCE BY FAU EMPLOYEE JOB DETAILS | This report shows every employee that is marked as a permanent position in Workforce cube. You will be able to see details of job and employee by FAU. You can filter down to the FAU level or view it from any level of the activity tree including campus wide. |