| 
   
   REPORT DIGEST   REGIONAL OFFICE OF EDUCATION #3   BOND, FAYETTE AND EFFINGHAM COUNTIES   FINANCIAL AUDIT (In Accordance with the For the Year Ended: June 30, 2004   Summary of Findings:   Total this audit 5 Total last audit 3 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 Regional Office of Education #3 tracked funding sources by grant income rather than as local, State or federal revenue.   · The Regional Office of Education #3 recorded local support totaling $55,223 as reductions of expenditures rather than as revenues.   ·       
  The Regional
  Superintendent does not review general journal entries prepared by the Program
  Director to allocate expenses between various programs.   ·       
  The Regional
  Office of Education #3 charged programs for budgeted costs rather than actual
  costs incurred for rent, utilities, postage, and copying costs.  This resulted in $26,925 of questioned costs
  and a qualified opinion on compliance for major federal programs.   ·       
  The Regional
  Office of Education #3 did not comply with certain statutory administrative
  requirements.                         
 
 
 
 
 
 
      {Expenditures and Revenues are
  summarized on the reverse page.}    | 
 
                                                                                    
                                                REGIONAL
OFFICE OF EDUCATION #3
 
                                                                  FINANCIAL AUDIT
                                                       For
The Year Ended June 30, 2004)
 
 
| 
      | 
  
  FY 2004 | 
  
  FY 2003 | 
 
  TOTAL REVENUES | 
  
   $1,657,281  | 
  
   $1,719,266  | 
 
| 
   Local sources  | 
  
   $446,388  | 
  
   $317,262  | 
 
| 
   % of Total Revenues  | 
  
   26.93%  | 
  
   18.45%  | 
 
| 
   State Sources  | 
  
   $670,263  | 
  
   $1,325,548  | 
 
| 
   % of Total Revenues  | 
  
   40.44%  | 
  
   77.10%  | 
 
| 
   Federal Sources  | 
  
   $540,630  | 
  
   $76,456  | 
 
| 
   % of Total Revenues  | 
  
   32.62%  | 
  
   4.45%  | 
 
| 
      | 
 ||
| 
   TOTAL EXPENDITURES  | 
  
   $1,666,354  | 
  
   $1,623,477  | 
 
| 
   Salaries and Benefits  | 
  
   $1,074,719  | 
  
   $1,116,826  | 
 
| 
   % of Total Expenditures  | 
  
   64.50%  | 
  
   68.79%  | 
 
| 
   Purchased Services  | 
  
   $400,808  | 
  
   $398,353  | 
 
| 
   % of Total Expenditures  | 
  
   24.05%  | 
  
   24.54%  | 
 
| 
   All Other Expenditures  | 
  
   $190,827  | 
  
   $108,298  | 
 
| 
   % of Total Expenditures  | 
  
   11.45%  | 
  
   6.67%  | 
 
| 
      | 
  
      | 
  
      | 
 
| 
   TOTAL NET ASSETS1  | 
  
   $635,462  | 
  
   $644,535  | 
 
| 
      | 
  
      | 
  
      | 
 
| 
   INVESTMENT IN
  CAPITAL ASSETS1  | 
  
     $39,969  | 
  
     2  | 
 
| 
      | 
 ||
| 
   1        
  In fiscal year 2004,
  Regional Offices of Education implemented Government Accounting Standards
  Board (GASB) Statement No. 34 which established a new financial reporting
  model for state and local governments. 
  Government-wide financial statements are prepared using full accrual
  accounting that reports Total Net Assets. 
   2        
  The financial
  statement opinion was qualified in fiscal year 2003 due to the omission of
  the General Fixed Asset Account Group.                Percentages may not add due
  to rounding.  | 
 ||
 
| 
   REGIONAL
  SUPERINTENDENT    | 
 
| 
   During Audit Period: Honorable Delbert Maroon (retired May 28, 2004) and Honorable Mark Drone (effective May 29, 2004) Currently: Honorable Mark Drone  | 
 
| 
               
   The Regional Office of Education #3 tracked funding sources by grant income rather than as local, State or federal revenue.                             The Regional Office of Education #3 recorded local support totaling $55,223 as reductions of expenditures rather than as revenues.                 
   The Regional
  Superintendent does not review general journal entries prepared by the
  Program Director to allocate expenses between various programs.                           
   The Regional Office
  of Education #3 charged programs for budgeted costs rather than actual costs
  incurred for rent, utilities, postage, and copying costs, resulting in
  $26,925 of questioned costs and a qualified auditor’s opinion for compliance
  with major federal programs.                                        
   The Regional Office
  of Education #3 did not comply with certain statutory administrative
  requirements.  | 
  
  FINDINGS, CONCLUSIONS AND RECOMMENDATIONS  REVENUE CLASSIFICATION   The Regional Office of Education #3 segregates its sources of revenue by grant income in their general ledger rather than as local, State, or federal revenue. The Regional Office of Education #3 is required to maintain their accounting systems consistent with the Illinois State Board of Education Regional Office of Education Accounting Manual which requires the Regional Office of Education #3 to track funding sources as local, State, or federal revenue. (Finding 04-1, page 12). This finding is repeated from our 2003 audit.   The Regional Office of Education #3 accepted the recommendation to identify its revenues as local, State or federal revenue. (For previous Regional Office response, see Digest Footnote #1.)     NETTING
  REVENUES AGAINST EXPENSES   The Regional Office of Education #3 recorded local support totaling $55,223 as reductions of expenditures rather than as revenues. Generally accepted accounting principles require governmental units to report all sources and uses of revenue. (Finding 04-2, page 13).   The Regional Office of Education #3 accepted the recommendation to record all revenues as revenue and not net them against related expenditures.     INADEQUATE REVIEW  The Program Director for Education Services prepares “Transfer Forms” directing the bookkeeping staff to make general journal entries allocating expenses between various programs. The Regional Superintendent does not review these general journal entries. Reasonable controls over compliance with laws and regulations and grant contract provisions require supervisory review of expenditures charged to grant programs. (Finding 04-3, page 14.)   The Regional Office of Education #3 accepted the recommendation that the Superintendent should review and approve all “Transfer Forms” along with supporting information documenting the allocation before the entries are posted to the accounting records.     CHARGING BUDGETED COST RATHER THAN ACTUAL COST   The Regional Office of Education #3 charged programs for budgeted costs rather than actual costs incurred for rent, utilities, postage, and copying costs. Rent and utilities charged to programs were not based on a reasonable allocation, such as square footage utilized compared with the total square footage available. Postage and copying charged to programs was based on what was budgeted and not actual usage. This resulted in $26,925 of questioned costs and a qualified auditor’s opinion on compliance for major federal programs.   OMB Circular A-21, Cost Principles for Education Institutions, states that allowable costs must be based on actual, not budgeted or projected costs. (Finding 04-5, page 17).   The Regional Office of Education #3 accepted the recommendation to develop a reasonable allocation plan for rent and utilities based on square footage utilized by each program compared with total square footage available. In addition, the Regional Office of Education will charge postage and copying expenses to programs based on actual usage.     COMPLIANCE
  WITH STATUTORY REQUIREMENTS            The Regional Office of Education #3
  did not comply with certain statutory administrative requirements.  For example, the Illinois School Code (105
  ILCS 5/3-12) requires that on or before January 1 of each year, the Regional
  Superintendent shall publish in a newspaper of general circulation published
  in the region or post in each school building under his/her jurisdiction,
  certain information regarding the Office’s Institute Fund.  According to the Regional Office, while
  the publication/posting requirement was complied with in prior years, it was
  not done in 2003 due to an oversight. 
     The School Code (105 ILCS 5/3A-7) also requires that the Regional Office annually prepare and submit a budget to the counties for approval by October 1. The Regional Office of Education #3 submitted its budget to the counties on November 17, 2003, more than 6 weeks after the statutory deadline. (Finding 04-4, pages 15, 16).           The Regional Office of Education #3 accepted the recommendation
  to comply with statutory requirements.         AUDITORS’ OPINION        Our auditors state the Regional Office
  of Education       #3’s financial
  statements as of June 30, 2004 are fairly presented in all material respects.                _____________________________________ WILLIAM G. HOLLAND, Auditor General   WGH:KJM:ro     SPECIAL
  ASSISTANT AUDITORS         Our special
  assistant auditors were Kemper CPA Group, LLP.   DIGEST
  FOOTNOTES
  
 #1: REVENUE CLASSIFICATION– Previous Regional Office
  Response   In
  its prior response in 2003, the Regional Office accepted the finding and
  agreed to implement corrective action.   Complete
  Regional Office responses to prior findings are available upon request from
  the Auditor General’s Office.    | 
 
| 
      | 
  
   |