Finding 512252 (2023-006)

Significant Deficiency
Requirement
N
Questioned Costs
-
Year
2023
Accepted
2024-11-26

AI Summary

  • Core Issue: The School Corporation lacked an effective internal control system for managing the Education Stabilization Fund, leading to compliance risks.
  • Impacted Requirements: Failure to meet federal reporting standards and maintain accurate financial disclosures as required by 2 CFR 200.303 and 200.302(b).
  • Recommended Follow-Up: Implement a documented review process by someone other than the report preparer to ensure data accuracy before submission.

Finding Text

Finding 2023-006 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 Federal Award Numbers and Years (or Other Identifying Numbers): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Finding: Significant Deficiency 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. Management misinterpreted the instructions for the reporting requirements and believed that they did not need to fill in the expense information as an LEA. 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 one Annual Data Report for each year in the audit period to the Indiana Department of Education (IDOE) to meet federal reporting requirements for ESSER grant awards. Amounts reported on each ESSER I Annual Data Report did not agree to underlying detail for the ESSER I grant. ESSER I was overstated on the Year 3 report by $76,231. The finding is isolated to the S425D200013 award (ESSER I). Identification as a repeat finding: No. 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

Finding 2023-006 – Education Stabilization Fund – Reporting Contact Person Responsible for Corrective Action: Matthew Parkinson, CFO Contact Phone Number: 317-869-4364 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: MSD Warren will submit a revised ESSER data report to DOE. Anticipated Completion Date: Completed as of the date of this report.

Categories

Internal Control / Segregation of Duties Reporting Significant Deficiency Matching / Level of Effort / Earmarking Subrecipient Monitoring

Other Findings in this Audit

  • 512237 2023-002
    Significant Deficiency
  • 512238 2023-002
    Significant Deficiency
  • 512239 2023-002
    Significant Deficiency
  • 512240 2023-002
    Significant Deficiency
  • 512241 2023-003
    Significant Deficiency Repeat
  • 512242 2023-003
    Significant Deficiency Repeat
  • 512243 2023-003
    Significant Deficiency Repeat
  • 512244 2023-003
    Significant Deficiency Repeat
  • 512245 2023-005
    Significant Deficiency Repeat
  • 512246 2023-005
    Significant Deficiency Repeat
  • 512247 2023-005
    Significant Deficiency Repeat
  • 512248 2023-004
    Significant Deficiency
  • 512249 2023-004
    Significant Deficiency
  • 512250 2023-004
    Significant Deficiency
  • 512251 2023-004
    Significant Deficiency
  • 512253 2023-007
    Material Weakness
  • 1088679 2023-002
    Significant Deficiency
  • 1088680 2023-002
    Significant Deficiency
  • 1088681 2023-002
    Significant Deficiency
  • 1088682 2023-002
    Significant Deficiency
  • 1088683 2023-003
    Significant Deficiency Repeat
  • 1088684 2023-003
    Significant Deficiency Repeat
  • 1088685 2023-003
    Significant Deficiency Repeat
  • 1088686 2023-003
    Significant Deficiency Repeat
  • 1088687 2023-005
    Significant Deficiency Repeat
  • 1088688 2023-005
    Significant Deficiency Repeat
  • 1088689 2023-005
    Significant Deficiency Repeat
  • 1088690 2023-004
    Significant Deficiency
  • 1088691 2023-004
    Significant Deficiency
  • 1088692 2023-004
    Significant Deficiency
  • 1088693 2023-004
    Significant Deficiency
  • 1088694 2023-006
    Significant Deficiency
  • 1088695 2023-007
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.553 School Breakfast Program $5.43M
84.027 Special Education_grants to States $1.79M
10.555 National School Lunch Program $1.32M
93.778 Medical Assistance Program $1.03M
32.009 Emergency Connectivity Fund Program $731,169
10.558 Child and Adult Care Food Program $650,790
84.027 Covid-19 - Special Education_grants to States $452,618
84.425 Covid-19 - Education Stabilization Fund $370,455
84.002 Adult Education - Basic Grants to States $337,628
10.559 Summer Food Service Program for Children $275,485
84.424 Student Support and Academic Enrichment Program $268,465
84.196 Education for Homeless Children and Youth $240,446
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $214,574
84.287 Twenty-First Century Community Learning Centers $211,558
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $176,372
12.357 Rotc Language and Culture Training Grants $147,853
16.710 Public Safety Partnership and Community Policing Grants $139,839
84.010 Title I Grants to Local Educational Agencies $130,913
84.365 English Language Acquisition State Grants $85,518
21.019 Covid-19 - Coronavirus Relief Fund $69,119
16.839 Stop School Violence $54,450
84.173 Special Education_preschool Grants $54,291
84.173 Covid-19 - Special Education_preschool Grants $50,135
93.575 Child Care and Development Block Grant $28,055
84.334 Gaining Early Awareness and Readiness for Undergraduate Programs $19,998
93.994 Maternal and Child Health Services Block Grant to the States $18,250
10.649 Pandemic Ebt Administrative Costs $11,764
45.310 Grants to States $7,277
84.367 Improving Teacher Quality State Grants $6,992
84.048 Career and Technical Education -- Basic Grants to States $2,502
84.048 Covid-19 - Career and Technical Education -- Basic Grants to States $760