| 
   REPORT DIGEST   CHICAGO STATE UNIVERSITY COMPLIANCE
  EXAMINATION (In
  accordance with the  For the Year Ended: June 30, 2007   Summary of Findings: Total this year - Financial Audit 3* - Compliance Audit 14 17 Total last year - Financial Audit 2* - Compliance Audit 10 12 Repeated from last year - Financial Audit 1* - Compliance Audit 7 8 *Financial Audit Previously Released Release Date: May 15, 2008 
 State of Illinois Office of the Auditor General WILLIAM G. HOLLAND AUDITOR GENERAL   To obtain a copy of the
  Report contact: Office of the Auditor
  General Iles Park Plaza, 740 E. Ash Street Springfield, IL 62703 (217) 782-6046 or TTY (888) 261-2887   This Report Digest and Full
  Report are also available on the worldwide web at  | 
  
     INTRODUCTION 
       The Financial Statement Audit for the year ended
  June 30, 2007 was previously released on April 10, 2008.  That audit contained three audit findings.
  Those findings pertained to significant deficiencies in internal control over
  financial reporting.   This report addresses Federal and State Compliance findings pertaining to the Single Audit and State Compliance Examination. In total, this document contains fourteen audit findings. SYNOPSIS   ¨      
  The University did not
  have supporting documentation and proper approvals for certain expenditures
  charged to Federal Programs.   ¨      
  The University’s
  procurement policies have requirements for competitive bidding however no
  evidence of competitive bidding was noted during testing of Federal
  transactions.   ¨      
  The University failed
  to comply with cash management requirements.   ¨      
  The University did not
  have adequate controls over contracting procedures.   ¨      
  The University did not
  follow the travel policies of the Higher Education Travel Control Board and
  the Department of Central Management Services Property Control Rules.  Additionally, numerous charges to the University
  credit card were not supported by receipts and documentation.   ¨      
  The University did not
  have procedures in place to periodically monitor unclaimed monies to
  determine proper and timely disposition of the funds in compliance with the
  Unclaimed Property Act.   ¨      
  The University did not
  perform timely reconciliations of University records to the Office of the
  State Comptroller records.   ¨      
  The University had
  inadequate controls over its property and equipment records.     {Financial Information is summarized on the reverse page.}    | 
 
CHICAGO STATE UNIVERSITY
COMPLIANCE EXAMINATION
| 
   STATEMENT OF REVENUES, EXPENSES AND
  CHANGES IN NET ASSETS  | 
  
  FY
  2007
   | 
  
  FY
  2006
   | 
 
| 
   OPERATING REVENUES         Student
  tuition (net of scholarship allowances of $7,573,293 and $7,721,000.............          Auxiliary
  enterprises (net of scholarship allowances of $13,664 and $35,336.............          Grants
  and contracts (principally federal).........................................................................          Other
  sources........................................................................................................................  ....... Total Operating Revenues................................................................................... OPERATING EXPENSES         Instruction..............................................................................................................................          Research.................................................................................................................................          Public
  service.........................................................................................................................          Academic
  support.................................................................................................................          Student
  services....................................................................................................................          Institutional
  support.............................................................................................................          Operation
  and maintenance of plant..................................................................................          Scholarships
  and fellowships.............................................................................................          Auxiliary
  enterprises.............................................................................................................          Depreciation...........................................................................................................................          On-behalf
  State fringe benefits...........................................................................................  ....... Total Operating Expenses.................................................................................... OPERATING LOSS.......................................................................................................................  NONOPERATING REVENUES (EXPENSES)         State
  appropriations.............................................................................................................          State
  fringe benefits..............................................................................................................          Investment
  income................................................................................................................          Interest
  on capital asset – related debt..............................................................................  ....... Net nonoperating revenues.................................................................................           Capital
  appropriations and grants......................................................................................          Loss on
  disposal of capital assets.....................................................................................  ....... Total other revenues.............................................................................................                           Increase
  in net assets.........................................................................................  NET ASSETS Net assets, beginning of the year...............................................................................................  Net assets, end of the year..........................................................................................................  | 
  
   
 $22,023,468 3,630,015 31,083,682 3,023,784 $59,760,949   $38,298,566 5,405,867 7,359,554 7,118,467 13,468,500 8,903,062 6,701,614 5,346,202 3,902,710 4,067,182 15,176,756 $115,748,480 $(55,987,531) 
 41,160,000 15,176,756 54,044 (1,350,769) $55,040,031 ($947,500) $16,916,913 (32,128) $16,884,785 $15,937,285 
 
  112,189,557 $128,126,842  | 
  
   
  $22,437,090 4,100,582 31,181,924 3,149,562 $60,869,158   $36,655,375 3,863,448 6,192,057 6,491,124 11,056,396 9,336,983 6,402,239 5,075,461 4,278,278 3,348,005 13,402,670 
  $106,102,036 $(45,232,878)   38,660,300 13,402,670 57,071 (1,472,091) $50,647,950 $5,415,072 $28,253,484 (37,802) $28,215,682      $33,630,754 
 78,558,803 $112,189,557  | 
 
| 
   SUPPLEMENTARY INFORMATION (Unaudited)  | 
  
   FY
  2007  | 
  
   FY
  2006  | 
 
| 
   Employment
  Statistics     Faculty/administrative..............................................................................      Student
  employees..................................................................................           Total Employees..............................................................................  Selected
  Activity Measures Students (Spring Term)     
  Undergraduate.......................................................................................      
  Graduate................................................................................................      
  Total Students........................................................................................   | 
  
     902 299 1,201     4,775 1,773 6,548  | 
  
     950 298 1,248     4,790 1,864 6,654  | 
 
  UNIVERSITY
  PRESIDENT
   | 
 ||
| 
   During Audit Period and Current: Dr. Elnora
  Daniel  | 
 ||
| 
   
                             Failure to maintain
  supporting documentation     Questioned costs
  totaling $13,702       Need to improve
  property control records                            
   University agrees
  with auditors                             $1,519,500 of
  expenditures contained no evidence of bidding     
   $58,359 of
  expenditures contained no evidence of bidding         
 
   $1,596,637 of
  expenditures contained no evidence of bidding         
   $1,309,692 of
  expenditures contained no evidence of bidding                 
   University agrees
  with auditors                     
   Competitive
  procurement regulations not followed             Cash draw-downs
  exceeded the quoted cost by $76,894               $39,650 cash
  drawn-down pertained to another program                       
   University agrees
  with auditors                           
   No evidence of
  competitive bids for 5 contracts totaling $679,927 
   One contract for
  $251,000 was with an employee of the University 
 
   18 of 26 contracts
  tested were executed after the date that services commenced       
   4 contracts
  exceeding $250,000 each were not approved by the Board of Trustees                     
   University agrees
  with auditors                                           Credit card charges
  were not always supported   
   Payment
  documentation did not identify any specific business purpose               
 
 
   Lack of receipts                               
   University accepted
  the recommendation                     
   Some outstanding
  checks were issued over 10 years ago                                                   University agrees
  with auditors                       
   Reconciliations  for the first 5 months were not performed until December 2006                   University agrees
  with auditors                 
   Inadequate controls
  over property and equipment records                       Several items
  observed were not on the property list                           Items could not be
  located                         
 
 
   Financial Statement
  adjustments needed as a result of auditor testing       
   Several items
  tested totaling $229,556 were missing on the DCMS list           
   Annual
  Certification of Inventory submitted 7 months late                 
   University agrees
  with auditors  | 
  
   FINDINGS, CONCLUSIONS, AND
  RECOMMENDATIONS   INADEQUATE DOCUMENTATION FOR FEDERAL PROGRAM EXPENDITURES   
        The University did
  not have supporting documentation and proper approvals for certain
  expenditures charged to Federal programs. 
  Specifically, the University charged lodging and per diem rates in
  excess of rates allowed by State travel regulations.  Further, certain equipment purchased with
  Federal funds had not been properly recorded in University property control
  records.         Some
  of the items noted during our review of federal programs follow:   ·       
  Eleven of
  seventy-seven (14%) expenditures ($48,966) tested for the U.S. Department of
  Education – Trio Cluster, were missing appropriate supporting
  documentation.   ·       
  One of forty-one
  (2%) expenditures ($29,598) tested for the U.S. Agency for International
  Development – Textbook and Learning Materials, included $13,702 of
  promotional items that were incorrectly charged to the program. ·       
  Three of
  forty-one (7%) expenditures ($366,943) tested for furniture and equipment
  were not properly recorded or tracked in the University’s property control
  records. (Finding 5, Pages 14-16) This finding was first reported in 2003.         We recommended that the University
  improve control procedures to ensure that payments are only made once a
  proper invoice with appropriate documentation and approval is received.  In addition, we recommended that the
  University maintain a filing system that allows them to locate supporting
  documentation (including documentation of the necessity for any non-standard
  travel costs) for all invoices paid and to ensure proper tracking and
  accounting of property expenditures.         University
  officials accepted our recommendation and stated that they will develop
  policies and procedures to ensure that payments are made only when a proper
  invoice and appropriate documentation and approval is received.  (For the previous University response, see
  Digest footnote #1.)    GRANT EXPENDITURES NOT PROPERLY BID   
        The University’s
  procurement policies have requirements for competitive bidding; however no
  evidence of competitive bidding was noted during testing of Federal
  transactions.         During our audit of major federal
  programs in compliance with OMB Circular A-133 we noted the following:   ·       
  In our expenditure testing of the U.S. Department of Health and Human
  Services – Head Start Program we tested 52 expenditures totaling
  $1,574,760.  We noted that 7 (13%)
  expenditures totaling $1,519,500 were over the small purchase threshold of
  $25,000 and contained no evidence of bidding. ·       
  In our expenditure testing of the U.S. Department of Education - Trio
  Cluster we tested 77 expenditures totaling $263,820. We noted that 2 (3%)
  expenditures totaling $58,359 were over the small purchase threshold of
  $25,000 and contained no evidence of bidding. ·       
  In our expenditure testing of the National Institutes of Health,
  National Science Foundation and the Department of Defense - Research Cluster
  we tested 67 expenditures totaling $1,742,176.  We noted that 11 (16%) expenditures totaling $1,596,637 were
  over the small purchase threshold of $25,000 and contained no evidence of
  bidding. ·       
   In our expenditure testing of
  the U.S. Agency for International Development – Textbook and Learning
  Materials Program we tested 41 expenditures totaling $1,513,680.  We noted that 17 (41%) expenditures
  totaling $1,309,692 were over the small purchase threshold of $25,000 and
  contained no evidence of bidding. accordance (Finding 6, Pages 17-18)        We recommended that
  the University improve its policies and procedures to ensure that purchases
  made with grant funds are competitively bid.   University officials agree with the recommendation and stated that they
  will provide training for fiscal officers and program directors to refresh
  their understanding of University bidding requirements, especially as those
  policies relate to grants.   FAILURE TO COMPLY WITH CASH
  MANAGEMENT REQUIREMENTS   The University failed to comply with cash management requirements.   During our testing of the U.S. Agency for International Development –
  Textbook and Learning Materials Program we noted that the University
  purchased equipment for this program and then subsequently determined that
  competitive procurement regulations were not followed and that the equipment
  could have been purchased for a lesser amount.     As a result of a review of other vendor quotes, University officials
  determined that the acquisition cost exceeded the quoted cost by
  $76,894.  The University had
  drawn-down the funds at the time of purchase and then subsequently adjusted
  its Federal drawdown to reduce the equipment expenditures of the
  program.  However, this resulted in the
  University drawing down Federal funds in excess of a reasonable amount had
  the University competitively procured the purchase.   During our testing of the U.S. Department of Education – Federal
  Academic Competitiveness Grants we noted that the University had expenditures
  of $43,300 for this grant.  However,
  the University had cash draw-downs of $82,950 under this program for the year
  ended June 30, 2007.  The draw-downs
  exceeded expenditures as the University erroneously requested reimbursement
  for monies, in the amount of $39,650, spent under another grant program.  (Finding 8, Pages 21-22)    We recommended that the University establish policies and procedures to
  ensure that cash management requirements are met.   University officials accepted the recommendation and stated that they
  will establish an internal review process for grant billings in an effort to
  uncover any errors in the grant billing process.   NEED TO IMPROVE CONTROLS OVER
  CONTRACTING    The University did not have adequate controls over contracting
  procedures.   During the audit, we noted numerous deficiencies in our examination of
  26 contracts.  Some of these
  significant deficiencies are as follows:   ·       
  Five contract files for goods and services that exceeded professional
  and artistic procurement maximums ($20,000) and small purchase amounts
  ($30,500) did not contain evidence of attempts to request competitive
  bids.  These contracts totaled
  $679,927.  One of these contracts for
  $251,000 was with an employee of the University, who failed to disclose any
  conflict of interest. ·       
  Eighteen contracts tested, totaling $2,043,222, were dated and signed
  by a University official and the vendors however, the date of the signatures
  was after the date of the commencement of services for the contract. ·       
  Two of the contracts on file at the University did not contain vendor
  signatures.  These contracts were for
  services totaling $275,163. ·       
  Four contracts, each exceeding $250,000 for goods and services, were
  not approved by the University Board of Trustees. ·       
  One University employee was paid $12,000 on a consulting contract after
  he had become a full time faculty member. (Finding 9, Pages 23-24)   We recommended that the University establish internal controls to
  ensure compliance with the Illinois Procurement Code, SAMS Manual, University
  policies and procedures and to ensure that contracts are fully executed prior
  to commencement.   University officials agreed with the recommendation and stated that
  they now have annual training for all fiscal officers to review and explain
  the University’s procurement policies and to reinforce universal application
  of the policy to all areas of University’s operations.     NEED TO IMPROVE CONTROLS OVER
  EMPLOYEE TRAVEL AND USE OF UNIVERSITY CREDIT CARD   The University did not always follow travel policies issued by the
  Illinois Higher Education Travel Control Board and Property Control Rules
  issued by the Department of Central Management Services.  We also noted numerous charges to the
  University credit card that were not supported by appropriate receipts or
  documentation.   During our testing of University credit card expenditures and employee
  travel documents some of the items we found are as follows:   ·       
  Five charges for meals and entertainment expenses totaling $1,095 were
  paid without documentation supporting the specific business purpose. ·       
  A number of restaurant charges totaling $538 were not supported by a
  receipt or documentation identifying any specific business purpose for the
  expenditure.  In addition, four
  airline ticket charges, totaling $1,489, were not documented by receipts or
  specific business purpose. ·       
  Six charges for gasoline, hotel and entertainment expenditures were
  paid by the University and should have been expenses reimbursed by the
  Chicago State University Foundation. 
  The total of these expenditures were $778. ·       
  A direct payment voucher in the amount of $34 was also paid on a credit
  card.  Therefore, the University paid
  twice for the same meal. ·       
  Four charges on the credit card totaling $207, for purchases for the
  President’s residence, were not documented by receipts and therefore the
  items purchased could not be determined.   After bringing these matters to the University’s attention, the
  University provided some of the meeting purposes and itineraries; however,
  this documentation was not presented with the charge card expenses submitted
  for payment by the University. (Finding 11, Pages 27-28)   We recommended that the University implement procedures to ensure
  compliance and require all employees to adhere to regulations established by
  the Higher Education Travel Control Board and Travel Regulation Council.  We further recommended that the University
  recoup the overpayments.   University officials accepted the recommendation and stated that they
  will instigate a second review process for credit card expenditures to
  monitor the completeness of the documentation for the expenditures.   FAILURE TO
  MONITOR COMPLIANCE WITH UNCLAIMED PROPERTY ACT   The University did not have procedures in place to periodically monitor
  unclaimed monies to determine proper and timely disposition of the funds in
  compliance with the Act.   During our audit we noted that the University had three accounts
  included in the accounts payable balance that solely contained stale
  checks.  There was no evidence that
  checks in these accounts had been periodically reviewed to determine the
  status or proper disposition.  Some of
  these checks were issued over ten years ago. 
     The Uniform Disposition of Unclaimed Property Act (765 ILCS 1025/11(a))
  states that every person holding funds or other property, tangible or
  intangible, presumed abandoned under this Act shall report and remit all
  abandoned property specified in the report to the State Treasurer with
  respect to the property as hereinafter provided.     According to the Act (765 ILCS 102/8.1(a)), all tangible personal
  property or intangible personal property and all debts owed or entrusted
  funds or other property held by any federal, state or local government or
  governmental subdivision, agency, entity, officer or appointee thereof, shall
  be presumed abandoned if the property has remained unclaimed for 7 years.
  (Finding 12, Page 29)   We recommended that the University establish appropriate procedures for
  stale checks and comply with the Act. 
 
   University officials agreed with the recommendation and stated that
  they have created a task force to review outstanding stale checks and
  determine their proper disposition.     UNTIMELY RECONCILIATION OF
  AGENCY’S RECORDS TO THE COMPTROLLER’S MONTHLY REPORTS   The University did not perform timely reconciliations of University’s
  records to the Office of the State Comptroller.   During our audit we noted that the reconciliations between the
  University’s expenditures and the Office of the State Comptroller’s Monthly
  Appropriation Status Report for the first five (42%) months of the fiscal
  year were not performed until December of 2006.  And the reconciliations for two (16%) of the remaining seven
  months were each performed one month late. 
  (Finding 14, Page 32)    We recommended that the University comply with SAMS and perform monthly
  reconciliations in a timely manner.   University officials agreed with the recommendation and stated that
  they will take the necessary steps to hire additional staff, which will
  facilitate the timely performance of reconciliations.   NEED TO IMPROVE CONTROLS OVER
  PROPERTY AND EQUIPMENT RECORDS   The University had inadequate controls over its property and equipment
  records.   We toured the University campus and judgmentally selected 25 items for
  review.  After confirming the existence
  of the item we tried to trace it to the property control list maintained by
  the University.  The list provided to
  us by the University is the same one the University provides to the
  Department of Central Management Services (DCMS) for property items with a
  cost of $500 or more.  Further, the
  University, pursuant to its capitalization threshold for financial statement
  reporting purposes, maintains a listing of property and equipment for items
  in excess of $5,000.   In performing our testing of University equipment, we found the
  following: 
 
   
 · Of the 25 items that we observed, 14 items (56%) were not on the property control list. · Three items observed, with a total cost of $16,369 (two copiers and a computer) were not on the property listing as provided to the Department of Central Management Services, however these were included on the University’s property control records used for financial statement reporting purposes. 
 We judgmentally selected 50 items from the University’s property control listing and attempted to locate these items. Some of the exceptions we noted are as follows: 
 · One item (2%) on the property listing could not be located with a total cost of $1,832. This item did not have a description. In addition, another item (ceramic stirrer) (2%) on the property control listing did not have a cost and did not have a location code of the listing. · Six items (12%) were assigned tag number however they did not have tags affixed. These items totaled $99,129. In addition, 9 items (18%) totaling $16,217 did not have tags affixed and were not on the property listing. · One item (2%), a laptop costing $891, could not be located. This had been loaned to a student however the University could not provide us with the documentation. 
 Additionally, one item was listed on the property control records for financial reporting purposes for a value of $521,089 greater than on the property listing. It was determined that the value of the records for financial reporting purposes was incorrect and resulted in an adjustment of $521,089 to assets, and $264,887 to depreciation expense. 
 As a result of the exceptions noted the auditors performed additional testing of the two different property control listings maintained by the University. We judgmentally selected 25 items from the property control listing used for financial statement reporting purposes and tried to locate those items on the property control listing used for DCMS reporting purposes. Ten items (40%) totaling $229,556 could not be found on the DCMS list. 
 The Annual Certification of Inventory submitted to the Department of Central Management Services for the period ended March 31, 2007 was submitted by the University on February 6, 2008. This report was due on July 2, 2007. The University had requested three extensions subsequent to July 2007, with the last requesting an extension until January 14, 2008. (Finding 18, Pages 36-38) This finding was first reported in 1997. 
 We recommended that the University adhere to its procedures to ensure that the property and equipment records are properly maintained and accounted for. 
 University officials agreed with the recommendation and stated that they realize the need to continue to improve controls and procedures over equipment. (For the previous University response, see Digest footnote #2.) 
 
 OTHER FINDINGS
 The remaining findings are reportedly being given attention by University management. We will review the University’s progress toward implementation of our recommendations in our next examination. 
 
 AUDITORS’ OPINION 
 The financial audit report was previously released. Our auditors stated the June 30, 2007 financial statements were fairly presented in all material respects. 
 
 
 
 ___________________________________ WILLIAM G. HOLLAND, Auditor General 
 WGH:TLK:pp 
 
 SPECIAL ASSISTANT AUDITORS 
 Our special assistant auditors for this audit were DeRaimo Hillger & Ripp. 
 
 
 DIGEST FOOTNOTE 
 #1 INADEQUATE SUPPORTING DOCUMENTATION FOR FEDERAL EXPENDITURES - Previous University Response We agree with the recommendation. The University had established control procedures to ensure that prepaid costs are subsequently compared to final actual invoices to ensure prepayments were proper. The University will develop procedures to ensure compliance with travel guidelines and exceptions properly explained and submitted to the Travel Control Board, where necessary. The vehicle was included on the schedule of Property and Equipment supporting the fixed assets reported on its financial statements. The University will arrange to reimburse the Department of Health and Human Services for these loans. 
 #2 INADEQUATE CONTROLS OVER PROPERTY AND EQUIPMENT RECORDS - Previous University Response We agree with the recommendation. The University continues its efforts to improve controls and procedures over equipment. The item (a metal filing cabinet) was reported by the Fiscal Officer to Property Control as scrap and appropriately removed from the Property Module. However, the item was retained by another department for storage until they purchased a replacement. The University plans to appeal to the Illinois Comptroller’ Office to change its procedures pertaining to reporting of CDB transfers. The current accounting systems utilized by the state agencies and universities allow recording such transfers in the quarter they belong.  |