Banner Accounts Receivable / User Guide / 8

1 Banner Accounts Receivable user GuideRelease 2009 Trademark, Publishing Statement and Copyright NoticeSunGard or its subsidiaries in the and other countries is the owner of numerous marks, including SunGard, the SunGard logo, Banner , PowerCAMPUS, Advance, Luminis, fsaATLAS, DegreeWorks, SEVIS Connection, SmartCall, PocketRecruiter, UDC, and Unified Digital Campus. Other names and marks used in this material are owned by third parties. 1999-2009 SunGard. All rights confidential and proprietary information of SunGard and its subsidiaries. Use of these materials is limited to SunGard Higher Education licensees, and is subject to the terms and conditions of one or more written license agreements between SunGard Higher Education and the licensee in preparing and providing this publication, SunGard Higher Education is not rendering legal, accounting, or other similar professional services.

2 SunGard Higher Education 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 by: SunGard Higher Education4 Country View RoadMalvern, Pennsylvania 19355 United States of America(800) 522 - 4827 Customer Support Center Services E-mail History LogPublication DateSummaryAugust 2009 New version that supports Accounts Receivable software. ContentsBanner Accounts Receivable GuideAugust 2009 Banner Accounts Receivable GuideContentsChapter 1 System OverviewAccounts Receivable Process Flow .. 1-1 Process Flow Symbols .. 1-1 Process Flow .. 1-3 Process Flow Narrative .. 1-4 Chapter 2 Finance Accounts Receivable ProceduresEstablish Controls.

3 2-1 Establish Installment Plans .. 2-2 Enter/Update/Review Account Detail .. 2-2 Mass Entry of Charges/Payments .. 2-3 Display/Reprint Receipt .. 2-3 Review Accounts .. 2-3 Collect Miscellaneous Revenue .. 2-3 Review Cashiering Activity .. 2-4 Adjust Cashiering Activity .. 2-4 Automatic Cashier Close and Session Finalize .. 2-5 Process Application of Payments .. 2-5 Accounting Feed Process .. 2-6ivBanner Accounts Receivable 2009 user GuideContents Bill Accounts .. 2-6 Produce Aging Reports .. 2-6 Processing Holds/Releases Automatically .. 2-7 Assign Accounts to a Collection Agency .. 2-7 Produce Account Detail Report.. 2-7 Purge Account Detail .. 2-7 Deposit Procedure.. 2-7 Application of Payment Procedure .. 2-10 Priorities .. 2-14 Processing Grant Payments .. 2-14 Entering Free Form Account Numbers.. 2-15 Rule Code Processing in Miscellaneous Transaction Form.

4 2-15 Cashiering Procedure .. 2-16 Accounting Feed Procedure .. 2-19 Establish Accounts .. 2-20 Application of Payments .. 2-20 Accounting Feed Transactions .. 2-21 Deposit Processing .. 2-22 Refund Processing through Accounts Payable .. 2-23 Refund Processing through Cash Drawer.. 2-24 Short Term Loan Processing .. 2-25 Reconciliation Tips and Examples .. 2-26 Common Sources of Reconciliation Problems .. 2-26 Reconciliation Example .. 2-26 Banner Accounts Receivable Interface to Banner Finance .. 2-29 Detail Code Overview .. 2-29 Application of Payments and Rule Classes .. 2-30 August 2009 Banner Accounts Receivable GuideContentsAccounts Receivable Interface Overview .. 2-31 Accounts Receivable Interface Process .. 2-32 Posting Accounts Receivable Transactions in the Finance System .. 2-35 Month-End Closing Procedures .. 2-37 Options for Returned Check Processing.

5 2-38 Accrual Method of Accounting .. 2-38 Option A - Place a new outstanding charge of a returned check on an account.. 2-39 Option B - Remove the payment of the original charge.. 2-39 Billing Purge Process .. 2-41 Sample Detail Codes, Accounting Entries, and Rule Classes .. 2-41 Recurring Receivables Procedure .. 2-43 Define Recurring Receivables .. 2-44 Invoice/Statement Process (TFRBILL) .. 2-45 Setting Up Sleep/Wake Processes .. 2-45 Banner Student .. 2-45 Banner Accounts Receivable .. 2-46 Control/Rules/Application Forms Reference .. 2-47 Chapter 3 Student Accounts Receivable ProceduresOverview .. 3-1 Establish Controls .. 3-1 Non-Term-Based Detail Codes Use.. 3-3 Associate an Effective Date with an Accounting Distribution .. 3-3 Change an Existing Set of Accounting Distribution Values .. 3-4 Term-Based Detail Codes Set-up .. 3-4 Advantages of using a Common Set of Detail Codes.

6 3-5 Optional Use of Term-Based Detail Codes .. 3-5 Implementation of the Term-based Detail Code Interface .. 3-6 Term-based Detail Codes Use .. 3-6viBanner Accounts Receivable 2009 user GuideContents Associate an Effective Date with an Accounting Distribution .. 3-7 Change an Existing Set of Accounting Distribution Values, Term-based to Term-based .. 3-7 Change a Detail Code from Term-based to Non-Term-based .. 3-8 Change a Detail Code from Non-Term-based to Term-based .. 3-8 Change an Existing Set of Term-based Designator Codes .. 3-9 Establish Third Party Contracts .. 3-9 Contract Student Load (TSPCSTU).. 3-10 Prerequisites .. 3-10 Contract Payment Detail Load (TSPCPDT).. 3-14 Prerequisites .. 3-14 Contract Payment Detail Form (TSACPDT) .. 3-18 Prerequisites .. 3-18 Main Window .. 3-18 Establish Exemption Information.. 3-24 Establish Installment Plans .. 3-25 Enter Student Payments.

7 3-25 Enter/Update/Review Account Detail .. 3-25 Mass Entry of Charges/Payments .. 3-26 Distribute a Single Payment to Multiple Charges .. 3-26 Display/Reprint Receipt .. 3-27 Review Accounts .. 3-27 Collect Miscellaneous Revenue .. 3-27 Rule Code Processing in Miscellaneous Transaction Form .. 3-27 Cashiering Procedure .. 3-28 Accounting Feed Procedure .. 3-31 Establish Accounts .. 3-31 Application of Payments .. 3-32 August 2009 Banner Accounts Receivable GuideContentsAccounting Feed Transactions .. 3-32 Deposit Processing .. 3-34 Refund Processing through Accounts Payable .. 3-34 Refund Processing through Cash Drawer .. 3-36 Short Term Loan Processing .. 3-36 Reconciliation Tips and Examples .. 3-38 Common Sources of Reconciliation Problems .. 3-38 Reconciliation Example .. 3-38 Banner Accounts Receivable Interface to Banner Finance .. 3-40 Detail Code Overview.

8 3-41 Application of Payments and Rule Classes .. 3-42 Accounts Receivable Interface Overview .. 3-43 Accounts Receivable Interface Process .. 3-44 Posting Accounts Receivable Transactions in the Finance System .. 3-48 Month-End Closing Procedures .. 3-50 Options for Returned Check Processing .. 3-51 Accrual Method of Accounting .. 3-51 Billing Purge Process .. 3-53 Sample Detail Codes, Accounting Entries, and Rule Classes .. 3-54 Review Cashiering Activity .. 3-55 Adjust Cashiering Activity .. 3-56 Automatic Cashier Close and Session Finalize .. 3-56 Application of Payments Process .. 3-57 Lockbox Payments Process .. 3-57 Grant Payments Process .. 3-58 ACH Refunds Process .. 3-59viiiBanner Accounts Receivable 2009 user GuideContents PLUS Loan Refunding Process.. 3-60 Automatic Process Flow .. 3-61 Manual Process Flow .. 3-61 Accounting Feed Process .. 3-62 Banner Pre-Bill Procedures.

9 3-62 Pre-Bill Process .. 3-62 Pre-Bill Assessments .. 3-63 Banner Alternative Payment/Assessment Processing .. 3-63 Setting Up Third Party Contracts .. 3-64 Setting Up Deposits .. 3-65 Setting Up Refunds through the Cash Drawer .. 3-66 Setting Up Refunds .. 3-68 Sample Detail Codes and Accounting Entries .. 3-69 Generic Accrual Account Distributions .. 3-69 Automated Installment Plans .. 3-70 About Automated Installment Plans and Installment Transactions .. 3-71 Assigning Installment Plans.. 3-71 Calculating Installment Plan Transactions .. 3-72 Setting Up Automated Installment Plans and Transactions - Things to Consider . 3-73 Tasks for Automated Installment Plans .. 3-73 Setting up Automated Installment Plans .. 3-73 Setting up Automated Installment Plan Assignment Rules .. 3-73 Setting up Automated Calculation Rules .. 3-74 Using Dynamic Calculation on a Bill .. 3-75 Not using Dynamic Calculation on a Student Bill.

10 3-76 Forms for Automated Installment Plans.. 3-76 Installment Plan Assignment Rules Form (TSAISTA) .. 3-76 Installment Plan Payment Rules Form (TSAISTR) .. 3-76 Installment Plan Payment Amount Form (TSAISTP) .. 3-77 Installment Plan Form - Student (TSAISTL).. 3-77 Customer Service Inquiry Form (TSICSRV) .. 3-77 Processes for Automated Installment Plans .. 3-78 Assign Installment Plans (TSPISTA) .. 3-78 Create Installment Transaction (TSPISTT) .. 3-78 Bill Student Accounts .. 3-78 August 2009 Banner Accounts Receivable GuideContentsThird Party Billing .. 3-81 Schedule/Bill Procedure and Processing .. 3-81 Parameter Types .. 3-82 Schedule/Bill Rules Form (TSASBRL) .. 3-82 Who Gets a Schedule/Bill .. 3-82 Student Selection .. 3-83 What Items and Item Headings Appear in the Schedule Portion .. 3-84 What Appears in the Bill Portion and How it is Displayed .. 3-85 Schedule/Bill Messages.