Banner Finance Chart of Accounts Training Workbook Release 8.7 – May 2012 Updated 6/19/2012
_______________________________________________________________________________________________

Ellucian

4 Country View Road
Malvern, Pennsylvania 19355
United States of America
(800) 522 - 4827

Customer Support Center website

http://connect.ellucian.com

Distribution Services e-mail address

distserv@ ellucian.com

Other services

In preparing and providing this publication, Ellucian is not rendering legal, accounting, or other similar professional services. Ellucian makes no claims that an institution's use of this publication or the software for which it is provided will insure compliance with applicable federal or state laws, rules, or regulations. Each organization should seek legal, accounting and other similar professional services from competent providers of the organization's own choosing.

Trademark

Banner®, Colleague®, PowerCAMPUS®, Luminis® and Datatel® are trademarks of Ellucian or its affiliates and are registered in the U.S. and other countries. Ellucian, Advance, Recruiter, and Open Digital Campus are trademarks of Ellucian or its affiliates. Other names may be trademarks of their respective owners.

Revision History Log

Publication Date	Summary
Original Date	New version that supports 8.0 software.
4/30/2008	Added 2 new topics: Copying existing JV and JV Reversal.
5/30/2008	Minor formatting changes.
6/25/2008	Added two new lessons – making changes to an encumbrance and closing/liquidating an encumbrance.
7/16/2008	Updated codes in the Account Code Records and Org Code tables.
7/23/2008	Updated codes in the Org Code table.
12/04/08 06/01/09	Updated various errors Corrected the encumbrance lessons
6/30/2009	Added a lesson on displaying new person fields for internationalization.
02/01/2010	Updated for Banner 8.4
7/29/2011	Updated to support available balance drill down on FGIBAVL for release 8.6.
8/12/2011	Updated screenshot of FTMCOAS on page 30.
4/30/2012	Updated to apply the Ellucian template.
6/19/2012	Updated to include information on month end closings with release 8.7.

Notice of rights

© 2012 Ellucian. All rights reserved.

Contains confidential and proprietary information of Ellucian and its subsidiaries. Use of these materials is limited to Ellucian licensees, and is subject to the terms and conditions of one or more written license agreements between Ellucian and the licensee in question.

Table of Contents

Introduction	5

Process Introduction	7

Chart of Accounts Overview	9

Chart of Accounts Features	11

Banner Finance System Ledgers	13

Other Finance Features	15

Banner Finance Reports	16

Rules and Security	19

Set Up	20

Displaying New Person Fields for Internationalization	22

Creating a New Chart of Accounts	24

Establishing Fiscal Year Parameters	35

Defining Internal Fund and Account Type Codes	38

Creating Level 1 Account Type Codes	47

Creating Account Codes	53

Defining Control Accounts	62

Creating Level 1 and Level 2 Fund Types	67

Developing Fund Codes	71

Defining a Fund Balance Account for a Multiple Fund Balance Institution	76

Creating a Bank ID	79

Defining Bank Codes for the Chart of Accounts	81

Establishing Program Codes	84

Establishing an Activity Code	87

Establishing a Location Code	89

Establishing Organization Codes	91

Creating an Agency Code	94

Creating Account Index Codes	96

Assigning a Financial Manager to the Chart of Accounts	98

Reviewing the Currency Code Maintenance Form	101

Maintaining Overall System Information for the Installation	103

Completing the Chart of Accounts Maintenance Form	105

Creating Attribute Set, Type, and Value Codes	107

Day-to-Day Operations	120

General Accounting Transaction Processing	121

General Encumbrance Processing	122

Making Changes to an Encumbrance	126

Closing/Liquidating Encumbrances	132

Journal Voucher Processing	134

Journal Voucher Processing – Quick Form	140

Journal Voucher Processing – Mass Entry Form	141

Journal Voucher Processing – Copying Existing Journal Voucher	142

Journal Voucher Processing – Journal Voucher Reversal	144

Automatic Journal Voucher Processing	146

Direct Cash Receipts Processing, FGADCSR	150

General Accounting and Budget Query Forms	154

Querying the Budget Availability Status Form, FGIBAVL	156

Querying the Organizational Budget Status Form, FGIBDST	161

Querying the Organizational Budget Summary Form, FGIBSUM	164

Querying the Executive Summary Form, FGIBDSR	166

Querying the General Ledger Trial Balance Form, FGITBAL	169

Querying the Trial Balance Summary Form, FGITBSR	171

Querying the Detail Transaction Activity Form, FGITRND	173

Querying the General Ledger Activity Form, FGIGLAC	175

Querying the Journal Voucher Summary Form, FGIJSUM	177

Querying the List of Suspended Journal Vouchers Form, FGIJVCD	179

Querying the List of Automatic Journal Vouchers Form, FGIAUTO	180

Querying the Detail Encumbrance Activity Form, FGIENCD	181

Querying the Organizational Encumbrance List Form, FGIOENC	183

Querying the Encumbrance List Form, FGIENCB	185

Querying the Document Retrieval Inquiry Form, FGIDOCR	186

Querying Direct Cash Receipts Form, FGIDCSR	188

Running the Account Hierarchy Report	189

Running the Fund Hierarchy Report	192

Running the Program Hierarchy Report	195

Running the Location Hierarchy Report	197

Running the Organization Hierarchy Report	199

Mandatory Daily Reports Review	202

Month-End Closings	207

Using the Open Close Fiscal Period Process at Month End	212

Summary	217

Self Check	218

Answer Key for Self Check	227

Appendix	238

Forms Job Aid	239

Introduction

Course goal

The Chart of Accounts is a systematic classification of accounts and an essential part of the Banner Finance accounting system. Accounts are developed to be compatible with your organizational structure. The form and content of the Chart of Accounts is arranged to be in agreement with the financial reports that you issue.

The fund, organization, account, and program codes are the primary chart of accounts elements used for classification, budgeting, recording, and/or reporting. The activity and location codes are used to provide specific performance-related detail for transactions.

This course will introduce you to the Chart of Accounts, and will explain how the Chart of Accounts is related to other parts of Banner’s Finance system.

The workbook is divided into these sections:

Introduction

Set-up

Day-to-day operations

Course objectives

In this course you will learn how to

create a Chart Code

create Accounts and Account Type Codes

create Funds and Fund Type Codes

create Organizations Codes

create Program Codes

create Activity Codes

create Location Codes

create a bank ID and defined bank codes

complete the Chart of Accounts Maintenance Form (FTMCOAS)

create attribute set, type, and value codes

process General Accounting Transactions

produce reports for the Chart of Accounts

query financial data

produce financial reports.

Intended audience

Finance Office Administrators and Staff.

Prerequisites

To complete this course, you should have

completed the Education Practices computer-based training (CBT) tutorial Banner 8 Fundamentals, or have equivalent experience navigating in the Banner system

administrative rights to create and perform the necessary set up in Banner.

Process Introduction

About the process

The Finance Office Staff can

establish a Chart of Accounts

process general accounting transactions

produce reports for the Chart of Accounts

query financial data

produce financial reports

Flow diagram

This diagram highlights the processes for using a Chart of Accounts.

What happens

The stages of the process are described in this table.

Stage	Description
Finance Office Staff
1	Establishes a Chart of Accounts.
2	Processes general accounting transactions.
3	Produces reports for the Chart of Accounts.
4	Queries financial data.
5	Produces financial reports.

Chart of Accounts Overview

Introduction

The Chart of Accounts (COA) is the “key” to Banner Finance. It defines the accounting distribution used on all transactions processed in the Banner Finance module.

The Chart of Accounts code is a one character, alpha/numeric field that uniquely identifies a particular chart. Banner Finance will accommodate multiple charts of accounts – each with a different chart code. It consists of seven elements that are defined as follows:

F O A P A L

Fund

This is a one-to-six-character code that identifies a self-balancing set of accounts and identifies ownership. Balance sheets and revenue/expense reports can be produced for any fund, which can be restricted (permanently or temporarily) or unrestricted. Fund codes may be established in a hierarchy of up to five levels for roll-up and reporting purposes. Examples of fund codes include Current Unrestricted Fund, Sponsored Student Loan Fund, and Fuller Architecture Program Endowment Fund.

Organization

This is a one-to-six-character code that identifies a unit of budgetary responsibility and/or departments within an institution. It is normally used to define “who” spends the money. Organization codes may be established in a hierarchy of up to eight levels for roll-up and reporting purposes. Examples of organization codes include Dean of Behavioral Sciences, School of Engineering, and Business Office. An institution’s organizational chart is a good guideline in setting up these codes.

Account

This is a one-to-six-character code that identifies objects, such as the general ledger accounts (assets, liabilities, control, fund balances) and the operating ledger accounts (income, expenditures, transfers). The account is a line item within an institution’s financial structure. Account codes may be established in a hierarchy of up to four levels for roll-up and reporting purposes. Examples of account codes include Petty Cash, Accounts Payable, Fund Balance, Tuition, and Regular Full Time Salaries.

Program

This is a one-to-six-character code that identifies a function and enables the institution to establish a method of classifying transactions across organizations and accounts. Examples of program codes include Instruction, Research, and Plant Operations. Most institutions follow the programs defined by the National Association of College and University Business Offices (NACUBO). Program codes may be established in a hierarchy of up to five levels for roll-up and reporting purposes. Examples of program codes include Academic Support, Student Services, and Research.

Activity

This is an optional one-to-six-character code that is non-hierarchical and can be used to further define an object of expenditure, such as, temporary units of work, subsidiary functional classifications, or short duration projects. Activity code examples are: Repair to Student Union Lobby Floor, Bookstore Van, and Computer Lab Printer Cartridge Recycling.

Location

This is an optional one-to-six-character code that identifies physical locations. It is primarily used with, but not limited to, the Fixed Asset module. However, if the Banner Fixed Assets module is used by the institution, then location codes must be defined and are not optional. Location codes may be established in a hierarchy of up to five levels for roll-up and reporting purposes. Examples of location codes are Controller’s Office, Athletic Department Offices, and Human Sciences Building.

Account Index

This code is another optional chart of accounts feature. It is a user-defined value for a set of FOAPAL elements that acts as a shortcut to speed data entry by the user. An example of an account index code might be a code used by the campus bookstore for certain transactions that defaults the Fund, Organization, Account, and Program code in order to represent book sales revenue. The index code may consist of up to six alphabetic/numeric characters and can define any combination of the FOAPAL elements.

Chart of Accounts Features

Features

Create Once, Use Everywhere

The Chart of Accounts needs only to be set up once to drive the following Banner Finance functions:

Accounts Payable

Budget Development

Electronic Approvals

Fixed Assets

General Ledger

Endowment Management

Purchasing

Research Accounting

Security

Stores Inventory

The Banner Chart of Accounts can also be set up to drive the following non-Finance functions:

Position Control and Position Budgeting

Salary and fringe budgeting

Salary and fringe encumbering

Payroll

Salaries and fringe expenditures

Salary and fringe re-distributions/reallocations

Accounts Receivable

Student charges and payments

Non-Student charges and payments

Financial Aid disbursements

Banner Finance System Ledgers

Introduction

In order to provide maximum flexibility and information capture, the Banner Finance System maintains these ledgers:

General Ledger

Operating Ledger

Encumbrance Ledger

Grant Ledger.

General Ledger (GL)

The General Ledger maintains information relevant to the organization’s “balance sheet.” Required COA elements for valid accounting distribution in the General Ledger are: COA, Fund, and Account codes. Transaction activity includes the sum of both periodic debits and credits.

The general ledger contains only balance sheet accounts. These accounts include the following:

Assets	Expenditure control

Liabilities	Transfer control

Fund balance	Budget controls

Fund additions	Encumbrance control

Fund deductions	Revenue control

General ledger control accounts contain the total debits/credits for their respective expenditure, transfer, budget, encumbrance, and revenue transactions. Detail transaction information for control accounts is maintained in the Banner operating ledger.

Revenue controls (budget, YTD actual for revenue account range)

Expenditure controls (budget, YTD actual for expenditure account range)

Transfer controls (budget, YTD actual for transfer account range)

Encumbrance controls (OPAL reservations or commitments)

Operating Ledger (OPAL)

The operating ledger contains transaction data for departmental operating accounts. Required COA elements for these transactions are fund, organization, account, and program. Optionally, the transactions may also include activity and/or location codes. Examples of operating ledger transactions include:

Revenues (tuition, fees, fines)

Expenditures (labor-related costs, supplies, services)

Transfers (mandatory and non-mandatory).

Transactional data that is entered or maintained in the operating ledger can include budget, YTD actual, encumbrance and grant activity. Operating ledger transactions are linked to their corresponding GL control accounts.

Other Finance Features

Features

Listed below are various other features of the Banner Finance Chart of Accounts module:

Purchasing/Receiving

Stores Inventory

Accounts Payable

Accounts Receivable

Budget Development

Fixed Assets

Endowment Management.

Banner Finance Reports

Reporting structures

Internal pre-defined values – these include the following:

Fund Types – there are two user-definable levels tied to internally defined fund types. Many reports are available based upon fund type.

Account Types – there are two user-definable levels tied to internally defined account types. Many reports are available based upon account type.

Fund structure – the hierarchical nature of the fund code aids roll-up reporting. Numerous reports are available based upon the fund structure.

Organization structure - the hierarchical nature of the organization code aids roll-up reporting. Various reports are available based upon organizational data.

Account structure - the hierarchical nature of the account code aids roll-up reporting. Both detail and summary reporting is available based upon the account code.

Extensive online queries

Banner offers users the capability to perform comprehensive online queries. The queries are available for the following areas:

executive level

transaction level

source document

trial balance

ad hoc queries.

Attribute reporting

This feature extends the “ad-hoc” reporting capabilities of the Banner Finance System. It enables you to

create user-defined attributes or categories of financial information

associate attributes to Fund, Organization, Account, Program, Activity, and location codes in the Chart of Accounts structure

summarize information from multiple levels in a single Chart of Accounts

support reporting across multiple Charts of Accounts

use attributes to retrieve and organize financial information in the institution-developed reports.

You can define up to three different levels of attributes. Basic level consists of

attribute types are the building blocks of this enhancement

attribute values are an additional, optional level of attributes – they are linked to Attribute types much in the same way that Fund codes are linked to Fund types in the Banner Finance System

attribute set codes enable you to create pre-defined groups of Attribute types – you can use them either to create an additional hierarchical level of attributes or to simplify data entry (set codes are optional)

depending on your needs, these levels can have a flat or a hierarchical structure.

After you define Attribute set codes, Attribute types, and/or Attribute values, you associate them to FOAPAL element codes in your Banner Finance System. Then, you can use a reporting tool in conjunction with Banner Object: Access (an additional Banner reporting tool) to create customized reports for your organization. (Refer to the GASB Reporting workbook for more details.)

Attribute set codes, Attribute types, and Attribute values enable you to easily retrieve financial information from the Banner database without having to remember complicated Charts of Accounts structures.

Banner user defaults

Each Banner Finance user has a record on the User Profile Maintenance Form (FOMPROF). This record may be used to assign certain fields to be automatically populated for the user. One of these fields is for the Chart of Accounts code. When a chart code is entered on the user’s profile record, the COA field on a form will always be populated with that chart code. The user will never need to enter the chart code on a form unless he/she desires to change to a different chart.

Budgeting options

Banner’s budgeting options allow users to use various combinations of these methods:

Hierarchical budgeting

Pooled budgeting

Line item budgeting

Hierarchical budgeting

This method of budgeting is used on fund and organization chart of account elements. It allows for the control of budgets at higher levels in the fund and organization hierarchies. Budget checking (NSF) edits the sum of the budgets entered at levels below the control level.

Pooled budgeting

Pooled budgeting is used on the account chart of accounts element. It allows for the control or pooling of budgets at higher levels in the account hierarchy. Budget checking (NSF) edits the sum of the budgets entered at levels below the pooled level.

Line item budgeting

Line item budgeting can be used in combination with the methods listed above or it may be used alone.

Rules and Security

Rule codes

In the Banner system, rule-based processing guides the system in accomplishing its tasks and objectives. Rule codes delivered with Banner Finance are designed to accomplish the following:

define transactions

specify edits by transaction

customize error messages

specify posting actions.

Although it is not necessary, Banner users can also create their own rule codes in order to achieve unique organizational objectives.

Security options

Banner Finance incorporates extensive security options from which users may select. The security options include these items:

Form level – controls access to individual forms and processes

Rule class – determines which users may work with specific rule codes and groups of rule codes

Organization code – limits users to query, update, and/or no access to specific organizational data

Fund type/fund – limits users to query, update, and/or no access to specific fund types and/or funds.

Tips and tricks

This document generally indicates that you are to use the Tab key to navigate from field to field. However, if you completely fill a field, in many cases the cursor will automatically skip to the next field. Always check to ensure that you are in the correct field before entering data! You may also use your mouse for navigation.

Set Up

Section goal

The purpose of this section is to outline the set-up process and detail the Steps to set-up your Banner Chart of Accounts.

Objectives

In this section you will learn how to

create a Chart Code

create Accounts and Account Type Codes

create Funds and Fund Type Codes

create Organizations Codes

create Program Codes

create Activity Codes

create Location Codes

create a bank ID and defined bank codes

complete the Chart of Accounts Maintenance Form (FTMCOAS)

create attribute set, type, and value codes.

Before you begin

Setting up your Chart of Accounts is critical to using the Banner Finance system. You will only have to create your Chart of Accounts once. To ensure accuracy and ease of set up, you should have an up-to-date, printed copy of your institution’s current chart of accounts on hand as reference while completing this workbook. Many people find it easiest to highlight each code as they create it in Banner.

The Banner forms are simple to fill out. This section will walk you through each step in detail. You will also need to decide if you want to display the new person fields for internationalization.

If you are taking this course in a classroom, sample data is provided throughout the workbook for you to use.

Displaying New Person Fields for Internationalization

Introduction

A major initiative of SunGard Higher Education is to make Banner more adaptable for use in different countries and with different languages. This ongoing effort is called internationalization (often abbreviated I18N).

As part of this initiative, Banner Finance 8.0 delivered several new fields in the database. These fields, however, were not visible on the user interface. With Banner Finance 8.3, these new fields can be displayed on forms and reports. This enhancement provides worldwide clients with a more robust, accurate, and efficient method of storing personal data.

New person fields

The following person fields are now available on several Banner Finance Forms and reports:

Field	Length	Description
Last Name Prefix	60 characters	Prefix that precedes a last name (for example, “Von” in the last name “Von Hintz”)
House Number	10 characters	Unique number assigned to each building on a street or in an area and used as part of the postal address in some countries (no validation)
Street Line 4	75 characters	Additional street address (no validation)
Telephone Country Code	4 characters	Code that designates the region and country of the telephone number (no validation)

Masked fields

Some users do not need these new fields on Banner forms. For this reason, Banner Finance 8.3 is being delivered with masking rules turned on for these new fields. This means the fields are not displayed on forms when you first upgrade to Banner Finance 8.3. If you want to display the new fields, you can do one of the following:

Run the gssmask.sql script, delivered with Banner General 8.2, to unmask the new fields. Refer to the Banner General 8.2 Release Guide for more details.

Use the Data Display Mask Rules Form (GORDMSK) to unmask the fields. You can unmask specific fields on specific forms. Refer to the Banner General Data Security Handbook for more details.

Masking rules apply only to name fields when they are displayed independently (that is, not concatenated). If fields are concatenated, the masking rules do not apply. It is assumed that the fields where data would normally be entered would be masked, preventing data entry. As a result, no values would be available for display on forms when the fields are concatenated.

Changed forms

Several forms can display the new person fields. Some forms display all new person fields; other forms display some of the new person fields. In general, the new person fields are displayed on forms as follows:

Last Name Prefix is displayed before the Last Name field.

House Number is displayed before the Street Line 1 field.

Street Line 4 is displayed after the Street Line 3 field. (If a form does not include Street Line 3, then Street Line 4 is not included on the form.)

Telephone Country Code is displayed before the Telephone Area Code field.

The following forms support the new person fields:

Entity Name/ID Search (FTIIDEN)

Finance Person Search (FOIIDEN)

Detail Encumbrance Activity Form (FGIENCD)

Creating a New Chart of Accounts

Purpose

You can use the Chart of Accounts Code Maintenance Form (FTMCOAS) set up a new Chart of Accounts for your institution and define FOAPAL elements, encumbrance, and budget carry forward information for this new Chart of Accounts code.

Effective date processing

All maintenance forms are in update mode when you enter the form. The third letter of the form name is M indicating it is a maintenance form. Each time you enter or change information on these forms, you must tell the system the date you want it to go into effect. Existing records cannot be deleted. You can terminate an existing record by entering a Termination date in that field. To change a record, you must make a copy of the original record, make the changes, and update the effective date field with the current date. If a record has been updated, the Next Change Date field will be valued. To find existing information, you execute queries. The original records are maintained as an audit trail.

The software is delivered with a seed chart of accounts - Chart B. The recommended practice for setting up test charts in a training database environment is to copy the seed data, keeping its effective date and making changes as necessary. It is very important to pay attention to the effective date as it can cause problems when filling out other forms. For example, if you make your effective date Feb 1, 2005, you will not be able to create a fiscal year that has a start date of July 1, 2004, because the chart was not in effect until Feb 1 of the following year (2005).

We assign a unique, one-character identification number or letter to our new chart of accounts. This permits the creation of multiple charts within the Finance system. The use of multiple charts is usually found in academic institutions that have a Foundation. All queries and reports are driven by the chart code. One problem with multiple chart processing is that the system cannot distinguish 1099’s by chart code. The vendor ID number stores the 1099 information. Requisitions, PO’s, Invoices, and JV’s are other document types that store data by the document number rather than the chart.

During the process of setting up your chart, we will set up a user profile for each Finance user and define the chart they will be using on transaction forms on the User Profile Maintenance Form (FOMPROF). This will populate the chart ID into the transaction forms for each user.

Banner form

Steps

Follow these steps to create a Chart of Accounts name and date information.

Access the Chart of Accounts Code Maintenance Form (FTMCOAS).

Enter your own unique one-character code in the Chart of Accounts field.

Note: This code is the primary identification code for the Chart of Accounts. Each participant in a classroom should enter his/her unique code.

Select the Active Status checkbox.

Notes: This indicates the current status of a Chart code. When this check box is selected, the chart is active and available for update.

The Last Activity field, which is display-only, shows the date when changes were last made to this record.

Enter the institution name in the Title field.

Notes: This field can contain up to a 35-character description or title of the chart and is a required field.

The Effective Date field defaults to the current date. However, if you are converting financial history, you may enter an earlier date. This field is required. Make a note of this date, as you will need it for a later Step.

This date format, DD-MMM-YYYY, is the only format that displays in Banner Finance. However, dates may be keyed in by entering only the day (if in the current month and year), or entering the day and month (if a different month in the current calendar year), or by entering the day, month, and two-digit year (if a different year).

Entering 23 and tabbing – Banner will display 23-Current Month-Current Year (e.g., 23-OCT-2003)

Entering 1023 and tabbing— Banner will display 23-OCT-Current Year (e.g., 23-OCT-2003)

Entering 102303 and tabbing— Banner will display 23-OCT-2003

Enter an end date for this record in the Term field (optional).

Notes: For this Steps, leave this field blank.

The display-only date in the Next Change field shows when your changes will take effect.

Enter A (Accrual Method) in the Method of Accounting field.

Note: This is a 1-character code that signifies the user-specified accrual method of accounting. This field is required. From an accounting perspective, it does not matter what you enter, since this is only an informational field.

Enter the beginning and ending month and day for the fiscal year in the Fiscal Year field.

Example: If your fiscal year begins July 1, enter 07/01 and 06/30. This field is required.

Notes: You cannot enter values in the Interfund Due/To Acct or Interfund Due/From Acct fields until you have defined account codes.

You will define account codes in a later procedure.

The Require Sets of Attribute Types check boxes, when selected, indicate that you wish to associate the selected codes to set codes in this Chart of Accounts. This is used in Attribute Reporting.

Steps

The budget control block fields will be used in available balance checking and tells the system how to handle transactions that exceed budget. Budgets are typically controlled at the Fund, Org., and Account level. In the following Steps, we will use these three fields for available budget checking.

Access the Budget Control block of FTMCOAS.

Note: The check boxes in this block are used in Available Budget Checking.

Enter Y in the Fund field.

Enter Y in the Organization field.

Enter Y in the Account field.

Enter N in the Program field.

Enter A in the Control Period field.

Notes: This determines the time period of the budget you will be working with.

A(nnual) - Checks the availability of funds annually, regardless of the fiscal period specified on an accounting entry.

Q(uarterly) - Budgeted funds within a quarter are available at the beginning of that fiscal quarter.

Y(ear-to-date) - Accumulates the budget for all the fiscal periods up to the transaction date of the entry and checks for availability on that basis.

All of these budget control parameters may be changed for individual fund types or funds. Here we are setting up system-wide defaults only.

The BAVL (Budget Availability) records are built based on the control periods specified in the Chart of Accounts, Fund Type, and Fund Code tables. Therefore, an Annual control period creates only one BAVL record and provides the greatest performance.

The Control Period is defined on three forms:

FTMCOAS – If you have not specified a control period value at the fund code and/or fund type level, the control period value here is used.

FTMFTYP – Overrides the control period value entered on FTMCOAS

FTMFUND – Overrides the control period value entered on FTMFTYP

Enter W (Warning) in the Control Severity field.

Note: This identifies the degree of severity allowed for a particular transaction.

IF you enter…	THEN…
W	a warning is issued, and the transaction is allowed.
E	an error message is displayed and the transaction is not permitted if there is no Budget available.

Check the Enc/Bud box to access the Encumbrance/Budget parameter window. You may also tab through this block into the next block.

Note: What this means is that when the system checks budget; it will look at Fund, Org., and Account, but not at Program. Hence, in the following scenario:

Fund	Org.	Acct.	Prog.	Budget

1000	120	6100	100	$100

1000	120	6100	200	50

1000	120	6225	100	75

1000	300	6225	20	200

Fund 1000, Org. 120, Acct 6100 will have $150 budget, regardless of program. If instead, we were checking by Fund and Org., but not by Account or Program, the same combination would have $225 total budget. If we were only checking by Fund, it would have $425 budget.

Introduction

The Organization Budget Status Form (FGIBDST) displays the values posted to the operating ledger so you see the total annual budget on this form regardless of the control period. The Budget Availability Status Form (FGIBAVL) displays only those funds available at the time of the query based on the specified control period.

Example: The Control Period is Quarterly. Budget entries of $10 are posted to each fiscal period. A total of $120 is available during the fiscal year with $30 being made available at the beginning of each quarter.

It is now the first day of the second quarter. FGIBDST displays $120 in the Adjusted Budget column, whereas FGIBAVL displays $60 in the Adjusted Budget column (the sum of the first and second quarter budget). The online budget checking will not allow more than $60 to be reserved or spent against this budget until the beginning of the third quarter.

Banner form

Parameters of FTMCOAS

The fields on this form are related to year-end processing. The specifics and details are covered in the Year-End Processing training session.

The Fund Balance Account field references a user-specified Fund Balance account used for posting year-end closing entries. This field cannot be entered until account codes are created. This field will be revisited and completed in a later Step.

The A/P Accrual Account field references a user-specified Accounts Payable account to be used for accruals. This field cannot be entered until account codes are created. This field will be revisited and completed in a later Step.

The A/R Accrual Account field references a user-specified Accounts Receivable account to be used for accruals. This field cannot be entered until account codes are created. This field will be revisited and completed in a later procedure.

Steps

Follow these steps to complete the process.

Select Parameters from the Options menu of FTMCOAS to navigate to the Parameters block.

Enter J001 in the Close OP Ledger Code field.

Note: This field contains a 4-character rule code used in the process that closes the General Ledger accounts to begin the fiscal year-end processing. This is a required field.

Enter E090 in the Rule Code field.

Note: This field contains a 4-character code used to roll the open encumbrances at the year-end into the new year.

Enter U in the Commit Type field.

Note: This field determines how the budget associated with open encumbrances is treated during the year-end process.

C = Committed – Encumbrances are treated as prior year encumbrances that roll to the current year. The purpose and budget are identified separately from the current year. Prior year encumbrance control is in the current year.

U = Uncommitted – Encumbrances roll to the current year with no distinction of being prior year. Balance is co-mingled with current year encumbrances.

Enter Y in the Budget Roll field.

Note: This field determines the year-end processing treatment for budgeted funds associated with encumbered values.

IF…	THEN…
Yes	the budget rolls forward.
prior year encumbrances are committed	it must be Yes.
prior year encumbrances are uncommitted	it can be Yes or No
No	the budget does not roll with the prior year encumbrances

Enter U in the Budget Disposition field.

Note: This field determines how remaining budgeted funds are to be treated at the end of the fiscal year if a rolled encumbrance is liquidated in the current year for an amount less than the encumbrance account. The possible values for this field are U (Unrestricted), R (Restricted), and N (No Action).

Unrestricted – For uncommitted encumbrances, if liquidated for less than the encumbrance, the available amount becomes available in the current year. If prior year encumbrances are uncommitted, must be Unrestricted.

Restricted – Any remaining amount after a committed encumbrance is liquidated is not available for use in the current year. It is reclassified to an appropriate account (that would need to be established in step 5).

No Action – Any remaining amount after a committed encumbrance is liquidated is not available for use in the current year. The dollars remain as restricted budget for that line item rather than be reclassified

Committed Encumbrances	Uncommitted Encumbrances

Budget Roll – must be Y	Budget roll can be Y or N

Budget disposition- R, U, or N	Budget disposition must be U

Enter 100 if 100 is not already the default in the Percent field.

Note: The value in this field determines the percentage of the budget to carry forward to the new fiscal year with encumbrances. This must be 100% when encumbrances are being rolled as committed.

Enter J020 in the Rule Code field in the Budget Carry Forward Parameters block.

Note: This field determines the accounting treatment of the budget roll process.

Enter P in the Budget Type field.

Note: This field defines the budget as Temporary or Permanent.

Enter O in the Budget Class field.

Note: This field defines whether the rolled budget is to be recorded in the new fiscal year as O for Original Budget or A for Adjusted Budget.

Enter 100 in the Percent field.

Notes: This field defines the percentage of the budget to be carried forward.

The Document Roll Parameters block is used to define the entity’s year end document roll policies, and includes settings for encumbrances, purchase orders, memo reserve, requisitions, labor encumbrances, and work orders. This is the only form that contains this definition.

The Spending Formula Hierarchy window is used with the Investment Management process and is not covered in this course.

Click the Save icon.

Click the Exit icon.

Establishing Fiscal Year Parameters

Introduction

Use the Fiscal Year Maintenance Form (FTMFSYR) to establish the fiscal year accounting period parameters for systems operations within Community College’s previously created Chart of Accounts.

Banner form

Steps

Follow these steps to complete the process.

Access the Fiscal Year Maintenance Form (FTMFSYR).

Enter the unique Chart of Accounts code you created in the previous lesson in the COA field.

Note: The display-only Last Activity field shows the last date that any changes were made to this record.

Enter the last two digits of the fiscal year you are setting up in the Fiscal Year field.

Enter the day, month, and year that marks the beginning of the fiscal year in the unlabeled Fiscal Year Start Date field.

Notes: Use the standard DD-MMM-YYYY format.

When you enter a fiscal year start date, Banner automatically calculates a fiscal year end date and displays it in the unlabeled Fiscal Year End date field.

The fiscal year start and end dates must match the month and days you entered in the Fiscal Year fields on FTMCOAS.

Enter 12 in the Periods field.

Notes: This specifies the number of accounting periods to be utilized during the fiscal year.

An accounting period is usually defined as one calendar month; however, the option for 13 four-week periods exists.

The Accrual Period field is only for period 14, and automatically displays Not Opened until year-end processing.

Perform a Next Block function.

Create all of the periods in this fiscal year.

Field/value parameters

The values for each field are described in this table.

Field	Value
Period	The number of periods is usually either 12 (one per month) or 13 (one for each four-week period).
Status	For each period, accept the default of N.
Start Date	For each period, the start date is automatically populated with the first day after the end date of the previous period.
End Date	For each period, the end date is the user-defined end date of the period. If this fiscal year has 12 periods, you will most likely enter the last day of the calendar month for that period. If this fiscal year has 13 periods, you will most likely enter a date that is four weeks after the start date.
Quarter Indicator	If this period represents the end of a quarter, select the check box.

Click the Save icon.

For each period, enter O (Open) in the Status field. All of the periods should be open in the training database. Do not open the Accrual Period.

Notes: The value in this field is used to change the status of individual periods from N (Not Open), to O (Open), to C (Closed). Note that if you open a period, you cannot manually close it and then manually reopen it. The job submission process FGPOCFP can be used to open and close periods at will.

You may not reopen a closed period. Periods must be opened and closed in sequence. You may not Open a future fiscal period when preceding periods have a status of Not Open, and you may not Close periods when the preceding periods are still Open. The only exception to this is that you may open period 01 in future fiscal years.

Click the Save icon.

Click the Exit icon.

Defining Internal Fund and Account Type Codes

Introduction

You can use the Account Type Validation Form (FTVATYP) and Fund Type Validation Form (FTVFTYP) to define internal fund and account type codes to be used with the Chart of Accounts on the System Data Maintenance Form (FTMSDAT).

Use this process to link the preset internal system values for Fund Type, Account Type, and Transaction Type (Sequence Number) to the new chart of accounts. This is a multi-purpose form; hence, the field names may appear confusing.

Next, establish Internal Pre-Defined Reporting Values for fund type, account type, and sequence number to the new chart of accounts. These internal values come with the software and the easiest way for linking the chart is to copy the setup from the seed data to your chart.

Banner form

Steps

Follow these steps to define codes for the Account Type Validation Form (FTVATYP) and Fund Type Validation Form (FTVFTYP).

Access the System Data Maintenance Form (FTMSDAT).

Perform an Enter Query function.

Enter FTVATYP in the Entity or Usage Code field.

Enter B in the Chart of Accounts field.

Perform an Execute Query function.

Insert a new record.

Duplicate the record.

Verify that FTVATYP is displayed in the Entity or Usage Code field.

Note: This field contains the 8-character code of the table for which you are establishing a value.

Verify that INTERNAL_ATYP_CODE is displayed in the Attribute Code field.

Note: If it is not, enter it. The value in this field names the column within the specified table.

Enter 10 in the Optional Code Number 1 field.

Note: The value in this field is user-defined codes that applies to the entity and attribute combination. It can be up to 8 characters long.

Enter the unique code for your Chart of Accounts in the Chart of Accounts field.

Note: Notice the effective date of the Chart of Accounts code in the Effective Date field. This must be the same date as in the Effective Date field on the Chart of Accounts Maintenance Form (FTMCOAS). If necessary, change this date.

Enter Asset in the Description/Title field.

Note: This field describes the hierarchy or title appropriate for the record being created. Change this description if desired.

Enter Asset in the Short Title field.

Note: The value in this field is often a shorter version of the entry in the Description/Title field. Change this description if desired.

Click the Save icon.

Repeat steps 6-14 for the values in the following tables.

Note: Table 1 lists account types and uses an attribute code of INTERNAL_ATYP_CODE, while Table 2 lists fund types and uses an attribute code of INTERNAL_FTYP_CODE.

Table 1

Entity or Usage Code	Attribute Code	Option Code	Description/Title
FTVATYP	INTERNAL_ATYP_CODE	10	Asset
FTVATYP	INTERNAL_ATYP_CODE	20	Liabilities
FTVATYP	INTERNAL_ATYP_CODE	30	Control Accounts
FTVATYP	INTERNAL_ATYP_CODE	40	Fund Balance
FTVATYP	INTERNAL_ATYP_CODE	50	Revenue
FTVATYP	INTERNAL_ATYP_CODE	60	Labor
FTVATYP	INTERNAL_ATYP_CODE	70	Expenditures
FTVATYP	INTERNAL_ATYP_CODE	80	Transfers
FTVATYP	INTERNAL_ATYP_CODE	90	Fund Additions
FTVATYP	INTERNAL_ATYP_CODE	95	Fund Deductions

Table 2

Entity or Usage Code	Attribute Code	Option Code	Description/Title
FTVFTYP	INTERNAL_FTYP_CODE	10	Current Unrestricted
FTVFTYP	INTERNAL_FTYP_CODE	20	Restricted Funds
FTVFTYP	INTERNAL_FTYP_CODE	30	Auxiliary Funds
FTVFTYP	INTERNAL_FTYP_CODE	40	Loan Funds
FTVFTYP	INTERNAL_FTYP_CODE	50	Quasi-Endowment Funds
FTVFTYP	INTERNAL_FTYP_CODE	60	Endowment Funds
FTVFTYP	INTERNAL_FTYP_CODE	70	Annuity & Life Income Funds
FTVFTYP	INTERNAL_FTYP_CODE	80	Agency Funds
FTVFTYP	INTERNAL_FTYP_CODE	90	Unexpended Plant Funds
FTVFTYP	INTERNAL_FTYP_CODE	92	Renewal and Replacement Funds
FTVFTYP	INTERNAL_FTYP_CODE	94	Retirement of Indebtedness Funds
FTVFTYP	INTERNAL_FTYP_CODE	96	Investment in Plant Fund
FTVFTYP	INTERNAL_FTYP_CODE	BK	Bank Fund

Banner form

Steps

Follow these steps to define codes for the FTVACTL, FTVFUND, FTVORGN, FTVACCT, FTVPROG, and FTVLOCN tables.

While you are still on the System Data Maintenance Form (FTMSDAT), again perform an Enter Query function.

Enter FTVACTL in the Entity or Usage Code field.

Enter SEQUENCE_NUMBER in the Attribute Code field.

Enter B in the Chart of Accounts field.

Perform an Execute Query function.

Perform an Insert Record function.

Perform a Duplicate Record function.

Verify that FTVACTL is displayed in the Entity or Usage Code field.

Note: This field contains the 8-character code of the table for which you are establishing a value.

Verify that SEQUENCE_NUMBER is displayed in the Attribute Code field.

Note: If it is not, enter it. The value in this field names the column within the specified table.

Enter 01 in the Optional Code Number 1 field.

Note: The value in this field is a user-defined code that applies to the entity and attribute combinations. It can be up to 8 characters long.

Enter the unique code for your Chart of Accounts in the Chart of Accounts field.

Notice the effective date of the Chart of Accounts code in the Effective Date field.

Note: This must be the same date as in the Effective Date field on the Chart of Accounts Maintenance Form (FTMCOAS). If necessary, change this date.

Enter Adopted Budget in the Description or Title field.

Note: This field describes the hierarchy or title appropriate for the record being created. Change this description if desired.

Enter Adopted Budget in the Short Title field.

Note: The value in this field is often a shorter version of the entry in the Description/Title field. Change this description if desired.

Review and save the record.

Repeat steps 1-11 for the values in Table 3.

Table 3

Entity or Usage Code	Attribute Code	Option Code Number 1	Description/Title
FTVACTL	SEQUENCE_NUMBER	01	Adopted Budget
FTVACTL	SEQUENCE_NUMBER	02	Budget Adjustments
FTVACTL	SEQUENCE_NUMBER	03	YTD Actual
FTVACTL	SEQUENCE_NUMBER	04	Encumbrances
FTVACTL	SEQUENCE_NUMBER	05	Budget Reservations
FTVACTL	SEQUENCE_NUMBER	06	Accounted Budget
FTVACTL	SEQUENCE_NUMBER	07	Temporary Budget

Banner form

Steps

Follow these steps to complete the procedure.

Perform an Enter Query function.

Enter FTVFUND in the Entity or Usage Code field.

Enter HIER_TITLE in the Attribute Code field.

Enter B in the Chart of Accounts field.

Note: If the query returns no values using B as COA, use A and retrieve values and desc/title of the Fund Group.

Perform an Execute Query function.

Perform an Insert Record function.

Perform a Duplicate Record function.

Verify that FTVFUND is displayed in the Entity or Usage Code field.

Note: This field contains the 8-character code of the table for which you are establishing a value.

Verify that HIER_TITLE is displayed in the Attribute Code field.

Note: If it is not, enter it. The value in this field names the column within the specified table.

Enter 1 in the Level field.

Note: This field contains the level number of the descending hierarchy descriptions.

Enter the unique code for your Chart of Accounts in the Chart of Accounts field.

Notice the effective date of the Chart of Accounts code in the Dates->Effective field.

Note: This must be the same date as in the Dates->Effective field on the Chart of Accounts Maintenance Form (FTMCOAS). If necessary, change this date.

Enter Fund Group in the Description/Title field.

Note: This field describes the hierarchy or title appropriate for the record being created. Change this description if desired.

Enter Fund Group in the Short Title field.

Note: The value in this field is often a shorter version of the entry in the Description/Title field. Change this description if desired.

Click the Save icon.

Repeat this set of steps for the values in Table 4.

Table 4

Entity or Usage Code	Attribute Code	Level	Description/ Title	Short Title
FTVFUND	HIER_TITLE	1	Fund Group	Fund Group
FTVFUND	HIER_TITLE	2	Fund Classification	Fund Classification
FTVFUND	HIER_TITLE	3	Fund Sub Classifications	Fund Sub Class
FTVFUND	HIER_TITLE	4	Continuation Awards	Continuation Awards
FTVFUND	HIER_TITLE	5	Grants and Project Funds	Grants and Projects
FTVORGN	HIER_TITLE	1	President/Board of Regents	President/ Board
FTVORGN	HIER_TITLE	2	Vice Presidents	Vice Presidents
FTVORGN	HIER_TITLE	3	Colleges	Colleges
FTVORGN	HIER_TITLE	4	Schools	Schools

Entity or Usage Code	Attribute Code	Level	Description/ Title	Short Title
FTVORGN	HIER_TITLE	5	Departmental Divisions	Department Divisions
FTVORGN	HIER_TITLE	6	Special Departmental Programs	Special Dept. Progs.
FTVORGN	HIER_TITLE	7	Unclassified Organizations	Unclassified Orgs.
FTVORGN	HIER_TITLE	8	Reserved Future Use	Reserved Future Use
FTVACCT	HIER_TITLE	1	Account Classification	Account Class
FTVACCT	HIER_TITLE	2	Account Object	Account Object
FTVACCT	HIER_TITLE	3	Primary Account	Primary Account
FTVACCT	HIER_TITLE	4	Sub-Account	Sub-Account
FTVPROG	HIER_TITLE	1	Prime Program Classification	Prime Program Class
FTVPROG	HIER_TITLE	2	Functional Programmatic Areas	Functional Programs
FTVPROG	HIER_TITLE	3	Departmental Programs	Departmental Programs
FTVPROG	HIER_TITLE	4	Special Programs	Special Programs
FTVPROG	HIER_TITLE	5	For Future Use	For Future Use
FTVLOCN	HIER_TITLE	1	Main Campus	Main Campus
FTVLOCN	HIER_TITLE	2	Building Location	Building Location
FTVLOCN	HIER_TITLE	3	Building Floor Location	Floor Location
FTVLOCN	HIER_TITLE	4	Classroom	Classroom
FTVLOCN	HIER_TITLE	5	Closets and Storage Areas	Closets and Storage Areas

Creating Level 1 Account Type Codes

Discussion

Create Level 1 and Level 2 account type codes using the Account Type Code Maintenance Form (FTMATYP) in order to organize the numerous accounts.

Only Level 1 account types may be linked to the internal system value. An unlimited number of Level 2 account types may be linked to Level 1 account types.

This is a user-defined scheme. You may use any scheme you like when setting up your own chart; however, Level 1 types and Level 2 types may not duplicate numbers.

Many of the Banner reports allow you to specify through the parameters what level you wish for your report. Some of the query forms may also be done on the level. The significance of the fund and account levels is the reporting, not the general ledger postings (which do not break down by level).

Level 1 Account Types

Represent headings and grand totals.

Example: Assets prints as the heading on the balance sheet and as a grand total at the end of the asset section of the report.

Level 2 Account Types

Represent sub-totals and print on the balance sheet as subordinate to Level 1 account types.

Example: Assets prints with its total below Accts. Receivable.

Define Level 1 account type codes

Define Level 1 external (user defined for reporting totals) account type codes to link your Chart of Accounts to the present internal codes.

Repeat the procedures used to define Level 1 external account type codes to define Level 2 external (report subtotals level) account type codes and link them to the Level 1 external codes we created. You must have at least one Level 2 account type for each Level 1 (even if they are assigned the same title).

Banner form

Steps

Follow these steps to complete the process.

Access the Account Type Code Maintenance Form (FTMATYP).

Enter the code for your Chart of Accounts in the Chart of Accounts field.

Note: This is a required field.

Enter 10 in the Account Type field.

Note: This field contains a 2-character account type code to be used for reporting purposes.

Enter Assets in the Title field.

Notes: The Effective Date field contains the effective date of the Chart of Accounts code.

Enter 10 in the Internal Account Type field.

Note: This field contains the internal system value used to let Banner Finance know how and where to process and report transactions.

Enter D in the Normal Balance field.

Notes: This indicates the typical balance in an account. Valid options are D (Debit), C (Credit), or 0 (Zero Balance).

Although 0 is an option for the Normal Balance, it can cause issues with some reports and internal processing. When in doubt, use Debit.

Click the Save icon.

After entering the above record, use the following Level 1 account type table to enter the remaining Level 1 account type records.

Level 1 account types

Account Type	Title	Internal Account Type	Normal Balance
10	Assets	10	D
20	Liabilities	20	C
30	Control Accounts	30	C
40	Fund Balances	40	C
50	Revenues	50	C
60	Salaries & Wages	60	D
70	Expenditures	70	D
80	Transfers	80	D
90	Fund Additions	90	C
95	Fund Deductions	95	D

Define Level 2 account type codes

After entering the Level 1 account type codes, perform a Rollback function and enter Level 2 account type codes, linking them to the Level 1 codes via the Predecessor field.

Steps

Follow these steps to complete the process.

Enter your Chart of Accounts code in the Chart of Accounts field.

Enter 11 in the Account Type field.

Note: This selects an account type to be used for reporting purposes. This is a required field.

Enter Cash and Cash Equivalents in the Title field.

Notes: This determines the name of the account type. This is a required field.

The Effective Date field contains the effective date of the Chart of Accounts code.

Enter 10 in the Internal Account Type field.

Notes: This field selects the internal system value used to let Banner Finance know how and where to process and report transactions.

To define a Level 2 account, the Predecessor Code field is needed to link the Level 2 codes to the Level 1 codes.

Enter 10 in the Predecessor Code field.

Note: This field determines which Level 1 account this account will be tied to. This is required for creating hierarchies.

Enter D in the Normal Balance field.

Note: This indicates the usual balance in an account. Valid options are D (Debit), C (Credit), or 0 (Zero Balance).

Click the Save icon.

Use the Level 2 account type table to enter the remaining account type records.

Click the Save icon.

Click the Exit icon.

Level 2 account types [Sample]

Account Type	Title	Internal Account Type	Predecessor Code	Normal Balance
11	Cash and Cash Equivalents	10	10	D
12	Accounts Receivable	10	10	D
13	Inventory	10	10	D
14	Investments	10	10	D
15	Plant & Equipment	10	10	D
16	Prepaid Items & Deferred Charges	10	10	D
17	Due from Other Funds	10	10	D
19	Other Assets	10	10	D
21	Accounts Payable	20	20	C
22	Accrued Liabilities	20	20	C
23	Deposits Payable	20	20	C
24	Bond Payable	20	20	C
25	Due to Other Funds	20	20	C
29	Other Liabilities	20	20	C
31	Control Accounts	30	30	C
41	Fund Balance	40	40	C
51	General Income	50	50	C
52	Tuition & Fees	50	50	C
53	Gifts	50	50	C

Account Type	Title	Internal Account Type	Predecessor Code	Normal Balance
54	Grants & Contracts	50	50	C
56	Endowment Income	50	50	C
57	Sales & Service	50	50	C
58	Financial Aid	50	50	C
59	Other Revenues	50	50	C
61	Salaries & Wages	60	60	D
62	Benefits	60	60	D
69	Fringe Benefits	60	60	D
71	Direct Expenditures	70	70	D
73	Services	70	70	D
76	Capital Expenditures	70	70	D
77	Depreciation Expense	70	70	D
78	Other Expenditures	70	70	D
81	Transfers In	80	80	D
82	Transfers Out	80	80	D
91	Fund Additions	90	90	C
96	Fund Deductions	95	95	D

Creating Account Codes

Introduction

The Account Code Maintenance form (FTMACCT) is used to create user-defined account codes, and tie them to the account types previously defined on the Account Type Code Maintenance Form (FTMATYP).

You can set up the account codes to be used in the new chart of accounts. You can link the new account codes to the Level 2 external account types established previously. Up to four hierarchical levels may be established within the account code structure.

Banner form

Steps

Follow these steps to create account codes for the Chart of Accounts.

Access the Account Code Maintenance Form (FTMACCT).

Enter the unique code for your Chart of Accounts in the Chart of Accounts field.

Enter 1100 in the Account field.

Note: This field allows entry for up to 6 characters.

Enter Cash & Cash Equivalents in the Title field.

Notes: This field contains the name of the account.

The Effective Date field contains the effective date of the Chart of Accounts code.

Leave the Predecessor Account field blank for this record.

Notes: This field indicates the higher-level account that is linked with this account. This field will be entered when this account is subordinate to another account (higher level).

Each time you enter a predecessor code, Banner validates the account type at commit time against the predecessor account type to ensure consistency with the hierarchy. Click on the exit door to exit the validation screen (FGQACTH) and return to the FTMACCT screen.

Enter N in the Data Entry field.

Note: Select Y if this account is used for data entry purposes or N for reporting purposes.

Enter 11 in the Account Type field.

Note: This field establishes the link between the account code and level 2 account types. A level 2 account type entered here references the next higher level to which the level 2 that is being created or modified reports in the hierarchy. The level 2 account type must already exist and be in effect before it can be entered here.

Leave the Income Type field blank.

Notes: The Income Type field is used for expenditure accounts that are used exclusively for 1099 income reporting.

The code entered here will default into the invoice form when this account is referenced for payments.

The Account Class is used to indicate asset accounts that are Fixed Assets.

The Asset Account field is used when the expense account code being established is for the acquisition of capital items. Once associated with the account code, this is used for automatic capitalization in the plant fund.

Leave the Depreciation Expense field blank.

Note: Depreciation Expense should be entered for all fixed asset accounts to indicate the expense account to which depreciation should be charged (the debit account in the depreciation transaction).

Leave the Pool Account field blank for this procedure.

Note: The Pool Account field allows you to enter a budget control account for pooling your budgets. Only the pool account will display on BAVL.

Leave the Fringe Account and Fringe Percent fields blank for this procedure.

Note: These fields are information-only fields. These will be used to handle fringe benefit charge-backs in conjunction with H/R - but are not implemented at this point. These fields have NO effect in Banner Finance.

Enter D in the Normal Balance field, indicating the usual balance in the account.

Select the Assign Attributes option from the Options menu to open the FOAPAL Attribute Association Form (FTMFATA) and associate set codes, attribute types, and/or attribute values to an account code.

After reviewing and saving the above record, use the following table to create more account code records.

Click the Save icon.

Click the Exit icon.

Account code records [Sample]

Account	Title	Predecessor Acct	Data Entry	Account Type	Normal Balance
1100	Cash and Cash Equivalents	N	11	D
1101	Cash - Operating	1100	Y	11	D
1102	Cash Payroll	1100	Y	11	D
1103	Petty Cash	1100	Y	11	D
1190	Claim on Cash	1100	N	11	D
1200	Accounts Receivable	N	12	D
1210	General Accounts Receivable	1200	Y	12	D
1220	Federal Grants Receivable	1200	Y	12	D
1230	State Grants Receivable	1200	Y	12	D
1240	Miscellaneous Receivable	1200	Y	12	D
1290	Accts Receivable Accrual	1200	Y	12	D
1300	Inventory	N	13	D
1310	Stores Inventory	1300	Y	13	D
1320	Book Store	1300	Y	13	D
1330	Stores	1300	Y	13	D
1400	Investments	N	14	D
1410	Bonds	1400	Y	14	D
1420	Preferred Stocks	1400	Y	14	D
1430	Common Stocks	1400	Y	14	D
1440	Money Market	1400	Y	14	D
1450	Real Estate	1400	Y	14	D
1500	Plant & Equipment	N	15	D
1510	Land	1500	Y	15	D
1520	Buildings & Improvements	1500	Y	15	D
1529	Accum. Deprec. Buildings Optional: a normal balance of D will display as a ‘-‘ on statements	1500	Y	15	C
1530	Other Improvements	1500	Y	15	D
1539	Accum. Deprec. Improvements	1500	Y	15	C
1540	Equipment	1500	Y	15	D
1549	Accum. Deprec. Equip.	1500	Y	15	C
1550	Library Books	1500	Y	15	D
1560	Art & Collections	1500	Y	15	D
1590	Construction in Progress	1500	Y	15	D
1700	Due From Other Funds	N	17	D
1701	Due From Other Funds	1700	Y	17	D
1900	Other Assets	N	19	D
1901	Other Assets	1900	Y	19	D
2100	Accounts Payable	N	21	C
2101	Accounts Payable – General	2100	Y	21	C
2104	Accounts Payable, Accrual	2100	Y	21	C
2140	Foreign Currency Exchange	2100	Y	21	C
2200	Accrued Liability	N	22	C
2201	Accrued Liability	2200	Y	22	C
2300	Deposits Payable	N	23	C
2301	Housing Deposits Payable	2300	Y	23	C
2400	Bonds Payable	N	24	C
2401	Bonds Payable	2400	Y	24	C
2500	Due to Other Funds	N	25	C
2501	Due to Other Funds	2500	Y	25	C
2900	Other Liabilities	N	29	C
2910	Interest Payable	2900	Y	29	C
3000	Control Accounts	N	31	C
3011	Revenue Control	3000	N	31	C
3012	Prior Year Revenue Control	3000	N	31	C
3013	Budgeted Revenue Control	3000	N	31	D
3014	Prior Year Budgeted Revenue Control	3000	N	31	D
3021	Expenditure Control	3000	N	31	D
3022	Prior Year Expenditure Control	3000	N	31	D
3023	Budgeted Expenditure Control	3000	N	31	C
3024	Prior Year Budgeted Expense Control	3000	N	31	C
3031	Transfer Control	3000	N	31	D
3032	Prior Year Transfer Control	3000	N	31	D
3033	Budgeted Transfer Control	3000	N	31	C
3034	Prior Year Budgeted Transfer Control	3000	N	31	C
3041	Encumbrance Control	3000	N	31	D
3042	Prior Year Encumbrance Control	3000	N	31	D
3043	Reserve for Encumbrance	3000	N	31	C
3044	Prior Year Reserve for Encumbrance	3000	N	31	C
3048	Reservation Control	3000	N	31	D
3049	Reservation Control Reserve	3000	N	31	C
3051	Budgeted Change to Fund Balance	3000	N	31	D
3052	Prior Year Budgeted Change to F/B	3000	N	31	D
4000	Fund Balance	N	41	C
4110	Fund Balance	4000	N	41	C
4115	Fund Balance - Unrestricted	4000	N	41	C
4120	Fund Balance – Restricted	4000	N	41	C
4125	Fund Balance – Temp Restricted	4000	N	41	C
5000	Revenue	N	51	C
5100	General Income	5000	N	51	C
5110	General Revenue	5000	Y	51	C
5120	Other Revenue	5000	Y	51	C
5200	Tuition & Fees	N	52	C
5210	Fall Term	5200	Y	52	C
5215	Winter Term	5200	Y	52	C
5220	Spring Term	5200	Y	52	C
5225	Summer Term	5200	Y	52	C
5300	Gifts	N	53	C
5310	Scholarships	5300	Y	53	C
5400	Grants & Contracts	N	54	C
5410	NSF Grant	5400	Y	54	C
5415	Department of HHS	5400	Y	54	C
5420	Federal Grants	5400	Y	54	C
5900	Other Revenue	N	59	C
5910	Special Income	5500	Y	59	C
6000	Salaries & Wages	N	61	D
6100	Salaries	6000	Y	61	D
6110	Administrative	6000	Y	61	D
6111	Faculty	6000	Y	61	D
6112	Clerical	6000	Y	61	D
6200	Benefits	N	62	D
6210	Medical	6200	Y	62	D
6220	Dental	6200	Y	62	D
6230	Retirement Insurance	6200	Y	62	D
6240	FICA	6200	Y	62	D
6250	Other Benefits	6200	Y	62	D
7000	Non Labor Expenses	N	71	D
7100	Direct Expenditures	7000	N	71	D
7110	Office Supplies	7100	Y	71	D
7120	Equipment	7100	Y	71	D
7130	Computers	7100	Y	71	D
7140	Travel	7100	Y	71	D
7150	Gas	7100	Y	71	D
7160	Electric	7100	Y	71	D
7180	Copy Center	7100	Y	71	D
7190	Contractual	7100	Y	71	D
7220	Indirect Expense	7200	Y	78	D
7300	Services	N	73	D
7311	Legal Services	7300	Y	73	D
7312	Audit Services	7300	Y	73	D
7314	Photography	7300	Y	73	D
7319	Misc. Contract	7300	Y	73	D
7320	Other Services	7300	Y	73	D
7600	Capital Expenditures	N	76	D
7610	Equipment	7600	Y	76	D
7620	Library Books	7600	Y	76	D
7700	Depreciation Expense	N	77	D
7710	Depreciation Expense	7700	Y	77	D
7800	Other Expenses	N	78	D
7810	Inventory Expense	7800	Y	78	D
7820	Indirect Expense	7800	Y	78	D
8100	Transfers In	N	81	D
8110	Transfer In	8100	Y	81	D
8200	Transfers Out	N	82	D
8210	Transfer Out	8200	Y	82	D
9000	Fund Additions	N	91	C
9100	Fund Addition	9000	Y	91	C
9600	Fund Deductions	N	96	D
9610	Fund Deductions	9500	Y	96	D

Defining Control Accounts

Introduction

You will create and define current and prior year control and offset accounts for the Chart of Accounts. Link your level 1 account types and the internal sequence numbers (transaction codes) with the appropriate control accounts in the new chart of accounts.

The linkages created here will specify the relationship of Revenue, Labor, Expense, and Transfer transactions in the Operating Ledger to the General Ledger (Balance Sheet).

Example: Adopted Budget transactions for Revenue accounts (in the Operating Ledger) will post two entries in the G/L, Budgeted Revenue Control (D) and an offset to Budgeted Change to Fund Balance to balance the entry in the G/L.

The purpose of the control account processing in Banner is to mirror the operating ledger transactions for the Balance sheet. The Control Accounts represent the current fiscal year activity while the Fund Balance Accounts would represent prior year. Each year, when balances are carried forward, Banner wraps up all the control accounts for each specific fund and totals them to the new years fund balance accounts. Then in the new fiscal year, the control accounts begin with a "Zero" balance.

Year-To-Date Actual Control Accounts

Revenue Control - Every year-to-date actual transaction affecting a Revenue account in the Operating Ledger (internal account type of 50) generates an equivalent entry in this General Ledger account.

Expenditure Control - Every year-to-date actual transaction affecting an Expenditure account in the Operating Ledger (internal account type of 60 or 70) generates an equivalent entry in this General Ledger account.

Transfer Control - Every year-to-date actual transaction affecting a Transfer account in the Operating Ledger (internal account type of 80) generates an equivalent entry in this General Ledger account.

Note: The NET of these accounts represents the actual year-to-date change to Fund Balance resulting from operations.

Encumbrance Control - Every encumbrance transaction or Budget Reservation (Sequence #5) in the Operating Ledger generates an equivalent entry in this General Ledger account and an offsetting entry to Reserve for Encumbrances.

Banner form

Steps

Follow these steps to complete the process.

Warning: If this step is not fully completed, the system will not recognize your operating ledger.

Access the Control Account Maintenance Form (FTMACTL).

Enter the unique code for your Chart of Accounts in the Chart of Accounts field.

Enter 50 in the Account Type field.

Note: This field selects an account type, as defined on the System Data Maintenance Form (FTMSDAT).

Enter 01 in the Sequence Number field.

Notes: This field contains a FTVACTL usage code previously defined on the System Data Maintenance Form (FTMSDAT).

The Effective Date contains the effective date of the Chart of Accounts code previously created.

Enter 3013 in the Control Account field.

Note: This field contains the account number of the General Ledger account representing the accumulated budgetary activity in the OPAL accounts- Revenues, Expenditures, Labor, and Transfers.

Enter 3051 in the Offset Account field.

Notes: This field defines the current year G/L control account to be used to offset or balance the transaction for a specific operating ledger Level 1 account type.
What you have just defined in Banner Finance. This record states that Adopted Budget transactions for Revenue accounts (in the Operating Ledger) will post to Budgeted Revenue Control and post an offset to Budgeted Change to Fund Balance in the General Ledger.

The Prior Year section is used whenever any encumbrances are rolled to the new year as Committed.

Note: This includes budgets and expenditures related to the Committed encumbrances. You will not set these up now, but remember to do so before running the year-end processes if you are planning to use the Committed encumbrance feature.

After entering and saving the above record, use the following table to create the remaining Control accounts.

Click the Save icon.

Click the Exit icon.

Control accounts table [Sample]

Account Type	Title	Sequence Number	Control Account	Offset Account	Control Account PY	Offset Account PY
50	Revenues	01	3013	3051	3014	3052
02	3013	3051	3014	3052
03	3011	3012
07	3013	3051	3014	3052
60	Labor	01	3023	3051	3024	3052
02	3023	3051	3024	3052
03	3021	3022
04	3041	3043	3042	3044
05	3048	3049	3042	3044
07	3023	3051	3024	3052
70	Direct Expenditures	01	3023	3051	3024	3052
02	3023	3051	3024	3052
03	3021	3022
04	3041	3043	3042	3044
05	3048	3049	3042	3044
07	3023	3051	3024	3052
80	Transfers	01	3033	3051	3034	3052
02	3033	3051	3034	3052
03	3031	3032
04	3041	3043	3042	3044
05	3048	3049	3042	3044
07	3033	3051	3034	3052

Verify your control accounts

To verify that your control accounts in the G/L equal the transactions in the Operating Ledger, use FGIBDST, FGIBDSR, or FGIBSUM and query on the fund code. The query form will display all of the accounts with a total at the bottom. Compare this total to the control account in the General Ledger.

*SDAT Internal Sequence numbers:

01 – Adopted Budget (offset)

02 – Budget Adjustment (offset)

03 – YTD Actual

04 – Encumbrances (offset)

05 – Reservations (offset)

06 – Accounted Budget (offset)

07 – Temporary Budget (offset)

Creating Level 1 and Level 2 Fund Types

Introduction

You can build and develop Level 1 external (user defined) fund types and link them to the preset internal codes. You can also build and develop Level 2 external fund types and link them to the Level 1 external fund types to organize funds within the Chart of Accounts.

Level 1 fund types represent the highest fund group within the fund hierarchy structure that all Level 2 fund types and Level 1 - 4 fund codes will roll up to. Level 2 fund types represent fund sub-groups within the fund hierarchy structure that Levels 1-4 fund codes will roll up to.

Banner form

Steps

Follow these steps to complete the process.

Access the Fund Type Maintenance Form (FTMFTYP).

Enter the unique code for your Chart of Accounts in the Chart of Accounts field.

Enter 10 in the Fund Type field.

Note: This field selects a fund type, as defined on the System Data Maintenance Form (FTMSDAT).

Enter Unrestricted Funds in the Title field.

Note: This field contains a 35-character description of the name of the fund.

The Effective Date field contains the effective date of the Chart of Accounts code previously created.

Enter 10 in the Internal Fund Type field.

Note: This field contains a 2-character Usage code previously defined on the System Data Maintenance Form (FTMSDAT).

Enter None in the Predecessor Fund Type field, as this fund type is a Level 1.

Note: This field is used to establish the link between Level 1 and Level 2 fund types. This is a required field for level 2 fund types.

The Capitalization Fund and Capitalization Equity Account fields are used in conjunction with the Asset Account on the Account Code record (see step 5) for automatic capitalization of fixed assets.

Select Organization from the pull-down list in the Default Override field.

Notes: This field is used to determine whether Fund or Organization takes precedence in the event that both default Program. Typically, for Current Unrestricted funds, it is best to let the Organization default the Program. For other types of funds, it is usually best to default from the fund. Budget Control, Control Period, Severity, Encumbrance Override

The Budget Control section consists of six fields, which specify what parameters will be used in available balance checking (if different from that specified at chart level) and how the system will handle transactions, which exceed budget. These are the same fields that we saw on the Chart of Accounts form FTMCOAS, except these are specific to the Level 1 Fund Types.
If these parameters are going to be the same as those set up in an earlier Steps, you may leave all of them blank. Note what you have just entered in Banner Finance.

After entering and saving the above record, use the following table to enter the remaining fund types.

Note: The internal fund types are pre-defined on FTMSDAT. We just made our user-defined external types the same, but you can make these different numbers and descriptions.

Warning: The bank should have its own fund created. In theory, it is not part of any of the other funds. It is an accumulation of all of the cash interfunds. If you were to include the bank fund in Current Unrestricted, you would overstate cash because it would include all of the cash interfunds plus the bank fund.

Click the Save icon.

Click the Exit icon.

Fund types table [Sample]

Fund Type	Title	Internal Fund Type	Predecessor Fund Type
10	Unrestricted Funds	10	None
20	Restricted Funds	20	None
30	Auxiliary Enterprise Fund	30	None
40	Student Loan Fund	40	None
50	Quasi Endowment Funds	50	None
60	Endowment Funds	60	None
70	Annuity and Life Income Funds	70	None
80	Agency Funds	80	None
90	Plant Funds	96	None
BK	Bank Fund	BK	None

Level 2 Fund types table [Sample]

Fund Type	Title	Internal Fund Type	Predecessor Fund Type
11	Current Unrestricted Funds	10	10
21	Current Restricted	20	20
22	Grants & Scholarships	20	20
31	Auxiliary Enterprise Funds	30	30
41	Student Loan Funds	40	40
51	Quasi Endowment Funds	50	50
61	Endowments	60	60
71	Annuity & Life Income	70	70
81	Agency Funds	80	80
91	Unexpended Plant Funds	96	90
92	Renewal & Replacement	96	90
93	Retirement of Indebtedness	96	90
94	Investment in Plant	96	90
99	Bank Fund	BK	BK

Developing Fund Codes

Introduction

You can define fund codes to encompass your institution’s diverse funds, categorizing them using a fund type.

The fund codes represent the funding sources for the institution. Fund codes consist of five levels of hierarchy and are linked to Level 2 fund types (established in a previous topic). The hierarchy is built from the top level down to the last level in the hierarchy. The first level does not report to any other level, while all levels below the first level have a predecessor fund code (the fund that it reports or rolls up to). The key thing to remember when building your fund codes is that you must have a separate fund code for every project (grants), loan, and endowment fund.

Banner form

Steps

Follow these steps to define fund codes for your Chart of Accounts and assign them to a previously created fund type.

Access the Fund Code Maintenance Form (FTMFUND).

Enter the unique code for your Chart of Accounts in the Chart of Accounts field.

Note: This is a required field.

The Grant and Proposal fields are used in grant accounting and are left blank for this procedure.

Enter 9900 in the Fund field.

Note: This field contains a code to uniquely identify a fund.

Enter Bank Fund in the Title field.

Note: This field contains the name of the fund.

The Effective Date field contains the effective date of the Chart of Accounts code previously created.

Uncheck the box to signify that this account will be used for reporting in the Data Entry field.

Note: Leaving it checked signifies that this account will be used for data entry.

Enter 99 in the Fund Type field.

Note: This field represents a Fund type previously defined and establishes the link between the fund code and the Level 2 fund types (step 7).

Leave the Predecessor Fund field blank for this record.

Notes: This field identifies the higher-level fund that this fund is linked to.

In later procedures when the Predecessor Fund field is entered, the Fund Hierarchy Form (FGQFNDH) appears on the screen.

Select Continue in the left navigation pane to return to the previous screen once the displayed fund hierarchy is confirmed.

Click Save to commit the record and select the Assign Attributes option from the Options menu to open the FOAPAL Attribute Association Form (FTMFATA) and associate set codes, attribute types, and/or attribute values to a fund code if you’re assigning attributes.

After entering and saving the above record, use the following table to enter the remaining fund codes.

Click the Save icon.

Click the Exit icon.

Note: For this procedure, we will not be entering data in the remaining fields. What follows is an explanation of each field.

Fund code records [Sample]

Fund code	Title	Data Entry	Fund Type	Predecessor Fund Code
1000	Current Unrestricted Funds	Unchecked	11
1010	General Funds	Checked	11	1000
2000	Current Restricted Funds	Unchecked	21
2110	General Restricted Fund	Checked	21	2000
2120	Other Restricted	Checked	21	2000
2200	Grants and Scholarships	Unchecked	22
2210	NSF Grant	Checked	22	2200
2220	Department of HHS	Checked	22	2200
2230	Pell Grant	Checked	22	2200
3000	Auxiliary Enterprise	Unchecked	31
3100	Auxiliary Enterprise	Checked	31	3000
3110	Central Stores	Checked	31	3000
3120	Book Store	Checked	31	3000
4000	Student Loans	Unchecked	41
4110	Federal Perkins Loan	Checked	41	4000
4120	Stafford Loan	Checked	41	4000
5000	Quasi Endowments	Unchecked	51
5110	Enrollment Management	Checked	51	5000
6000	Endowments	Unchecked	61
6110	Endowed Scholarship	Checked	61	6000
6120	Other Endowments	Checked	61	6000
7000	Annuity & Life Income	Unchecked	71
7110	Annuity Fund	Checked	71	7000
7120	Life Income Fund	Checked	71	7000
8000	Agency Funds	Unchecked	81	None
8110	Expendable Trust	Checked	81	8000
8120	Non-Expendable Trust	Checked	81	8000
9100	Unexpended Plant	Unchecked	91
9110	Physical Plant Operations	Checked	91	9100
9200	Renewal & Replacement	Unchecked	92
9210	Renewal & Replacement	Checked	92	9200
9300	Retirement of Indebtedness	Unchecked	93
9310	Building Bond 02-182	Checked	93	9300
9600	Investment in Plant	Unchecked	94
9610	Investment in Plant	Checked	94	9600
9900	Bank Fund	Unchecked	99
9910	Bank Fund	Checked	99	9900

Defining a Fund Balance Account for a Multiple Fund Balance Institution

Introduction

The Multiple Fund Balance Processing feature allows you to close Revenue, Expense, and Transfer control accounts to more than one fund balance account at year-end and during concurrent year processing. This feature is optional. Implement it on the following forms:

FOASYSC: Check the Multiple Fund Balance checkbox to initiate multiple fund balance processing.

FTMCOAS: Make sure that a Fund Balance Account is defined in the Parameters Window on this form. The system uses this account for closing encumbrance and budget activity.

FTMFUND: Use the drop-down list to populate the Multiple Fund Balance Ind field on this form. This indicator allows the system to determine the criteria for selecting the correct Fund Balance Accounts.

If you are not using the multiple fund balance feature, the system uses the Fund Balance Account defined on the Chart of Accounts Maintenance Form (Procedure 1) as the default fund balance account to which all operating account year-to-date control activity will close to at year-end.

Banner form

Steps

Follow these steps to complete the process.

Access the Fund Balance Account Maintenance Form (FTMFBAL).

Enter your Chart of Accounts code in the Chart of Accounts field.

Enter the effective date of this record in the Effective Date field.

Enter a termination date, if appropriate in the Termination Date field. For this procedure, leave this field blank.

Enter 21 in the Fund Type field.

Note: This field selects a fund type defined on the Fund Type Maintenance Form (FTMFTYP). Funds with this multiple fund balance indicator will look to their fund type Level 2, or, if this is not specified, fund type level 1 to determine the fund balance account into which the operating ledger will be closed.

Enter 4120 in the Fund Balance Account field.

Note: This field contains a one-to-six-character Fund Balance account code.

Enter T in the Restriction Indicator field.

Note: This field is a restriction indicator that determines what type of Fund/Account combination you want to report on FASB 117 reports. Valid options include T (Temporary Restricted), U (Unrestricted), and P (Permanently Restricted).
On any one line in FTMFBAL, you may either enter the Fund Type (#5) or the Fund and the Account (#8 and #9). To identify both for multiple fund balance processing requires the addition of two separate line items.

Enter 2000 in the Fund field.

Note: This field selects the fund code name. Funds with this multiple fund balance indicator will look to their fund code to determine the fund balance account into which the operating ledger will be closed.

The Account field contains a one-to-six-character account code.

Note: For this procedure, use 6100. Funds with this multiple fund balance indicator will look to the individual account code to determine the fund balance into which the operating ledger will be closed. This option allows you to use multiple fund balance accounts for a single fund.

Enter 4125 in the Fund Balance Account field.

Note: This field contains a one-to-six-character Fund Balance account code.

Enter T in the Restriction Indicator field.

Notes: This field is a restriction indicator that determines what type of Fund/Account combination you want to report on FASB 117 reports.

Valid options include T (Temporary Restricted), U (Unrestricted), and P (Permanently Restricted).

Click the Save icon.

Click the Exit icon.

Note: The Fund Balance Account Report (FGRFBAL) provides a hard copy listing of information entered through the Fund Balance Account Maintenance form. Execute this report through a particular “As of” date.

The Balance Forward Processing Report (FGRGLRL) and the Close Operating Accounts Report (FGRCLOP) stop processing if you have not defined fund balance accounts on FTMFBAL for the indicator referenced on each Fund record. The system stops processing if it finds that the total of the Fund Balance accounts to which it is attempting to close do not equal the amounts in the Operating ledger Control Accounts.

Creating a Bank ID

Introduction

You can create an ID for each of the Banking Institutions that your institution does business with. These ID’s will be used in the “Define Bank Accounts” lesson.

Banner form

Steps

Follow these steps to complete the process.

Access the Person Identification Form (FOAIDEN).

Enter NEXT or the bank’s tax id number in the ID field.

Note: This field identifies the bank, and can contain either a system-generated nine-character code or a client-specified alphanumeric value.

Click the Generate ID icon.

Result: the Common Matching Entry Form opens.

Select a matching rule in the Matching Rule field.

Enter the name of the bank in the Non-Person field.

Note: This is a 60-character description field (Organization-specific value). The name fields are available for an individual represented as a person instead of a corporation.

Enter the bank’s tax id number in the SSN/SIN/TIN field.

Enter BU in the Address Type Code field.

Note: This field contains a 30-character address type code already defined on (STVATYP)

Enter the address, city, state, zip code, and phone information in the appropriate fields.

Click the Save icon

Click the Yes button.

Click the OK button.

Result: The Person Identification Form (FOAIDEN) re-opens with the data you entered displayed. Record the ID number for future use.

Click the Exit icon.

Defining Bank Codes for the Chart of Accounts

Introduction

You can set up the bank codes used by the new chart of accounts and to link each bank code to a cash account and cash interfund account.

In a previous steps, you established a Bank fund. This is a special fund unique to cash processing to facilitate cash management. It is designed to provide a trial balance showing the total cash balance for your institution and the breakdown of where the cash is deposited. It also facilitates the bank reconciliation process. The bank code must be entered on all invoices, cash receipts, and cash interfund transactions. As mentioned previously, it is recommended that you default the bank code on the fund for more efficient processing and error reduction.

We will set up one “Cash Interfund” Account and multiple cash accounts. It is this account residing in the Bank fund that shows the total cash for the institution. We will also set up multiple cash accounts, which are the individual fund’s claim on that total cash. For example, you may use one cash account for accounts payable disbursements and another for deposits. Alternatively, you may have different actual bank accounts that need to be kept separate.

Banner form

Steps

Follow these steps to complete the process.

Access the Bank Code Rule Form (GXRBANK).

Enter your initials in the Bank field.

Note: This field contains a unique two-character code to represent a bank and drives the bank reconciliation process.

Enter Operating Cash as the name for the bank you are defining in the Name field.

Notes: The Effective Date field should contain the same effective date used through out the chart.

The Base Currency field is defined on GUACURR and left blank for this exercise.

Enter a unique identification number for the financial organization represented in the Bank ID field.

Note: This field contains a nine-character code. Use the ID created in Lesson 10 for Bank ID.

Enter 23557631 in the Bank Account Number field.

Note: This field contains a 15-character code that the bank uses to recognize you. This is usually the number that is encoded on the checks. A bank can have more than one bank account number.

Enter your Chart of Accounts code in the Chart of Accounts field.

Note: This links your chart to the bank code.

Enter 9910 in the Bank Fund field.

Note: This field contains a one-to-six-character code of the fund connected with the financial organization.

Enter 1101 in the Cash Account field.

Note: This field contains the account number of the organization’s cash balances in the bank fund.

Enter 1090 in the Interfund Account field.

Note: This field contains the account number of the organization’s cash balance in the Operating Ledger.

Click the Save icon.

Perform a Rollback function.

Enter 02 in the Bank Code field for the next cash account.

Enter Payroll Cash in the Name field.

Enter 9910 in the Bank Fund Field and 1102 in the Cash Account field.

Enter 1190 in the Cash Interfund account

Click the Save icon.

Perform a Rollback function.

Enter 03 in the Bank Code field.

Enter State Treasurer Cash in the Name field

Enter 9910 in the Bank Fund field and

Enter 1103 in the Cash Account field.

Enter 1190 in the Cash Interfund account.

Click the Save icon.

Click the Exit icon.

Establishing Program Codes

Introduction

Program Codes may have up to five levels of hierarchy. Program codes define all of the functions that the institution is involved in. While the Organization codes identify who is spending the money, the Program codes define what the money is being spent on.

Expenditure, encumbrance, revenue, and transfer transactions must have Fund, Organization., Account, and Program codes to post to the Operating Ledger. If you do not track accounting by these elements, you may set up “dummy” organizations and programs. Direct entries to the General Ledger only need Fund and Account.

Banner form

Steps

Follow these steps to complete the process.

Access the Program Code Maintenance Form (FTMPROG).

Enter your Chart of Accounts code in the Chart of Accounts field.

Enter 00 in the Program field.

Note: This field contains the code of the program you are Enter. This exercise is creating the “dummy” program.

Enter Non-Programmatic Revenue in the Title field.

Note: This field contains the name of the program you are creating.

Enter the effective date of the Chart of Accounts code previously created in the Effective Date field.

Select the checkbox in the Data Entry field to indicates that this program should be used for data entry..

Leave the Predecessor Program field blank for this record.

Note: This field selects the higher-level program to which this program is linked.

Options – Assign Attributes

Select Assign Attributes from the Options menu to open the FOAPAL Attribute Association Form (FTMFATA) and associate set codes, attribute types, and/or attribute values to a program code.

Click the Save icon.

Repeat steps 2-9 using the following table to enter the remaining program codes.

Click the Exit icon.

Program code records [Sample]

Program	Description	Data Entry	Predecessor Program
10	Instruction	Checked
20	Research	Checked
30	Public Service	Checked
40	Academic Support	Checked
50	Student Services	Checked
60	Instructional Support	Checked
70	Physical Plant	Checked
80	Residential Services	Checked
90	Auxiliary Services	Unchecked
91	Food Services	Checked	90
92	Residential Services	Checked	90
93	Bookstore	Checked	90

Establishing an Activity Code

Introduction

You can use the Activity Code Maintenance Form (FTMACTV) to describe a new activity code to ensure activities are accurately recorded.

Banner form

Steps

Follow these steps to complete the process.

Access the Activity Code Maintenance Form (FTMACTV).

Enter your Chart of Accounts code in the Chart of Accounts field.

Enter 1234 in the Activity field.

Note: This field contains a unique code to identify the activity you are creating.

Enter Special Activities in the Activity Title field.

Note: This field contains a description of the activity being created.

Enter the effective date of the record being created in the Effective Date field.

Select the Assign Attributes option from the Options menu to open the FOAPAL Attribute Association Form (FTMFATA) and associate set codes, attribute types, and/or attribute values to an activity code.

Click the Save icon.

Click the Exit icon.

Establishing a Location Code

Introduction

You can use the Location Code Maintenance Form (FTMLOCN) to create a new location code to begin the systematic categorization of your institution’s facilities. Location codes are used with fixed assets and plant management.

Banner form

Steps

Follow these steps to complete the process.

Enter your Chart of Accounts code in the Chart of Accounts field.

Enter Arts building in the Location Title field.

Note: This field contains a description of the location being created.

Select the Assign Attributes option from the Options menu to open the FOAPAL Attribute Association Form (FTMFATA) and associate set codes, attribute types, and/or attribute values to a location code.

Click the Exit icon.

Establishing Organization Codes

Introduction

You can use the Organization Code Maintenance Form (FTMORGN) to create organization codes for each of the organizations. You can include detailed descriptions and define Chart of Accounts information for each organization.

Banner form

Steps

Follow these steps to complete the process.

Access the Organization Code Maintenance Form (FTMORGN).

Enter your Chart of Accounts code in the Chart of Accounts field.

Enter 001 in the Organization field.

Note: This field contains the code of the organization you are creating.

Enter University in the Organization Title field.

Note: This field describes the title of the organization.

The Effective Date field contains the effective date of the organization record you are creating.

Uncheck the Data Entry checkbox.

Note: If checked, this checkbox indicates that the organization code is to be used for data entry; if unchecked, it indicates the organization code is to be used for reporting.

Leave the Predecessor Organization field blank for this record.

Note: This field indicates the higher-level organization to which this organization is linked.

Leave the Default Fund field blank for this record.

Note: This field indicates the fund that is primarily associated with this fund.

Leave the Default Program field blank for this record. This field indicates the program that is primarily associated with this program.

Select the Assign Attributes option from the Options menu to open the FOAPAL Attribute Association Form (FTMFATA) and associate set codes, attribute types, and/or attribute values to an organization code.

Click the Save icon.

Repeat steps 2-11 using the following table to enter the remaining Organization codes.

Click the Exit icon.

Organization codes [Sample]

Organization	Title	Data Entry	Predecessor Organization	Default Fund	Default Program
1	University	Unchecked
10	President	Unchecked	1
100	Office of the President	Checked	10	1010	60
110	V.P.of Finance and Administration	Unchecked	10
1100	Finance Office	Checked	110	1010	60
1101	Admissions	Checked	110	1010	60
1102	Financial Aid	Checked	110	1010	60
200	Dean of Arts and Sciences	Unchecked	10
2100	Art	Checked	200	1010	10
2110	Biology	Checked	200	1010	10
2115	Chemistry	Checked	200	1010	10
300	Dean of Humanities	Unchecked	10
3101	Sociology	Checked	300	1010	10
3102	Psychology	Checked	300	1010	10
3103	History	Checked	300	1010	10
3104	Speech	Checked	300	1010	10
400	Support Staff	Unchecked	10
4010	Custodial	Checked	400	1010	60
500	Auxiliary Enterprises	Unchecked	10
5010	Book Store	Checked	500	3120	93

Creating an Agency Code

Introduction

Use the Agency Code Maintenance Form (FTMAGCY) to create an agency code and define identification and address information for it. Agencies are considered entities external to your institution with which you hold reporting relationships. The agency structure is a five-level, user-defined hierarchy.

Banner form

Steps

Follow these steps to complete the process.

Access the Agency Code Maintenance Form (FTMAGCY).

Enter USDA in the Agency field.

Note: This field contains the name of the agency you are describing.

Enter a name in the Contact field.

Note: This field lists the person or entity to contact within the agency.

Select the Address tab.

Enter BI in the Address Type field.

Note: This field lists the type of address represented. BI will populate in the Type field at the bottom of the screen.

Enter 01 in the Sequence Number field.

Note: This field contains a user-defined sequence of the addresses of the contact.

Select the Address tab.

Enter an address in the Address field.

Note: This field contains the address of the agency.

Enter a city in the City field.

Note: This field contains the city in which the agency resides.

Enter a state in the State/Prov field.

Note: This field contains the state (or province) in which the agency resides.

Enter a zip code in the ZIP/PC field.

Note: This field contains the ZIP code of the agency.

Click the Save icon.

Creating Account Index Codes

Introduction

Use the Account Index Code Maintenance Form (FTMACCI) to construct an Account Index to better facilitate FOAPAL entries into Banner.

Banner form

Steps

Follow these steps to complete the process.

Access the Account Index Code Maintenance Form (FTMACCI).

Enter your Chart of Accounts code in the Chart of Accounts field.

Enter BOOKS in the Account Index field.

Note: This field contains a user-defined name for this account.

Enter Bookstore Revenue in the Account Index Title field.

Note: This field contains a description of the Account Index previously entered.

Enter the 9-character code (DD-MON-YYYY) in the Effective Date field for the effective date.

Enter 3120 in the Fund field.

Note: This field specifies the fund code to be used in Available Budget Checking.

Enter 5010 in the Organization field.

Note: This field specifies the organization code to be used in Available Budget Checking.

Enter 5510 in the Account field.

Note: This field specifies the account code to be used in Available Budget Checking.

Enter 93 in the Program field.

Note: This field specifies the program code to be used in Available Budget Checking.

Enter 1234 in the Activity field.

Note: This field contains a previously defined activity code.

Enter ART101 in the Location field.

Note: This field contains a previously created location code.

Click all of six of the Check to Override checkboxes to override the system-populated FOAPAL elements.

Click the Save icon.

Click the Exit icon.

Assigning a Financial Manager to the Chart of Accounts

Introduction

You can use the Financial Manager Maintenance Form (FTMFMGR) to define a financial manager in the Banner Finance System to oversee the newly completed Chart of Accounts.

Banner form

Steps

Follow these steps to assign a financial manager to maintain your Chart of Accounts.

Access the Financial Manager Maintenance Form (FTMFMGR).

Enter NEXT in the Financial Manager field.

Note: This field identifies the financial manager.

Enter a last name in the Last Name field.

Note: This field contains the last name of the financial manager you are describing.

Enter a name in the First Name field.

Enter an initial in the Middle Name field.

Enter a title of the financial manager in the Title field.

Check the Active Status checkbox to signify that the financial manager’s record you are creating is active.

Note: The Effective Date field contains the effective date of the record you are creating.

Enter your Chart of Accounts code in the Chart of Accounts field.

Enter 1100 in the Assigned Organization field.

Note: This field specifies the organization to which the financial manager is assigned.

Enter ART101 in the Assigned Location field.

Note: This field specifies the physical location of the organization’s financial manager.

Enter BU in the Default Address Type field.

Note: This field contains the address type of the financial manager.

Enter 01 in the Sequence Number field.

Note: This field specifies a user-defined sequence number edited with the address.

Click the Save icon.

Address tab

Select Address tab.

Enter BU in the Type field.

Note: This field contains the address type of the financial manager. More than one address may be associated with the Financial Manager.

Enter 01 in the Sequence Number field.

Enter an address in the Address field.

Note: This field specifies the address of the financial manager.

Enter a city in the City field.

Enter a state in the State or Province field.

Enter a zip code in the ZIP or Postal Code field.

Click the Save icon.

Click the Exit icon.

Reviewing the Currency Code Maintenance Form

Introduction

Use the Currency Code Maintenance Form (GUACURR) to verify that the currency code and conversion data is correct for your Chart of Accounts.

Banner form

Steps

Follow these steps to complete the process.

Access the Currency Code Maintenance Form (GUACURR).

Enter USD in the Currency Code field.

Note: This field contains the currency code used by your Chart of Accounts.

Enter 2101 in the Accounts Payable Account field.

Notes: This field identifies the Accounts Payable account code to be used if an entity intends to produce a check in a foreign currency rather than through a disbursing agent.

This form is non-chart specific. In a multi-chart environment, certain account codes must remain consistent between the multiple charts. The Accounts Payable account code is an example of an account code that must remain consistent.

Enter 2140 in the Exchange Account field.

Enter 1 in the Conversion Rate field.

Note: This field represents the conversion rate to the base currency amount.

Click the Save icon.

Click the Exit icon.

Maintaining Overall System Information for the Installation

Introduction

Use the Installation Control Form (GUAINST) to review the base currency code and make sure it is appropriate for your Chart of Accounts.

Banner form

Steps

Follow these steps to complete the process.

Access the Installation Control Form (GUAINST).

Enter an address in the Address field.

Enter 157 in the Nation field.

Enter a phone number in the Phone field.

Select WNT from the drop-down list in the Operating System field.

Note: This field affects how commands to execute batch jobs are constructed.

Select Higher Education from the drop-down list in the Installation field.

Note: This field provides a description of the organization.

Enter E400 in the Instance Name field.

Note: This field contains a four-character, user-defined code.

Enter 5 in the ZIP or Postal Code Length field.

Note: This field determines the number of positions to use when looking up zip codes on the ZIP/Postal Code Validation Form (GTVZIPC).

Enter USD in the Base Currency field.

Enter 10 in the Maximum Number of Open Forms field.

Note: This field determines the number of open forms allowed by Banner.

Enter 49 in the Century Pivot field.

Note: This field contains the two-character number of the year by which the century will default to 20xx as opposed to 19xx (to account for the turn of the millennium).

Select MDY in the Date Format field.

Note: This field determines the date format to be used by Banner.

Enter the current release number of the Banner General System in the General Release field.

Enter the current release number for each Banner System in use at the institution in the Release fields in the Installation Information block.

Click the Save icon.

Click the Exit icon.

Completing the Chart of Accounts Maintenance Form

Introduction

Use the Chart of Accounts Code Maintenance Form (FTMCOAS) to enter values for multiple Interfund and Account fields.

Banner form

Steps

Follow these steps to complete the process.

Access the Chart of Accounts Code Maintenance Form (FTMCOAS).

Perform a query on your Chart of Accounts in the Chart of Accounts field. The record previously entered will populate the form

Perform an Insert Record function.

Perform a Duplicate Record function.

Enter the current date (DD-MM-YYYY) in the Effective Date field.

Enter 1190 in the Interfund Due To Account field.

Enter 1190 in the Interfund Due From Account field.

Enter Y in the Encumbrance or Budget field.

Select Parameters from the Options menu,

Enter 4110 in the Fund Balance Account field.

Note: This field contains a user-specified Fund Balance account used for posting year-end closing entries.

Enter 2104 in the Accounts Payable Accrual Account field.

Note: This field contains a user-specified Accounts Payable account to be used for accruals.

Enter 1290 in the Accounts Receivable Accrual Account field.

Note: This field contains a user-specified Accounts Receivable account to be used for accruals.

Click the Save icon.

Click the Exit icon.

Creating Attribute Set, Type, and Value Codes

Introduction

You can use several forms within the Banner Finance System to set up attribute set codes, types, and values and attach them to the existing FOAPAL codes created in earlier exercises.

You can:

Define attribute types on the Attribute Type Maintenance Form (FTMATTT)

(Optional) If you want to use attribute values, define them on the Attribute Value Maintenance Form (FTMATTV)

(Optional) If you want to use set codes, select the appropriate Require Sets of Attribute Types checkboxes on the Chart of Accounts Code Maintenance Form (FTMCOAS)

(Optional) If you want to use set codes, define them on the Attribute Type Set Maintenance Form (FTMATTS)

Associate set codes, attribute types, and/or attribute values to FOAPAL codes on the FOAPAL Attribute Association Form (FTMFATA)

Query FOAPAL code association records on the FOAPAL Attribute Association Query Form (FTIFATA)

Banner form

Use the Attribute Type Maintenance Form (FTMATTT) to create, change, inactivate, delete, and query attribute types. Attribute types are codes that enable you to categorize financial information for reporting purposes.

Steps

Follow these steps to complete the process.

Access the Attribute Type Maintenance Form (FTMATTT).

Perform an Insert Record function.

Enter the Chart of Accounts code you created previously in the COA field.

Enter CAMPUS in the Attribute Type field.

Enter Campus-based reporting in the Description field.

Notes: This field contains a user-defined 50-character description of the attribute type code.

The Valid for All and FOAPAL checkboxes allow you to identify the FOAPAL elements for which the attribute type will be valid. At least one must be checked for the creation of the record; for this exercise, check Fund.

Check the Status checkbox to identify if the attribute code is active (checked) or inactive (unchecked).

When a new code is created, the system will populate the Activity Date field with the current system date.
Note: If the description or status of an existing code is updated, this field will be updated with the current system date.

Perform Duplicate Record functions to create new records.

Click the Save icon.

Click the Exit icon.

Banner form

Use the Attribute Value Maintenance Form (FTMATTV) to create, change, inactivate, delete, and query attribute values. Attribute values enable you to categorize financial information for reporting purposes. They are linked to attribute types and are optional.

Note: Before using this form, you must define attribute types on the Attribute Type Maintenance Form (FTMATTT).

Steps

Follow these steps to complete the process.

Access the Attribute Value Maintenance Form (FTMATTV).

Enter your Chart of Accounts code in the COA field.

Enter CAMPUS in the Attribute Type field.

Access the Value Creation block.

Enter East in the Attribute Value field.

Enter Eastern State Campus Reporting in the Description field.

The Begin Date field displays the date when the attribute value code is to be active.
Note: When a new code is created, the System populates the field with the current system date, but any valid system date can be entered. This is a required field.

The End Date field displays the date when the attribute value code is no longer active.

Notes: It must be greater than or equal to the begin date.

The Valid for All, FOAPAL checkboxes allow you to identify the FOAPAL elements for which the attribute value code will be valid. At least one must be checked for the creation of a record. For this exercise, F (Fund) is already checked. When creating a new record, the settings will be identical to the FOAPAL codes identified as valid for the attribute type code.

When a new code is created, the System will populate the Activity Date field with the current system date. If the description, beginning date, or end date of an existing code is updated, this field will be updated with the current system date.

Use the Record Duplicate function to create new records.

Click the Save icon.

Click the Exit icon.

Banner form

Select the appropriate check boxes on the Chart of Accounts Code Maintenance Form (FTMCOAS).

Steps

Follow these steps to complete the process.

Access the Chart of Accounts Code Maintenance Form (FTMCOAS).

Perform a query on your Chart of Accounts code.

Notes: If you want to use set codes, you must first select the appropriate Require Sets of Attribute Types checkboxes on this form.

Warning: SunGard Higher Education recommends that you do not change these fields after you use the FOAPAL Attribute Association Form (FTMFATA) to associate set codes with FOAPAL codes. If you must change the fields after associations have been made, first remove the appropriate associations on FTMFATA and then update the fields on the Chart of Accounts Code Maintenance Form (FTMCOAS).

Perform an Insert Record function.

Perform a Duplicate Record function.

Enter the current date (DD-MM-YYYY) in the Effective Date field.

Click the Require Sets of Attribute Types: FOAPAL check boxes to associate set codes to each of the FOAPAL elements in this Chart of Accounts. The use of set codes is optional.

Click the Save icon.

Click the Exit icon.

Banner form

Define set codes on the Attribute Type Set Maintenance Form (FTMATTS).

Steps

Follow these steps to complete the process.

Access the Attribute Type Set Maintenance Form (FTMATTS).

Enter your Chart of Accounts code in the COA field.

Enter BASIC in the Set Code field.

Enter Basic Reporting Set in the Description field.

Notes: This field contains a user-defined description of the set code.

The Valid for: radio buttons allow you to identify the FOAPAL element (or all FOAPAL elements) for which the set code will be valid. The FOAPAL element or elements selected match the ones checked on FTMCOAS.

When a new code is created, the system will populate the Activity Date field with the current system date. If the description or definition of an existing code is updated, this field will be updated with the current system date.

Select the Select Attribute Types to Associate with Set option in the Navigation Form to access the Attribute Type Selection Form (FTQATTS).

Notes: You cannot access this form (FTQATTS) from Direct Access. It must be called from the FTMATTS form.

The Attribute Type field displays the attribute type code (CAMPUS, in this exercise) to be included in the set being defined. This code cannot be entered here but must come from the Attribute Type Selection Form (FTQATTS). This code was selected because it met the FOAPAL requirement for sets of attribute types on FTMCOAS.

The Description field will contain the Description of the attribute type entered on the Attribute Type Maintenance Form (FTMATTT) for the records returned by the query. The Description field is display-only.

The Valid for: check boxes identify the FOAPAL element type for which the attribute type code is valid, as defined on the Attribute Type Maintenance Form (FTMATTT). The Valid for: check boxes are display-only.

The Active Status field displays whether the attribute code is active (checked) or inactive (unchecked). This is a display-only field.

Click the Add check box if you want to add the attribute type code.

Note: The Add check box determines whether the attribute type record should be defined for the set or should be associated to a FOAPAL element (checked).

Click the Save icon.

Click the Exit icon.

Banner form

Use this form to associate FOAPAL element codes to attribute types, attribute values, and set codes. You can also use this form to update, remove, and query FOAPAL element association records. Before using this form, the following steps must be completed:

define attribute types on the Attribute Type Maintenance Form (FTMATTT).

optional -- if you want to use attribute values, define them on the Attribute Value Maintenance Form (FTMATTV).

optional - if you want to use set codes, select the appropriate Require Sets of Attribute Types check boxes on the Chart of Accounts Code Maintenance Form (FTMCOAS).

optional - if you want to use set codes, define them on the Attribute Type Set Maintenance Form (FTMATTS).

Note: These forms were completed in previous exercises.

Steps

Follow these steps to complete the process.

Access the FOAPAL Attribute Association Form (FTMFATA).

Enter the code for the Chart of Accounts in which the FOAPAL element being associated exists in the Chart of Accounts field.

Select Fund from the Select FOAPAL element to associate attributes radio buttons. This allows you to associate a FOAPAL element to one or more attributes.

Enter 1010 in the Fund Code field.

Note: This code is used to identify the FOAPAL code that is being associated.

The Description field contains the display-only description of the FOAPAL code that is being associated (for this exercise, General Funds).

If the fund code has a predecessor code, the Predecessor code field will automatically display the predecessor code and its description.

The Data Entry field identifies whether the fund code allows data entry.

Note: This is a display-only field.

Perform a Next Block function to navigate to the Set Association block.

Note: This block only displays if the FOAPAL element type selected above has been required to use sets on the Chart of Accounts Code Maintenance Form (FTMCOAS). Otherwise, this block is not displayed and you will see the Attribute Association block.

Click the Exit icon in the Set Code field BASIC.

Note: If the COA entered above requires the use of sets for the selected FOAPAL element type, then a set code must be defined.

The Description field contains the user-defined description of the set code entered on the Attribute Type Set Maintenance Form (FTMATTS). (For this exercise, Basic Reporting Set is displayed.) This is a display-only field.

Perform a Next Block function to navigate to the Attribute Type Association block.

Enter CAMPUS in the Attribute Type field.

Notes: This field identifies the attribute type code to be associated with the FOAPAL element.

The description of the pre-existing attribute type code will automatically populate in the Description field. This is a display-only field.

The display-only Status field signifies whether the attribute code is active (checked) or inactive (unchecked).

Enter EAST in the Attribute Value field.

Note: This field identifies the attribute value code to be associated with the FOAPAL element. This is required when attribute value code(s) exist for the specified attribute type code.

The Description field contains the attribute value code description entered on the Attribute Value Maintenance Form (FTMATTV). (For this exercise, Eastern State Campus Reporting will be displayed.) This is a display-only field.

The Begin Date field displays the date when the attribute value code is to be active.

Note: The Begin Date field display-only.

The End Date field displays the date when the attribute value code is no longer active.

Note: The End Date field display-only.

Click the Save icon.

Click the Exit icon.

Banner form

Use the FOAPAL Attribute Association Query Form (FTIFATA) to query FOAPAL code association records. You can search for information about FOAPAL codes, set codes, attribute types, and/or attribute values.

Steps

Follow these steps to complete the process.

Access the FOAPAL Attribute Association Query Form (FTIFATA).

Enter the code for the Chart of Accounts in the Chart of Accounts field in which the FOAPAL element types will be queried.

The Select FOAPAL element to query, radio buttons identify which FOAPAL element will be used to query association records.

Note: For this exercise, click Fund.

The Query Criteria radio buttons identify the type of attribute to query. You can view the association records organized by attribute sets or by attribute type and value. For this exercise, select By Sets of Attribute Types.
Note: The form will dynamically display based on the radio button selected here.

The FOAPAL Code field contains the FOAPAL code that has been associated to a set based on the FOAPAL element selected in the Key block.

Note: This is a display-only field.

Perform a Next Block function to view the Set Association View block.

Enter 1010 in the Fund Code field.

Perform an Execute Query function.

Note: For this exercise, the Description field will be populated with “General Funds.” This field contains the description of the FOAPAL code that has been associated to a set.

The Set Code field contains the set code that has been associated to the FOAPAL element selected in the Key block.

Note: This is a display-only field. (For this exercise, BASIC should be displayed.)

The Description field contains the description of the set code entered on the Attribute Type Set Maintenance Form (FTMATTS).

Note: This is a display-only field.

Perform a Rollback function and select the By Attribute Types Query Criteria radio button.

Perform a Next Block function to view the Attribute Type Association Detail View block.

The Attribute Type field contains the attribute type that has been associated to the FOAPAL element selected in the Set Association View block. This is a display-only field. (For this exercise, CAMPUS should be displayed.)

The Description field contains the description of the attribute type entered on the Attribute Type Maintenance Form (FTMATTT). This is a display-only field.

The Attribute Value field contains the attribute value code that has been associated with the attribute type code. This is a display-only field. (For this exercise, EAST should be displayed.)

The Description field contains the attribute value code description entered on the Attribute Value Maintenance Form (FTMATTV). This is a display-only field.

Click the Exit icon.

Summary of Set Up Procedures

Summary

As a result of completing this section, you have

created a Chart of Accounts

created a Chart Code

created Accounts and Account Type Codes

created Funds and Fund Type Codes

created Organizations Codes

created Program Codes

created Activity Codes

created Location Codes

created a bank ID and defined bank codes

completed the Chart of Accounts Maintenance Form (FTMCOAS)

created attribute set, type, and value codes.

Other functions

The Chart of Accounts needs only to be set up once to drive the following Banner Finance functions:

Accounts Payable

Budget Development

Electronic Approvals

Fixed Assets

General Ledger

Endowment Management

Purchasing

Research Accounting

Security

Stores Inventory

Day-to-Day Operations

Section goal

The purpose of this section is to explain the day-to-day or operational procedures to create, modify, and query the Chart of Accounts at your institution.

Objectives

In this section you will learn how to

process General Accounting Transactions

produce reports for the Chart of Accounts

query financial data

produce financial reports.

General Accounting Transaction Processing

Introduction

The purpose of the general accounting transaction processing is to provide you with the ability to input the necessary transactions according to the user’s needs within the financial environment. These are transactions other than those related to purchase requisitions, purchase orders, invoices, or check processing.

The general accounting transaction forms are as follow:

Encumbrance

Encumbrance/Reservation Maintenance Form (FGAENCB). Used to establish non-purchase order fund reserve, that is, to encumber or reserve funds for future commitments.

Journal voucher

Journal Voucher Entry Form (FGAJVCD). Used to enter journal voucher transactions.

Journal Voucher Quick Form (FGAJVCQ). Used to enter journal voucher transactions.

Automatic journal voucher

Automatic Journal Voucher Form (FGAAUTO). Create recurring journal voucher transactions.

General Encumbrance Processing

Introduction

The Encumbrance/Reservation Maintenance Form (FGAENCB) allows you to establish and adjust budget reservation type encumbrances in Banner. Encumbrances are automatically generated within the Purchasing and Procurement module. Sometimes, however, it is necessary to create an encumbrance that is unrelated to a purchase order.

Example: A central stores department may distribute supplies or equipment. Your institution requires the department to encumber a funds anticipated expenses over a certain dollar value. It is important to remember that if you issue a purchase order after the encumbrance exists, it is necessary to liquidate the existing encumbrance to avoid overstating reserved funds.

Banner form

Steps

Follow these steps to complete the process.

Access the Encumbrance/Reservations Maintenance Form (FGAENCB).

Enter a pre-determined encumbrance/reservation number or type Next in the Encumbrance Number field.

Note: You can also leave the field blank to allow the system to generate the next available number.

Perform a Next Block function.

Enter a description in the Encumbrance Title field.

Enter the total value of the encumbrance in the Document Total field.

Enter the date (DD-MM-YYYY) the encumbrance will take effect in the Transaction Date field.

The Open Status check box will be checked for all open encumbrances.

Click the radio button for one of the following Encumbrance Type values:

Encumbrance- Standard General Encumbrance.

Labor - Encumbrance related to payroll.

Memo - Memorandum posting.

If possible, identify the Vendor ID for whom you are encumbering or reserving funds in the Vendor ID field.

Leave the Encumbrance Change field and Title field blank for this exercise.

Enter the date you created the encumbrance in the Date Established field.

Enter a document reference number in the Document Reference Number field is optional and may be used to establish additional identification. This may be used for reporting purposes.

Perform a Next Block function.

Tab through the Sequence Number field.

Note: Banner will automatically assign a one up number.

Enter a E100 for this accounting entry in the Journal Type field.

Leave the Project Code field blank for this example.

Note: The Project Code is used only when encumbrance is related to a Project or Work Order from Cost Accounting.

The Fiscal Year field will default from date entered on Header Page.

The Current Encumbrance Amount field is used to inform the user of the current amount of the encumbrance.

Note: The field shows no value when the encumbrance is entered.

Enter a valid COA value in the COA field.

Enter a valid index code in the Index field.

Note: This is an optional value.

Enter a valid fund code in the Fund field.

Enter a valid organization code in the Orgn field.

Enter a valid account code in the Acct field.

Enter a valid program code in the Prog field.

Enter a valid activity code in the Actv field.

Enter a valid location code in the Locn field.

Enter a percent to be charged to the accounting distribution in the Percent field.

Note: This is optional and will default a dollar amount.

Enter a dollar amount of the accounting distribution to be charged in the Amount field.

Note: You may overwrite what defaults from the use of a Percent.

Enter C or U in the Commit Type field.

Note: This determines how an encumbrance that is open at year end will be rolled in terms of the user’s ability to distinguish it from a current year encumbrance.

C - Committed. The encumbrance will be treated as a prior year encumbrance that has been rolled to the current year whose purpose and budget have been set aside from the current year’s operating budget. Its balance is reflected in the Prior Year Encumbrance Control account in the current year.

U - Uncommitted. The encumbrance rolls into the current year with no distinction of being from a prior year. Its balance is reflected in the Encumbrance Control Account in the current year. When the commit type is Uncommitted, The budget Disposition must be Unrestricted

Click the NSF Override check box to override the Budget Checking processing.

Perform a Next Record function.

Repeat Steps 15-31 as required to enter all Accounting Distributions.

Note: The total of all Sequences must equal the Document total entered on the Header page.

Perform a Next Block function.

Click the Complete checkbox to process Encumbrance Transaction or click the In Process checkbox to save Encumbrance information for future processing.

Making Changes to an Encumbrance

Introduction

Changes to the general encumbrance form include changing the FOAPAL and increasing and decreasing the encumbrance.

Banner form

Steps – Procedure 1 Follow these steps to increase or decrease the encumbrance Access the Encumbrance Inquiry Form (FGIENCD) to review the encumbrance you want to change. Enter the document number of the encumbrance that you want to change in the Document Number field. Click the Next Block icon. Review the item number and sequence of number that you would like to change on the encumbrance. Note: If it is an encumbrance with many sequences, you may use the query function to query for the specific sequence you want to change. Click the Exit icon. Access the Encumbrance/Reservations Maintenance Form (FGAENCB). Enter the Document Number that you wish to adjust Perform a Next Block function.
Enter the amount that you wish to adjust the encumbrance in the Document Total field Note: To reduce the encumbrance enter a negative number. Enter the encumbrance change number in the Encumbrance Change field. Note: This is user assigned and must be unique. Suggested numbering is to use ‘EC’, the encumbrance number, leading zero’s and a 1 for the first change, 2 for the second change. Example, encumbrance number E0000016, first change number is EC160001, second change is EC160002 Enter the description of the encumbrance change in the Title field. Perform a Next Block function.
Enter E020 in the Journal Type Field. Tab to the amount and enter the amount of the change Note: If you are reducing the encumbrance, enter a negative number. If there is more than one accounting line, you can split the total adjustment amount. Perform a Next Block function. Click the Complete checkbox to process Encumbrance Transaction or click the In Process checkbox to save Encumbrance information for future processing. Click the Exit icon.
Steps – Procedure 2 Follow these steps to change the accounting distribution of the encumbrance Access the Encumbrance Inquiry Form (FGIENCD) to review the encumbrance you want to change. Enter the document number of the encumbrance that you want to change in the Document Number field. Click the Next Block icon. Review the item number and sequence of number that you would like to change on the encumbrance. Note: If it is an encumbrance with many sequences, you may use the query function to query for the specific sequence you want to change. Click the Exit icon. Access the Encumbrance/Reservations Maintenance Form (FGAENCB). Enter the Document Number that you wish to adjust Perform a Next Block function.
Enter the zero in the Document Total field Enter the encumbrance change number in the Encumbrance Change field. Note: This is user assigned and must be unique. Suggested numbering is to use ‘EC’, the encumbrance number, leading zero’s and a 1 for the first change, 2 for the second change. Example, encumbrance number E0000016, first change number is EC160001, second change is EC160002 Enter the description of the encumbrance change in the Title field. Perform a Next Block function.
Enter E100 in the Journal Type Field For the FOAPAL that you are no longer want enter a negative amount in the Amount field that is equal to the amount in the Current Amount field. Perform a Next Record function. Enter E100 in the Journal Type Field Enter in the new accounting distribution. Enter in a positive amount in the Amount field. Perform a Next Block function. Click the Complete checkbox to process Encumbrance Transaction or click the In Process checkbox to save Encumbrance information for future processing. Click the Exit icon.

Closing/Liquidating Encumbrances

Introduction

There are two main ways of liquidating and closing encumbrances;

Use the invoice form to enter an invoice against an encumbrance. This method is covered in detail in the invoice processing module of Accounts Payable.

Use a journal voucher and apply the E032 rule code to liquidate the encumbrance.

Steps

Follow these steps to use a journal voucher to liquidate an encumbrance.

Access the Encumbrance Inquiry Form (FGIENCD) to review the encumbrance you want to change.

Enter the document number of the encumbrance that you want to change in the Document Number field.

Click the Next Block icon.

Review the item number and sequence of number that you would like to change on the encumbrance.

Note: If it is an encumbrance with many sequences, you may use the query function to query for the specific sequence you want to change.

Click the Exit icon.

Access the Detail Journal Voucher Form (FGAJVCD)

Create a new document number / journal voucher number and click the Next Block icon.

Note: You are now in the detail block of your journal voucher.

Enter rule code E032 – encumbrance liquidation rule code. Used to liquidate and close an encumbrance or a sequence within an encumbrance.

Type in the F-O-A-P-A-L elements that you want to use on your encumbrance as they appear on your original encumbrance.

Note: To fully liquidate an encumbrance or particular encumbrance sequence, type in the total encumbrance value or total sequence dollar value.

Tab over to the Encumbrance Number field of the journal voucher form and input the document number of the encumbrance to which you are making changes.

Tab over to the Item Number field and enter your item number from your original encumbrance

Tab over to the Sequence field and enter the sequence number from your original encumbrance.

Tab through to the Document Reference field and enter a document reference number (this is an optional field).

Tab through to the Adjustment type field and select a suitable adjustment from the list of values provided.

Tab to the Dr/Cr field of your journal and put in a ‘plus’ +.

Click the Next Block icon to access the completion block

Click the Complete icon.

Run posting to post your document.

Access the Encumbrance Inquiry Form (FGIENCD) to review your changes.

Journal Voucher Processing

Introduction

Banner provides three Journal Voucher Forms, the Journal Voucher Entry Form (FGAJVCD), the Journal Voucher Quick Form (FGAJVCQ) and the Journal Voucher Mass Entry Form (FGAJVCM). Use the Journal Voucher forms to enter various transactions such as cash, receipts, budget entries, accruals, correcting/adjusting entries. The rule codes used on these forms specify the transaction type and the proper accounting activity associated with the entry. The form you choose depends on your preference; however there are differences.

Form	Description
Journal Voucher Entry Form (FGAJVCD)	Structured horizontally, with unlimited entries per document. This form can be used to process all transaction types.
Journal Voucher Quick Form (FGAJVCQ)	Structured vertically, with unlimited entries per document. You cannot use this form to enter encumbrance activities, bank deposits, reference other documents, or accrual entries, because these fields do not exist on the form.
Journal Voucher Mass Entry Form (FGAJVCM)	Structured vertically, listing twelve entries per page, unlimited entries per document. You cannot use this form to enter encumbrance activities, reference other documents, or accrual entries because these fields do not exist on the form.

Banner form

Steps

Follow these steps to complete the process.

Access the Journal Voucher Entry Form (FGAJVCD).

Enter a pre-determined Journal Voucher number in the Document Number field, type NEXT, or leave the field blank to allow the system to generate the next available number.

Banner will automatically assign a number in the Submission Number field.

Perform a Next Block function.

Verify the date in the Transaction Date field.

Notes: The Transaction Date will default to the system date, but it may be overridden. This is the date when the transaction will post to the ledgers and must be in an open fiscal period.

Enter the total in the Document Total field.

Note: This total represents the sum of the absolute values of the accounting sequences entered. (Required)

Click the Redistribute checkbox if you want to distribute the dollar amounts on a percentage basis.

Enter an amount in the Distribution Total field.

Note: This is used in redistributing detail totals by percentages. If left blank, Banner applies the distribution percentages to the Document Total.

The NSF Checking checkbox will be checked when turned on.

Note: Banner controls the checkbox on the System Maintenance Form (FOASYSC). If checked on FOASYSC, then you cannot override NSF at transaction entry time.

The Defer Edit checkbox indicates when editing will occur.

Note: The system default is valued on the System Control Maintenance Form (FOASYSC).

View the Document Text Exists field.

Note: A Y (Yes) in this box indicates that text exists for this document; an N (No) indicates that it does not. To enter text for this document, select Document Text (FOATEXT) from the Options menu.

Perform a Next Block function.

Result: Banner updates the status of the document after you commit each transaction record in the Document Status field.

Note: If the Defer Edit checkbox in the Journal Voucher Document Header area is checked, this field remains blank.

Tab through the Sequence Number field.

Note: Banner will automatically assign the next number. If the Sequence field contains a sequence number, you can access the Journal Voucher Summary Query (FGIJSUM) through the Options menu.

Enter a Journal Type (Rule Code) for this accounting entry in the Journal Type field.

Examples: JE16 Interfund Transfer, JE15 Intrafund Transfer, CR05 Cash Receipts, BD01 Original Budget, BD02 Budget Adjustment). The transaction type will determine the fields in which you enter data.

A cash transaction will require a bank code to be entered; a budget entry requires a budget period. When you respond to the required fields, save the data. Unless the Defer Edit indicator is checked, the system will perform the editing and the available balance processing.

Enter a valid COA value in the COA field.

Enter a valid index code in the Index field.

Note: This is an optional value.

Enter a valid fund code in the Fund field.

Enter a valid organization code in the Orgn field.

Enter a valid account code in the Acct field.

Enter a valid program code in the Prgm field.

Enter a valid activity code in the Actv field

Enter a valid location code in the Locn field.

Note: This is an optional field.

Enter a project in the Project field if the transaction is related to a project from the Cost Accounting Module or leave the field blank.

Enter a percent to be charged to the accounting distribution in the Percent field.

Note: This is optional and will default a dollar amount.

Enter a dollar amount of the accounting distribution to be charged in the Amount field.

Note: You may overwrite what defaults from the use of a Percent.

Enter a value in the Debit/Credit field.

Note: The valid values are determined by Rule Code and may be +, -, D or C. (The CR05, BD01 and BD02 will use +/- and the JE15 and JE16 will use D/C.)

Click the NSF Override check box to override the Budget Checking processing.

Note: This will post a transaction when Budget is not available therefore creating an over budget condition.

Enter a description for the transaction being processed in the Description field.

Enter a valid bank code in the Bank Code field.

Note: This is necessary for cash transactions and may default from the fund record or rule code, if the rule class has the appropriate edit.

Enter the bank deposit number associated with a cash receipt transaction in the Deposit field.

Verify the encumbrance number and the sequence of an existing encumbrance to be adjusted or liquidated as a result of this detail transaction in the Encumbrance Number field.

Note: Valid with E020, E032 and other Encumbrance Rule Codes

For General Accounting Encumbrances (FGAENCB), the Item field defaults to zero.

Note: For Procurement Commitments, specify the item number from the document.

Enter a valid Sequence number for the Accounting Distribution to be adjusted/liquidated in the Sequence field.

Note: This will default to 1, however it may be overridden.

Select a valid action for the encumbrance in the Action field.

Note: This may be Total Liquidation, Partial Liquidation or Adjustment. The rule code used must support this selection.

Select U (Uncommitted) or C (Committed) encumbrance in the Commit field.

Enter a user-defined number providing additional identification for the transaction in the Document Reference field.

Note: This is an optional field.

Enter a valid budget period for transaction in the Budget Period field.

Note: This is only required on Budget Rule Codes such as BD01, BD02, BD03 and BD04

Click the Accrual checkbox.

Note: If checked, Banner generates transactions for both prior and current fiscal years. This only to be used for cash activity related to operating ledger accounts during one accrual period.

Leave the Currency field blank.

Notes: If the transaction is related to a currency transaction other than the base currency referenced on the Installation Control Form (GUACURR), enter the foreign currency.

If you enter a foreign currency, the Currency Conversion button activates. If you click it, Banner displays the Currency Conversion window, which displays the amounts in both the input currency and the converted currency.

Enter a valid date in the Gift Date field for all Endowment transactions.

Note: This gift date will be used in the Banner Endowment Module. It is required only when the Account Code used in the FOAPAL is marked with a ‘U’ in Account Class.

A number should be entered in the Number of Units field when entry is to override the Endowment Module Unitization process.

Note: This is necessary for loading Legacy data.

Perform a Next Record function.

Repeat Steps 15-42 as required to enter all Accounting Distributions.

Note: The total of all Sequences must equal the Document total entered on the Header page.

Perform a Next Block function.

Click the Complete checkbox to process Journal Voucher Transaction or click the in Process checkbox to save JV information for future processing.

Journal Voucher Processing – Quick Form

Introduction

All processing is the same as Steps above for the Journal Voucher Entry Form (FGAJVCD). The Quick form does not allow for certain types of processing such as Encumbrance liquidations or Accrual postings.

Banner form

Steps

Follow these steps to complete the process.

Access the Journal Voucher Quick Form (FGAJVCQ).

Refer to steps in the previous lesson for processing information.

Journal Voucher Processing – Mass Entry Form

Introduction

All processing is the same as steps above for the Journal Voucher Entry Form (FGAJVCD). The Mass form does not allow for certain types of processing such as Encumbrance liquidations or Accrual postings.

Banner form

Steps

Follow these steps to complete the process.

Access the Journal Voucher Mass Entry Form (FGAJVCM).

Refer to steps in the previous lesson for processing information.

Journal Voucher Processing – Copying Existing Journal Voucher

Introduction

Once in a while you may have entries that are duplicated on a regular basis and are not necessarily recurring entries. The copy feature of the journal voucher entry forms enables you to copy a journal from an existing completed journal.

Steps

Access the Journal Voucher Entry form – FGAJVCQ, FGAJVCD, FGAJVCM

Put in a document number or type NEXT in the Document Number field for the system to generate a document number.

Click on the Copy icon and a copy screen will pop-up.

Enter the journal number you want to copy your voucher from in the Copy From field and click OK. You may also click on the list of values and select from a PREVIOUSLY COMPLETED or a PREVIOUSLY POSTED list of journal vouchers.

Refer to steps in the previous lesson for processing information.

Journal Voucher Processing – Journal Voucher Reversal

Introduction

Clerical errors or erroneous accounting can sometimes result in unwanted or incorrect journal vouchers. Banner Finance system allows you to reverse such vouchers using the journal voucher reversal option.

Steps

Follow these steps to complete the procedure.

Access the Journal Voucher Entry From –FGAJVCQ, FGAJVCD or FGAJVCM.

Put in your journal document number or type in Next in the Document Number field.

Click on the Copy/reverse icon and pop up will appear.

Type in the document number that you want to reverse in the Copy To or Copy From fields.

Click on the Reverse JV check box and click OK.

Click the Next Block icon.

Click the Next Block icon again or use the Options menu to ACCESS COMPLETION block.

Complete your journal.

Run posting and visit the FGIDOCR to review your journal.

Automatic Journal Voucher Processing

Introduction

The Automatic Journal Voucher process is designed to establish the submission of routine and recurring journal vouchers to the posting and approval process. Automatic journal vouchers may be processed for the purpose of charge backs, postage or duplication, or for journal entries that are made at the end of the month and include numerous line items. The journal entries made at the end of the month may be reversed at the beginning of the next month. Documents attached to the Auto Journal Vouchers differ from the normal JV’s in that changes may be made to documents that are already completed and approved.

Note: The Status field shows if individual journal vouchers associated with the Automatic JV are incomplete.

Banner form

Steps

Follow these steps to create and process an Automatic Journal Voucher.

Access the Automatic Journal Voucher Form (FGAAUTO).

Enter an automatic journal ID in the Automatic Journal ID field.

Note: This is a three-character field tied to document numbers listed below in the Journal Voucher Header area.

Perform a Next Block function.

Enter a title of the automatic journal in the Title field.

Enter an (H) in the Automatic JV Hold? Field to put the transaction on Hold or leave blank.

Note: Leave blank for this example.

Select the frequency of document submissions in the Submission Cycle field.

Note: Valid options are:

Monthly

Quarterly

Annual

On Demand

Enter Monthly for this example.

Enter the Day the Auto JV is to be processed in the Submission Day field.

Note: This is used to designate a specific day of the month or the last day of the month. Valid days are 1-31 and L for last day of the month. (For Submission Cycle of Monthly, Annually or On Demand, enter Day only. For Quarterly, day and Period are required)

Enter the period to begin Auto JV submission in the Period field.

Note: This is required for Monthly and Quarterly.

Identify the number of times the Journal Voucher should be submitted in the Submissions Total field.

Example: If you wanted a monthly submission for one year, the Submission Cycle would be Monthly and the Submission Total would be 12.

Note: This may be changed after submission process has begun.

The Completed field shows the number of prior submissions processed.

Note: This is updated by Banner.

The Remaining field displays the number of remaining submissions.

Note: This is updated by Banner.

The First/Next Submission field displays the date when the submission is to be performed.

Note: Banner will update this automatically for all Monthly, Quarterly and Annually submissions.

The Last Submission field is populated by the system after the last submission is processed.

The Last Reversal checkbox indicates whether the original transaction needs to be reversed.

Note: If the box is checked, Banner generates an exact reversal of the original posting according to the following reversal posting schedule.

Enter the Day the Auto JV is to be reversed in the Reversal Day field.

Note: This is used to designate a specific day of the month or the last day of the month. Valid days are 1-31 and L for last day of the month. (For Submission Cycle of Monthly, Annually or On Demand, enter Day only. For Quarterly, day and Period are required)

Enter the period to begin Auto JV reversal in the Period field.

Note: This is required for Monthly and Quarterly.

Enter the number of times this auto journal should be reversed in the Reversals Total field.

The Completed field displays how many reversals have been completed.

Note: This is updated by Banner.

The Remaining field displays how many reversals remain.

The First/Next Reversal field displays the date when reversal is to be performed.

Note: Banner will update this automatically for all Monthly, Quarterly and Annually reversals.

The value in the Last Reversal field is generated by the systems after the last reversal is processed.

Perform a Next Block function.

Enter a unique document number in the Document field that you want to post.

Note: This number must be supplied and should not be system generated. This number will be re-usable. Each submission uses the same journal voucher document number with a system assigned submission number providing a unique internal index.

Tab through the Submission Number field to have Banner assign the next sequence number to this document.

Enter a description in the Description field.

Enter the total for the Journal Voucher in the Document Total field.

Click the Details button to automatically transfer to the Journal Voucher Entry Form and complete the details.

Note: Completion of the document indicates that the Automatic JV is ready for processing within the established submission parameters.

Automatic Journals can only be approved by running the

Transaction Interface Process (FGRTRNI) and the Transaction Error Report (FGRTRNR).

Direct Cash Receipts Processing, FGADCSR

Introduction

The Direct Cash Receipts process is designed to record cash receipts.

Banner form

Steps

Follow these steps to create and process a Direct Cash Receipts.

Access the Direct Cash Receipts Form (FGADCSR).

Enter a pre-determined Direct Cash Receipts number in the Document Number field, type NEXT, or leave the field blank to allow the system to generate the next available number.

Enter a vendor code, if applicable.

Perform a Next Block function.

Verify the date in the Transaction Date field.

Notes: The Transaction Date will default to the system date, but it may be overridden. This is the date when the transaction will post to the ledgers and must be in an open fiscal period.

Enter the total in the Document Total field.

Note: This total represents the sum of the absolute values of the accounting sequences entered. (Required)

A value defaults into the Collects Tax field if applicable to a selected vendor.

Click the NSF Override check box to override the Budget Checking processing.

View the Document Text Exists field.

Note: A Y (Yes) in this box indicates that text exists for this document; an N (No) indicates that it does not. To enter text for this document, select Document Text (FOATEXT) from the Options menu.

Enter NEXT field.

Result: Banner updates the status of the document after you commit each transaction record in the Document Status field.

Tab through the Sequence Number field.

Note: Banner will automatically assign the next number.

Enter a valid COA value in the COA field.

Enter a valid index code in the Index field.

Note: This is an optional value.

Enter a valid fund code in the Fund field.

Enter a valid organization code in the Orgn field.

Enter a valid account code in the Acct field.

Enter a valid program code in the Prgm field.

Enter a valid activity code in the Actv field.

Enter a valid location code in the Locn field.

Note: This is an optional field.

Enter a percent to be charged to the accounting distribution in the Percent field.

Note: This is optional and will default a dollar amount.

Enter a dollar amount of the accounting distribution to be charged in the Amount field.

Note: You may overwrite what defaults from the use of a Percent.

Enter a value, +/-, in the Debit/Credit field.

Click the NSF Override check box to override the Budget Checking processing.

Note: This will post a transaction when Budget is not available therefore creating an over budget condition.

Enter a description for the transaction being processed in the Description field.

Enter a valid bank code in the Bank Code field.

Note: This is necessary for cash transactions and may default from the fund record or rule code, if the rule class has the appropriate edit.

Enter the bank deposit number associated with a cash receipt transaction in the Deposit field.

Enter a user-defined number providing additional identification for the transaction in the Document Reference field.

Note: This is an optional field.

Leave the Currency field blank.

Notes: If the transaction is related to a currency transaction other than the base currency referenced on the Installation Control Form (GUACURR), enter the foreign currency.

If you enter a foreign currency, the Currency Conversion button activates. If you click it, Banner displays the Currency Conversion window, which displays the amounts in both the input currency and the converted currency.

Perform a Next Record function.

Repeat Steps 15-29 as required to enter all Accounting Distributions.

Note: The total of all Sequences must equal the Document total entered on the Header page.

Perform a Next Block function.

Click the Complete checkbox to process Direct Cash Receipts Transaction or click the in Process checkbox to save cash receipts information for future processing.

General Accounting and Budget Query Forms

Introduction

The purpose of the General Accounting and Budget query forms is to review how end users can query transactions in Banner. You can use budget query, transaction inquiry, encumbrance inquiry, or document inquiry forms.

Budget query forms

Budget Availability Status Form (FGIBAVL)

Organizational Budget Status Form (FGIBDST)

Organizational Budget Summary Form (FGIBSUM)

Executive Summary Form (FGIBDSR)

General Ledger inquiry forms

General Ledger Trail Balance Form (FGITBAL)

Trial Balance Summary Form (FGITBSR)

Transaction inquiry forms

Operating Accounts Transaction Detail Form (FGITRND)

General Ledger Transaction Detail Transaction Form (FGIGLAC)

Journal Voucher Summary Form (FGIJSUM)

List of Suspended Journal Vouchers Form (FGIJVCD)

List of Automatic Journal Vouchers Form (FGIAUTO)

Encumbrance inquiry forms

Detail Encumbrance Activity Form (FGIENCD

Organizational Encumbrance List Form (FGIOENC)

Encumbrance List Form (FGIENCB)

Document inquiry forms

Document Retrieval Inquiry Form (FGIDOCR)

Querying the Budget Availability Status Form, FGIBAVL

Introduction

You can query the status of accounts for transaction processing using the Budget Availability Status Form (FGIBAVL). The form provides current information on adjusted budget, year-to-date activity, budget reservations, and available balance for selected index, fund, organization, account, and program combinations.

Chart, FY and FOAP are required

FOAP values must be data enterable

Account is the starting point for display, not only for that account

Displays Unapproved and Unposted transactions

The Available Balance Drill enhancement adds capability to drill down from Budget Availability Status Form (FGIBAVL) to a new form listing the unposted documents from the Available Balance tables. The new form Transaction in Process Status (FGITINP) can also be accessed directly or from the menu.

When non-sufficient funds (NSF) checking is active, the Available Balance of remaining budget should equal the total of unposted or pending documents plus the operating ledger's posted activity. Certain forms and processes update activity for unposted documents in Available Balance Table (FGBBAVL) and Back Out Table (FGRBAKO). Transaction in Process Status Form (FGITINP) provides the capability to view the pending documents from the back out table before they are posted and visible with operating ledger queries.

Checkbox indicators have been added to the key block and to each row in the data block to identify when pending documents are present in Back Out Table (FGRBAKO).

Once you successfully enter a query and the form's Control Keys are populated, the checkbox indicators will also be populated if applicable. The key block indicator for Pending Documents is checked if there are unposted documents in the back out table for any one of the Account codes listed, and an Account line indicator is checked if there are pending documents to view for that specific budget control account.

If you select an account row with the Pending Documents indicator checked and then choose Pending Documents from the Options menu or use the Duplicate Item function (F3) you will be able to view unposted documents affecting available balance for the budget control key and the selected control account.

Banner form

Transaction in Progress Status form (FGITINP)

Transaction in Process Status Form (FGITINP) provides the capability to view the pending documents from Back Out Table (FGRBAKO) before they are posted and visible with operating ledger queries. The new form may be accessed from Budget Availability Status Form (FGIBAVL) whenever pending documents are indicated or it can also be accessed directly.

The form is used to query pending documents and can be used to view the current status of each pending document as well as other details for the transaction in process. Statuses returned with query results are selected from one of the status codes below. The first applicable status is displayed.

Code	Description
In Travel (TEM)	Document type used by Banner Travel & Expense Management
To Be Posted	Completed document waiting in the posting queue or the deferred edit queue
In Approvals	Completed document but final approval is not yet recorded
Error	Orphan record in FGRBAKO (accounting sequence is already posted, or the document no longer exists)
Receipt Pending	Completed invoice waiting for matching
Disapproved	Incomplete document with disapproval history (excluding general encumbrance change documents)
Incomplete	Incomplete documentation in process
Undefined	Document with an undetermined status

Banner form

Steps

Follow these steps to complete the process.

Access the Budget Availability Status Form (FGIBAVL).

Note: This form will display all activity including in process and not posted transactions.

Enter the Chart of Accounts that you want to query in the Chart field.

Note: This should default from the user profile (FOMPROF)

Enter the fiscal year that you want to query in the Fiscal Year field.

Enter the index code that you want to query in the Index field.

Note: This will default certain pieces of the FOAPAL. This is optional.

Enter the fund code you want to query in the Fund field.

Enter the organization code you want to query in the Organization field.

Enter the account code you want to query in the Account field.

Enter the program code you want to query in the Program field.

Select the type of encumbrances to review (Both, Uncommitted, or Committed) in the Commit type field.

Verify the values in the Control Key --> fields.

Fund: Displays the value budget is controlled on.

Organization: Displays the value budget is controlled on.

Account: Displays the value budget is controlled on.

Program: Displays the value budget is controlled on.

Note: For Steps 5 – 8, you must enter a value for the pieces of FOAP that budget is being controlled on. If any piece of the Control Keys is null, then budget is not being checked on this piece.

Perform a Next Block function.

View the results of your query.

Highlight a row that includes pending documents.

Select Pending Documents (FGITINP) from the Options menu to review the existing document(s).

Note: You can also access the Transaction In Process Status Form (FGITINP) from the Go To field on the main Banner menu.

View the results of your query by document number.

Click the Exit icon to return to the Budget Availability Status Form (FGIBAVL).

Click the Exit icon again to close the Budget Availability Status Form (FGIBAVL).

Click the Exit icon.

Querying the Organizational Budget Status Form, FGIBDST

Introduction

You can use the Organizational Budget Status Form (FGIBDST) to query the organizational status of accounts on adjusted budget, year-to-date activity, budget commitments, and available balance for selected index, fund, organization, account, program, activity, and location combinations.

Chart and FY are required

Any FOAPAL selection must be data enterable

Account Type is level 2 only

Displays Approved and Posted transactions

Banner form

Steps

Follow these steps to complete the process.

Access the Organizational Budget Status Form (FGIBDST).

Note: This form will only display posted transactions.

Enter the Chart of Accounts that you want to query in the Chart field.

Note: This should default from the user profile (FOMPROF)

Enter the fiscal year that you want to query in the Fiscal Year field.

Enter the index code that you want to query in the Index field.

Note: This will default certain pieces of the FOAPAL. This is optional.

Enter the organization code you want to query in the Organization field.

Enter the fund code you want to query in the Fund field.

Enter the program code you want to query in the Program field.

Enter the account code you want to query Account field.

Enter the account type you want to query in the Account Type field.

Enter the activity code you want to query in the Activity field.

Enter the location code you want to query in the Location field.

Select the type of encumbrances to review (Both, Uncommitted, or Committed) in the Commit Type field.

Click the Query Specific Account check box if you want to query a single account or a single account type.

Note: If you check this box, then Account code or Acct Type is required.

Click the Include Revenue Accounts check box if you want to review information for Revenues.

Note: If you check this box, the total of Budget Availability will be NULL since revenues should offset expenses.

Perform a Next Block function.

View the results of your query.

Note: Use the Options menu to access additional query forms supporting the detail on this form.

Click the Exit icon.

Querying the Organizational Budget Summary Form, FGIBSUM

Introduction

You can use the Organizational Budget Summary Form (FGIBSUM) to query the organizational account status at an account type summary level. The financial information is displayed at the internal account type within the fund and organization combination for adjusted budget (i.e., adopted budget plus or minus budget adjustments), year-to-date activity, budget reservations and available balance.

Chart and FY are required

Fund must be data enterable

Organization must be data enterable

Displays only Approved and Posted transactions

Banner form

Steps

Follow these steps to complete the process.

Access the Organizational Budget Summary Form (FGIBSUM).

Note: This form will only display posted transactions.

Enter the Chart of Accounts that you want to query in the Chart field.

Enter the fiscal year that you want to query in the Fiscal Year field.

Enter the organization you want to query in the Organization field.

Enter the fund code you want to query in the Fund field.

Select the type of encumbrances to review (Both, Uncommitted, or Committed) in the Commit Type field.

Perform a Next Block function.

View the results of your query.

Note: Use the Options menu to access additional query forms supporting the detail on this form.

Click the Exit icon.

Querying the Executive Summary Form, FGIBDSR

Introduction

The Executive Summary Form (FGIBDSR) lets you query for the highest level of the account structure hierarchy for adjusted budget, year-to-date activity, budget commitments and available balance for selected index, fund, organization, account, program, activity and location combinations.

Chart and FY are required

FOAPL selections can be either data or non-data enterable

Account Type can be a level 1 or 2

Displays only Approved and Posted transactions

Banner form

Steps

Follow these steps to complete the process.

Access the Executive Summary Form (FGIBDSR).

Note: This form will only show posted transactions.

Enter the Chart of Accounts that you want to query in the Chart field.

Note: This should default from the user profile (FOMPROF).

Enter the fiscal year that you want to query in the Fiscal Year field.

Enter the index code that you want to query in the Index field.

Note: This will default certain pieces of the FOAPAL. This is optional.

Enter the organization you want to query in the Organization field.

Enter the fund code you want to query in the Fund field.

Enter the program code you want to query in the Program field.

Enter the account code you want to query in the Account field.

Enter the account type you want to query in the Account Type field.

Enter the activity code you want to query in the Activity field.

Enter the location code you want to query in the Location field.

Select the type of encumbrances to review (Both, Uncommitted, or Committed) in the Commit Type field.

Check the Query Specific Account checkbox if you want to query a single account or a single account type.

Note: If you check this box, then Account code or Account Type is required.

Check the Include Revenue checkbox if you want to review information for Revenues.

Note: If you check this box, the total of Budget Availability will be NULL since revenues should offset expenses.

Perform a Next Block function.

View the results of your query.

Note: Use the Options menu to access additional query forms supporting the detail on this form.

Click the Exit icon.

Querying the General Ledger Trial Balance Form, FGITBAL

Introduction

The General Ledger Trail Balance Form (FGITBAL) lets you query the General Ledger account balances for selected funds, account types, and account code combinations.

Chart, FY and Fund are required

Funds must be data enterable

Account types can be both level 1 and 2

Account code must be data enterable

Account code queries only that code

Banner form

Steps

Follow these steps to complete the process.

Access the General Ledger Trial Balance Form (FGITBAL).

Note: This form will only display posted transaction.

Enter the Chart of Accounts that you want to query in the Chart field.

Note: This should default from the user profile (FOMPROF).

Enter the fiscal year that you want to query in the Fiscal Year field.

Enter the fund code you want to query in the Fund field.

Enter the account type you want to query in the Account Type field.

Enter the account code you want to query in the Account field.

Perform the Next Block Function

View the results of your query.

Note: Use the Options menu to access additional query forms supporting the detail on this form.

Click the Exit icon.

Querying the Trial Balance Summary Form, FGITBSR

Introduction

The Trial Balance Summary Form (FGITBSR) lets you query the General Ledger account balances for selected funds, account types, and account code combinations. This enables viewing of values at higher levels within the Fund hierarchy.

Chart, FY and Fund are required

Fund can be either data or non-data enterable

Fund type can be level 1 or 2

Account type can be level 2 or 2

Banner form

Steps

Follow these steps to complete the process.

Access the Trial Balance Summary Form (FGITBSR).

Note: This form will only display posted transaction.

Enter the Chart of Accounts that you want to query in the Chart field.

Note: This should default from the user profile (FOMPROF).

Enter the fiscal year that you want to query in the Fiscal Year field.

Enter the fund code you want to query in the Fund field.

Enter the account type you want to query in the Account Type field.

Enter the account code you want to query in the Account field.

Perform the Next Block Function

View the results of your query.

Note: Use the Options menu to access additional query forms supporting the detail on this form.

Click the Exit icon.

Querying the Detail Transaction Activity Form, FGITRND

Introduction

You can use the Detail Transaction Activity Form (FGITRND) to query the detailed transaction activity for selected operating ledger account combinations. This is for Operating Accounts only.

Banner form

Steps

Follow these steps to complete the process.

Access the Detail Transaction Activity Form (FGITRND).

Note: This form will only display posted transactions.

Enter the Chart of Accounts that you want to query in the Chart field.

Note: This should default from the user profile (FOMPROF)

Enter the fiscal year that you want to query in the Fiscal Year field.

Enter the index code that you want to query in the Index field.

Note: This will default certain pieces of the FOAPAL. This is optional.

Enter the fund code you want to query in the Fund field.

Enter the organization you want to query in the Organization field.

Enter the account code you want to query in the Account field.

Enter the program code you want to query in the Program field.

Enter the activity code you want to query in the Activity field.

Enter the location code you want to query in the Location field.

Enter the period you want to query in the Period field.

Enter an ‘S’ in the Query Type field to query a specific account.

Note: When selecting a specific account, the Account must be entered. Banner will populate an ‘R’ for all accounts if nothing is entered.

Enter the type of encumbrances to review Null (for Both), ‘U’ for Uncommitted, or ‘C’ for Committed) in the Commit Type field.

Perform a Next Block function.

Perform a Query Execute to retrieve data.

View the results of your query.

Note: Use the Options menu to access additional query forms supporting the detail on this form.

Click the Exit icon.

Querying the General Ledger Activity Form, FGIGLAC

Introduction

You can use the General Ledger Activity Form (FGIGLAC) to query the detail transaction activity for selected general ledger account combinations. This is for Balance Sheet Accounts only.

Chart, FY and Fund are required

Fund must be data enterable

Account (optional) must be data enterable

Banner form

Steps

Follow these steps to complete the process.

Access the General Ledger Activity Form (FGIGLAC).

Note: This form will only display posted transaction.

Enter the Chart of Accounts that you want to query in the Chart field.

Note: This should default from the user profile (FOMPROF).

Enter the fiscal period that you want to query in the Period field.

Enter the fiscal year you want to query in the Fiscal Year field.

Enter the Index code you want to query in the Index field.

Enter the fund code you want to query in the Fund field.

Enter the account code you want to query in the Account field.

Perform the Next Block function.

View the results of your query.

Note: Use the Options menu to access additional query forms supporting the detail on this form.

Click the Exit icon.

Querying the Journal Voucher Summary Form, FGIJSUM

Introduction

You can query the journal vouchers that have not been posted using the Journal Voucher Summary Form (FGIJSUM).

Note: You cannot insert, update, or delete information on this query form.

Banner form

Steps

Follow the steps to complete the process.

Access the Journal Voucher Summary Form (FGIJSUM).

Note: This form will only include Journal Vouchers that are not completed.

Enter a valid journal voucher number in the Document field.

Enter a valid submission number in the Submission field.

Note: This will automatically populate by Banner when Zero.

Perform a Next Block function

View the results of your query.

Note: Use the Options menu to access additional query forms supporting the detail on this form.

Click the Exit icon.

Querying the List of Suspended Journal Vouchers Form, FGIJVCD

Introduction

The List of Suspended Journal Vouchers Form (FGIJVCD) lists all incomplete Journal Vouchers.

Banner form

Steps

Follow these steps to complete the process.

Access the List of Suspended Journal Vouchers Form (FGIJVCD).

Note: This form will only display those Journal Vouchers that are not posted.

View the results of your query.

Click the Exit icon.

Querying the List of Automatic Journal Vouchers Form, FGIAUTO

Introduction

Use the List of Automatic Journal Vouchers Form (FGIAUTO) to view a list of existing recurring journal vouchers.

Banner form

Steps

Follow these steps to complete the process.

Access the List of Automatic Journal Vouchers Form (FGIAUTO).

Note: This form lists all Automatic Journal Vouchers and there status.

View the results of your query.

Click the Exit icon.

Querying the Detail Encumbrance Activity Form, FGIENCD

Introduction

You can use the Detail Encumbrance Activity Form (FGIENCD) to query the detail transaction activity for an encumbrance.

Banner form

Steps

Follow these steps to complete the process.

Access the Detail Encumbrance Activity Form (FGIENCD).

Note: This form will only display posted transactions.

Enter a valid document number in the Encumbrance field.

Perform a Next Block function.

View the results of your query.

Click the Exit icon.

Querying the Organizational Encumbrance List Form, FGIOENC

Introduction

The Organizational Encumbrance List Form (FGIOENC) allows you to query on all open encumbrances by organization for selected index, fund or organization combinations.

Banner form

Steps

Follow these steps to complete the process.

Access the Organizational Encumbrance List Form (FGIOENC).

Note: This form will only display posted transactions.

Enter the Chart of Accounts that you want to query in the Chart field.

Note: This should default from the user profile (FOMPROF).

Enter the fiscal year that you want to query in the Fiscal Year field.

Enter the index code that you want to query in the Index field.

Note: This will default certain pieces of the FOAPAL. This is optional.

Enter the organization you want to query in the Organization field.

Enter the fund code you want to query in the Fund field.

Perform the Next Block function.

View the results of your query.

Note: Use the Options menu to access additional query forms supporting the detail on this form.

Click the Exit icon.

Querying the Encumbrance List Form, FGIENCB

Introduction

The Encumbrance List Form (FGIENCB) allows you to query on all encumbrances listing encumbrance type, description, current balance and status.

Banner Form

Steps

Follow these steps to complete the process.

Access the Encumbrance List Form (FGIENCB).

View the results of your query.

Click the Exit icon.

Querying the Document Retrieval Inquiry Form, FGIDOCR

Introduction

Use the Document Retrieval Inquiry Form (FGIDOCR) to query any posted journal voucher.

Banner form

Steps

Follow these steps to complete the process.

Access the Document Retrieval Inquiry Form (FGIDOCR).

Note: This form will only display posted transactions.

Enter a valid document number in the Document field.

The Submission Number field will display the submission number associated with the document.

Note: Banner will update this field.

The Document Type field will populate with the document type associated with the transaction.

Perform a Next Block function.

View the results of your query.

Note: Use the Options menu to access additional query forms supporting the detail on this form.

Click the Exit icon.

Querying Direct Cash Receipts Form, FGIDCSR

Introduction

Use the Direct Cash Receipts Inquiry Form (FGIDCSR) to query any posted cash receipts.

Banner form

Steps

Follow these steps to complete the process.

Access the Direct Cash Receipts Form (FGIDCSR).

View the results of your query.

Click the Exit icon.

Running the Account Hierarchy Report

Introduction

Run the Account Hierarchy Report (FGRACTH) to generate a report showing the hierarchy of the accounts that have been entered.

Banner form

Steps

Follow these steps to complete the process.

Access the Account Hierarchy Report (FGRACTH).

Enter the desired printer name in the Printer field.

Note: You can enter DATABASE to write the report to a table for on-line viewing and to enable the saving of the report to a shared folder on a designated network drive.

Enter these parameter values.

Required?	Parameter	Description
yes	Chart of Accounts	Enter the one-character code of the Chart of Accounts that you previously created.
As of Date	Date from which information to run the report will be gathered.
Account Type	Enter 11. This parameter contains a 30-character code for the account type reported. Note: Entering 11 will generate a hierarchy report for the Cash and Cash Equivalent accounts only. If you wanted the entire account hierarchy, you would leave this parameter field blank.

Click the Save Parameter Set as checkbox.

Enter a name and description in the Name and Description fields.

Click the Submit radio button.

Click the Save icon to execute the report.

Result: The Auto hint line displays the job submission number for the report log and list file.

Once the process has run, check the Auto Hint line.

Note: It should indicate that two files were created: a Log file and a List file. The filenames are in the format process_number.type, where:

process is the name of the report run (for this exercise, FGRACTH)

number is the process number of the report run

type is the type of file created (.log for Log, .lis for List)

Select the Review Output option from the Navigation Frame to Access the Saved Output Review Form (GJIREVO) to view the report.

Enter FGRACTH in the Process field.

Note: This field specifies the name of the job previously run.

Enter the process number from the Auto Hint line in the Number field.

Note: This field specifies the number of the job.

Double-click in the File Name field to view the available output files.

Note: The output file names will be in the format database_process_number.type, as above, but here using the name of the database as a prefix. This field specifies the name of the file produced because of running the job. Select the file for your process with the .lis suffix to display the report output.

Running the Fund Hierarchy Report

Introduction

Run the Fund Hierarchy Report (FGRFNDH) to generate a summary of the hierarchy of funds.

Banner form

Steps

Follow these steps to complete the process.

Access the Fund Hierarchy Report (FGRFNDH).

Enter the desired printer name in the Printer field.

Note: You can enter DATABASE to write the report to a table for on-line viewing and to enable the saving of the report to a shared folder on a designated network drive.

Enter these parameter values.

Req?	Parameter	Description
yes	Chart of Accounts	Enter the 1-character code previously created for the Chart of Accounts.
As of Date	Date from which information to run the report shall be gathered.
Fund Type Code	Enter 21. Fund type code reported. (In this example, entering 21 will generate a hierarchy report for the Current Restricted funds only. If you wanted the entire fund hierarchy, you would leave this parameter field blank.)

Click the Save Parameter Set as checkbox.

Enter a name and description in the Name and Description fields.

Click the Submit radio button.

Click the Save icon to execute the report.

Result: The Auto hint line displays the job submission number for the report log and list file.

Once the process has run, check the Auto Hint line.

Note: It should indicate that two files were created: a Log file and a List file. The filenames are in the format process_number.type, where:

process is the name of the report run (for this exercise, FGRACTH)

number is the process number of the report run

type is the type of file created (.log for Log, .lis for List)

Select the Review Output option from the Navigation Frame to Access the Saved Output Review Form (GJIREVO), where you may view the report.

Enter FGRFNDH in the Process field.

Note: This field specifies the name of the job previously run.

Enter the process number from the Auto Hint line in the Number field.

This field specifies the number of the job.

Double-click in the File Name field to view the available output files.

Note: The output file names will be in the format database_process_number.type, as above, but here using the name of the database as a prefix. This field specifies the name of the file produced because of running the job. Select the file for your process with the .lis suffix to display the report output.

Running the Program Hierarchy Report

Introduction

The Program Hierarchy Report (FGRPRGH) lets you run a report listing the program codes in the Chart of Accounts.

Banner form

Steps

Follow these steps to complete the process.

Access the Program Hierarchy Report (FGRPRGH).

Enter the desired printer name in the Printer field.

Note: You can enter DATABASE to write the report to a table for on-line viewing and to enable the saving of the report to a shared folder on a designated network drive.

Enter these parameter values.

Req?	Parameter	Description
yes	Chart of Accounts	Enter the 1-character code previously created for the Chart of Accounts.
As of Date	Date from which information to run the report shall be gathered.
Program Code	Leave this field blank to generate a report for the entire program hierarchy.
Hold/Submit	Enter S. Determines the report status.

Click the Save Parameter Set as checkbox.

Enter a name and description in the Name and Description fields.

Click the Submit radio button.

Click the Save icon to execute the report.

Once the process has run, check the Auto Hint line.

Note: It should indicate that two files were created: a Log file and a List file. The filenames are in the format process_number.type, where:

process is the name of the report run (for this exercise, FGRACTH)

number is the process number of the report run

type is the type of file created (.log for Log, .lis for List)

Select the Review Output option from the Options menu to navigate to the Saved Output Review Form (GJIREVO) to view the report.

Enter FGRPRGH in the Process field.

Enter the process number from the Auto Hint line in the Number field.

Note: This field specifies the number of the job.

Double-click to view the available output files in the File Name field. The output file names will be in the format database_process_number.type, as above, but here using the name of the database as a prefix.
Note: This field specifies the name of the file produced because of running the job. Select the file for your process with the .lis suffix to display the report output.

Click the Exit icon.

Running the Location Hierarchy Report

Introduction

Run the Location Hierarchy Report (FGRLOCH) to view a list of all the locations in your institution.

Banner form

Steps

Follow these steps to complete the process.

Access the Location Hierarchy Report (FGRLOCH).

Enter the desired printer name in the Printer field.

Note: You can enter DATABASE to write the report to a table for on-line viewing and to enable the saving of the report to a shared folder on a designated network drive.

Enter these parameter values.

Req?	Parameter	Description
yes	Chart of Accounts	Enter the 1-character code previously created for the Chart of Accounts.
Effective Date	Date from which information to run the report shall be gathered.
Location Code	Enter ART101. Location code reported. If you leave this field blank, you would generate a report for the entire location hierarchy.
Hold/Submit	Enter S. Determines the report status.

Click the Save Parameter Set as checkbox.

Enter a name and description in the Name and Description fields.

Click the Submit radio button.

Click the Save icon to execute the report.

Once the process has run, check the Auto Hint line.

Note: It should indicate that two files were created: a Log file and a List file. The filenames are in the format process_number.type, where:

process is the name of the report run (for this exercise, FGRACTH)

number is the process number of the report run

type is the type of file created (.log for Log, .lis for List)

Select the Review Output option from the Options menu to navigate to the Saved Output Review Form (GJIREVO) to view the report.

Enter FGRLOCH in the Process field.

Enter the process number from the Auto Hint line in the Number field.

Note: This field specifies the number of the job.

Double-click in the File Name field to view the available output files.

Click the Exit icon.

Running the Organization Hierarchy Report

Introduction

Run the Organization Hierarchy Report (FGRORGH) to view a list of all organizations in your Chart of Accounts.

Introduction

Steps

Follow these steps to complete the process.

Access the Organization Hierarchy Report (FGRORGH).

Enter the desired printer name in the Printer field.

Note: You can enter DATABASE to write the report to a table for on-line viewing and to enable the saving of the report to a shared folder on a designated network drive.

Enter these parameter values.

Req?	Parameter	Description
yes	Chart of Accounts	Enter the 1-character code previously created for the Chart of Accounts.
Effective Date	Date from which information to run the report shall be gathered.
Organization	Enter 001. This report will return all the organization codes that are associated with organization 001. If you leave this field blank, you would obtain an organization hierarchy for all organizations in the College.
Hold/Submit	Enter S. Determines the report status.

Click the Save Parameter Set as checkbox.

Enter a name and description in the Name and Description fields.

Click the Submit radio button.

Click the Save icon to execute the report.

Once the process has run, check the Auto Hint line.

Note: It should indicate that two files were created: a Log file and a List file. The filenames are in the format process_number.type, where:

process is the name of the report run (for this exercise, FGRACTH)

number is the process number of the report run

type is the type of file created (.log for Log, .lis for List)

Select the Review Output option from the Options menu to navigate to the Saved Output Review Form (GJIREVO) to view the report.

Enter FGRORGH in the Process field.

Note: This field contains the name of the job previously run.

Enter the process number from the Auto Hint line in the Number field.

Note: This field specifies the number of the job.

Double-click in the File Name field to view the available output files.

Note: The output file names will be in the format database_process_number.type, as above, but here using the name of the database as a prefix. This field specifies the name of the file produced because of running the job. Select the file for your process with the .lis suffix to display the report output.

Click the Exit icon.

Mandatory Daily Reports Review

Introduction

It is critical to run the four mandatory reports on a daily basis because they will alert you to an out of balance situation so that it can be fixed immediately. On the next few pages, we will review each of the four mandatory daily reports:

GL Subsidiary Ledger Control (FGRCTRL)

Trial Balance Exception Report (FGRTBEX)

Bank Interfund Exception Report (FGRBIEX)

Bank Interfund Account Control Report (FGRCASH)

GL Subsidiary Ledger Control (FGRCTRL)

Run the GL Subsidiary Ledger Control Report (FGRCTRL) daily to ensure the operating ledger and the general ledger are in balance. This report checks your operating ledger transactions, open invoices, AP transactions, and make sure they all tie to control accounts to make sure everything is in balance.

Possible causes of out of balance errors

The number one cause of an out of balance error is journal vouchers. When you have an out of balance error on FGRCTRL, the first thing to check should be if journal vouchers were entered on accounts that should be non-data enterable. If the out of balance error was not caused by a Journal entry, then run the FGRCTRL report in detail to find which funds are out of balance. Review these funds using the FGITBAL and the FGIGLAC forms. Another way of creating an out of balance situation between the ledgers is if there is a data problem with the interface transfer of data from the legacy system to Banner Finance. Again review the detail report for the funds that have caused the out of balance. Also if beginning balances were not entered correctly for Accounts Payable, then you would get an out of balance message when the system checked the AP account and the Open Invoices total.

Banner report

Trial Balance Exception Report (FGRTBEX)

Run the Trial Balance Exception Report (FGRTBEX) daily to analyze all funds for potential out of balance conditions. FGRTBEX can be run in either summary or detail mode. When this report is run in summary mode, it displays any out of balance funds for each chart of accounts. If there are no out of balance funds, a report saying that all funds are balanced displays. In detail mode, the report provides a list of all documents that are associated with that out of balance fund. This report is not designed to be used in conjunction with summarized postings.

Banner report

Bank Interfund Exception Report (FGRBIEX)

Run the Bank Interfund Exception Report (FGRBIEX) daily to ensure that you are in balance. You can run it in Summary mode to get a report like this that lets you know that you are in balance. If not, you can rerun the report in Detail mode to see the fund code and account code that is causing the out of balance error.

Banner report

Bank Interfund Account Control Report (FGRCASH)

Run the Bank Interfund Account Control Report (FGRCASH) each day to compare the cash interfund account for each bank fund to the cash accounts of each fund which has a claim on the bank fund. Each Chart of Accounts is reported separately.

Banner report

Month-End Closings

Introduction

Month End includes more than month end reports. It is important to ensure that the document clean-up process is complete and control reports have been run.

Ensure that the requisitions, purchase orders, accounts payable documents, and journal vouchers are cleaned up – for example, incomplete documents need to be completed or closed, and documents in suspense need to be corrected.

Requisitions

Requisitions – can be done weekly but should be done at least monthly. At the end of each month you will want to run reports to check for:

incomplete documents

documents in suspense

open requisitions that have not yet been turned into purchase orders.

You will also want to use the query forms to view how much encumbrance remains on requisition documents.

Purchasing

Purchasing – can be done weekly but should be done at least monthly. At the end of each month you will want to run reports to check for:

incomplete purchase order (PO) documents

PO documents in suspense

open POs that have not yet been turned into invoices

open POs that need to be closed

You will also want to use the query forms to view how much encumbrance remains on purchase order documents.

Note: Prior to the fiscal year-end roll, you will also want to run an additional Report –the Open Encumbrance Report (FGROPNE) – to see what will actually roll when you roll encumbrances.

Accounts Payable

Accounts Payable – can be done weekly but should be done at least monthly. At the end of each month you will want to run reports to check for:

incomplete invoices

invoices in suspense or on hold

valid invoices

invoices that are posted but not paid past 30 days.

Journal vouchers

Journal Vouchers – can be done weekly but should be done at least monthly. At the end of each month you will want to run reports to check for:

incomplete journal vouchers

suspended journal and feed documents.

Requisitions

Banner Name	Form Name	Description
FGRIDOC	Incomplete Document Report	Run this report for requisitions to list incomplete documents. Use FPAREQN to correct or delete requisitions. Usually someone in accounting runs this and contacts listed user ID with questions.
FPIREQS	Requisition Suspense List Form	Use this form to determine if any requisition documents are in suspense. Use the FPAREQN to correct or delete the document.
FPROPNR	Open Request Report	Run the report to verify valid open requisitions (not turned into purchase orders yet). Any open requests not turned into Purchase Orders will be deleted when you roll your encumbrances forward. You should cancel any requisitions that you do not want to keep using FPARDEL.
FPARDEL	Requisition Cancel Form	Use this form to cancel any posted requisitions to be reversed. You cannot cancel a requisition that has purchase order activity attached to it.
FGIENCD	Encumbrance Query Form	Use this form to query on how much encumbrance remains on requisition documents. You can view requisitions, purchase order or general encumbrance documents because it only queries the General Encumbrance Ledger.
FPAEOCD	Encumbrance Open/Close Form	Use this process to close a requisition
FGROPNE	Open Encumbrance Report	Run this report to verify any open encumbrances.

Purchasing

Banner Name	Form Name	Description
FGRIDOC	Incomplete Document Report	Run this report for a list of Purchase Orders that are incomplete. Use FPAPURR to correct or delete Purchase Orders.
FPIPORS	Purchase Order Suspense List Form	Use this form to determine if any PO documents are in suspense. Use the FPAPURR to correct or delete the document.
FPROPNP	Open Purchase Orders Report	Run this report to verify valid open POs (not invoices yet)
FPARDEL	Purchase Order/Blanket Order Cancel Form	Use this form to cancel any posted POs that need to be reversed. Do not cancel a purchase order that has a receiver or invoice activity attached to it until you have canceled the invoice and reversed (adjusted) the receiving document to zero.
FPPPOBC	PO Batch Close Process	Use this process to close purchase orders in batches. Keep this form secure since it can be used to close all purchase orders. You can use a Maximum Encumbrance Amount of 0.00 to close those open POs that have 0.00 encumbrance amounts. If it does not close the PO, it will tell you why.
FGIENCD	Encumbrance Query Form	Use this form to query on how much encumbrance remains on purchase order documents.
FPAEOCD	Encumbrance Open/Close Form	Use this process to open/close a purchase order.
FGROPNE	Open Encumbrance Report	Run this report monthly to view a list of all open encumbrances, which includes Requisitions, Purchase Orders, and General Encumbrances. Prior to running the Year End Encumbrance Roll, run the FGROPNE report to determine which documents need to be cleaned up and which ones will actually roll to the new fiscal year.
FGAJVCD	Journal Voucher Entry Form	Use this form to liquidate encumbrances.

Accounts Payable

Accounts Payable – can be done weekly but should be done at least monthly.

Banner Name	Form Name	Description
FGRIDOC	Incomplete Document Report	Run this report to view a list of incomplete invoices and use the FAAINVE form to either complete or delete the documents.
FAIINVL	Invoice/Credit Memo List Form	View Suspended and Hold invoices on this form. Use the FAAPAYC form to take the invoices off hold so that they can be paid and use the FAAINVE form to delete or correct the suspended documents.
FARIAGE	Invoice Aging Report	Run an aging report for any invoices that are posted but not paid past 30 days.
FAROINV	Open Invoice Report	Run this report to view and determine valid open invoice documents.
FAAINVD	Invoice Cancellation Form	Use this form to cancel a posted invoice. If an invoice was created from a Purchase Order, canceling the invoice it will re-open the PO’s encumbered amount.
FABMATC	Receiving Matching Process	If three way matching is turned on, review this report for invoices pending receiving reports that have a transaction date in the prior period

Journal vouchers

Banner Name	Form Name	Description
FGRIDOC	Incomplete Document Report	Run this report for JVs to list incomplete documents.
FGIJVCD	Suspended Journal Voucher List	Use this form to view any suspended journal and feed documents. Use the FGAJVCD, FGAJVCQ or FGAJVCM form to view information on these suspended documents and fix or delete them.

Using the Open Close Fiscal Period Process at Month End

Introduction

The Open Close Fiscal Period Process (FGPOCFP) is new in Finance Release 8.7. This process is designed to provide authorized users with the ability to open and close fiscal periods when it is not possible to do so using the Fiscal Year Maintenance Form (FTMFSYR). Beginning in Finance 8.7, users with access to the FGPOCFP process have control over opening a previously closed fiscal period without database administrator (DBA) intervention.

This process may be run from Job Submission by chart of accounts and fiscal year.

This process includes the capability to perform the following updates, within a specific chart and fiscal year:

Open a fiscal period.

Close a fiscal period.

Update all Budget Period edit codes in the rule classes.

Update the status of the accrual period.

The validation for fiscal periods 01 through 13 has been included, recognizing that some customers may use thirteen (13) fiscal periods, rather than the customary twelve (12).

Update Budget Period Edit Code

For customers that select a default budget period to be enforced at data entry time, this optional FGPOCFP feature may be used to update existing Rule Class Edit Table (FTVEDIT) records that contain a Budget Period edit, specifically those records that contain an edit field of Budget Period and an edit code of 0004 to enforce a specified period:

Edit Sequence: Budget Period

Edit Code: 0004 Default User Specified Value

Literal Value: 01

For example, if you enter Y in the Update Budget Period Edit Code parameter for FGPOCFP, the literal value will be updated from 01 to a new value matching the fiscal

period specified in the Fiscal period to be opened parameter; therefore, if you enter 06 as the fiscal period, then the literal value for all Budget Period rule class edits will be updated to 06.

Update Accrual Period

The status of the accrual period (period 14) can be updated only if period 14 was already opened by the Balance Forward Report (FGRGLRL). As one of the year-end processes, FGRGLRL is the only mechanism available to update the status of the accrual period from Not Open to Open. After the accrual period is opened using FGRGLRL, the FGPOCFP process can be used to close and/or subsequently re-open the accrual period. The accrual period may not be closed with FGPOCFP if any of the fiscal periods are open. In this case, close any remaining fiscal periods, and then close the accrual period. The accrual period can also be closed manually on FTMFSYR if all other periods are closed.

FGPOCFP Parameters

The following table contains the parameters for the FGPOCFP process.

Parameters	Name	Required?	Description	Values
01	Chart of Accounts Code	Yes	Chart of Accounts code for which you are opening or closing fiscal periods.	Valid Chart of Accounts
02	Fiscal Year	Yes	Fiscal year that contains the fiscal period that you are opening or closing.	Valid Fiscal Year
03	Fiscal period to be opened	No	Fiscal period that you are opening	01-13
04	Fiscal period to be closed	No	Fiscal period that you are closing	01-13

Parameters	Name	Required?	Description	Values
05	Update Budget Period Edit Code	Yes	Enter Y to update the Budget Period edit code, or enter N to leave the Budget Period edit code unchanged.	Y Update Budget Period edit code N Do not update Budget Period edit code
06	Accrual Period Update	No	Enter O to change the accrual period status to Open, or enter C to change the accrual period status to Closed.	O Change the accrual period status to Open C Change the accrual period status to Closed

Banner process

Steps

Follow these steps to complete the process.

Access the Open Close Fiscal Period Process (FGPOCFP).

Click the Next Block icon.

Enter a printer name or DATABASE in the Printer field.

Click the Next Block icon.

Enter a chart code in the Parameter 01 Chart of Accounts Values field.

Enter the fiscal year that contains the fiscal period that you are opening or closing in the Parameter 02 Fiscal Year Values field.

Enter the fiscal period to be opened in the Parameter 03 Fiscal period to be opened Values field OR enter the fiscal period to be closed in the Parameter 04 Fiscal period to be closed Values field.

Enter Y to update the Budget Period edit code, or enter N to leave the Budget Period edit code unchanged in the Parameter 05 Update Budget Period Edit Code Values field.

Enter O to change the accrual period status to Open, or enter C to change the accrual period status to Closed in the Parameter 06 Accrual Period Update Values field.

Click the Next Block icon.

Click the Save icon to run the report.

Summary

Summary

By completing this section you have

processed General Accounting transactions

produced reports for the Chart of Accounts

queried financial data

produced daily and monthly financial reports

reviewed month-end processes

Self Check

Directions

Use the information you have learned in this workbook to complete this self check activity.

Question 1

What is the function of the Chart of Accounts Maintenance Form (FTMCOAS)?

Question 2

What are the “Keys” which are established in the Budget Control block of the Chart of Accounts Maintenance Form (FTMCOAS), and what does entering a Y or N indicate?

Question 3

The Close Operating Ledger Rule Class field in the Parameters block on the Chart of Accounts Maintenance Form (FTMCOAS) is a required field. What does this code represent?

Question 4

What does the Encumbrance Parameters block define?

Question 5

The Budget Carry Forward Parameters block allows the definition of the following rules. What does each rule indicate?

Budget Type:

Budget Class:

Question 6

What are the six things defined on the Fiscal Year Maintenance Form (FTMFSYR)?

Question 7

The Chart of Accounts code must exist and be in effect before it can be used on the Account Type Validation Form (FTVATYP).

True or False

Question 8

What is entered in the Entity/Usage Code field?

Question 9

Where on the System Data Maintenance Form (FTMSDAT) do you identify the name of the column within the specified table?

Question 10

What is defined in the Optional Code #1 field?

Question 11

The Account Type Code Maintenance Form (FTMATYP) requires that what three things must be established and in effect?

Question 12

What is needed to define a Level 2 account?

Question 13

User-defined account codes are created on the Account Code Maintenance Form (FTMACCT), and are tied to account types defined on what form?

Question 14

How do you access the FOAPAL Attribute Association Form (FTMFATA)?

Question 15

The Control Account Maintenance Form (FTMACTS) allows you to establish what?

Question 16

If a particular amount (which is identified by the Sequence Number) requires an offset account, how is this indicated?

Question 17

Fund Codes must be established and in effect before any Fund Types may be established in the system.

True or False

Question 18

List three features supported on the Fund Type Maintenance Form (FTMFTYP).

Question 19

Why is it important to establish Fund codes?

Question 20

List the five features supported on the Fund Code Maintenance Form.

Question 21

The Fund Balance Account Maintenance Form (FTMFBAL) provides you with the ability to cross reference fund balance accounts to what three things for a single chart of accounts?

Question 22

Where on the Fund Balance Account Maintenance Form (FTMFBAL) do you indicate what type of Fund/Account combination you want to report on FASB 117 reports?

Question 23

A Bank ID must exist on the General Person table before being entered on the Person Identification Form (FOAIDEN).

True or False

Question 24

If the Bank ID code already exists in the General Person table, the name will be displayed but will not be updateable.

True or False

Question 25

What is the purpose of the Bank Account Number field?

Question 26

Define the following:

Bank Fund:

Cash Account:

Interfund Account:

Question 27

What do program codes represent?

Question 28

What are the three required fields on the Program Code Maintenance Form (FTMPROG)?

Question 29

How are Activity codes used?

Question 30

Location codes are maintained in a ___ level hierarchy structure.

Question 31

All levels of the hierarchy must be used?

True or False

Question 32

Entering the Square Footage/Square Footage Rate fields provides additional information to the system for what subsequent use?

Question 33

What is the maximum number of levels in an organization?

Question 34

The Financial Manager ID must be in the General Person Identification Table (SPAIDEN).

True or False

Question 35

If Fund, Predecessor Organization, Program, Location, or Budget Control Organization code(s) are entered, they must ____ and ____.

Question 36

What is the function of the Agency Code Maintenance Form (FTMAGCY)?

Question 37

The Agency structure is a maximum ___ level user defined hierarchy.

Question 38

What do Account Index codes represent?

Question 39

What designation are you providing by entering one or all of the values in the Accounting Distribution block of the Account Index Code Maintenance Form (FTMACCI)?

Question 40

What do the Interfund Due To/Due From fields indicate?

Question 41

The Fund Balance Account (entered in the Parameters block) used for what?

Question 42

What do the attribute types that are set up on the Attribute Type Maintenance Form (FTMATTT) enable you to do?

Question 43

Attribute values, which are linked to attribute types and are optional, are set up on the Attribute Value Maintenance Form (FTMATTV).

True or False

Question 44

Set codes, attribute types, and/or attribute values are associated to FOAPAL codes on what form?

Question 45

Where can you search for information about FOAPAL codes, set codes, attribute types, and/or attribute values?

Question 46

The Currency code table contains many attributes that describe each currency code and allow the system to know how to treat each currency code.

True or False

Question 47

The Currency Code Maintenance Form (GUACRR) is non-chart specific. In a multi-chart environnent, certain codes must remain consistent. This form contains two such code fields. What are they?

Question 48

The Financial Manager Maintenance Form (FTMFMGR) is used to identify financial managers and principal investigators in the system. They must be established using this form before what can happen?

Question 49

A manager is assigned to what three things on the Financial Manager Maintenance Form (FTMFMGR)?

Question 50

What is the function of the Installation Control Form (GUAINST)?

Question 51

Where will the name entered in the Name field appear?

Question 52

Where do you enter the current release number for each Banner System at the institution?

Answer Key for Self Check

Question 1

What is the function of the Chart of Accounts Maintenance Form (FTMCOAS)?

The Chart of Accounts Maintenance Form allows the establishment and maintenance of the Charts of Accounts for the institution. It is also used to define the institution policies and system control rules for the operation of the financial system.

Question 2

What are the “Keys” which are established in the Budget Control block of the Chart of Accounts Maintenance Form (FTMCOAS), and what does entering a Y or N indicate?

The Budget Control “Keys” are Funds, Organization, Account, and Program. By entering a value of Y- Yes, or N – No, the user indicates what level of budget control is to be enforced for all budgets within the chart of accounts.

Question 3

The Close Operating Ledger Rule Class field in the Parameters block on the Chart of Accounts Maintenance Form (FTMCOAS) is a required field. What does this code represent?

This four-character alpha/numeric code represents the rule used in the process that closes the operating ledger at the end of the year.

Question 4

What does the Encumbrance Parameters block define?

Encumbrance Parameters are entered to define to the system how encumbrance values recorded during the year are to be treated in the year-end process.

Question 5

The Budget Carry Forward Parameters block allows the definition of the following rules. What does each rule indicate?

Budget Type: indicates whether the budget is treated as a temporary or a permanent budget.

Budget Class: indicates whether the budget is to be recorded in the new fiscal year as an Original Budget or an Adjusted Budget.

Question 6

What are the six things defined on the Fiscal Year Maintenance Form (FTMFSYR)?

Fiscal Year dates

Number of periods

Period status

Start and end dates

Fiscal Quarter indicators

Accrual period

Question 7

The Chart of Accounts code must exist and be in effect before it can be used on the Account Type Validation Form (FTVATYP).

False. The Account Type Validation Form is used to set up the account type codes. They will be linked to the Chart of Accounts code later.

Question 8

What is entered in the Entity/Usage Code field?

The form or table that identifies the entity.

Question 9

Where on the System Data Maintenance Form (FTMSDAT) do you identify the name of the column within the specified table?

The Attribute Code field identifies the column name.

Question 10

What is defined in the Optional Code #1 field?

The Optional Code #1 field contains a user-defined, eight-character code, which applies to the entity and attribute combination.

Question 11

The Account Type Code Maintenance Form (FTMATYP) requires that what three things must be established and in effect?

Chart of Accounts

Internal Account Type

Predecessor Code

Question 12

What is needed to define a Level 2 account?

The Predecessor Code.

Question 13

User-defined account codes are created on the Account Code Maintenance Form (FTMACCT), and are tied to account types defined on what form?

The Account Type Code Maintenance Form (FTMATYP).

Question 14

How do you access the FOAPAL Attribute Association Form (FTMFATA)?

Select Assign Attributes from the Options menu.

Question 15

The Control Account Maintenance Form (FTMACTS) allows you to establish what?

The Control Account Maintenance Form (FTMACTS) allows you to establish a relationship among various budget, actual, and encumbrance amounts found on the Operating Ledger and the control accounts found on the General Ledger.

Question 16

If a particular amount (which is identified by the Sequence Number) requires an offset account, how is this indicated?

A value of OFFSET is entered in the Data field on the System Data Table (accessed via the System Data Maintenance Form (FTMSDAT).

Question 17

Fund Codes must be established and in effect before any Fund Types may be established in the system.

False. Fund Types must be established and in effect before any Fund Codes may be established in the system.

Question 18

List three features supported on the Fund Type Maintenance Form (FTMFTYP).

Budget Control definitions

Fixed Asset Capitalization

Fiscal Year End Processing

Question 19

Why is it important to establish Fund codes?

The Fund code is a primary component of the overall accounting structure and is required on all accounting transactions.

Question 20

List the five features supported on the Fund Code Maintenance Form.

Budget Control definitions

Fixed Asset Capitalization

Grant Accounting

Multiple Fund Balance definition

Defaulting of Organization, Program, Activity and Location codes

Question 21

The Fund Balance Account Maintenance Form (FTMFBAL) provides you with the ability to cross reference fund balance accounts to what three things for a single chart of accounts?

Fund types

Fund codes

Account codes

Question 22

Where on the Fund Balance Account Maintenance Form (FTMFBAL) do you indicate what type of Fund/Account combination you want to report on FASB 117 reports?

The Rest(riction) Ind.

Question 23

A Bank ID must exist on the General Person table before being entered on the Person Identification Form (FOAIDEN).

False. If a new ID code is entered on the Person Identification Form (FOAIDEN) that does not exit on the General Person table, a General Person record will be created, assigning a new PIDM to the vendor.

Question 24

If the Bank ID code already exists in the General Person table, the name will be displayed but will not be updateable.

True

Question 25

What is the purpose of the Bank Account Number field?

This field contains a 15-character code that the bank uses to recognize you. This is the number that is encoded on checks.

Question 26

Define the following:

Bank Fund: A code which uniquely identifies a fiscal entity

Cash Account: The account number and title of the installments cash balances in the bank fund

Interfund Account: The account number and title of the installments cash balance in each operating ledger

Question 27

What do program codes represent?

Program codes represent functional classifications of financial activity such as Instruction, Research, and Public Support.

Question 28

What are the three required fields on the Program Code Maintenance Form (FTMPROG)?

Chart of Accounts

Program code

Program title

Question 29

How are Activity codes used?

An Activity code is an optional code in the accounting distribution and may be used to further delineate financial activity of the institution.

Question 30

Location codes are maintained in a ___ level hierarchy structure.

Five

Question 31

All levels of the hierarchy must be used?

False.

Question 32

Entering the Square Footage/Square Footage Rate fields provides additional information to the system for what subsequent use?

This information is used in cost studies.

Question 33

What is the maximum number of levels in an organization?

Eight.

Question 34

The Financial Manager ID must be in the General Person Identification Table (SPAIDEN).

True.

Question 35

If Fund, Predecessor Organization, Program, Location, or Budget Control Organization code(s) are entered, they must ____ and ____.

If Fund, Predecessor Organization, Program, Location, or Budget Control Organization code(s) are entered, they must exist and
be in effect.

Question 36

What is the function of the Agency Code Maintenance Form (FTMAGCY)?

The Agency Code Maintenance Form (FTMAGCY) to create and maintain a list of agencies external to your installation for reporting purposes.

Question 37

The Agency structure is a maximum ___ level user defined hierarchy.

Five.

Question 38

What do Account Index codes represent?

Index codes represent “short hand” codes, which may be used to reduce the keystrokes necessary to enter an accounting distribution in the system.

Question 39

What designation are you providing by entering one or all of the values in the Accounting Distribution block of the Account Index Code Maintenance Form (FTMACCI)?

By entering one or all of the values in the Accounting Distribution block, you are providing a designation of the default accounting distributions that will be automatically brought to the transaction entry when the Account Index code is entered.

Question 40

What do the Interfund Due To/Due From fields indicate?

The Chart Due To/Due From accounts are entered to indicate to the system which accounts are to be used when the automatic posting of due to/due from accounts is to occur. This allows the user to debit one fund and credit another fund without having to enter the offsetting due to/due from accounts.

Question 41

The Fund Balance Account (entered in the Parameters block) used for what?

The Fund Balance Account may be used for journal entry and for the posting account when the operating account ledger is closed at year-end.

Question 42

What do the attribute types that are set up on the Attribute Type Maintenance Form (FTMATTT) enable you to do?

Attribute types enable you to categorize financial information for reporting purposes.

Question 43

Attribute values, which are linked to attribute types and are optional, are set up on the Attribute Value Maintenance Form (FTMATTV).

True.

Question 44

Set codes, attribute types, and/or attribute values are associated to FOAPAL codes on what form?

FOAPAL Attribute Association Form (FTMFATA).

Question 45

Where can you search for information about FOAPAL codes, set codes, attribute types, and/or attribute values?

FOAPAL Attribute Association Query Form (FTIFATA).

Question 46

The Currency code table contains many attributes that describe each currency code and allow the system to know how to treat each currency code.

True.

Question 47

The Currency Code Maintenance Form (GUACRR) is non-chart specific. In a multi-chart environnent, certain codes must remain consistent. This form contains two such code fields. What are they?

A/P Account

Exchange Rate

Question 48

The Financial Manager Maintenance Form (FTMFMGR) is used to identify financial managers and principal investigators in the system. They must be established using this form before what can happen?

A financial manager must be established using the Financial Manager Maintenance Form (FTMFMGR) before assigning a manager to an organization or fund/grant.

Question 49

A manager is assigned to what three things on the Financial Manager Maintenance Form (FTMFMGR)?

Chart of Accounts

A home organization

A home location

Question 50

What is the function of the Installation Control Form (GUAINST)?

The Installation Control Form (GUAINST) maintains overall system information for the installation.

Question 51

Where will the name entered in the Name field appear?

The name entered in the Name field will be used in all standard form headings and standard report headings.

Question 52

Where do you enter the current release number for each Banner System at the institution?

The current release number for each Banner System at the institution is entered on the Installation Control block, which is accessed by selecting Installation Control from the Options menu.

Appendix

Forms Job Aid

Form	Full Name	Use this Form to...
FGAAUTO	Automatic Journal Voucher	specify routine or recurring journal transactions for the Finance ledgers, such as month-end accruals.
FGAENCB	Encumbrance/Reservations Maintenance Form	encumber or reserve funds for future commitments.
FGAJVCD	Journal Voucher Entry Form	make journal entries into the Finance ledgers.
FGAJVCQ	Journal Voucher Quick Form	enter a journal voucher quickly. The Quick form does not allow for certain types of processing such as Encumbrance liquidations or Accrual postings.
FGIAUTO	List of Automatic Journal Voucher Form	view an online query of defined automatic journal entries within the system.
FGIBAVL	Budget Availability Status Form	view an online query of the budget availability for a selected fund, organization, account, and program combination.
FGIBAVL	Budget Availability Status Form	view an online query of the budget availability for a selected fund, organization, account, and program combination.
FGIBDSR	Executive Summary Form	Access an online query of operating ledger budget and activity data organized by account.
FGIBDST	Organizational Budget Status Form	view an online query of the budget availability by organization code.
FGIBSUM	Organizational Budget Summary Form	view summarized budget information by user-defined account type for a selected organization/fund combination.
FGIDOCR	Document Retrieval Inquiry Form	Access an online query capability for all transactions processed by the system.
FGIENCD	Detail Encumbrance Activity Form	view an online query of detailed transaction activity for an original encumbrance entry as well as all transaction activity against the encumbrance.
FGIGLAC	General Ledger Transaction Detail Form	view detailed transaction activity for General Ledger accounts by account number in an online summary.
FGIJSUM	Journal Voucher Summary Form	view an online summary of journal voucher transactions that are not yet posted.
FGIJVCD	List of Suspended Journal Voucher Forms	view an online query of pending journal vouchers in the system.
FGIOENC	Organizational Encumbrance List Form	view an online list of all encumbrances by organization.
FGITBAL	General Ledger Trial Balance Form	view an online display of a trial balance.
FGITRND	Detail Transaction Activity Form	display an online view of detailed transaction activity for operating ledger accounts.
FTIFATA	FOAPAL Attribute Association Query Form	query FOAPAL element association records. You can search for information about FOAPAL element codes, set codes, attribute types, and/or attribute values.
FTMACCI	Account Index Code Maintenance Form	establish an account index code that provides a short keying sequence for user-defined fund, organization, account, program, activity, and location (FOAPAL) combinations.
FTMACCT	Account Code Maintenance Form	establish an object of expenditure accounts.
FTMACTL	Control Account Maintenance Form	create and maintain revenue, expense, transfer, and encumbrance control accounts in Finance.
FTMACTV	Activity Code Maintenance Form	create activity codes that describe financial activity (e.g., auditing).
FTMAGCY	Agency Code Maintenance Form	create and maintain a list of agencies external to your installation for reporting purposes.
FTMATTS	Attribute Type Set Maintenance Form	create, update, remove, and query set codes. Set codes enable you to create groups of attribute types.
FTMATTT	Attribute Type Maintenance Form	create, change, inactivate, delete, and query attribute types.
FTMATTV	Attribute Value Maintenance Form	create, change, inactivate, delete, and query attribute values.
FTMATYP	Account Type Code Maintenance Form	define account types linked to user-defined account codes.
FTMCOAS	Chart of Accounts Code Maintenance Form	to define and maintain FOAPAL (Fund, Organization, Account, Program, Activity, Location) code data for each chart of accounts.
FTMFATA	FOAPAL Attribute Association Form	associate FOAPAL element codes to attribute types, attribute values, and set codes.
FTMFMGR	Financial Manager Maintenance Form	view demographic data about each financial manager and to establish budgetary responsibility for grants, funds, and organizations.
FTMFTYP	Fund Type Maintenance Form	establish fund types linked to user-defined fund codes.
FTMFUND	Fund Code Maintenance Form	establish fund codes for a specific chart of accounts.
FTMLOCN	Location Code Maintenance Form	establish location codes.
FTMORGN	Organization Code Maintenance Form	establish organization codes representing functions and departments within your site.
FTMPROG	Program Code Maintenance Form	establish program codes.
FTMSDAT	System Data Maintenance Form	maintain information integral to the processing or maintenance of various transactions and/or reports within Finance.
GUACURR	Currency Code Maintenance Form	establish and maintain the currency codes used in the system.
GUAINST	Installation Control Form	enter and maintain overall system information for your institution.
GXRBANK	Bank Code Rule Form	define bank codes for your institution’s bank accounts, link bank funds and bank accounts with your cash accounts, and define Automatic Clearing House (ACH) information for your institution’s bank accounts.