REPORT DIGEST REGIONAL OFFICE OF EDUCATION #27 HENDERSON,
MERCER AND WARREN COUNTIES FINANCIAL AUDIT (In Accordance with the For the Year Ended: June 30, 2004 Summary of Findings: Total this audit 8 Total last audit 7 Repeated from last audit 6 Release Date: April 28, 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 #27 did not have proper segregation of duties. Each of the ROE’s three bookkeepers has the primary responsibility for most of the accounting and financial functions for the programs they individually handle. · The Regional Office of Education #27 did not have adequate controls over cash receipts. · The Regional Office of Education #27 did not have adequate controls over property and equipment. · The Regional Office of Education #27 did not have adequate controls over disbursements. · The Regional Office of Education #27 did not record five bank accounts, with balances totaling $247,904, in the general ledger. Two of the accounts were recorded in the financial statements but the adjustments were not recorded in the general ledger. · The Regional Office of Education #27 did not have employment contracts or formal documentation of rates of pay for several salaried and hourly rate employees tested. · The Regional Office of Education #27’s system of accounts does not report funding sources in accordance with the ROE Accounting Manual. · The Regional Office of Education #27 did not comply with certain statutory administrative requirements.
{Expenditures and Revenues are
summarized on the reverse page.} |
REGIONAL
OFFICE OF EDUCATION # 27
FINANCIAL AUDIT
For
The Year Ended June 30, 2004
|
FY 2004 |
FY 2003 |
TOTAL REVENUES |
$1,224,405 |
$1,101,636 |
Local Sources |
$391,267 |
$262,232 |
% of Total Revenues |
31.96% |
23.80% |
State Sources |
$434,004 |
$531,742 |
% of Total Revenues |
35.45% |
48.27% |
Federal Sources |
$399,134 |
$307,662 |
% of Total Revenues |
32.60% |
27.93% |
|
||
TOTAL EXPENDITURES |
$1,162,610 |
$1,077,855 |
Salaries and Benefits |
$782,255 |
$765,237 |
% of Total Expenditures |
67.28% |
71.00% |
Purchased Services |
$320,863 |
$272,845 |
% of Total Expenditures |
27.60% |
25.31% |
All Other Expenditures |
$59,492 |
$39,773 |
% of Total Expenditures |
5.12% |
3.69% |
|
|
|
TOTAL NET ASSETS1 |
$310,374 |
$248,579 |
|
|
|
INVESTMENT IN
CAPITAL ASSETS1 |
$0 |
$0 |
|
||
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 R. Bruce Hall Currently: Honorable Glen W. Braden |
The Regional Office
of Education #27 did not have proper segregation of duties in its accounting
function. The Regional Office
of Education #27 did not have adequate controls over cash receipts.
The Regional Office
of Education #27 did not have adequate controls over property and equipment.
The Regional Office of Education #27 did not adequate controls over disbursements and expenditures.
The Regional Office of Education #27 did not record
five bank accounts, with balances totaling $247,904, in the general ledger.
Two of the accounts were recorded in the financial statements but the
adjustments were not recorded in the general ledger. The Regional Office
of Education #27 did not have employment contracts or formal documentation of
rates of pay for several salaried and hourly rate employees tested.
The Regional
Office of Education #27’s system of accounts does not report funding sources
in accordance with the ROE Accounting Manual.
The Regional Office of Education #27 did not comply with certain statutory administrative requirements. |
FINDINGS, CONCLUSIONS AND RECOMMENDATIONS INADEQUATE SEGREGATION OF DUTIES The Regional Office of Education #27 did not have proper segregation of duties. Each of the ROE’s three bookkeepers has the primary responsibility for most of the accounting and financial functions for the programs they individually handle. The bookkeepers perform the disbursement functions of invoice processing, check preparation, custodianship of blank checks, recording, and bank reconciliation for those programs. The bookkeepers also perform the functions of receiving, depositing, and recording of cash receipts for those programs. The ROE Operations bookkeeper has custody of the signature stamp. The Regional Superintendent of Schools is responsible for
establishing and maintaining an internal control system to prevent errors and
irregularities. Inadequate
segregation of duties limits the effectiveness and efficiency of the internal
control system and increases the risk that errors or irregularities may occur
and not be detected promptly (Finding 04-1, pages 12 - 14). This finding is repeated from our 2003
audit. The Regional Office of Education #27 accepted the recommendation to strengthen internal controls. Checks received will be date stamped and registered on the bookkeeper’s check registry. The Regional Superintendent will periodically check that deposits are made on a weekly basis, or if needed, twice weekly. The bank reconciliations and deposits are prepared and initialed by the bookkeeper. The Superintendent also initials each deposit and reconciliation report. Unused checks are kept in the Superintendent’s office. (For previous Regional Office response, see Digest Footnote #1.)
INADEQUATE CONTROLS OVER
CASH RECEIPTS The Regional Office of Education #27
did not maintain a logbook of checks received. The receipts were recorded only when they were deposited. Checks received were not restrictively
endorsed. Twelve out of 60 (20%)
receipts tested were deposited from 10 to 112 days after the date of the
check. Sound internal controls require that all checks
received should be deposited promptly and recorded immediately to the
appropriate accounts (Finding 04-2, pages 15-17). This finding is repeated from our 2003 audit. The Regional Office of Education #27
accepted the recommendation stating that checks received will be date stamped
and stamped “for deposit only” and placed in the fire safe by the secretary. The bookkeeper will record the checks in a
register. Receipts will be prepared
for moneys received for the Institute Account and kept on file. The Regional Superintendent will review
the receipts periodically for timely deposits. Transfers between banks and accounts will be recorded properly
by the bookkeeper. (For previous Regional Office response, see Digest
Footnote #2.) INADEQUATE CONTROLS OVER PROPERTY AND EQUIPMENT The Regional Office of Education #27
did not have adequate controls over fixed assets. For example, no formal policies and procedures had been
established to monitor and control equipment and other fixed assets. Fixed asset tag numbers are assigned to
the equipment items but the tags were not affixed to the corresponding
equipment item. A fixed asset listing did not have complete information as to
the function and activity; reference to the acquisition source document;
acquisition date; acquisition cost; vendor; unit charged with custody;
location; fund and account from which purchased; and method of
acquisition. Also, transfers of
equipment from one location to another were not formally documented. The Regional Office of Education (ROE) Accounting Manual requires each ROE to maintain detailed fixed asset records for both accounting purposes as well as insurance purposes, for fixed assets costing $500 or more. In addition, sound internal controls require that policies and procedures on fixed assets cover the acquisition and tagging, recording and reporting, depreciation (if applicable), transfers and dispositions, and physical inventory, and that they be formally documented and consistently applied (Finding 04-3, pages 18-20). This finding is repeated from our 2003 audit. The Regional Office of Education #27 accepted the recommendation stating that tags have been purchased and will be attached for each item on the inventory list. A log will be maintained with the item name, number, location, fund used for purchase and sign out area for transportation to another location. The log will also include a disposal date. The Regional Office will prepare a fixed asset policy and determine a capital outlay threshold. (For previous Regional Office response, see Digest Footnote #3.) INSUFFICIENT CONTROLS OVER DISBURSEMENTS The
Regional Office Education #27 did not have adequate controls over
disbursements and expenditures. For
example, the following was noted during testing of disbursements and
expenditures: ·
Invoices and
supporting documents were not stamped “PAID” or the check number was not
recorded on the invoice to indicate that payment had been made. ·
Eight of 60 (13%)
vouchers tested did not have supporting documents and 3 of 60 (5%) vouchers
tested had supporting documents that did not completely account for the
amount disbursed. ·
No receiving reports
were prepared to document receipt of items purchased nor was there any
acknowledgement of receipt of the items indicated in the invoices attached
for 11 of 60 (18%) vouchers tested. ·
Approval for the
disbursement was not evident on the invoices; 16 of 60 cancelled checks
tested were signed using a signature stamp. Sound internal controls
over cash disbursements require all disbursements to be adequately supported,
approved by authorized personnel, and have supporting documents properly
canceled at time of signature to prevent duplicate payment (Finding 04-4,
pages 21-22). This finding is repeated from our 2003 audit. The Regional Office of
Education #27 accepted the recommendation to ensure that all disbursements are
adequately supported stating that all disbursements will have the check stub
attached as well as stamped “PAID” on the invoices. The Superintendent will also initial all invoices for approval
of payment. When items are ordered,
the packing slip will also be attached upon arrival of the item and the date
of receipt will be indicated. These
will be attached to the check stub upon payment. (For previous Regional Office response, see Digest Footnote
#4.) UNRECORDED AND UNRECONCILED BANK ACCOUNTS The Regional Office of Education #27 did not record five
bank accounts, with balances totaling $247,904, in the general ledger. Two of
these accounts were recorded in the financial statements but the adjustments
were not recorded in the general ledger.
There were also two other bank accounts that had June 30 balances that
had not been reconciled to the Regional Office’s books. Sound internal controls require that accounting records accurately and completely record all transactions of the entity. Balances in the general ledger accounts should be reconciled with the statement of accounts on a regular basis and adjustments recorded timely and correctly in the book of accounts (Finding 04-5 pages, 23-24). This finding is repeated from our 2003 audit. The Regional Office of
Education #27 accepted the recommendation to record these bank accounts in
the general ledger. The Regional
Office responded that the unreconciled differences in bank reconciliations
will be resolved. (For previous
Regional Office response, see Digest Footnote #5.) INADEQUATE DOCUMENTATION OF SALARY RATES The Regional Office of Education #27 did not have employment contracts or formal documentation of rates of pay for several salaried and hourly rate employees tested. Sound internal controls require that payroll rates and amounts be properly authorized and formally documented. Absence of an employee contract and salary rate authorization may result in disputes over salary calculations and inaccurate payroll computations (Finding 04-6, pages 25-26). This finding is repeated from our 2003 audit. The Regional Office of Education #27 agreed with the recommendation stating that contracts will be prepared for all employees. (For previous Regional Office response, see Digest Footnote #6.) INADEQUATE CHART OF ACCOUNTS
The system of accounts maintained by the Regional Office of Education #27 does not correspond with the system of accounts promulgated by the Illinois State Board of Education in the ROE Accounting Manual. The Regional Office maintains its system of accounts based on grants, awards and contracts (programs) it administers. Programs are not maintained in individual separate self-balancing funds. Instead, programs are set-up as cost centers that track only revenues and expenditures by program. In addition, revenues are accounted for using a single revenue code for each program, without regard to the source of the revenue. The Regional Superintendent of Schools in each Regional Office of Education shall maintain accurate financial records in accordance the Regional Office of Education Accounting Manual. The Manual requires the Regional Office of Education #27 to track funding sources as federal, State, or local (Finding 04-7, pages 27-28). The Regional Office of Education #27 accepted the recommendation and stated that it will have all grants use the same terminology and accounts set up in the ROE Accounting Manual. NONCOMPLIANCE WITH STATE MANDATES
The Regional Office of Education #27 did not comply with certain
statutory administrative requirements.
For example, the Illinois School Code (105 ILCS 5/3-6) requires the
Regional Superintendent to report, in writing, to the county board on or
before January 1 of each year, stating:
(1) the balance on hand at the time of the last report, and all
receipts since that date, with the sources from which they were derived; (2)
the amount distributed to each of the school treasurers in his or her county;
and (3) any balance on hand.
The School Code (105 ILCS 5/3-12) also 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 shall post in
each school building under his/her jurisdiction, certain information
regarding the Office’s Institute Fund
(Finding 04-8, pages 29-30).
According to the Regional Office management, for these reports, they
use information contained in their audited financial statements, which were
not available as of January 1, 2004.
The Regional Office said they were unaware they could use financial
information from their accounting records instead of the audited financial
statements. The Regional Office planned to place the financial statements in
the December Newsletter that is distributed to all schools. The Regional Office also planned to send a
copy of the information to the three county boards as well. The Regional Office of Education #27 accepted the recommendation to submit the required information to the County by the deadline as well as comply with the notification requirements of the statutes. AUDITORS’ OPINION Our auditors state the Regional Office
of Education #27’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 E.C. Ortiz & Company, LLP. DIGEST FOOTNOTES
#1: INADEQUATE SEGREGATION OF DUTIES - Previous
Regional Office Response In
its prior response to the June 30, 2003 audit, the Regional Office of
Education #27 accepted the recommendation to strengthen internal
controls. The bookkeeper will record
the checks on a register with the date received. The Regional Superintendent will periodically check that
deposits are made on a weekly basis, or if needed, twice weekly. The bookkeeper will sign the bank
reconciliations, which will in turn be reviewed and signed by the Regional
Superintendent. The Regional
Superintendent’s signature stamp will be in his possession until needed during
his absences. #2: INADEQUATE
CONTROLS OVER CASH RECEIPTS - Previous Regional Office Response In
its prior response to the June 30, 2003 audit, the Regional Office of
Education #27 accepted the recommendation stating that checks received will
be date stamped when possible and stamped “for deposit only” by the
secretary. The bookkeeper will record
the checks in a register listing the date received. Checks will be placed in a fire safe until deposit. The Regional Superintendent will
periodically check to see if the checks have been deposited weekly or twice
weekly if needed. #3: INADEQUATE
CONTROLS OVER PROPERTY AND EQUIPMENT -
Previous Regional Office Response In
its prior response to the June 30, 2003 audit, the Regional Office of
Education #27 accepted the recommendation stating that the current fixed
asset listing has been updated to include the acquisition dates, funding
source, vendor and location of the asset.
It will also show when an item is disposed of and the purchase of new
items. A tagging system and log is
being developed. A log of items that
are loaned out to individual school personnel will be kept. A Capital Outlay Fixed Asset Policy has
been created and signed by the Regional Superintendent. #4: INSUFFICIENT DOCUMENTATION FOR DISBURSEMENTS – Previous Regional
Office Response In
its prior response to the June 30, 2003 audit, the Regional Office of
Education #27 accepted the recommendation stating the bookkeeper will
continue to attach documents to the checks and check stubs for the Regional
Superintendent to sign. A packing
slip indicating the materials have been received will also be attached. A stamp “PAID” with check number and date
has been purchased to stamp the invoice copies. The Regional Superintendent, Grant Coordinator, or
Administrative Personnel will initial each invoice for payment. The Regional Superintendent will keep the
unused checks in his office. #5 UNRECORDED AND UNRECONCILED BANK ACCOUNTS – Previous Regional
Office Response In
its prior response to the June 30, 2003 audit, the Regional Office of
Education #27 accepted the recommendation stating the Regional Office is
currently working on several ways to include these funds in the Quick Books
system. It is still an ongoing
process. The bookkeeper will begin
reconciling the Illinois Funds statements with the Regional Superintendent
reviewing and signing them. #6: INADEQUATE DOCUMENTATION OF SALARY RATES – Previous Regional
Office Response In
its prior response to the June 30, 2003 audit, the Regional Office of
Education #27 accepted the recommendation stating that contracts are being
prepared for all employees. Job
descriptions have been updated and the Regional Superintendent will prepare
statements of payroll changes, such as increases in pay, benefit changes or
changes in job descriptions. Complete Regional Office responses to prior findings are available upon request from the Auditor General’s Office. |