Audit 325286

FY End
2024-06-30
Total Expended
$21.28M
Findings
14
Programs
16
Year: 2024 Accepted: 2024-10-21
Auditor: Scheffel Boyle

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
503194 2024-002 Significant Deficiency Yes L
503195 2024-003 Significant Deficiency - H
503196 2024-002 Significant Deficiency Yes L
503197 2024-002 Significant Deficiency Yes L
503198 2024-002 Significant Deficiency Yes L
503199 2024-004 Significant Deficiency Yes L
503200 2024-005 Significant Deficiency - F
1079636 2024-002 Significant Deficiency Yes L
1079637 2024-003 Significant Deficiency - H
1079638 2024-002 Significant Deficiency Yes L
1079639 2024-002 Significant Deficiency Yes L
1079640 2024-002 Significant Deficiency Yes L
1079641 2024-004 Significant Deficiency Yes L
1079642 2024-005 Significant Deficiency - F

Contacts

Name Title Type
CACCK5AKRN81 Kim Nixon Auditee
6184742600 Robyn Klingler Auditor
No contacts on file

Notes to SEFA

Title: OTHER INFORMATION Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Alton Community Unit School District #11 and is presented on the modified cash basis of accounting. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. De Minimis Rate Used: N Rate Explanation: Restricted rate of 2.98% and unrestricted rate of 21.91% There was no insurance coverage in effect paid with Federal funds during the year. There were no loans/loan guarantees outstanding at June 30. The District has no Federal grants requiring matching expenditures during the fiscal year ended June 30.
Title: SUBRECIPIENTS Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Alton Community Unit School District #11 and is presented on the modified cash basis of accounting. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. De Minimis Rate Used: N Rate Explanation: Restricted rate of 2.98% and unrestricted rate of 21.91% No federal awards were provided to subrecipients for the year ended June 30, 2024.
Title: NONCASH ASSISTANCE Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Alton Community Unit School District #11 and is presented on the modified cash basis of accounting. The information in this schedule is presented in accordance with the requirements of the Office of Management and Budget Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards. Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. De Minimis Rate Used: N Rate Explanation: Restricted rate of 2.98% and unrestricted rate of 21.91% The following amounts were expended in the form of non-cash assistance by Alton Community Unit School District No. 11 and should be included in the Schedule of Expenditures of Federal Awards: NON-CASH COMMODITIES (AL 10.555): $150,254. OTHER NON-CASH ASSISTANCE - DEPT. OF DEFENSE FRUIT & VEGETABLES = $93,508. Total = $243,762.

Finding Details

Reporting. The District did not submit timely expenditure reports. The Illinois State Board of Education requires that expenditure reports be submitted on a quarterly basis 20 days after the quarter ends. No questioned costs. Of the 10 quarterly expenditure reports for fiscal year 2024 that were submitted to the Illinois State Board of Education for the IDEA Cluster, five were not filed by the required due date of 20 days after the quarter ends. Late filing of expenditure reports. Five expenditure reports for the IDEA Cluster were submitted after the due date. The District must submit timely quarterly expenditure reports to the Illinois State Board of Education. The District will submit timely periodic expenditure reports.
Period of Performance. Expenditures were reported in an incorrect quarter to the Illinois State Board of Education. No questioned costs. Of the 25 expenditures tested for the IDEA Cluster, two were reported in the June 30, 2024 expenditure report to the Illinois State Board of Education when they were incurred in a prior quarter of the fiscal year. The expenditures were reported on a quarterly expenditure report to the Illinois State Board of Education that did not match the quarter that the expenditure was incurred . The expenditure was applied to the grant via journal entry to the general ledger in the quarter ending June 30, 2024 when the expenditure had been incurred by the District in a prior quarter during the fiscal year. The District should report expenditures to the Illinois State Board of Education in the quarter that the expenditure is incurred. The District finance team will continue to monitor reporting by grant coordinators to ensure accurate reporting.
Reporting. The District did not submit timely expenditure reports. The Illinois State Board of Education requires that expenditure reports be submitted on a quarterly basis 20 days after the quarter ends. No questioned costs. Of the 10 quarterly expenditure reports for fiscal year 2024 that were submitted to the Illinois State Board of Education for the IDEA Cluster, five were not filed by the required due date of 20 days after the quarter ends. Late filing of expenditure reports. Five expenditure reports for the IDEA Cluster were submitted after the due date. The District must submit timely quarterly expenditure reports to the Illinois State Board of Education. The District will submit timely periodic expenditure reports.
Reporting. The District did not submit timely expenditure reports. The Illinois State Board of Education requires that expenditure reports be submitted on a quarterly basis 20 days after the quarter ends. No questioned costs. Of the 10 quarterly expenditure reports for fiscal year 2024 that were submitted to the Illinois State Board of Education for the IDEA Cluster, five were not filed by the required due date of 20 days after the quarter ends. Late filing of expenditure reports. Five expenditure reports for the IDEA Cluster were submitted after the due date. The District must submit timely quarterly expenditure reports to the Illinois State Board of Education. The District will submit timely periodic expenditure reports.
Reporting. The District did not submit timely expenditure reports. The Illinois State Board of Education requires that expenditure reports be submitted on a quarterly basis 20 days after the quarter ends. No questioned costs. Of the 10 quarterly expenditure reports for fiscal year 2024 that were submitted to the Illinois State Board of Education for the IDEA Cluster, five were not filed by the required due date of 20 days after the quarter ends. Late filing of expenditure reports. Five expenditure reports for the IDEA Cluster were submitted after the due date. The District must submit timely quarterly expenditure reports to the Illinois State Board of Education. The District will submit timely periodic expenditure reports.
Reporting. The expenditure reports filed with the Illinois State Board of Education do not match the general ledger detail. No questioned costs. The District reported expenditures totaling $1,099,218 for fiscal year 2024 for the ESSER 2 grant, but the general ledger only showed $1,099,021. The discrepancies were noted in function 1000 and object 100 of $176, and in function 1000 and object 200 of $21, totaling $197. The general ledger does not match the expenditure report filed with the Illinois State Board of Education for the functions and objects noted above. The District did not ensure the grant budget and the functions of the general ledger matched before processing grant expenditures. The expenditure reports filed with the Illinois State Board of Education should match the general ledger of the District's accounting system by function and object. To ensure that expenditure reports and the general ledger detail match, the District will provide training for grant managers regarding coding all payments to match the ISBE budget detail for grant functions before processing payments.
Equipment/Real Property Management. The District's capital outlay log for the ESSER 3 grant did not reconcile back to the capital outlay 500 objects noted in the general ledger. No questioned costs. The District failed to include in its capital outlay log for ESSER 3 an item expensed in a 500 object that was over its capitalization threshhold of $5,000. Further, the dollar amount for another capital outlay expense included in the log did not match what was in the general ledger and reported to the Illinois State Board of Education. The capital outlay log for ESSER 3 was not completed correctly. The District inadvertently did not have its capital outlay log for ESSER 3 reconciled back to the general ledger. The District should follow its capitalization policy and further reconcile the capital outlay log for the ESSER 3 grant back to supporting documentation in the capital outlay 500 objects in the general ledger. The District finance department will work with grant coordinators through training and reconciling of capital outlay objects to ensure all items over the District threshold are logged and reported accurately.
Reporting. The District did not submit timely expenditure reports. The Illinois State Board of Education requires that expenditure reports be submitted on a quarterly basis 20 days after the quarter ends. No questioned costs. Of the 10 quarterly expenditure reports for fiscal year 2024 that were submitted to the Illinois State Board of Education for the IDEA Cluster, five were not filed by the required due date of 20 days after the quarter ends. Late filing of expenditure reports. Five expenditure reports for the IDEA Cluster were submitted after the due date. The District must submit timely quarterly expenditure reports to the Illinois State Board of Education. The District will submit timely periodic expenditure reports.
Period of Performance. Expenditures were reported in an incorrect quarter to the Illinois State Board of Education. No questioned costs. Of the 25 expenditures tested for the IDEA Cluster, two were reported in the June 30, 2024 expenditure report to the Illinois State Board of Education when they were incurred in a prior quarter of the fiscal year. The expenditures were reported on a quarterly expenditure report to the Illinois State Board of Education that did not match the quarter that the expenditure was incurred . The expenditure was applied to the grant via journal entry to the general ledger in the quarter ending June 30, 2024 when the expenditure had been incurred by the District in a prior quarter during the fiscal year. The District should report expenditures to the Illinois State Board of Education in the quarter that the expenditure is incurred. The District finance team will continue to monitor reporting by grant coordinators to ensure accurate reporting.
Reporting. The District did not submit timely expenditure reports. The Illinois State Board of Education requires that expenditure reports be submitted on a quarterly basis 20 days after the quarter ends. No questioned costs. Of the 10 quarterly expenditure reports for fiscal year 2024 that were submitted to the Illinois State Board of Education for the IDEA Cluster, five were not filed by the required due date of 20 days after the quarter ends. Late filing of expenditure reports. Five expenditure reports for the IDEA Cluster were submitted after the due date. The District must submit timely quarterly expenditure reports to the Illinois State Board of Education. The District will submit timely periodic expenditure reports.
Reporting. The District did not submit timely expenditure reports. The Illinois State Board of Education requires that expenditure reports be submitted on a quarterly basis 20 days after the quarter ends. No questioned costs. Of the 10 quarterly expenditure reports for fiscal year 2024 that were submitted to the Illinois State Board of Education for the IDEA Cluster, five were not filed by the required due date of 20 days after the quarter ends. Late filing of expenditure reports. Five expenditure reports for the IDEA Cluster were submitted after the due date. The District must submit timely quarterly expenditure reports to the Illinois State Board of Education. The District will submit timely periodic expenditure reports.
Reporting. The District did not submit timely expenditure reports. The Illinois State Board of Education requires that expenditure reports be submitted on a quarterly basis 20 days after the quarter ends. No questioned costs. Of the 10 quarterly expenditure reports for fiscal year 2024 that were submitted to the Illinois State Board of Education for the IDEA Cluster, five were not filed by the required due date of 20 days after the quarter ends. Late filing of expenditure reports. Five expenditure reports for the IDEA Cluster were submitted after the due date. The District must submit timely quarterly expenditure reports to the Illinois State Board of Education. The District will submit timely periodic expenditure reports.
Reporting. The expenditure reports filed with the Illinois State Board of Education do not match the general ledger detail. No questioned costs. The District reported expenditures totaling $1,099,218 for fiscal year 2024 for the ESSER 2 grant, but the general ledger only showed $1,099,021. The discrepancies were noted in function 1000 and object 100 of $176, and in function 1000 and object 200 of $21, totaling $197. The general ledger does not match the expenditure report filed with the Illinois State Board of Education for the functions and objects noted above. The District did not ensure the grant budget and the functions of the general ledger matched before processing grant expenditures. The expenditure reports filed with the Illinois State Board of Education should match the general ledger of the District's accounting system by function and object. To ensure that expenditure reports and the general ledger detail match, the District will provide training for grant managers regarding coding all payments to match the ISBE budget detail for grant functions before processing payments.
Equipment/Real Property Management. The District's capital outlay log for the ESSER 3 grant did not reconcile back to the capital outlay 500 objects noted in the general ledger. No questioned costs. The District failed to include in its capital outlay log for ESSER 3 an item expensed in a 500 object that was over its capitalization threshhold of $5,000. Further, the dollar amount for another capital outlay expense included in the log did not match what was in the general ledger and reported to the Illinois State Board of Education. The capital outlay log for ESSER 3 was not completed correctly. The District inadvertently did not have its capital outlay log for ESSER 3 reconciled back to the general ledger. The District should follow its capitalization policy and further reconcile the capital outlay log for the ESSER 3 grant back to supporting documentation in the capital outlay 500 objects in the general ledger. The District finance department will work with grant coordinators through training and reconciling of capital outlay objects to ensure all items over the District threshold are logged and reported accurately.