How to Run a Report from the Financial Reporting Center

Pre-Requisites

  • Review Financial Inquiries and Reports course training materials on Canvas
  • Before entering the financial management system (Oracle Cloud), ensure the following:
    • You are using Mozilla Firefox as your browser
    • ​Your pop up blocker is turned off

Logging In

  • Go to the myRutgers portal (my.rutgers.edu)
  • Click LOGIN (upper right) and enter your NetID and password
  • Choose the Cornerstone tab toward the top of the page
  • Within the “Financial” section of the page, click on Financial Management (Oracle Cloud)

Navigation

  • From the Oracle Cloud home page, click on the home icon (looks like a house) in the tool bar
  • Click on the Financial Reporting Center icon
  • Click on the Search icon (looks like a magnifying glass) in the upper right portion of the screen
  • In the “Enter search terms” box enter 021, and click on the smaller magnifying glass icon Search
  • Report 021 Management P&L by Business Line should appear
  • Double click on the report name link to open the report
  • Set the Dimensions (in the blue bar at the top) by clicking on each of them and selecting the appropriate values.  Select the values from the “Current” hierarchy.

Parameter Selection (with examples and expected results)

Parameter

Example

Accounting Period

Month within the fiscal year folder (ex. SEP-17)

Ledger

Rutgers Ledger will always be the required value

Unit

Your unit (ex. 120 – School of Law Camden CLAW)

Division

Specific Division or all (ex. 6295 – Office of the Dean)

Organization

Specific Organization or all (ex. 6435 – Office of the Dean)

Location

Specific Location or all (ex. 1000 – Camden Regional Campus)

Fund Type

Specific Fund Type or all (ex. 100 – Unrestricted Operating General)

Activity

All Activity Values

IntraUnit

Always select all IntraUnit Values

Future

Always select all Future Values

Balance Amount

Select Period Activity to see results for that month only. Select Ending Balance to see the month’s ending balance.

Ending balance is the typical choice for P&L reports. (ex. Ending Balance)

Amount Type

Use in conjunction with Balance Amount. Select PTD to see results for a particular period or choose YTD for year to date results.

YTD is the typical normal choice for P&L reports. (ex. YTD)

Currency

Select USD since the currency is US dollars (ex. USD)

Currency Type

Select Total (ex. Total)

 

If you chose all of the example parameters in brackets, the expected results should be as follows:

  • Expenses – Actual = $18,169.82
  • Expenses – Budget = $2,874,076.65

Expansion of Columns and Rows

  • Through a series of clicks on the triangle to the left of each Grandparent (then Parent) column, you can expand to the child (data enterable) values, in this case Business Line (continuing in our example, expand GP Research, then expand P Other Separately Budgeted Research you’ll see values in the child Business Lines of Other Separately Budgeted Research and Faculty Research Support).
  • Through a series of clicks on the triangle to the left of each Great Grandparent (then Grandparent, then Parent) Account row, you can expand to the child (data enterable) accounts (continuing in our example, expand GGP Total Operating Expense, Research, then expand GP Supplies & Materials, then P Office Supplies you’ll see values in the child Accounts of Office Supplies Computer and Office Supplies Postage & Shipping).

Drill Down to Details Steps

  • Click on an underlined amount within the report – preferably at a column and row child account cross section (continuing in our example, click on the 2,616.94 within the BL of Faculty Research Support and Account Office Supplies Computer)
  • In the pop up box, select Drill to Detail Balances
  • In the Search Results section, scroll to the bottom and all the way to the right and you will see the Period Activity column.  The amounts in this column will sum to the amount on your report (assuming you ran it as YTD).  By clicking on any of the amounts (in blue) you will see the journal entries that make up that balance.
  • By clicking on the Journal name (in blue) you can see details of the journal and all the lines of the journal.