Impact23

Financial System Replacement Program

Finance Reports (Go to Reports)

  • iReports

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

    Report Name Description
    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 - 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 - Recently Paid Lists bills that were paid that month by account, charge billed, and amount.
    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
    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.
    Dept Chargeback Report

    Lists accounts and charges by bill type and department that will chargedback (reversed) and not collected.

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

    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. 
  • Financials Web Reports

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

    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.
    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.
    PO Encumbrance Reports Provides PO encumbrance balances by PO, supplier, and COA.
  • Oracle Budget
    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.
    Faculty Non-Project Portfolio Report This report is based on the Flex 2 dimension. It provides an overview of Faculty balances by Fund.
    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  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.
    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.
    Carryfoward Report* This report displays a three-year view of rollover data by organization and department fund group details.
    Defecit Analysis Report by Project Number This report presents detailed budget values for COAs where the total sum of BCs reflects a deficit, organized by project number.
    Defecit Analysis Report with Flex Detail This report provides a comprehensive overview of budget values and subtotals for COAs across all combined BCs. It identifies deficit COAs by highlighting the subtotal in red when the total sum of all BCs is in deficit, allowing for further analysis through flex detail drilling.
    Flex 2 - Faculty Non Project Portfolio Report This report showcases all available funds categorized by Principal Investigator (PI) or Flex2 code, specifically excluding those allocated to projects (non-contract and grant-related).
    Flex1 Summary Report This report illustrates the available budgets and expenditures associated with a specified Flex1 field.
    Foundation Transfers by Month This report provides a listing of COAs affected in the TEMP budget due to revenue from UCR Foundation gifts and endowments, categorized by the month when the revenue was loaded.
    Function Summary by Expense Report This report presents a summary-level comparison of budgeted amounts to actual expenditures, organized by function-program combinations.
    Function Summary by Expense Report with Flex Detail This report provides a summary-level comparison of budgeted amounts to actual expenditures, categorized by function-program combinations, with the option to drill down into flex details for further analysis.
    Fund Summary by Activity and Function Program This report offers a subtotal by fund of both budgeted and actual revenue and expenses, with the flexibility to specify activity and function-program parameters for detailed analysis.
    Fund Summary Expandable This report provides a subtotal by fund for both budgeted and actual revenue and expenses, with the capability to expand the details in HTML format for enhanced readability and analysis.
    Fund Summary Report This report presents a fund-level subtotal of both budgeted and actual revenue and expenses.
    Fund Summary Report with Flex Details This report provides a subtotal by fund of both budgeted and actual revenue and expenses, with the option to delve into flex details for further analysis.
    Grad Financial Aid Values by Month This report lists the COAs affected by TEMP or PERM interlocation transfers approved by UCOP. The breakdown is categorized by the month when the Interlocation Transfer Form (ITF) was loaded.
    ITF Values by Month This report lists the COAs affected by TEMP or PERM interlocation transfers approved by UCOP. The breakdown is categorized by the month when the Interlocation Transfer Form (ITF) was loaded.
    PERM benefit transfers This report showcases all PERM budget allocated to benefit Budget Codes (BCs) for the five core funds utilized in CBR mitigation. It delineates the sources of the PERM budget, including July 1 PERM, Intra-Org Adjustment, Budget Model transfers, and other relevant categories.
    Perm Core Benefits Report (19900, 19912, 19924, 19942, 67000) This report provides an overview of the total PERM budget alongside its detailed breakdown. Its purpose is to allow units to review all PERM budget allocated to benefit Budget Codes (BCs) for the five core funds used in CBR mitigation.
    Project Financials Analysis Report This report presents all projects within a specified organizational view, accompanied by Budget to Actual details and subtotals for each project.
    Regent Gift Values by Month This report lists the COAs affected in the TEMP budget due to revenue approved via the gift acceptance system. It categorizes the impact based on the month when the revenue was loaded.
    Staffing Detail Report This report showcases a unit's total PERM-budgeted Full-Time Equivalents (FTE) and salaries by Cost Object Account (COA), including position details.
    Staffing Detail Report by Job Code This report provides a unit's total PERM-budgeted Full-Time Equivalents (FTE) and salaries by Cost Object Account (COA), including position details, with subtotals by Job Code.
    Staffing Employee Summary Report This report presents the FTE distributions for a single employee.
    Staffing Summary Report This report presents summarized BDP data, including Full-Time Equivalents (FTE) and salaries, categorized by Cost Object Account (COA) for both filled and vacant positions. It contrasts this data against total financial execution budgets by COA to identify any imbalances.
    Variance Report for Expense This report offers a high-level overview of the total variance between the General Ledger (GL) working budget and actuals for expense Budget Codes (BCs), without including flex details.
    Variance Report for Expense with Flex Details This report provides a high-level overview of the total variance between the General Ledger (GL) working budget and actuals for expense Budget Codes (BCs), including flex details.
    Variance Report for Expense-Expandable This report presents a high-level overview of the total variance between the General Ledger (GL) working budget and actuals for expense Budget Codes (BCs), with the added option to view it in HTML format.
    Variance Report for Revenue This report provides a high-level overview of the total variance between the General Ledger (GL) working budget and actuals for revenue Budget Codes (BCs), excluding flex details.
    Variance Report for Revenue-Expandable This report offers a high-level overview of the total variance between the General Ledger (GL) working budget and actuals for revenue Budget Codes (BCs), without including flex details. It also provides the option to view the report in HTML format.
    PERM Budget Column Breakdown This report shows all PERM budget for a given POV sorted by type of adjustment.
    TEMP Budget Column Breakdown This report shows all TEMP budget for a given POV sorted by type of adjustment.

     

  • Oracle Financials
    Report Name Description Central Office / Department Use
    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 -

    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. -
    Expense Detail Report Provides the details of all expenses incurred by award organization/PI -
    UCR AP Interface Rejection Report

    This report contains no filters.

    /shared/Custom/UCR/Reports/Financials/Accounts Payable/BI

    		 Central Office
    UCR AP Report for Invoices

    This report contains filters for Invoice Creation from and to dates, Owning Department, Payables Specialist, Invoice Source, Supplier name, and Supplier Number. 

    /shared/Custom/UCR/Reports/Financials/Accounts Payable/BI

    		 Central Office
    UCR Concur AP Consolidation Report

    This report contains filters for invoice from and to dates. 

    /shared/Custom/UCR/Reports/Financials/Accounts Payable/BI

    		 Central Office
    UCR Department Report for AP Invoices

    This report contains filters for invoice creation from and to dates, owning department, payables specialist, invoice source, invoice number, supplier number, and supplier name. 

    /shared/Custom/UCR/Reports/Financials/Accounts Payable/BI

    		 Department
    UCR Invoice Approval Rejection Report

    This report contains filters for Invoice From and To Dates, Invoice Number, Supplier Number, and Supplier Name. 

    /shared/Custom/UCR/Reports/Financials/Accounts Payable/BI

    		 Central Office
    UCR Invoice Audit Listing Report

    This report contains filters for Payables Specialist, Supplier Number, and Supplier Name. 

    /shared/Custom/UCR/Reports/Financials/Accounts Payable/BI

    		 Central Office
    UCR AR Aging Report

    This reports contains filters for Receipts (Y/N), Targeted Currency, Customer Class, Business Unit, PI Name and Department, From and To Customer Name, as-of accounting date, and Aging Bucket.

    /shared/Custom/UCR/Reports/Financials/Accounts Receivable/BI

    		 Department
    Equipment/Capital Expenditure report

    This report contains filters for accounting year and COA values. 

    /shared/Custom/UCR/Reports/Financials/Fixed Assets/OTBI

    		 Central Office
    UCR Balance Sheet Transaction Details Report

    This report contains filters for the fiscal year, accounting period, account, entity, fund code, activity, and function. 

    /shared/Custom/UCR/Reports/Financials/General Ledger/BI

    		 Central Office
    UCR BE-125 Report

    This report contains filters for Payment Start and End dates. 

    /shared/Custom/UCR/Reports/Financials/General Ledger/BI

    		 Central Office
    UCR Current Fund Expenditures by Department Detail Report

    This report contains filters for the fiscal year, accounting period, and entity. 

    /shared/Custom/UCR/Reports/Financials/General Ledger/BI

    		 Department
    UCR Current Fund Expenditures by Department Summary Report

    This report contains filters for the fiscal year, accounting period and entity.

    /shared/Custom/UCR/Reports/Financials/General Ledger/BI

    		 Department
    UCR Financial Transaction Detail Report

    This report contains filters for the fiscal year, accounting period, entity, activity, function project, fund code, account, and program. 

    /shared/Custom/UCR/Reports/Financials/General Ledger/BI

    		 Department
    UCR Journal Batch ID with Lines

    This report contains filters for the accounting period name and journal user source name.

    /shared/Custom/UCR/Reports/Financials/General Ledger/OTBI

    		 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 Awards - Projects Aging Report

    This report contains filters for award number, to date, interim or final, questions to name, and direct questions to contact email. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Department
    UCR Cash Balance Report

    This report contains filters for interest rate, fiscal year and quarter. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Central Office
    UCR Commitment Details Report

    This report contains filters for award organization, award number and project number. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Department
    UCR DrawDown Report

    This report contains filters for sponsor name, PI name, award from and to, project number from and to, expenditure date from and to, and invoice status. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Department
    UCR ITD Cumulative Report

    This report contains filters for award number and as of date accounting period. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Department
    UCR Month End Exception Report

    This report contains filters from project number from and to, task number from and to, contract number from and to, transaction source from and to, and document entry from and to. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Department
    UCR PGM Capital Drawdown Report

    This report contains filters for creation from and to dates, project number, award number, sponsor name, transaction source, and funding source number from and to. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Central Office
    UCR PPM Awards IDC Listing Report

    This report contains filters for award number and award owning organization. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Department
    UCR PPM Cost Transfer Report

    This report contains filters for from and to posted date, award number, and project owning organization. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Department
    UCR PPM Expenditure Type - GL Account Discrepancy Report

    This report runs no filters. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Central Office
    UCR PPM Expense Detail Report

    This report contains filters for accounting period from and to, project number from and to, award number from and to, transaction source, supplier name, invoicing status, award organization, PI/Project manager, billable items, and prime pi. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Department
    UCR PPM Expense GL Recon Report

    This report contains filters for fiscal year, project number, and award number. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Central Office
    UCR PPM Prime PI Summary Report

    This report contains filters for award organization, Prime PI, and accounting period. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Department
    UCR PPM Revenue-GL Recon Report

    This report contains filters for period from and to, contract from and to, and project from and to. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Central Office
    UCR Project Related Fund Reservations Holds

    This report doesn't contain any filters. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Department
    UCR_PPM_Contract_Dep_REP

    This report contains a filter for department number. 

    /shared/Custom/UCR/Reports/Projects/BI

    		 Central Office
    UCR Budget to Actuals Report

    This report contains filters for award number and project number. 

    /shared/Custom/UCR/Reports/Projects/OTBI

    		 Department
    UCR Cost Detail for Billing Review

    This report contains filters for project accounting date, award type, sponsor between. 

    /shared/Custom/UCR/Reports/Projects/OTBI

    		 Department
    UCR Cost Reimbursable Invoices detail by revenue category and invoice status

    This report contains filters for award type and sponsor between. 

    /shared/Custom/UCR/Reports/Projects/OTBI

    		 Central Office
    UCR Event Based Invoices

    This report contains filters for sponsor between and award type. 

    /shared/Custom/UCR/Reports/Projects/OTBI

    		 Department
    UCR Financial Reporting Requirements Report

    This report contains a filter for month. 

    /shared/Custom/UCR/Reports/Projects/OTBI

    		 Central Office
    UCR PPM Award Funding and Budget Details by Budget Year

    This report contains a filter for award number. 

    /shared/Custom/UCR/Reports/Projects/OTBI

    		 Department
    UCR PPM Award Bill with Details

    This report does not contain filters. 

    /shared/Custom/UCR/Reports/Projects/OTBI

    		 Central Office
    UCR PPM Projects with Fund Reference

    This report does not contain filters. 

    /shared/Custom/UCR/Reports/Projects/OTBI

    		 Department
    UCR Capitalization - Budget to Actuals Report

    This report contains filters for accounting period name, project status, and project organization. 

    /shared/Custom/UCR/Reports/Projects/OTBI/Capitalization Reports

    		 Central Office
    UCR Capitalization - Costs Pending Capitalization

    This report contains a filter for accounting date to <=. 

    /shared/Custom/UCR/Reports/Projects/OTBI/Capitalization Reports

    		 Central Office
    AAC Conflict Results /shared/Custom/UCR/Reports/Risk Management Central Office
    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
    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
    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 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
    UCR AP Transcepta Exception Report

    This report contains filters for invoice date from and to. 

    /shared/Custom/UCR/Reports/Supply Chain/Procurement/BI

    		 Central Office
    UCR Campus Procure-to-Pay Report

    This report includes filters for supplier, supplier site, PO agreement from and to, Requisition creation date from and to, receiver, requisitioner, requisition number from and to, requisition status, requisition project number, requisition fund number, requisition activity, PO category from and to, buyer, and owning department. 

    /shared/Custom/UCR/Reports/Supply Chain/Procurement/BI

    		 Department
    UCR PO Encumbrance Report

    This report includes filters for business unit, organization, division, department, and activity code. 

    /shared/Custom/UCR/Reports/Supply Chain/Procurement/BI

    		 Department
    UCR Purchase Order Detail Report

    This report includes filters for owning department, purchase order from date, and purchase order to date. 

    /shared/Custom/UCR/Reports/Supply Chain/Procurement/BI

    		 Department
    UCR Requisition and PO Approval Rejection Report

    This report includes filters for the PO/Requisition number, rejection date from, and rejection date to. 

    /shared/Custom/UCR/Reports/Supply Chain/Procurement/BI

    		 Department
    UCR Supplier Business Classification Report

    This report includes filters for business unit, supplier status, supplier name, supplier number, business classification, expiration date from, and expiration date to. 

    /shared/Custom/UCR/Reports/Supply Chain/Procurement/BI

    		 Department
    UCR Supplier Registration Status Summary Report

    This report includes a "requested by" filter. 

    /shared/Custom/UCR/Reports/Supply Chain/Procurement/BI

    		 Department
    UCR Supplier Master OTBI Report

    This report includes filters for the supplier number, name, supplier type and creation source. 

    /shared/Custom/UCR/Reports/Supply Chain/Procurement/OTBI

    		 Central Office
  • 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

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