REPORT DIGEST REGIONAL OFFICE OF EDUCATION #32 IROQUOIS/KANKAKEE COUNTIES FINANCIAL AUDIT (In Accordance with the For the Year Ended: June 30, 2007 Summary of Findings: Total this audit 1 Total last audit 2 Repeated from last audit 0 Release Date: September 18, 2008
State of Office of the Auditor General WILLIAM G. HOLLAND AUDITOR GENERAL To obtain a copy of the
Report contact: Office of the Auditor
General
(217) 782-6046 or TTY (888)
261-2887 This Report Digest and Full
Report is also available on the worldwide web at http://www.auditor.illinois.gov |
SYNOPSIS
{Expenditures
and Revenues are summarized on the reverse page.} |
(In Accordance with the Single Audit Act and OMB Circular A-133)
|
FY 2007
|
FY 2006
|
TOTAL REVENUES |
$7,734,947 |
$7,477,732 |
Local Sources |
$1,403,233 |
$1,143,017 |
% of Total Revenues |
18.14% |
15.29% |
State Sources |
$2,643,087 |
$2,316,723 |
% of Total Revenues |
34.17% |
30.98% |
Federal Sources |
$3,688,627 |
$4,017,992 |
% of Total Revenues |
47.69% |
53.73% |
|
||
TOTAL EXPENDITURES |
$7,288,481 |
$7,455,389 |
Salaries and Benefits |
$3,466,302 |
$3,495,939 |
% of Total Expenditures |
47.56% |
46.89% |
Purchased Services |
$2,874,005 |
$2,504,628 |
% of Total Expenditures |
39.43% |
33.60% |
All Other Expenditures |
$948,174 |
$1,454,822 |
% of Total Expenditures |
13.01% |
19.51% |
|
|
|
TOTAL NET ASSETS |
$1,966,855 |
$1,520,389 |
|
|
|
INVESTMENT IN
CAPITAL ASSETS |
$0 |
$0 |
|
||
Percentages may not add due to rounding. |
REGIONAL
SUPERINTENDENT |
During Audit Period: Honorable Kay Pangle Currently: Honorable Kay Pangle |
The Regional Office
of Education #32 did not
prepare bank reconciliations properly and timely for its primary bank
account. In addition, a bank
account was not recorded in the general ledger and no reconciliations were
completed. |
FINDINGS, CONCLUSIONS AND RECOMMENDATIONSINADEQUATE CONTROLS
OVER BANK RECONCILIATION PROCESS
Effective internal control policies require
complete and accurate accounting records of all transactions of the
entity. Sound internal control also
requires bank reconciliations to be performed monthly to ensure that all
transactions have been recorded.
Reconciling items should be investigated immediately and adjustments
made to the general ledger. The Iroquois-Kankakee
Regional Office of Education #32 had cash and investment balances totaling
$2,378,065 as of June 30, 2007. During
our review of the Regional Office’s monthly cash and bank reconciliations, we
noted the following:
A bank account (Illinois Funds) with an ending balance of $30,706 as of June 30, 2007 was not recorded in the general ledger and, consequently, no reconciliations were completed for this account. This bank account serves as a pass through account for monies received from the Illinois State Board of Education for distribution to other funds. This account was opened in prior years and has been included in cash balances reported in the audited financial statements through adjusting entries. Failure to prepare bank reconciliations properly and on a timely basis may lead to loss or misuse of assets due to improper control and monitoring of bank accounts. Also, failure to record a bank account in the general ledger results in inaccurate and incomplete financial reporting and increases the risk of unauthorized transactions not being detected timely or not being detected at all, which could result in misappropriation of assets. (Finding 07-1, pages 12-14) According to Regional Office management, reconciliations of the primary bank account have not balanced starting July 2006 due to the migration to the new accounting system and an increase in the volume of transactions since the primary operating fund account was merged with the payroll account. The unreconciled differences were due to staff not having sufficient time to investigate the differences. Thus, this resulted to untimely completion of bank reconciliations. The Illinois Funds bank account was established to serve as a clearing bank account until funds are transferred to other funds. Regional Office of Education #32 did not deem it necessary to perform monthly bank reconciliations and maintain the account in the general ledger since deposits are transferred to the respective fund bank accounts on a regular basis. According to Regional Office officials, the balance at any given time is a timing difference as a result of transfers pending receipt of transaction details. Auditors recommended that Regional Office of Education #32 prepare monthly bank reconciliations accurately and on a timely basis. Unreconciled differences should be promptly investigated and bank reconciliations should be properly reviewed by a person independent of the preparer. Auditors also recommended that Regional Office of Education #32 immediately record the Illinois Funds bank account in the general ledger and properly account for all transactions of this account in the books. The Regional Office of Education #32 responded that it has trained an additional staff member to assist with the bank reconciliation duties. This has begun and outside assistance from a software/bookkeeping consultant was enlisted to ensure proper training of the additional staff member and setup of the bank reconciliation procedure. The Regional Office responded that the Regional Superintendent will once again review and initial all bank reconciliations on a monthly basis. The Regional Office also responded that the Illinois Funds account has been assigned a cash account number in the accounting system and those bank reconciliations are being done separately from the primary bank account, going back in the system and beginning with July of 2007. AUDITORS’ OPINION Our auditors state the Regional Office of Education #32’s financial statements as of June 30, 2007 are fairly presented in all material respects. _____________________________________ WILLIAM G. HOLLAND, Auditor General WGH:JRB SPECIAL ASSISTANT AUDITORS Our special assistant auditors were E.C. Ortiz & Co., LLP. |