Available Fund Balance Trends

• The Available Fund Balance Trends report displays resources available at various levels of the Financial Unit hierarchy across campus in a quarter-to-quarter and year-to-year format.
• For both the quarter-to-quarter and year-to-year views, the report displays a line graph and detailed data table presenting resources available for the Financial Units selected.
• The report only displays resources available for ‘Closed’ Accounting Periods. No data will be displayed for ‘Open’ Accounting Periods.
• For the quarter-to-quarter view, the resources available shown are based on balances as follows:
  • Qtr-1 = resources available as of Sep-XX Accounting Period
  • Qtr-2 = resources available as of Dec-XX Accounting Period
  • Qtr-3 = resources available as of Mar-XX Accounting Period
  • Qtr-4 = resources available as of 13_Jun-XX Accounting Period
• For the year-to-year view, the resources available are the balances as of 13_Jun-XX Accounting Period for a given fiscal year.
• The report can be run for any of the Vice Chancellor, School, Department, and Posting levels of the Financial Unit hierarchy.
• The report can be run for different Fund types: Contracts and Grants, Core Funds, Other Unrestricted Funds, Restricted Funds. The report can be run for a single, multiple, or all Fund types.
  • The report can also be run for a specific Posting level Fund (L6) of the Managerial Fund hierarchy.
• Internal Loan Funds 13042 are excluded from this report.

This report answers the following questions:

• What are the Total Managerial Resources Available for my Vice Chancellor? For my School? For my Department? For my Financial Unit?
• How have my Total Managerial Resources Available fluctuated from quarter-to-quarter? From year-to-year?

Respond to Prompts

Fiscal Year

1. The Fiscal Year prompt is required. Enter the desired Fiscal Year (YYYY) using the drop-down list for the prompt. Proceed to the Financial Unit prompt.

Financial Unit

1. Users can select from four levels of the Financial Unit hierarchy: VC Area, School/Division, Department, Posting Level.
2. Start with a selection from the VC Area section of the Financial Unit prompts. Your Financial Unit selection will be indicated by a blue highlight.
   1. If desired, you can select from the School section of the prompt which has automatically filtered results based on your VC Area selection.
   2. Repeat this step as necessary for the Department and Posting Level sections of the prompts to select your desired Financial Unit.
   3. To refresh Posting Level results based on your Department selection, click the button titled ‘Filter by FinUnit L4 Selection’.

Fund

1. The Fund prompt is optional. Users may choose from either Managerial Fund L3 or L6 only, or the user can leave both prompts unselected to run the report for ‘All Funds’.
2. Users can select from four types of the Managerial Fund L3 hierarchy: Contracts and Grants, Core Funds, Other Unrestricted Funds, Restricted Funds.
   1. The report can be run for a single, multiple, or all Fund types.
   2. The report can also be run for single or multiple Posting level Funds (L6) of the Managerial Fund hierarchy.

Project Department Reporting Category

1. The Project Department Reporting Category prompt is optional.
2. Users can select from three options of the Project Department Reporting Category: Department Portfolio, Faculty Portfolio, No Reporting Category.
   1. The report can be run for a single, multiple, or all Project Department Reporting Category options.

Once all Prompt selections are complete, click Finish to generate the report.

The report output displays 2 separate tabs which can be selected at the bottom of the report:

• Quarter-to-Quarter
• Year-to-Year

To export the report in PDF, Excel, or CSV, click on the down arrow next to the play button and select your desired output.

Refer to the Data Glossary under Get Started on the main BI & Financial Reporting Blink menu for searchable data descriptions and usage rules.