Consolidated Billing and Payment CBM

1
Consolidated Billing and Payment (CBM)

• Audrey Lindsay
• Administrative Systems Coordination Committee
• Jan 16, 2004

2
CBM - Components

• Combined bill display for students
• CBM - Web payment options
• Web services credit card option
• Administrative module
• Automated reconciliation process

3
Consolidated Billing

• Display a combined student bill
• live Dec 2002
• poll participating departmental financial systems
• create a single invoice display
• departments can initially be display only mode

4
Payment Options

• student selects charges to be paid
• CBM
• Payment by credit card (Dec 2002)
• Electronic Funds Transfer (EFT) (Dec 2003)
• Web Service
• Payment by credit card
• system distributes real-time payments to
  departmental system
• Consolidated Billing demo student view

5
Login to Student Service Centre
6
System Polls Departmental Accounts
7
Student Presented Bill part 1
8
Student Presented Bill part 2
Amounts for Housing and Admission would also
display here. Clicking on the links displays
details of the charge.
9
Select Items to Pay
Student selects one or more items to pay
10
EFT Payment Option part 1
11
EFT Payment Option part 2
Bank information from previous payments can be
saved for future payments
12
Credit Card Payment part 1
or student could choose to pay by credit card
13
Credit Card Payment part 2
14
Student Confirms Payment part 1
15
Student Confirms Payment part 2
16
System Confirms Payment part 1
17
System Confirms Payment part 2
18
Participants

• Current CBM participants
• Tuition
• Admission Applications
• Housing (application fee, rent, daycare)
• Current credit card Web Services participants
• transcripts
• admission applications for various faculties
• housing
• food services
• workshops

19
Payment process

• Third party process for both credit card EFT
• BeanStream - Internet Service Provider (ISP)
• UBC interactions are with BeanStream
• TD is our bank for Visa
• TD uses FirstData for MasterCard
• All interactions with TD are via Beanstream

20
Administrative System

• View student transactions
• Daily payment logs for Financial Services
• Automated reconciliation
• CBM transactions (with tuition Admissions)
• CBM with Beanstream
• TD Bank with FMIS
• Account reporting by merchant
• Ability to refund/reverse charges
• Administrative System demo

21
Login to CBM Administrative System
22
CBM Administration Functions
Administrative staff can view payments by student
or a variety of payment reports
23
Select date range for Payment Log
24
Payment Log of transactions
25
Payment Summary by Merchant
26
Summary by Merchant page 2
27
Select Reconciliation Report
28
Select specific date or latest reports
29
Displays totals and any transactions not
automatically reconciled
30
Security

• Administrative System
• limited IDs have access to system
• view all functions
• only specific Ids have refund access
• General
• credit card numbers are not saved
• encrypt bank account numbers

31
Consolidated Billing expansion

• Expand CBM to other merchants
• Food Services (to CBM not just web service)
• ITServices (on-campus phones, Interchange
  accounts)
• Parking (permits, fines)
• Library (fines)
• Bookstore (graduation regalia, fast track)
• EFT to UBC one-card
• Others ?

32
To become a CBM Merchant

• System must be account-based system (i.e. assess
  now - pay later)
• Registered with CWL
• Configure system to listen and send account
  information to CBM in real time
• Configure system to receive payment information
  in real time
• Design presentation (e.g housing tuition
  examples)

33
To use Credit Card Web Service

• Registered with CWL
• Develop own user interface
• Able to post https messages
• Request document write-up from the CBM team
  (initial contact Gord Uyeda)

34
CBM possible future enhancements

• Cross application of credits
• Direct deposit of Awards Financial Assistance
  to student bank account
• Refund requests and deposit in bank account
• Use the Verified by Visa option for additional
  security and fraud prevention