Mobile Navigation Menu Icon. 3 horizontal gold bars.

Accounting Office

West Vandenberg Hall, Room 121
502 Meadow Brook Road
Rochester, MI 48309-4452
(location map)
(248) 370-2447
Fax: (248) 370-2554

Accounting Office

West Vandenberg Hall, Room 121
502 Meadow Brook Road
Rochester, MI 48309-4452
(location map)
(248) 370-2447
Fax: (248) 370-2554

Banner Finance

Oakland University uses the SCT Banner Finance System. System access request forms are available on the University Technology Services site.

An Account Request Form and Finance Access Request Form must be completed, approved and sent to Gerriann Reimann, Associate Controller, in the Accounting Office.
Training

Banner Finance training is available periodically throughout the year. See the Faculty and Staff Training website for a schedule of available courses.

Systems Overview
Banner Finance

Banner Finance includes the following modules:

  • General Accounting
  • Purchasing / Accounts Payable
  • Budgeting
  • Project Accounting (Grants, Contracts, Capital Projects)
  • Equipment Control

In addition, financial information is “fed” to Banner Finance from other Banner systems including:

  • Student
  • Human Resources
  • Alumni
OU Ledgers

The University’s basic financial reports are available on the “shares” server.  The reports can be accessed by mouse clicking “start” then “run” on Windows and typing in the following addresses:

  • "\\shares\budget\FRS\Financial Reports.mdb"
  • “\\shares\ouledgers\ledgers.mdb”
  • “\\shares\ouledgers\fy_cumulative_databases”
  • \\shares\hr\hr_reports.mdb”
MS Access and Banner Finance
Banner tables and views can be accessed through MS Access to create customized data queries and reports.
Security
Security forms to access Banner Finance and Admnet are available at the following UTS web site: http://www.oakland.edu/uts/accounts.

Contact Jim Hargett with any questions you may have (hargett@oakland.edu).
Fund Descriptions

All University funds are grouped into one of the following “categories”:

General Fund: maintained to account for those transactions related to the academic and instructional programs of the University and their administration.

Designated Fund: maintained to account for funds for specific purposes which are not restricted by donors or supporting agencies outside of the University.  

Auxiliary Activities Fund: maintained to account for revenue-producing, substantially self-supporting University activities that perform a service but are not themselves educational activities.

Expendable Restricted Fund: maintained to account for special programs financed by gifts, grants and contracts and endowment income.

Loan Fund: maintained to account for loans to students.

Endowment Fund: maintained to account for gifts that are to be held and invested in perpetuity. The income from investments is used to support donor defined purposes.

Plant Fund: maintained to account for University physical properties and related indebtedness.

Retirement and Insurance Fund: maintained to account for employee retirement and insurance programs.

Agency Fund: maintained to account for resources held by the University on behalf of organizations associated with the University (e.g. student, faculty and staff organizations).

Basic Financial Statements

Income Statement: this financial statement reports revenues, expenditures and transfers.

In Banner Finance the income statement can be found on the form FGIBDST, “Budget Status Form”. A list of transactions comprising the balances on the income statement can be found on the form FGITRND, “Detail Transaction Activity Form”. From FGITRND you can “drill down” to more detailed information about each transaction within Banner Finance.

In OULedgers the income statement can be found on the report FGRBDSC, “Budget Status Report”. A list of transactions comprising the balances on the income statement can be found on the report FGRODTA, “Detail Activity Report”.

Balance Sheet: this financial statement reports assets, liabilities and fund balance. The basic accounting equation is assets minus liabilities equals fund balance (or assets equals liabilities plus fund balance).

Total fund balance is comprised of revenue, expenditure and transfer “control accounts” for the current fiscal year added to the fund balance as of the beginning of the fiscal year. The sum of all revenue, expenditure and transfer accounts in the income statement equal the total of the control accounts in the balance sheet.

In Banner Finance the balance sheet can be found on the form FGITBSR, “Trial Balance Summary Form”.  A list of transactions comprising the balances on the balance sheet can be found on the form FGIGLAC, “General Ledger Activity Form”. From FGIGLAC you can “drill down” to more detailed information about transaction within Banner Finance.

In OULedgers the balance sheet can be found on the report FGRBLSH, “Balance Sheet”.

Examples:

  • Refer to the class handout examples of the income statement (FGRBDSC, FGRODTA) and balance sheet (FGRBLSH) reports from OULedgers.
  • Review this same activity on-line in Banner Finance at FGIBDST (income statement) and FGITBSR (balance sheet).
  • Note that OULedgers reports are as of a month end whereas the related Banner Finance forms are as of the current date.
Transactions in Banner Finance

Each transaction in Banner Finance has a document number and transaction type. Here is a breakdown of how some of the more common documents are numbered:

  • Purchase Orders: Pxxxxxxx
  • Invoices: Ixxxxxxx
  • Journal Vouchers: Jxxxxxxx
  • Checks: Uxxxxxxx
  • Student System: Fxxxxxxx
  • HR System: Fxxxxxxx
  • Alumni System: Fxxxxxxx

Transaction types are shown on Banner forms and reports. Transaction types determine how transactions should be posted in Banner. These are established by the Accounting Office.

Financial Reports

Monthly financial reports are kept in an MS Access database application on the university’s "shares" server. An admnet password is required to access the financial reports.

To access the reports on your computer:

  1. Click Start
  2. Click Run
  3. Type "\\shares\ouledgers\ledgers.mdb"
  4. Click OK