Finding 1117236 (2024-007)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-03-31
Audit: 350448
Auditor: Crowe LLP

AI Summary

  • Core Issue: The School Corporation lacks an effective internal control system, leading to significant errors in annual data reports submitted for the ESSER grants.
  • Impacted Requirements: Compliance with 2 CFR 200.303 and 200.302(b) regarding internal controls and accurate financial reporting is not being met.
  • Recommended Follow-Up: Management should enhance internal controls to ensure that annual data reports align with underlying transaction details before submission.

Finding Text

Information on the federal program: Subject: Education Stabilization Fund (ESSER) – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013, 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 ESSER I amount reported on the Year 3 report ($266,367) did not agree to the underlying expenditure record ($96,019) for the period of July 1, 2021 through June 30, 2022. Additionally, the ESSER II and ESSER III amount reported on the Year 2 report ($1,433,207, and $643,771, respectively) did not agree to the underlying expenditure records ($1,400,698, and $630,465 respectively) for the period of July 1, 2021 through June 30, 2022. We also noted that the ESSER II and ESSER III amounts reported on the Year 3 report ($4,291 and $1,522,378, respectively) did not agree to the underlying expenditure records ($4,590 and $1,774,722, respectively) for the period of July 1, 2022 through June 30, 2023. Additionally, the School Corporation was not able to provide any support for the 288 full-time equivalent (FTE) positions on September 30, 2022, reported on the Year 2 CrossAct report or the 338 full-time equivalent (FTE) positions on September 30, 2023, reported on the Year 3 CrossAct report. Crowe also noted that the School Corporation reported 0 full-time equivalent (FTE) positions paid by ESSER on September 2023, but there were ESSER positions reported in the ESSER applications. 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

  • 540781 2024-005
    Significant Deficiency Repeat
  • 540782 2024-005
    Significant Deficiency Repeat
  • 540783 2024-002
    Material Weakness
  • 540784 2024-003
    Material Weakness
  • 540785 2024-004
    Material Weakness Repeat
  • 540786 2024-002
    Material Weakness
  • 540787 2024-003
    Material Weakness
  • 540788 2024-004
    Material Weakness Repeat
  • 540789 2024-002
    Material Weakness
  • 540790 2024-003
    Material Weakness
  • 540791 2024-004
    Material Weakness Repeat
  • 540792 2024-007
    Material Weakness
  • 540793 2024-006
    Material Weakness
  • 540794 2024-007
    Material Weakness
  • 540795 2024-008
    Material Weakness
  • 540796 2024-006
    Material Weakness
  • 540797 2024-007
    Material Weakness
  • 540798 2024-008
    Material Weakness
  • 1117223 2024-005
    Significant Deficiency Repeat
  • 1117224 2024-005
    Significant Deficiency Repeat
  • 1117225 2024-002
    Material Weakness
  • 1117226 2024-003
    Material Weakness
  • 1117227 2024-004
    Material Weakness Repeat
  • 1117228 2024-002
    Material Weakness
  • 1117229 2024-003
    Material Weakness
  • 1117230 2024-004
    Material Weakness Repeat
  • 1117231 2024-002
    Material Weakness
  • 1117232 2024-003
    Material Weakness
  • 1117233 2024-004
    Material Weakness Repeat
  • 1117234 2024-007
    Material Weakness
  • 1117235 2024-006
    Material Weakness
  • 1117237 2024-008
    Material Weakness
  • 1117238 2024-006
    Material Weakness
  • 1117239 2024-007
    Material Weakness
  • 1117240 2024-008
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $2.79M
32.009 Emergency Connectivity Fund Program $499,800
84.010 Title I Grants to Local Educational Agencies $364,371
16.710 Public Safety Partnership and Community Policing Grants $347,149
93.778 Medical Assistance Program $261,509
10.555 National School Lunch Program $224,183
10.553 School Breakfast Program $181,263
84.027 Special Education Grants to States $97,685
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $25,536
10.559 Summer Food Service Program for Children $20,762
84.424 Student Support and Academic Enrichment Program $18,985
84.173 Special Education Preschool Grants $7,292
84.365 English Language Acquisition State Grants $1,495
10.649 Pandemic Ebt Administrative Costs $628
96.001 Social Security Disability Insurance $84