Finding 623940 (2022-017)

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

AI Summary

  • Core Issue: The School Corporation lacked a proper system of internal controls, leading to incomplete and inaccurate reporting of ESSER data.
  • Impacted Requirements: Noncompliance with 2 CFR 200.303 and 200.334, which mandate effective internal controls and accurate financial records for federal awards.
  • Recommended Follow-Up: Management should implement a robust internal control system to ensure compliance with grant agreements and improve reporting accuracy.

Finding Text

FINDING 2022-017 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 Numbers and Years (or Other Identifying Numbers): S425D200013, S425D210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Reporting Audit Findings: Material Weakness, Other Matters Condition and Context The School Corporation had not designed nor implemented a system of internal controls to ensure that the four Elementary and Secondary School Emergency Relief (ESSER) annual data reports required to be filed during the audit period were complete and accurate prior to submission. Each of the reports was prepared by one employee without an oversight or review process in place to prevent, or detect and correct, errors. Furthermore, 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 The Full-Time Employee (FTE) Positions as of March 13, 2020, and FTE Positions as of September 30, 2020, were not able to be verified to the School's records. ESSER I, Year 2 Report The Key Line Item, Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Personnel Services - Salary was overstated by $950. An additional Key Line Item, Operational Continuity and Other Allowed Uses - purchased professional services was understated by $138,739. ESSER II, Year 1 Report The Key Line Item, Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Purchased Professional and Technical Services was understated by $111,290. An additional Key Line Item, Meeting Students' Academic, Social, Emotional, and Other Needs (Excluding Mental Health Supports) - Supplies was understated by $6,500. 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.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. . . ." 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, financial 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." Cause Management had not designed nor implemented a system of internal controls that would have ensured compliance with the grant agreement and the Reporting compliance requirement. Effect The failure to establish an effective system of internal controls 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 a system of 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.

Categories

Subrecipient Monitoring Internal Control / Segregation of Duties Matching / Level of Effort / Earmarking Procurement, Suspension & Debarment Material Weakness Reporting

Other Findings in this Audit

  • 47451 2022-003
    Material Weakness
  • 47452 2022-004
    Material Weakness
  • 47453 2022-005
    Material Weakness
  • 47454 2022-003
    Material Weakness
  • 47455 2022-004
    Material Weakness
  • 47456 2022-005
    Material Weakness
  • 47457 2022-003
    Material Weakness
  • 47458 2022-004
    Material Weakness
  • 47459 2022-005
    Material Weakness
  • 47460 2022-003
    Material Weakness
  • 47461 2022-004
    Material Weakness
  • 47462 2022-005
    Material Weakness
  • 47463 2022-003
    Material Weakness
  • 47464 2022-004
    Material Weakness
  • 47465 2022-005
    Material Weakness
  • 47466 2022-003
    Material Weakness
  • 47467 2022-004
    Material Weakness
  • 47468 2022-005
    Material Weakness
  • 47469 2022-003
    Material Weakness
  • 47470 2022-004
    Material Weakness
  • 47471 2022-005
    Material Weakness
  • 47472 2022-003
    Material Weakness
  • 47473 2022-004
    Material Weakness
  • 47474 2022-005
    Material Weakness
  • 47475 2022-008
    Material Weakness
  • 47476 2022-006
    Material Weakness
  • 47477 2022-007
    Material Weakness
  • 47478 2022-008
    Material Weakness
  • 47479 2022-006
    Material Weakness
  • 47480 2022-007
    Material Weakness
  • 47481 2022-010
    Material Weakness
  • 47482 2022-011
    Material Weakness
  • 47483 2022-012
    Material Weakness
  • 47484 2022-013
    Material Weakness
  • 47485 2022-014
    Material Weakness
  • 47486 2022-015
    Material Weakness
  • 47487 2022-010
    Material Weakness
  • 47488 2022-011
    Material Weakness
  • 47489 2022-012
    Material Weakness
  • 47490 2022-013
    Material Weakness
  • 47491 2022-014
    Material Weakness
  • 47492 2022-015
    Material Weakness
  • 47493 2022-018
    Material Weakness
  • 47494 2022-018
    Material Weakness
  • 47495 2022-017
    Material Weakness
  • 47496 2022-018
    Material Weakness
  • 47497 2022-016
    Material Weakness
  • 47498 2022-017
    Material Weakness
  • 47499 2022-018
    Material Weakness
  • 47500 2022-009
    Material Weakness
  • 47501 2022-009
    Material Weakness
  • 623893 2022-003
    Material Weakness
  • 623894 2022-004
    Material Weakness
  • 623895 2022-005
    Material Weakness
  • 623896 2022-003
    Material Weakness
  • 623897 2022-004
    Material Weakness
  • 623898 2022-005
    Material Weakness
  • 623899 2022-003
    Material Weakness
  • 623900 2022-004
    Material Weakness
  • 623901 2022-005
    Material Weakness
  • 623902 2022-003
    Material Weakness
  • 623903 2022-004
    Material Weakness
  • 623904 2022-005
    Material Weakness
  • 623905 2022-003
    Material Weakness
  • 623906 2022-004
    Material Weakness
  • 623907 2022-005
    Material Weakness
  • 623908 2022-003
    Material Weakness
  • 623909 2022-004
    Material Weakness
  • 623910 2022-005
    Material Weakness
  • 623911 2022-003
    Material Weakness
  • 623912 2022-004
    Material Weakness
  • 623913 2022-005
    Material Weakness
  • 623914 2022-003
    Material Weakness
  • 623915 2022-004
    Material Weakness
  • 623916 2022-005
    Material Weakness
  • 623917 2022-008
    Material Weakness
  • 623918 2022-006
    Material Weakness
  • 623919 2022-007
    Material Weakness
  • 623920 2022-008
    Material Weakness
  • 623921 2022-006
    Material Weakness
  • 623922 2022-007
    Material Weakness
  • 623923 2022-010
    Material Weakness
  • 623924 2022-011
    Material Weakness
  • 623925 2022-012
    Material Weakness
  • 623926 2022-013
    Material Weakness
  • 623927 2022-014
    Material Weakness
  • 623928 2022-015
    Material Weakness
  • 623929 2022-010
    Material Weakness
  • 623930 2022-011
    Material Weakness
  • 623931 2022-012
    Material Weakness
  • 623932 2022-013
    Material Weakness
  • 623933 2022-014
    Material Weakness
  • 623934 2022-015
    Material Weakness
  • 623935 2022-018
    Material Weakness
  • 623936 2022-018
    Material Weakness
  • 623937 2022-017
    Material Weakness
  • 623938 2022-018
    Material Weakness
  • 623939 2022-016
    Material Weakness
  • 623941 2022-018
    Material Weakness
  • 623942 2022-009
    Material Weakness
  • 623943 2022-009
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.555 National School Lunch Program 22 $1.84M
84.425 Education Stabilization Fund 22 $1.32M
84.027 Special Education_grants to States 22 $975,069
84.425 Education Stabilization Fund 21 $862,480
84.010 Title I Grants to Local Educational Agencies 22 $756,412
84.010 Title I Grants to Local Educational Agencies 21 $756,017
84.027 Special Education_grants to States 21 $625,125
10.553 School Breakfast Program 22 $366,043
84.048 Career and Technical Education -- Basic Grants to States 22 $223,010
84.367 Improving Teacher Quality State Grants 21 $182,695
84.048 Career and Technical Education -- Basic Grants to States 21 $178,359
84.367 Improving Teacher Quality State Grants 22 $173,731
84.424 Student Support and Academic Enrichment Program 21 $136,860
10.555 National School Lunch Program 21 $123,737
93.778 Medical Assistance Program 22 $69,074
93.778 Medical Assistance Program 21 $64,916
10.559 Summer Food Service Program for Children 21 $54,204
84.173 Special Education_preschool Grants 22 $42,315
10.559 Summer Food Service Program for Children 22 $36,540
84.173 Special Education_preschool Grants 21 $35,644
10.553 School Breakfast Program 21 $31,026
84.424 Student Support and Academic Enrichment Program 22 $16,715
10.649 Pandemic Ebt Administrative Costs 22 $3,063