Controller Directory Documentation News Financial Data Queries UC Home Page
UC Home Page 

Financial Data Queries

Account Expenses Departmental Expenses Departmental Transactions Document Details Endowment Query Page Fund Balance Microfilm Index PIPES

Introduction

Internet access to the University's financial information was significantly improved during and since the spring of 2001.  Additional data is now displayed in each of the queries/requests listed below.  The query results may be printed from the Web browser or imported to an individual client workstation in a department.  The data from the query results may be loaded into an Excel spreadsheet or transported to a text file.  By exporting the data to a text file on a person's PC, it may be subsequently moved to a number of software programs (such as MS Access, Excel, Department Manager and others) that typically support such a format.

Call the CUFS Hotline at 556-5100 if you have questions or need assistance in using this process.  

Please note that the Treasurer's Office manages the Endowment Query Page.   For questions about and assistance with this page, call 556-5002.

Simply click one of the hyperlinks below and you will be taken to another page where you may specify the criteria for your unique query.   Hyperlinks to the query pages also appear above.

Account (Fund-Area-Organization) Expenses for a Fiscal Year 
This query allows a Fund, Area and Organization Code to be specified along with a Fiscal Year.  All expense transactions for the specified account and fiscal year will be reported in detail.  The current fiscal year will include all expense transactions from the fiscal year's closed accounting periods as well as from the current accounting period (up through the previous business day).
Departmental Expenses by Organization for a Fiscal Year
This query allows an Organization code (either a Grant, Plant or Departmental Organization) to be specified along with a fiscal year.  All expense transactions for the specified Organization and fiscal year will be reported in detail.  The current fiscal year will include all expense transactions from the fiscal year's closed accounting periods as well as from the current accounting period (up through the previous business day).
Departmental Accounting Transactions by Organization for a Month
This query allows an Organization code (either a Grant, Plant or Departmental Organization) to be specified for a selected fiscal year and month.   All transactions (expense, encombrance, pre-encumbrance, revenue and balance sheet accounts) for this Organization for the specified fiscal month will be reported in detail.
Details for a Single Accounting Document
This query allows an individual accounting document to be specified for a selected fiscal year.  All accounting events associated with this document will be listed.  Budgets documents are not included.
Endowment Query Page

This link will take you to the Treasurer Office's Endowment Query Page.  For questions about and assistance with this Web page, call the Treasurer's Office at 556-5002.

Fund Balance (Unexpended)
This query allows a Fund code to be specified.   Unexpended Fund balance information will be listed effective as of the last monthly close.   The balance will include the effects of revenue and expense postings (but not those of encumbrance and pre-encumbrance entries).
Microfilm Index
This query allows a microfilm identification number to be specified.   A list of microfilm index numbers will be listed that correspond to the request.   The microfilm information is managed by the Accounting resource Center (ARC).
Purchase order Invoice and Payment Enquiry System (PIPES)
PIPES consolidates a great deal of information associated with a purchase order that ordinarily takes a lot of time and effort to find in CUFS.  With the help of a datawarehouse of CUFS information, it provides more historical and concise information than is available through online CUFS.  PIPES also enhances CUFS data by providing a link to the images of the invoice documents associated with a purchase order.  Click on this link to access PIPES.

Questions should be directed to Finance IT Services at 556-5008.

Return to top