Finding 1115472 (2024-004)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-03-28
Audit: 349745
Organization: Milan Community Schools (IN)
Auditor: Crowe LLP

AI Summary

  • Core Issue: The School Corporation lacked an effective internal control system to ensure accurate reporting for the COVID-19 Education Stabilization Fund.
  • Impacted Requirements: Non-compliance with 2 CFR 200.303 and 200.302(b) regarding internal controls and financial reporting led to material errors in annual data reports.
  • Recommended Follow-Up: Management should enhance internal controls to verify that submitted data aligns with underlying records before submission.

Finding Text

Information on the federal program: Subject: COVID-19 – Education Stabilization Fund – Reporting Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Material Weakness Criteria: 2 CFR section 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal awards in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in 'Standards for Internal Control in the Federal Government' issued by the Comptroller General of the United States or the ‘Internal Control Integrated Framework’, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). . . ." 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in §§ 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirements. Cause: The School Corporation's management implemented a review control over the annual data reports; however, it was not sufficient enough to detect and prevent errors in annual data reports submitted to the Indiana Department of Education. Effect: Annual data reports submitted during the audit period to the Indiana Department of Education contained material errors compared to underlying transaction detail for the period reported. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit Annual Data Reports to the Indiana Department of Education (IDOE) during the audit period to meet federal reporting requirements for ESSER grant awards. We noted that the following exceptions in data reporting submissions:  ESSER I Year 4, ESSER II Year 3, and ESSER III Year 3 expenditures for the period of July 1, 2021 through June 30, 2022 ($0, $360,404, and $12,974, respectively) did not agree to underlying expenditure records ($60,937, $490,934, and $477,914, respectively).  ESSER II Year 4 and ESSER III Year 4 expenditures for the period of July 1, 2022 through June 30, 2023 ($57,667 and $363,486, respectively) did not agree to underlying expenditure records ($361 and $400,473, respectively). Identification as a repeat finding: No. Recommendation: We recommend management review internal controls over the review of annual data reports to ensure the data to be submitted agrees to underlying transaction detail or other supporting documentation prior to the submission of the annual data report. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.

Categories

Subrecipient Monitoring Material Weakness Reporting Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 539019 2024-002
    Material Weakness Repeat
  • 539020 2024-002
    Material Weakness Repeat
  • 539021 2024-002
    Material Weakness Repeat
  • 539022 2024-002
    Material Weakness Repeat
  • 539023 2024-002
    Material Weakness Repeat
  • 539024 2024-003
    Material Weakness
  • 539025 2024-003
    Material Weakness
  • 539026 2024-004
    Material Weakness
  • 539027 2024-003
    Material Weakness
  • 539028 2024-004
    Material Weakness
  • 539029 2024-003
    Material Weakness
  • 539030 2024-004
    Material Weakness
  • 539031 2024-003
    Material Weakness
  • 539032 2024-004
    Material Weakness
  • 1115461 2024-002
    Material Weakness Repeat
  • 1115462 2024-002
    Material Weakness Repeat
  • 1115463 2024-002
    Material Weakness Repeat
  • 1115464 2024-002
    Material Weakness Repeat
  • 1115465 2024-002
    Material Weakness Repeat
  • 1115466 2024-003
    Material Weakness
  • 1115467 2024-003
    Material Weakness
  • 1115468 2024-004
    Material Weakness
  • 1115469 2024-003
    Material Weakness
  • 1115470 2024-004
    Material Weakness
  • 1115471 2024-003
    Material Weakness
  • 1115473 2024-003
    Material Weakness
  • 1115474 2024-004
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $584,758
10.553 School Breakfast Program $167,047
84.010 Title I Grants to Local Educational Agencies $149,085
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $125,000
10.555 National School Lunch Program $111,595
32.009 Emergency Connectivity Fund Program $98,176
10.579 Child Nutrition Discretionary Grants Limited Availability $30,000
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $28,047
84.196 Education for Homeless Children and Youth $24,990
93.778 Medical Assistance Program $17,685
84.027 Special Education Grants to States $10,204
84.424 Student Support and Academic Enrichment Program $10,000
10.559 Summer Food Service Program for Children $5,106
10.649 Pandemic Ebt Administrative Costs $628