Topics Map > University of Chicago > IT Services > Business Systems > Reporting Systems

Business Objects - IRF - Financial Reporting and Transaction Tracking Report List

This article lists the IRF Financial Reporting and Transaction Tracking reports.

Document Purpose

Webi Report Name

Calendar

Organization

BODoc Description

 

Account Information

FR-200-Account Status

Month(s)

Account(s)

Shows comprehensive financial activity and descriptive information for specified SL accounts(s) during specified month(s). Contains everything about an account shown on AM090 and AM091, plus detailed encumbrance information and account attributes (e.g., people information, award information, FAS codes and flags).

 

Fiscal Account Analysis

FR-202-Fiscal Acct Analysis-FY-For Acct

Month and Comparison Month

Account(s)

Provides month-by-month graphs of cumulative current month expense and budget figures, and month-by-month detail by sub-account, for the current fiscal year.

FR-201-Fiscal Acct Analysis-Mo-ForAcct

Current Fiscal Year

Account(s)

For one or more accounts, provides comparison reports of current month activity, YTD activity, budget balance available, and percentage of budget spent with the same month last year (or any other specified month). Also provides projections by expense category or sub-account, and current month account activity by sub-account.

Project Account Analysis

FR-110-Project Analysis-Mo

Month

Account(s)

Reports on the financial status, for a specified month, of a group of accounts that make up a project. Provides project totals by expense category, account, and sub-account. Displays open encumbrances and key account attributes.

 

FR-100-Project Analysis-History

Range of Months

Account(s)

Reports on the financial status, over a range of months, of a group of accounts that make up a project. Provides month-by-month graphs and tables of current month expense, summarized across the project or grouped by expense category and account.

IDC Analysis

FR-314-IDC Recovery FYTD-For Dept

Fiscal Year

Department(s)

Retrieves and calculates fiscal year to date direct, indirect, and total costs for federal and non-federal grants, contracts, cooperative agreements, and drug studies for one or more Departments and the fiscal year of the YearMonth entered.

FR-315-IDC Recovery FYTD-For Exec

Fiscal Year

Exec Level(s)

Retrieves and calculates fiscal year to date direct, indirect, and total costs for federal and non-federal grants, contracts, cooperative agreements, and drug studies for one or more Exec Levels and the fiscal year of the YearMonth entered.

FR-313-IDC Recovery Analysis FYTD-For Acct and Dept

Range of Months

Account(s) or Department(s)

Retrieves and calculates Fiscal Year To Date direct, indirect, and total costs for federal and non-federal grants, contracts, cooperative agreements, and drug studies for one or more Accounts or Departments, in a specified time period.

Grant & Contract Account Administration

FR-304-Grants and Contracts-For Dept

Latest Update

Dept No(s)

Provides a current list of Grant and Contract accounts for a specified department

FR-311-GC-FAS Close Due-For Dept and Univ

FAS Close Due Dt Range

Dept No(s)

For a specified department (or university-wide), provides a list of Grant and Contract accounts with FAS Close Due Dt in the specified date range.

FR-312-GC-Financial Rpt Due-For Dept and Univ

Financial Rpt Due Dt Range

Dept No(s)

For a specified department (or university-wide), provides a list of Grant and Contract accounts where the financial report is due within a specified date range.

FR-303-GC-Overdraft SL Accts-For Dept

Latest Update

Dept No(s)

Selects Grant and Contract accounts for a department where the budget balance available is less than $0 as of the latest update.

FR-301-GC-Exceptions-Gift Grant Contract Cd

Latest Update

NA

Identifies miscoded grant and contract accounts university-wide

FR-300-GC-Exceptions-Assoc Accts

Latest Update

NA

Identifies miscoded associated accounts university-wide

FR-302-GC-Exceptions-Master Accts

Latest Update

NA

Identifies miscoded master accounts university-wide

Terminated Employee Reports

FR-400-Terminated GL Acct People For Dept

NA

Department(s)

The purpose of this BODoc to help in removing people from various account roles after employee termination.

FR-401-Terminated SL Acct People for Dept

NA

Department(s)

The purpose of this BODoc to help in removing people from various account roles after employee termination.

Account Groups Display

FR-801-SL Acct6 Group Definition

NA

NA

Displays the embedded rules and structure of a specified SL Account6 Report Group Definition. A SL Account6 Report Group is a mechanism for grouping 6-digit accounts into projects and sub-projects for financial reporting.

SubAccount Groups Display

>FR-802-Sub Acct Group Definition

NA

NA

Displays the embedded rules and structure of a specified SubAccount Report Group—a mechanism for grouping data into custom categories defined by SubAccount ranges. This BODoc identifies the SubAccounts that make up each category.

Organizational History Display

>FR-800-FAS Org History

Month(s) and Range of Months

Exec Level(s) and Department(s)

Lists some details associated with FAS Organization codes, to assist in the interpretation of historical data or research of anomalies which may result from organizational changes.

Account Organizational History & IDC Display

>FR-305-Migrant SL Acct6 History

Range of Months

Exec

A useful tool for identifying accounts for which Department and/or Exec Level codes have changed. This BODoc searches a specified range of months and Exec Level(s), retrieving indirect cost amounts for each of these “migrant” accounts. Account migrations can help to explain variances in organization totals on the Fiscal Year To Date IDC BODocs.

 

Encumbrance History

TT-200-Encum History-For Acct or Encum No

Latest IRF Update

Encumbrance(s)

Retrieves the entire encumbrance history for specified account(s) or encumbrance number(s) since the creation of the encumbrance(s).

TT-201-Open Encum-For Acct

Latest IRF Update

Account(s)

Retrieves a list of details for encumbrances open as of the latest update of FAS data in IRF for a specified account or list of accounts.

Transaction Lookups

TT-100-SL Trans Lookup-For Acct and Document ID

Month(s)

Accounts(s) or Document(s)

Retrieves detailed transaction data for a specified subsidiary ledger account, a list of accounts, or for a Document ID (Control Number, PO Number, or Voucher Number) or list of IDs, for a specified range of months.

TT-120-GL Trans Lookup-For Acct

Month(s)

Account(s)

Retrieves detailed transaction data for a specified general ledger account or list of accounts and a specified month or list of months.




Keywords:BO grant GC contract subaccount emcumbrance   Doc ID:50987
Owner:James I.Group:University of Chicago
Created:2015-04-30 10:25 CSTUpdated:2015-07-28 08:02 CST
Sites:University of Chicago, University of Chicago - Sandbox
Feedback:  0   0