Skip to main content

Monthly Financials

Access Cognos through the NUPortal or at https://reporting.northwestern.edu. Navigation: Cognos BI > Finance, Facilities, and Research Administration > School > Monthly Financials.

Report Name Description
AM002 - Asset Inventory Report'
GE002 - Transactional data file: Pre-Encumbrance detail Shows all transactional detail from Requisitions (pre-encumbrance) in a CSV format.

GE004 - Transactional data file: Encumbrance detail

Shows all transactional detail from Purchase Orders (encumbrances) in a CSV format.
GE005 - Transactional data file: Expense detail Shows all transactional detail from all Expense transactions (Actuals) in a CSV format.
GE006 - Transactional data file: Revenue detail Shows all transactional detail from all Revenue transactions (Actuals) in a CSV format.
GE007 - User Security Profile
GE008 - Department Workflow Approval Security Profile Shows NUFinancials Workflow Approver information for a given department or department values within a node.
GE010 - Department Row Level Security Profile Shows NUFinancials Row Level Security information for a given department or department values within a node
GE011 - Project Workflow Approval Security Profile
GE012 - Department Row Level Security Profile
GL002 - Fund/Project Equity Position Report - Summary The summary report gives the users a snapshot of the equity position of each of their gifts and endowment Projects as well as totals for all, at a given date.
GL005 - Budget Status Report - Summary Summarizes budget to actuals for revenue and expenses
for a specific Fund, DeptID, Project.
GL008 - Revenue & Expense Activity Report View all transactions affecting the budget for the current period.
GL009 - Expense/Revenue Budget Provides current expense and revenue budget information for all non-grant operating chart strings.
GL010 - Operating Budget Report Provides current expense and revenue budget information and actual expense and revenue activity for all non-grant chart strings.
GL012 - Project by Attribute/Activity
Designated Funds
Provides the ability to search for designated projects that
have a given attribute.
GL013 - Year End Performance Review Report Used by management to gauge actual to budget for
revenue and expenses.
GL018 - Summary of Agency Project Cash Balances Gives a snapshot of the balances on the Summary and gives more information on the individual Agency Project on the Detail reports.
GL025 - Faculty Startup Summary Used by central offices to review faculty start up funds.
GL026 - Faculty Startup Summary (for departments) Used by schools to review faculty start up funds.
GL061 - Agency Project Detail Gives agency account managers a detail of cash balances.
GL062 - Gift/Endowment Project Detail The detail report gives detail of a particular Project ID, including budgeted and actual Revenue, budgeted expenses, pre-encumbrances, encumbrances, and expenses, as well as amounts available to spend for the particular Gift and Endowment Projects. For Endowments, it gives specific detail for both the Principal and the Spending portions.
GL064 - Project by Attribute/Activity
Non-Designated Funds
Provides the ability to search for non-designated projects that have a given attribute.

GL068 - Financial Summary (Excluding Agency and Multi-Year Funds)

Provides summarized financial information by chart string, for a DeptID or for a School/Unit, reflecting the typical Beginning Balance, Expenses, Revenues, and Ending Balance for both Budget and Actuals, as applicable; also providse sub-totals by Fund type and DeptID.

GL069 - Financial Summary (Including Multi-Year Funds And Excluding Agency Funds) Displays summarized expense and revenue (actuals and budget) financial information by chart string for a DeptID or School/Unit, reflecting the typical Expenses, Revenues, and Ending Balance, as applicable. This report shows information for all chart strings except those that use agency funds (starts with a 7).
GL070 - Financial Summary with Project Purpose (Excluding Agency and Multi-Year Funds) Provides summarized financial information by chart string, for a DeptID or for a School/Unit, reflecting the typical Beginning Balance, Expenses, Revenues, and Ending Balance for both Budget and Actuals, as applicable; also provides sub-totals by Fund type and DeptID. The GL070 report has the additional benefit of reporting and sub-totaling by Project Attributes, as assigned.
GL071 - Financial Summary - Historical Comparison (Excluding Agency and Multi-Year Funds) Allows comparison of fiscal year data by accounting period.  Answers the question:  “How were we doing this time last year?” 
GL072 - Financial Summary w/ Detail ICR (Excluding Agency and Multi-Year Funds)
GL073 - Financial Summary w/ Detail ICR (Including Multi-Year Funds And Excluding Agency Funds)
GL074 Financial Summary with Management Level & Project Purpose (Excluding Agency and Multi-Year Funds) Extends the functionality present in the GL068-GL071 range of reports.
- Using the new Management Level attribute, allows you to group your chart strings into classifications consistent with how funds in your area are managed.
- Available Management Level values will be Dean/VP Administration, Department Chair/Unit Head, PI/Faculty, Program/Center, and Other.
GL077 - Income Statement'
SC016 - Open Encumbrance Report

Last Updated: 5 September 2017

Get Help Back to top