Impact23

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.
  Concur Approved Cards	Displays 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.
  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.

• 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
  All Funds Summary	This report allows you to view fund budget, expense, encumbrance, and balance detail by COA with subtotals at the fund-function-activity combination level. This report allows you to see all funds at once.
  Activity Summary	This report allows you to view fund budget, expense, encumbrance, and balance detail by COA with subtotals at the activity level. This report allows you to select an activity or see all activities at once and will show all funds.
  Carryforward Report	*Could potentially be renamed Rollover Report* This report shows the rollover balances for the last 3 years at consolidated activity and fund viewpoints.
  Deficit Analysis Report	This report shows only Activity/Fund/Function combinations that have a negative balance (deficit) at the total BC level.
  Deficit Analysis with Flex Detail	This report shows only Activity/Fund/Function combinations that have a negative balance (deficit) at the total BC level and includes flex values in the details.
  Expandable Fund Summary	This report allows you to view the fund budget, expense, encumbrance, and balance detail at the highest level by Fund and BC with the option to expand down into the function and activity nodes. This report is useful for orgs that like to see total function balances quickly. (Must be viewed in HTML to be expandable).
  Faculty Non-Project Portfolio Report	This report is based on the Flex 2 dimension. It provides an overview of Faculty balances by Fund.
  Fund Summary by Activity	This report allows you to view fund budget, expense, encumbrance, and balance detail by COA with subtotals at the fund-activity-function combination level. This report allows you to see only one fund at a time. But you can view all orgs at once as well.
  Fund Summary Report	This report allows you to view fund budget, expense, encumbrance, and balance detail by COA with subtotals at the fund-function combination level. This report allows you to select a fund or see all funds simultaneously.
  Staffing Position List Detail	This report provides workforce details by COA of filled positions and unfilled positions to have a sum of total staffing by employee and job code detail.
  Staffing Summary	This report provides workforce details by COA of filled positions versus unfilled positions to have a sum of total staffing and compare that sum to Total Budget in financials sub-totaled by activity. You can filter down to the COA level or view it from any level of the activity tree including campuswide. This forces you to select a BC so that you only see one BC at a time.
  Variance Report for Expense	This report shows the variance between budget and actuals. You must select between final or OEP working budget and the report sorts by activity fund combination. You can select any level of the ORG tree. When viewed in HTML, you can drill down into more detail for the function and BC detail. Only shows expense BCs.
  Variance Report for Expense - Expandable	You must select between final or OEP working budget. The report sorts by activity fund combination. You can select any level of the ORG tree. When viewed in HTML, you can drill down into more detail for the function and BC detail. Only shows expense BCs.
  Variance Report for Revenue	This report shows the difference between budget and actuals. You must select between final or OEP working budget. The report sorts by activityfund-function combination. You can select any level of the ORG tree. Only shows Revenue BCs.
  Variance Report for Revenue - Expandable	You must select between final or OEP working budget. The report sorts it by activity fund combination. You can select any level of the ORG tree. When viewed in HTML, you can drill down into more detail for the function and BC detail. Only shows revenue BCs.

   

• Oracle Financials

  Report Name	Description
  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