FTMFUND - Fund Code Maintenance Query Form

The Fund Code Maintenance Query page allows you to view details of a fund code.

To use:

  • From your Banner home screen, go to FTMFUND.

Once FTMFUND opens, launch a query by pushing F7 on your keyboard or clicking on the Filter icon on the top right of the screen.

Operating Ledger & General Ledger

FTMACCI - Account Index Code Maintenance Query Form

The Account Index Code Maintenance Query page allows you to view FOAPAL codes associated with indexes.

To use:

  • From your Banner home screen, go to FTMACCI.
  • Once FTMACCI opens, launch a query by pushing F7 on your keyboard or clicking on the Filter icon on the top right of the screen.
  • There are boxes to enter queries on index, account index title, and effective date. You can also use the “Add Another Field” drop-down to query on any of the FOAPAL elements.
    • You can use the Banner wildcard % in the account index title to search for keywords, for example %Geography%.
    • Keep in mind the query function in FTMACCI is case sensitive.
  • To execute your query after you’ve entered your desired fields, push F8 on your keyboard or click the Go icon on the top right of the screen.
  • If your query returned more than one record you can toggle through by pushing the up/down arrows on your keyboard or the clicking the left/right arrows on the left-center of the screen.
    • Active records are indicated by having no termination date or next change date.
    • Campus departments do not have maintenance access to make changes.

FGIBDSR - Executive Summary

FGIBDSR provides a summary organized by account codes of the current status of an organization's adjusted budget, year-to-date activity, commitments (encumbrances), and available balance. It is similar to FGIBDST, but FGIBDSR allows you to query at higher level chart components (roll-ups) and view all activity within that hierarchy. FGIBDSR is useful if you want to review aggregate numbers rather than analyze specific accounting transactions.

  • Enter the chart elements for your desired query. You can enter index, organization, fund, program, account, account type, activity, and/or location.
    • To query a specific account code you must select the "Query Specific Account" check box.
    • You can unselect the "Include Revenue Accounts" to exclude revenue account codes from your query.
       
  • To execute your query, push Alt+Page Down on your keyboard or click the Go or Next Section buttons on your screen.
     
  • To see transaction details for a line, drill down into your query by choosing Transaction Detail Information (FGITRND) from the Related menu or pushing F3 on your keyboard. To return to FGIBDSR, close FGITRND.
     
  • To enter a different query, click the Start Over button on your screen.

Fund Type Definitions

A fund is a self-balancing set of accounts with assets, liabilities, and a fund balance. Funds show ownership of cash and fund balance and are distinguished by their source of revenue. Funds may be restricted or unrestricted and may be specific to one department or shared by many departments. UO has thousands of funds which are grouped in fund types based on similar characteristics. They are hierarchical and roll up from detailed to summary level.

Budgeted Operations - Fund Type 11

Used to account for unrestricted resources that are available for current operations and are not accounted for as an auxiliary or service department. Revenue sources include:

  • State appropriations
  • Student instruction fees
  • Sales and service income of educational departments
  • Investment income that is unrestricted and available for current operations
  • Indirect cost reimbursements

Expenditure functions are:

  • Instruction
  • Research
  • Public Service
  • Academic Support
  • Student Services
  • Operational and Maintenance of Plant
  • Institutional Support
  • Budgeted Reserves

Examples of Budgeted Operations

General Fund - 001100

  • Budgeted fund shared by many departments
  • Used for general expenses of operating the university
  • Revenues come from state appropriations and student fees for tuition

ASA Fund - 001100

  • Shared budgeted fund (part of General Fund)
  • Used to provide support to eligible professors
  • Items purchased are UO property

ICC Fund - 001700

  • Shared budgeted fund
  • Used for general expenses
  • Revenues come from overhead charges to grants for use of UO facilities

Income/Expense Funds - 0012XX, 0013XX, 0014XX

  • Specific to one department
  • Used for general expenses
  • Revenues come from student fees and/or department sales/services
Designated Operations - Fund Type 12

Unrestricted funds to account for self-sustaining student activities related to instruction, community education, public service, and scholarships. Examples include field trips, non-credit conferences, workshops, non-instructional camps or seminars offered to general public, theater and music activities, and financial aid funds generated from fund raising activities. Revenue comes from student fees and fees charged to participants.

Examples of Designated Operations Funds

Unrestricted Gifts - 060XXX

  • Specific to one department
  • Used for general expenses
  • Revenues come from gifts having no donor restrictions
Service Departments - Fund Type 13

Unrestricted funds to account for activities established to provide services to campus departments, other schools, or the general public. They are expected to be self-sustaining and break-even. Examples include Computing Center, Telecom, Printing, and Mail Services.

Internal Bank Fund - Fund Type 15

Accounts for the investment and debt activity of the UO, including the funding of capital projects from debt proceeds.

Housing Auxiliary - Fund Type 21

Auxiliary funds account for activities related to entities that have been specifically designated as auxiliary enterprises. An auxiliary enterprise is an entity that exists primarily to furnish services to students, faculty and staff. Housing funds are student auxiliaries that account for activities primarily intended to serve the student bodies' housing needs.

Student Centers and Activities Auxiliary - Fund Type 22

Auxiliary funds account for activities related to entities that have been specifically designated as auxiliary enterprises. An auxiliary enterprise is an entity that exists primarily to furnish services to students, faculty and staff. Student Centers/Activity funds are student auxiliaries that account for activities primarily intended to serve the student body. Examples include EMU, Career Planning, and Counseling Center.

Intercollegiate Athletics Auxiliary - Fund Type 23

Auxiliary funds account for activities related to entities that have been specifically designated as auxiliary enterprises. An auxiliary enterprise is an entity that exists primarily to furnish services to students, faculty and staff. Intercollegiate Athletics funds account for athletic activities in participation with other institutions.

Health Services Auxiliary - Fund Type 24

Auxiliary funds account for activities related to entities that have been specifically designated as auxiliary enterprises. An auxiliary enterprise is an entity that exists primarily to furnish services to students, faculty and staff. Housing funds are student auxiliaries that account for activities primarily intended to serve the student bodies' Health Services needs.

Parking Auxiliary Fund - Type 25

Auxiliary funds account for activities related to entities that have been specifically designated as auxiliary enterprises. An auxiliary enterprise is an entity that exists primarily to furnish services to students, faculty and staff. Parking funds are student auxiliaries that account for activities related to on campus parking needs.

Other Auxiliaries - Fund Type 29

Auxiliary funds account for activities related to entities that have been specifically designated as auxiliary enterprises. An auxiliary enterprise is an entity that exists primarily to furnish services to students, faculty and staff. Examples of other auxiliaries include Vivian Olum Child Development Center, Vending, and Library Copying.

Restricted Funds - Fund Type 30

Account for resources that are available for current operations, but are restricted to specific purposes by the donor, or the granting or contracting agency. Examples include grant funds limited to use for sponsored research and donated gifts with donor imposed restrictions.

Loan Funds - Fund Type 41

Central administrative funds used to account for resources available for loans to students and for the loans made to students. Revenues come from individuals, corporations, foundations, and government agencies. The three classifications of loan funds are:

  • Institutional loan funds - Gifts which the donor has specified are to be used for student loans.
  • Institutional matching loan funds - Institutional fund provided to match Federal government loans.
  • Government loan funds - Loan funds provided by Federal or State government. For example, National Direct Student Loans.
Unexpended Plant Funds - Fund Type 81

Accounts for resources that are available for capital additions and improvements. The principal revenue sources for unexpended plant funds are:

  • Building bond proceeds
  • State appropriations restricted to plant fund uses
  • Student building fees
  • Income from investment of unexpended plant funds
  • Grants from government agencies
  • Gifts restricted by donors to capital outlay
  • Building indirect cost recoveries
  • Contributions of building repair and equipment replacement reserves
Renewal & Replacement Funds - Fund Type 83

Part of Unexpended Plant Funds. Accounts for contributions to building repair and equipment replacement reserves made by departments in accordance with specific funding requirements.

Investment in Plant Funds - Fund Type 87

Accounts for the value of capital assets, the liability associated with those assets, and the net investment in capital assets. Net investment is the acquisition value less the outstanding liabilities. Capital assets include land, buildings, improvements other than buildings, and equipment and furnishings that are capitalized.

Agency Funds - Fund Type 91

Accounts for funds of external persons or organizations while the funds are in the custody of the institution. The institution acts only as a fiscal agent and the funds can be disbursed only as directed by the external person or organization.

Account Code Primer

Account codes define the type of activity being recorded in a transaction such as revenue, expense, and transfers in the operating ledger and assets, liabilities, and fund balance in the general ledger.

Knowledge of account codes is important for both reporting on accounting data and for entering financial transactions into the system. It also allows Business Affairs time to review purchasing information and trends. Some commonly used account code groups are listed below.

 
Account Code Type Description
0XXXX Revenue To record revenue for sales, services, rentals, and fines to customers outside the UO. Generally used when making a deposit through Cashiers.
09XXX Internal Revenue To record revenue for internal sales and services provided to other UO departments.
1XXXX Payroll To record payroll expense. Generally used only through the payroll sysytem.
2XXXX General Expense To record expense for services and supplies.
3XXXX Travel Expense To record travel expense.
4XXXX Capital Expense (Non-Proprietary) To record capital outlay (purchase or construction) for non-expendable personal property and real property from non-proprietary funds.
5XXXX Student Aid To record expense related to scholarships, fellowships, grants-in-aid, waivers of fees and participant support for UO students.
6XXXX Merchandise for Resale To record the purchase of merchandise for resale.
70XXX Indirect Costs To record indirect costs.
79XXX Internal Sales Reimbursements To record internal sales reimbursements for sales and services from the General Fund (001100) and the ICC Credits Fund (001700) to other UO departments.
8XXXX Student Loan-Related Expense To record student loan fund receipts and expenditures for loan funds. BA use only.
9XXXX Transfers To move cash between funds when there is not an exchange transaction. Also used to move fund balance created by prior year's activity.
A8XXX Capital Expense (Proprietary) To record capital outlay (purchase or construction) for non-expendable personal property and real property from proprietary funds.
Major Categories

 Supplies (20XXX)
Communications & Postage and Shipping (220XX & 225XX)
Facilities & Utilities Related (230XX, 233XX, 235XX, and 240XX)
Fees and Services (245XX-249XX)
Conferences, Entertainment, etc. (286XX)Travel (393XX-397XX)
Summary of Tax Reportable Account Codes (various)

Banner FIS Document Approvals

FAQ: Banner: How can I get my document back to make a change or add text?

Banner: How can I get my document back to make a change or add text?

If a journal voucher has been completed and doesn't need to go through an approval queue, it can't be retrieved to make changes or additions. If an approval queue is involved (as with amounts > $5,000, grants and general ledger account codes), you can call the person in charge of the approval queue and have that person disapprove the journal voucher. Then you will be able to go into the journal voucher and make desired changes.

If an invoice has been completed, as with journal vouchers, you will only be able to go into it if it goes to an approval queue and the person in charge of the approval queue (Maryam Peigahi at 6-3152) disapproves it. However, with invoices there is another option. If the invoice has already been approved, you can call Accounts Payable (6-3143) and have the invoice cancelled if that is the best option. Then you can start again with a fresh invoice.

New lines of text may be added to a completed document using Banner form FOATEXT. Go to this screen,enter the type of document and the document number, and then use the down arrow key to access a new line.
Add your name, telephone number, and the date, and then add the desired new text. Adding text in this way will not affect the original document.

FAQ: What are FOAPAL elements?

What are FOAPAL elements?

FOAPAL is an acronym for the six chart of accounts elements used to process financial data (Fund, Organization, Account, Program, Activity, Location). Transactions in the Operating Ledger (OPAL) require fund, organization, account, and program, sometimes referred to as FOAP. Transactions in the General Ledger require only fund and account. All of the elements, with the exception of activity codes, are hierarchical and roll up from lower data entry levels to higher summary levels.