Banner Accounts Receivable Training Workbook Release 8.4.1 – June 2012 Updated 7/30/2012
_______________________________________________________________________________________________

Prepared by: Ellucian

4375 Fair Lakes Court

Fairfax, Virginia 22033

United States of America

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
January 2012	New version that supports Banner 8.4 software.
June 2012	Updates for Ellucian rebranding.
July 2012	Updates for release 8.4.1

Notice of rights

Copyright © Ellucian 2005-2012.

This document is proprietary and confidential information of one or more of the Ellucian companies and is not to be copied, reproduced, lent, displayed used or distributed except under license from Ellucian. Third party copy centers are advised that clients of Ellucian that have licensed the underlying technology associated with this documentation have a valid license to copy and use this documentation in accordance with that underlying license.

Table of Contents

Introduction	5

Process Introduction	7

Banner 8 Enhancements	8

Set Up	10

Enrollment Period Processing	11

Building Auto-Hold Rules	12

Create a Non-Person	18

Create a Person	21

Create a User Profile	24

Enter Comments about Account Holders	27

Define a Customer Profile	29

Quick Entry and Registration of a Student	31

Review Assessment of Fees	37

Displaying Study Path Information	45

Process Exemptions	46

Creating Detail Codes and Accounting	51

Build Student-Related Detail Codes	52

Aid Year-based Accounting	60

Aid Year-Based Designator Validation Form	65

Aid Year-Based Designator Rule Form	67

Aid Year Validation Form	69

Term-based Accounting	70

Build Term-Based Designators	74

Associate an Effective Date with an Accounting Distribution	80

Change an Existing Set of Accounting Distribution Values	82

Change a Detail Code from Term or Aid Year-based to Non-Term or Aid Year-based	84

Change a Detail Code from Non-Term or Aid Year-based to Term or Aid Year-based	86

Change an Existing Set of Term-based Designator Codes	88

Managing Billing and Late Fees	89

Review the Schedule/Bill Rules Form	91

Review the Third Party Billing Rules Form	109

Process Third-Party Contracts	117

Managing Installment Plans	127

Create an Automated Installment Plan	128

Create Assignment Rules	131

Create Payment Rules	132

Process Installment Plans for a Student Account	135

Managing Delinquencies and Collections	138

Set Up for Handling Delinquent Accounts	139

Processing Delinquent Accounts	141

Sending Accounts to the Collection Agency	143

Setting Up for Write-off Procedures	144

Processing Bad Debt	145

Managing Payments and Deposits	147

Create a Deposit (TGADEPC)	148

Query Records in the Account Charge/Payment Detail table (TBRACCD)	150

Accept Charges and Post Payment on the Student Payment Form (TSASPAY)	153

Post a Charge on an Account	156

Post a Payment on the Account Detail Review Form – Student (TSAAREV)	160

Distribute a Single Payment to Multiple Charges	162

Review a Student Account	164

Query Account by Detail Code	166

Process Deposits and Post Deposits to a Student’s Account	168

Use Mass Entry for Student Charges and Payments	172

View the Account Transactions for a Student	174

Managing Application of Payments	176

Direct Application of Payment	177

Review the Application of Payments	179

Perform an Unapplication of Payments - Student	184

Managing Cashiering Sessions	187

Perform Miscellaneous Routine Cash Receipts	188

Perform Miscellaneous Non-routine Cash Receipts	190

Process Non-Sufficient Fund Checks	193

Use the Receipt Form (TGARCPT)	196

Use the Receipt Query Form (TGIRCPT)	199

Review and Close Cashier Sessions	201

Adjust a Closed Session – Regular	206

Adjust a Closed Session – Miscellaneous	211

Finalize a Cashier Session	213

Auto Refunding of Credit Amounts	216

Reconciling Accounts Receivable to Finance	222

Nightly Feed to Finance Best Practice	223

Generate the Accounting Feed Report	227

Running the Accounts Receivable Reconciliation Report	229

Reading the A/R Reconciliation Report	232

Balancing A/R to Finance	240

Review of Accounts Receivable	242

Self Check	243

Self Check – Answer Key	249

Appendix	257

Forms Job Aid	258

Introduction

Course goal

The goal of this workbook is to provide an overview of the Accounts Receivable system.

The workbook is divided into these sections:

Introduction

Set Up

Creating Detail Codes and Accounting

Managing Billing and Late Fees

Managing Installment Plans

Managing Delinquencies and Collections

Managing Payments and Deposits

Managing Application of Payments

Managing Cashiering Sessions

Reconciling Accounts Receivable to Finance

Review of Accounts Receivable

Appendix

Course objectives

At the conclusion of this course, participants should be able to

build standard charge and payment detail codes

process student charges and payments

describe the process of admission, registration, and fee assessment

query an individual person’s account

apply payments to specific charges

unapply charges and their related payments

create a company account

process a returned check transaction

adjust a cashier’s session

close and finalize a cashier’s sessions

reconcile accounts receivable to finance.

Intended audience

Student Accounts Receivable Office Administrators and Staff

Prerequisites

To complete this section, 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 the rules and set the validation codes in Banner.

Process Introduction

Introduction

The Business Office staff will create detail codes with accounting data, assess charges, process payments, handle third party contracts, exemptions, generate billings, process returned checks, handle collection activity of past due accounts and perform various audit and control functions using the Banner Accounts Receivable module.

Flow diagram

This diagram summarizes the overall Accounts Receivable process.

Banner 8 Enhancements

Internationalization

Banner Accounts Receivable 8.0 includes the following Internationalization enhancements as part of the overall Banner 8.0 release:

Banner now supports the Unicode international character set (UTF8) and its Oracle database has been converted to the UTF8 standard.

A new table, the Additional Identification Table (GORADID), allows storage of any number of extra IDs for a person. Each additional ID must be assigned an ID type. These can be set up using the Additional Identification Type Validation Form (GTVADID).

A new Additional ID tab on SPAIDEN displays the new Additional ID information. Please refer to the Banner Student 8.0 Release Guide for more information on this.

Many fields have been expanded on Banner tables and forms so as to accommodate longer data values that may be needed, including fields such as currency amounts, currency rates, names, addresses and IDs. Please refer to the Banner General 8.0 Release Guide for more information on this.

Partial Data Masking

With Banner 8.0, the ability to partially mask a field has been extended to character fields. A specified number of characters at either side of a field can remain readable while the rest of the value is masked.

To support partial character masking, two new fields have been added to the Data Display Mask Rules Form (GOTDMSK):

Partial Character Mask

Partial Character Length

For additional detailed information about partial data masking, please refer to the Banner General 8.0 Release Guide.

PIN Maintenance

An enhancement has been added for user PIN (password) security.

PINs are now stored only in encrypted form.

Institutions can now set and enforce standards for strong passwords.

A new, more secure PIN reset mechanism has been established.

A new PIN Questions Form (GOAQSTN) has been added.

The Enterprise PIN Preferences Form (GUAPPFR), the Third Party Access Form (GOATPAC) and the Third Party Access Audit Form (GOATPAD) have been modified for the PIN security updates.

For additional detailed information about the PIN enhancement, please refer to the Banner General 8.0 Release Guide.

Supplemental Data Engine

The Supplemental Data Engine (SDE) is a simple way to add data fields to Banner forms, allowing storage of data that is not part of the existing Banner data model.

For additional detailed information about the SDE enhancement, please refer to the Banner General 8.0 Release Guide.

Set Up

Introduction

The purpose of this section is to outline the set-up process and detail the procedures to set-up your Banner system to manage Accounts Receivable functionality at your institution.

Objectives

At the end of this section, you will be able to

process the enrollment period

build auto-hold rules

create a non-person

create a person

create a user profile

enter comments about account holders

define a customer profile

quickly enter and register a student

review assessment of fees

display study path information

process exemptions.

Enrollment Period Processing

Introduction

Periods are created in Banner Financial Aid. A Period can include one or more terms. Only one term in the period may be flagged as the Accounts Receivable term. The Accounts Receivable term is the term passed into A/R when Financial Aid is disbursed or memoed.

For periods with more than one term, application of payments processing treats the terms in the period as a single unit for processing purposes. For example, two summer terms (201250 and 201270) are combined into a period caqlled Summer201260, and term 201250 is flagged as the A/R term. When the A/R term is passed to Accounts Receivable, term 201250 will be disbursed to Accounts Receivable and can be used to pay charges for both 201250 and 201270 terms.

For a detail code disbursed to a period that has more than one term, Application of Payments processing applies first to charges with terms matching a term in the period, before applying to other terms.

Payment Detail Codes flagged as Like Period will only pay charges with terms in the same period. Terms in a period are paid in ascending order, from earliest to latest term.

Forms

These forms and processes include references to Enrollment Periods:

Account Detail Review Form (TSAAREV)

Student Account Detail Form (TSADETL)

Foreign Currency Detail Form (TSADETF)

Account Detail Query Form (TGIACCD)

Application of Payment Review Form (TSIAPPL)

Customer Service Inquiry Form (TSICSRV)

Detail Code Control Form (TSADETC)

Application of Payments Process (TGRAPPL)

Building Auto-Hold Rules

Introduction

The Auto Holds Rule Form (TGAHOLD) is used to create automatic holds on accounts. The holds can be non-conditional which ignore balances and put a hold on all accounts within a certain population if desired. Holds can also be placed on accounts by building balance or aging criteria using this form. Always run the application of payment process before running the process to putting automatic holds on an account.

Banner form

Steps

Follow these steps to complete the process.

Access the Auto Holds Rule Form (TGAHOLD)

Enter AR in the Rule Code field

Perform a Next Block function.

Enter AR in the Hold Type field in order to put AR holds on any accounts that meet the criteria.

Click the Release checkbox only the user that is referenced in the following box can release this hold.

Note: Recommended to leave blank for auto-hold process.

Enter an explanation of why a hold is put on an account in the Reason field.

Enter the dollar amount associated with the hold in the Amount field.

Enter a begin date of the hold in the From field.

Enter an expiration date of the hold in the To field.

Enter the office that originates the hold in the Originator field.

Click the Purge Prior Holds checkbox to purge prior released holds from the hold table (SPRHOLD).

Click the Include Non-Person checkbox to apply the hold to non-person accounts as well as person accounts.

Click the Non-Conditional checkbox if you are performing a population selection that you want to apply the hold regardless of balance.

Note: If this box is checked and a population selection is not used Banner will put the hold on all accounts. Leave unchecked to build balance or aging rules.

Perform a Next Block to access the Account Balance Rules window.

Note: Use this window to build hold criteria based on account balance. UTo build hold rules use this window or the next window but not both. If both are populated the Automatic Hold Process (TGPHOLD) will not work.

Enter 100.00 in the Minimum Account Balance field to put holds on any accounts greater than $100.00.

Enter a maximum balance if desired in the Maximum Account Balance field.

Enter a date in the Account As of Date field to look for charges as of the date entered.

Click the Include Future Charges checkbox if you want it to calculate future charges in the balance calculation like payment plans.

Click the Include Financial Aid checkbox if you want it to allow authorized, non-disbursed Aid to reduce the balance due. For Non-Student AR, leave the Include Financial Aid unchecked since Non-Student AR does not have Financial aid.

If you checked Include Financial Aid you will need to populate For Terms and Term to designate how much authorized, non-disbursed aid should be used to reduce the balance amount. If also using the Account As of Date field it is recommended to not use future term aid. For Non-Student AR, leave the For Terms field blank.

See previous. For Non-Student AR, leave the Term field blank.

Click the Include FinAid Memos checkbox to allow memoed financial aid to reduce the balance amount. Checking this box will require you to populate the For Terms and Term fields. For Non-Student AR leave the Include FinAid Memos unchecked.

If you checked Include FinAid Memos you will need to populate For Terms and Term to designate how much memoed aid should be used to reduce the balance amount. If also using the Account As of Date field it is recommended to not use future term aid. For Non-Student AR, leave the For Terms field blank.

See previous. For Non-Student AR, leave the Term field blank.

For Non-Student AR leave the Memos For Terms field blank.

For Non-Student AR leave the Memos Term field blank.

Click the Include A/R Memos checkbox to include AR memos in the calculation

For Non-Student AR leave the Include Contract Memos unchecked

Perform a Next Block function to navigate to the next window.

Note: Use this window to build rules based on aging date of the accounts instead of balance criteria. UUse either this window or the previous window to build criteria or the Auto Hold Process (TGPHOLD) will not work.

Select a date to base the criteria in the Aging Date field.

Note: Options include:

Billed Date – Date the transaction was billed.

Effective Date – The effective date of the charge

Due Date – Date the transaction is due

Enter a number in the Minimum Aging Days field to put a hold on any account with a balance that is this many days or greater.

Enter the maximum days to age to in the Maximum Aging Days fields.

Note: This field is usually used in conjunction with the above parameter.

Enter an amount in the Minimum Aging Balance field to put a hold on an account with a balance greater than or equal to the amount entered.

Enter an amount in the Maximum Aging Balance field to put a hold on an account with a balance less than or equal to this balance.

Click the Save icon.

Click the Exit icon.

Create a Non-Person

Introduction

A non-person account is created to enter non-student accounting transactions for companies and associations.

Collection agencies (internal or external to the institution) are defined with an ID and a name on the Identification Form (FOAIDEN or SPAIDEN) and exist on the system as non-persons.

Access the Identification Form (SPAIDEN).

Click on the Search icon to access the Non-Person Search Form (SOACOMP). Enter the name of the company you wish to create and query to ensure that the person has not been created already. (Return to SPAIDEN after doing so.)

Click the Generate ID icon to generate an ID. This will transfer you to the Common Matching Entry Form (GOAMTCH).

Select a Common Matching Source for Non-Persons

Access the Non-Person Name field and enter the non-person’s name.

Click Save to return to SPAIDEN. Note what happens in the Key ID and ID fields.

Perform a Next Block function and then select the Address tab.

Enter BI (Billing) in the Address Type field. Enter a billing address for your non-person.

Click Save, then click Exit.

Access the Name/ID Search Form (SOAIDEN).

Enter the non-person’s name in the Name field. The non-person should now be displayed.

Create a Person

Introduction

A person account is created to enter student and non-student accounting transactions.

Collection agencies (internal or external to the institution) are defined with an ID and a name on the Identification Form (FOAIDEN or SPAIDEN) and exist on the system as non-persons.

Steps

Create a person account in Banner.

Access the Identification Form (SPAIDEN).

Click on the Search icon to access the Person Search Form (SOAIDEN). Enter the name of the person you wish to create and query to ensure that the person has not been created already. (Return to SPAIDEN after doing so.)

Click on the Generate ID icon to be transferred to GOAMTCH.

Select a Common Matching Source for Persons

Access the Last Name field and enter the person’s last name.

Access the First Name field and enter the person’s first name.

Access the Middle Name field and enter either the person’s middle name or initial. It is not necessary to place a period after the initial, as the system will automatically place the period when the name is displayed.

Click Save to return to SPAIDEN. Note that the ID field and name are now populated.

Perform a Next Block function and then select the Address tab.

Enter MA (Mailing) in the Address Type field. Enter a mailing address for your person.

Click Save, then click Exit.

Access the Name/ID Search Form (SOAIDEN).

Go to the Name field.

Query on the new person’s name. The person should now be displayed.

Create a User Profile

Introduction

The User Profile Definition Form (TGAUPRF) is used to grant access to detail codes based on the category of the detail code.

Define a user

Define the user as a supervisor and grant permission for specific charge and payment transactions.

Each new User ID/User Name (password) must first be issued through the security function, which is one of the Banner General System utilities. The User Profile Definition Form (TGAUPRF) will not grant access to the Banner System. This form will only set supervisor access and restrict detail code availability.

Steps

Follow these steps to complete the process.

Access the User Profile Definition Form (TGAUPRF).

In the User ID field, enter the appropriate User ID in the Key block.

Perform a Next Block function.

Enter a name in the User Name field. Type in Cashier Supervisor.

Check the Restricted User field to restrict the user’s ability to post charges and payments. Enter detail category codes in the User Permissions block.

Check the Supervisor field to perform supervisory functions on the Cashier Supervisory Form (TGACSPV) and session adjustments on the Miscellaneous Transaction Forms (TFAMISC/TSAMISC), the Account Detail Form (TSADETL), and the Student Account Detail Review Form (TSAAREV).

Click the Save icon.

The instructor will demonstrate and explain the control on the Accounts Receivable Billing Control Form (TGACTRL).

Enter Comments about Account Holders

Introduction

The ability to add comments for student accounts can be accessed directly using the Comment Central Form (TGACOMC). Student/person/non-person account-specific comments can be entered using this form, or the comments can be entered by selecting the option Comment Form (TGACOMC) when you are in another Accounts Receivable form.

Review forms

Review the forms where comments are stored about accounts and transactions and review the forms that list all the comments and their original locations.

Steps

Follow these steps to complete the comment form.

Access the Comment Central Form (TGACOMC).

The student’s ID should default into the Key block. If not, enter the ID of the student.

Perform a Next Block function. All the forms that can contain comments are listed.

Notice the Data icons (filled pages) next to topics that contain existing comments.

Select the type of comment you wish to view.

To view all the comments associated with the ID, click View All Comments. Options from the Options menu will access the same information.

Define a Customer Profile

Introduction

The Customer Profile Definition Form (TGACPRF) is an optional form that is used to identify a customer with an entity category, establish a credit limit, and append text to a customer's account.

Banner form

Steps

Follow these steps to complete the Customer Profile Definition Form (TGACPRF).

Access the Customer Profile Definition Form (TGACPRF).

The student’s account number should display.

Perform a Next Block function.

Enter an Entity Code (query the table to find an appropriate code).

Perform a Next Block function.

Enter an Originator code (again, query the table to find an appropriate code).

Enter the comment “Student called today about making payment arrangement” in the Customer Comments block.

Click Save.

Quick Entry and Registration of a Student

Introduction

The Student Course Registration Form (SFAREGS) and the Quick Entry Form (SAAQUIK) are used to register students for courses.

Steps

Admit a student into the system for use in the Fee Assessment and Payment process.

Access the Student Course Registration Form (SFAREGS).

When this form is requested for the first time, the Student System Distribution Initialization Info Form (SOADEST) will appear. If this occurs, click the Exit icon to continue on to SFAREGS.

Enter an appropriate term in the Term field.

In the ID field, enter the ID of the person you’ve been working with in previous lessons.

Perform a Next Block function.

You should receive the message in the auto help line at the bottom of the form: '*Error* Person is not a student, can not register'.

Click Exit.

Access the Quick Entry Form (SAAQUIK). The ID that you previously entered on SFAREGS should default in. If not, enter the ID of the person you have been working with. Also, the term you entered onto SFAREGS should also default into the key block. If not, enter 200910 into the Term field.

Enter UG (Undergraduate) in the Level field.

Perform a Next Block function to populate the fields on this form. Student Type, Student Status, Residence, and a Curriculum record are required. See below for values if none default.

Steps

Follow these steps to view existing addresses.

Select the Addresses tab.

Use the scroll bar to view existing addresses for your person.

If your student does not have a billing address, perform an Insert Record function.

In the Address Type field, enter BI and then enter an address.

If your student does not have a mailing address, repeat the previous step, using an Address Type of MA and a different address.

Click Save.

Steps

Follow these steps to enter values.

Select the Biographicaltab of SAAQUIK, if you are not there already.

Update the Gender field to an appropriate value of M or F.

If the Birth Date field is not populated, enter 01/06/76. The class discussion should include options for entering dates.

If quick entry rules have been built for the level and term in the Key block, all the fields should be filled in the block. Acknowledge the message if you receive one

*Warning* Invalid TERM, LEVEL, CAMP, COL-1, DEG-1 & MAJ-1 for curriculum.

If the fields are not populated, enter the following values:

Field	Value
Ethnic	1
Citizenship	Y
Student Type	N
Student Status	AS
Residence	R
Catalog Term	200910
Campus	Will default into the form when the program code is entered
College	Will default into the form when the program code is entered
Program	BA_ANTHRO
Degree	Will default into the form when the program code is entered

Steps

Follow these steps to enter values.

In the Field of Study Block, click Search for the Type field. Select MAJOR.

In the Field of Study field, select ANTH (Anthropology).

In the Priority field in this block, enter 1.

In the Status field, enter INPROGRESS.

Click Save.

Click Exit.

Return to the Student Course Registration Form (SFAREGS).

The term and ID that you had previously entered should default in.

Perform a Next Block function.

A Status of EL (Eligible to Register) should default.

Perform a Next Block function to access the CRN field to register the student for courses.

Enter the following CRNs (Course Reference Numbers) in the CRN field and press tab after each one:

10021

10022

10023

10024

The instructor may provide alternate CRNs to use for this.

Click Save.

You are now registered for 10 credit hours.

The message “**Registered* *-[today’s date]” should appear in the Message field for each course.

Some of these courses may return error messages instead. For the purposes of this exercise, should this occur, select All from the Override field for each course record that returned an error. This will override the errors and allow you to save and continue on this form.

Y – Immediate Assessment appears in the Fees field. Assess fees immediately by saving, and acknowledge the message that displays.

Click Save to update the collector file for printing the student invoice and schedule using the Sleep/Wake feature of the system.

Click Exit.

This exercise registers the student for 10 credit and billing hours and assesses the student using the Registration Fee Assessment rules. Explanation is given in class of the use of different billing hours and the option of not performing the fee assessment online.

Review Assessment of Fees

Introduction

There are three options to view fee assessment information:

Registration Fees Process Control Form

Account Detail Review Form

Student/Course Fee Assessment Query Form

Steps

Review Fee Assessment rules using the Registration Fees Process Control Form (SFARGFE).

Access the Registration Fees Process Control Form (SFARGFE).

In the Key block, enter 200910 in the Term field.

Select Student from the Rule Type drop-down menu.

Select Regular from the Entry Type drop-down menu.

Access the Registration Charges and Fees block.

Enter a query of T% in the Detail Code field. Execute the query to bring back all the rules for assessment by student for Tuition detail codes.

Class discussion should include an explanation of each field in this block of the form.

Perform other queries based on the different data elements.

Select Charges by Course Level Rules from the Options menu, which establishes rules by course level. Notice the similarities of this block to the last block.

Select Charges by Course Campus Rules from the Options menu.

Notice that this block assesses based on the Campus code in addition to the other fields listed.

Select Charges by Course Attribute Rules from the Options menu.

Notice that this block assesses based on a course attribute code in addition to the other fields listed.

Explanation will be given in class for the differences in the three blocks and how to use them in conjunction with each other to establish registration fee assessment.

Click Exit.

Access the Term Control Form (SOATERM).

The term 200910 should populate the Key block.

Review the information on this form. The options on the Fee Assessment section of this form were discussed in class.

Note: The Effective Date field is for assessing tuition charges into the future.

Click Exit.

Steps

Follow these steps to review Account Detail Review Form – Student (TSAAREV).

Access the Account Detail Review Form – Student (TSAAREV).

Use the ID you used in the previous exercise.

Charges for the term should now be posted to the account as a result of the Online Fee Assessment process. It should look similar to the following table.

A Transaction Date field, Receipt field, and User ID field appear between the Effective Date field and the Transaction Number field. (You may need to use the horizontal scrollbar to view all fields.) If your account doesn’t contain the information displayed on the following page, stop and alert the instructor.

Actual transaction numbers depend on the number of transactions already posted to the account.

Detail Code	Description	Term	Charge	Payment	Balance	S	Effective Date	Transaction Number
BKST	Bookstore	200910	37.00	37.00	R	DD-MM-YYYY	5
T101	Tuition	200910	130.00	130.00	R	DD-MM-YYYY	4
STU1	Student U	200910	15.00	15.00	R	DD-MM-YYYY	3
S001	Student S	200910	75.00	75.00	R	DD-MM-YYYY	2
R001	Registration	200910	50.00	50.00	R	DD-MM-YYYY	1

Steps

Follow these steps to review the Student Course/Fee Assessment Query Form (SFAREGF).

Access the Student Course/Fee Assessment Query Form (SFAREGF).

Use the ID from the previous exercise and the 200910 term code.

Perform a Next Block function to display the student’s enrollment status and course registration for the term.

To display the fees to be charged the student based on his/her registration, select Fee Assessment Without Min/Max Applied from the Options menu.

Review the charges and note the total assessment.

The Student Fee Assessment block appears:

Detail Code	Description	Type	Ref	Charge	Total Charges
BKST	Bookstore Charge	BIL	Y	37.00
T101	Tuition	TUI	Y	130.00
STU1	Student Union Campus 1	FEE	Y	15.00
S001	Student Service Fee	FEE	N	75.00
R100	Registration Fee	FEE	N	50.00	307.00

Review the assessment before the system applies any minimum or maximum rules from the Registration Fees Min/Max Charge Control Form (SFAFMAX).

The CRN (Course Reference Number) specifies the section for which a fee was assessed. Class discussion addresses what happens when the system applies a Minimum/Maximum rule.

To display the fees to be charged the student based on his/her registration, select Fee Assessment With Min/Max Applied from the Options menu.

Detail Code	Description	Type	Ref	Charge	CRN
BKST	Bookstore Charge	BIL	Y	37.00	10023
R100	Registration Fee	FEE	N	50.00
STU1	Student Union Campus 1	FEE	Y	15.00
S001	Student Service Fee	FEE	N	75.00
T101	Tuition	TUI	Y	150.00
T101	Tuition	TUI	Y	-30.00

Click Exit.

Access the Account Detail Review Form - Student (TSAAREV).

The identification number and name of the student should be in the Key block.

Perform a Next Block function to review the fees assessed.

Audit Registration Fee

The Registration Fee Assessment Audit Form (SFAFAUD) contains a student’s fee assessment and displays the calculations used to determine the fee assessment and refund amounts.

Banner form

Steps

Follow these steps to review the Registration Fee Assessment Audit Form (SFAFAUD).

Access the Registration Fee Assessment Audit Form (SFAFAUD).

Enter your student’s ID in the ID field.

Enter 200910 in the Term field.

Perform a Next Block function to review the assessments.

The lines with a number in the Account Transaction Number field are lines that caused a transaction to post to the student’s account. The Account Transaction Number corresponds with the Transaction Number on the Account Detail Review Form (TSAAREV).

Perform a Next Block function while on one of the records to see which rule and block on SFARGFE caused that detail code and amount to be assessed for the student.

Click the Exit icon.

Displaying Study Path Information

Banner Student Accounts Receivable forms can now display study paths. The study path sequence number is displayed when a study path is associated with a charge that has been generated by fee assessment. An indicator is used to turn the display on and off.

Study Path information can be viewed on these forms:

Account Detail Review Form (TSAAREV)

Student Billing Control Form (TSACTRL)

Student Account Detail Form (TSADETL)

Customer Service Inquiry Form (TSICSRV)

Student Payment Detail Query Form (TSIQACT)

Use the Display Study Paths checkbox on TSACTRL to control the display of the study path sequence number in Banner Student Accounts Receivable on the TSAAREV, TSADETL, and TSIQACT forms and in Banner Student Self-Service on the Account Detail for Term page.

You can view additional study path information on TSAAREV and TSADETL for the study path sequence number, such as:

valid study path values for the student for the term

the study path name for the current and active curriculum record for the student for the term

Note: If your institution is not at Banner Student version 8.3 or higher, the Banner Accounts Receivable 8.2 study path changes will not be available.

Process Exemptions

Introduction

The Exemption Authorization Form (TSAEXPT) is used to create exemption authorizations for student accounts by term. Each exemption authorization is established as an account level, category level, or detail code level exemption. At any level, the exemption is based on a percentage. A maximum amount to be paid by the exemption and a minimum amount to be paid by the student can be established. After the exemption is defined, students can be assigned to the exemption on this same form.

Steps

Follow these steps to create and post an exemption payment on a student’s account for tuition and fees.

Access the Exemption Authorization Form (TSAEXPT).

Enter a number in the Exemption Code field to create the exemption code.

Enter 200910 in the Term field.

Access the Exemption Base Information block.

Enter a Description for your exemption (i.e. 100% up to $50)

Enter a detail payment code in the Detail Payment Code field. List the available values by clicking on the down arrow which will pull up all detail codes. Query for a payment detail code (Type field = P) with EXM in the Category field. Return with the selected value (i.e. EXPT).

Click the Save icon.

Steps

Follow these steps to create an account authorization.

Select Create Account Authorization from the Options menu.

Enter the values from the following table in the Account Level Authorization block.

After entering these values, save the data.

Field	Value
Percent	100
Max Amt	50.00
Source	R

Note: This rule states that the exemption can pay up to $50 for any charges assessed through registration fee assessment.

Attaching a student

You must also attach a student (who has tuition/fee charges) to the exemption using the Person Assignment block of the TSAEXPT form or the Exemption Person Authorization Form (TSAEXPP) before the exemption can pay against the student’s account.

Steps

Follow these steps to add an exemption to a student on the Exemption Person Authorization Form (TSAEXPP).

Access the Exemption Person Authorization Form (TSAEXPP).

Enter the exemption code in the Exemption Code field you created in the previous exercise.

Enter the 200910 term in the Term field.

Perform a Next Block function.

Enter the student’s ID, with which you have been working, in the Student ID field.

Click the Save icon.

Click the Exit icon.

Steps

The instructor will review several other ways to set-up exemption authorizations.

Access the Student Payment Form (TSASPAY).

Enter 200910 in the Term field of the Key block.

Enter the student’s ID number in the Key block.

Perform a Next Block function.

Perform another Next Block function.

The Accept Charges/Payments pop up box may appear; click Return to ‘accept charges/credits’.

Note: If the Charges/Credits are accepted by clicking return, this sets the AR Indicator in registration and location management to Y for students. This was designed to allow the institution to choose whether or not to update the accept charges flag which is used in the Drop for Non-Payment process (SFRRNOP).

Notice the Exemption Payment in the Cashier Data block. The detail code is the code just entered as the Payment detail code on the Exemptions Authorization Form (TSAEXPT).

Select View Account Detail from the Options menu.

The student’s ID will default into the ID field in the Key block.

The top transaction should be the Payment detail code that was posted through TSASPAY. Notice that the source code is E for the Exemption module. Note the dollar amount of the transaction.

Click the Exit icon.

Click the Exit icon again.

Access the Account Review Form – Student (TSAACCT).

Perform a Next Block function from the Key block.

Select View Exemptions/Contracts from the Options menu. Notice that the contract appears in the Contracts block and the exemption appears in the Exemptions block.

Click the Exit icon.

Creating Detail Codes and Accounting

Introduction

In this section you will learn how to set up Accounts Receivable detail codes in Banner and associate them with accounting information.

Section Objectives

In this section you will learn how to

build student-related detail codes

use aid year accounting

use an aid year-based designators

use term-based accounting

use term-based designators

associate an effective date with an accounting distribution

change an existing set of accounting distribution values

change a detail code from term or aid year-based to non-term or aid year-based

change a detail code from non-term or aid year-based to term or aid year-based

change an existing set of term-based designator codes.

Build Student-Related Detail Codes

Introduction

Detail codes are the most important items linking the Accounts Receivable Module to the General Ledger. Each is defined as either a charge or a payment and contains the description that will appear on invoices and statements.

Priorities are established to determine to which charge a payment may be applied, and in what order payments may be applied for each detail code used in the Application of Payments Process (TGRAPPL). Also, default amounts and effective dates may be specified. Behind each detail code is an accounting distribution(s) and a series of Finance Rule Classes that determine the postings made to the General Ledger.

Individual Rule Classes handle original posting of Accounts Receivable transactions (payments and charges), details and netting of like types of codes (charges and negative charges; payments and negative payments) and unlike types of codes (payments liquidating charges).

Detail codes create the accounting transactions that are fed to the General Ledger through the interface process. As such, they must be thoroughly tested prior to entering production.

Build Student-related detail codes

Create new Student-related detail codes.

Steps

Follow these steps to complete the procedure.

Access the Detail Code Control Form – Student (TSADETC).

Move through the fields, reviewing the comments on the Auto Help line at the bottom of the form for each element.

Insert a new record.

A highlighted blank record block will appear.

Enter the following information in the appropriate fields:

Field	Value
Detail Code	LIBx (where x is your initial)
Description	Library Fine
Type	C
Category	BIL
Priority	799
Pay Type	N
Refundable	Leave Blank

Click Save.

Select Create GL Interface from the Options menu. On this form, you will enter the General Ledger account distribution for the detail code.

Click the Term-Based or Aid Year-Based check box if this detail code is term or aid year-based.

Perform a Next Block function to enter the General Ledger Interface to Banner Finance block and enter the following data elements by following the steps below to complete the process:

Note: If you have Banner Finance, the account string is linked and validated to Banner Finance.

Non-Finance clients enter accounting information in a 60-character free-form field.

Account A Field	Value
COA	B
Rule Class 1	CHS1
Rule Class 2	APS2
Rule Class 3	APS1

Account B Field	Value
COA	B
Rule Class 1	CHS1
Rule Class 2	APS2
Rule Class 3	APS1

Note: The Finance consultant or the Finance department staff of your institution will provide the FOAPAL information.

Enter 100 in the Percent field.

For Account A, enter B in the COA field, and use the scroll bar to Access the Rule Class fields. Enter CHS1 in the Rule Class 1 field, APS2 in the Rule Class 2 field, and APS 1 in the Rule Class 3 field.

Repeat this step for Account B with the same values.

Click Save.

Select Create Detail Code Control from the Options menu to return to the main window of TSADETC.

Perform queries

Perform queries based on the selection fields.

Enter a query in the Category field for all detail codes that have a category of BIL.

Repeat the previous step using a category of FEE to locate all the Registration Fee detail codes.

Search for all detail codes that begin with an L by querying for L% in the Detail Code field.

Find the detail code for a Library charge. Access the Description field and query for %Libr% to select all codes with the word Libr in their descriptions.

Note: The Description field is case-sensitive when querying.

Click Exit.

GL Interface window – Banner Finance not installed

The GL Interface window of the Detail Code Control Form – Student (TSADETC) will appear slightly different if you do not have Banner Finance installed. Note that the account string is a free-format, 60-character string and is not validated.

Steps

Follow these steps to enter general ledger account distribution information if Banner Finance is not installed.

Access the Detail Code Control Form - Student (TSADETC).

Select Create GL Interface from the Options menu. On this form, you will enter the General Ledger account distribution for the detail code.

Note: The Finance consultant or the Finance department staff of your institution will provide this information.

Perform a Next Block function.

Enter 100 in the Percent field.

Enter the appropriate 60-character string in the Account A and Account B fields.

Repeat this step for Account B with the same values.

Click Save.

Select Create Detail Code Control from the Options menu to return to the main window of TSADETC.

Steps

Follow these steps to build a payment detail code.

Perform an Insert Record function to open a blank detail code record.

Enter a new Payment Detail Code.

Enter an appropriate description for the Payment detail code.

Enter P for Payment in the Type field.

Enter CSH in the Category field.

Enter 000 in the Priority field to indicate that this payment can be applied to any charge.

Access the Pay Type field. Click the Search icon to view a list of valid payment type validation codes. Select C (Cash Type Payment).

The Refundable check box should be selected if this detail code could create a credit balance on an account that should be refunded by the system in the Auto Refund Credit Amt Process (TSRRFND).

Leave the Refund Code drop-down box unselected. Codes in this drop-down box should be used only if the detail code defined is the one used to generate a refund check to the student in the Accounting Feed Process (TGRFEED).

Leave the GL Enterable check box unselected. Only select this check box when accounting distribution information can be overridden for miscellaneous transactions on the Miscellaneous Transaction Form – Finance (TFAMISC).

Select the Receipt check box to specify that a receipt number should be generated whenever this detail code is entered on an account.

Access the Amount field.

Enter an amount only if the detail code is usually entered on an account for the same amount each time.

(Note: this is a default value.)

Access the Effective Date field.

Enter a date only if the detail code usually has the same effective date when entered on an account.

(Note: this is a default value.)

Click Save.

Select Create GL Interface from the Options menu.

On this form, you will enter the General Ledger account distribution for the detail code.

Enter 100 in the Percent field.

For Account A, enter B in the COA field and use the scroll bar to Access the Rule Class fields. Enter CHS1 in the Rule Class 1 field, APS2 in the Rule Class 2 field, and APS 1 in the Rule Class 3 field. Repeat this step for Account B.

Click Save.

Click Exit.

Aid Year-based Accounting

Institutions can create aid year-based detail codes and feed aid to specified accounts, depending on whether the aid is being posted against a prior, current or future aid year. Aid year-specific accounting information can be fed to the Banner Finance System or another Finance system.

The use of aid year-based detail codes is optional, so only those detail codes that require aid year-specific accounting need to be designated as aid year-based, and an institution may continue to specify detail codes as non-term/non-aid year-based or as term-based. Changing a detail code to an aid year-based detail code does not affect any other rules associated with a detail code.

Set Up Procedures for aid year-based Accounting

Follow these steps to set up aid year-based accounting.

Create designator codes on the Aid Year-Based Designator Validation Form (TTVABDS). These values should be used for prior, current or future aid years. The two-character designator can be any unique code you choose.

Create Financial Aid year codes. For Banner Financial Aid clients, create Financial Aid year codes on the Institution Financial Aid Options Form (ROAINST).

Note: Aid year-based accounting requires that aid year codes be numeric and sequential.

For Non-Banner Financial Aid clients, create Financial Aid year codes on the Aid Year Validation Form (TTVAIDY).

Note: Aid year-based accounting requires that aid year codes be numeric and sequential.

Create the relationship between the aid year codes and the designator codes using the Aid Year Based Designator Rules Form (TSAABDS).

Enter the aid year-based designator rules on the form. Then Define aid year code values as associated with prior, current or future aid years.

Note: For Banner Financial Aid clients, the aid year code is validated against ROBINST. For Non-Banner Financial Aid clients, the aid year code is validated against TTVAIDY.

Create new detail codes for aid year-based use on the Detail Code Control Form (TSADETC).

Select the Aid Year-based check box on the GL BANNER Interface Window.

Associate the appropriate designator codes with the corresponding accounting distributions in the GL BANNER Interface window.

Use the (Aid Year-Based) Designator field to enter the code.

Note: Valid values are available on the Aid Year-Based Designator Validation Form (TTVABDS).

Run the Accounting Feed Process (TGRFEED) to feed activity for aid year-based detail transactions to Banner Finance or to a Non-Banner Finance system.

Reset the aid year code rules on the Aid Year Based Designator Rules Form (TSAABDS) for each year or aid year as needed.

Aid Year-Based Designator Validation Form

This form is used to set up aid year-based designator codes. These codes are validated on the Aid Year Based Designator Code field on the Aid Year-Based Designator Rules form (TSAABDS) and on the Detail Code Control Form (TSADETC).

The codes entered on this form may be whatever an institution wants to use, to identify the aid year for accounting purposes. These codes are used when rules are built to establish a relationship between the designator, the aid year, and detail codes.

After a designator code is created on TTVABDS, use the Aid Year-Based Designator Rules Form (TSAABDS) to assign an aid year to each designator code. Then use the Detail Code Control Form (TSADETC) to establish the relationship of the designator code to a detail code.

Banner form

Steps

Follow these steps to add a designator code to the Aid Year-Based Designator Validation Form (TTVABDS).

Access the Aid Year-Based Designator Validation Form (TTVABDS).

Click the Insert Record icon.

Click in the empty Code field on the newly inserted record.

Create an aid year-based designator code. It may be any unique two character combination. Enter this code in the Code field.

Enter the Aid Year-based designator code description in the Description field.

Observe the User ID field. It is a display only field, and is blank until the record is saved. Once the record is saved, this field displays the User ID of the user who last changed the record.

Observe the Activity Date field. It is a display only field, and is blank until the record is saved. Once the record is saved, it displays the date and time this record was last changed.

Click the Save icon to save the newly created aid year-based designator code.

Click the Exit icon.

Aid Year-Based Designator Rule Form

This form is used to set up aid year-based designator code rules to establish the relationship between aid year codes and aid year-based designators. This form allows a history of changes to the aid year-based designtors to be stored in the database and displayed on this form. All designator codes that appear on the form at one time belong to a set associated with one effective date.

Banner form

Steps

Follow these steps to make a change to a set of designators on the Aid Year-Based Designator Rule Form (TSAABDS).

Access the Aid Year-Based Designator Rule Form (TSAABDS).

Click the Next Record icon.

Observe the Effective Date field. This is the date on which the designator rule codes become effective. The default is the system date. It can be changed.

Observe the Next Change Date field. This displays the date on which the user changed the designator code set.

Note: When you create a set for the first time, the default value for this field is the end of time (31-DEC-2099).

Note: The set of records with the greatest effective date will appear initially. To view prior dated records, perform a Previous Record function. To create a new effective-dated record, perform a Next Record function.

Click the Next Block icon to access the Rules block.

Note: The Copy option can be used to copy the original set of designator code information forward to a new effective date. Use the Options menu to access the copy function.

Enter a code into the Aid Year-Based Designator Code field. Values in this field are validated against TTVABDS.

Observe the contents of the Description field. This defaults from the setting on TTVABDS.

Set the Primary Operator. This setting indicates the relationship between the aid year code and the aid year-based designator. Valid values are =, > and <.

Enter the aid year code into the Aid Year field.

Enter the Secondary Operator. This setting indicates the relationship of the suffix to the Aid Year field and the term code.

Enter the Suffix. This is the last two digits of the term code, and allows diferent terms within an aid year to be designated to separate accounting distributions.

Observe the Activity Date field. This field is blank until the record is saved. It then displays the day and time that the record was last modified. This field cannot be changed.

Aid Year Validation Form

This form is used by Non-Banner Financial Aid clients to establish Aid Years to be used when creating Aid Year-based designator rules on TSAABDS. This form is accessible only if Banner Financial Aid is not installed at your site. Note: Aid year-based accounting requires that aid year codes be numeric and sequential.

Banner form

Steps

Follow these steps to create a new Aid Year code.

Access the Aid Year Validation Form (TTVAIDY).

Enter the aid year code into the Code field.

Enter the description of the aid year code into the Description field.

Enter the official start date of the aid year into the Start Date field.

Observe the setting of the User ID field. This field is blank until the record has been saved. It then displays the ID of the user who last modified this code. This field cannot be changed.

Observe the setting of the Activity Date field. This field is blank until the record has been saved. It then displays the date this code was last modified. This field cannot be changed.

Click the Save icon.

Click the Exit icon.

Term-based Accounting

Institutions can create term-based detail codes and feed aid to specified accounts, depending on whether the aid is being posted against prior, current or future term. Term-specific accounting information can be fed to the Banner Finance System or another Finance system.

The use of term-based detail codes is optional, so only those detail codes that require term-specific accounting need to be designated as term-based, and an institution may continue to specify detail codes as non-term/non-aid year-based or as aid year-based. Changing a detail code to a term-based detail code does not affect any other rules associated with a detail code.

Set Up Procedures for term-based Accounting

Follow these steps to set up term-based accounting.

Create designator codes on the Term-Based Designator Validation Form (TTVTBDS). These values should be used for prior, current or future terms. The two-character designator can be any unique code you choose.

Create the relationship between the term codes and the designator codes using the Term-Based Designator Rules Form (TSATBDS).

Assign a default designator code on the Student Billing Control Form (TSACTRL). Valid values are available on the Term-based Designator Validation Form (TTVBDS).

Create new detail codes for term-based use on the Detail Code Control Form (TSADETC).

Select the Term-based check box on the GL BANNER Interface Window.

Associate the appropriate designator codes with the corresponding accounting distributions in the GL BANNER Interface or GL Interface window of TSADETC.

Use the (Term-Based) Designator field to enter the code.

Note: Valid values are available on the Term-Based Designator Validation Form (TTVTBDS).

Run the Accounting Feed Process (TGRFEED) to feed activity for term-based and aid year-based detail transactions to Banner Finance or to a Non-Banner Finance system.

Reset the term code rules on the Term-Based Designator Rules Form (TSATBDS) for each year, term or as needed.

Build Term-Based Designators

Introduction

Build the term-based designators to be used to define the term-based rules that will be attached to detail codes to make them term-based detail codes.

The designator code is a two-digit code that links to a term code. During application of payments the process checks the term code on the transaction and uses the designator for the term attached to the transaction.

The designator allows the control of accounts that are debited and credited based on the term of the transaction. For example, when students register in April for next Fall, the designator then marks the transaction as future effective dated.

Steps

Follow these steps to complete the process.

Access the Term-Based Designator Validation Form (TTVTBDS).

Enter the following codes in the form:

Code Description

CF Current Spring

CS Current Fall

CU Current Summer

PY Prior Year

FY Future Year

Click Save.

Steps

Follow these steps to complete the process.

Access the Term-Based Designator Rules Form (TSATBDS).

Enter the following codes in the form:

Code Primary Operator Term

CF	=	200910

CS	=	200920

CU	=	200930

PY	<	200910

FY	>	200930

Use Secondary Operator to set the condition so two designator codes can be used for future or prior activity. For example, if the designator is greater than 200910, the secondary operator could be set to equal all term codes ending in 20. Then if another designator is greater than 200910, its secondary operator could be set to not equal any term codes ending in 20.

Note: These values will need to be changed as the terms changes and registration activity occurs whether or not you use secondary operators. If you choose to use term-based detail codes you will need to decide how many designators will be required and will need to create new rules starting the first day of each fiscal year.

Click Save.

Steps

Follow these steps to complete the process.

Access the Detail Code Control Form - Student (TSADETC)

Choose an existing detail code or create a new detail code that will be term based.

Select Create GL Interface from the Options menu.

On this form, you will enter the General Ledger account distribution for the detail code.

Place your cursor in the Effective Date field and perform an Insert Record function to populate today's date into the field.

Select the Term-based check box.

Enter the code CF in the Designator field.

Enter 100 in the Percent field.

For Account A, enter B in the COA field and use the scroll bar to Access the Rule Class fields. Enter CHS1 in the Rule Class 1 field, APS2 in the Rule Class 2 field, and APS 1 in the Rule Class 3 field. Repeat this step for Account B.

Use your cursor to move to the next line and enter the code CS in the Designator field.

For Account A, enter B in the COA field and use the scroll bar to Access the Rule Class fields. Enter CHS1 in the Rule Class 1 field, APS2 in the Rule Class 2 field, and APS 1 in the Rule Class 3 field. Repeat this step for Account B.

Use your cursor to move to the next line and enter the code CU in the Designator field.

For Account A, enter B in the COA field and use the scroll bar to Access the Rule Class fields. Enter CHS1 in the Rule Class 1 field, APS2 in the Rule Class 2 field, and APS 1 in the Rule Class 3 field. Repeat this step for Account B.

Use your cursor to move to the next line and enter the code PY in the Designator field.

For Account A, enter B in the COA field and use the scroll bar to Access the Rule Class fields. Enter CHS1 in the Rule Class 1 field, APS2 in the Rule Class 2 field, and APS 1 in the Rule Class 3 field. Repeat this step for Account B.

Use your cursor to move to the next line and enter the code FY in the Designator field.

For Account A, enter B in the COA field and use the scroll bar to Access the Rule Class fields. Enter CHS1 in the Rule Class 1 field, APS2 in the Rule Class 2 field, and APS 1 in the Rule Class 3 field. Repeat this step for Account B.

Click the Save icon.

Associate an Effective Date with an Accounting Distribution

Introduction

Use this process to create new term-based detail codes.

Banner Form

Steps

Access the Detail Code Control Form (TSADETC).

Enter the required information and any optional information for the detail code on the Main window of the Detail Code Control Form (TSADETC)

Go to the GL Interface window. The effective date defaults to the current date.

Note: You can change this date to a prior date, but you cannot use a future date.

Select the Term-based check box.

Enter the desired values in the accounting distribution fields, or copy the values using the Copy feature. To use the Copy feature, select Copy from the Options menu.

Make your desired updates to the fields you wish to change.

Click the Save icon.

Click the Exit icon.

Change an Existing Set of Accounting Distribution Values

Introduction

Follow these steps to modify an existing set of Accounting Distribution Values

Banner Form

Steps

Select a detail code on the Main win dow of the Detail Code Control Form (TSADETC).

Click the Next Block icon.

In the Header block of the GL Interface window, click the Insert Record icon.

Note: the effective date defaults to the current date.

Note: The effective date must be set to the current date. You cannot use a prior or future date.

Click the Next Block icon.

The Copy window will appear. You can either enter a detail code from which to copy information (the default value for this field is the current detail code, but you can change that field), or you can select Cancel from the Options menu to close the Copy window and manually enter the accounting information.

Make whatever changes are necessary to the fields in this window.

Click the Save icon.

Change a Detail Code from Term or Aid Year-based to Non-Term or Aid Year-based

Introduction

Follow these steps to change a detail code from a Term-based code to a Non-Term-based code.

Banner Form

Steps

Access the Detail Code Control Form (TSADETC).

Click on the term-based detail code you wish to change.

Click the Next Block icon.

In the GL Interface Window, click the Next Record icon.

Note: the effective date defaults to the current date.

Note: The effective date must be set to the current date. You cannot use a prior or a future date.

Clear the Term-based or Aid Year-based check box by clicking it.

Click the Next Block icon.

Enter the new accounting distribution set.

Note: You can copy accounting distribution information from another detail code, as long as it is non-term-based. You cannot copy information from a detail code that is designated as term-based to a detail code that is non-term-based.

Modify the accounting distribution set as you need.

Click the Save icon.

Click the Exit icon.

Change a Detail Code from Non-Term or Aid Year-based to Term or Aid Year-based

Introduction

Follow these steps to create a term-based detail code from a non-term-based detail code.

Banner Form

Steps

Access the Detail Code Control Form (TSADETC).

Select the non-term-based detail code on this form by clicking it.

Click the Next Block icon.

In the Header Block of the GL BANNER Interface window, click the Next Record function.

Note: The effective date defaults to the current date.

Note: The effective date must be set to the current date. You cannot use a prior or a future date.

Select the Term-based or Aid Year-based check box.

Click the Next Block icon.

Enter the new accounting distribution set.

Note: You can enter new information or copy existing information. If you copy the accounting information from the current detail code (which is non-term-based), you must also enter designator codes.

Make any modifications to the information that you wish.

Click the Save icon.

Click the Exit icon.

Change an Existing Set of Term-based Designator Codes

Introduction

The information on the Term-Based Designator Rules Form (TSATBDS) allows a history of changes to the term-based designators. At the end of the fiscal year, follow this recommended procedure for updating the form.

Banner Form

Steps

Access the Term-Based Designator Rules Form (TSATBDS).

To enter a new set of Designators, click the Next Record icon, or enter the effective date of the new set into the Effective Date field.

Click the Next Block icon.

Copy the set from the existing set.

Make the modifications you wish for the new set.

Click the Save icon.

Click the Exit icon.

Managing Billing and Late Fees

Introduction

The Student Invoice/Billing Statement Process (TSRCBIL) produces a multiple page invoice/statement. It can also produce a schedule/bill document. A schedule/bill is a combination of a student's schedule of classes and an invoice of charges and credits.

There are three steps required to produce a schedule/bill:

Create Schedule/Bill Rule Codes (TTVSBRC)

Set up the schedule/bill parameters on the Schedule/Bill Rules Form (TSASBRL)

Run the Student Invoice/Billing Process (TSRCBIL) to produce a schedule/bill.

The Third Party Invoice/Billing Statement Process (TSRTBIL) produces a multiple page invoice/statement. An Invoice/bill can be a combination of a student's schedule of classes and the invoice/bill of charges and credits.

There are three steps required to produce a third party bill:

Create appropriate codes on the Third Party Rules Code Validation Form (TTVTPRC).

Set up the invoice/bill parameters on the Third Party Billing Rules Form (TSATPRL).

Run the Third Party Invoice/Billing Statement (TSRTBIL) to produce an invoice/bill.

Objectives

In this section you will learn how to:

review the Schedule/Bill Rules Form

review the Third Party Billing Rules Form

process Third-Party contracts.

Review the Schedule/Bill Rules Form

Introduction

The Student Invoice/Billing Statement Process (TSRCBIL) produces a multiple page invoice/statement. It can also produce a schedule/bill document. A schedule/bill is a combination of a student's schedule of classes and an invoice of charges and credits.

There are three steps required to produce a schedule/bill:

Create Schedule/Bill Rule Codes (TTVSBRC)

Set up the schedule/bill parameters on the Schedule/Bill Rules Form (TSASBRL)

Run the Student Invoice/Billing Process (TSRCBIL) to produce a schedule/bill.

The Schedule/Bill process consists of two types of parameters: rules parameters and run-time parameters. The rules parameters are those parameters that would probably remain static for each generation of schedule/bills. The Minimum Account Balance parameter, the Detail Codes to Bill parameter, and the Include zero balances parameter are a few examples of rules parameters.

In reviewing TSRCBIL, parameters titled Charge Selection, Charge Summarization and Payment Summarization are not in the list. They are part of the rules found on TSASBRL. The run-time parameters are those parameters that may change for each execution of the schedule/bills. TERM, ID, and the POPULATION SELECTION parameters are examples of run-time parameters.

Schedule/Bill Rules Form (TSASBRL)

The purpose for the Schedule/Bill Rules Form (TSASBRL) is twofold. It enables you to enter the schedule/bill parameters once, eliminating the need to enter a large number of parameters each time schedule/bills are produced. Additionally, parameters that reside on the Schedule/Bill Rules Form (TSASBRL) may be secured.

The key to the Schedule/Bill Rules Form is the schedule/bill rule code. The schedule/bill rule code is defined on the Schedule/Bill Rules Code Validation Form (TTVSBRC). A rules code should be defined for each set of schedule/bill parameters required by the institution.

The schedule/bill rules consist of the following data:

Who gets a schedule/bill

What items and item headings appear in the schedule portion

What appears in the bill portion and how is it displayed

Messages

Who gets a schedule/bill

The system determines who gets a schedule/bill using the parameters entered when submitting the Student Invoice/Billing Statement Process (TSRCBIL) in conjunction with the data input on the Schedule/Bill Rules Form (TSASBRL).

A schedule/bill can be produced for an individual or for a group of students. The run-time parameters determine which student(s) are/are not to be screened by the selection criteria.

To produce a schedule/bill for an individual, you must run the Student Invoice/Billing Statement Process (TSRCBIL) and provide a valid ID when prompted for the ID parameter. To produce a schedule/bill for a group of students, you must run the Student Invoice/Billing Statement Process (TSRCBIL) in COLLECTOR mode, MASS mode, or POPULATION SELECTION mode.

To run in COLLECTOR mode, you must type the word ‘COLLECTOR’ when prompted for the ID parameter. Leave all of the population selection (Selection Identifier, Application Code, and Creator ID) parameters blank.

To run in MASS mode, you must leave the ID and population selection (Selection Identifier, Application Code, and Creator ID) parameters blank.

To run in POPULATION SELECTION mode, you must provide a valid population defined by entering the Selection Identifier, Application Code, and Creator ID, and you must leave the ID parameter blank.

On the Schedule/Bill Rules Form, you may either define student selection rules or provide a population for which a schedule/bill should be produced. Selection rules are never applied when running for an individual or in COLLECTOR mode. If you choose to define selection rules and provide a population or run the process in MASS mode, the group of students selected must be registered for the term. These students will then be screened by the selection rules.

Selection rule components

Four items make up the selection rules:

Exclude Students Not Allowed to Register
Select this check box to exclude any student whose enrollment status prevents them from registering for the term (i.e., Prevent Registration is selected on the Enrollment Status Code Validation Form (STVESTS)).

Exclude Students Who Do Not Count in Enrollment
Select this check box to exclude any student whose enrollment status causes no effect on the headcount of the student population for the term (i.e., the Affect Headcount check box is cleared on the Enrollment Status Code Validation Form (STVESTS)).

Course Required
Select this check box to include only students who are registered for at least one course with a status that is eligible to print on the schedule/bill document (i.e., Print is selected on the Course Registration Status Code Validation Form (STVRSTS)).

Account Billable
Select this check box to include only students whose accounts are eligible to be billed (i.e., Bill Code is null on the Account Detail Review Form (TSAACCT)).

All selection criteria must be satisfied in order for a schedule/bill to be produced.

If you choose to provide a population and not define selection rules, a schedule/bill will be produced for those students in that population. (A population must have been provided via run-time parameters or the job will abort.) If a student within that population has no classes for the term, the schedule of classes will be absent from the schedule/bill document. If a student within that population has no charges or credits for the term, then the invoice of charges and credits will be absent from the schedule/bill document.

What items and item headings appear in the schedule portion

On the Schedule/Bill Rules Form (TSASBRL), you can indicate which data items will appear in the schedule portion. The available items are as follows:

Part of Term	Course Level

Course Reference Number (CRN)	Course Status

Subject	Meeting Days

Course	Meeting Times

Section	Building

Campus	Room

Title	Instructor(s)

Credits	Grading Mode

To select a data item, select the corresponding check box. You can display an abbreviated course title and/or instructor name via a pull-down list. You must also provide the item heading. An error message will appear if the items selected exceed the allowable line width.

The allowable line width checked by Banner is 132 characters. Determine the allowable line width at your institution based on your printer and the pitch/font used for printing. If more items are selected than can be accommodated by your printer and pitch/font combination, printing difficulties may result.

What appears in the bill portion and how it is displayed

The following parameters entered on the Schedule/Bill Rules Form (TSASBRL) determine what the bill portion of the schedule/bill should look like:

Parameter	Description
Print Financial Aid Memos	Select this check box to display Financial Aid memos on the schedule/bill. For enrollement period schedule/bill outputs, financial aid memos print if the term matches a term in the student’s enrollment period. For stnadard (non-enrollment period) schedule/bill outputs, financial aid memos print if the term matches the run term (Term) parameter.
Print Contract and Exemption Memos	Select this check box to display contract and exemption memos on the schedule/bill.
Print Deposits	Select this check box to display deposits on the schedule/bill. Clear this check box if you do not want deposits to display on the schedule/bill.
Print Note on Enrollment Period bill indicating terms included in Enrollment Period.	Select this check box to print a note describing the terms that are part of the enrollment period. This option is only relevant on enrollment period schedule/bill outputs.
Summarize Financial Aid Memos	Select this check box to display the total of the financial aid memos. Clear this check box if you wish to display each financial aid memo for the term.
Financial Aid Memos Affect Amount Due	Select this check box to have financial aid memos reduce amount due. Clear this check box to ensure that financial aid memos do not reduce amount due.
Pre-authorized Memos Affect Amount Due	Select this check box to have pre-authorized contract memos reduce amount due. Clear this check box to ensure that contract memos do not reduce amount due.
Enrollment Period Aid offsets Previous Balance first	Select this check box if you want enrollment period aid to offset a previous balance debit amount before offsetting current enrollment period term balances. This option is only relevant on enrollment period schedule/bill outputs.
Current Credit Balance Apply to Previous Debit Balance	Select this check box to have a current credit balance apply to a previous debit balance, thereby reducing amount due. Clear this check box to specify that a current credit balance may not apply to a previous debit balance. For example: Previous Balance = 125.00 Current Term Balance = -75.00 If the check box is selected, Amount Due = 50.00; if cleared, Amount Due = 125.00. There is no parameter to control the reverse (i.e., a current debit balance would apply to a previous credit balance).
Current Due Cutoff Date	This date is used to determine which items comprise current due, which items comprise previous balance, and which items comprise future balance. All information is displayed based on term, but this parameter determines whether items are current due, past due, or future due. If not entered, this parameter defaults to the schedule/bill run date.
Select Term Charges	Using a pull-down list, term charges may be selected by CATEGORY, SOURCE, or ALL. When selecting by category, you must provide categories to select. When selecting by source, you must provide source codes to select.
Summarize Term Charges	Using a pull-down list, term charges may be summarized by DETAIL CODE, CATEGORY, SOURCE, or TOTAL. This parameter controls how charges are displayed.
Summarize Payments	This parameter controls how payments are displayed. Using a pull-down list, payments may be summarized by DETAIL CODE, CATEGORY, or TOTAL. You also may display each payment for the term (i.e., no summarization).
Currency Code	To display dollar amounts in a currency other than base currency, enter a valid currency code from the Currency Code Validation Form (GTVCURR).
Print Order	Using a pull-down list, select the schedule/bill print order (ID, Name, Zip/ID, Zip/Name).

Enrollment Period Dates by Term

This section should be populated if you combine multiple terms into into a single enrollment period and want to establish different Cutoff Dates and Due Dates for the terms in the enrollment period. The dates in this section are only used for schedule/bills printed in the enrollment period format.

Parameter	Description
Term Code	LOV with validation to STVTERM (term code validation). Press LIST for valid codes. This field is optional.
Cutoff Date	The date used to determine which transactions are current based on the effective date. If Term Code is entered, cutoff date is required.
Due Date	Date used for enrollment period schedule/bills, and to update the due date of the transaction. This field is optional.

Messages

You may enter messages to be displayed on the schedule/bill document on the Schedule/Bill Rules Form (TSASBRL). The messages will display immediately following the billing information. An unlimited number of messages may be displayed; however, remember space considerations when supplying messages. If Schedule Bill rules are not used, messages can be added to the bill using TGAMESG.

The Student Invoice/Billing Statement Process (TSRCBIL)

You will be prompted for the following parameters to run the Student Invoice/Billing Statement Process (TSRCBIL):

Run Sequence Number

Term

Address Selection Date

Address Hierarchy

ID

Printer

Selection Identifier

Application Code

Creator ID

Run in Sleep/Wake Mode

Sleep Interval

Number of Printed Lines Per Page (not used for schedule/bill processing)

You will then be prompted for the following:

Parameter	Description
Produce Schedule/Bill	If Y (Yes), you will be prompted for additional parameters: TERM TYPE, CAMPUS, SCHEDULE/BILL DUE DATE, and STATEMENT DATE. Parameter prompting will then cease, and the rest of the parameters required to produce a schedule/bill will be obtained from the Schedule/Bill Rules Form (TSASBRL). If N (No), you will be prompted for the rest of the parameters necessary to run the Student Invoice/Billing Statement Process (TSRCBIL) (i.e., the current SunGard Higher Education invoice/statement will be produced).
Schedule/Bill Rules Code	Enter a valid schedule/bill rules code from the Schedule/Bill Rules Code Validation Form (TTVSBRC). This rules code is used to access the rules defined on the Schedule/Bill Rules Form (TSASBRL).
Campus	Campus is a repeating parameter. Enter a valid campus or campuses from the Campus Validation Form (STVCAMP). A schedule/bill will be produced for those students whose curriculum campus meets all the selection criteria at the specified campus or campuses. If % is entered, all campuses will be processed.
Schedule/Bill Due Date	Enter the date the student's payment is due.
Statement Date	Enter the date to be printed in the heading. When the Student Invoice/Billing Statement Process (TSRCBIL) is run via Job Submission, rules parameter information will be obtained from the Schedule/Bill Rules Form (TSASBRL), not from the Process Submission Controls Form (GJAPCTL). The help text on the PRODUCE SCHEDULE/BILL parameter on GJAPCTL will convey this fact.

Additional parameters

When producing schedule/bills via job submission, it is still necessary to enter a value for the following parameters, but they will be ignored:

Run Mode	Due Date

Currency Code	Minimum Account Balance

Contract, Deposits, Expt Indicator	Detail Codes to Bill

Financial Aid Indicator	Accounts

Print Future Detail Indicator	Print Other Memos

Futures Print Date	Do You Want Deposits Printed

Print Order	Preauth Credits Affect Amt Due

About the Schedule/Bill Document

The schedule and bill portions of the document are considered floating in that each does not reside in a pre-defined area of the document. The entire student schedule will print followed by the student's entire invoice of charges and credits. Normal page break logic is employed. A continuation message signals the existence of subsequent documents.

The document can be printed on either an 8 1/2” x 11" sheet of paper or institution letterhead and stuffed into a #10 window envelope or on a pre-printed mailer. The schedule portion displays the student's schedule of classes as defined by the data elements selected on the Schedule/Bill Rules Form (TSASBRL). The bill portion of the schedule/bill is divided into two regions. Charges are displayed in one region. Payments/Anticipated Credits are displayed in the other region.

The Charges region holds charges for the parameter term (i.e., account detail items where the type indicator of the detail code = C). Keep in mind that charges are displayed according to the CHARGE SELECTION parameter, the CHARGE SUMMARIZATION parameter, and the TERM parameter. Whether a charge is due, is determined by comparing the effective date of the charge to the CURRENT DUE CUTOFF DATE parameter. A charge for the term that is not yet due is denoted by an asterisk (*).

Payments/ Anticipated Credits

The Payments/Anticipated Credits region is comprised of the following:

Payment-type account detail items (i.e., the type indicator of the detail code = P)

Deposits (when the Print Deposits check box is selected on the Schedule/Bill Rules Form (TSASBRL))

Contract/exemption (when the Process Contracts, Deposits, Exemptions check box is selected on the Schedule/Bill Rules Form (TSASBRL))

Financial Aid memos

Financial Aid authorizations.

Some items that display in the Payments/Anticipated Credits section may not affect amount due based on the value of the PRE-AUTHORIZED MEMOS AFFECT AMOUNT DUE parameter, FINANCIAL AID MEMOS AFFECT AMOUNT DUE, and the COMMITTED/AUTHORIZED FINANCIAL AID indicator on the Student Billing Control Form (TSACTRL).

Items that appear in the Payments/Anticipated Credits section that do not affect amount due are denoted by an asterisk (*).

Bottom section

Student Name, Student ID, Campus, Previous Balance, Current Term Balance, Amount Due, and Future Balance appear in the bottom section of the schedule/bill. Student Name, Student ID, Term, and Amount Due appear on the remittance stub.

Previous Balance is the sum of charges minus sum of payments where the effective date of the charge is less than or equal to the current due cutoff date.

Current Term Balance is the sum of term charges due minus payments/anticipated credits that affect amount due (i.e. sum of non-asterisk (*) charges minus the sum of non-asterisk (*) payments.

Amount Due is the sum of current term balance and previous balance.

Future Balance is the sum of charges due, minus the sum of payments where the effective date of the item is greater than the current due cutoff date.

If the current term balance is a credit balance, and the CURRENT CREDIT BALANCE APPLY TO PREVIOUS DEBIT BALANCE parameter is not selected on the Schedule/Bill Rules Form (TSASBRL), amount due would be the same as previous balance.

The messages on the schedule/bill will display immediately following the billing information. An unlimited number of messages may be displayed; however, you should be aware of the space considerations when supplying messages. Items denoted by an asterisk (*) cause an additional message line to be generated. The message explains the significance of the “*”.

Steps

Review the set-up of the Schedule/Bill parameters used in the billing portion of the Schedule/Bill document.

Access the Schedule/Bill Rules Code Validation Form (TTVSBRC).

This form lists valid rules codes. Make a note of one of them that may apply to your student (for example, SBIL (Student Bills).

Click the Exit icon.

Access the Schedule/Bill Rules Form (TSASBRL).

Enter the rules code you chose from TTVSBRC in the Rules Code field.

Perform a Next Block function.

The Use Selection Criteria field should be populated with the default value (Y – Build Student Selection Rules).

Select Create Student Selection/Print Options from the Options menu. Review the information.

Select Schedule Item Selection from the Options menu.

Review the options that are available to print on the document. Notice that the number in the Total Length field (in the upper right corner of the form) adjusts to reflect the total number of characters to be displayed.

Select Create Bill Selection Parameters from the Options menu.

Review the options that are available for processing and review with the instructor.

Select Create Billing Messages from the Options menu. Notice that this is a free-form message block.

As you move between the blocks of this form, the options in the Options menu change to the options that are available for each block.

Click Exit.

Review the Third Party Billing Rules Form

Introduction

The Third Party Invoice/Billing Statement Process (TSRTBIL) produces a multiple page invoice/statement. An Invoice/bill can be a combination of a student's schedule of classes and the invoice/bill of charges and credits.

There are three steps required to produce a third party bill:

Create appropriate codes on the Third Party Rules Code Validation Form (TTVTPRC).

Set up the invoice/bill parameters on the Third Party Billing Rules Form (TSATPRL).

Run the Third Party Invoice/Billing Statement (TSRTBIL) to produce an invoice/bill.

Enter data for parameters on TSRTBIL and run in one of the following modes:

INVOICING – simulates a bill but does not update the account or begin aging.

STATEMENT – processes credits and payments and updates the bill date, due date, statement date, and invoice number fields on the account. The aging process begins and a statement is generated.

APPLYCRED – processes credits and payments and updates the account. It does not update the account as billed and no statement is generated.

Third Party Rules Form (TSATPRL)

The Third Party Rules Form (TSATPRL) is used to define the rules that will determine how Banner prints the third party bills, and to establish the relationship between a third party rule code and how Banner will print the bills that use that rule code. A rule code must be established on the Third Party Rules Code Validation Form (TTVTPRC) prior to using it on this form.

An invoice of items not previously billed may be produced, either for an individual third party account or for all third parties via the batch process Third Party Invoice/Billing Statement (TSRTBIL). An invoice may be not requested online for a third party. The request of an invoice will not update a third party account as being billed; therefore, charges and payments will be billed in detail when a bill is requested in Statement mode. No aging of invoiced charges occurs.

When a third party statement is requested, the account’s bill date, due date, and statement date are updated, and the aging of charges billed begins. All charges and payments are billed in detail once. Transactions with “ARTERM” are reported separately under the “Contractor Activity” section of the report. Any outstanding charges at the next billing cycle which have not been previously paid and have a due date prior to the billing date will be reflected as being past due.

The Assess Penalty/Interest Charges Report (TSRLATE) should be run prior to bills to ensure that the third party is billed for the penalty or interest charges. When the Student Billing Control Form (TSACTRL) specifies that student authorization is required for third party contracts, authorization for a student should be completed before running TSRTBIL in Statement mode. This will ensure that the third party is billed for the student’s charges.

Items and item headings

On the Third Party Billing Rules Form (TSATPRL), you can indicate which data items will appear on the Invoice/Bill. The available items are as follows:

Print Student’s Schedule on Bill

Print Student Summary on Bill

Print One Student Per Page

Print Authorization Number

Print Sponsor Reference Number

Print Student Text

Print Billing Message

Print Contract Number Text

To select a data item, select the corresponding check box.

Print Student’s Schedule on Bill

On the Third Party Billing Rules Form (TSATPRL), you can use the Schedule Item Selection window to select the student’s schedule data items that will appear in the schedule portion.

The available items are as follows:

Part of Term	Course Level

Course Reference Number (CRN)	Course Status

Subject	Meeting Days

Course	Meeting Times

Section	Building

Campus	Room

Title	Instructor(s)

Credits	Grading Mode

To select a data item, select the corresponding check box. You can display an abbreviated course title and/or instructor name via a pull-down list. You must also provide the item heading. An error message will appear if the items selected exceed the allowable line width.

The allowable line width checked by Banner is 132 characters. Determine the allowable line width at your institution based on your printer and the pitch/font used for printing. If more items are selected than can be accommodated by your printer and pitch/font combination, printing difficulties may result.

Print Student Summary on Bill

When this check box is selected, Banner will print a student summary on the bill. This is a list of all the students assigned to a contract and their account balances. If selected, this information will appear on the bill after the contractor’s detail information.

Print One Student per Page

When this check box is selected, Banner will print either the information for one student or multiple students on each page of the bill.

Print Authorization Number

When this check box is selected, Banner will print the contract authorization number for the contract on the bill.

Print Sponsor Reference Number

When this check box is selected, Banner will retrieve the sponsor’s reference number from the Contract Authorization Form (TSACONT).

Print Student Text

When this option is selected, Banner will include any text for a student on the bill.

Print Billing Message

When this option is selected, Banner will print any message on the Billing Message Form (TGAMESG) that is associated with the third party/contractor on the bill.

Print Contract Number Text

When this option is selected, Banner will print any text that is associated with the third party/contractor on the Contract Authorization Form (TSACONT) on the bill.

Third Party Invoice/Billing Statement (TSRTBIL)

You will be prompted for the following parameters to run the Third Party Invoice/Billing Statement process (TSRTBIL).

Run Sequence Number

Term

Address Selection Date

Address Hierarchy

ID

Printer

Selection Identifier

Application Code

Creator ID

Run in Sleep/Wake Mode

Sleep Interval

Number of Printed Lines Per Page (not used for schedule/bill processing)

Steps

Review the set-up of the Third Party parameters.

Access the Third Party Rules Code Validation Form (TTVTPRC).

This form lists valid rule codes. Make a note of one of them that may apply to your third party.

Click Exit.

Access the Third Party Rules Form (TSATPRL).

In the Rules Code field, enter the rules code you chose from TTVTPRC.

Perform a Next Block function.

In the Bill Parameters block, select the items that you want to be printed on the third party invoice/bill.

If you chose the option Print Student’s Schedule on Bill, select Create Schedule Items from the Options menu.

Review the options that are available to print on the document.

Notice that the number in the Total Length field (in the upper right corner of the form) adjusts to reflect the total number of characters to be displayed.

Click Save.

Click Exit.

Process Third-Party Contracts

Introduction

Requiring that students be authorized for contracts prior to the release of funds is controlled via the Student Authorization Required for Contracts box on the Student Billing Control Form (TSACTRL). When this check box is selected, it indicates that each student must be authorized by the third party prior to receiving third party credit.

The Contract Authorization Form (TSACONT) is used to establish third party contract authorizations for student accounts. A third party must first be established on the Identification Form (FOAIDEN or SPAIDEN) with an ID number as a non-person.

Third-party contracts

Third-party contracts are billed via the Third Party Invoice/Statement Process (TSRTBIL).

A third-party contract exists on the system as an ID number and a non-person name. Each contract ID number may have multiple contracts. Each contract is established as an account level, a category level, or a detail level contract. At any level, the contract may be based on a percentage and a maximum amount to be paid by the contract. A maximum amount to be paid by the contract to the student can be established as well as a minimum amount to be paid by the student.

After the contract is established, students may be assigned to the contract on this form. Contracts should be established before the beginning of the Billing process.

Payment by the contracts take place online using the Student Payment Form (TSASPAY), or in batch prior to or during the Billing process (TSRCBIL).

Students may also be assigned to a contract on the Account Detail Review Form (TSAACCT). Contracts are billed using the Third Party Billing Process (TSRTBIL).

Steps

Create and post a third-party payment on a student’s account for tuition and fees.

Access the Contract Authorization Form (TSACONT).

Enter the ID number of the non-person account you have been using. The name should appear in the field to the right.

Enter 1 in the Contract Number field.

Enter 200910 in the Term field.

Perform a Next Block function.

In the Contract Base Information block, enter a Description for the Third Party Billing (i.e. what the contract pays for).

List the values for the Payment Detail Code by clicking on the down arrow which will pull up a list of all detail codes. Query for a payment detail code (Type field = P) with CNT in the Category field. Return with the selected value (i.e. TPPY).

List the values for the Charge Detail Code by clicking on the down arrow which will pull up a list of all detail codes. Query the Charge Detail Code fields for a Charge detail code (Type field = C) with CNT in the Category field. Return with the selected value (i.e. TPCH).

Click Save.

Steps

Follow these steps to create account authorizations.

Select Create Account Authorizations from the Options menu.

Enter the data elements in the following table.

After entering these elements, save the data.

Field	Value
Percent	100
Max Amt	200.00
Source	R

Note: This rule states that the contract can pay up to $200 for any charges assessed through registration fee assessment.

Attach a student

You must also attach a student (that has tuition/fee charges) to the contract using the Person Assignment block of the TSACONT form, or the TSACONP form, before the next piece can happen.

Steps

Follow these steps to add a contract to a student on the Contract Person Authorization Form (TSACONP).

Access the Contract Person Authorization Form (TSACONP).

Enter the Contract ID of the Third Party Vendor.

Enter the Contract Number of your contract

Enter the 200910 in the Term field.

Perform a Next Block function.

Add the student you have been working with in the Student ID field.

Click the Save icon.

Click the Exit icon.

Note: You can query on students associated with a contract by using the form TSICONT.

Set up third-party contracts

In class, the instructor will review several other ways to set up Third Party Contracts.

Steps

Follow these steps to complete the process.

Access the Student Payment Form (TSASPAY).

Enter 200910 in the Term field of the Key block.

Enter the student’s ID number in the Key block.

Perform a Next Block function.

Perform another Next Block function.

The Accept Charges/Payments pop up box may appear.

Note: If the Charges/Credits are accepted by clicking return, this sets the AR Indicator in registration and location management to Y for students. This was designed to allow the institution to choose whether or not to update the accept charges flag which is used in the Drop for Non-Payment process (SFRRNOP).

Click Return to ‘accept charges/credits’, if the pop up box appears.

Notice the Third Party Payment in the Cashier Data block. The detail code is the code you just entered as the Payment detail code on the Contract Authorization Form (TSACONT).

Select View Account Detail from the Options menu.

The student’s ID should default into the ID field in the Key block.

The top transaction should be the Payment detail code that was posted on TSASPAY. Notice that the source code is C for the Contract module. Note the dollar amount of the transaction.

Click the Exit icon.

Click the Exit icon again.

Access the Account Review Form – Student (TSAACCT).

Perform a Next Block function from the Key block.

Select View Exemption/Contract from the Options menu. Notice that the contract appears in the Contracts and Exemption block.

Click the Exit icon.

Access the Account Detail Review Form – Student (TSAAREV).

Enter the Company Account number used in the Contract Authorization Form (TSACONT) in the ID field.

Access the Account Details block by performing a Next Block function.

The top transaction should be the Charge detail code that was established on the Contract Authorization Form in this lesson. The amount should be the same amount that was posted as a payment to the student’s account.

Recording a payment from a third-party

This provides the ability to record details about a payment received from the sponsor of a third party contract. In the event of an overpayment, a credit can easily be transferred to the student account, or a refund to the sponsor can be initiated.

Steps

Access the Account Detail Review Form - Student (TSAAREV).

Enter the Contract ID in the ID field.

Perform a Next Block function.

Perform a Record Insert function.

Enter the detail code for check in the Detail Code field.

Enter 200910 in the Term field.

Enter an amount in the Payment field.

Check the indicator for Contract Detail.

Click the Save icon.

Write down the Transaction Number associated with the payment you entered.

Click the Exit icon.

Access the Contract Payment Detail Form - Student (TSACPDT).

Enter the Contract ID in the ID field.

Enter the transaction number you wrote down.

Perform a Next Block function.

Enter the ID of the student for whom you received the payment.

Enter the Contract Number to which the student is associated.

Click the Save icon.

Click the Exit icon.

Reviewing payments from a third-party

Steps

Access the Contract Review Form (TSACONR).

Enter the Contract ID in the Contract ID field.

Perform a Next Block function.

Review the transactions on the account.

Managing Installment Plans

Introduction

The Installment Plan Code Control Form (TSAISTC) defines the characteristics and default entry information for loans and time payments for the institution. Only those installments defined by this form may be granted.

If the installment plan is an automated plan, links to the Installment Plan Assignment Rules Form (TSAISTA) and the Installment Plan Payment Rules Form (TSAISTR) are enabled.

The installment plans defined in this form are used in the Student Installment Plan Form (TSAISTL) to grant loans and time payments.

Objectives

In this section you will learn how to:

create an automated installment plan

create assignment rules

create payment rules

process installment plans for a student account.

Create an Automated Installment Plan

Introduction

The Installment Plan Code Control Form (TSAISTC) defines the characteristics and default entry information for loans and time payments for the institution. Only those installments defined by this form may be granted.

If the installment plan is an automated plan, links to the Installment Plan Assignment Rules Form (TSAISTA) and the Installment Plan Payment Rules Form (TSAISTR) are enabled.

The installment plans defined in this form are used in the Student Installment Plan Form (TSAISTL) to grant loans and time payments.

The Interest Detail Code and Rate and the Service Charge Detail Code and Amount must either both be entered or both be null.

Note: The system will permit entering both the Interest Detail Code and the Service Charge Detail Code. A decision will be required to determine which of these will be used for each installment plan, as to use both would place a double charge on the account for the plan.

Select a detail code for the Plan Detail Code field from the Detail Code Control Form.

Steps

Follow these steps to create an installment plan.

Access the Installment Plan Code Control Form (TSAISTC).

Perform an Insert Record function.

Enter the following values in the following table.

After entering the values in the following table, click the Save icon.

Field	Value
Installment Plan Code	(2 Char user-defined) & description For this exercise, you can use your initials Ex. IG; Irene’s Plan
Term	200910
Plan Detail Code	DEFR
Plan Amount	Leave Blank
Pay Period	Leave Blank
Principal Detail Code	PRIN
Number of Payments	Leave Blank
Auto Installment Plan	Check

To create a manual installment plan, enter these values and then click the Save icon.

Field	Value
Installment Plan Code	(2 Char user-defined) & description For this exercise, you can use your initials Ex. IG; Irene’s Plan
Term	201130
Plan Detail Code	DEFR
Plan Amount	Leave Blank
Pay Period	Leave Blank
Principal Detail Code	PRIN
Number of Payments	Leave Blank
Auto Installment Plan	uncheck

Create Assignment Rules

Introduction

The Installment Plan Assignment Rules Form enables you to create rules that automatically assign a student to an installment plan for a given term. Rules defined on this form are used by the Assign Installment Plans process (TSPISTA), the Installment Plan Payment Form (TSAISTP), the Customer Service Form (TSICSRV), Self-Service Products, and Voice Response (VR).

Steps

Follow these steps to complete the process.

Access the Installment Plan Assignment Rules Form (TSAISTA).

Enter the following data in the Key block:

Plan Code	Enter the plan code created previously
(Your Initials)

Term:	200910

Access the Installment Plan Details block.

Click the Save icon.

For simplicity, we will not be establishing student attributes for this exercise, so that all students will qualify for this plan.

Create Payment Rules

Introduction

The Installment Plan Payment Rules Form (TSAISTR) enables you to define variables used to calculate the Installment principal amount. Rules defined on this form are used by the Create Installment Plan Transaction process (TSPISTT), the Installment Plan Payment Form (TSAISTP), the Customer Service Form (TSICSRV), Web, and Voice Response (VR).

Steps

Follow these steps to complete the process

Access the Installment Plan Payment Rules Form (TSAISTR).

Enter the following data in the Key block:

Plan Code	Enter the plan code created previously
(Your Initials)

Term	200910

Perform a Next Block function to Access the Base Plan Rules for Term block.

In the Calculate Payments Using area, enter the following values:

Field	Value
Calculate Payments Using	Percentage Payments radio button
First Payment Due Date	N/A
Number of Payments	N/A
Pay Period	N/A
Minimum Plan Amount	500.00
Exclude First Payment from Service Charge check box	N/A

Check the types of credits to include when determining the Installment Principal Amount:

Authorized Aid

Financial Aid Memos

Other Memos

Click the Save icon.

Select the Define Dates and Percentages for Payments from the Options menu or perform a Next Block function.

Enter the following information:

Seq No	Due Date	Payment Percent
1	Enter a date	40
2	Enter a date	30
3	Enter a date	30

Click the Save icon.

Select the Define Charges Include in Plan from the Options menu, or perform a Next Block function.

In the Category Information Code Information block, double-click the Category field to view the List of Values.

Select FEE and click OK.

Repeat step 11, select TUI, and click OK.

Click the Save icon.

Once you have completed this exercise, let the instructor know.

As soon as everyone is ready, the instructor will run the Auto Assignment Process (TSPISTA) and then the Auto Calculation Process (TSPISTT).

Access the Account Review Form (TSAAREV) to view the impact of these processes on a student account.

Process Installment Plans for a Student Account

Introduction

The Student Installment Plan Form (TSAISTL) is used to process and post installment plans to a student’s account that have not been assigned using the automatic installment plan assignment functionality.

Installment plan transactions are entered in the Student Installment Plan Form (TSAISTL). This form is located in the Student Accounts Receivable Menu.

Steps

Assign a student to an installment plan and define the terms of the plan.

Access the Student Installment Plan Form (TSAISTL).

In the Key block, enter the ID number of the student you processed in the previous lessons.

Perform a Next Block function.

In the Installment Plan field, enter an installment plan code from the Installment Plan Code Control Form (TSAISTC).

In the Term field, change the default term to the term with which you are working.

Select an Installment Due radio button to specify installment timing (either a Fixed Day of the month, the Last Day of the Month, or Use Pay Period).

In the Number of Payments field, enter the number of payments required for the plan.

If you selected Use Pay Period for the Installment Due field, enter the desired pay period number in the Pay Period field. If you selected Fixed Day or Last Day of Month, ignore this field.

Enter the First Due Date for the payments.

The Plan Detail Code field and Principal Detail Code field will contain default values.

Enter the dollar amount of the plan for this student in the Plan Amount field.

If you intend to charge an interest rate charge for the plan, enter INTR in the Interest Detail Code field, and then enter the rate to be charged in the Interest Rate field.

If you intend to charge a service fee, enter SERV in the Service Charge Detail Code field. You may enter a flat amount in the Service Charge Amount field, or a percentage of the principal in the Or Percent field.

Click the Save icon

Steps

Follow these steps to view the repayment schedule

From TSAISTL, select View Repayment Schedule from the Options menu.

Review the data

Click the Exit icon.

Access the Installment Plan Payment Amount Form (TSAISTP).

Review the data.

Click the Exit icon.

Access the Account Detail Review Form-Student (TSAAREV).

Review the data displayed on this form.

Notice that each of the installments have a different date that corresponds to the date type and first due date entered on the Student Installment Plan Form (TSAISTL) for the student.

Click the Exit icon.

Managing Delinquencies and Collections

Introduction

You will need to decide how to handle delinquent accounts and collections in your Accounts Receivable system. Banner can be set up to automatically assist you in your collections attempts, and ultimately in using write-off procedures and processing bad debt.

Objectives

In this section you will learn how to:

set up for handling delinquent accounts

process delinquent accounts

send accounts to the Collection Agency

set up for write-off procedures

process bad debt.

Set Up for Handling Delinquent Accounts

Introduction

Follow these steps to set up Banner for handling delinquent accounts

Banner form

Steps

Determine how to bill (e.g., whether to bill all students with outstanding balances, bill grouping of students through population selection, etc.)

Create delinquency codes for tracking the delinquency status of the account using the Delinquency Code Validation Form (TTVDELI). Codes may be alpha or numeric. Recommended:

Code 30 = 30 days past due

Code 60 = 60 days past due

Code 90 = 90 days past due

Code CO = referred to Collection Agency

Code WO = Write-offs (but include BAD DEBT) in the description.

Create a Hold Code for “Outstanding Balances” on Hold Type Code Validation Form (STVHLDD).

Create a Hold Code for “Collection Agency” on Hold Type Code Validation Form (STVHLDD).

Create a collection agency or agencies on the General Person Identification Form (SPAIDEN).

Processing Delinquent Accounts

Introduction

Your institution has policies regarding the collection of past due amounts from delinquent accounts. This lesson focuses on putting these policies into place within Banner Accounts Receivable.

Banner form

Steps

Follow these steps to process Delinquent Accounts.

Run the Student Billing Process (TSRCBIL) in “Statement” mode to update the “bill date” and “due date” the first time the transaction appears on a bill. This process should be run on a regular basis to notify the student of the outstanding balance. Subsequent runs of TSRCBIL will not change the original “bill date” or “due date” of individual transactions.

The Student Account Review Form (TSAACCT) can be used to review, on-line, the aging of an account’s outstanding transactions.

The Aging Analysis Report (TGRAGES) can be run to determine how old accounts are. The report can be run based on the effective date of the transactions outstanding, the bill date of the transactions outstanding, or the due date of the transactions outstanding. TGRAGES is used to monitor the accounts that are outstanding

Note: This report is also used in the reconciliation process of Banner Accounts Receivable.

The Auto Holds Rules Form (TGAHOLD) creates rules on page two or three, using the “Outstanding Balances” hold code, to place a hold on student accounts that have outstanding past due balances.

The Auto Hold Release Process (TGPHOLD) is run in batch or sleep-wake mode. This process is used to place holds on accounts that have outstanding past due balances or to release accounts that have paid the outstanding balance. This job should be run at least daily.

The Batch Update of Delinquencies is used to update the delinquency code on the student’s account (TSAACCT). The report uses the “due date” of the outstanding transactions and updates the delinquency code on TSAACCT based on the rules defined through the parameters on TGRDELI.

Note: This process is usually run monthly after the billing due date.

Sending Accounts to the Collection Agency

Introduction

When all internal efforts to collect past due accounts have been exhausted, you may opt to send accounts to a Collections Agency to attempt to collect the past due amounts.

Steps

Follow these steps to send accounts to the collection agency.

Using a population Selection, those accounts that have a specific delinquency code can be identified for referral to the collection agency.

Using the Auto Holds Rules Form (TGAHOLD), create a hold rule for the “Collection Agency” hold.

Set up a NON-CONDITIONAL rule for posting the “Collection Agency” hold to students

Only fill out Page One (no rules should be attached)

Run the Auto Hold Release Process (TGPHOLD) to assign students to the appropriate collection agency.

Note: this is a manual process.

Using the Account Review Form (TSAACCT):

Select the “Collection Agency” code for the Bill Code field in the Account Status block.

Select the appropriate “referred to collection agency” code for the Delinquency field in the Account Status block.

Note: this is a manual process.

Setting Up for Write-off Procedures

Introduction

Your institution will determine the rules for deciding when to write off bad debt. Once that time has passed, follow these instructions to write off uncollectible amounts.

Steps

Follow these steps to set up for write-off procedures at your institution.

Create two detail codes to be posted to student accounts

A payment code to pay off the account

Debit: Bad Debt Clearing

Credit: Unapplied Bad Debt Account

A charge code to capture the “Bad Debt”

Debit: Bad Debt Expense

Credit: Bad Debt Clearing

Create a Bill Code for “Bad Debt” on the Bill Code Validation Form (TTVBILL)

Create a Delinquency Code for “Bad Debt” on the Delinquency Code Validation Form (TTVDELI).

Create a Hold Code for “Bad Debt” on the Hold Type Code Validation Form (STVHLDD).

Create a Bad Debt Rule Code on the Auto Hold Validation Form (TTVRHLD).

Processing Bad Debt

Introduction

The process to write-off bad debt involves several steps, using accounting rules to move the Outstanding Receivable into the Bad Debt Expense account. In this diagram, you can see four accounts, with debits on the right and credits on the left for each account. The numbers 1), 2), 3) and 4) indicate which process debits or credits the account. For this illustration, assume that a bad debt of $99.99 is being written off.

Process Number	Process Action
1	Open Balance on Accounts (Credit $99.99)
2	Post Write-off Payment to account (Credit Bad Debt Clearing, Debit the Unapplied Bad Debt Account)
3	Post Bad Debt Charge to account (Debit Bad Debt Clearing, Credit Bad Debt Expense)
4	Application of payment (Write-off payment to old outstanding charge) (Credit the Outstanding Receivable, Debit the Clearing Account)/

Steps

Follow these steps to process a student’s bad debt and write it off.

Access the Account Review Form (TSAACCT)

Enter the ID of the Student whose account you are getting ready to write off into the ID field.

Click the Next Block icon to view the student’s account status.

Set the Bill Code field to the “bad debt” code.

Set the Delinquency field to the “bad debt” code.

Click the Save icon to update the student’s account record.

Click the Exit icon.

Access the Account Detail Review Form (TSAAREV).

Verify that the ID field in the Key Block contains the information for the student whose account you are updating. If not, enter the student’s ID into the ID field.

Post the “Bad Debt” payment code in the Detail Code field on the Account Details block. This would be the amount for the bad debt being written off.

Note: If you are not writing off the entire account, t-pay the payments to those transactions being written off. You could do this on the Application Distribution of Single Payment – Student Form (TSAADSP).

Post the “Bad Debt” Charge code for the amount of bad debt to be written off.

Click the Save icon to update the student’s account record.

Click the Exit icon.

Access the Auto Holds Rules Form (TGAHOLD).

Enter a NON_CONDITIONAL rule for posting the “Bad Debt” hold to students, only filling out Page One of the form.

Note: No rules should be attached.

Click the Save icon to update the Auto Holds Rules.

Click the Exit icon.

Create a population selection for those accounts that have been written-off. This can be done through population slections rules or by manually entering IDs in a manual population selection.

Run the Auto Hold Release Process (TGPHOLD) to place accounts on the “Bad Debt” hold. Use the Hold Rule Code you created above for the “Bad Debt,” entering it into Parameter 05 Hold Rule Code.

Managing Payments and Deposits

Introduction

The purpose of this section is to explain the day-to-day or operational procedures to manage Accounts Receivable functionality at your institution.

Objectives

At the end of this section, you will be able to

create a deposit

query records in the account charge/payment detail table

accept charges and post payments on the Student Payment form

post a charge on an account

post a payment on the Account Detail Review form

distribute a single payment to multiple charges

review a student account

query account by detail code

process deposits and post deposits to a student’s account

use mass entry for student charges and payments

view the account transactions for a student.

Create a Deposit (TGADEPC)

Introduction

The Deposit Detail Control Form (TGADEPC) is used to create deposits. Once the deposits are created, they can be placed on a student’s account.

Steps

Follow these steps to create a deposit.

Access the Deposit Detail Control Form (TSADEPC).

Enter the values from the following table.

After entering these values, save the data.

Field	Value
Deposit Code	HDEP
Payment Code	DCHK
Auto Release	Y
Minimum Amount	Leave Blank
Deposit Type	HOU
Release Date	Leave Blank
Expiration Date	Leave Blank

Query Records in the Account Charge/Payment Detail table (TBRACCD)

Introduction

The Account Query Detail Form (TGIACCD) allows for the ability to query all records in the Account Charge/Payment Detail Table (TBRACCD) without specifying an ID number or to specify an ID number to view just one student account. It can be used as a tool while reconciling Banner Accounts Receivable to Banner Finance or to non-Banner Finance systems. A query can also be processed for just one detail code.

Steps

Query records in the Account Charge/Payments Detail table (TBRACCD) using TGIACCD.

Access the Account Detail Query Form (TGIACCD).

Since the query is being performed on the TBRACCD table, the query can be very large; therefore, the following recommendations should be considered.

Allow a select group of users to have access to this form. This determination should be made by your organization.

Perform queries in an efficient manner. The table, which is being queried, has indexes. The indexed data elements should be used for the best performance.

The form is entered in Query mode.

Use the scroll bar to view the fields that can be used to select your query criteria. Combinations of any fields are possible.

Scroll to the Cashier area.

Enter the user name, the session number that was assigned when the cashier session in a previous topic was closed, and today’s date.

Review the information that is displayed.

The instructor will advise the class on using the indexed fields to assist in an efficient query.

Accept Charges and Post Payment on the Student Payment Form (TSASPAY)

Introduction

The Student Payment Form (TSASPAY) is used to process a payment for a student who has registration and/or housing (location management) charges for a term.

Student registration and housing (location management) charges not previously assessed in the individual modules will be assessed on this form. The form is term-specific. Charges for the term are accepted on this form indicating that the student plans to attend.

This form calculates exemptions and contracts for eligible students and releases any deposits set to automatically release. It can also display the available Financial Aid if it is interfaced with the institution's Financial Aid system. If the Banner Financial Aid System is installed, it can call the Financial Aid disbursement process.

Review a student's registration charges

Review a student’s registration charges on the Account Detail Review Form - Student (TSAAREV), accept the charges, and enter a payment transaction on the Student Payment Form (TSASPAY).

Steps

Follow these steps to complete the process.

Access the Student Payment Form (TSASPAY).

Upon entering an Accounts Receivable form for the first time, the Accounts Receivable Distribution Initialization Form (TOADEST) appears. Click the Exit icon. The instructor will explain this form during class.

Enter 200910 in the Term field.

Enter the ID number of the student you registered (if it was not defaulted into the key block).

Perform a Next Block function

The number of credit hours, the number of bill hours and the amount of the term charges display in the top half of the form.

The Accept Charges block will pop up if new charges and/or credits are available. If the Charges/Credits are accepted by clicking return, this sets the AR Indicator in registration and location management to Y for students. This was designed to allow the institution to choose whether or not to update the accept charges flag which is used in the Drop for Non-Payment process (SFRRNOP).

Select View Account Detail from the Options menu.

Review the charges/payments.

The account balance displays at the bottom of the form.

Click the Exit icon to return to the Student Payment Form (TSASPAY) to complete the action.

Click Return to accept the term charges.

The difference between Charges, Charges/Credits, and None is explained in class.

Enter a $50.00 cash payment to cover a portion of the student’s tuition amount only.

Find the detail code for cash payment (remember that you can query for all cash-type payments by entering CSH in the Category field while in the TSADETC form).

Enter the amount of the payment and click Save to update the collector file for printing the student receipt using the Sleep/Wake feature of the system.

Note: The sleep/wake process will need to be started for TGRRCPT for receipts to be printed.

Acknowledge the message displayed in the Auto Help line.

The receipt process is initiated as a result of the cash payment.

Review the totals on the bottom of the form.

Post a Charge on an Account

Introduction

The Student Account Detail Form (TSADETL) allows for the entry of all charges and payments by detail code and amount, and to create deposits and memo items. Comments on the account (account text) may also be entered on this form. Balances and the NSF total indicator are displayed. Invoice numbers may be generated, and unapplication of payments may be requested.

The Account Detail Form is used for detail entry of transactions to individual accounts.

The Accounts Receivable Distribution Initialization Form (TOADEST) will appear the first time you access any form in Accounts Receivable module. You may specify printer identification for invoices and for receipts, which are required if each user is printing at a different printer or if preformatted forms are being used for invoices, receipts or student summary.

Steps

Post a charge transaction to a student’s account using the Student Account Detail Form (TSADETL).

Access the Student Account Detail Form (TSADETL).

Upon entering an Accounts Receivable form for the first time, the Accounts Receivable Distribution Initialization Form (TOADEST) appears. The instructor will explain this form during class.

In the ID field, enter the ID number of your assigned student in the Key block of the Student Account Detail Form (TSADETL).

Perform a Next Block to access the Charges/Payments block.

Review the charges and payment posted. Note the current amounts in the Account Balance and Amount Due fields.

The student has a parking charge of $35.00 that needs to be posted to his/her account.

Insert a blank transaction record from the Options menu by clicking on Record and Insert.

Enter the following data elements:

Field	Value
Detail Code	PARK
Amount	35
Term	200910

Access the Doc Num field.

Enter the number of the parking office document that generated the charge, which is HJR501.

Click the Save icon.

Review the balance information on the bottom of the form. The $35.00 increase will be reflected in the Account Balance and the Amount Due fields.

Post a second transaction

You will now add a second parking charge for the student, which will take effect at a later date.

Insert a blank transaction record from the Options menu by clicking on Record and Insert.

Enter the following data elements:

Field	Value
Detail Code	PARK
Amount	100.00
Term	200920

In the Doc Num field, enter the number of the parking office document that generated the second charge, which is HJR728.

In the Effective Date field, enter a date greater than today’s date (future effective date).

Click the Save icon.

Note that the new charge has been applied to Account Balance but has not been applied to Amount Due yet.

Click the Exit icon.

Post a Payment on the Account Detail Review Form – Student (TSAAREV)

Introduction

The Account Detail Review Form (TSAAREV) is used to enter charges and payments to a student's account and to display information in a condensed format.

Post a payment

Post a payment to an account via the Account Detail Review Form - Student (TSAAREV).

Access the Account Detail Review Form – Student (TSAAREV).

In the ID field, enter the ID of the student used in previous lessons if it is not already present in the Key block.

Perform a Next Block function to enter the Account Details block of TSAAREV.

Select a blank line in the Account Details block.

Enter CHEK in the Detail Code field.

Enter CHEK #300 in the Description field by typing over the existing description.

Enter 200910 in the Term field.

Enter a payment amount of $40.00 by entering 40 in the Payment field. Notice that the cursor defaults to the Payment field when using a Payment detail code.

Click the Save icon.

Note: The Receipt field for this payment populated when the record was saved. (Use the scrollbar to view additional fields.)

Click the Enter Query icon. Then click the Execute Query icon. The transaction that you just entered should now be on the first line, since it was the most recent one posted.

Note that the Transaction Number field has been populated, and that the Source field now displays a value of T.

To print a Student Transaction Summary report, simply select Print Detail from the Options menu. This will print a summary for the student of the account transactions provided the TSRSSUM process has been started in sleep/wake mode.

Click the Exit icon.

Distribute a Single Payment to Multiple Charges

Introduction

The Application Distribution of a Single Payment Form – Student (TSAADSP) is used to apply a single payment to one or more charges. Use it to specify how Banner will distribute a payment among multiple charges. You can specify whether the payment amount will post as a single transaction or as multiple transactions. If you select the single payment option, you must select the charges to which you want the payment applied. If you select the split payment option, you must enter the amount of the payment you want to apply to each charge in the Split Payment field. The total dollar amount in the Split Payment column must equal the payment amount entered in the Key block. A transaction will be generated for each charge that receives part of the payment.

Access the Application Distribution of a Single Payment Form – Student (TSAADSP).

In the ID field, enter the ID of the student used in previous lessons if it is not already present in the Key block.

In the Detail Code field, enter CASH.

In the Amount field, enter 100.

In the Term field, enter 200910.

Perform a Next Block function.

Check the checkbox on the record with the PARK detail code with the balance of 100.

Click the Save icon.

Click OK on the pop up box stating that the transaction saved.

Click OK on the second pop up box stating that the transaction saved. This one is for the receipt that prints if TGRRCPT is running in sleep/wake mode.

Review the message in the help line at the bottom of the form.

Select View Student Account Detail Review Information from the Options menu.

The first transaction should be the cash transaction for $100.

Go to the parking fee transaction for $100.

Scroll over to the Transaction Paid field, where you will see the transaction number for the cash transaction in this field. This is how the two transactions are associated with each other.

Note: When application of payment (TGRAPPL) runs, the cash transaction will always apply against the parking fee transaction on this record.

Review a Student Account

Introduction

The Account Detail Review Form (TSAACCT) is used to review account information about a specific account. Overall account summary data is displayed, including account status, balances including future and aging balances, exemptions, third party contracts, collection agency assignments, and installment plan information.

Steps

Review a student’s account using the Account Detail Review Form (TSAACCT).

Access the Account Detail Review Form (TSAACCT).

In the ID field, enter the ID of the student used in previous lessons if it is not already present in the Key block.

Perform a Next Block function to populate the Account Status block.

Perform a Next Block function to populate the Account Balance block. Review these values.

Should you have any questions, return to the Account Detail Form (TSADETL) or the Account Detail Review Form (TSAAREV) and review all items to understand the summary provided on the Account Detail Review Form. If you need assistance, the instructor can help.

Explanation is given in class of the fields in the Account Status block and the batch processing related to each field.

Continue performing Next Block functions to review the Exemptions, Contracts, Collections and Installment Plan Query blocks. (Alternatively, you may use the options on the Options menu to navigate between blocks.)

You may wish to return to TSAACCT after completing subsequent exercises that will affect the values on this form.

Query Account by Detail Code

Introduction

The Account Detail Review Form - Student (TSAAREV) is also used to display information in a condensed format.

Review total charges

Review the total charges for a specific detail code using the Account Detail Review Form - Student (TSAAREV).

Access the Account Detail Review Form - Student (TSAAREV).

In the Key block, enter the ID number of the student you processed in the previous lessons.

Perform a Next Block function to access the Account Details block.

Review the charges and payments posted.

Review specific charges

First, you will review specific charges on your student’s account.

Perform an Enter Query function.

Enter the detail code PARK in the Detail Code field.

Perform an Execute Query function.

The system retrieves all parking charges on this account.

Review the summary information at the bottom of the form.

Notice that the query balance reflects the total amount of the selected transactions only. The other totals still reflect the overall account.

Review all charges for a particular term

Next, you will review all charges for a particular term on your student’s account.

Perform an Enter Query function.

Enter the term code 200910 in the Term field.

Perform an Execute Query function.

The system retrieves all charges for the term 200910 on this account.

Query for multiple criteria

Finally, you may narrow your search even further by querying for multiple criteria. In this case, you will view only the parking charges for the 200910 term on your student’s account.

Perform an Enter Query function.

Enter the detail code PARK in the Detail Code field.

Enter the term code 200910 in the Term field.

Perform an Execute Query function.

The system retrieves all the parking charges for the term 200910 on this account.

Process Deposits and Post Deposits to a Student’s Account

Introduction

The Student Account Detail Form (TSADETL) is used to process and post deposits to a student’s account.

Deposits are entered using either the Account Detail Form (TSADETL), or by using the Create Deposits option on the Billing Mass Data Entry Form (TSAMASS). Deposit detail codes should be set up along with deposit payment codes, and defaults may be established for the type of payment that is used to make the deposit. Deposit information is maintained in a separate block from payment and charge transactions.

In the Accounts Receivable System, deposits may be released manually or automatically and either applied to an account's outstanding charges as a payment, or refunded (by entry of the proper refund code).

Steps

Process deposits received for a student’s account and release and post the deposit to a student’s account.

Access the Student Account Detail Form (TSADETL).

In the Key block, enter the ID number of the student you processed in the previous lessons.

Perform a Next Block function.

Select the Deposits tab.

Click in the Deposit Code field.

Search for a deposit detail code. Return with an appropriate code.

Enter 200910 in the Term field.

Click the Save icon.

Acknowledge the messages that appear in the pop-up windows.

Click the Exit icon.

The instructor will discuss the Deposit Detail Control Form (TGADEPC) that is used to establish the deposit codes.

Access the Account Detail Review Form – Student (TSAAREV).

Notice that the deposit transaction does not appear on this form.

Return to the Student Account Detail Form (TSADETL).

Select the Deposits tab.

Enter the amount of the original deposit in the Release Amount field.

Click the Save icon. This will release the deposit onto the student account.

Steps

Follow these steps to view released deposits.

Click the Charges/Payment tab.

Notice that the first transaction is the deposit that was released onto the student’s account. Notice the change in the balance fields at the bottom.

Click the Exit icon.

Go to the Account Detail Review Form - Student (TSAAREV).

Perform a Next Block function.

Review the data. The deposit transaction should be on the top transaction line on the account.

The instructor will explain the other options for releasing deposits to the student’s account.

Use Mass Entry for Student Charges and Payments

Introduction

The Billing Mass Data Entry Form (TSAMASS) is used to quickly enter charges and payments in amount form, deposits, and memo items. Totals and the NSF indicator are displayed. Invoice numbers may be generated upon request. The form is used to enter many like transactions to large numbers of accounts on a single form.

Steps

Post a number of transactions using the Billing Mass Data Entry Form (TSAMASS).

Access the Billing Mass Data Entry Form (TSAMASS).

Assume that Accounts Receivable has been given several small checks for student payments. In the Key block, enter the following data elements:

In the Detail Code field, enter CHEK

In the Amount field, enter 25

In the Term field, enter 200910

Perform a Next Block function to access the Charges/Payments block.

Enter the ID of your student from previous lessons in the ID field. Notice that the Detail Code field and the Amount fields have been populated with the values listed in the Key block.

Access the Detail Code Description field. Tab across the field to the end of the existing description and enter a check number.

Access the next record. Again, enter the student’s ID and modify the description to reflect a different check number.

Click Save.

Notice the Charge/Payment Total field at the bottom of the page.

Click Exit.

Access the Student Account Detail Review Form (TSAAREV).

Perform a Next Block function to access the Account Details block.

Notice that the two check payments recorded on the Billing Mass Data Entry Form (TSAMASS) are now listed in the Account Details block.

This same procedure can be used to enter the same charge to several accounts. The amount and the detail code can be adjusted in the Charges/Payments block as data is entered.

Click Exit.

View the Account Transactions for a Student

Introduction

The Account Detail Review Form – Student (TSAAREV) is used to view the account transactions for a student.

Banner form

Steps

Review the application of payments to charges.

The instructor will run the Application of Payment Process (TGRAPPL) prior to this exercise. The Application of Payments Process applies payments to charges.

Access the Account Detail Review Form - Student (TSAAREV).

The student’s ID should populate the Key block.

Next block to access the Account Details block.

Use the scroll bar in the Account Details block to view the transactions for this student.

Note that the Balance field (in the Account Details block) is now different than the Charge or Payment fields for many transactions. When the Balance and Charge or Payment fields are not equal, payments and charges have been applied to one another according to the Application of Payments priorities of each detail code defined on the Detail Code Control Form – Student (TSADETC).

Click the Exit icon.

Access the Application of Payment Review Form – Student (TSIAPPL).

Perform a Next Block function.

Review the payments that have been applied to charges. Notice that the Count field below the message line displays the record you are on and the total number of records for the account as 1/54, 2/54, and so forth.

Managing Application of Payments

Introduction

The Application of Payments Process (TGRAPPL) exists to allow the institution maximum flexibility in determining which payments apply to which charges, the order in which payments should be used, and the order in which charges should be liquidated. It handles the internal application of a line item with a negative balance to a line item with a positive balance. Generally, the payment is applied to a charge, but could also be a negative charge (cancellation or reduction) against a charge, or a payment against a negative payment (such as a reduced PELL Grant or a canceled exemption or contract payment).

After a payment has been applied and it is determined that it was applied incorrectly, the payment(s) may be unapplied using the Unapplication of Payments Form (TSAUNAP) for a specific transaction number, term, or effective date.

Objectives

In this section you will learn how to:

make direct application of payments

review the application of payments

perform an unapplication of payments – student.

Direct Application of Payment

Introduction

As mentioned in a previous lesson, the Student Account Detail Review Form is used to enter charges and payments to a student’s account and to display information in a condensed format.

Steps

Perform a direct application of payment on the Account Detail Review Form (TSAAREV).

Access the Student Account Detail Review Form (TSAAREV).

In the Key block, enter the identification number of the student processed in the previous lesson.

Next block to access the Account Details block.

The student wants to pay the $35.00 parking charge for term 200910. Since this transaction was entered recently on the account, it appears near the top of the Account Details block.

Note the transaction number (Transaction Number field) of the $35.00 parking charge. (Use the scroll bar to view this field.)

Place the cursor in the Detail Code field of the $35.00 transaction.

Perform an Insert Record function to insert a blank transaction line directly beneath the $35.00 parking charge.

In the new transaction line, enter CHEK in the Detail Code field.

Enter CHEK #310 in the Description field.

Enter 200910 in the Term field.

Enter a payment amount of $35.00 by entering 35 in the Payment field.

Use the scroll bar to access the Transaction Paid field. Enter the Transaction Number from step #3 of the $35.00 parking charge.

Click Save.

Note that the Receipt field for the new transaction (the $35.00 payment) has been populated.

Once saved, the new transaction is assigned its own transaction number. When the account is queried, the new transaction will appear at the top of the Account Details block.

Click on Options and Apply Transactions. Notice the balance column.

Click Exit.

Review the Application of Payments

Introduction

The Application of Payments Process (TGRAPPL) exists to allow the institution maximum flexibility in determining which payments apply to which charges, the order in which payments should be used, and the order in which charges should be liquidated. It handles the internal application of a line item with a negative balance to a line item with a positive balance. Generally, the payment is applied to a charge, but could also be a negative charge (cancellation or reduction) against a charge, or a payment against a negative payment (such as a reduced PELL Grant or a canceled exemption or contract payment).

When the Application of Payment Batch Process is run, the following processes take place:

Payment applied to a charge:

Debit Account B for payment code

Credit Account A for charge code

Reversed charge applied to a charge

Debit Account A for reversed charge code

Credit Account A for charge code

Payment applied to a reversed payment

Debit Account B for payment code

Credit Account B for reversed payment code

Entering a payment on TSASPAY, TSADETL, TSAAREV or TSAADSP can be directly applied to a specific charge or invoice using the Transaction Payment field. This will override all other application of payment specifications. If a direct application (TPay) is not specified, then when TGRAPPL is run, the payments will be applied based on the following criteria order:

Direct Payments (TPays)

Direct Invoice number

Like Detail Codes with the same term

Contract Payment Detail

Priority Order within

Payments

Title IV TGRAPPL parm 5

Order by Term TGRAPPL parm 8 (1 or 2) future term parm 7 = Y

Cross Reference Info TGRAPPL parm 4

Priority Codes

Like term indicator (within Priorities) – Term codes defined in Aid Periods will process those payments to all terms defined posting to the AR indicated term first.

Like Aid Year (within Priorities)

Oldest effective date

Lowest Transaction number

Charges

Order Charge by payment (TIV/nonTIV)

Institutional charges first

Institution Charge same term

Institutional Charge lesser term, same Aid Year – Like Term = N

Institutional Charge future term , same Aid Year - TGRAPPL parm 6 = Y, Like Term = N

Institutional Charge other terms - PY/PPY, Like Term/Aid Year = N

TIV/PTV Authorization

Non-Institutional Charge same term

Non-Institutional Charge lesser term, same Aid Year – Like Term = N

Non-Institutional Charge future term , same Aid Year - TGRAPPL parm 6 = Y, Like Term = N

Non-Instutitional Charge other terms – PY/PPY, Like Term/Aid Year = N

Like term indicator

Like Aid Year

Order by Term TGRAPPL parm 8 (1 or 3) future term parm 7 = Y

Cross Reference Info TGRAPPL parm 4

Priority Codes

Oldest effective date

Lowest Transaction number

Refund to any priority TGRAPPL parm 2

Negative charge to any priority TGRAPPL parm 3

When the Application of Payment Batch Process (TGRAPPL) is run, results may be viewed for each account on the Application of Payment Query Form (TSIAPPL), which shows the charge Detail code, the payment Detail code, and the amount applied. Once a payment has been applied to a charge, the balance of the payment and charge will reflect the amount that has been used. The unused or outstanding balance for each transaction may be viewed on the Student Account Detail Form (TSADETL) or the Account Detail Review Form (TSAAREV).

If a payment is the result of an exemption or a third party contract payment, an additional requirement must be met when running TGRAPPL in order for the payment to apply to a charge transaction. If Apply Contracts or Detail Code Priority is set to C, then the exemption or contract payment is matched to the transaction that was read by the rule that produced the Payment. To bypass this requirement, when defining the parameters on TGRAPPL, set the Apply Contracts or Detail Code Priority to D.

Future dated transactions will be handled in one of two ways, depending on the status of the Feed Future Effective Transactions check box on the Accounts Receivable Billing Control Form (TGACTRL). If this check box is checked, then the effective date is not used (i.e., all transactions are candidates for application of payments). If this check box is not checked, the Application of Payments process will only apply to those transactions that have a current or less than current effective date. Future charges or payments will not be applied until they become effective.

For Finance only transactions (i.e. transactions with a term code of ARTERM), only the following order is followed:

Direct Payments (TPays)

Direct Invoice number

Like Detail Codes

Priority Order within

Payments

Priority Codes

Oldest effective date

Lowest Transaction number

Charges

Priority Codes

Oldest effective date

Lowest Transaction number

Refund to any priority TGRAPPL parm 2

Negative charge to any priority TGRAPPL parm 3

Perform an Unapplication of Payments - Student

Introduction

After a payment has been applied and it is determined that it was applied incorrectly, the payment(s) may be unapplied using the Unapplication of Payments Form (TSAUNAP) for a specific transaction number, term, or effective date.

Unapply online payments

Unapply online payments, review the results, and request batch unapplication of another payment for the Student System.

Access the Student Unapplication of Payment Form (TSAUNAP).

The student’s ID should populate the Key block.

Perform a Next Block function to enter the Applied Payments block.

Review the payments that have been applied to charges. If more entries exist than can display on one page, a scroll bar will appear on the right side of the block. Use the scroll bar to view all the payments.

Perform a Next Block function to access the Unapplication of Payments block.

Choose a transaction from the Applied Payments block.

Enter the transaction number in the Transaction Number field in the Unapplication of Payments block.

Click Save.

The transaction is removed from the Applied Payments block.

Click Exit.

Access the Account Detail Review Form – Student (TSAAREV).

Locate the transaction number you unapplied in the previous step. The balance should now equal the amount in the Payment field.

Remove the transaction number from the transaction pay field.

Click Save.

This transaction is now available to be applied to a different detail code (if the new detail code entered has a higher priority) when the Application of Payment report (TGRAPPL) is run again.

Click Exit.

Access the Account Detail Review Form (TSAACCT).

Enter the Account Status block. Select Unapply Payments from the Options menu.

Enter 200910 in the Term field, indicating that you want to unapply all payments for that term.

An alternative is to enter the date for which you want to have transactions unapplied. You cannot use both the Term and the Unapply Date.

Click Save. .

Unapplication of payment can also be done while viewing the Account Detail Review Form - Student (TSAAREV). To do so from that form, select Unapply Transactions from the Options menu.

Managing Cashiering Sessions

Section Goal

The goal of this section is to review the processes involved in Cashiering in Banner Accounts Receivable.

Section Objectives

In this section you will learn how to:

perform miscellaneous routine cash receipts

perform miscellaneous non-routine cash receipts

process non-sufficient fund checks

use the receipt form

use the receipt query form

review and close cashier sessions

adust a closed session – regular

adjust a closed session – miscellaneous

finalize a cashier session

use auto refunding of credit amounts.

Perform Miscellaneous Routine Cash Receipts

Introduction

The Miscellaneous Transaction Forms are used to collect money that is not applied to a specific account. (The Miscellaneous Transaction Form – Finance (TFAMISC) is used if Banner Finance is installed; the Miscellaneous Transaction Form – Student (TSAMISC) is used if Banner Finance is not installed.) These forms provide a method for cashiers to record these transactions and generate a receipt.

Whenever a payment is made or money is collected, a corresponding charge must be entered for the same amount to produce a balanced entry. These forms allow for direct entry of general ledger account information when the detail code used permits it. The forms also have a pop up box, accessible only by a supervisor (as specified on the user profile form), for the purpose of allowing adjustments to a cashier's closed session.

Steps

Post miscellaneous debits and credits and produce a receipt using detail codes with the existing account distributions.

If the Banner Finance System is installed, access the Miscellaneous Transaction Form - Finance (TFAMISC).

If the Banner Finance System has not been installed, access the Miscellaneous Transaction Form - Student (TSAMISC).

The two forms are mutually exclusive. If Finance is installed, TSAMISC will be unavailable, and if it is not installed, TFAMISC will be unavailable.

Assume that the bookstore (a campus-run auxiliary) has brought all of its cash receipts for the day, totaling $525.00, to the cashier.

It is possible to enter an ID number in the Key block of the form, but the form does not update the account associated with the ID. The miscellaneous transaction remains separate from the account detail records. The instructor will indicate whether or not to enter an ID number.

Perform a Next Block function.

In the Detail Code field, enter the payment detail code CASH.

Access the Description field. Enter Bookstore Receipts and today’s date for the description of the transaction.

Access the Debit or Credit field. Enter D to indicate this is the debit side of the transaction.

Access the Amount field. Enter $525.00, the amount of the payment.

Access the next record. Enter the detail code for the bookstore in the Detail Code field.

Access the Description field. Enter Bookstore Receipts and today’s date for the description of the transaction.

Access the Debit or Credit field. Enter C to indicate that this is the credit side of the transaction.

Access the Amount field. Enter $525.00, the amount of the payment.

The GL# Enterable field is unchecked (No) for both the CASH and BKST detail codes.

The instructor will explain what happens when the GL# Enterable field is checked (Yes), and how those results will differ depending on whether the Finance System has been installed.

Select Create Address Information from the Options menu.

Enter the campus address information. This information is optional.

Click Save.

The system has already requested a printed receipt. Acknowledge any messages that may appear.

The Auto Help line indicates that the receipt request has been processed. This is because the Receipt Print Indicator flag is set to Y (Auto Print) on the Accounts Receivable Billing Control Form (TGACTRL).

Click Exit.

Perform Miscellaneous Non-routine Cash Receipts

Introduction

The Miscellaneous Transaction Form (TFAMISC/TSAMISC) is used to post miscellaneous transactions that will not have permanent records in Accounts Receivable based on a person/non-person ID.

Steps

Post miscellaneous debits and credits and produce a receipt when accounting distributions have not been assigned to a detail code.

Access the appropriate Miscellaneous Transaction Form for your system (TFAMISC or TSAMISC).

You are in receipt of numerous check payments, totaling $200.00, for participation in a College Fair held on campus. The payments are not to be posted to individual accounts but must be entered as miscellaneous transactions.

The ID field in the Key block is optional. The form will not update the account associated with the ID. The miscellaneous transaction remains separate from the account detail records. The instructor will indicate whether or not to enter an ID number.

Access the Detail Code field. Enter CHEK to indicate a check payment.

Continue to the Description field. Enter College Fair Receipts.

Access the Debit or Credit field. Enter D to indicate that this is the debit side of the transaction.

Access the Amount field. Enter $200.00, which is the amount received by the admissions office.

After an amount is entered, the Accounting information fields display.

The GL# Enterable field is checked (Yes). The instructor can explain the differences in data entry between Banner Finance clients and Non-Banner Finance clients.

Enter the General Charge detail code in the Detail Code field. To find the valid code, display the Detail Code Control Forms - Student (TSADETC).

Perform a Query on the Description field by entering General %. Return to the Miscellaneous Transaction Form with the General Charge detail code (GFEE.)

Continue to the Description field. Enter College Fair.

Access the Debit or Credit field. Enter C to indicate this is the credit side of the transaction.

Access the Amount field. Enter $200.00, which is the amount received by the admissions office.

After an amount is entered, the Accounting information fields display.

The GL# Enterable field is sent to Y (Yes). The instructor can explain the differences in data entry between Banner Finance clients and Non-Banner Finance Clients.

Select Create Address Information from the Options menu.

Enter the campus address information. This information is optional.

Click Save.

The system has already requested a printed receipt.

Acknowledge any messages that may appear.

The Auto Help indicates that the receipt request has been processed. This is because the Receipt Print Indicator flag is set to Y (Auto Print) on the Accounts Receivable Billing Control Form (TGACTRL).

Process Non-Sufficient Fund Checks

Introduction

The Returned Check Code Control Form (TGARETC) establishes penalty codes and amounts for returned checks, to be automatically assessed upon entry of a returned check code. Entry of a returned check code onto an account also automatically increases the NSF flag field, which is viewable on the different account forms (TSADETL, TSASPAY, and/or TSAAREV).

Steps

Check number #300 in the amount of $100.00, posted to an account, has been returned by the bank unpaid due to non-sufficient funds. You must repost the charge to the account for the amount of the check.

Access the Returned Check Code Control Form (TGARETC).

Do not make any changes to this control form during the exercise. This detail code, for Return Check, must be entered on the account when a returned check is posted.

Click Exit.

Access the Account Detail Review Form - Student (TSAAREV).

In the Key block, enter the ID number of the account being processed.

The number of returned checks posted to the account, as indicated by the NSF (non-sufficient funds) field, should be 0.

Next block to access the Account Details block.

Perform an Insert Record function.

Enter RETC in the Detail Code field.

In the Description field, enter the check number of the returned check.

Enter 200910 in the Term field.

In the Charge field, enter the amount of the returned check.

In the Source field, T (Charge/Payment Transaction) is automatically populated and does not have to be entered.

Click Save.

The number of returned checks posted to the account, as indicated by the NSF (non-sufficient funds) field, should now read 1.

The penalty code associated with the returned check does not need to be entered by the user. The system will apply the penalty when the transaction for the returned check is saved.

Perform a Rollback function.

Perform a Next Block function.

The penalty code is now displayed with its amount from the Returned Check Control Form (TGARETC).

Use the Receipt Form (TGARCPT)

Introduction

The Receipt Form (TGARCPT) is used to display and reprint previously processed transaction receipts. Any transaction receipt created may be displayed on this form. This form may also be accessed from TSASPAY, TSADETL, TSADETF, and TSAAREV when a receipt number is generated.

Steps

View a receipt entered previously and produce a duplicate.

Access the Student Account Detail Form (TSADETL).

Enter the ID of the student you have been using in the ID field.

Perform a Next Block function.

Query for a check payment. Use the detail code CHEK in the Detail Code field.

The system displays the details entered on the account with this detail code. The system has a receipt number for each entry on the account with CHEK as a detail code as defined on the Detail Code Control Form (TSADETC).

Record the receipt number that was assigned to a check payment.

Receipt Number _____________________.

Click Exit.

Steps

Follow these steps to create a duplicate receipt

Access the Receipt Form (TGARCPT).

Enter the Receipt Number.

Perform a Next Block function.

Notice the information that displays on the form after you enter the Receipt Detail block (e.g., the name on the account, the date of the transaction, and the cashier who processed the transaction).

To print a duplicate receipt, select Print Receipt from the Options menu.

Note: TGRRCPT must be running in sleep/wake mode for the defined printer for a receipt to be printed.

Click Exit.

Access the Account Detail Form (TSADETL).

Perform a Next Block function.

Query the account for only CHEK detail code transactions.

Select Display Receipt from the Options menu to go to the Receipt Form (TGARCPT).

Select Print Receipt from the Options menu to print a duplicate receipt.

Note: TGRRCPT must be running in sleep/wake mode for the defined printer for a receipt to be printed.

Use the Receipt Query Form (TGIRCPT)

Introduction

The Receipt Query Form (TGIRCPT) is used to view and copy receipts.

View receipts

View receipts based on the type of receipt entered previously, and produce a duplicate copy.

Note: Since miscellaneous transactions entered on TFAMISC/TSAMISC do not appear in an account, this is the only form in Banner Student Accounts Receivable where the transactions entered on those forms may be viewed.

Access the Receipt Query Form (TGIRCPT).

Select the desired receipt category in the Key block. For this exercise, select Transaction Receipts.

Perform a Next Block function.

Query on one or more fields to locate transactions performed in previous lessons. (For example, you could query on the ID of the student or non-student you have worked with recently, or query for a specific set of receipt numbers.) Execute the query.

Examine the records that match your executed query. The highlighted record on the left side of the form will have more information available in the Receipt Detail block (on the right side of the form).

The Type field will indicate the display category selected. Use the horizontal scroll bar under the Name field to access additional information.

Select Print Receipt from the Options menu to send the selected receipt to the destination printer designated on the Accounts Receivable Distribution Initialization Form (TOADEST).

Note: TGRRCPT and/or TGRMISC must be running in sleep/wake mode for the defined printer for a receipt to be printed.

Click Exit.

Review and Close Cashier Sessions

Introduction

The Accounts Receivable module supports online processing of all types of payments and charges. A cashiering session is created whenever charge or payment activity is entered into the system.

The data entry forms listed below are used for the cashiering function. Individual cashier review and supervisory checkout of cashiers ensures that all funds are properly accounted for and that all accounting entries are properly sent to the Finance system.

Steps

Follow these steps to review and audit a cashiering session.

Access the Cashier Session Review Form (TGACREV).

Enter your Banner User ID. The Session number should default to 0, allowing you to view the current open/active session.

The current session for the user is always ‘0’. A number will be assigned by the system when the session is closed.

Click Save.

Next block to access the Session Detail Selection block.

Select Display User Sessions from the Options menu to access data from past cashiering sessions.

Perform a query for the first session of this cashier’s User ID.

Click Return in the Options menu to go back to the Cashier Session Review Form.

Perform a Next Block function to access the Cashier Session Summary block. This block will be populated with all payment and charge transactions that have been processed in the current session.

Review the summary of all the cashiering completed in this session. If there is more data than what displays on the screen, scroll to the end using the scroll bar on the right side of the form.

This block displays data in summary by detail codes. Query the Cashier Session Summary block for specific detail codes.

From the toolbar, click on Block and Previous .

In the Payment/Charge field, enter P (Payment).

In the Category field, enter CSH (Cash).

Next block to access the Cashier Session Summary block. The block should populate with the transactions matching your criteria.

Select Review Cashier Session Detail from the Options menu.

All processing is shown by detail transaction.

Note: The occurrences for the student who has been followed in this workshop. If there is more data than what displays on the screen, scroll to the end.

Return to the Session Detail Selection block and select all payments by entering P in the Payment / Charge field. View all the payment information entered in the Cashier Session Summary block.

Select Review Cashier Session Detail from the Options menu to review the information there.

Click Options and Review Session Detail/Summary to return to the Session Detail Selection block.

Select all charges by entering C in the Payment/Charge field.

Perform a Next Block function to view all the charge information entered in the Cashier Session Summary block.

Select Review Cashier Session Detail from the Options menu to review the information there.

Click Options and Review Session Detail/Summary to return to the Session Detail Selection block and select any category by entering the appropriate category code in the Category field.

Perform a Next Block function to view the information in the Cashier Session Summary block.

Perform a Next Block function to view the information in the Session Detail Selection block.

Click Options and Review Session Detail/Summary to return to the Session Detail Selection block and remove the Payment/Charge and Category field values.

Perform a Next Block function.

Enter a Query, enter a T in the Source field, and Execute a Query.

Click on Display Totals in the Options menu for the total of all transactions displaying from the query you performed.

Click Return.

Perform other queries using both positive and negative amounts as well as greater than or less than amounts (>100, <350) and combinations of the fields on the Cashier Session Detail block.

Close the session by selecting Close Session from the Options menu.

The instructor can also explain how to close sessions automatically by using the Cashier Session Close (TGRCLOS) process. This report/process can close/finalize a session based on the transaction’s source code. There is an indicator on the Charge/Payment Source Code Validation Form (TTVSRCE) that ties the ability to auto-close a session with the source code.

Notice how the Session number changes at the top of the form.

Select Display User Sessions from the Options menu. The session now appears in the closed session query.

Notice the C in the Status field indicating that the session is closed.

Click Exit.

Adjust a Closed Session – Regular

Introduction

The User Profile Definition Form (TGAUPRF) is used to identify users as supervisors and to assign cashiers to a supervisor. You can, also, restrict users to the processing of specific categories of transactions and transaction types.

Steps

Adjust a closed session for a simulated data entry error. The adjustment updates the individual’s account and the cashier session totals, but does not create a new session.

A payment entered by another cashier (in this case, another class member) needs to be reversed.

Ensure that you have supervisor privileges by querying the User Profile Definition Form (TGAUPRF).

All members of the class should have closed their sessions. Ask another class member for his/her User/Session ID and Session Number and record them below:

User/Session ID: ______________________________

Session Number: _______________________

Find an “incorrect” cash type payment on an individual account.

Review the details of that cashier session using Direct Access to call the Cashier Session Review Form (TGACREV).

Enter the Session User ID and the Session Number recorded above and save the data.

Access the Cashier Session Detail block and find the receipt in question. Assume one of the entries that had an Account ID and name was entered incorrectly. Write the Account ID, detail code and Amount below:

ID: __________________________________

Detail code: ___________________________

Amount: ______________________________

Using Direct Access, Access the Account Detail Form - Student (TSADETL) or the Account Detail Review Form – Student (TSAAREV).

Enter the ID Number of the account that has the error.

Steps

Follow these steps to adjust a closed session

Select Process Supervisory Adjustment from the Options menu.

Enter the Cashier User/Session ID and Session Number of the Cashier session being adjusted.

Click Return

Notice that the User field displays the Cashier whose session is being adjusted.

Click the Next block icon.

Query for the detail code that was recorded by entering the code in the Detail Code field. You will return all detail codes that match the code you are trying to locate.

Locate the transaction that you recorded above as being in error.

Insert a blank record.

Enter the same detail code with a negative adjusted amount. Indicate a short reason for the adjustment in the Description field.

Insert another blank record. Enter a different detail code with a positive amount.

Click Save.

The instructor will discuss the options for reversing the transaction and entering the correct transaction.

Click Exit.

Access the Cashier Session Review Form (TGACREV).

Notice the additional transaction and the adjusted session totals.

Click Exit.

Access the Account Detail Form (TSADETL).

The adjustment just made should be the first transaction record.

Click on the first transaction record.

Select Create Additional Text from the Options menu to enter a more thorough explanation for the adjustment.

Click Save.

Click Return.

The Text flag for the detail transaction has been set to Y by the system. To view the comments, simply click the icon to the right of the Text box.

Click Exit.

Adjust a Closed Session – Miscellaneous

Introduction

The Cashier Session Review Form (TGACREV) can be used to adjust closed sessions.

Steps

Adjust a closed session for miscellaneous transactions.

Access the Cashier Session Review Form (TGACREV).

Using the same Cashier User ID and Session Number as previously, find the miscellaneous transactions by entering the Session User and Session Number and saving the data.

Perform three Next Block functions to access the Cashier Session Detail block.

A miscellaneous transaction can be identified with an S in the Source field. It does not have an ID number.

Select a transaction for adjustment. Record the receipt number of the miscellaneous transaction below:

Receipt Number: ____________________________

Click the Exit icon.

Access the Miscellaneous Transaction Form – Finance (TFAMISC).

Select Process Supervisor Adjustment from the Options menu.

Enter the other cashier’s Cashier User ID and Session Number.

To reverse the original entry, switch the entry of the detail codes between the Debit code and the Credit code fields. Enter the same amount and General Ledger Account information. Change the Description field to Reverse Receipt #x.

Click Save, then Exit.

Return to the Cashier Session Review Form (TGACREV) and the Cashier Session Detail block.

Notice the additional entry and the revised session totals.

Click Exit.

Finalize a Cashier Session

Introduction

The Cashier Supervisory Form (TGACSPV) is used to finalize a cashier session.

Steps

Finalize cashier sessions for daily cash deposit.

Access the Cashier Supervisory Form (TGACSPV).

The cursor appears in the Active Cashier Session Query block and only the current active sessions are displayed. These sessions have not been closed.

Select Review Inactive Cashier Sessions from the Options menu.

These sessions are either in C (Closed), F (Finalized), or R (Reported) status.

Perform a query. Entering your user ID in the User field. The system displays all inactive sessions for your user ID.

Perform additional queries using combinations of the available fields such as User, Status, Start (date), and End (date).

Select a closed session with a status of C.

Finalize the session by putting an F in the Status field.

Click in the Bank field and select an appropriate code from the Bank Code Query Form (GXIBANK).

The above step is optional as the bank is defined on the rule class codes.

Enter a deposit number in the Deposit Number: field.

The above step is also optional as not all clients have numbered deposit tickets.

Click Save.

Click Exit.

Auto Refunding of Credit Amounts

Introduction

This process has two steps. First, accounts that have a credit balance are identified, flagged, and reported. Second, after manual review of the accounts, the flagged accounts are updated with a refund detail code for the amount of the credit balance and listed on the report.

When you run the process in FLAG mode, the selected accounts are listed on the Refund Review Form - Student (TSARFND). Users uncheck the Refund Indicator for accounts they do not wanted selected by the process when it is run in RFND mode.

Steps

Access the Auto Refunding of Credit Amount Process (TSRRFND).

Perform a Next Block function.

Type DATABASE into the Printer field.

Perform a Next Block function.

Enter the following information in the appropriate fields in the Parameter Values block.

Field	Value
01 – Flag/Refund Mode	FLAG
02 – Audit/Update Mode	U
03 – Refund A(LL) or T(IV) only	A
04 – Minimum Credit Balance	-1
05 – Address Selection Date	SYSDATE
06 – Address Type Hierarchy	1PR
07 – Refund Detail Code	Leave Blank
08 – Cashier User ID	Leave Blank
09 – Process Term	Leave Blank
10 – Entity Type (P/C/%)	%
11 – Detail Code Hierarchy	Leave Blank
12 – Include/Exclude mode	Leave Blank
13 – Selection Term	200910
14 – Print Account Detail	Y
15 – Except Term	Leave Blank
16 – Selection identifier	Leave Blank
17 – Application Code	Leave Blank
18 – Creator ID	Leave Blank
19 – User ID	Leave Blank

Perform a Next Block function.

Click Save.

Click Review Output (GJIREVO) in the Options menu.

Double click in the File Name field and select the lis file.

Review the information about the select accounts.

Click Exit.

Click Exit.

Access the Refund Review Form - Student (TSARFND).

Scroll through the list of accounts to see everyone selected by the Auto Refunding of Credit Amounts Process (TSRRFND).

Uncheck the Refund Indicator for any accounts you to not want refunded by the Auto Refunding of Credit Amounts Process (TSRRFND) for the amount listed in the All Refunds column.

Click Save.

Click Exit.

Access the Auto Refunding of Credit Amount Process (TSRRFND).

Perform a Next Block function.

Type DATABASE into the Printer field.

Perform a Next Block function.

Enter the following information in the appropriate fields in the Parameter Values block.

Field	Value
01 – Flag/Refund Mode	RFND
02 – Audit/Update Mode	A
03 – Refund A(LL) or T(IV) only	A
04 – Minimum Credit Balance	-1
05 – Address Selection Date	SYSDATE
06 – Address Type Hierarchy	1PR
07 – Refund Detail Code	RFND
08 – Cashier User ID	SAISUSR
09 – Process Term	200910
10 – Entity Type (P/C/%)	Leave Blank
11 – Detail Code Hierarchy	Leave Blank
12 – Include/Exclude mode	Leave Blank
13 – Selection Term	Leave Blank
14 – Print Account Detail	Leave Blank
15 – Except Term	Leave Blank
16 – Selection identifier	Leave Blank
17 – Application Code	Leave Blank
18 – Creator ID	Leave Blank
19 – User ID	Leave Blank

Perform a Next Block function.

Click Save.

Click Review Output (GJIREVO) in the Options menu.

Double click in the File Name field and select the lis file.

Review the information about the select accounts.

Make sure that all of the accounts have an address, because refund checks cannot be produced if there is no address. For accounts without an address, go to back to the Refund Review Form (TSARFND), uncheck the Refund Indicator for those accounts, and Save.

Click Exit.

Perform a Next Block function.

Type DATABASE into the Printer field.

Perform a Next Block function.

Enter the following information in the appropriate fields in the Parameter Values block.

Field	Value
01 – Flag/Refund Mode	RFND
02 – Audit/Update Mode	U
03 – Refund A(LL) or T(IV) only	A
04 – Minimum Credit Balance	-1
05 – Address Selection Date	SYSDATE
06 – Address Type Hierarchy	1PR
07 – Refund Detail Code	RFND
08 – Cashier User ID	SAISUSR
09 – Process Term	200910
10 – Entity Type (P/C/%)	Leave Blank
11 – Detail Code Hierarchy	Leave Blank
12 – Include/Exclude mode	Leave Blank
13 – Selection Term	Leave Blank
14 – Print Account Detail	Leave Blank
15 – Except Term	Leave Blank
16 – Selection identifier	Leave Blank
17 – Application Code	Leave Blank
18 – Creator ID	Leave Blank
19 – User ID	Leave Blank

Perform a Next Block function.

Click Save.

Click Review Output (GJIREVO) in the Options menu.

Double click in the File Name field and select the lis file.

Write down an ID from the report.

ID:

Review the information about the select accounts.

Click Exit.

Click Exit.

Access the Account Detail Review Form - Student (TSAAREV).

Enter an ID in the ID field from the lis file from the Auto Refunding of Credit Amounts Process (TSRRFND).

Perform a Next Block function.

The top transaction with be the refund that was posted by the Auto Refunding of Credit Amounts Process (TSRRFND).

Click Exit.

Reconciling Accounts Receivable to Finance

Introduction

Accounts Receivable should be reconciled to Finance every night, as well as at the end of every financial period. This section discusses the steps by which the nightly reconciliation and feed occur, as well as ways to troubleshoot any issues that may be uncovered.

Objectives

In this section you will learn how to:

use Best Practices in the Nightly Feed to Finance process

generate the Accounting Feed Report

run the Accounts Receivable Reconciliation Report

read the Accounts Receivable Reconciliation Report

balance Accounts Receivable to Finance.

Nightly Feed to Finance Best Practice

Introduction

SunGard Higher Education recommends these steps as the best practice for reconciling and feeding Accounts Receivable transactions to Finance each night.

Steps

Cashier manually closes his or her open cashier session, using the Cashier Session Review Form (TGACREV).

Supervisor verifies bank deposits and finalizes closed cashier sessions, using the Cashier Supervisory Review Form (TGACSPV).

Run the automated session close for sessions that do not contain cash transactions, using the Cashier Session Close process (TGRCLOS). Set it to run at Midnight so it will correspond with the bank statement.

Set Parameter 01 Close or Finalize Serssions to B for both – close and finalize.

Set Parameter 04 Detail Category Code Exception to CSH for cash and checks, as well as to the category code for credit cards and credit payments (this would be something other than CSH).

Set Parameter 05 Close Sessions Containing Depo to Y.

Set Parameter 06 Close Sessions Containing Misc to Y.

Run the Cashier Detail Report (TGRCSHR) to review the detail of what is being fed to Finance. Always update finalized cashiers to R, (set Parameter 08 Update Finalized Sessions to R to Y).

Run Application of Payment process (TGRAPPL) to apply payments to open charges, and print an application of payment roster. Use the Parameter Definitions Form (GJAPDEF) to verify that the default parameter settings on TGRAPPL are the standard parameters used by your institution on a regular basis.

The Pending Roster need not be printed at this time. To print, set Printer field to correct printer definition.

Run the Un-application of Payment Process (TGRUNAP).

Set Parameter 01 Run Mode ( S, U, B ) to B for (B)oth select and unapply.

Set Parameter 02 Unapply Automatically Y or N to Y.

A Population Selection is not needed on the nightly run unless the institution is targeting a set population.

Run the Application of Payments process again (TGRAPPL) to re-apply any unapplied transactions, and make sure to print the application of payment roster (set Parameter 09 to Y).

Optionally, run the Cashier Delete/Report Process (TGRCDEL).

Run the Accounting Feed Process (TGRFEED) to feed closed and finalized cashier session transactions to the Finance Table (GURFEED).

Run two Aging Analysis Report (TGRAGES) as of today.

First Run:

Set Parameter 01 Age Date B-Bill E-Eff D-Due to E.

Set Parameter 02 Range Date 1 to 0

Set Paramter 03 Range Date 2 to 1

Set Parameter 04 Range Date 3 to 2

Set Parameter 05 Minimum Account Balance to -999,999,999.99

Set Parameter 06 Maximum Account Balance to -.01

Set Parameter 08 As of Date (DD-MON-YYYY) to Today’s Date in the format indicated.

Second Run

Set Parameter 01 Age Date B-Bill E-Eff D-Due to E.

Set Parameter 02 Range Date 1 to 0

Set Paramter 03 Range Date 2 to 1

Set Parameter 04 Range Date 3 to 2

Set Parameter 05 Minimum Account Balance to .01

Set Parameter 06 Maximum Account Balance to 99,999,999.99

Set Parameter 08 As of Date (DD-MON-YYYY) to Today’s Date in the format indicated.

Run the Accounts Receivable Reconciliation Report (TGRRCON) immediately upon the submission of the Aging Analysis Report. Use it to reconcile Accounts Receivable balance to the Aging Analysis Report. Leave all Starting and Ending dates blank, unless Parameter 4 Miscellaneous Reconciliation is set to Y, then enter date range for the Miscellaneous transactions, (Parameters 5 & 6).

Run the Finance Sweep process (FURFEED).

Run the Refund Interface process (FURAPAY).

Run the Interface process (FGRTRNI).

Run the Transaction Error Report (FGRTRNR).

Run the Posting Process (FGRACTG).

Optionally, run the Accounts Receivable Reconciliation Report (TGRRCON) and the Aging Analysis Reports (TGRAGES) after steps 16, rather than before step 12.

Note that unless transactions have been stopped on the Transaction Error Report (FGRTRNR), the Pending GURFEED and In Transit should be zero, and the Adjusted Net Feed should be tied to the G/L account at the end of the report.

The AR Balance (column 5) should change based on transactions, mainly web (24/7) transactions, and when TGRRCON is run it reports on the current AR transactions. It cannot go back and report on a point in time prior to when the report is run.

Additional Recommendations

Place nightly jobs in a job scheduler.

Make sure reconciliation issues are investigated the day they are found.

Have transactions stopped from Self-Service Banner during month-end and year-end feeds to Finance. This ensures a clean cut off and true representation of AR balances.

Run the Aging Analysis Report (TGRAGES) multiple times with different date ranges and min and max account amounts during month-end and year-end for a clearer picture of aging and assist in reconciliation issues.

Generate the Accounting Feed Report

Introduction

The Accounting Feed Process (TGRFEED) is used to send the accounting information to the Finance system.

Steps

Review the process for sending the accounting information for the day to the Finance System (for Banner Finance clients) and/or generate a report of the accounting information for the day.

Access the Process Submission Control Form (GJAPCTL).

The instructor will demonstrate this process using the instructions below.

Enter TGRFEED in the Process field.

(This report (TGRFEED) can also be opened through Direct Access.)

Access the Printer Control block. Enter DATABASE in the Printer field.

Access the Parameter Values block. The instructor will demonstrate how to enter multiple address hierarchies.

Access the Submission block and save the data (check the Submit field).

The instructor will explain the information that appears on the report.

Running the Accounts Receivable Reconciliation Report

Introduction

The Accounts Receivable Reconciliation Report (TGRRCON) enables you to reconcile receivable information to your General Ledger accounts. It displays the current General Ledger balances for Banner Finance schools, to help you identify out-of-balance conditions, reflecting any amounts that have not yet been posted to the General Ledger.

This report accesses accounting information based on term code and designator code. Term-based transactions are processed by using either the feed date or the system date. For miscellaneous transactions, the report uses the default designator code from the Student Billing Control Form (TSACTRL) to access the accounting information to be reconciled to the Banner Finance System. The last page of the report summarizes the transaction information that displays on the report.

TGRRCON is a snapshot of thc receivable ledger using the current accounting of the detail code. If any changes are made to the General Ledger side of the detail codes, then it is necessary to use a journal to move the outstanding balance in the General Ledger to that account.

Banner form

Steps

Follow these steps to run the A/R Reconciliation Report

Access the A/R Reconciliation Report Process (TGRRCON).

Click the Next Block icon to access the Printer Control block.

In order to view the results of the process on your computer screen directly, enter DATABASE into the Printer field. In order to print the results of the process on a particular printer, enter it’s identifier into the Printer field.

After entering the correct printer information in the Printer Control block, click the Next Block icon.

Set the following parameters in the PARAMETERS VALUE block:

Parameter 01 Account Detail Reconciliation to Y

Leave Parameter 02 Starting Feed Date for Detail blank

Leave Parameter 03 Ending Feed Date for Detail blank

Parameter 04 Miscellaneous Reconciliation to Y (if reconciling misc. receipts)

Parameter 05 Starting Feed Date for Misc to beginning date (if reconciling misc. receipts) in format DD-MON-YYYY

Parameter 06 Ending Feed Date for Misc to end date (if reconciling misc. receipts) in format DD-MON-YYYY

Parameter 07 Deposit Reconciliation to Y (if using deposits)

Parameter 08 Original or Current Accounting to	C

Click the Next Block icon.

Click the Save icon.

Note: If reconciling miscellaneous transactions, the date range should be from the last time a reconciliation was done to the current date (unless troubleshooting and looking for specific date related information)

Reading the A/R Reconciliation Report

Introduction

The columns on the A/R Reconciliation Report are as listed:

Column	Column Header	Description
1	TOTAL FED	Column 5 minus column 4. The net between what is in A/R and what has not yet fed is the amount previously fed.
2	APPLIED NOT FED	If there is a different between TBRACCD_BALANCE and TBRACCD_AMOUNT, it is due to application of payment. If the application transaction (TBRAPPL) has not been fed, then the A/R BALANCE has been reduced, but the TOTAL FED has not, and the amount must be added back.
3	ADJ FED TOTAL	Column 1 plus column 2 - Adding unfed application reductions back in gives an adjusted total for the G/L which should now match the ledger balances, as long as all feed documents created have posted.
4	TOTAL NOT FED	This will be either the TBRACCD_AMOUNT (not balance) for any transaction that has not fed, or .00. If a new transaction has not yet been fed, and the feed indicator is not F, the new transaction is reflected on the A/R side but not in the G/L.
5	A/R BALANCE	This is the outstanding balance column of TBRACCD. This column represents the actual outstanding A/R balances at the time the report is run.

Processing Detail

An initial transaction creates A/R BALANCE, but has an equal TOTAL NOT FED, so TOTAL FED, ADJ FED TOTAL and the G/L are .00.

When the initial session is closed and fed, TOTAL NOT FED goes to .00, TOTAL FED, ADJ FED TOTAL, and the G/L match the A/R BALANCE which is still the original amount.

When the payment is applied but not fed, A/R BALANCE is reduced by the amount of the payment, APPLIED NOT FED is increased by the amount of the payment, and ADJ FED TOTAL matches the G/L and is still the original amount. (At this point, the TOTAL FED column does not reflect anything real.)

When the application transaction is fed, then APPLIED NOT FED is back to .00, and TOTAL FED, ADJ FED TOTAL, and A/R BALANCE all match each other and the G/L, representing the net outstanding balance. This should be the case for the whole report if all sessions have been closed and fed.

Summary Section

The TGRRCON report provides detailed information of pending transactions in a summary section which includes the information identified in the following chart.

Column	Column Header	Description
1	Total Fed	The total amount of the A/R balance less the amount not fed.
2	Pending GURFEED	Amount waiting to be fed through the Finance Transaction Input Table (GURFEED)
3	In Transit	Total amount fed through GURFEED but not yet reflected in the G/L balance.
4	Adjusted Net Fed	Column 1 minus Column 2 minus Column 3. This total includes the amount fed, less the transactions that are still in process in Finance.
5	G/L Balance	G/L Balance, not including the pending amount(s)
6	Difference	Column 5 minus Column 4. Difference between the Adjusted Net Fed column and the G/L Balance.

Banner form

Steps

After running the A/R Reconciliation Report, open the report on your screen or obtain it from the printer.

First section (pages 1 & 2, above) – Errors. Some errors you may encounter are:

Percentage of accounting greater than 100.00

Missing Designator for term

Accounting missing for detail code

Second section – Open receivables

All charge detail codes with an open balance

Summed by accounting unit based on the A account of charge detail codes

Third Section – Unapplied Payments

All payment detail codes with an open balance

Summed by accounting unit based on the B account of the payment detail code

Fourth section – Summary section of Open Receivables/Unapplied Payments

Sums by accounting unit, both Open Receivables and Unapplied Payment accounts

List the amount in GURFEED that has not been moved to Finance.

For Banner Finance Clients only:

List the amount transferred to Finance, but not posted to the GL accounts

List the GL balances from Finance

List the difference from the GL balance to the adjusted AR balance

Fifth section – Miscellaneous Transactions (if parameter 04 = Y)

List miscellaneous transactions based on the date range entered

List each transaction and if fed or not fed.

List the detail code and the accounting unit.

Does not list any GL information

Sixth section – Deposits

List deposits that have not been released

summed by accounting unit and payment detail code

Seventh section – Summary section for Deposits

Summed by accounting unit

List what has not been transferred from GUREED

Banner Finance Clients

List what has been transferred to finance but not posted to the GL

List the GL balance

List the difference between the GL and the Adjusted AR balance.

Balancing A/R to Finance

Introduction

Follow the steps described in this lesson to balance accounts receivable to finance.

Steps

Check for errors at the beginning of the A/R Reconciliation Report. Some errors you may encounter are:

Percentage of accounting greater than 100.00

Missing Designator for term

Accounting missing for detail code

Check the summary section of the A/R Reconciliation Report. This section is after the Open Receivables section and after the Unapplied Payments section

Banner Finance clients:

Transactions still in GURFEED and moved from GURFEED but not posted to AR is reported and used to adjust the ending AR balance

The difference between the adjusted AR balance and the GL will be listed

Non-Banner Finance clients:

Only transactions in GURFEED will be listed and used to adjust the ending AR Balance

No difference between the adjusted Ar balance and the institutions GL will be listed.

Non-Banner Finance clients will need to obtain the GL balances manually or through an institutional report.

Investigate and begin to reconcile any account that is not in balance

Check for manual entries in the GL account

Check for accounting changes behind the detail codes associated with the account that is out of balance.

Verify that the TGRRCON report balances with the TGRAGES reports.

Add the Open Receivables and Unapplied Payments

Add the totals from the negative aging report and positive aging report.

Compare the two totals. They should be equal.

Review of Accounts Receivable

Self Check

Directions

Use the information that you have learned in this workbook to complete this self check activity.

Question 1

How are detail codes defined?

Question 2

Why are detail codes so important?

Question 3

How can fees be accessed immediately on the Student Course Registration Form?

Question 4

List the four forms that are used to view fee assessments.

Question 5

What are the two steps required to produce a schedule bill?

Question 6

Who gets a schedule bill?

Question 7

What are the four items that make up the selection rules?

Question 8

What must happen in order for a schedule/bill to be produced?

Question 9

Think of some examples at your institution that would require a Non-person entry.

Question 10

List any codes that you think may be used at your institution.

Question 11

What functions can a Supervisor perform?

Question 12

When should contracts be established?

Question 13

Each contract must be established as one of what three levels?

Question 14

How are third-party contracts billed?

Question 15

What are some of the features of the Exemption Authorization Form?

Question 16

What are the recommendations for querying the Account Charge/Payment Detail Table?

Question 17

List some of the information that can be found on the Student Account Detail Form.

Question 18

How does entering a future effective date affect the Account Balance and Amount Due fields?

Question 19

How are transactions sequenced on the Account Detail Review Form – Student?

Question 20

A student has requested a copy of his/her account transactions. How can you get them this information?

Question 21

What type of information is displayed on the Account Review Form (TSAACCT)?

Question 22

What is the difference between the Query Balance field and the Account Balance field on the Account Detail Review Form – Student (TSAAREV)?

Question 23

What types of charges are accessed on the Student Payment Form (TSASPAY)?

Question 24

List some of the features of the Student Payment Form (TSASPAY).

Question 25

What does it mean when the Balance and Charge or Payment fields are different on the Account Detail Review Form?

Question 26

What happens once a payment is directly applied?

Question 27

On which forms can payments be unapplied?

Question 28

What processes take place when the Application of Payment Batch Process (TGRAPPL) is run?

Question 29

Where can the results of the Application of Payment Batch Process be viewed?

Question 30

What is the significance of the Feed Future Effective Transactions checkbox?

Question 31

In what types of ways can payments be unapplied?

Question 32

Which applications cannot be unapplied?

Question 33

What are the two forms used to collect money that is not applied to a specific account?

Question 34

On which forms can the NSF flag field be viewed?

Question 35

What form must be modified to allow for the ability to auto-close a session?

Self Check – Answer Key

Question 1

How are detail codes defined?

They are defined as either a charge or a payment.

Question 2

Why are detail codes so important?

Detail codes are the most important items linking the Accounts Receivable module to the General Ledger. Behind each detail code is an accounting distribution and a series of Finance Rule Classes that determine the postings made to the General Ledger. Detail codes create the accounting transactions that are fed to the General Ledger through the interface process.

Question 3

How can fees be accessed immediately on the Student Course Registration Form?

Fees are assessed immediately by clicking the Save icon.

Question 4

List the four forms that are used to view fee assessments.

Registration Fees Process Control Form

Account Detail Review Form

Student/Course Fee Assessment Query Form

Registration Fee Assessment Audit History (SFAFAUD)

Question 5

What are the two steps required to produce a schedule bill?

Set up the schedule bill parameters on the Schedule/Bill Rues Form (TSASBRL)

Run the Student Invoice/Billing Process (TSRCBIL) to produce a schedule bill.

Question 6

Who gets a schedule bill?

The system determines who gets a schedule/bill using the parameters entered when submitting the Student Invoice/Billing Statement Process (TSRCBIL) in conjunction with the data input on the Schedule/Bill Rules Form (TSASBRL).

A schedule/bill can be produced for an individual or for a group of students.

Question 7

What are the four items that make up the selection rules?

Exclude students not allowed to register

Exclude students who do not count in enrollment

Course required

Account billable.

Question 8

What must happen in order for a schedule/bill to be produced?

All selection criteria must be satisfied.

Question 9

Think of some examples at your institution that would require a Non-person entry.

Answers are on an individual basis.

Question 10

List any codes that you think may be used at your institution.

Answers are on an individual basis.

Question 11

What functions can a Supervisor perform?

The User ID can perform supervisory functions on the Cashier Supervisory Form (TGACSPV) and session adjustment transactions on the Miscellaneous Transaction Forms (TFAMISC and TSAMISC), the Account Detail Forms (TSADETL), and the Student Account Detail Review Form (TSAAREV).

Question 12

When should contracts be established?

Before the beginning of the Billing process

Question 13

Each contract must be established as one of what three levels?

Account level, category level, or detail level

Question 14

How are third-party contracts billed?

Via the Third Party Invoice/Statement Process (TSRTBIL)

Question 15

What are some of the features of the Exemption Authorization Form?

Established as an account level, category level, or detail level

Based on a percentage

Maximum amount to be paid by the exemption

Minimum amount to be paid by the student

Question 16

What are the recommendations for querying the Account Charge/Payment Detail Table?

Allow a select group of users to have access to this form

Perform queries in an efficient manner

Question 17

List some of the information that can be found on the Student Account Detail Form.

Student’s credit limit

charges

payment history

comments

account balances

due dates

Question 18

How does entering a future effective date affect the Account Balance and Amount Due fields?

The new charge is applied to the Account Balance, but does not get applied to the Amount Due until that effective date nears.

Question 19

How are transactions sequenced on the Account Detail Review Form – Student?

Transactions are sequenced in ascending order by the most recent activity.

Question 20

A student has requested a copy of his/her account transactions. How can you get them this information?

To print a Student Transaction Summary, access Print Detail from the Options menu within the Account Detail Review Form – Student.

Question 21

What type of information is displayed on the Account Review Form (TSAACCT)?

Overall account summary data is displayed, including account status, balances including future and aging balances, exemptions, third party contracts, collection agency assignments, and installment plan information.

Question 22

What is the difference between the Query Balance field and the Account Balance field on the Account Detail Review Form – Student (TSAAREV)?

The Query Balance field reflects the total amount of the selected transactions only. The Account Balance field reflects the overall account.

Question 23

What types of charges are accessed on the Student Payment Form (TSASPAY)?

Student registration and housing charges not previously accessed in the individual modules.

Question 24

List some of the features of the Student Payment Form (TSASPAY).

The Student Payment Form calculates exemptions and contracts for eligible students and releases any deposits set to automatically release. It can also display the available Financial Aid if it is interfaced with the institution’s Financial Aid system.

Question 25

What does it mean when the Balance and Charge or Payment fields are different on the Account Detail Review Form?

When the fields are not equal, payments and charges have been applied to one another according to the Application of Payments priorities of each detail code defined on the Detail Code Control Form – Student.

Question 26

What happens once a payment is directly applied?

The payment cannot be unapplied.

Question 27

On which forms can payments be unapplied?

Account Detail Review Form (TSAACCT)

Unapply Transactions option within the Account Detail Review Form – Student (TSAAREV)

Student Unapplication of Payment Form (TSAUNAP)

Question 28

What processes take place when the Application of Payment Batch Process (TGRAPPL) is run?

Payment is applied to a charge, reversed charge is applied to a charge, or payment is applied to a reversed payment.

Question 29

Where can the results of the Application of Payment Batch Process be viewed?

Application of Payment Query Form (TSIAPPL)

Question 30

What is the significance of the Feed Future Effective Transactions checkbox?

If this checkbox is checked, then the effective date is not used (I.e., all transactions are candidates for application of payments). If this checkbox is not checked, the Application of Payments process will only apply to those transactions that have a current or less than current effective date. Future charges or payments will not be applied until they become effective.

Question 31

In what types of ways can payments be unapplied?

For a specific transaction number, term, or effective date.

Question 32

Which applications cannot be unapplied?

Direct application of payment transactions cannot be unapplied and the transaction will not show up on the Unapplication of Payment Form.

Question 33

What are the two forms used to collect money that is not applied to a specific account?

The Miscellaneous Transaction Form – Student (TSAMISC) and Miscellaneous Transaction Form – Finance (TFAMISC)

Question 34

On which forms can the NSF flag field be viewed?

TSADETL, TSASPAY, and TSAAREV

Question 35

What form must be modified to allow for the ability to auto-close a session?

The indicator on the Charge/Payment Source Code Validation Form (TTVSRCE) ties the ability to auto-close a session with the source code.

Appendix

Forms Job Aid

Form	Full Name	Use this Form to...
FGRACTG	Posting Process	post financial transactions to the system, typically runs automatically every few minutes.
FGRTRNI	Interface Process	perform edits on the records and either write the records to the suspended journal voucher file or approved posting table.
FGRTRNR	Transaction Error Report Process	list financial transactions with errors.
FURAPAY	Refund Interface Process	sweep the Generic Interface Process (GURAPAY) and feed refund transactions to the Finance System.
FURFEED	Finance Sweep	sweep the Generic Interface table (GURFEED) and write the records into the Interface table (FGBTRNI).
GJAPDEF	Parameter Definitions Form	identify parameters for a report or process, establish validation characteristics for those parameters, define defaults for the parameters.
GOAMTCH	Common Matching Entry Form	Use Common Matching functionality to verify that new IDs do not exist in the system.
ROAINST	Institution Financial Aid Options Form	define institutional options, dates and defaults for an aid year.
SAAQUIK	Quick Entry Form	register students for courses.
SFAFAUD	Registration Fee Assessment Audit Form	displays the calculations used to determine the fee assessment and refund amounts.
SFAREGF	Student Course/Fee Assessment Query Form	display a student’s enrollment status and course registration for the term.
SFAREGS	Student Course Registration Form	admit a student into the system for use in the Fee Assessment and Payment process
SFARGFE	Registration Fees Process Control Form	Review Fee Assessment rules
SPAIDEN	Identification Form	Create a new non-person in the system.
STVESTS	Enrollment Status Code Validation Form	create, update, insert and delete enrollment status codes.
STVHLDD	Hold Type Code Validation Form	create, update, insert and delete hold type codes.
STVRSTS	Course Registration Status Code Validation Form	create, update, insert and delete registration status codes.
TGACOMC	Comment Central Form	add comments for student accounts
TGACPRF	Customer Profile Definition Form	identify a customer with an entity category, establish a credit limit, and append text to a customer's account.
TGACREV	Cashier Session Review Form	review and audit a cashiering session.
TGACSPV	Cashier Supervisory Form	finalize a cashier session.
TGAHOLD	Auto Holds Rules Form	define the rules for placing an account on hold and establish the relationship between a hold rule code and the type of hold placed on an account.
TGAMESG	Billing Message Form	enter the messages which appear on invoices and statements for specific accounts, delinquency codes, installment plans and collection agencies.
TGARCPT	Receipt Form	display and reprint previously processed receipts.
TGARETC	Returned Check Code Control Form	establishes penalty codes and amounts for returned checks, to be automatically assessed upon entry of a returned check code.
TGAUPRF	User Profile Definition Form	grant access to the Banner system
TGIACCD	Account Query Detail Form	query all records in the Account Charge/Payment Detail Table (TBRACCD) without specifying an ID number or to specify an ID number to view just one student account.
TGIRCPT	Receipt Query Form	view and copy receipts.
TGPHOLD	Auto Hold Release Process	release a specific hold from a specific population.
TGRAGES	Aging Analysis Report Process	analyze account balances as of a specified date.
TGRAPPL	Application of Payment Process	apply payments/receipts to specific account(s).
TGRCDEL	Cashier Delete/Report Process	delete specific cashiering session(s) after they have been fed to the accounting system.
TGRCLOS	Cashier Session Close Process	close and/or finalize cashiering sessions.
TGRCSHR	Cashier Detail Report	report on specific cashier(s) sessions and summary of transaction data by category.
TGRFEED	Accounting Feed Process	feed all charge and payment transactions to the accounting system.
TGRRCON	Accounts Receivable Reconciliation Process	display General Ledger accounts balances that have not yet been posted.
TGRUNAP	Unapplication of Payment Process	unapply transactions prior to application or re-application of transactions.
TSAABDS	Aid Year-Based Designator Rules Form	set the rules for the Aid Year-based designators.
TSAACCT	Account Detail Review Form	review account information about a specific account.
TSAADSP	Application Distribution of Single Payment - Student	indicate how Banner will distribute a payment among multiple charges.
TSAAREV	Account Detail Review Form – Student	enter charges and payments to a student's account and display information in a condensed format.
TSACONT	Contract Authorization Form	establish third party contract authorizations for student accounts.
TSACTRL	Student Billing Control Form	enter the parameters for the operation and control process for Student Accounts Receivable.
TSADETC	Detail Code Control Form – Student	create a new detail code and to perform queries based on the selection fields.
TSADETL	Student Account Detail Form	enter charges and payments by detail code and amount, and to create deposits and memo items
TSAEXPP	Exemption Person Authorization Form	add an exemption to a student
TSAEXPT	Exemption Authorization Form	create exemption authorizations for student accounts by term.
TSAISTA	Installment Plan Assignment Rules Form	create rules that automatically assign a student to an installment plan for a given term.
TSAISTC	Installment Plan Code Control Form	define the characteristics and default entry information for loans and time payments for an institution
TSAISTL	Student Installment Plan Form	process and post installment plans to a student’s account that have not been assigned using the automatic installment plan assignment functionality.
TSAISTP	Installment Plan Payment Form	assign a student to an installment plan, calculate installment plan transactions, and view installment plan payments.
TSAISTR	Installment Plan Payment Rules Form	define variables used to calculate the Installment principal amount.
TSAMASS	Billing Mass Data Entry Form	quickly enter charges and payments in amount form, deposits, and memo items and post multiple transactions.
TSAMISC	Miscellaneous Transfer Form – Student	to collect money that is not applied to a specific account.
TSASBRL	Schedule/Bill Rules Form	set up the schedule/bill parameters.
TSASPAY	Student Payment Form	enter a payment transaction.
TSATBDS	Term-Based Designator Rules Form	define the term-based rules that will be attached to detail codes to make them term-based detail codes
TSATPRL	Third Party Rules Form	define the rules that will determine how Banner prints the third party bills, and to establish the relationship between a third party rule code and how Banner will print the bills that use that rule code
TSAUNAP	Unapplication of Payments Form	unapply a payment for a specific transaction number, term, or effective date.
TSIAPPL	Application of Payment Review Form – Student	review the payments that have been applied to charges.
TSICSRV	Customer Service Form	have centralized access to student-related and accounts receivable-related information, including assign a student to an installment plan, calculate installment plan transactions, and view installment plan payments.
TSPISTA	Assign Installment Plans Process	assign students to an installment plan.
TSPISTT	Create Installment Plan Transaction Process	create installment plan transactions in the Accounts Receivable Transaction Detail table.
TSRCBIL	Student Invoice/Billing Statement Process	produce a multiple page invoice/statement. It can also produce a schedule/bill document
TSRLATE	Assess Penalty/Interest Charges Report	assess penalty and interest charges for accounts with past due balances.
TSRTBIL	Third Party Invoice/Billing Statement Process	produce a multiple page invoice/statement.
TTVABDS	Aid Year-Based Designator Validation Form	create, update, modify and delete aid year-based designator codes.
TTVAIDY	Aid Year Validation Form	create, update, modify and delete aid year codes, for non-Banner Financial Aid users.
TTVBILL	Bill Code Validation Form	insert, update and delete detail bill codes.
TTVDELI	Delinquency Code Validation Form	create, update and delete delinquency codes.
TTVRHLD	Auto Hold Validation Form	create and maintain rule codes used in automated hold and release processing.
TTVSBRC	Schedule/Bill Rules Code Validation Form	create and list valid Schedule/Bill rule codes.
TTVTBDS	Term-Based Designator Validation Form	define the term-based rules that will be attached to detail codes to make them term-based detail codes
TTVTPRC	Third Party Rules Code Validation Form	list valid rule codes