banner accounts receivable new enhancements in 7 - usg.edu · modes applycred invoicing statement...

www.sungardhe.com

Banner Accounts Receivable New Enhancements in 7.3

Kris LorenzPrincipal Consultant

2www.sungardhe.com

Topics of Discussion

TGRRCON

New summary sections

Finance Installed

Finance Not Installed

Collector table changes

New views

TSRCBIL

New parameters

Changed parameters

Removed parameters

Other changes

3www.sungardhe.com

Topics of DiscussionStudent eBills

Students and staff can view

Stored point-in time statements, includingschedule/bill statements

Payment history as defined by institution

Unbilled activity since last statement, including future effective dated transactions

PLUS Loan Refunding

Refund produces automatic check to PLUS borrower (if parent did not select refund to student)

Refund based on balance for each PLUS loan that has not been applied to charges on student’s account

www.sungardhe.com

TGRRCON

5www.sungardhe.com

TGRRCON – Finance installed

New Account Summary section

A/R Adjusted Fed total

+ Pending Gurfeed

+ In transit (FGBTRNI & FGBJVCD)

= Adjusted Net Fed

General Ledger Balance

Difference (Adjusted Net Fed – General Ledger Bal)

6www.sungardhe.com

TGRRCON – Finance installed

New Deposit Summary section

Total Fed

+ Pending Gurfeed

+ In transit (FGBTRNI & FGBJVCD)

= Adjusted Net Fed

General Ledger Balance

Difference (Adjusted Net Fed – General Ledger Bal)

7www.sungardhe.com

Report Sample Account Summary with Banner Finance Installed

8www.sungardhe.com

TGRRCON – Finance NOT installed

New Account Summary section

A/R Adjusted Fed total

+ Pending Gurfeed

= Adjusted Ledger

9www.sungardhe.com

TGRRCON – Finance NOT installed

New Deposit Summary section

Total Fed

+ Pending Gurfeed

= Adjusted Ledger

10www.sungardhe.com

TGRRCON – Collector Table changes

New column

tgrcolr_source

Identifies source of the data

Values

ACCD – Receivable transactions (TBRACCD)

DEPO – Deposits (TBRDEPO)

MISD – Miscellaneous receipts (TBRMISD)

Cleared at start of run (not at end) to retain summarized data

11www.sungardhe.com

TGRRCON – New Views

Detail of Application of Payments View (TBVDTAP)

Detail Application of Payment table (TBRAPPL)

Research Accounting Application of Payment table (TRRAPPL)

Includes data from associated transaction table, detail code table and identification tables

12www.sungardhe.com

TGRRCON – New Views

Detail of Accounts Receivable Transactions View (TBVDTTR)

Charge/Payment Table (TBRACCD)

Grant Detail (TRRACCD)

Deposits (TBRDEPO)

Miscellaneous Transactions (TBRMISD)

Detail code table

Identification tables

Information can be viewed by Feed Document or by Cashier Session

www.sungardhe.com

Student Billing Process TSRCBIL

14www.sungardhe.com

RPE’s Delivered (TSRCBIL)

RPE 25737

Eliminated extra blank page that printed between each S/B in sleep/wake mode

15www.sungardhe.com

Defects Resolved (TSRCBIL)

Defect 90475

Problem – Name prefix and suffix did not print in S/B mode

Resolution- Prefix and suffix (at least first 3 characters) now print in S/B mode

16www.sungardhe.com

Defects Resolved (TSRCBIL)

Defect 96035

Problem – Primary instructor name was not printing when instructor was not associated with the first meeting session

Resolution -Primary instructor name now prints

17www.sungardhe.com

Other changes (TSRCBIL)

Missing spriden PIDMS now identified in the .log file of tb-statement API

Output prints accounts with no addresses first

Additional jobsub parameter edits

18www.sungardhe.com

New Parameters (TSRCBIL)

User ID for population selection

Accept charges (Y/N) (RPE 2840)

Option to update or not update the accept charges flags when credits (contracts, exemptions, deposits) are posted to account

Registration (SFBETRM)

Location Management (SLRRASG/MASG/PASG)

19www.sungardhe.com

Modified Parameters (TSRCBIL)

Pre 7.3 Release- RUN modes ApplyCred

Invoicing

Statement

Financial

7.3 Release- RUN Modes ApplyCred

Invoicing

Statement

SCHEDSTMT (new)

Updates bill/due dates for trans included in amount due

SCHEDINV (new)

Current schedule bill functionality which does not update bill/due dates

20www.sungardhe.com

Modified Parameters (TSRCBIL)

Include Zero Balance (RPE 24610)

Enables billing of zero bal accounts with current activity, and avoids billing accounts with no activity

Parameter options

N - exclude all zero

C - include zero only if current activity

Y - include all zero (schedule bill only)

Overrides Minimum Balance parameter

21www.sungardhe.com

Modified Parameters (TSRCBIL)

Pre 7.3 ReleaseSchedule Bill Due Date

Used for

Schedule/bills only

Days in Billing Cycle parameter was used to calculate Statement due date

7.3 ReleaseDue Date

Used for Schedule/bills

& Statements

Removed Days in Billing Cycle parameter

22www.sungardhe.com

Removed Parameters (TSRCBIL)

Produce Schedule/Bill

Run Mode now determines

(SCHEDSTMT/SCHEDINV)

Days in Billing Cycle

Due date parameter replaces calculation of due date

Financial Aid Indicator

23www.sungardhe.com

Summary

TGRRCON changes to simplify reconciliation

TSRCBIL changes to improve student billing functionality

www.sungardhe.com

Student eBills

25www.sungardhe.com

Topics of Discussion

What’s new - Functional

My Statement Luminis channel

Statement and Payment History self service page

Statement and Payment History form (TGISTMT)

Form Modifications (TGACTRL & TS/FADETC)

Statement Purge process (TGPSTMT)

26www.sungardhe.com

Topics of Discussion

What’s new – Technical

Statement header table (TBBSTMT)

API for new Statement Table

Large object storage table (GORBLOB)

Procedure for display of stored files

Added database columns (TBBCTRL and TBBDETC)

www.sungardhe.com

Technical Notes

28www.sungardhe.com

Technical notes

TBBSTMT – statement header table

Record of statement produced

RPE 26121 – display statement in Self Service

Used when running TSRCBIL

Defect 54060 – performance sorting by zip code

Defect 89417 – schedule/bill drops student with no address

29www.sungardhe.com

Technical notes

GORBLOB – large object storage table

BLOB – binary large object in database

BFILE – pointer to physical file stored in file system

30www.sungardhe.com

Technical notes

Statement stored

TSRCBIL will not create stored file

Unique statement number in the output

Third Party tool

Parse on statement number

Create PDF

Call API to store the file

Script

www.sungardhe.com

Student Perspective Let’s take a look

32www.sungardhe.com

Student Perspective example

Accesses institution’s Unified Digital Campus

Sees My Statement channel

Reviews summary info for most recent statement

Opens stored statement

Navigates to self service to view statements, payment history and unbilled activity

33www.sungardhe.com

My Statement channel

Opens stored

file

34www.sungardhe.com

Example: Statement stored in PDF format

35www.sungardhe.com

My Statement channel

Link to Self

Service

Link to payment gateway

36www.sungardhe.com

Statement and Payment History self service page

Access stored billing statements

Current (most recent) statement always displays

Previous statements display as defined by institution

Displays payment history – Institution defines

Displays unbilled activity

Activity since most recent statement

Future dated transactions

NEW Student Account menu under Student and Financial Aid

37www.sungardhe.com

38www.sungardhe.com

Opens PDF

39www.sungardhe.com

40www.sungardhe.com

Example: Statement stored in PDF format

41www.sungardhe.com

Blank means payment has

not yet appeared on a

statement

Entry Date

in INB

42www.sungardhe.com

Entry Date

in INB

43www.sungardhe.com

www.sungardhe.com

Office Staff Perspective Let’s take a look

45www.sungardhe.com

Office Staff Perspective example

Student calls with a question about their statement

Staff accesses the Statement and Payment History form (TGISTMT)

Sees a list of statements and summary information

Opens stored statement and sees EXACTLY what the student sees

Reviews payments and unbilled activity with student

46www.sungardhe.com

Opens statement for highlighted

record

47www.sungardhe.com

Example: Statement stored in PDF format

48www.sungardhe.com

Y = both can view * = Staff can view Blank = file not avail

Term populated for schedule bills

49www.sungardhe.com

Post Date in SS

50www.sungardhe.com

www.sungardhe.com

Form Modifications

52www.sungardhe.com

Billing Control form (TGACTRL)

Used to calculate

cutoff dates

53www.sungardhe.com

Accounts Recv Billing Control (TGACTRL)

Statement History Months

Valid values are 0 to 99 months

0 (zero) shows the most recent statement that exists for the student, without regard to cutoff

Statement cutoff applies to students only

Staff access is NOT limited. Staff can access all statements stored in the database

Student access to stored statements is limited to statements with bill date >= cutoff date

54www.sungardhe.com

Accounts Recv Billing Control (TGACTRL)

Payment History months

Valid values are 0 to 99 months

0 (zero) shows payments made in current month only

Student and Staff see same payment history

Payments with entry date >= cutoff date display

55www.sungardhe.com

Cutoff Date calculation How is cutoff date calculated?

Today is April 4, 2006 and Months History is 4

Current month is April

Count back four months– Mar, Feb, Jan, Dec

1st day of 4th month back is cutoff date - Dec 1, 2005

Statements and Payments since Dec. 1, 2005

56www.sungardhe.com

Detail Code Control forms (TS/FADETC)

Select to include detail code in payment history

Charge and Payment type detail codes valid

Refund detail codes can be included in Payment History

57www.sungardhe.com

Detail Code Control forms (TSADETC & TFADETC)

www.sungardhe.com

Statement Purge Process TGPSTMT

59www.sungardhe.com

Statement Purge process (TGPSTMT)

Purges records no longer needed or created in error

Deletes statement header row from TBBSTMT

Large object storage table

Deleted if BLOB stored

Marked pending delete if BFILE points to file system

60www.sungardhe.com

Statement Purge process (TGPSTMT)Parameters

Bill date

Job run number

Run Mode (Audit or Update)

Population selection

Output display by Bill Date

ID Name Statement Count

Control report shows total student and statement record counts

Output display by Job Number

Job Num Bill Date Statement Count

61www.sungardhe.com

Summary

Students and staff can view:

Stored point-in time statements, including schedule/bill statements

Payment history as defined by institution

Unbilled activity since last statement, including future effective dated transactions

www.sungardhe.com

PLUS Loan Refunding

63www.sungardhe.com

Process Prerequisites

Unique detail code on TSADETC for PLUS refunds to be sent to the parent borrower.

The Refund Code Associated with this detail code must be valued to P (Parent PLUS).

Fund code established on RFRBASE with the Federal Fund ID equal to PLUS must have the Direct Loan Indicator, Electronic Loan Indicator, or Manual Loan Indicator set to an appropriate value on the Fund Management Form (RFRMGMT).

64www.sungardhe.com

Data Entry Requirements

For the refund to go to the parent, do not select the Parent Loan to student check boxes

Get a complete parent name and address in the Parent Data section of the Loan information

65www.sungardhe.com

Automatic Process Flow

Disburse loan funds to the Student account using Banner Financial Aid disbursement (RPEDISB).

Run application of payments to apply any funds received for the student’s record to any outstanding charges.

Auto Refund Credit Amt – Student Process (TSRRFND) to allow refunding to PLUS Loan borrowers.

TGRFEED to update the GURAPAY table with the parent borrower’s name and address, as a one-time vendor.

Execute the Refund Interface (FURAPAY) to create the invoice records from the GURAPAY table.

Generate checks and distribute to the proper recipients.

66www.sungardhe.com

Changed Forms

TSADETC

TFADETC

A new value of P was added to the refund code on this form

Identifies a detail code as a PLUS loan refund

Only one active detail code can exist with a value of P

67www.sungardhe.com

Changed Processes

TSRRFND (Auto Refund Credit Amt- Student)

TGRFEED (Accounting Feed Process)

FURAPAY (Student Refund Interface Process)

68www.sungardhe.com

Questions & Answers

69www.sungardhe.com

Thank You!

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Without limitation, SunGard, the SunGard logo, Banner, Campus Pipeline, Luminis, PowerCAMPUS, Matrix, and Plus are trademarks or registered trademarks of SunGard Data Systems Inc. or its subsidiaries in the U.S. and other countries. Third-party names and marks referenced herein are trademarks or registered trademarks of their respective owners.

©

2006 SunGard. All rights reserved.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -