Finding 540793 (2024-006)

Material Weakness
Requirement
F
Questioned Costs
-
Year
2024
Accepted
2025-03-31
Audit: 350448
Auditor: Crowe LLP

AI Summary

  • Core Issue: The School Corporation lacks an effective internal control system for managing equipment and real property funded by federal grants.
  • Impacted Requirements: Compliance with 2 CFR 200.313(d) regarding property records, physical inventory, safeguards, and maintenance procedures is not being met.
  • Recommended Follow-Up: Update the capital asset listing annually to include all acquisitions and ensure it contains all required information for tracking federal funding usage.

Finding Text

Information on the federal program: 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 and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Finding: 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. Context: The School Corporation was not able to provide a complete capital asset listing with the required information to support that the equipment purchases of $46,727 and $12,408 with COVID-19 – Education Stabilization Fund ESSER II and ESSER III funds had been added to the capital asset listing. Additionally, the School Corporation was not able to provide support that an inventory of capital assets had taken place at least once in the last 2 year. 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. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and has prepared a corrective action plan.

Corrective Action Plan

Information on the federal program: 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 and Years (or Other Identifying Numbers): S425D210013, S425U210013 Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Finding: Material Weakness 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. Context: The School Corporation was not able to provide a complete capital asset listing with the required information to support that the equipment purchases of $46,727 and $12,408 with COVID-19 – Education Stabilization Fund ESSER II and ESSER III funds had been added to the capital asset listing. Additionally, the School Corporation was not able to provide support that an inventory of capital assets had taken place at least once in the last 2 year. Corrective Action Plan: The School Corporation will implement a system of internal controls to ensure the capital asset listing is updated at least annually to include all equipment and real property acquisitions as well as dispositions that took place. The School Corporation will ensure the capital asset listing includes all required information. Person responsible for implementation and projected implementation date: The Business Manager will be responsible for overseeing the implementation of the corrective action plan, which will go into effect immediately.

Categories

Equipment & Real Property Management Internal Control / Segregation of Duties

Other Findings in this Audit

  • 540781 2024-005
    Significant Deficiency Repeat
  • 540782 2024-005
    Significant Deficiency Repeat
  • 540783 2024-002
    Material Weakness
  • 540784 2024-003
    Material Weakness
  • 540785 2024-004
    Material Weakness Repeat
  • 540786 2024-002
    Material Weakness
  • 540787 2024-003
    Material Weakness
  • 540788 2024-004
    Material Weakness Repeat
  • 540789 2024-002
    Material Weakness
  • 540790 2024-003
    Material Weakness
  • 540791 2024-004
    Material Weakness Repeat
  • 540792 2024-007
    Material Weakness
  • 540794 2024-007
    Material Weakness
  • 540795 2024-008
    Material Weakness
  • 540796 2024-006
    Material Weakness
  • 540797 2024-007
    Material Weakness
  • 540798 2024-008
    Material Weakness
  • 1117223 2024-005
    Significant Deficiency Repeat
  • 1117224 2024-005
    Significant Deficiency Repeat
  • 1117225 2024-002
    Material Weakness
  • 1117226 2024-003
    Material Weakness
  • 1117227 2024-004
    Material Weakness Repeat
  • 1117228 2024-002
    Material Weakness
  • 1117229 2024-003
    Material Weakness
  • 1117230 2024-004
    Material Weakness Repeat
  • 1117231 2024-002
    Material Weakness
  • 1117232 2024-003
    Material Weakness
  • 1117233 2024-004
    Material Weakness Repeat
  • 1117234 2024-007
    Material Weakness
  • 1117235 2024-006
    Material Weakness
  • 1117236 2024-007
    Material Weakness
  • 1117237 2024-008
    Material Weakness
  • 1117238 2024-006
    Material Weakness
  • 1117239 2024-007
    Material Weakness
  • 1117240 2024-008
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.425 Education Stabilization Fund $2.79M
32.009 Emergency Connectivity Fund Program $499,800
84.010 Title I Grants to Local Educational Agencies $364,371
16.710 Public Safety Partnership and Community Policing Grants $347,149
93.778 Medical Assistance Program $261,509
10.555 National School Lunch Program $224,183
10.553 School Breakfast Program $181,263
84.027 Special Education Grants to States $97,685
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) $25,536
10.559 Summer Food Service Program for Children $20,762
84.424 Student Support and Academic Enrichment Program $18,985
84.173 Special Education Preschool Grants $7,292
84.365 English Language Acquisition State Grants $1,495
10.649 Pandemic Ebt Administrative Costs $628
96.001 Social Security Disability Insurance $84