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
An Account Request Form and Finance Access Request Form must be completed, approved and sent to Joyce Cline, Associate Controller, in the Accounting Office.
Banner Finance training is available periodically throughout the year. See the Faculty and Staff Training website for a schedule of available courses.
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
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”
Contact Jim Hargett with any questions you may have (hargett@oakland.edu).
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).
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.
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.
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:
- Click Start
- Click Run
- Type "\\shares\ouledgers\ledgers.mdb"
- Click OK