REPORT DIGEST REGIONAL OFFICE OF EDUCATION #26 HANCOCK
AND MCDONOUGH COUNTIES FINANCIAL AND COMPLIANCE AUDIT (In Accordance with the Single Audit Act
and For the Year Ended: June 30, 2003 Summary of Findings: Total this audit 6 Total last audit 0 Repeated from last audit 0 Release Date: September 16, 2004
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 #26’s system of accounts did not correspond with the system of accounts promulgated by the Illinois State Board of Education in the Regional Office of Education Accounting Manual. The Regional Office of Education #26 also uses a single revenue code without regard to the source of the revenue. · The Regional Office of Education #26 did not have adequate controls over fixed assets. Fixed asset listings had not been maintained or updated with acquisitions or disposals. As a result, the General Fixed Asset Account Group was omitted from the ROE’s financial statements in non-conformity with generally accepted accounting principles. · The Regional Office of Education #26 did not account for one of its cash accounts in the accounting system. · The Regional Office of Education #26 did not maintain a cost allocation plan in accordance with OMB Circular A-87 for indirect costs associated with a direct federal award.
{Expenditures and Revenues are
summarized on the reverse page.} |
REGIONAL OFFICE OF EDUCATION #26
FINANCIAL AND COMPLIANCE AUDIT
For
The Year Ended June 30, 2003
|
FY 2003 |
FY 2002 |
TOTAL REVENUES |
$2,706,470 |
$2,439,207 |
Local Sources |
$462,689 |
$550,909 |
% of Total Revenues |
17.10% |
22.59% |
State Sources |
$1,413,630 |
$1,699,846 |
% of Total Revenues |
52.23% |
69.69% |
Federal Sources |
$830,151 |
$188,452 |
% of Total Revenues |
30.67% |
7.73% |
|
||
TOTAL EXPENDITURES |
$2,574,218 |
$2,387,095 |
Salaries and Benefits |
$1,427,841 |
$1,416,091 |
% of Total Expenditures |
55.47% |
59.32% |
Purchased Services |
$924,837 |
$816,977 |
% of Total Expenditures |
35.93% |
34.22% |
All Other Expenditures |
$221,540 |
$154,027 |
% of Total Expenditures |
8.61% |
6.45% |
|
|
|
COST OF PROPERTY
AND EQUIPMENT |
1 |
$149,905 |
|
||
1 Financial statement
opinion was qualified due to omission of Statement of General Fixed Assets *
Percentages may not add due to rounding. |
REGIONAL
SUPERINTENDENT |
During Audit Period: Honorable Robert Baumann Currently: Honorable Robert Baumann |
The Regional Office
of Education #26’s system of accounts did not correspond with the system of
accounts promulgated by the Illinois State Board of Education in the Regional
Office of Education Accounting Manual.
The Regional Office
of Education #26 did not have adequate controls over fixed assets. The Regional Office
of Education #26 did not account for one of its cash accounts in the
accounting system.
The Regional Office
of Education #26 did not maintain a cost allocation plan in accordance with
OMB Circular A-87 for indirect costs associated with a direct federal award. |
FINDINGS, CONCLUSIONS AND RECOMMENDATIONS CHART OF ACCOUNTS The Regional Office of Education #26’s system of accounts did not correspond with the system of accounts promulgated by the Illinois State Board of Education in the Regional Office of Education (ROE) Accounting Manual. The Regional Office of Education maintains its system of accounts based on the grants, awards and contracts (Programs) it administers. Each Program is maintained in a separate self-balancing fund and the system of accounts is based on the specific reporting requirements of the program. While a number of the programs have similar requirements, not all of the reporting requirements are consistent. In addition, revenues are accounted for using a single revenue code, without regard to the source of the revenue. The Regional Superintendent of Schools is required to maintain accurate financial records. The financial records shall be maintained in accordance with the ROE Accounting Manual, as applicable. (Finding 03-1, pages 12 - 13). The Regional Office of Education #26 accepted the recommendation stating that effective July 1, 2004 the Regional Office implemented a system of accounts in compliance with the Accounting Manual in accordance with the Illinois Administrative Code. INADEQUATE CONTROLS OVER PROPERTY AND EQUIPMENT The Regional Office of Education did not have adequate controls over fixed assets. For example, there were no formal policies or procedures to monitor and control equipment and other fixed assets. Fixed asset listings had not been maintained or updated with acquisitions or disposals. Physical inventories were not consistently performed and reconciled with the fixed asset listings. The balances in the General Fixed Asset Account Group were not recorded in the general ledger. As a result, the General Fixed Asset Account Group was omitted from the ROE’s financial statements in non-conformity with generally accepted accounting principles. The 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 03-2, pages 14 - 16). The Regional Office of Education #26 accepted the recommendation to develop a formal fixed asset policy and procedures manual to effectively monitor property acquisitions, transfers and disposals, and provide for accurate reporting of fixed asset balances. The Regional Office stated they are in the process of developing procedures and documents that will effectively monitor fixed assets. CASH ACCOUNT NOT RECORDED IN THE ACCOUNTING SYSTEM OR FINANCIAL STATEMENTS The Regional Office of Education #26 did not account for one of its cash accounts in the accounting system. The Illinois School Districts Liquid Asset Fund Plus money market account, which had a balance of $84,772 at June 30, 2003, was excluded from the accounting system and financial statements. All cash accounts of the Regional Office of Education #26 should be maintained in the accounting system and recorded in its financial statements in order to properly track all funds maintained by the Regional Office (Finding 03-5, page 19). The Regional Office of Education #26 accepted the recommendation to include the Illinois School Districts Liquid Asset Fund Plus account in the computerized accounting system and financial statements. COST ALLOCATION PLAN FOR DIRECT FEDERAL AWARDS The Regional Office of Education #26 does not allocate indirect costs in accordance with OMB Circular A-87. The Regional Office invoices the various grants and programs it administers for central service activities, including support salaries and related benefits, accounting and secretarial services, and space rent, based on the grant’s budgeted costs (rather than as part of a Cost Allocation Plan). Such salaries and benefits are allowable under Circular A-87, however, where employees work on multiple activities or cost objectives, a distribution of their salaries or wages is required to be documented in accordance with provisions of Circular A-87 or be included in the ROE’s cost allocation plan. Rent costs are also an allowable expenditure, subject to limitations included in Circular A-87. Grants, cost reimbursement contracts and other agreements with the federal government should bear their fair share of costs recognized under principles established by the federal Office of Management and Budget (OMB). Costs are allocable to federal awards if the goods or services involved are chargeable or assignable to the award in accordance with the relative benefits received. Where an accumulation of indirect costs will ultimately result in charges to a federal award, a cost allocation plan is required as described in OMB Circular A-87 (Finding 03-6, pages 20 – 22). The Regional Office of Education #26 accepted the recommendation to develop a cost allocation plan in accordance with OMB Circular A-87. The Regional Office stated they are in the process of developing a cost allocation plan that addresses allowable indirect costs to all applicable programs. OTHER FINDINGS
The remaining findings are reportedly being given attention by Regional Office of Education #26. We will review progress toward the implementation of our recommendations during the next audit. AUDITORS’ OPINION Our auditors state Regional Office of
Education #26’s financial
statements as of June 30, 2003 are fairly presented in all material respects
except for the omission of the General Fixed Asset Account Group. The General Fixed Asset Account Group
should be included in order to conform with Generally Accepted Accounting
Principles.
___________________________________ WILLIAM G. HOLLAND, Auditor General WGH:KJM:ro SPECIAL
ASSISTANT AUDITORS Our special assistant auditors were Sikich Gardner & Co., LLP. |