Finding 384412 (2023-003)

Material Weakness Repeat Finding
Requirement
E
Questioned Costs
-
Year
2023
Accepted
2024-03-26
Audit: 297571
Organization: Rush County Schools (IN)

AI Summary

  • Core Issue: The School Corporation lacks a proper system of internal controls, leading to repeated eligibility compliance failures for Title I grants.
  • Impacted Requirements: Noncompliance with 2 CFR 200.303 and 2 CFR 200.334 regarding internal controls and record retention jeopardizes future federal funding.
  • Recommended Follow-Up: Management should implement a robust internal control system and establish policies to ensure accurate reporting and maintenance of Real Time reports for audits.

Finding Text

FINDING 2023-003 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): S010A200014, S010A210014, S010A220014 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 prior audit report. The prior audit finding number was 2021-006. 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 pre-populated 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 reports, to the IDOE without a documented oversight or review process to ensure that the information was accurate. In addition, there was no review by the School Corporation of the enrollment and poverty counts that were pre-populated into the School Corporation's Title I grant application. The IDOE used the October 1 Real Time (RT) reports for fiscal years 2020-2021 and 2021-2022, as provided by the School Corporation, to determine Title I Eligibility for the 2021-2022 and 2022-2023 grant programs, respectively. 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. The lack of internal controls was a systemic issue throughout the audit period. The lack of documentation presented for audit was an issue for the 2022-2023 grant. INDIANA STATE BOARD OF ACCOUNTS 18 RUSH COUNTY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) 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 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. . . ." Cause A proper system of internal controls was not designed by management of the School Corporation, which would include segregation of key functions. 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, Real Time reports were not maintained for audit, and, as such, we 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 management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure Real Time reports 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 2023-003 Finding Subject: Title I Grants to Local Educational Agencies - Eligibility Summary of Finding: An effective internal control system, which would include segregation of duties, was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Eligibility compliance requirement. The October 1st Real Time Report of Pupil Enrollment (PE) was used by the Indiana Department of Education to pull data into the Title I application. These numbers were then used to calculate Percent Poverty which was used to rank schools for Title I eligibility. One person was primarily responsible for compiling and uploading student data, including poverty status for Real Time reports. There was no additional review or verification being done to ensure that the numbers being pre-populated on the grant applications were correct. There was no internal control in place, such as an oversight, review or approval process to ensure eligibility was properly determined. The Indiana Department of Education (IDOE) used the October 1 Real Time reports for fiscal years 2020- 2021 and 2021-2022, as provided by the School Corporation, to determine Title I Eligibility for the 2021- 2022 and 2022-2023 grant programs, respectively. There was no October 1 Real Time report presented for audit for fiscal year 2021-2022, which would have been used to pull in enrollment and poverty information for the 2022-2023 grant. Therefore, we were unable to verify if the amounts reported in the grant application were correct. Additionally, we were unable to verify if the correct socioeconomic status was properly reported for any of the students. Contact Person Responsible for Corrective Action: Nancy Schroeder Contact Phone Number and Email Address: 765-932-3901 schroedern@rushville.k12.in.us Views of Responsible Officials: We concur with the finding. Explanation and Reasons for Disagreement: N/A Description of Corrective Action Plan: Eligibility – The Technology Director, Brevin Runnebohm will supply the Title I director with the official October 1 count each school year. This will be retained for audit and will be used by the Grant Coordinator, Nancy Schroeder, to determine the enrollment numbers in the Title I application have INDIANA STATE BOARD OF ACCOUNTS 45 been prepopulated correctly. The Grant Coordinator will sign off that she has reviewed this information and find it accurate. Anticipated Completion Date: 10/2024

Categories

Subrecipient Monitoring Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties Allowable Costs / Cost Principles Eligibility Material Weakness

Other Findings in this Audit

  • 384413 2023-003
    Material Weakness Repeat
  • 384414 2023-004
    Material Weakness Repeat
  • 384415 2023-004
    Material Weakness Repeat
  • 384416 2023-005
    Material Weakness
  • 384417 2023-005
    Material Weakness
  • 384418 2023-005
    Material Weakness
  • 384419 2023-006
    Material Weakness
  • 384420 2023-006
    Material Weakness
  • 384421 2023-007
    Material Weakness Repeat
  • 384422 2023-007
    Material Weakness Repeat
  • 384423 2023-007
    Material Weakness Repeat
  • 384424 2023-007
    Material Weakness Repeat
  • 384425 2023-007
    Material Weakness Repeat
  • 384426 2023-007
    Material Weakness Repeat
  • 384427 2023-007
    Material Weakness Repeat
  • 384428 2023-008
    Material Weakness Repeat
  • 384429 2023-009
    Material Weakness Repeat
  • 384430 2023-009
    Material Weakness Repeat
  • 960854 2023-003
    Material Weakness Repeat
  • 960855 2023-003
    Material Weakness Repeat
  • 960856 2023-004
    Material Weakness Repeat
  • 960857 2023-004
    Material Weakness Repeat
  • 960858 2023-005
    Material Weakness
  • 960859 2023-005
    Material Weakness
  • 960860 2023-005
    Material Weakness
  • 960861 2023-006
    Material Weakness
  • 960862 2023-006
    Material Weakness
  • 960863 2023-007
    Material Weakness Repeat
  • 960864 2023-007
    Material Weakness Repeat
  • 960865 2023-007
    Material Weakness Repeat
  • 960866 2023-007
    Material Weakness Repeat
  • 960867 2023-007
    Material Weakness Repeat
  • 960868 2023-007
    Material Weakness Repeat
  • 960869 2023-007
    Material Weakness Repeat
  • 960870 2023-008
    Material Weakness Repeat
  • 960871 2023-009
    Material Weakness Repeat
  • 960872 2023-009
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
10.555 National School Lunch Program 2022 $1.28M
84.027 Special Education_grants to States 2022 $1.22M
84.425 Education Stabilization Fund 2023 $1.20M
10.555 National School Lunch Program 2023 $1.05M
84.010 Title I Grants to Local Educational Agencies 2022 $470,033
84.010 Title I Grants to Local Educational Agencies 2023 $393,650
84.425 Education Stabilization Fund 2022 $321,585
10.553 School Breakfast Program 2022 $274,432
10.553 School Breakfast Program 2023 $248,457
84.367 Improving Teacher Quality State Grants 2022 $145,801
84.027 Special Education_grants to States 2023 $117,465
84.173 Special Education_preschool Grants 2022 $52,756
84.367 Improving Teacher Quality State Grants 2023 $46,523
10.559 Summer Food Service Program for Children 2022 $30,254
84.424 Student Support and Academic Enrichment Program 2022 $18,947
10.559 Summer Food Service Program for Children 2023 $15,289
84.173 Special Education_preschool Grants 2023 $8,833
10.649 Pandemic Ebt Administrative Costs 2023 $3,135
10.649 Pandemic Ebt Administrative Costs 2022 $3,063
10.556 Special Milk Program for Children 2023 $994