University of California, Riverside

UCR Reporting



Enterprise Reporting System


MS Excel Based Reports

A MS Excel based reporting application, The Enterprise Reporting System, is available to department users.

Access to the Enterprise Reporting System (ERS) is authorized by the Department SAA.

Please contact the Computing Support Group Help Desk for the installation and configuration of the Enterprise Reporting System. 

Enterprise Reporting System (ERS)

The Enterprise Reporting System (a.k.a. ERS) application is a Microsoft Excel based program. The ERS allows users to query the UCRFStotals and SUPER-D.O.P.E. databases and automatically produce formatted summary and detail reports. Salary and non-salary projections can be included. The final reports are Excel spreadsheets (all totals are formulas, not static numbers). The spreadsheets can, of course, be customized after processing is complete.

The ERS produces three different reports:
  1. Expense Overview 
  2. Operating Statement 
  3. Operating Statement including Unexpended Balance 
The ERS also accommodates shared fund sources with the following options:
  • Budgeting by Cost Center
  • Management Reports (by Activity, Fund, and Function) providing an overview of Allocations by Cost Center, Expenditures, and Balances.
Recent enhancements include:
  • The detail report now provides outstanding lien balances from the encumbrance ledger.
  • A condensed detail report is being provided so that PIs can review current period activity on a single page format.

The ERS produces three different reports:


Expense Overview

The Expense Overview report compares appropriations and expenditures for expense accounts.

step 1


Operating Statement

The Operating Satement produces a current year "Profit &Loss" by fund for revenue and expense accounts.

step 1


Operating Statement Including Unspent Balance

In addition to producing a current year P&L" by fund, this report also includes the fund equity balance forward and any current year unspent balance transactions.

step 1

FAQs, Frequently Asked Questions

Why should these reports be run versus the standard UCRFS reports?

These reports summarize information across funding sources. It may be useful when preparing reports for Principal Investigators with multiple funding sources or to see the status of a department’s operations across funds.

Official ledgers are the standard reports from UCRFS. The ERS reports are to be used as a supplemental reporting and analytical tool.

What type of report should be run?

Expense Overview (EO)
This report contains information on expense accounts only for the FAU specified. It allows for a comparison of appropriations and expenditures across specified funds. This report is best used with funds where the income is centrally controlled and budgetary allocations are the authority to expend (i.e. campus-wide funds, contracts and grants, and gift funds). This is a good format to provide information to a Principal Investigator (PI) on his/her sponsored project activity. Recommended for use with funds that are not shared within a department and fund ranges 18000-18999, 20600-20999, 21100-59999. On contract and grant funds to include overhead select function code 80. This selection will appear as a separate column on the summary output.
Operating Statement (OS)
This report contains information on revenue and expense accounts for the FAUs specified. It is a basic Profit & Loss (P&L) statement with a focus on the current fiscal year. This report will be beneficial for departments that are responsible for generating income to support their expenditures, such as Sale & Service and Auxiliary operations. Note: The report is most meaningful when budgets are zeroed-out to BC75 at year-end to accurately reflect prior year carryforward/deficits. Recommended for most funds within the range 60000-70999. Limit selections to expense FAU combinations as the revenue activity is automatically included.
Operating Statement including Fund Equity (OE)
This report contains information on revenue and expenses for the FAUs specified and the associated fund equity transactions. On the summary output, the fund equity total will only appear in the first FAU combination, as the fund equity value is for the entire fund and is not separated by activity code. It is a form of a Profit & Loss (P&L) statement, but the focus is on overall performance over the life of the operation. This report will be beneficial for departments that have activity flowing through the unexpended balance account (e.g. depreciation, debt payments, transfers to plant), such as Sale & Service and Auxiliary operations with Reserve and Renewal & Replacement funds. The report is most useful when the funds are limited to one activity and purpose. Note: It is important to zero-out budgets to BC75 at year-end to accurately reflect prior year carryforward/deficits. Recommended for fund ranges 75000-76999. Limit selections to expense FAU combinations as the revenue activity is automatically included.

Are there any FAU combinations I should not use?

When selecting the Operating Statement reports (OS and OE) to run, do not include function code 20.

When should the reports be run?

The reports are most complete after the month has closed. There is an e-mail notification announcing the period has closed and the ledgers are complete. The reports can be run on an ad-hoc basis, but be aware of when the databases are updated, to determine how current the data is that will be included. For example, the SuperDOPE database is updated the first week of the month and the UCRFS database is updated daily.

More Information 

General Campus Information

University of California, Riverside
900 University Ave.
Riverside, CA 92521
Tel: (951) 827-1012

Department Information

Computing & Communications
Computing & Communications Bldg.

Tel: (951) 827-4741
Fax: (951) 827-4541
E-mail: helpdesk@ucr.edu

Footer