New Financial Reports

RELEASE 1.2.41 CHANGES AFFECTING THE KFS90 MANAGEMENT TAB REPORTS

Release Update: October 2022

Default Sub-Fund Group Settings

For most of the reports, the natural default is all sub-fund group types, (restricted, unrestricted, plant fund, etc.).  Where noted and highlighted, the sub-fund group of unrestricted is the default presentation.  A dialogue box will appear when you access the income statement reports listed below (#1 - #3). 

Please use the Filters button Graphical user interface, application, website

Description automatically generated and select all fund groups to revert to all sub-fund group types.

As you move from one report to another, a dialogue box will appear that will indicate the default setting for the report selected.

Reports affected:

  1. Multi-Year Income Statement
  2. Income Statement by Organization
  3. Income Statement by Month
  4. Budget versus Actuals
  5. Budget versus Actuals Variance
  6. Budget versus Actuals Scorecard

New Reports Added:

The following reports have been added to the Management tab reports in the KFS90 Management Reports:

Fund Balance by Organization - The Fund Balance by Organization lists YTD fund balances by organizational hierarchy by fund type:  Current Funds, Unrestricted – E&G, Current Funds Restricted, Loan Funds, Endowment Funds, Plant Funds, and Agency Funds. It also provides the trend between the current year fund balance and prior period fund balance.

New Features and Reporting Enhancements:

  1. New Filter Added:  Amount Type – The Amount Type filter defaults to “Year to Date Actuals”.  Also available with this filter are: “Fiscal Period Actuals” (based on the fiscal period month selected) or “Year to Date Adjusted Budget” which will populate only budget amounts for the line items listed.

Reports affected:

INCOME STATEMENT

BALANCE SHEET

Multi-Year Income Statement

Multi-Year Balance Sheet

Income Statement by Fund Type

Balance Sheet by Fund Type

Income Statement by Organization

Balance Sheet by Organization

Income Statement by Month

Balance Sheet by Month

  1. New Button Added: “Columns”

A “Columns” button has been added to select or deselect the columns appearing on the page.  See below for the reports affected.  By default, all columns are presented except for the Income Statement by Fund Type that does not present in the view, Plant, Loan, Agency, Endowment sub-fund group types.

A scrolling feature has been added so that the user can navigate horizontally through the page/table to view all the columns.

Reports affected:

INCOME STATEMENT

BALANCE SHEET

FUND BALANCE

Income Statement by Organization

Balance Sheet by Organization

Fund Balance by Organization

Income Statement by Fund Type

Balance Sheet by Fund Type

 

  1. New Columns in certain reports

In the Budgets versus Actuals report, there is a new column added to the report, “% of Prior Year Actuals”.  The calculation is YTD Actuals Variance (Current year YTD – Prior Period YTD for the selected fiscal period) divided by / Prior Fiscal Period YTD actuals.

The Multi-Year Capital Spending report now includes another column for the Income Stream account for capital expenditures that have an income stream account.

Please take note of the filters that are activated when using the KFS90 Management reports when viewing these reports, downloading the information, or preparing your analysis.

Please reach out to fds-request@umd.edu should you encounter any issues or have any questions on these changes.

The Reporting Team