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.

OBFS offers training in how to use Banner, My-UI-Financials, Mobius View, and EDDIE:
OBFS Training Center

Decision Support offers training on how to use Business Objects:
AITS Services, Reports and Data: Help and Training

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 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 provides standard static month-end reports, available after each month has closed.

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 (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.