REPORT DIGEST

EASTERN ILLINOIS UNIVERSITY

 

FINANCIAL AUDIT AND COMPLIANCE EXAMINATION

(In Accordance with the
Single Audit Act and OMB Circular A-133)

For the Year Ended:

June 30, 2004

 

Summary of Findings:

Total this audit                          2

Total last audit                          6

Repeated from last audit           1

 

Release Date:

February 17, 2005

 

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 is also available on

the worldwide web at

 

http://www.state.il.us/auditor

 

 

 

 

 

 

 

SYNOPSIS

 

 

¨      The University did not properly follow generally accepted accounting principles for various transactions for the year ended June 30, 2004.

¨      The University is not maintaining adequate internal controls over its purchasing/disbursement system.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

{Expenditures and Activity Measures are summarized on the reverse page.}

 


EASTERN ILLINOIS UNIVERSITY

FINANCIAL AUDIT AND COMPLIANCE EXAMINATION

For The Year Ended June 30, 2004

 

STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS

2004
2003

OPERATING REVENUES

      Student tuition and fees.........................................................................................................

..... Auxiliary enterprises (net of scholarship allowances of $1,134,446)...............................

      Grants and contracts...............................................................................................................

      Sales and services of educational activities........................................................................

      Other..........................................................................................................................................

            Total Operating Revenues..............................................................................................

OPERATING EXPENSES

      Instruction...........................................................................................................................

      Auxiliary enterprises..........................................................................................................

      Institutional support...............................................................................................................

      Student services......................................................................................................................

      Academic support..............................................................................................................

      Operations and maintenance of plant.............................................................................

      Depreciation expense........................................................................................................

      Public service......................................................................................................................

      Student aid..........................................................................................................................

      Research..............................................................................................................................

            Total Operating Expenses..............................................................................................

Operating Loss.............................................................................................................................

NONOPERATING REVENUES (EXPENSES)

      State appropriations................................................................................................................

      Payments on behalf of the University..................................................................................

      Other nonoperating revenues (expenses), net....................................................................

            Total Nonoperating Revenues (Expenses)...................................................................

Income Before Capital Contributions.......................................................................................

Capital appropriations, capital gifts and donated assets.......................................................

INCREASE IN NET ASSETS.....................................................................................................

Net assets, beginning of the year...............................................................................................

Net assets, end of the year..........................................................................................................

 

    $45,670,270

      31,999,799

      13,612,542

        3,722,294

        2,212,998

    $97,217,903

 

    $87,079,406

      24,446,039

      19,358,917

      17,398,558

      15,293,528

      11,497,238

      10,058,204

        7,583,254

        4,353,409

        1,011,479

  $198,080,032

$(100,862,129)

 

    $46,691,598

      59,683,866

       (1,057,176)

  $105,318,288

      $4,456,159

        3,440,112

      $7,896,271

      80,764,665

    $88,660,936

 

    $39,040,593

      30,197,309

      12,627,031

        3,818,914

        2,105,484

    $87,789,331

 

    $58,254,959

      22,523,655

      14,221,718

      13,933,442

      11,329,819

      10,286,699

        8,613,345

        6,898,650

        3,927,293

        1,068,794

  $151,058,374

   $(63,269,043)

 

    $50,461,113

      19,568,936

       (1,167,914)

    $68,862,135

      $5,593,092

        4,112,416

      $9,705,508

      71,059,157

    $80,764,665

SELECTED ACCOUNT BALANCES

JUNE 30, 2004

JUNE 30, 2003

Cash and investments..................................................................................................................

Capital assets, net of accumulated depreciation......................................................................

Revenue bonds, notes payable and capital lease obligations...............................................

Accrued compensated absences................................................................................................

Net assets.......................................................................................................................................

    $33,979,134

  $143,117,350

    $67,137,170

    $15,078,449

    $88,660,936

    $27,262,450

  $134,120,991

    $62,194,503

    $15,593,689

    $80,764,665

SUPPLEMENTARY INFORMATION (Unaudited)

2004

2003

Average Number of Employees

      Faculty/administrative............................................................................................................

      Civil service..............................................................................................................................

      Student employees..................................................................................................................

            Total Employees................................................................................................................

Selected Activity Measures

Annual full-time equivalent students.........................................................................................

Full-time equivalent costs per student......................................................................................

 

930

819

275

2,024

 

9,911

$13,031

 

877

832

329

2,038

 

9,628

$11,145

UNIVERSITY PRESIDENT

During Audit Period and Currently: Mr. Louis V. Hencken (Interim President until 9/30/03)


 

 

 

 

 

 

 

 

 

 

 

 


Failure to apply the appropriate accounting principles resulted in inaccurate and incomplete financial statements

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Accounts payable personnel can access the vendor database

 

 

 

Purchasing personnel have the right to process invoices and override budgetary controls

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

FINDINGS, CONCLUSIONS, AND RECOMMENDATIONS

 

NEED TO IMPROVE UPON THE APPLICATION OF GENERALLY ACCEPTED ACCOUNTING PRINCIPLES FOR FINANCIAL REPORTING

 

      The University did not properly follow generally accepted accounting principles (GAAP) for various transactions for the year ended June 30, 2004.

 

      We noted the following in our audit of the financial statements: 

 

·        The University had not properly reported an advance of $250,000 on an insurance reimbursement received before June 30, 2004.

 

·        The University had not properly reported $789,599 in expenses relating to a fire that occurred on campus.

 

·        The University had not properly eliminated $349,288 in internal accounts payable and accounts receivable charges.

 

·        The University failed to capitalize approximately $81,000 of interest expense on construction in progress costs for the year ended June 30, 2004.

 

With the exception of the capitalized interest amount of $81,000, the audited financial statements for the year ended June 30, 2004 have been adjusted for these noted eliminations, omissions and misclassifications. (Finding 1, Pages 28-30)

 

We recommended that the University take specific steps to ensure that certain financial information is included in the University’s financial statements.  Specifically, the University should:

 

1)      Report insurance recoveries as nonoperating gains or losses on involuntary conversions in the preparation of the financial statements;

2)      Capitalize costs incurred in the preparation of a building for restoration as required by GAAP;

3)      Report nonoperating expenses as such in the preparation of the financial statements;

4)      Examine its accounts receivable and accounts payable to ascertain that all internal receivables and payables have been properly eliminated in the preparation of the financial statements; and

5)      Compute the capitalized interest expense amount for inclusion within its financial records.

 

      University officials agreed with the finding and recommendation.

 

NEED TO IMPROVE INTERNAL CONTROLS RELATED TO THE PURCHASING/ DISBURSEMENT SYSTEM

 

      The University is not maintaining adequate internal controls over its purchasing/disbursement system.

 

      During our testing, we noted the following internal control deficiencies over the purchasing and cash disbursements systems:

 

·        Accounts payable personnel have access to the vendor database on the computer system.  

 

·        Purchasing personnel have the right to process invoices for payment.

 

·        All purchasing personnel have been given access to override the budgetary controls on the purchasing system if a purchase order amount would cause the account to go over budget. 

 

      Although no improper purchases were noted in our current audit testing, failure to establish proper internal controls over the purchasing and disbursement systems creates an opportunity for fraudulent purchases and could, at a minimum, lead to the improper and unauthorized use of University assets.  University expenses excluding salary, benefits and depreciation exceeded $38 million in the fiscal year ended June 30, 2004. (Finding 2, pages 31-33)  This finding was first reported in 2003.

 

      We recommended the following actions to strengthen the internal controls over the purchasing/disbursement system:

 

·        Limit the access to the vendor database by allowing only one employee from accounts payable access to it.

 

·        Eliminate the right of purchasing personnel to process invoices for payment.

 

·        Limit the access to override the purchasing system budgetary controls to only two to three employees to maintain accountability.

 

      University officials disagreed with our recommendations to strengthen the internal controls over purchasing and disbursement systems.  In summary, the University believes there are adequate compensating controls in place to provide assurance that there are no improper or unauthorized uses of University assets.  (For the previous agency response, see Digest Footnote.)

 

      In our Auditors’ Comment, we noted our recommendations allow the University officials some flexibility.  We reiterated our position and views relating to internal controls over purchasing and accounts payable functions.

 

Mr. Jeffrey L. Cooley, Vice President for Business Affairs, provided responses to the findings and recommendations.

 

AUDITORS' OPINION

 

      Our auditors state the Eastern Illinois University's financial statements as of and for the year ended June 30, 2004 are fairly presented in all material respects.

 

 

____________________________________

WILLIAM G. HOLLAND, Auditor General

 

WGH:TLK:pp

 

SPECIAL ASSISTANT AUDITORS

 

      Doehring, Winders & Co. LLP were our special assistant auditors on this engagement.

 

 

DIGEST FOOTNOTE

 

PURCHASING/DISBURSEMENT SYSTEM INTERNAL CONTROL DEFICIENCIES – Previous University Response

The University partially accepts the recommendations to strengthen the internal controls over the purchasing and disbursements systems.

 

The University agrees that Accounts Payable (AP) employees should not have access to purchasing screens that lead to the creation of a purchase order and have corrected this situation.

 

The University disagrees with the recommendation to limit the access to the vendor database to only one AP employee.  Currently, four AP employees (three clerks and a supervisor) have access to the vendor database.  The recommendation that only one AP employee have access does not allow for employees being absent for vacations, illness or other circumstances.  The University believes it has restricted employee access to the database to the minimum number necessary to process payments in a timely manner.

 

The University disagrees with the auditors’ recommendation to eliminate the ability of Purchasing personnel to invoice because adequate compensating controls are in place.  Purchasing personnel must acquire fiscal agent approval on all invoices before forwarding them to AP.  AP will not complete the payment process and write the check without the fiscal agent’s approval.  All checks are reviewed and dispersed by AP personnel who do not process invoices or have access to the vendor database.

 

The University disagrees with limiting override access in budgetary controls to only two or three employees.  The University believes there is accountability in place, as Purchasing employees acquire approval from Accounting Office personnel before proceeding with any overrides, and fiscal agents are responsible for monitoring activity in their accounts.

 

The University further disagrees that there is not a proper audit trail for purchase order changes.  The date, amount, and the identity of the employee making the change are recorded on the transaction feed to the automated accounting system.  The reason and authority for a change are noted in the purchasing contract file and/or noted in the automated purchasing system.

 

The University believes there are adequate compensating controls in place to provide reasonable assurance that there are no improper or unauthorized uses of University assets.  As noted by the auditors, no improper purchases were noted during the audit.