| 
   REPORT DIGEST   REGIONAL OFFICE OF EDUCATION #41   MADISON COUNTY   FINANCIAL AUDIT (In accordance with the   For the Year Ended: June 30, 2004   Summary of Findings:   Total this audit 5 Total last audit 6 Repeated from last audit 3   Release Date: July 13, 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 #41 did not allocate payroll based on time spent working on each grant.   · The Regional Office of Education #41 did not properly record the entries necessary to reflect payables and receivables for the current and prior year.   · The Regional Office of Education #41 did not reconcile the bank statements to the general ledger until the end of the year. 
 
                       
 
 
 
 
 
 
 
               {Expenditures
  and Revenues are summarized on the reverse page.}  | 
 
 
(In Accordance with the
Single Audit Act and OMB Circular A-133)
 
 
 
| 
      | 
  
  FY 2004 | 
  
  FY 2003 | 
 
  TOTAL REVENUES | 
  
   $6,933,161  | 
  
   $5,694,296  | 
 
| 
   Local Sources  | 
  
   $2,274,881  | 
  
   $1,553,876  | 
 
| 
   % of Total Revenues  | 
  
   32.81%  | 
  
   27.29%  | 
 
| 
   State Sources  | 
  
   $1,104,365  | 
  
   $2,119,840  | 
 
| 
   % of Total Revenues  | 
  
   15.93%  | 
  
   37.23%  | 
 
| 
   Federal Sources  | 
  
   $3,553,915  | 
  
   $2,020,580  | 
 
| 
   % of Total Revenues  | 
  
   51.26%  | 
  
   35.48%  | 
 
| 
      | 
 ||
| 
   TOTAL EXPENDITURES  | 
  
   $6,803,861  | 
  
   $5,767,973  | 
 
| 
   Salaries and Benefits  | 
  
   $3,511,066  | 
  
   $2,899,172  | 
 
| 
   % of Total Expenditures  | 
  
   51.60%  | 
  
   50.26%  | 
 
| 
   Purchased Services  | 
  
   $1,292,414  | 
  
   $1,879,255  | 
 
| 
   % of Total Expenditures  | 
  
   19.00%  | 
  
   32.58%  | 
 
| 
   All Other Expenditures  | 
  
   $2,000,381  | 
  
   $989,546  | 
 
| 
   % of Total Expenditures  | 
  
   29.40%  | 
  
   17.16%  | 
 
| 
      | 
  
      | 
  
      | 
 
| 
   TOTAL NET ASSETS1  | 
  
   $1,961,256  | 
  
   $1,831,956  | 
 
| 
      | 
  
      | 
  
      | 
 
| 
   INVESTMENT IN
  CAPITAL ASSETS1  | 
  
     $121,175  | 
  
     $154,352  | 
 
| 
      | 
 ||
| 
   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. 
  The fiscal year 2003 ending general fixed assets have been restated to
  reflect the changes required as part of the implementation of GASB Statement
  No. 34.               Percentages may not add due to
  rounding.  | 
 ||
 
| 
   REGIONAL
  SUPERINTENDENT    | 
 
| 
   During Audit Period: Honorable Harry Briggs Currently: Honorable Harry Briggs  | 
 
| 
               
   The Regional Office of Education #41 did not allocate
  payroll based on time spent working on each grant.                             
   The Regional Office of Education #41 did not properly
  record the entries necessary to reflect payables and receivables for the
  current and prior year.                                             
   The Regional Office of Education #41 did not reconcile
  the bank statements to the general ledger until the end of the year.                               The Regional Office of Education #41’s expenditure
  report for various grants did not agree with the actual amounts expended as
  shown on the general ledger.                                | 
  
  FINDINGS, CONCLUSIONS AND RECOMMENDATIONS    PAYROLL COSTS NOT PROPERLY ALLOCATED          The Regional Office of
  Education #41 did not allocate payroll based on time spent working on each
  grant.  Rather, payroll was allocated
  based on the grant budget and work completed.          Based on allowable cost
  principles, payroll costs of each employee who works for more than one grant
  must be allocated to each individual grant based on the amount of time spent
  on each grant. (Finding 04-1, page 12)          The Regional Office of
  Education #41 agreed with the recommendation to allocate payroll costs based
  on time spent on each grant.     UNRECORDED PAYABLES AND RECEIVABLES          The Regional Office of
  Education #41 did not properly record the entries necessary to reflect
  payables and receivables for the current and prior year.  The Regional Office did not maintain
  subsidiary records of accounts receivable, accounts payable, and deferred
  revenue.  Accordingly, the Regional
  Office of Education’s general ledger did not agree to the audited financial
  statements.  Adjusting entries were
  required as part of the 2004 year end audit to account for the receivables
  and payables at June 30, 2003 and 2004. 
            Accounting principles
  generally accepted in the United States of America require government-wide
  financial statements to be prepared on the accrual basis of accounting and
  the fund financial statements to be prepared on the modified accrual basis of
  accounting.  (Finding 04-2, page
  13)  This finding is repeated
  from our 2003 audit.   The Regional Office of Education #41 agreed with the recommendation, stating that accurate records will be maintained that reflect receivables and payables at the end of each year. (For previous Regional Office response, see Digest Footnote #1.)     BANK RECONCILIATIONS   Although the Regional Office of Education #41 reviewed bank statements monthly for outstanding items, they were not reconciled to the general ledger until the end of the year. Numerous adjusting entries were required at the end of the year to balance the bank reconciliation with the general ledger.   Bank reconciliations should be completed on a monthly basis and reconciled to the general ledger. (Finding 04-3, page 14) This finding is repeated from our 2003 audit.   The Regional Office of Education #41 accepted the recommendation to have an individual, other than the person preparing the bank reconciliations, verify that the bank reconciliations have been properly prepared, and formally approve them. (For previous Regional Office response, see Digest Footnote #2.)     INACCURATE EXPENDITURE REPORTS FILED   The expenditure report for various grants for the grant period ending June 30, 2004 did not agree with the actual amounts expended as shown on the general ledger. The net difference for 4 programs amounted to $41,161 more expenditures on the general ledger than on the grant expenditure reports.          Grant expenditure reports filed with
  the State should agree to general ledger totals.  (Finding 04-4, page 15) 
  This finding is repeated from our 2003 audit.   The Regional Office accepted the recommendation stating it will correct the expenditure reports and reconcile the program administrative records to the general ledger. (For previous Regional Office response, see Digest Footnote #3.)     OTHER FINDING
  
 The remaining finding is reportedly being given attention by Regional Office of Education #41. We will review progress toward the implementation of our recommendations during the next audit.     AUDITORS’ OPINION         Our auditors state the Regional Office
  of Education #41’s financial statements as of June 30, 2004 are fairly
  presented in all material respects.       _____________________________________ WILLIAM
  G. HOLLAND, Auditor General   WGH:JRB       SPECIAL ASSISTANT AUDITORS           Our special assistant
  auditors were J.W. Boyle & Co., Ltd.   DIGEST
  FOOTNOTES
    #1: UNRECORDED PAYABLES AND RECEIVABLES MATERIAL TO FINANCIAL
  STATEMENTS -- Previous Regional Office Response    In
  its prior response in 2003, the Regional Office accepted the finding and
  stated it will maintain accurate records that will enable it to post
  necessary entries to reflect the receivables and payables at year-end.      #2: BANK RECONCILIATIONS WERE NOT
  RECONCILED TO THE GENERAL LEDGER TIMELY --       Previous Regional Office Response   In its prior response in 2003, the Regional Office accepted the finding stating the
  Accounting Assistant would be doing the bank reconciliations and the Head
  Accountant would verify that all reconciliations are balanced and accurately
  reflected on the general ledger.  The
  Assistant Regional Superintendent would ensure all reconciliations are
  correctly performed and balanced.    #3: INACCURATE GENERAL LEDGER -- 
  Previous Regional Office Response   In its prior response in 2003, the Regional Office accepted the finding stating the Regional Office would provide leadership to assure that the revenues and expenditures per the general ledger agreed with the granting agency.   Complete Regional Office responses to prior findings are available
  upon request from the Auditor General’s Office.    |