| 
   REPORT DIGEST   REGIONAL OFFICE OF EDUCATION #48   PEORIA
  COUNTY   FINANCIAL AUDIT (In Accordance with the    For the Year Ended: June 30, 2004   Summary of Findings:   Total this audit 3 Total last audit 2 Repeated from last audit 1   Release Date: June 7, 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 #48 prepares its
  financial reports on a cash basis of accounting instead of the accrual and modified
  accrual basis of accounting.    · The Regional Office of Education #48 did not appropriately allocate expenses among the ROE/ISC Operations and Local Workshops funds. The Regional Office also did not correctly record cash transfers among funds.   ·       
  The Regional
  Office of Education #48 did not properly monitor its sub-recipient for the
  Regional Safe Schools Program.                 
                                 {Expenditures and Revenues are
  summarized on the reverse page.}    | 
 
                                                                                    
REGIONAL
OFFICE OF EDUCATION #48
FINANCIAL AUDIT
For
The Year Ended June 30, 2004
 
| 
      | 
  
  FY 2004 | 
  
  FY 2003 | 
 
  TOTAL REVENUES | 
  
   $4,964,500  | 
  
   $3,710,178  | 
 
| 
   Local Sources  | 
  
   $767,139  | 
  
   $1,551,461  | 
 
| 
   % of Total Revenues  | 
  
   15.45%  | 
  
   41.82%  | 
 
| 
   State Sources  | 
  
   $1,299,780  | 
  
   $1,964,418  | 
 
| 
   % of Total Revenues  | 
  
   26.18%  | 
  
   52.95%  | 
 
| 
   Federal Sources  | 
  
   $2,897,581  | 
  
   $194,299  | 
 
| 
   % of Total Revenues  | 
  
   58.37%  | 
  
   5.24%  | 
 
| 
      | 
 ||
| 
   TOTAL EXPENDITURES  | 
  
   $5,040,138  | 
  
   $3,406,702  | 
 
| 
   Salaries and Benefits  | 
  
   $1,507,769  | 
  
   $1,629,170  | 
 
| 
   % of Total Expenditures  | 
  
   29.92%  | 
  
   47.82%  | 
 
| 
   Purchased Services  | 
  
   $1,106,851  | 
  
   $1,103,974  | 
 
| 
   % of Total Expenditures  | 
  
   21.96%  | 
  
   32.41%  | 
 
| 
   All Other Expenditures  | 
  
   $2,425,518  | 
  
   $673,558  | 
 
| 
   % of Total Expenditures  | 
  
   48.12%  | 
  
   19.77%  | 
 
| 
      | 
  
      | 
  
      | 
 
| 
   TOTAL NET ASSETS1  | 
  
   $865,023  | 
  
   $940,661  | 
 
| 
      | 
  
      | 
  
      | 
 
| 
   INVESTMENT IN
  CAPITAL ASSETS1  | 
  
     $138,006  | 
  
     $164,158  | 
 
| 
      | 
 ||
| 
   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 Gerald Brookhart Currently: Honorable Gerald Brookhart  | 
 
| 
                     The Regional Office of Education #48 prepares its financial reports on a cash basis of accounting.                                                               The Regional Office of Education #48 did not appropriately allocate expenses among the ROE/ISC Operations and Local Workshops funds. The Regional Office also did not correctly record cash transfers among funds.                                                                           The Regional Office
  of Education #48 did not properly monitor its sub-recipient for the Regional
  Safe Schools Program.  | 
  
  FINDINGS, CONCLUSIONS AND RECOMMENDATIONS    ACCOUNTING RECORDS MAINTAINED ON A CASH BASIS OF ACCOUNTING   The Regional Office of Education #48 prepares its financial reports on the cash basis of accounting. The Regional Office is not maintaining records of its accounts receivable, accounts payable, and deferred revenue in order to efficiently and effectively convert their financial statements from a cash basis of accounting to the accrual and modified accrual basis of accounting.          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-1, page 11).
  This finding is repeated from our 2003
  audit.   The Regional Office of Education #48 accepted the recommendation, responding that the Regional Office will begin maintaining subsidiary records of accounts receivable, accounts payable, and deferred revenue balances. As of July 1, 2005 all funds received by the Regional Office that are marked for the prior fiscal year will be entered in the computerized bookkeeping system as accounts receivable for that fiscal year. Using the same practice, all items ordered before July 1 and not received prior to that date will be kept on a separate list and entered into the computer system as accounts payable. Revenue received during the prior fiscal year and not totally expended will be transferred from a revenue account to a liability account, and a listing will be kept of these accounts. (For previous Regional Office response, see Digest Footnote #1.)     COMMINGLING OF FUNDS          The Regional Office of
  Education #48 used the ROE/ISC Operations fund and the Local Workshops fund
  to record the payment of salaries and other expenses without properly
  allocating those expenses between these funds.  The Regional Office also used the ROE/ISC Operations fund to
  record the payment of expenses for other funds within the same pooled cash
  account during Fiscal Year 2003.  The
  Regional Office subsequently recorded the expenses to the appropriate
  accounts; however, the expenses in the Operations fund were not adjusted to
  reflect the transfer.  In addition,
  neither the transfer of cash nor an amount due to/from other funds was
  recorded.          Good business practices require the
  Regional Office of Education #48 to transfer cash or record an amount due to
  and from other funds when cash from one fund is used to pay for expenses of
  another fund  (Finding 04-2, page 12
  and 13).          The
  Regional Office of Education #48 accepted the recommendation, responding that
  the Regional Office has created a chart that calculates the percentage of
  expenses that will be allocated between the Local Workshops fund and the
  ROE/ISC Operations fund from this fiscal year forward.  Through communication, training, and
  continuous scheduled meetings, the Regional Office has implemented a
  procedure, which is reviewed regularly during various meeting times, to help
  them better understand and control accounting procedures over pooled cash
  funds and transfers between funds.     INADEQUATE MONITORING OF SUBRECIPIENTS-REGIONAL SAFE SCHOOLS PROGRAM          The
  Regional Office of Education #48 contracted with, and distributed $337,325 in
  federal pass-through funds to, School District #150 to operate the Regional
  Safe School Program for Peoria County. 
  School District #150 submits various reports to the State to satisfy
  financial and compliance requirements; however, the Regional Office does not
  review or approve these reports prior to their submission.  The Regional Office also did not perform
  any other monitoring of the program expenditures.  The lack of adequate monitoring resulted in a qualified opinion
  on compliance for major federal programs.          The
  Regional Office of Education #48 is responsible for monitoring the
  alternative school program in Peoria County. 
  In addition, OMB Circular A-110, “Uniform Administrative Requirements
  for Grants and Agreements with Institutions of Higher Education, Hospitals,
  and other Non-Profit Organizations”, states recipients are responsible for
  managing and monitoring sub-awards to ensure sub- recipients are meeting
  audit requirements (Finding 04-3, pages 14 and 15).          The
  Regional Office of Education #48 agreed with the recommendation, and
  responded that as part of its responsibility for providing a Regional Safe
  Schools Program, the Regional Office now reviews and approves all reports on
  the Regional Safe Schools Program that are submitted to the State by its
  contractor for this program, Peoria School District #150.  The Regional Office also monitors and
  keeps a formal record of all expenditures for this program as submitted to it
  by District #150.     AUDITORS’ OPINION         Our
  auditors state the Regional Office of Education #48’s financial statements as
  of June 30, 2004 are fairly stated in all material respects.     _____________________________________ WILLIAM
  G. HOLLAND, Auditor General   WGH:KJM:ro 
 
 SPECIAL ASSISTANT AUDITORS           Our special assistant
  auditors were Sulaski & Webb, CPAs. 
 
   DIGEST FOOTNOTES
  
 #1: ACCOUNTING
  RECORDS MAINTAINED ON CASH BASIS – Previous Regional Office Response   In its prior response in 2003, the Regional Office
  accepted the finding, responding that
  they have historically prepared financial reports on a cash basis.  The Regional Office stated they are
  transitioning into a modified accrual system through the use of
  vouchers.  Each purchase for end of
  current fiscal year expenses will be done by voucher, making sure that any
  taxes, shipping or additional charges are included.  The actual expense will be recorded in the current fiscal year,
  even if the actual check is issued the following year.     Complete Regional Office responses to prior findings are available
  upon request from the Auditor General’s Office.  |