Monitoring Expenditures
Monitoring and reconciling all sponsored awards on a regular basis helps ensure that funds are spent in accordance with the terms and conditions of the award. It also helps avoid overspending and identifying erroneous posting in a timely manner. Corrections to expenditures on sponsored awards should be made promptly - within 90 days of the initial posting. Corrections made after this period require a GC81 - Cost Transfer Justification for Sponsored Projects Form.
The University maintains a variety of resources that provide sponsored award-related reports. Contact the unit providing the resource for support.
Training Heading link
-
Training
OBFS offers training in how to use Banner, My-UI-Financials, Mobius View, and EDDIE:
OBFS Training CenterDecision Support offers training on how to use Business Objects:
AITS Services, Reports and Data: Help and Training -
Banner
Banner is the University’s financial system of record. Other reporting systems (listed below) mainly use data which originates from Banner. Some Banner forms can be used to run queries and these results reflect all transactions that have been processed to date.
- Website: Banner Administrative Forms
- Recommended forms:
- FZIGITD – Inception to date financial information (i.e., budget, expense, commitment, available balance) for sponsored awards.
- FRIPSTG – All grants for which a person is Principal Investigator (PI) or a Co-PI.
- FRIORGH – All grants associated with a particular org code.
- FRIASTG – All grants associated with a particular sponsor.
- FZIBDET – Total amount billed, paid, and refunded on a particular award
- FZAAREV – Individual amounts billed and paid on a particular award
- Help with Banner
-
My-UI-Financials
My-UI-Financials is a report distribution system. With My-UI-Financials, you have quick access to all of your financial and payroll reports, in one place.
A simple dashboard provides budgets, expenditures, encumbrances, and balances. The system allows drilling down to individual transactions including payroll details.
- Website: My-UI-Financials
- Getting access: Access to My-UI-Financials is granted by College/Department Report Assigners. A list is available on the My-UI-Financials Resource Page.
- For available grant fund balance, use the report Revenue Expense Statements Inception to Date
-
Mobius View
Mobius View provides standard static month-end reports, available after each month has closed.
- Website: Mobius View
- Getting access: AITS Services: Get Access
- Recommended reports (replace the “x” with the chart number for your campus, e.g. FIOPLEITD1, FIOPLITDS2, FIOLTRANS4):
- FIOPLEITDx – Revenue/Expense/Detail Statement Inception to Date
- FIOPLITDSx – Revenue/Expense/Summary Statement Inception to Date
- FIOLTRANSx – Revenue/Expense/Transactions
- Help with Mobius View: Mobius View – Access to View Direct and Document Direct Applications
-
EDDIE
EDDIE reports are run on-demand and therefore reflect all transactions through the previous day. Some of the same reports available in Mobius View are also available through EDDIE. There are also several reports designed specifically for managing sponsored awards (listed below).
- Website: EDDIE
- Getting access: AITS Services: Get Access
- Recommended reports:
- FIGR_Grants_Status_and_Billing_Summary_Report – Provides a comprehensive financial summary of a grant, including budget and expense information, general ledger balances for a specific accounting period, current accounts receivable balances and individual sponsored project billings.
- UR_FIGR_Grant_Detail Report – Provides departmental managers with details on a particular grant including ITD information, a summary of personnel and non-personnel expenses, non-personnel transaction detail, and projections.
- UR_FIGL_Departmental_Multifund_Management_Report – Contains a summary of the fund balance by fund and fund type, as well as fund code details for a particular Chart, three-digit organization code, fiscal year and fiscal period.
- Help with EDDIE: AITS Services: Get Help
or Contact Decision Support at servicedeskaits@uillinois.edu
-
Web Intelligence (Business Objects)
Web Intelligence (previously known as Business Objects) is a flexible reporting tool that allows users to create custom reports or to modify reports created by others. Many different datasets are available related to HR, finance, and student data.
- Getting Access: AITS Services: Get Data Warehouse Access
- Installing Web Intelligence: AITS Services Help & Training: Business Objects 4.1 Resources
- Training: AITS Services, Reports and Data: Help and Training
- Solution Library – Web Intelligence reports created and validated by Decision Support staff
- Website: AITS Services, Reports and Data: Solution Library
- Recommended Reports:
- Active Grants by College – Listing of all active grants for a college.
- Direct & Indirect Expenses for Grant Funds – List of direct and indirect expenses for grant funds, for a specific chart, org, state fiscal period and state fiscal year.
- Help with Web Intelligence: AITS Services: Get Help
or Contact Decision Support at servicedeskaits@uillinois.edu