The CER dashboard displays expenditure details using data from Oracle Grants Accounting (GA), iJournals, Consolidated Budget (Hyperion/Tidemark), iBudgets, GA Budgets (Sponsored and Capital Projects) and Hard Commitments. The dashboard provides details on expenses that have been incurred over a period of time for analysis, reconciliation and comparison to plan.

Select this link... ...for reports about
Expenditure Balance Summary and detail on budgeted vs actual expenditures with the remaining balance. Hard commitments can be optionally included to calculate a projected remaining balance
Monthly Expenditure Details Statement Non-customizable, BI Publisher summary of fiscal-to-date/project-to-date (FTD/PTD) expenditures containing details of the latest month, with budget, commitment and remaining balance (formerly the RM3 FIN_EXP_285 report).
Expenditure Award to Date and Award Detail Summarized report of budget, actual expenditures, prepaid expenses and commitments (equivalent to the RM3 FIN_EXP_179).
Expenditure Trend Summary and detail of expenditures pivoted by time periods such as GL period, fiscal quarter and fiscal year.
Expenditure Variance Summary and detailed comparison of total expenditures incurred between two ranges of dates.
Expenditure Details Summary and detail of total expenditures for the fiscal year to date, project to date or between any two GL Periods
Expenditure Details Data Download Expenditure Details Data Download with the exact same fields and sequence as in RM3 279 download report (formerly the FIN_EXP_279).
Sponsored Awards Actual Expenditures - by MTDC, Exclusions, Indirect Expense Sponsored Awards Expenditure amount by MTDC (equivalent to the RM3 FIN_EXP_109).
iJournals Summary and Detail including approval history for feeder and iJournal transactions.
Commitment Details Expenditure Hard Commitment (requisitions, purchase orders (POs), invoices and salary) transaction details.

 

Displays budget, expenditures and remaining balance as of the specified GL Period for the Fiscal Year to Date or Project Year to Date based on your selection criteria. Hard commitments can be optionally included to calculate a projected remaining balance. 

Demo of Expenditure Balance reports within the CER Dashboard in OBI

  • Are actual to date expenses in alignment with the annual budget?
  • What is the projected remaining balance, with or without commitments?
  • What are the actual expenditures affecting large variances from budget?

To retrieve results, follow the Selection Criteria instructions near the top of the screen. Refer to Using Selection Criteria for OBI Reports for more guidance.  

  • For Include Budget Sources, the Budget Management Tool refers to Tidemark and Hyperion, Grants Accounting refers to sponsored project budgets and capital project budgets, and iBudgets refers to mid year adjustments created in the iBudgets system.
  • Commitments data is only returned if the ending GL Period requested is the last closed or current open period. 

For a list of the CER common selection criteria, their associated list of values and when to use them, refer to CER Selection Criteria List of Values.

Expenditure Balance Summary

The Expenditure Balance Summary is a pivot table that displays summarized expenses for the period specified; shows summarized expenses to budget for FTD or PTD; and calculates the balance and percentage of budget consumed. The summary will provide total salary expenditures, even if you do not have salary access. Refer to the following screenshots.

 

  •  To include hard commitments to show projected expenditures, balances and budget consumption, use the Budget with Expenditure and Commitment view.
  • For reconciliation by PTA, use the Expenditure Reconciliation view.

Expenditure Balance Details

The Expenditure Balance Details section displays the detailed expense data that supports the summary reports listed above. If you do not have salary access, salary detailed data will not be included. In this section, you can include the column Expenditure Transaction Long Description to see the full business purpose and PO description. Refer to the following screenshots.

 

For reconciliation with your Expenditure Detail report, choose the GL Period Names for your selection criteria and use the Expenditure Reconciliation view.

When exporting the Expenditure Balance Details by PTAE data into a csv file, the data in the fields Expenditure Item Account Reference Text and Expenditure Item Department Reference Text will be hyperlinks, as these are drillable fields in the report. To retrieve the actual reference text, use the fields Expenditure Item Account Reference Plain Text and Expenditure Item Department Reference Plain Text when analyzing your data.

Non-customizable, BI Publisher summary of Fiscal-to-Date(FTD) and/or Project-to-Date (PTD) expenditures containing details of the latest month, with budget, commitment and remaining balance. This report is similar to the RM3 FIN_EXP_285 report.

  • Are actual to date expenses in alignment with the annual budget?
  • If hard commitments are included, what is the projected remaining balance?
  • What are the actual expenditures affecting large variances from budget?
  • The Selection Criteria section is located on the left hand side of the screen. Make sure to fill in an award number or replace the XXXXX with a % wildcard if you are using other selection criteria. You must enter a date parameter near the bottom, either Fiscal-To-Date, Project-To-Date or Period Begin and End Date
  • For additional information, refer to BI Publisher Reports

You can select All Detail (salary and non-salary), Non-Salary Detail or Compensation by Person.

Summarized report of budget, actual expenditures, prepaid expenses and commitments (equivalent to the RM3 FIN_EXP_179). This report is owned and supported by the Office of Research Administration. 

  • What are the actual to date expenses for a principal investigator’s (PI’s) portfolio of awards and what are the remaining balances with respect to their budgets?
  • When factoring hard commitments, what are the projected remaining balances?

 

The Expenditure Award to Date Expenditure and Award Detail report displays summarized budget compared to actual expenditure by award.

  • For sponsored and plant accounting awards, budget (column A) and actual expenditure (column B) will be Project-to-Date.
  • For non-sponsored awards, budget and actual expenditure will be Fiscal-to-Date. A graph of budget and actual expenses over time is displayed by individual award. 

Summary and detail of expenditures by time periods such as GL period, quarter and year. It allows you to analyze changes in expenditures over time.

Demo of Expenditure Trend reports within the CER Dashboard in OBI

  • What was the spending pattern for my organization, award or PTA over the periods specified?
  • What are the patterns in my expenditures over time (e.g., trending up, trending down, erratic)? By Expenditure High Level Group? By Tasks within my Award?
  • Are there unusual expenditures in this period (e.g., fiscal quarter, fiscal year) compared to the same period last year and what are the sources?
  • What is my rate of spending for the period specified (e.g., burn rate)?
  • What are my PIs expenditures by year for the last 3 years?

To retrieve results, follow the Selection Criteria instructions near the top of the screen. Refer to Using Selection Criteria for OBI Reports for more guidance.

 

For a list of the CER common selection criteria, their associated list of values and when to use them, refer to CER Selection Criteria List of Values

The Expenditure Trend reports allow you to view in summary and detail expenditure amounts grouped in columns by the time period you specify, allowing you to analyze changes in expenditures over time.

Expenditure Trend Summary

The Expenditure Trend Summary section is a pivot table that displays summarized expenses for the time range you specify, allowing you to analyze changes in expenditures over time. 

 

Expenditure Trend Detail

The Expenditure Trend Detail section displays more detailed expense data that supports the Expenditure Trend Summary. 


  • These reports can be run for any range of period, even across fiscal years.
  • You can view by fiscal period, fiscal quarter and year, calendar quarter and year and project or fiscal year to date. 
  • The two reports can be viewed using the same or different period buckets.

 

View and compare actual expenditures for any two General Ledger (GL) period ranges by amount and percentage.

Demo of Expenditure Variance reports within the CER Dashboard in OBI

  • What are my actual expenditures in this quarter compared to the same quarter last year?
  • What are my actual expenditures in this time period (e.g., fiscal month, fiscal quarter, fiscal year) compared to another time period?
  • How do my expenditure totals to date compare to the previous year's totals?
  • What are the largest sources of variances that require further analysis (for example, for high-risk expenditure categories)?

To retrieve results, follow the Selection Criteria instructions near the top of the screen. Refer to Using Selection Criteria for OBI Reports for more guidance.

Values must be entered for all four date period prompts. The first date range must be earlier than the second date range for the report to run properly.

For a list of the CER common selection criteria, their associated list of values and when to use them, refer to CER Selection Criteria List of Values.

The Expenditure Variance reports allow you to compare the summary and detail expenditure amounts incurred between the two date ranges entered. The calculated variance amount and variance percent are displayed. 

Expenditure Variance Summary

The Expenditure Trend Summary section is a pivot table that displays summarized expenses for the time ranges you specify, allowing you to compare expenditures and calculates the variance.

 

Expenditure Variance Detail

The Expenditure Trend Detail section displays more detailed expense data for the two time periods for comparing and variance analysis.


 For both reports, comparison can only be done between two date ranges, and not between different organizations, PTAs or SPOs. 

For a list of fields available to include in report customizations refer to Data Fields Available in CER Dashboard.

To understand how expenditure types roll up into higher level groupings and how they compare object codes and Tidemark rollups, refer to CER Expenditure Type Roll-ups.

The Expenditure Details report contains details on expenditures within a range of GL periods. This report can be used for expenditure review and reconciliation.

Demo of Expenditure Detail reports within the CER Dashboard in OBI

  • What has been charged to my PTAs?
  • What are my total expenditures across organizations for a parent organization?
  • What are my actual expenditures by expenditure type or expenditure category? Award type? Award or SPO number?
  • What are my actual expenditures by task manager or task/award owner (PI)?
  • Which of my task managers has the largest expenditures in a high-risk expenditure category (e.g., travel/entertainment/food)?
  • What are the transactions that I need to reconcile by source system?

To retrieve results, follow the Selection Criteria instructions near the top of the screen. Refer to Using Selection Criteria for OBI Reports for more guidance.

  • Transactions displayed can be for Fiscal Year-to-Date, Project-to-Date or between a Beginning and Ending Period. Last Closed designates the most recent closed fiscal period. 
  • Expenditure Transaction Source Long Name allows you to select expenditures related to the type of transaction or module interface. You can further refine your search by entering specific text in Expenditure Item Account Reference Text or Expenditure Item Department Reference Text. For more information, refer to the Oracle Reference Code Table.  Using these selection criteria fields affects only the data displayed in the Expenditure Detail by PTAE section and will not affect what is displayed in the Expenditure Summary report section.

For a list of the CER common selection criteria, their associated list of values and when to use them, refer to CER Selection Criteria List of Values

Expenditure Summary

The Expenditure Summary report is a pivot table that displays high level totals for the date range selected. It subtotals by Expenditure High Level Group Description by default, but you can select other aggregate levels to summarize the expenditures. The summary will provide total salary expenditures, even if you do not have salary access.  Refer to the following screenshot.

By selecting one of the Consolidated Budget Reporting CoA levels, you can summarize your expenses to the same level needed for the university budget tool.

Expenditure Detail by PTAE

The Expenditure Detail by PTAE report displays the detailed expense data by Project-Task-Award-Expenditure (PTAE) that supports the Expenditure Summary report.  Each expenditure line will typically have one or more fields that you can drill on to find additional details about the transaction. If you do not have salary access, salary detailed data will not be included.  Refer to the following screenshots.

You can include the column Expenditure Transaction Long Description to see the full business purpose and purchase order description.

 

Table view allows you to easily export the report section into an Excel file that will have the same columns as displayed.

The legacy view contains columns in the same sequence as the RM3 FIN_EXP_279 report.

This  view summarizes salary expenses by Job Classification Subtype Code and Job Classification Codes.

When exporting the expenditure details by PTAE data into a csv file, the data in the fields Expenditure Item Account Reference Text and Expenditure Item Department Reference Text will be hyperlinks, as these are drillable fields in the report. To retrieve the actual reference text, use the fields Expenditure Item Account Reference Plain Text and Expenditure Item Department Reference Plain Text when analyzing your data. 

Expenditure Details Data Download has the exact same fields and sequence as in the RM3 FIN_EXP-279 download report.

  • What is my expenditure data in a format suitable for external analysis that I can also merge with external data?

To retrieve results, follow the Selection Criteria instructions near the top of the screen. Refer to Using Selection Criteria for OBI Reports for more guidance.

 

For a list of the CER common selection criteria, their associated list of values and when to use them, refer to CER Selection Criteria List of Values.

The expenditure details data download is intended for external analysis (in tools such as Excel) and returns the exact same 57 columns of data (in the same column order) as the legacy RM3 FIN_EXP_279 Transaction Details Report data download. 

  • Some column names are slightly different from the RM3 FIN-EXP-279 report.
  • It uses the abbreviated expenditure transaction description field, which is limited to 30 characters like the legacy report.
  • Salary data will not be returned to users who do not have salary view authority for a PTA.

Displays the Modified Total Direct Costs (MTDC), along with the exclusions and indirect expenses associated with a sponsored PTA.

  • What was the modified total direct costs, exclusions and indirect expenses associated with sponsored research last year?

To retrieve results, follow the Selection Criteria instructions near the top of the screen. Refer to Using Selection Criteria for OBI Reports for more guidance.

 

For a list of the CER common selection criteria, their associated list of values and when to use them, refer to CER Selection Criteria List of Values.

Sponsored Awards’ Actual Expenditures reports allow you to see the modified total direct costs (MTDC), exclusions and indirect expenses associated with a sponsored project PTA.  Refer to the following screenshots.

For more information on MTDC, exclusions and indirect expenses, refer to DoResearch 15.1 Facilities and Administrative (Indirect Cost) and Fringe Benefits Rates.

This report provides details of iJournals in any range of GL Periods.

Demo of iJournals report within the CER Dashboard in OBI

  • Which journals posted in a specified period?
  • What are the iJournals including manual and feeder journals for a time period?
  • Where is my journal in the approval process?

To retrieve results, follow the Selection Criteria instructions near the top of the screen. Refer to Using Selection Criteria for OBI Reports for more guidance.

 

For a list of the CER common selection criteria, their associated list of values and when to use them, refer to CER Selection Criteria List of Values.

The iJournal reports allow you to view summary, detail and approval history for iJournals in the range of GL periods that you specify. This also includes iJournals that have not yet been posted. Refer to the following screenshots.

This report provides details on hard commitments for salary, requisitions, purchase orders and AP invoices.

Demo of Commitment Detail reports within the CER Dashboard in OBI

  • What are my hard commitments?
  • What were the commitments as of a prior time period?
  • What are the outstanding commitments as of today?
  • What are my committed future expenses?
  • What are the commitment details by type (salary, requisition, PO, Accounts Payable (AP) invoice)?

To retrieve results, follow the Selection Criteria instructions near the top of the screen. Refer to Using Selection Criteria for OBI Reports for more guidance.

Commitment data is only returned if the ending GL Period requested is the Last Closed or Current Open period.

For a list of the CER common selection criteria, their associated list of values and when to use them, refer to CER Selection Criteria List of Values.

The Commitment Details report shows commitments in based on type:  Salary, Requisitions, Purchase Orders and AP Invoices.  Refer to the following screenshots.