Finding 380599 (2023-009)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-03-15

AI Summary

  • Core Issue: The School Corporation lacked a proper system of internal controls, leading to errors in the ESSER I, Year 2 report.
  • Impacted Requirements: Compliance with 2 CFR 200.303 and 200.302(b) regarding effective internal controls and accurate financial reporting.
  • Recommended Follow-Up: Establish a robust internal control system and develop clear policies and procedures for accurate reporting of expenditures.

Finding Text

FINDING 2023-009 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Number: 84.425D Federal Award Number and Year (or Other Identifying Number): S425D200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports, and two ESSER III reports, for a total of six reports. The annual data reports were prepared by the Chief Financial Officer and reviewed by a second knowledgeable individual; however, this process did not allow for the prevention, or detection and correction, of errors prior to submission. INDIANA STATE BOARD OF ACCOUNTS 30 MADISON-GRANT UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Due to the lack of effective internal controls, one of the six annual data reports was not supported by the School Corporation's records. For the ESSER 1, Year 2 report, which covered the period of October 1, 2020 to June 30, 2021, the School Corporation's records did not support the data reported. The total expenditures were not correct and the key line item did not match to the records of the unit. The lack of internal controls and noncompliance were isolated to the ESSER I, Year 2 report. Criteria 2 CFR 200.303 states in part: "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award 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 and 200.329. . . ." 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." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause A proper system of internal controls was not designed by management of the School Corporation. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper implementation of an effectively designed system of internal controls, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, the ESSER I, Year 2 report was not supported by the School Corporation's records. Noncompliance with the provisions of federal statutes, regulations, and the terms and conditions of the federal award could result in the loss of future federal funding to the School Corporation. INDIANA STATE BOARD OF ACCOUNTS 31 MADISON-GRANT UNITED SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure that all expenditures are reported on the reports submitted on behalf of the COVID-19 - Education Stabilization Fund program funds. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report. INDIANA STATE BOARD OF ACCOUNTS 32

Corrective Action Plan

FINDING 2023-009 Finding Subject: Education Stabilization Fund - Reporting Summary of Finding: Material Weakness, Other Matters, Qualified Opinion The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance. The School Corporation was required to submit an annual data report to the Indiana Department of Education (IDOE) via JotForm, a form/report builder. Data to be submitted included, but was not limited to, current period expenditures, prior period expenditures, and expenditures per activity. During the audit period the School Corporation submitted two ESSER I reports, two ESSER II reports and two ESSER III reports, for a total of six reports. The annual data reports were prepared by the Chief Financial Officer and reviewed by a second knowledgeable individual; however, this process did not allow for the prevention, or detection and correction of errors prior to submission. Due to the lack of effective internal controls, one of the six annual data reports was not supported by the School Corporation’s records. For the ESSER 1, Year 2 report, which covered the period of October 1, 2020 to June 30, 2021, the School Corporation’s records did not support the data in the report. The lack of controls and noncompliance were isolated to the ESSER I, Year 2 report. Contact Person Responsible for Corrective Action: Bengamin Mann Contact Phone Number and Email Address: 765-536-0008 bmann@mgusc.k12.in.us Views of Responsible Officials: We concur with the finding Description of Corrective Action Plan: Supporting documentation of data reported will be retained with each report filed. Anticipated Completion Date: February 2024

Categories

Internal Control / Segregation of Duties Subrecipient Monitoring Material Weakness Reporting Matching / Level of Effort / Earmarking Special Tests & Provisions

Other Findings in this Audit

  • 380557 2023-002
    Material Weakness Repeat
  • 380558 2023-002
    Material Weakness Repeat
  • 380559 2023-002
    Material Weakness Repeat
  • 380560 2023-002
    Material Weakness Repeat
  • 380561 2023-002
    Material Weakness Repeat
  • 380562 2023-002
    Material Weakness Repeat
  • 380563 2023-003
    Material Weakness
  • 380564 2023-003
    Material Weakness
  • 380565 2023-003
    Material Weakness
  • 380566 2023-003
    Material Weakness
  • 380567 2023-003
    Material Weakness
  • 380568 2023-003
    Material Weakness
  • 380569 2023-004
    Material Weakness Repeat
  • 380570 2023-004
    Material Weakness Repeat
  • 380571 2023-004
    Material Weakness Repeat
  • 380572 2023-004
    Material Weakness Repeat
  • 380573 2023-004
    Material Weakness Repeat
  • 380574 2023-004
    Material Weakness Repeat
  • 380575 2023-005
    Material Weakness
  • 380576 2023-005
    Material Weakness
  • 380577 2023-005
    Material Weakness
  • 380578 2023-005
    Material Weakness
  • 380579 2023-005
    Material Weakness
  • 380580 2023-005
    Material Weakness
  • 380581 2023-005
    Material Weakness
  • 380582 2023-006
    Material Weakness
  • 380583 2023-006
    Material Weakness
  • 380584 2023-006
    Material Weakness
  • 380585 2023-006
    Material Weakness
  • 380586 2023-006
    Material Weakness
  • 380587 2023-006
    Material Weakness
  • 380588 2023-006
    Material Weakness
  • 380589 2023-007
    Material Weakness
  • 380590 2023-007
    Material Weakness
  • 380591 2023-007
    Material Weakness
  • 380592 2023-007
    Material Weakness
  • 380593 2023-007
    Material Weakness
  • 380594 2023-008
    Material Weakness
  • 380595 2023-008
    Material Weakness
  • 380596 2023-008
    Material Weakness
  • 380597 2023-008
    Material Weakness
  • 380598 2023-008
    Material Weakness
  • 956999 2023-002
    Material Weakness Repeat
  • 957000 2023-002
    Material Weakness Repeat
  • 957001 2023-002
    Material Weakness Repeat
  • 957002 2023-002
    Material Weakness Repeat
  • 957003 2023-002
    Material Weakness Repeat
  • 957004 2023-002
    Material Weakness Repeat
  • 957005 2023-003
    Material Weakness
  • 957006 2023-003
    Material Weakness
  • 957007 2023-003
    Material Weakness
  • 957008 2023-003
    Material Weakness
  • 957009 2023-003
    Material Weakness
  • 957010 2023-003
    Material Weakness
  • 957011 2023-004
    Material Weakness Repeat
  • 957012 2023-004
    Material Weakness Repeat
  • 957013 2023-004
    Material Weakness Repeat
  • 957014 2023-004
    Material Weakness Repeat
  • 957015 2023-004
    Material Weakness Repeat
  • 957016 2023-004
    Material Weakness Repeat
  • 957017 2023-005
    Material Weakness
  • 957018 2023-005
    Material Weakness
  • 957019 2023-005
    Material Weakness
  • 957020 2023-005
    Material Weakness
  • 957021 2023-005
    Material Weakness
  • 957022 2023-005
    Material Weakness
  • 957023 2023-005
    Material Weakness
  • 957024 2023-006
    Material Weakness
  • 957025 2023-006
    Material Weakness
  • 957026 2023-006
    Material Weakness
  • 957027 2023-006
    Material Weakness
  • 957028 2023-006
    Material Weakness
  • 957029 2023-006
    Material Weakness
  • 957030 2023-006
    Material Weakness
  • 957031 2023-007
    Material Weakness
  • 957032 2023-007
    Material Weakness
  • 957033 2023-007
    Material Weakness
  • 957034 2023-007
    Material Weakness
  • 957035 2023-007
    Material Weakness
  • 957036 2023-008
    Material Weakness
  • 957037 2023-008
    Material Weakness
  • 957038 2023-008
    Material Weakness
  • 957039 2023-008
    Material Weakness
  • 957040 2023-008
    Material Weakness
  • 957041 2023-009
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.555 National School Lunch Program 2023 $550,440
10.555 National School Lunch Program 2022 $543,201
84.425 Education Stabilization Fund 2023 $517,866
84.425 Education Stabilization Fund 2022 $417,732
84.010 Title I Grants to Local Educational Agencies 2023 $263,779
84.010 Title I Grants to Local Educational Agencies 2022 $258,963
10.553 School Breakfast Program 2022 $128,915
10.553 School Breakfast Program 2023 $116,149
84.367 Improving Teacher Quality State Grants 2023 $45,784
84.367 Improving Teacher Quality State Grants 2022 $43,904
84.424 Student Support and Academic Enrichment Program 2022 $42,984
84.027 Special Education_grants to States 2023 $30,427
10.559 Summer Food Service Program for Children 2022 $28,442
84.424 Student Support and Academic Enrichment Program 2023 $15,655
84.173 Special Education_preschool Grants 2023 $9,445
10.559 Summer Food Service Program for Children 2023 $2,511
84.027 Special Education_grants to States 2022 $2,190
10.649 Pandemic Ebt Administrative Costs 2023 $628
10.649 Pandemic Ebt Administrative Costs 2022 $614
84.173 Special Education_preschool Grants 2022 $364