Audit 47819

FY End
2022-06-30
Total Expended
$30.32M
Findings
8
Programs
15
Year: 2022 Accepted: 2022-11-13
Auditor: Scheffel Boyle

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
52173 2022-003 Significant Deficiency - L
52174 2022-003 Significant Deficiency - L
52175 2022-002 Significant Deficiency - F
52176 2022-004 Significant Deficiency - L
628615 2022-003 Significant Deficiency - L
628616 2022-003 Significant Deficiency - L
628617 2022-002 Significant Deficiency - F
628618 2022-004 Significant Deficiency - L

Contacts

Name Title Type
PMC4V2ZJDSA6 Dr. Craig Fiegel Auditee
6185667414 Keith Brinkmann Auditor
No contacts on file

Notes to SEFA

Title: NON CASH ASSISTANCE Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Mascoutah Community Unit School District No. 19 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: The auditee did not use the de minimis cost rate. The following amounts were expended in the form of non-cash assistance by Mascoutah Community Unit School District No. 19 and should be included in the Schedule of Expenditures of Federal Awards: NON-CASH COMMODITIES (CFDA 10.555)**: 189,256
Title: subrecipients Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Mascoutah Community Unit School District No. 19 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: The auditee did not use the de minimis cost rate. NONE
Title: OTHER INFORMATION Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Mascoutah Community Unit School District No. 19 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: The auditee did not use the de minimis cost rate. NO INSURANCE COVERAGE IN EFFECT PAID WITH FEDERAL FUNDS DURING THE FISCAL YEAR. NO LOANS/LOAN GUARANTEES OUTSTANDING AT 6/30. THE DISTRICT HAS NO FEDERAL GRANTS REQUIRING MATCHING EXPENDITURES.

Finding Details

'8. Criteria or specific requirement (including statutory, regulatory, or other citation): Reporting '9. Condition: 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. 10. Questioned Costs: No questioned costs. '11. Context: Of the 10 quarterly expenditure reports for project year 2022 that were submitted to the Illinois State Board of Education for the Education Stabilization fund, 4 were not filed by the required due date of 20 days after the quarter ends. '12. Effect: Late filing of expenditure reports. 13. Cause: Due to some uncertainty when reports were needed, the District was late in filing some of the required quarterly reports. 14. Recommendation: The District must submit timely quarterly expenditure reports to the Illinois State Board of Education. The District should consider checking the list of expenditure reports due on the FRIS website frequently. 15. Management's response: The Business Office is aware of quarterly due dates for applied for and approved grants. It will monitor the quarterly due dates of both federal and state grants that have not been approved.
'8. Criteria or specific requirement (including statutory, regulatory, or other citation): Reporting '9. Condition: 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. 10. Questioned Costs: No questioned costs. '11. Context: Of the 10 quarterly expenditure reports for project year 2022 that were submitted to the Illinois State Board of Education for the Education Stabilization fund, 4 were not filed by the required due date of 20 days after the quarter ends. '12. Effect: Late filing of expenditure reports. 13. Cause: Due to some uncertainty when reports were needed, the District was late in filing some of the required quarterly reports. 14. Recommendation: The District must submit timely quarterly expenditure reports to the Illinois State Board of Education. The District should consider checking the list of expenditure reports due on the FRIS website frequently. 15. Management's response: The Business Office is aware of quarterly due dates for applied for and approved grants. It will monitor the quarterly due dates of both federal and state grants that have not been approved.
'8. Criteria or specific requirement (including statutory, regulatory, or other citation: Equipment/Real Property Management '9. Condition: The District budgeted for and included items in capital outlay objects in both the general ledger and Illinois State Board of Education expenditure reports that were below the District's capitalization threshold of $5,000. '10. Questioned Costs: No questioned costs '11. Context: Of the 5 Education Stabilization Fund grants that had expenditures in fiscal year 2022 , one of the grants included items below the capitalization threshold of $5,000 in capital outlay objects. '12. Effect: The District did not follow its capitalization threshold as outlined in its Fixed Asset Policy. 13. Cause: This was an oversight by the grant coordinator as they did not take into consideration the District's capitalization policy when compiling the budget. 14. Recommendation: The District should only include items greater than its $5,000 capitalization threshold in capital outlay objects in its general ledger, budgets, and expenditure reports filed with the Illinois State Board of Education. Items between $5,000 and $500 but still capital in nature should be recorded in the 700 object (non-capital equipment). 15. Management's response: The budget will now include Function 7000 to recognize non-capitalized equipment with purchase price between $500 and $4,999.
'8. Criteria or specific requirement (including statutory, regulatory, or other citation): Reporting: Special reporting. '9. Condition: The District did not submit accurate total additional expenditures in the Expenditures for CWD section of the 2023 Impact Aid application. '10. Questioned Costs: No questioned costs. '11. Context: The District reported total additional expenditures of $8,622,372 for the 2023 application when the amount should have been $8,526,219. '12. Effect: The total additional expenditures under the Expenditures for CWD was overstated by $96,153. 13. Cause: The prior year transportation report total for special ed transportation (FY21) was used instead of the correct current year transportation report total. 14. Recommendation: The District should have a second employee review the Impact Aid application numbers before it is submitted. 15. Management's response: The Business Office will add an additional quality check prior to submitting Impact Aid data.
'8. Criteria or specific requirement (including statutory, regulatory, or other citation): Reporting '9. Condition: 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. 10. Questioned Costs: No questioned costs. '11. Context: Of the 10 quarterly expenditure reports for project year 2022 that were submitted to the Illinois State Board of Education for the Education Stabilization fund, 4 were not filed by the required due date of 20 days after the quarter ends. '12. Effect: Late filing of expenditure reports. 13. Cause: Due to some uncertainty when reports were needed, the District was late in filing some of the required quarterly reports. 14. Recommendation: The District must submit timely quarterly expenditure reports to the Illinois State Board of Education. The District should consider checking the list of expenditure reports due on the FRIS website frequently. 15. Management's response: The Business Office is aware of quarterly due dates for applied for and approved grants. It will monitor the quarterly due dates of both federal and state grants that have not been approved.
'8. Criteria or specific requirement (including statutory, regulatory, or other citation): Reporting '9. Condition: 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. 10. Questioned Costs: No questioned costs. '11. Context: Of the 10 quarterly expenditure reports for project year 2022 that were submitted to the Illinois State Board of Education for the Education Stabilization fund, 4 were not filed by the required due date of 20 days after the quarter ends. '12. Effect: Late filing of expenditure reports. 13. Cause: Due to some uncertainty when reports were needed, the District was late in filing some of the required quarterly reports. 14. Recommendation: The District must submit timely quarterly expenditure reports to the Illinois State Board of Education. The District should consider checking the list of expenditure reports due on the FRIS website frequently. 15. Management's response: The Business Office is aware of quarterly due dates for applied for and approved grants. It will monitor the quarterly due dates of both federal and state grants that have not been approved.
'8. Criteria or specific requirement (including statutory, regulatory, or other citation: Equipment/Real Property Management '9. Condition: The District budgeted for and included items in capital outlay objects in both the general ledger and Illinois State Board of Education expenditure reports that were below the District's capitalization threshold of $5,000. '10. Questioned Costs: No questioned costs '11. Context: Of the 5 Education Stabilization Fund grants that had expenditures in fiscal year 2022 , one of the grants included items below the capitalization threshold of $5,000 in capital outlay objects. '12. Effect: The District did not follow its capitalization threshold as outlined in its Fixed Asset Policy. 13. Cause: This was an oversight by the grant coordinator as they did not take into consideration the District's capitalization policy when compiling the budget. 14. Recommendation: The District should only include items greater than its $5,000 capitalization threshold in capital outlay objects in its general ledger, budgets, and expenditure reports filed with the Illinois State Board of Education. Items between $5,000 and $500 but still capital in nature should be recorded in the 700 object (non-capital equipment). 15. Management's response: The budget will now include Function 7000 to recognize non-capitalized equipment with purchase price between $500 and $4,999.
'8. Criteria or specific requirement (including statutory, regulatory, or other citation): Reporting: Special reporting. '9. Condition: The District did not submit accurate total additional expenditures in the Expenditures for CWD section of the 2023 Impact Aid application. '10. Questioned Costs: No questioned costs. '11. Context: The District reported total additional expenditures of $8,622,372 for the 2023 application when the amount should have been $8,526,219. '12. Effect: The total additional expenditures under the Expenditures for CWD was overstated by $96,153. 13. Cause: The prior year transportation report total for special ed transportation (FY21) was used instead of the correct current year transportation report total. 14. Recommendation: The District should have a second employee review the Impact Aid application numbers before it is submitted. 15. Management's response: The Business Office will add an additional quality check prior to submitting Impact Aid data.