Contact us at:
fad_communications@harvard.edu
Or via the UIS Helpdesk, 6-2001


 

HDW Applications Offline Sunday, April 28   top

The Harvard Data Warehouse (HDW) Team will conduct a performance test as part of our Fiscal Year End Close tuning efforts on Sunday, April 28, 2002 from 5 a.m.-7 p.m.

The HDW (HUDINI, AWS2 and Ad-hoc reporting environments) will be unavailable to users during this time. For your information, reports scheduled to run on Sunday mornings will be executed and available to users the morning of Monday, April 29.

If you have any questions, please contact the UIS Helpdesk at 496-2001.


FAQs about Accounts Receivable  top

The FAD Accounts Receivable (AR) Department would like to thank users who responded to our recent survey. We appreciate the time and effort you took to tell us about your experiences using the Oracle AR system. We plan to thoroughly review all the issues identified in your survey responses over the next few months.

In the meantime, we'd like to provide answers to some of the most frequently asked questions we received, namely:


Who does what in FAD Accounts Receivable   back
Who we are What we do Questions we can answer

Manager:

Ed Feldman
5-4182
ed_feldman@
harvard.edu

Oversees and manages the operations of the FAD Accounts Receivable department Any policy or procedure question relating to Harvard's Central Accounts Receivable function

Supervisor:

Kathy Hallmann
5-4598
kathy_hallmann@
harvard.edu

Supervises the daily operation of the Customer Hotline, Invoice Processing, and Cash Application functions within AR Any policy or procedure question relating to the invoicing, credit memos, customer setup, or payment processes

Customer Service / Collections

Lead Collector:
Cyndi Tam
5-0962
cyndi_tam@
harvard.edu

Collectors:
Terry D'Oyley
5-7752
terry_doyley@
harvard.edu


Joanne Reid
5-0963
joanne_reid@
harvard.edu

• Correspond with external customers to collect past due balances

• Coordinate collection actions with local units

• Provide customer service and collection information to the University community



 

• How can I dispute an invoice I received?

• Could you tell me why my payment was applied as it was?

• Can I create a web voucher to pay these charges?

• Why can't I find this transaction on my detail listing?

• Can we deposit a payment we've received for an AR billing?

• Can we print our own invoices?

Customer Setup Hotline (5-9192)

Database Administrator:
Cassandra Williams
5-9192
cassandra_williams@
harvard.edu

• Sets up new customer accounts in Oracle AR system

• Maintains customer database (e.g., info on customer sites, contact names, etc.)

• Maintains Payroll Deduction Authorization file

• Audits database for duplicates or other errors

• Researches, manages, and resolves returned mail

• How do I know if a customer has already been set up?

• Can you delete this account?

• The account you set up is slightly different than I requested. Why?

• How long until my accounts will be set up?

Invoice Processing

Kathleen King
5-9503
kathleen_king@
harvard.edu

• Enters invoices and credit memos for local units who bill fewer than ten invoices per month

• Monitors incomplete invoices and deletes as per policy

• Prints, sorts, and mails invoices, and statements

• Returns invoices with attachments to local unit

• Processes payroll deductions

• I have a customer who wants to pay his charges with his department's 33-digit account code. How do I do this?

• How can I find my "incomplete invoices"?

• My customers would like to have their charges deducted from payroll. How can we set them up for this? How does it work?

Accounting

Stella Marston
5-5016
stella_marston@
harvard.edu

• Reconciles AR sub-ledger to the General Ledger daily

• Prepares monthly reconciliation

• Supports financial reporting needs of AR

• Verifies that deposits made to lockbox are entered into Oracle AR

• Advises AR staff and local units on accounting procedures and policies

• Prepares web vouchers for customer refunds

• Assists the Cash Applicators with research

• Why can't I find this transaction on my detail listing?

• In which month did our transaction get posted?

• Our receivables are not in balance this month. Could you help?

Cash Applicators

Maria Raposa
Connie Stec

note: questions regarding application of receipts should be addressed to Customer Service/Collections

• Enter payments and other miscellaneous transactions, such as bad debt recoveries

• Research and resolve all overpaid, duplicate, and unidentified payments

• I forwarded a receipt to AR that had been sent directly to my department, along with the list of invoices paid by the receipt. However, AR did not apply the receipt as instructed. Can you tell me why?

 

How accounts receivable credit processing works   back

When staff in FAD AR attempt to process a customer receipt but find that there is no open invoice to which the payment should be applied, they research the issue to determine if the payment is:

1. for an invoice paid previously.
2. for an invoice cancelled by credit memo (e.g., charged to bad debt, written off as a billing error), or
3. sent erroneously to FAD AR.

Depending on their findings, the credit is either owed to the customer, to the local unit, or to another Central operating unit.

If research shows that... Staff in FAD AR will...

the invoice(s) was "written off" (i.e., charged to bad debt expense)

process a "bad debt recovery" in Oracle, returning the revenue to the department.

the payment is a "duplicate" and owed to the customer

place the credit amount "On Account" (a designation in Oracle for the status of a payment) indicating that the amount is due to the customer.

The credit amount appears on the customer's statement and is netted against any balance due.

Assuming that there are still charges being incurred, the credit is used when the customer pays the next statement balance.

a credit, or credit balance, remains on the customer's account for 90 days

issue a refund in many, but not all cases. For example, if past account activity shows monthly invoicing, the credit will remain "On Account" for application for an additional thirty days.

Note: This policy applies to individual account holders only. Corporate payers who make duplicate payments are generally refunded immediately.

a payment has been deposited in our lockbox that "belongs" to another Central operation (e.g., Student Loans or Receivables)

call the other Central operation for their 33-digit coding for the deposit, then journal the revenue to the proper coding.


A new collection tool for AR   back

Many of the participants of our survey indicated that they would like to have access to an electronic "tickler" or reminder file in the Oracle AR system called "Scheduler." For example, if a collector needs to follow up with a customer on May 1st, that call will appear in the collector's Scheduler on May 1 to remind him or her to make the call.

Many felt that this tool would make their collection responsibilities easier. Our plan is to have this made available to you in the coming months by enhancing your collection responsibility screen to include this function.


Oracle AR Training Opportunities   back

We would like to remind everyone that there is instructor-led training, refresher training, and online documentation available to support users of Harvard's AR system.

Support for AR users Available at...

Instructor-led training

Course descriptions:
http://vpf-web.harvard.edu/training/#AR1

Course schedule:
http://vpf-web.harvard.edu /training/schedule.html

Registration contacts:
http://vpf-web.harvard.edu /training/#Register

Refresher training

We especially encourage "non-financial" staff who have invoicing and/or collections responsibilities — or those who use the system sporadically — to repeat instructor-led training courses as necessary.

If you would like to meet with an AR representative about your particular issues or questions after you have attended training, please contact Kathy Hallmann at 5-4598.

Online documentation

ABLE:
http://able.harvard.edu/ar/ar_index.shtml


Survey Gift Certificate Winner!

We are happy to announce that Hilde DeWeerdt from the Harvard-Yenching Library was the gift certificate winner from our random drawing of survey respondents. Thank you, Hilde, for taking the time to provide us with your feedback.



American Express Updates  top

American Express Increases Fees

Please be advised that beginning May 1, 2002, American Express will increase the following fees:

Fee Type
Current
As of May 1, 2002
Delinquency Fees

Will be assessed on charges that are 60 or more days past due with a minimum balance greater than $50

Will be assessed on charges that are 60 or more days past due with a minimum balance greater than $35

The fee will be 2.75% of the balance over 60 days The fee will be 2.75% of the balance over 60 days
The fee will be based on all cumulative balances past 60 days The fee will be based on all cumulative balances past 60 days
Suspense Fee assessed on cards that have been suspended due to late payment (90 days past due)

$0

$25

All cardholders should have received a notice from American Express regarding the change in fees. Since that notice was sent out, American Express has advised us that Massachusetts state law prohibits them from charging the "flat fees." Therefore, the minimum $29 flat fee that was referred to in the letter you received will not apply.


American Express Website Features

A reminder that corporate cardholders can access statements online, allowing for a timely review and reconciliation of their monthly charges, even while on the road. This service is free.

Online management of your account is a convenient way to

  • access account information 24 hours a day, 7 days a week
  • track current charges and payments, and view statements for the past six months
  • review statement closing date, spending limit information, total balance (includes unpaid billed balance and new charges), and the Open-to-Buy amount
  • confirm Corporate Card payment
  • manage your account profile, including updating addresses
  • initiate charge inquiries and disputes, and
  • view the US dollar equivalent of charges made in other currencies.

To enroll, visit http://www.americanexpress.com, click on Corporations, and then select Learn About & Enroll in Manage Your Card Account (under the Check Your Bill header).

Please contact the Travel and Reimbursement Office at 495-7760, or stop by 380 Holyoke Center if you have any questions or concerns.


Harvard Travel Center Fees   top


The travel industry has been hit hard due to the economic downturn, which began late in 2000 and continued through 2001. Then the September 11 tragedy plunged it into cataclysmic financial disaster. Airlines, hotels, car rental companies, and travel agencies have remained viable only through cutbacks and layoffs.

On March 18, 2002, the airlines began a precedent-setting cutback by eradicating commissions to travel agents. Car rental companies have followed suit and it is expected that hotels will do the same. To remain in business, travel agents now have no choice but to charge a fee for the service they provide.

Many Harvard travelers may feel more compelled than ever to use the Internet to avoid the fees. While this is certainly understandable, remember that travel agents continue to provide personal and comprehensive services that websites are not designed to do. Also remember that Harvard University will fully reimburse all travel agent fees.

Harvard Travel Center fees are as follows:
Domestic airline ticket $45
International airline ticket $55
Refund of an airline ticket $25
Delivery of a paper ticket (can be avoided by purchasing an e-ticket) $10
Amtrak ticket $27
Car or hotel only booking $25
Meeting services $55

Most local travel agencies are charging comparable fees. Questions regarding Harvard's travel program should be directed to Jack Healey at 496-8686 or Priscilla Campbell at 496-4599.


STAR Query Tool to Be Decommissioned   top

Since STAR (the now-defunct System for Travel and Reimbursement) was permanently shut down on June 30, 2001, there has been very little use of the STAR Query Tool that was made available to research past expense reports. Therefore, on May 15, 2002, the query tool will also be shut down permanently.

Departments who expect to need information from old STAR reports should access the STAR Query Tool prior to May 15 and print out reports for future reference.

To get summary-level information related to an old STAR report after May 15, you can run a detailed listing report in AWS2 or HUDINI. If you have any questions about how to interpret STAR data on the detailed listing, contact you local financial office or Stacy Clifton in the Travel and Reimbursement Office at 5-9308.

For more complete information about an old STAR report after May 15, you will need to contact the Imaging Department at 5-8930 and provide them with the name and HUID number of the reimbursee and the total amount of the STAR report in question (both of these can be obtained from the detailed listing). The Imaging Department will then provide you with a copy of the original reimbursement report. Please allow two weeks for this process.


2001-2002 Harvard Fact Book Available on Web   top

The web version of the 2001-2002 Harvard University Fact Book, published each spring by the FAD Office of Budget and Financial Planning, is now available online. This handy reference tool collects a wealth of facts and figures about the University, and is organized into three general sections: Organization, People, and Resources.

The Organization section includes a flow chart that depicts the structure of Harvard's faculties and allied institutions. (A similar chart showing how Central Administration is organized, as well as a list of all of Harvard's research and academic centers, will be added soon.)

The People section provides statistical data about Harvard's student population and distributes it in several ways (for example, by discipline, school, nationality, gender, number of degrees conferred, etc.). This section also includes data on Harvard's faculty and staff populations (for example, how many people work in each faculty, allied institution, or Central Administration unit).

Finally, the Resources section provides information about Harvard's tuition and fees, income and expenses, number of holdings in each of Harvard's 90 libraries, buildings and land owned, endowment information, and much more.

A few of the 2001-2002 Fact Book entries are still being compiled, and they will be added to the web site as the information becomes available. However, previous editions of the Fact Book are complete and archived on the site for your review.

You can read the Fact Book at the following location: http://vpf-web.harvard.edu/factbook/.

About the FAD e-News   top

The Financial Administration publishes this semi-monthly electronic newsletter for users of Harvard University's financial systems, policies, and procedures. Generally, the e-News is published on or around the 12th and 26th of each month.

It contains:

  • updates on projects underway to build or improve University financial systems;
  • information about new University financial policies, procedures, and forms;
  • reminders about upcoming deadlines and cut-over dates;
  • tips and tricks for working more easily or productively.

We welcome questions and suggestions for improvement from readers. If your questions are of general interest, we will answer them in future issues.

Please send comments, questions, or suggestions for improvement by email to us at: fad_communications@harvard.edu