The Revenue and Fund Management (RFM) Dashboard displays information about revenue and fund management including details on fund statements, journals, transfers, fund trends, trial balances, fund variances, budget variances, budget transactions, endowments and donor pledges. 

Select this link... ...for reports about
Award at a Glance Fund overviews; Award Attributes, SU Fund Summary, EN Fund Summary, Fiscal Year Anticipated Payout Summary, SU GL Balance Trend, EN GL Balance Trend, Endowment Activity, GL Transactions and Pledge Summary.
Fund Statement Fund statement for EN & SU sets of books showing beginning balance, transactional activity and ending balance for the reporting period (similar to RM3 153, 154, 154a, 156 and 158 reports). For non-sponsored and non-capital awards.
Fiscal to Date (FTD) Fund Statement Non-customizable FTD Fund Statement for EN & SU sets of books showing beginning balance, transactional activity and ending balance (formerly the RM3 FIN_FUND_153_Fund_Statement). For non-sponsored and non-capital awards.
Award Status Fund Statement Non-customizable fund statement showing current status (FTD actuals, expense control, commitments) of projects and funds prior to year-end and during year-end close. Also provides information that will assist in the ability to fund deficits or reallocate surpluses as needed to close operating budget awards at year-end (formerly FIN_FUND_253_YTD_Award_Status report). 
Operating Statement and Clinical Trials Statement Non-customizable operating statement detail with revenues, expenditures for last month selected as well as annual revenue/expense controls (budget), fiscal year to date actuals and variances (formerly FIN_OP_101_Operating_Detail & FIN_OP_101A_SPO_Clinical_Trials_Statement).
GL Journal Details Provides General Ledger (GL) journal transaction details (similar to RM3 161, 162 and 252 reports).  
Posted Journals by Object Code (real-time) Non-customizable report displays the posted journal line detail for a single period and given PFOO (formerly the RM3 FIN_GL_161_Post_Jrnl_By_Obj_Code and RM3 FIN_GL_162_Central_Jrnls_By_Obj reports).
Transfer Summary Report Transfers of funds between awards (object codes 49100 to 49699); displays both to and from awards, projects and related attributes.
Transfer Detail Report Transfers of funds between awards (object codes 49100 to 49699); displays both to and from Awards, Projects and related attributes. 
Inactive Awards Report Shows awards with no transactional activity for the reporting period.
Fund Trend Fund statements for EN & SU sets of books showing values over time in user selectable time periods, includes line graph representations (similar to RM3 152 and 283 reports).
Operating Statement Month by Month Provides monthly operating statement summary information by award and object code, sectioned by revenue, fund transfers, expenditures, gain/loss and capital transfers. The yearly information also provides summary information on other assets and liabilities codes (formerly FIN_OP_284_Mo_By_Mo _Month-by-Month report).
Operating Statement Year by Year Provides yearly operating statement summary information by award and object code, sectioned by revenue, fund transfers, expenditures, gain/loss and capital transfers. The yearly information also provides summary information on other assets and liabilities codes (formerly FIN_OP_284_Mo_By_Mo_Year-By-Year report).
Trial Balance by Object Code (SOA) Statement of Activity (object codes beginning with 4 or 5) for the selected range of periods. Statement of Position (object codes beginning with 1, 2 or 3) for the selected range of periods (similar to RM3 163 and 164 reports).
Fund Variance Variance of two fund statements of differing reporting periods to show their values and differences (similar to RM3 238 report).
Budget Variance Variance of budget vs. actual in fund statement format showing values and differences for the reporting period (similar to RM3 165 and 166 reports).
Budget Transactions Details Budget transaction details for Budget Tool (9/1 non-sponsored operating budget), iBudget (mid year changes to operating budget) and GA Budget (sponsored activity budget) (similar to RM3 165 and 166 reports).
Endowment and Donor Endowment-related data such as investment pools, share quantities, share values, book values and market values. Donor Financial Report with gifts and endowment related data shown in the donor reporting format (similar to RM3 123 and 128 reports).
Endowment Award Summary and FTD Investment History Non-customizable summary including cumulative share balances, book value, market value and ending share value by award with fiscal year-to-date investment history (formerly the RM3 FIN_ENDOW_123_Endow_Display).
Endowment Investment Summary by Pool Non-customizable summary including cumulative share balance, book value and market value by awards within investment pools with a downloadable summary by award number (formerly the RM3 FIN_ENDOW_128_Endow_Investment report).
Pledge Report Shows pledge and pledge schedules for given awards.
Endowment Financial Dashboard Shows awards that are unused and/or underwater.

The Award at a Glance Report shows in one place a broad summary of fund management reports covering: Fund overviews; Award Attributes, SU Fund Summary, EN Fund Summary, Fiscal Year Anticipated Payout Summary, SU GL Balance Trend, EN GL Balance Trend, Endowment Activity, GL Transactions and Pledge Summary . This is a collection in one place of other reports in the dashboard. The fund statement area shows a summary across all returned awards.

Demo of Award at a Glance report within the RMF Dashboard in OBI

  • What are the awards in my organization (org), their purposes, general status and totals across my org of balances and high level inflows and outflows?
  • For specific award(s) what is their financial situation, projected payout for endowment, balances, high-level inflows and outflows?
  • Looking at the stats of an award, what numbers look unusual and what are their details when I drill into them?

The Award at a Glance Report displays report sections that show the overall financial situation for the displayed awards. There are fifteen sections: 

  • Award Attributes
  • Fund Authorization
  • SU Fund Summary
  • EN Fund Summary
  • Fiscal Year Merged Pool Anticipated Payout Summary
  • Fund Trend Graph for SU Set of Books 
  • Fund Trend Graph for EN Set of Books 
  • Endowment Shares and Market Value
  • Specific Investment (for Endowment)
  • Transfers Detail Report
  • Five Year Trend Report for SU Set of Books 
  • Five Year Trend Report for EN Set of Books
  • Pledge Summary Report 

 

 

Award attributes provide details about the setup and parameters associated with the awards or funds, such as award type and purpose codes.

Displays the fund authorization description with expanded purpose, additional instructions, other information and information source. Section is collapsed by default. Select the triangle on the left to expand.

Displays high level summary of account balance, inflows and outflows.

Displays high level summary of account balance, inflows and outflows subtotaled by year.

Displays high level summary of account balance, inflows and outflows.

Displays high level summary of account balance, inflows and outflows subtotaled by year.

For endowments only, shows current balance, payout to date, anticipated payout for the rest of the year and anticipated balance after all payout is received. If this last amount is negative then the fund is projected to be overspent at fiscal year end and expenses may need to be journaled off.

The report sections above for Fund Trend Graph for SU and EN Set of Books have a choice of these time periods for the trend columns. If showing a longer period of time, e.g., years, it is best to select broader time periods like GL Period Fiscal year since there would be so many GL Period Name values.

The GL Balance Trend Graph for SU Set of Books shows balance amounts for beginning balance, fund balance and available balance. The fund balance for one period carries forward to become the beginning balance for the next period. The available balance is the fund balance adjusted for accrued assets and liabilities, e.g., the fund balance could be reduced by uncleared advances, but the available balance amount does not carry forward to the next period but is instead calculated based on current accruals.

The GL Activity Trend Graph for SU Set of Books shows the trend for things that affect the balance, such as expenses and receipts. Drilling on a data point reveals underlying details and is useful for researching exceptional values.

The GL Activity Trend Chart for SU Set of Books shows the trend in a stacked format to highlight positive and negative influences on the balance and show the net activity amount in the form of a line graph whose scale is shown on the right side of the graph, with generally smaller values than the stacked scale on the left side.

The GL Balance Trend Graph for EN Set of Books shows balance amounts for beginning balance, fund balance and available balance. The fund balance for one period carries forward to become the beginning balance for the next period. The available balance is always zero for EN set of books (endowment values) because the endowment value is not available for spending by definition.

The GL Activity Trend Graph for EN Set of Books shows the trend for things that affect the balance, such as receipts and transfers (expenses do not exist for EN set of books as balances cannot be spent). The Net Investment value is always a negative amount equal to the fund balance so that the sum, or available balance, will be zero. Drilling on a data point reveals underlying details and is useful for researching values.

The GL Activity Trend Chart for EN Set of Books shows the trend in a stacked format to highlight positive and negative influences on the balance and show the net activity amount in the form of a line graph whose scale is shown on the right side of the graph, with generally smaller values than the stacked scale on the left side. Net Activity for EN Set of books is mostly meaningless because the convention on available balance washes out other activities.

The Subtotal by setting value changes the field displayed in the column titled in dark gray.
The Endowment Shares and Market Value shows key metrics about the EN set of books values including share quantity, share price, market value (share quantity times share price), share type and book value. Note that book value does not change except through additions to capital or in rare cases of sales of share.

Specific Investments shows the value of endowments which are temporarily held in investments outside the merged pool and are not eligible for regular endowment appreciation of value. Eventually they will be liquidated and the proceeds used to buy shares like a regular endowment.

The transfer detail report, View by Basic, provides basic details of transfers to or from the selected funds, in particular the to and from fund/award number.

The transfer detail report, view by Expanded, provides many more details than the basic report. Note that both views pull from the same set of returned data.

The above Five Year Trend reports have a Subtotal By option. Choosing one of these values changed the initial column to display the chosen field, grouping the funds by the field’s values.

The Five Year Trend Report for SU Set of Books displays values by fiscal year for the 5 years prior to the end date selected in the selection criteria. These are the ending fund values.
 
The Five Year Trend Report for EN Set of Books displays values by fiscal year for the 5 years prior to the end date selected in the selection criteria but shows the book values amounts where the values do not tend to change over time.

The pledge summary report contains pledge details, when they are known and transferred into OBI. Based on pledge number and associated name, the report shows original pledge amount, current pledge amount, pledge paid and anticipated remaining amount. These numbers should be taken as estimates only and confirmed with the Office of Development.

For additional information refer to RFM Resources in System: OBI Financial Reporting.

Note that EN set of books only exists for endowments while SU set of books exists for all funds. SU is the expendable or income value while EN is the endowment or book value. There is also a market value for EN sets of books shown in the Endowment and Donor tab. For additional information about endowments and the difference between SU and EN set of books, refer to Topic Overview: Endowments.

This report provides the Fund Statement for EN & SU sets of books showing beginning balance, transactional activity and ending balance for the reporting period. For non-sponsored and non-capital awards.

Demo of Fund Statement report within the RFM Dashboard in OBI

  • What was my SU Beginning Balance for my award(s) at X Point in Time?
  • What is my current EN Ledger fund and/or available balance for my award(s)?
  • What is my projected payout and year end balance for my endowments
  • What were the net revenues, transfers and expenses on my award(s) over a user specified period between X and Y, or P/FTD?

  

  • To retrieve results, be sure to 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 RFM common selection criteria, their associated list of values and when to use them, refer to RFM Selection Criteria List of Values.
  • Select the Last Closed GL Period or earlier. Future GL Periods do not return an available balance.
  • For a list of the RFM common selection criteria, their associated list of values and when to use them, refer to RFM Selection Criteria List of Values.
  • Using object code selection criteria from the Next section affects balance amounts so that they no longer reflect the entire fund balance.
  • Using time period selection of Beginning and Ending Period means that the beginning balance and ending balance align with the period selections. Choosing fiscal year to date means the beginning balance is 9/1.

 

The Fund Statement Report sections show key information about balances, inflows and outflows with display options by high-level and sublevel groupings. The statement detail sections show much more detail. Drilling on a summary section value returns a new tab focusing on that amount but using the details section format.  The five sections are: 

SU Fund Statement Summary

A number of options, two shown below, are available for the summary reports to choose the key column field by which to "subtotal by", and for the "view by" which changes the display to show higher or lower levels of rollups, awards or projects and even a download view matching the previous reporting system.

This view shows awards and high level rollups of object codes.

This view shows awards and high-level object code subgroups, which provide much finer differences among object code groups. The columns referring to Merged Pool only relate to endowment funds.

EN Fund Statement Summary

The EN Fund Statement Summary has the same characteristics as the SU Fund Statement Summary but only reports on endowment funds . Note that balances for for book value rather than market value.

Fiscal Year Merged Pool Anticipated Payout Summary 

Displaying endowments only, this section shows current balance, payout to date, anticipated payout for the rest of the year and anticipated balance after all payout is received. If this last amount is negative then the fund is projected to be overspent at fiscal year end after all payout is received and expenses ought to be journaled off to avoid overdraft.

SU Fund Statement Detail

A number of options are available for the detail reports to choose the key column field by which to subtotal, and for the "view by" which changes the display to show; award only or award-project with legacy or inflow/outflow options. 

This is the fund statement details which would be returned if the summary above was drilled upon. Expenditures are rolled up from the Grants Accounting module and passed as a single value per month per object code. Other journals are shown as individual transaction lines. Award-Project Legacy View is the view returned by drilling on amounts in the summary section.

EN Fund Statement Detail

The EN Fund Statement Detail report provides equivalent information for the EN Set of Books where balances reflect book value rather than market value.

 

SU and EN refer to journal ledger code aka set of books. The EN set-of-books carries the principal balances which are invested in the Endowment, and the SU set-of-books carries all other balances, including Endowment income. (Refer to Topic Overview: Endowments)

Drilling provides additional information and sometimes drilling on drills is required to answer a question, e.g. to see the Expense Request number that cleared a Net Investment balance you would need to drill on the actual amount in Fund Statement revealing an iJournal transaction and drill on the detail amount there to open the AP Inv report showing the Expense Request number.

For additional information refer to documents in the RFM section of resources in System: OBI Financial Reporting like:

  • Data Fields Available in Dashboard Tabs
  • Endowment Glossary
  • Selection Criteria List of Values
  • Object Code Rollups

Non-customizable, BI Publisher report, FTD Fund Statement for EN & SU sets of books showing beginning balance, transactional activity and ending balance. For non-sponsored and non-capital awards. (formerly the RM3 FIN_FUND_153_Fund_Statement). Equivalent to the dashboard Fund Statement report

  • What are the GL details affecting my awards?
  • What GL transactions occurred in the last month?
  • What are my balances in the GL?
  • The Selection Criteria section is located on the left hand side of the screen. Instructions are on the first tab. 
  • For additional information, refer to BI Publisher Reports
  • For a list of the RFM common selection criteria, their associated list of values and when to use them, refer to RFM Selection Criteria List of Values.
  • The GL Period Name is a required field. 
  • Use Journal ledger code = SU for expendable accounts and = EN for endowment principle accounts. An endowment fund has both SU and EN accounts while other funds types only have SU.

Fiscal to Date Fund Statement report tabs show key information about fund statement values like balances, inflows and outflows. Reports can be viewed on screen and downloaded as PDF or Excel files. There are seven different report views on different tabs: 

 If any of the report tabs and menu controls are missing, your window is too narrow. Expand the width or decrease the browser Zoom (control-minus).

For additional information, refer to RFM Resources in System: OBI Financial Reporting.

Non-customizable, BI Publisher report, Award Status Fund Statement (formerly RM3 FIN_FUND_253_YTD_Award_Status) report provides current status (FTD actuals, expense control, commitments) of projects and funds prior to year-end and during year-end close. The report also provides information that will assist in the ability to fund deficits or reallocate surpluses as needed to close operating budget awards at year-end.

  • What are my account balances, especially those in overdraft?
  • What are my variances between budget and actual?
  • What are my actual transaction totals and commitments year to date?
  • What are my balances and transaction totals for a range of GL Periods?
  • The Selection Criteria section is located on the left hand side of the screen. Instructions are on the first tab. 
  • For additional information, refer to BI Publisher Reports
  • For a list of the RFM common selection criteria, their associated list of values and when to use them, refer to RFM Selection Criteria List of Values.
  • A GL Period perspective must be entered. Choose either Fiscal Year to Date, Project to Date or both a First GL Period and a Last GL Period. 

 

This report assists in year end close processes by showing projected balances.

For additional information refer to documents in the RFM section of resources in System: OBI Financial Reporting like:

  • Object Code Rollups

Non-customizable, BI Publisher report, Operating Statement and Clinical Trials Statement (formerly RM3 FIN_OP_101_Operating_Detail & FIN_OP_101A_SPO_Clinical_Trials_Statement) report provides revenues and expenditures for last month selected, annual revenue/expense controls (budget), GL Period range actuals and variance.

  • As a Service Center org what is my break even between revenue and expense?
  • What is the reconciliation between GA and GL?
  • The Selection Criteria section is located on the left hand side of the screen. Instructions are on the first tab. 
  • For additional information, refer to BI Publisher Reports
  • For a list of the RFM common selection criteria, their associated list of values and when to use them, refer to RFM Selection Criteria List of Values.

 

Operating Statement and Clinical Trials Statement report tabs show details from both GA and GL in a single report and facilitate GA/GL reconciliation. There are seven different report views on different tabs: 

  • Award Summary
  • Detail (GL/GA Actuals with Budget)
  • Detail (GL/GA Actuas) 
  • GL Summary
  • Data Download
  • 101A SPO Clinical Trials
  • Data Download-Awards

If any of the report tabs and menu controls are missing, your window is too narrow. Expand the width or decrease the browser Zoom (control-minus).

This is the third of seven possible report views.

For additional information refer to RFM Resources in System: OBI Financial Reporting.

This report returns details of GL journal transactions. (similar to RM3 161, 162 and 252 reports).

  • Which journals have posted to my PTA?
  • Which journals filtered specific parameters (e.g., Receipts - EFP Allocations) have posted?

 

For examples of the reports available, view the screenshots below: 

For additional information, refer to RFM Resources in System: OBI Financial Reporting.

Non-customizable, BI Publisher report, Posted Journals by Object Code report displays the posted journal line detail for a single period and given PFOO. (formerly the RM3 FIN_GL_161_Post_Jrnl_By_Obj_Code and RM3 FIN_GL_162_Central_Jrnls_By_Obj reports). The primary benefit of this report is that it is real time instead of yesterday’s data.

For a given GL Period and Object Code and PTA perspective, what journals have posted to the live Oracle system (i.e., as of this minute)?

  • The Selection Criteria section is located on the left hand side of the screen. Instructions are on the first tab. 
  • For additional information, refer to BI Publisher Reports
  • For a list of the RFM common selection criteria, their associated list of values and when to use them, refer to RFM Selection Criteria List of Values

 

Posted Journals by Object Code (real-time) tabs show details of journals posted to the GL. There are six report view tabs: 

  • Journals
  • Journals(xlsx)
  • Journals w/o Orgs 
  • Journals w/o Orgs(xlsx)
  • Data Download
  • Data Download w/o Orgs(xlsx)

If any of the report tabs and menu controls are missing, your window is too narrow. Expand the width or decrease the browser Zoom (control-minus).

The data download report contains 123 columns of data about each journal transaction.
The other four report tabs are not shown here.

For additional information, refer to RFM Resources in System: OBI Financial Reporting.

The Transfer Summary Report shows transfers of funds between awards (object codes 49100 to 49699), displays both to and from awards, projects and related attributes at a summary level in a table with from and to axess at the consolidated budget category level.

Demo of Transfers report within the RMF Dashboard in OBI

At the consolidated budget category level, what are the total transfers to and from my PTA perspective?

  • To retrieve results, be sure to 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 RFM common selection criteria, their associated list of values and when to use them, refer to RFM Selection Criteria List of Values.
  • Data is pulled based on either the From or the To perspective of PTA or org.

 

For additional information, refer to RFM Resources in System: OBI Financial Reporting.

The Transfer Detail Report shows transfers of funds between awards (object codes 49100 to 49699), displays both to and from awards, projects and related attributes at a detail level, transaction by transaction.

Demo of Transfers report within the RMF Dashboard in OBI

  • What are the details of transfers to and from my PTA perspective?
  • At year end, what are the details of my transfers in and out during the month of August?
  • To retrieve results, be sure to 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 RFM common selection criteria, their associated list of values and when to use them, refer to RFM Selection Criteria List of Values.
  • Data is pulled based on either the From or the To perspective of PTA or org.

For examples of the reports available, view the screenshots below: 

If you have authority for either the from or the to side of a transfer you will be able to see the transaction based on your side and see the offsetting from or to on the same line; i.e., if your award receives a transfer you will see which award transferred it to you.

For additional information, refer to RFM Resources in System: OBI Financial Reporting.

The Inactive Awards Report shows awards which have no activity fiscal year to date; i.e., no money coming in or going out. If they have no balance and no future planned activity then they should be closed. If they have a balance and no planned use for the funds, it is advisable to find a way to spend the funds or give them back to the donor in the case of a gift.

  • Which of my awards had no activity this fiscal year to date but have a balance so I should consider spending?
  • Which of my awards had no activity this fiscal year to date and have no balance so I should consider closing?
  • To retrieve results, be sure to 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 RFM common selection criteria, their associated list of values and when to use them, refer to RFM Selection Criteria List of Values.
  • Select the Current Open GL Period or earlier. Future GL Periods do not return an available balance.

 

 For examples of the reports available, view the screenshots below:

All awards with no activity will appear in this report. Some will also appear in the Fund Statement report due to some behind-the-scenes bookkeeping activity that nets to zero (e.g., an error that is reversed) but normally the Fund Statement can’t show awards that don’t have some activity. This is why this report exists, to find and show awards that have no transactions. 
 
For additional information, refer to RFM Resources in System: OBI Financial Reporting

The Fund Trend Report Fund Statements for EN & SU sets of books showing values over time in user-selectable time periods, includes line graph representations.

Demo of Fund Tend report within the RMF Dashboard in OBI

  • If my inflows and outflows remain consistent with historical trends, how long will my funding last?
  • Are the net revenues, transfer and expenses on my award(s) trending up or down?
  • Is my balance consistently increasing or decreasing over time?

Choose values of both the View By for trend time period column settings and Subtotal By to choose the dark gray column to show a subtotal.

A similar report is returned for EN set of books but does not have expenses because the endowment principle can not be spent.

The GL Balance Trend Graph for SU Set of Books shows balance amounts for beginning balance, fund balance and available balance. The fund balance for one period carries forward to become the beginning balance for the next period. The available balance is the fund balance adjusted for accrued assets and liabilities; e.g., the fund balance could be reduced by uncleared advances, but the available balance amount does not carry forward to the next period but is instead calculated based on current accruals.

The GL Activity Trend Graph for SU Set of Books shows the trend for things that affect the balance, such as expenses and receipts. Drilling on a data point reveals underlying details and is useful for researching exceptional values. 

The GL Activity Trend Chart for SU Set of Books shows the trend in a stacked format to highlight positive and negative influences on the balance and show the net activity amount in the form of a line graph, whose scale is shown on the right side of the graph with generally smaller values than the stacked scale on the left side.

The GL Balance Trend Graph for EN Set of Books shows balance amounts for beginning balance, fund balance and available balance. The fund balance for one period carries forward to become the beginning balance for the next period. The available balance is always zero for the EN set of books (endowment values) because the endowment value is not available for spending by definition.

The GL Activity Trend Graph for EN Set of Books shows the trend for things that affect the balance, such as receipts and transfers (expenses do not exist for the EN set of books as balances cannot be spent). The net investment value is always a negative amount equal to the fund balance so that the sum, or available balance, will be zero. Drilling on a data point reveals underlying details and is useful for researching values.

The GL Activity Trend Chart for EN Set of Books shows the trend in a stacked format to highlight positive and negative influences on the balance and show the net activity amount in the form of a line graph, whose scale is shown on the right side of the graph with generally smaller values than the stacked scale on the left side. Net Activity for EN set of books is mostly meaningless because the convention on available balance washes out other activities.

For additional information, refer to RFM Resources in System: OBI Financial Reporting.

BI Publisher, non-customizable, Operating Statement Month by Month Report provides monthly operating statement summary information by award and object code, sectioned by revenue, fund transfers, expenditures, gain/loss and capital transfers. The yearly information also provides summary information on other Assets and Liabilities codes. (formerly FIN_OP_284_Mo_By_Mo _Month-by-Month).

  • What is my revenue and expense month by month by object code?
  • What are my gains/losses month by month?
  • What is my summary information about assets and liabilities?

 

The data download has 36 columns of data organized into sections for revenue, fund transfers, expenditures, gain/loss and capital transfers.

For additional information, refer to RFM Resources in System: OBI Financial Reporting.

Non-customizable, BI Publisher report, Operating Statement Year by Year report provides yearly operating statement summary information by award and object code, sectioned by revenue, fund transfers, expenditures, gain/loss and capital transfers. The yearly information also provides summary information on other Assets and Liabilities codes. (formerly FIN_OP_284_Mo_By_Mo_Year-By-Year).

  • What is my revenue and expense year by year by object code?
  • What are my gains/losses month by month?
  • What is my summary information about assets and liabilities?
  • The Selection Criteria section is located on the left hand side of the screen. 
  • For additional information, refer to BI Publisher Reports
  • For a list of the RFM common selection criteria, their associated list of values and when to use them, refer to RFM Selection Criteria List of Values.
  • A GL Period perspective must be entered. Choose either Fiscal Year to Date, Project to Date or both a First GL Period and a Last GL Period.

 

 For examples of the reports available, view the screenshots below:

The data download has 36 columns of data organized into sections for Revenue, Fund Transfers, Expenditures, Gain/Loss and Capital Transfers.

For additional information refer to RFM Resources in System: OBI Financial Reporting.

The Trial Balance by Object Code report provides a Statement of Activity (SOA) (object codes beginning with 4 or 5) for the selected range of periods or Statement of Position (SOP) (object codes beginning with 1, 2 or 3) for the selected range of periods (similar to RM3 163 and 164 reports).

  • What is my trial balance?
  • What is the variance of my Statement of Activity between two time periods?
  • What is the variance of my Statement of Position between two time periods?

For examples of the reports available, view the screenshots below:

The trial balance reports use Stanford’s institutional Object Code FS line (fund statement) rollups. 
For additional information, refer to RFM Resources in System: OBI Financial Reporting.

The Fund Variance report shows the variance between two fund statements of differing reporting periods to show their values and differences (similar to RM3 238 report).

  • How do the fund statements compare this year vs. last year of given awards?
  • Which awards have the largest percentage difference this year vs. last for receipts and expenses?
  • How large is the dollar difference of expenses between projects this summer vs. last summer?

 

For examples of the reports available, view the screenshots below:

There is an equivalent report section for EN Set of Books just not displayed here.

For additional information, refer to RFM Resources in System: OBI Financial Reporting.

Note that EN set of books only exists for endowments while SU set of books exists for all funds. SU is the expendable or income value while EN is the endowment or book value. For additional information about endowments and the difference between SU and EN set of books, refer to Topic Overview: Endowments.

The Budget Variance Report shows Variance of budget vs. actual in fund statement format showing values and differences for the reporting period (similar to RM3 165 and 166 reports).

  • How did the net revenues, transfers and expenses on my award(s) vary from budget over the period between X and Y or P/FTD?
  • What did I budget for transfers over the period between X and Y or P/FTD?
  • What are the components affecting large variances from budget?
  • To retrieve results, be sure to 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 RFM common selection criteria, their associated list of values and when to use them, refer to RFM Selection Criteria List of Values. [dummy#1349]
  • If a range of GL periods is specified rather than using Fiscal to Date or Project to Date then the third set of budget/variance amounts in the expanded view will be misleading (refer to Understanding the Date section below) as the full year budget is posted to the SEP GL Period each year. If SEP is not included then neither will the annual budget amounts.

For additional information, refer to RFM Resources in System: OBI Financial Reporting.

The expanded views show three time periods

  • Fiscal year to date has the incremental budget, i.e., the portion of the annual budget applicable up to that point in time added up month by month (after 6 months about half) and the variance is comparing months of budget to months of actual activity. The variance is likely to be very small if the year is proceeding close to the anticipated budget.
  • The last (most recent) request listed as a single GL Period compared to the budget for that single GL Period.
  • The full fiscal year budget compared to the actual activity up the requested GL Period. A report run mid fiscal year would likely show activity that is only half of the annual budget and the variance would then be equal to the remaining half of the budget, i.e., half left to go.

The Budget Transactions Details Report shows details for Budget Tool (9/1 non-sponsored operating budget), iBudget (mid year changes to operating budget) and GA Budget (sponsored activity budget) (similar to RM3 165 and 166 reports). 

  • What iBudget activity comprises the budget numbers for my award(s) over the period between X and Y, or P/F.TD?
  • Who prepared the iBudget entry that was posted against my award(s)?
  • To retrieve results, be sure to 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 RFM common selection criteria, their associated list of values and when to use them, refer to RFM Selection Criteria List of Values.
  • The annual budget, also called 9/1 budget, is stored in the SEP GL Period. If the selection criteria specify a first and last GL Period that does not include SEP then the 9/1 budget will not appear in the report.

 For examples of the reports available, view the screenshots below:

Budget Type Description lists the system used for entry, either iBudget for mid-year adjustments or the annual budget tool, currently Tidemark but for FY16 and earlier Hyperion Budget.

The Endowment and Donor Report shows endowment related data such as investment pools, share quantities, share values, book values and market values. Donor Financial Report with gifts and endowment related data shown in the donor reporting format (similar to RM3 123 and 128 reports).

Demo of Endowment and Donor report within the RMF Dashboard in OBI

  • How many shares do my endowment awards have by pool and share type (pure vs quasi) and what is the market share value?
  • What is the book and market value of my endowment awards?
  • What has been the trend of market value over time?
  • What is the value of my "Specific Investments" now and over time?
  • What is the high level overview of my endowments for the Donor Endowment Financial Report?
  • For additional information, refer to RFM Resources in System: OBI Financial Reporting.
  • Specific Investments shows the value of endowments which are temporarily held in investments outside the merged pool and are not eligible for regular endowment appreciation of value. Eventually they will be liquidated and the proceeds used to buy shares like a regular endowment.

Non-customizable, BI Publisher report, Endowment Award Summary including cumulative share balances, book value, market value and ending share value by award with fiscal year to date investment history (formerly the RM3 FIN_ENDOW_123_Endow_Display).

What are the fiscal YTD details of my endowments?

  • The Selection Criteria section is located on the left hand side of the screen. Instructions are on the first tab. 
  • For additional information, refer to BI Publisher Reports
  • For a list of the RFM common selection criteria, their associated list of values and when to use them, refer to RFM Selection Criteria List of Values.

For examples of the reports available, view the screenshots below:

There are also Excel data download versions of these two reports.

For additional information, refer to RFM Resources in System: OBI Financial Reporting.

Non-customizable, BI Publisher report, Endowment Summary including cumulative share balance, book value and market value by awards within investment pools with a downloadable summary by award number (formerly the RM3 FIN_ENDOW_128_Endow_Investment).

What are the share values of all the investment pools by pool type code for any GL Period?

  • The Selection Criteria section is located on the left hand side of the screen. Instructions are on the first tab. 
  • For additional information, refer to BI Publisher Reports
  • For a list of the RFM common selection criteria, their associated list of values and when to use them, refer to RFM Selection Criteria List of Values.

For examples of the reports available, view the screenshots below:

The download lists all pool share values but only the share quantity and market values of the returned awards. There are also individual reports by pool not shown here.

For additional information, refer to RFM Resources in System: OBI Financial Reporting.

The Pledge Report shows pledge and pledge schedules for given awards.

Demo of Pledge report within the RMF Dashboard in OBI

  • What pledges have been made to my award(s)?
  • What is the scheduled receipt of pledges made to my award(s)?
  • What is the pledge paid amount for my award(s)?

 

For examples of the reports available, refer to the following screenshots:

For additional information, refer to RFM Resources in System: OBI Financial Reporting.

The Endowment Financial Dashboard Report shows awards that are unused and/or underwater (market value is less than book value).

  • Which of my endowment funds are underwater?
  • Which of my endowment funds are underutilized; i.e., are building up large balances compared to annual payout?
  • What are my endowment payout amounts and anticipated payout amounts?
  • Which of my endowments no longer have any payouts?
  • What is the ending book value and ending market value of my endowment?

For examples of the reports available, view the screenshots below:

 

  • Underwater funds are those endowments where the market value is less than the book value.
  • Unused funds are endowments where the accrued available balance from payout exceeds certain multiples of annual payout. Level 1 warning = Y means more than two times annual payout and Level 2 warning = Y means more than four times annual payout.
  • For additional information, refer to RFM Resources in System: OBI Financial Reporting.