Finding 1099898 (2024-005)

Material Weakness
Requirement
F
Questioned Costs
-
Year
2024
Accepted
2025-02-17
Audit: 342716
Auditor: Crowe LLP

AI Summary

  • Core Issue: The School Corporation lacks an effective internal control system for managing equipment and real property, leading to potential noncompliance with federal grant requirements.
  • Impacted Requirements: Compliance with 2 CFR 200.313(d) is at risk due to inadequate property records, lack of physical inventory, and insufficient safeguards against loss or theft.
  • Recommended Follow-Up: Update the capital asset listing annually to include all acquisitions and ensure it contains all required information, as well as develop a robust internal control system for oversight and compliance.

Finding Text

Subject: Education Stabilization Fund – Internal Controls Federal Agency: Department of Education Federal Program: COVID-19 – Education Stabilization Fund Assistance Listing Number: 84.425D, 84.425U Federal Award Numbers: S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness Criteria: 2 CFR 200.313(d) states in part: "Management requirements. Procedures for managing equipment (including replacement equipment), whether acquired in whole or in part under a Federal award, until disposition takes place will, as a minimum, meet the following requirements: (1) Property records must be maintained that include a description of the property, a serial number or other identification number, the source of funding for the property (including the FAIN), who holds title, the acquisition date, and cost of the property, percentage of Federal participation in the project costs for the Federal award under which the property was acquired, the location, use and condition of the property, and any ultimate disposition data including the date of disposal and sale price of the property. (2) A physical inventory of the property must be taken and the results reconciled with the property records at least once every two years. (3) A control system must be developed to ensure adequate safeguards to prevent loss, damage, or theft of the property. Any loss, damage, or theft must be investigated. (4) Adequate maintenance procedures must be developed to keep the property in good condition. . . ." Condition: An effective internal control system was not in place at the School Corporation in order to ensure compliance with requirements related to the grant agreement and the Equipment and Real Property Management Requirements compliance requirements. Cause: The School Corporation's management had not developed a system of internal controls to ensure compliance with the compliance requirements listed above. Effect: The failure to establish an effective internal control system placed the School Corporation at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have also allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the programs. Questioned Costs: There were no questioned costs identified. audit which was charged to the ESSER II (84.425D) and ESSER III (84.425U) grant awards. It was noted these capital asset acquisitions were not reported on the capital asset listing for the School Corporation as of June 30, 2024. Identification as a repeat finding: No. Recommendation: We recommend the School Corporation update the capital asset listing at least annually to include all equipment and real property acquisitions and review for potential capital asset dispositions. The capital asset listing should include all required information to track capital asset acquisitions purchased with federal funding. Additionally, we noted the School Corporation’s capital asset listing did not contain all the required information, including the source of funding for the property, outlined in the criteria above. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.

Categories

Equipment & Real Property Management Internal Control / Segregation of Duties

Other Findings in this Audit

  • 523441 2024-002
    Material Weakness
  • 523442 2024-002
    Material Weakness
  • 523443 2024-002
    Material Weakness
  • 523444 2024-002
    Material Weakness
  • 523445 2024-002
    Material Weakness
  • 523446 2024-002
    Material Weakness
  • 523447 2024-003
    Significant Deficiency Repeat
  • 523448 2024-003
    Significant Deficiency Repeat
  • 523449 2024-003
    Significant Deficiency Repeat
  • 523450 2024-003
    Significant Deficiency Repeat
  • 523451 2024-003
    Significant Deficiency Repeat
  • 523452 2024-003
    Significant Deficiency Repeat
  • 523453 2024-004
    Material Weakness Repeat
  • 523454 2024-004
    Material Weakness Repeat
  • 523455 2024-004
    Material Weakness Repeat
  • 523456 2024-005
    Material Weakness
  • 523457 2024-005
    Material Weakness
  • 523458 2024-006
    Significant Deficiency
  • 523459 2024-006
    Significant Deficiency
  • 523460 2024-007
    Material Weakness Repeat
  • 523461 2024-007
    Material Weakness Repeat
  • 523462 2024-007
    Material Weakness Repeat
  • 1099883 2024-002
    Material Weakness
  • 1099884 2024-002
    Material Weakness
  • 1099885 2024-002
    Material Weakness
  • 1099886 2024-002
    Material Weakness
  • 1099887 2024-002
    Material Weakness
  • 1099888 2024-002
    Material Weakness
  • 1099889 2024-003
    Significant Deficiency Repeat
  • 1099890 2024-003
    Significant Deficiency Repeat
  • 1099891 2024-003
    Significant Deficiency Repeat
  • 1099892 2024-003
    Significant Deficiency Repeat
  • 1099893 2024-003
    Significant Deficiency Repeat
  • 1099894 2024-003
    Significant Deficiency Repeat
  • 1099895 2024-004
    Material Weakness Repeat
  • 1099896 2024-004
    Material Weakness Repeat
  • 1099897 2024-004
    Material Weakness Repeat
  • 1099899 2024-005
    Material Weakness
  • 1099900 2024-006
    Significant Deficiency
  • 1099901 2024-006
    Significant Deficiency
  • 1099902 2024-007
    Material Weakness Repeat
  • 1099903 2024-007
    Material Weakness Repeat
  • 1099904 2024-007
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
10.553 School Breakfast Program $930,696
84.010 Title I Grants to Local Educational Agencies $449,430
84.287 Twenty-First Century Community Learning Centers $243,701
10.555 National School Lunch Program $226,905
93.778 Medical Assistance Program $181,848
84.027 Special Education Grants to States $145,640
10.582 Fresh Fruit and Vegetable Program $77,549
10.559 Summer Food Service Program for Children $69,530
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $66,379
84.002 Adult Education - Basic Grants to States $47,643
84.358 Rural Education $44,544
84.365 English Language Acquisition State Grants $36,621
84.425 Education Stabilization Fund $28,777
84.196 Education for Homeless Children and Youth $25,516
84.424 Student Support and Academic Enrichment Program $24,858
84.173 Special Education Preschool Grants $23,706
84.048 Career and Technical Education -- Basic Grants to States $4,000
10.649 Pandemic Ebt Administrative Costs $3,135
10.558 Child and Adult Care Food Program $2,533