Finding 525798 (2024-005)

Material Weakness Repeat Finding
Requirement
E
Questioned Costs
-
Year
2024
Accepted
2025-03-06

AI Summary

  • Core Issue: The School Corporation lacks a proper system of internal controls, leading to difficulties in verifying eligibility for Title I grants due to missing enrollment and poverty data.
  • Impacted Requirements: Compliance with federal eligibility requirements is compromised, risking future federal funding due to noncompliance with 2 CFR 200.303 and 2 CFR 200.334.
  • Recommended Follow-Up: Management should implement effective internal controls and establish policies to ensure retention of necessary documentation for audits.

Finding Text

FINDING 2024-005 Subject: Title I Grants to Local Educational Agencies - Eligibility Federal Agency: Department of Education Federal Program: Title I Grants to Local Educational Agencies Assistance Listings Number: 84.010 Federal Award Numbers and Years (or Other Identifying Numbers): S010A210014, S010A220014, S010A230014 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Eligibility Audit Findings: Material Weakness, Modified Opinion Repeat Finding This is a repeat finding from the immediately prior audit report. The prior audit finding number was 2022-003. INDIANA STATE BOARD OF ACCOUNTS 23 MADISON CONSOLIDATED SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Condition and Context Eligibility for Title I is determined on the Eligible School Summary of the Tile I application. Enrollment and Poverty numbers are automatically pulled from the Indiana Department of Education's (IDOE) Official Pupil Enrollment (PE) count for each school into the Eligible School Summary page of the Tile I application. These counts that are prepopulated should be based on the School Corporation's records as of October of the prior fiscal year. One person compiled and uploaded enrollment data, including poverty status for Real Time (RT) reports, to the IDOE without a documented oversight or review process to ensure that the information was accurate and retained for audit. In addition, there was no review by the School Corporation of the enrollment and poverty counts that were prepopulated into the School Corporation's Title I grant application. The IDOE used the October 1 RT reports for fiscal years 2021-2022 and 2022-2023, as provided by the School Corporation, to determine Eligibility for the 2022-2023 and 2023-2024 grant programs, respectively. The October 1 RT report could not be presented for audit for 2021-2022, which would have been used to pull in enrollment and poverty information for the 2022-2023 grant. As such, we were unable to verify the amounts reported in the grant application. Additionally, the Indiana State Board of Accounts was unable to verify if the correct socioeconomic status was properly reported for any of the students. Enrollment and poverty numbers for any nonpublic schools are manually entered into the application by the School Corporation. The School Corporation had not established an effective process to review the listing of students from the nonpublic schools for enrollment and poverty counts to be entered into the Title I application and to retain this information for audit. We were unable to determine if the enrolled student count and their poverty status in the application was accurate. The lack of internal controls and lack of information submitted for audit was a systemic issue 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 the Federal awards that are renewed quarterly or annual, from the date of 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. . . ." INDIANA STATE BOARD OF ACCOUNTS 24 MADISON CONSOLIDATED SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions, to ensure all records pertinent to the federal award were retained for audit. After a change in software providers, information from the previous provider could not be obtained for audit. 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, RT reports and nonpublic school enrollment documentation were not maintained for audit, and, as such, the Indiana State Board of Accounts could not determine if the School Corporation complied with the Eligibility compliance requirement. 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. Questioned Costs There were no questioned costs identified. Recommendation We recommended that the management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure RT reports, and nonpublic school enrollment documentation are maintained for audit. 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 2024-005 Finding Subject: Title I - Eligibility Summary of Finding: The October 1 Real Time report could not be presented for audit for 2021-2022, which would have been used to pull in enrollment and poverty information for the 2022-2023 grant. As such, we were unable to verify the amounts reported in the grant application. Additionally, we were unable to verify if the correct socioeconomic status was properly reported for any of the students. Additionally, we were unable to verify nonpublic enrollment and poverty data included on the Title I application. Contact Person Responsible for Corrective Action: Janet McCreary Contact Phone Number and Email Address: 812-274-8001 jmccreary@madison.k12.in.us Views of Responsible Officials: We concur with the finding. Description of Corrective Action Plan: Due to the timing of the prior audit and the nature of the Real-Time report, this portion of the finding was not able to be completed timely for FY23’s grant. Beginning in FY24, The Data Management Specialist will save all reports submitted to the DOE. This will ensure that supporting documentation is kept that will be used determine Eligibility for Title I. Additionally, for the nonpublic enrollment and poverty data, the grants specialist meets with non-public partners to review enrollment information and verify the student population that encumbers funding. The data management specialist for MCS verifies all enrollment information and poverty identification in concert with the nutrition manager of MCS, building administrators, and the central office administration to verify all data reported to the state. Anticipated Completion Date: 6/30/2025

Categories

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

Other Findings in this Audit

  • 525794 2024-003
    Material Weakness Repeat
  • 525795 2024-003
    Material Weakness Repeat
  • 525796 2024-004
    Material Weakness
  • 525797 2024-004
    Material Weakness
  • 525799 2024-005
    Material Weakness Repeat
  • 525800 2024-006
    Significant Deficiency
  • 525801 2024-006
    Significant Deficiency
  • 525802 2024-006
    Significant Deficiency
  • 525803 2024-006
    Significant Deficiency
  • 525804 2024-006
    Significant Deficiency
  • 1102236 2024-003
    Material Weakness Repeat
  • 1102237 2024-003
    Material Weakness Repeat
  • 1102238 2024-004
    Material Weakness
  • 1102239 2024-004
    Material Weakness
  • 1102240 2024-005
    Material Weakness Repeat
  • 1102241 2024-005
    Material Weakness Repeat
  • 1102242 2024-006
    Significant Deficiency
  • 1102243 2024-006
    Significant Deficiency
  • 1102244 2024-006
    Significant Deficiency
  • 1102245 2024-006
    Significant Deficiency
  • 1102246 2024-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
10.555 National School Lunch Program 2023 $1.24M
10.555 National School Lunch Program 2024 $1.02M
84.010 Title I Grants to Local Educational Agencies 2024 $907,107
84.027 Special Education Grants to States 2023 $820,554
84.010 Title I Grants to Local Educational Agencies 2023 $637,283
10.553 School Breakfast Program 2023 $295,282
10.553 School Breakfast Program 2024 $248,290
84.027 Special Education Grants to States 2024 $184,724
84.425 Education Stabilization Fund 2023 $155,669
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) 2024 $138,853
84.041 Impact Aid 2024 $91,722
84.424 Student Support and Academic Enrichment Program 2024 $83,521
84.041 Impact Aid 2023 $76,543
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) 2023 $69,623
84.424 Student Support and Academic Enrichment Program 2023 $43,785
84.048 Career and Technical Education -- Basic Grants to States 2023 $42,969
84.048 Career and Technical Education -- Basic Grants to States 2024 $40,688
84.358 Rural Education 2023 $32,745
93.778 Medical Assistance Program 2024 $31,911
93.778 Medical Assistance Program 2023 $29,990
84.196 Education for Homeless Children and Youth 2023 $27,095
84.358 Rural Education 2024 $18,755
84.173 Special Education Preschool Grants 2024 $13,789
84.425 Education Stabilization Fund 2024 $11,182
84.196 Education for Homeless Children and Youth 2024 $10,309
10.649 Pandemic Ebt Administrative Costs 2023 $3,135