|
Reference |
Recommendation |
Management Response |
Responsible Person |
Estimated Completion |
Comments |
|
B.4.6 |
Request that Datatel integrate the credit card machine with the student payment to eliminate duplicate data entry. |
Information Technology will discuss this integration process with Datatel. |
Bill Carter |
December 2000 (discussion) |
Change in date |
|
B.4.7 |
Establish a policy to limit the amount of time a reconciliation item can be carried. |
Part of the staledate rules have been written. |
Kathy Dinse Leslie Sabin |
March 2001 |
Change in date. Some rules still need to be finalized and put in writing. |
|
B.6.3 |
Replace the manually intensive requisition process with a purchasing card program. |
An RFP has been prepared for distribution to purchasing card vendors in December 2000. |
Gilbert Rodriquez |
March 2001 |
Change in date |
|
B.7.1 |
Financial statements should be prepared and published on a quarterly basis. This task should be reassigned to a general ledger accountant and the controller, rather than the Vice President. |
Quarterly financial statements for the Board will continue to be published on a quarterly basis. Transition for the reassignment of this duty to the controller began with the third quarter report in June 2000. |
Jerry Miller Leslie Sabin |
January 2001 |
|
The following items have previously
been reported as 'Completed' or 'Rejected.'
|
B.2.1 |
Restructure bank accounts to achieve additional interest income. |
A new bank account structure has been designed and implements and Chase Bank is sweeping funds nightly into an interest bearing account. |
|
|
COMPLETED |
|
B.2.2 |
Reduce chargeback processing fees. |
Chase Bank has eliminated all chargeback fees. |
|
|
COMPLETED |
|
B.2.3 |
Assign one person to monitor and process chargebacks. |
A full-time staff in Student Accounting is assigned this duty. |
Cheryl Coe |
|
COMPLETED |
|
B.2.4 |
Store the image of checks on CD ROM providing access electronically to all staff. |
All cancelled checks have been imaged and placed on a CD-ROM. Software has been installed in the Business Office to access the CD-ROM check data. |
Kathy Dinse |
|
COMPLETED |
|
B.3.1 |
Appoint one person to monitor the collateral position on a daily basis. |
The Revenue Accounting Manager has been assigned this duty. |
Cheryl Coe |
|
COMPLETED |
|
B.3.2 |
Negotiate with the bank to accept a surety bond in lieu of securities. |
Chase Bank agreed to provide a surety bond for collateral in the amount of $5 million. |
|
|
COMPLETED |
|
B.4.1 |
Reconcile all bank statements within fifteen days of receipt. |
This has been performed monthly since the July statement. |
Kathy Dinse |
|
COMPLETED |
|
B.4.2 |
Develop the automated tools necessary to streamline the bank reconciliation process. |
This has been implemented and in operation since April 2000. |
|
|
COMPLETED |
|
B.4.3 |
Network business services staff, backup computer files and equip the reconciliation staff with current hardware. |
A LAN was installed in May 2000 and is backed up as a segment of the IT college-wide back-up procedures. Reconciliation staff received upgraded computers in July 2000. |
|
|
COMPLETED |
|
B.4.4 |
Train the cashier staff and hold them accountable for the money and records they produce. |
Cashiers have been trained to read the credit card transmission reports. |
Cheryl Coe |
|
COMPLETED |
|
B.4.5 |
Require the cashiers to validate the Datatel entry against the credit card processor report to ensure accuracy in both systems. |
Cashiers complete a reconciliation sheet daily to tie credit card and cash activity to data contained in Datatel system. |
Cheryl Coe |
|
COMPLETED |
|
B.4.8 |
Develop an automated tool to streamline the credit card reconciliation effort. |
A program was written allowing for direct download into Excel. |
|
|
COMPLETED |
|
B.4.9 |
Download the Datatel session data and process against the bank statements to identify differences. |
Session data is downloaded twice weekly. This has reduced reconciliation process. |
|
|
COMPLETED |
|
B.4.10 |
No longer accept American Express for charges. |
Because American Express refused to change their method of charging fees, the decision was made to stop accepting American Express cards, effective July 10, 2000. |
|
|
COMPLETED |
|
B.4.11 |
Ask Discover to assess their merchant discount fees monthly using a separate transaction. |
Discover has agreed to process fees monthly instead of daily. |
|
|
COMPLETED |
|
B.5.1 |
Write detailed procedures to reconcile general ledger accounts monthly. |
Procedures have been developed and implemented. |
|
|
COMPLETED |
|
B.5.2 |
Setup a payroll offset account for erroneous entries that will not impact the payroll cash account. |
A payroll clearing account was created in July 2000. |
|
|
COMPLETED |
|
B.5.3 |
Establish a general ledger closing policy and procedure. |
A policy of closing books within two months has been instituted. Back posting to the general ledger is no longer allowed. |
|
|
COMPLETED |
|
B.6.1 |
Take cash discounts from vendors when offered. |
Accounts Payable staff is aggressively taking cash discounts when offered. |
|
|
COMPLETED |
|
B.6.2 |
Transfer the vendor setup process to purchasing. |
Purchasing and Accounts Payable have implemented this change. |
|
|
COMPLETED |