Tips:

Reading the GL070 Financial Summary with Project Purpose Report

Use the GL070 Financial Summary report to see chart strings filtered by project purpose.

For example, if you want to see the financial status of designated chart strings that are set aside for faculty research, you would select "FACULTY_RSRCH" for faculty research projects from the Project Purpose prompt in Cognos. You may also select multiple purposes if you want to see more than one on the report.

Although this report was designed for administrators at the major unit level, anyone with access to Cognos BI and the approprite row-level security can run this report. Data will only be returned for chart strings you have access to view.

Contents

Step 1: Navigate to the report.

Begin in Cognos BI with Public Folders on display.

  1. Click Finance, Facilities, and Research Administration > School or Central > choose any of the following folders: Accounting Services, Budget, Facilities, Sponsored Programs Management, Supply Chain, Voyager, Budget/COA, or Monthly Financial.
  2. Click the report title to see the prompt page.

Step 2: Respond to prompts and run the report.

  1. Respond to prompts as needed to filter the report. There are no required prompts. If you enter none, the report contains all chart strings to which you have access.
    • The report will display financial information for chart strings that do not use a project # if the associated fund is selected from the fund prompt area.
    • Chart strings that use grant, agency, or plant funds (funds that start with 6, 7, or 8) have been excluded from this report.
    • You may only select up to 10 funds at a time.
  2. Click Finish. Result: the report appears in HTML or your default format.
Prompts Descriptions
  • Left Column
    • Business Unit (NWUNV)
    • Date Options
    • Fiscal Year/Budget Period
    • Accounting Period
    • Project Purpose
    • Fund
    • Optional Columns*
  • Right Column
    • Department **
    • Project Status
    • Project (ID)
    • Sort Order Prompt***

* Optional Columns. Select from a list of optional columns to include them in the report. Columns are: Benefits Budget, Benefits Obligation, Over/Under Expense Budget, Over/Under Revenue Budget, Fringe Benefit Surplus/(Deficit), Fund Description.

** Department. Enter one or multiple DeptIDs, or select a node on the department tree. The tree represents the structure of the university for financial reporting. Select the tree (As of Today) for the most recent reporting structure, or select the prior fiscal year tree to use the reporting structure from the prior fiscal year.

*** Sort Order Prompt. Specifies how the information is sorted, by Fund & Department or by Department & Fund. The report groups chartstrings by department, and your choice determines how chartstrings are sorted within each group.

Report Results

Financial information is displayed at the summarized expense and revenue (actuals and budget) level instead of the transactional detail level. Queried data starts at day one of the fiscal year and ends during the selected accounting period. If the selected accounting period is closed when the report is run, (Closed) appears in the report header.

Graphic: GL070 Financial Summary with Project Purpose report.

Column Definitions

Chartstrings and Descriptions

Indicated by Letter

Column Name

Column Description

Calculations

A

Department

Seven-digit DeptID value; the part of the chart string that identifies the unit responsible for the activity.

No calculations performed

B

Department Description

A description of the specified DeptID number.

No calculations performed

C

Fund Code

Three-digit value; the part of the chart string that that identifies the type of funding source.

No calculations performed

D

Fund Description(optional column)

The description of the fund such as General Unrestricted, or Designated

No calculations performed

E

Project Purpose

Identifies the distinct unrestricted or restricted purpose such as Libraries, Named Chair, Departmental, Center Support etc.

No calculations performed

F

Project

Unique eight-digit value; part of the chart string that links the activity to a distinct restricted or unrestricted purpose.

No calculations performed

G

Project Description

The description of the project number.

No calculations performed

Expense Budget

Indicated by Letter

Column Name

Column Description

Calculations

H

Carryforward Expense Budget

This is the amount of actuals dollars remaining from the prior fiscal year. These are not budget dollars.

No calculations performed

I

Fiscal Year Expense Budget

This is the expense budget for the chart string. This includes the base budget plus any budget adjustments that have been made.

No calculations performed

J

Total Expense Budget

This amount is the carryforward dollars from the prior fiscal year added to the expense budget for this fiscal year, which is your total amount of spending authority.

= columns H plus I

K

Benefits Budget (optional column)

This is the amount of your total expense budget that is budgeted for benefits. This amount is a subset of column I Fiscal Year Expense Budget.

No calculations performed

Expense Actuals and Balance

Indicated by Letter

Column Name

Column Description

Calculations

L

Total Actual Expenses

Total expenses posted against the chart string from fiscal year beginning through the selected accounting period.

No calculations performed

M

Total Encumbrances

Total encumbrances and pre-encumbrances posted against the chart string from fiscal year beginning through the selected accounting period.

No calculations performed

N

Total Obligation

The sum of the total actual expenses, encumbrances, and pre-encumbrances from fiscal year beginning through the selected accounting period.

= columns L plus M

O

Benefits Obligation

(optional column)

This is the amount of your total obligation that is solely benefits expense. This amount is a subset of column N Total Obligation.

No calculations performed

P

Under/(Over) Expense Budget (optional column)

This is the total expense budget including carryforward dollars minus all expenses, encumbrances, and pre-encumbrances (total expense budget minus total obligation).

= columns J minus N

Revenue Budget, Actuals, and Balance

Indicated by Letter

Column Name

Column Description

Calculations

Q

Fiscal Year Revenue Budget

This is the amount budgeted for revenue for the fiscal year. This includes the base budget plus any adjustments that have been made.

No calculations performed

R

Recognized Revenue

This is the actual revenue that has been posted for this chart string from fiscal year beginning through the selected accounting period.

No calculations performed

S

Over/(Under) Revenue Budget (optional column)

The difference between the amount of revenue that was budgeted and actual revenue received for the chart string.

= columns R minus Q

Fiscal Year and Cumulative Balances

Indicated by Letter

Column Name

Column Description

Calculations

T

Fiscal Year Surplus/(Deficit)

Revenue surplus or deficit plus Expense surplus or deficit, provides the net position which includes benefits and excludes any carryforward dollars from prior years.

= columns I minus N plus R

U

Cumulative Surplus/(Deficit)

Revenue surplus or deficit plus Expense surplus or deficit, provides the net position which includes benefits and includes carryforward dollars from prior years.

= columns P plus S

OR I minus N plus R

V

Fringe Benefits Surplus/(Deficit)

(optional column)

The benefits budget minus benefits obligation which includes benefits transactions that are expense and encumbrances

The fringe benefit Surplus/(Deficit) is a subset of the Cumulative Surplus/(Deficit) amount

For fund 110, General Unrestricted, a fringe benefit surplus is generally returned to the university

A fringe benefit deficit is generally the responsibility of the applicable department or unit.

= column K minus O