Finding 522795 (2024-003)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-02-12
Audit: 342172
Auditor: Crowe LLP

AI Summary

  • Core Issue: The School Corporation lacks an effective internal control system, risking noncompliance with federal grant requirements.
  • Impacted Requirements: Compliance with 2 CFR 200.303 and 200.302(b) for accurate financial reporting and internal controls.
  • Recommended Follow-Up: Implement a documented review process by someone other than the report preparer to ensure data accuracy 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.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 had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. Context: The School Corporation was required to submit two 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 II amount reported on the Year 3 report ($572,289) did not agree to the underlying expenditure records ($558,956) for the period of July 1, 2021 through June 30, 2022. Additionally, we noted that the ESSER I, ESSER II, and ESSER III amounts reported on the Year 4 report ($105,506, $510,158, and $1,156,254, respectively) did not agree to the underlying expenditure records ($138,662, $316,236, and $1,158,054, respectively) for the period of July 1, 2022 through June 30, 2023. We also noted there was no documented, secondary review of the information in the annual data reports by someone other than the preparer. Identification as a repeat finding: This is a repeat finding from the immediately prior audit. The prior finding number was 2022-008. Recommendation: We recommend someone other than the preparer of the report perform a documented review prior to submission to validate the accuracy and completeness of the data submitted. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.

Corrective Action Plan

Context: The School Corporation was required to submit two 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 II amount reported on the Year 3 report ($572,289) did not agree to the underlying expenditure records ($558,956) for the period of July 1, 2021 through June 30, 2022. Additionally, we noted that the ESSER I, ESSER II, and ESSER III amounts reported on the Year 4 report ($105,506, $510,158, and $1,156,254, respectively) did not agree to the underlying expenditure records ($138,662, $316,236, and $1,158,054, respectively) for the period of July 1, 2022 through June 30, 2023. Contact Person Responsible for Corrective Action: David Rowe, Business Manager Contact Phone Number: 765-298-6505 Views of Responsible Official: We concur with the finding, while noting that all expenditures and revenue from reimbursements balance within our system. Description of Corrective Action Plan: Verify that all expenditure account numbers match those utilized by AFR and Gateway reporting. Anticipated Completion Date: Begin immediately, ongoing.

Categories

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

Other Findings in this Audit

  • 522791 2024-002
    Material Weakness Repeat
  • 522792 2024-002
    Material Weakness Repeat
  • 522793 2024-002
    Material Weakness Repeat
  • 522794 2024-002
    Material Weakness Repeat
  • 522796 2024-003
    Material Weakness Repeat
  • 522797 2024-004
    Material Weakness
  • 522798 2024-005
    Material Weakness
  • 1099233 2024-002
    Material Weakness Repeat
  • 1099234 2024-002
    Material Weakness Repeat
  • 1099235 2024-002
    Material Weakness Repeat
  • 1099236 2024-002
    Material Weakness Repeat
  • 1099237 2024-003
    Material Weakness Repeat
  • 1099238 2024-003
    Material Weakness Repeat
  • 1099239 2024-004
    Material Weakness
  • 1099240 2024-005
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.553 School Breakfast Program $320,877
84.010 Title I Grants to Local Educational Agencies $285,601
84.011 Migrant Education State Grant Program $177,443
10.555 National School Lunch Program $156,580
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $77,812
84.424 Student Support and Academic Enrichment Program $77,723
84.425 Education Stabilization Fund $31,114
93.778 Medical Assistance Program $22,586
84.027 Special Education Grants to States $10,159
84.173 Special Education Preschool Grants $1,152