Finding 626549 (2022-007)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-03-26

AI Summary

  • Core Issue: The School Corporation lacked an effective internal control system for managing federal grant compliance, leading to inaccurate reporting of expenditures.
  • Impacted Requirements: Non-compliance with 2 CFR 200.303 and 200.302(b) regarding internal controls and accurate financial reporting.
  • Recommended Follow-Up: Implement a documented review process by someone other than the report preparer to ensure data accuracy before submission.

Finding Text

FINDING 2022-007 Subject: COVID-19 ? Education Stabilization Fund ? Reporting 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, S425U200013 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) to meet federal reporting requirements for ESSER grant awards. The first report was for the period of March 13, 2020 to September 30, 2020 and was due by January 21, 2021. The second report was for the period of October 1, 2020 to June 30, 2021 and was due by May 13, 2022. The amounts reported as expended on the second report did not agree to the underlying expenditure records of the School Corporation. Per discussion with the Treasurer, the amounts reported on the second report were the appropriated amounts, not the actual amounts expended during the period. Therefore, the amounts on the report were overstated by approximately 25% for ESSER I and 280% for ESSER II compared to the correct amounts on the School Corporation?s records. Additionally, for both reports that were submitted, there was no documented review by someone other than the preparer of the report to ensure the information submitted was complete and accurate. Identification as a repeat finding: No. Recommendation: We recommended 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.

Categories

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

Other Findings in this Audit

  • 50097 2022-004
    Material Weakness Repeat
  • 50098 2022-004
    Material Weakness Repeat
  • 50099 2022-004
    Material Weakness Repeat
  • 50100 2022-004
    Material Weakness Repeat
  • 50101 2022-008
    Material Weakness Repeat
  • 50102 2022-009
    Material Weakness Repeat
  • 50103 2022-008
    Material Weakness Repeat
  • 50104 2022-008
    Material Weakness Repeat
  • 50105 2022-005
    Material Weakness
  • 50106 2022-006
    Material Weakness
  • 50107 2022-007
    Material Weakness
  • 50108 2022-005
    Material Weakness
  • 50109 2022-006
    Material Weakness
  • 50110 2022-007
    Material Weakness
  • 50111 2022-005
    Material Weakness
  • 50112 2022-006
    Material Weakness
  • 626539 2022-004
    Material Weakness Repeat
  • 626540 2022-004
    Material Weakness Repeat
  • 626541 2022-004
    Material Weakness Repeat
  • 626542 2022-004
    Material Weakness Repeat
  • 626543 2022-008
    Material Weakness Repeat
  • 626544 2022-009
    Material Weakness Repeat
  • 626545 2022-008
    Material Weakness Repeat
  • 626546 2022-008
    Material Weakness Repeat
  • 626547 2022-005
    Material Weakness
  • 626548 2022-006
    Material Weakness
  • 626550 2022-005
    Material Weakness
  • 626551 2022-006
    Material Weakness
  • 626552 2022-007
    Material Weakness
  • 626553 2022-005
    Material Weakness
  • 626554 2022-006
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Covid-19 - Education Stabilization Fund $608,464
10.553 School Breakfast Program $217,534
84.027 Special Education_grants to States $213,439
10.555 National School Lunch Program $107,401
84.010 Title I Grants to Local Educational Agencies $83,469
93.778 Medical Assistance Program $60,319
84.358 Rural Education $22,583
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $11,217
84.173 Special Education_preschool Grants $10,888
84.424 Student Support and Academic Enrichment Program $9,576
10.559 Summer Food Service Program for Children $5,250
84.367 Supporting Effective Instruction State Grants $4,000