Finding 43499 (2022-009)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-09-24

AI Summary

  • Core Issue: The School Corporation lacks an effective internal control system, leading to noncompliance with grant reporting requirements.
  • Impacted Requirements: Compliance with 2 CFR 200.303 and 200.302(b) is critical for accurate financial reporting and record-keeping.
  • Recommended Follow-Up: Management should implement robust internal controls to ensure adherence to grant agreements and improve reporting accuracy.

Finding Text

FINDING 2022-009 Subject: COVID-19 - Education Stabilization Fund - Reporting Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 84.425C, 84.425D, 84.425U Federal Award Numbers and Years (or Other Identifying Numbers): S425C200018, S425D200013, S425U200013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context An effective internal control system was not designed nor implemented at the School Corporation to ensure compliance with requirements related to the grant agreement and the Reporting compliance requirement. The School Corporation completed and submitted four annual Data Collection reports (Reports) for the Elementary and Secondary School Emergency Relief (ESSER) grants and two Reports for the Governors Emergency Education Relief (GEER) grant. The reported data on three of the Reports as noted below could not be traced back to records that accumulate or summarize the data; therefore, the accuracy and completeness of the Reports could not be verified. ESSER I, Year 1 Report and GEER I, Year 1 Report The full-time equivalent (FTE) positions could not be verified. A spreadsheet that showed FTE positions was provided for audit; however, the spreadsheet had more FTE positions then what was reported due to the School Corporations software incorrectly assigning FTE positions to all items paid. ESSER III, Year 1 Report The School Corporation's ledgers indicated expenses totaling $43,084 were spent for salaries and stipends during the reporting period. However, these expenditures were not included in the report. The lack of internal controls and noncompliance were systemic issues throughout the audit period. 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. . . . (3) Records that identify adequately the source and application of funds for federally-funded activities. These records must contain information pertaining to Federal awards, authorizations, obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. . . ." 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." 2 CFR 200.334 states in part: "Financial records, supporting documents, statistical records, and all other non-Federal entity records pertinent to a Federal award must be retained for a period of three years from the date of submission of the final expenditure report or, for Federal awards that are renewed quarterly or annually, from the date of the submission of the quarterly or annual financial report, respectively, as reported to the Federal awarding agency or pass-through entity in the case of a subrecipient. . . ." 34 CFR 76.731 states: "A State and a subgrantee shall keep records to show its compliance with program requirements." Cause Management had not developed a system of internal controls that would have ensured compliance with the grant agreement and Reporting compliance requirement. Effect The failure to establish an effective internal control system enabled material noncompliance to go undetected. Noncompliance with the grant agreement and the Reporting compliance requirement could result in the loss of future federal funds to the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the School Corporation's management establish effective internal controls to ensure compliance and comply with the grant agreement and the Reporting compliance requirement. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Corrective Action Plan

FINDING 2022-009 Contact Person Responsible for Corrective Action: Whitney Dixon, Treasurer Contact Phone Number: 574-533-8631 Views of Responsible Official: We concur with the finding. Description of Corrective Action Plan: Documentation to support reporting data will be prepared by the business office. Full-time equivalent positions will be reviewed by the Human Resources department to ensure that the FTE positions reported are accurate. This will be signed by the preparer, Human Resources, and the program administrator. All ledger expenditures will be included in any report requirement. The prepared report and supporting documentation will be reviewed and approved by Assistant Superintendent, Tracey Noe. Anticipated Completion Date: May 2023

Categories

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

Other Findings in this Audit

  • 43470 2022-003
    Material Weakness Repeat
  • 43471 2022-004
    Material Weakness Repeat
  • 43472 2022-003
    Material Weakness Repeat
  • 43473 2022-004
    Material Weakness Repeat
  • 43474 2022-003
    Material Weakness Repeat
  • 43475 2022-004
    Material Weakness Repeat
  • 43476 2022-003
    Material Weakness Repeat
  • 43477 2022-004
    Material Weakness Repeat
  • 43478 2022-003
    Material Weakness Repeat
  • 43479 2022-004
    Material Weakness Repeat
  • 43480 2022-003
    Material Weakness Repeat
  • 43481 2022-004
    Material Weakness Repeat
  • 43482 2022-003
    Material Weakness Repeat
  • 43483 2022-004
    Material Weakness Repeat
  • 43484 2022-003
    Material Weakness Repeat
  • 43485 2022-004
    Material Weakness Repeat
  • 43486 2022-003
    Material Weakness Repeat
  • 43487 2022-004
    Material Weakness Repeat
  • 43488 2022-005
    Material Weakness Repeat
  • 43489 2022-006
    Material Weakness Repeat
  • 43490 2022-007
    Material Weakness
  • 43491 2022-005
    Material Weakness Repeat
  • 43492 2022-006
    Material Weakness Repeat
  • 43493 2022-007
    Material Weakness
  • 43494 2022-005
    Material Weakness Repeat
  • 43495 2022-006
    Material Weakness Repeat
  • 43496 2022-007
    Material Weakness
  • 43497 2022-011
    Material Weakness Repeat
  • 43498 2022-011
    Material Weakness Repeat
  • 43500 2022-010
    Material Weakness
  • 43501 2022-008
    Material Weakness
  • 43502 2022-009
    Material Weakness
  • 43503 2022-008
    Material Weakness
  • 43504 2022-009
    Material Weakness
  • 43505 2022-008
    Material Weakness
  • 43506 2022-009
    Material Weakness
  • 619912 2022-003
    Material Weakness Repeat
  • 619913 2022-004
    Material Weakness Repeat
  • 619914 2022-003
    Material Weakness Repeat
  • 619915 2022-004
    Material Weakness Repeat
  • 619916 2022-003
    Material Weakness Repeat
  • 619917 2022-004
    Material Weakness Repeat
  • 619918 2022-003
    Material Weakness Repeat
  • 619919 2022-004
    Material Weakness Repeat
  • 619920 2022-003
    Material Weakness Repeat
  • 619921 2022-004
    Material Weakness Repeat
  • 619922 2022-003
    Material Weakness Repeat
  • 619923 2022-004
    Material Weakness Repeat
  • 619924 2022-003
    Material Weakness Repeat
  • 619925 2022-004
    Material Weakness Repeat
  • 619926 2022-003
    Material Weakness Repeat
  • 619927 2022-004
    Material Weakness Repeat
  • 619928 2022-003
    Material Weakness Repeat
  • 619929 2022-004
    Material Weakness Repeat
  • 619930 2022-005
    Material Weakness Repeat
  • 619931 2022-006
    Material Weakness Repeat
  • 619932 2022-007
    Material Weakness
  • 619933 2022-005
    Material Weakness Repeat
  • 619934 2022-006
    Material Weakness Repeat
  • 619935 2022-007
    Material Weakness
  • 619936 2022-005
    Material Weakness Repeat
  • 619937 2022-006
    Material Weakness Repeat
  • 619938 2022-007
    Material Weakness
  • 619939 2022-011
    Material Weakness Repeat
  • 619940 2022-011
    Material Weakness Repeat
  • 619941 2022-009
    Material Weakness
  • 619942 2022-010
    Material Weakness
  • 619943 2022-008
    Material Weakness
  • 619944 2022-009
    Material Weakness
  • 619945 2022-008
    Material Weakness
  • 619946 2022-009
    Material Weakness
  • 619947 2022-008
    Material Weakness
  • 619948 2022-009
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.374 Teacher Incentive Fund Fy 2022 $1.90M
84.374 Teacher Incentive Fund Fy 2021 $1.41M
84.425 Education Stabilization Fund Fy 2022 $848,265
84.010 Title I Grants to Local Educational Agencies Fy 2021 $789,944
10.553 School Breakfast Program Fy 2022 $779,613
84.027 Special Education_grants to States Fy 2022 $743,671
10.555 National School Lunch Program Fy 2021 $292,335
84.010 Title I Grants to Local Educational Agencies Fy 2022 $215,048
84.424 Student Support and Academic Enrichment Program Fy 2021 $155,532
84.367 Improving Teacher Quality State Grants Fy 2021 $145,734
10.559 Summer Food Service Program for Children Fy 2022 $139,725
10.559 Summer Food Service Program for Children Fy 2021 $117,188
93.778 Medical Assistance Program Fy 2021 $108,536
10.553 School Breakfast Program Fy 2021 $86,705
10.555 National School Lunch Program Fy 2022 $84,920
84.173 Special Education_preschool Grants Fy 2022 $72,589
84.173 Special Education_preschool Grants Fy 2021 $71,486
93.778 Medical Assistance Program Fy 2022 $67,954
84.367 Improving Teacher Quality State Grants Fy 2022 $67,699
84.425 Education Stabilization Fund Fy 2021 $44,638
84.365 English Language Acquisition State Grants Fy 2021 $25,235
10.649 Pandemic Ebt Administrative Costs Fy 2022 $3,063