Finding 1103052 (2024-005)

Material Weakness
Requirement
F
Questioned Costs
-
Year
2024
Accepted
2025-03-11

AI Summary

  • Core Issue: The School Corporation lacks a proper system of internal controls for managing equipment purchased with federal funds, leading to incomplete asset records.
  • Impacted Requirements: Compliance with federal regulations (2 CFR 200.303 and 200.313) regarding equipment management and record-keeping is not being met.
  • Recommended Follow-Up: Implement a robust internal control system and develop clear policies to ensure all asset records are complete and compliant.

Finding Text

FINDING 2024-005 Subject: COVID-19 - Education Stabilization Fund - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Education Stabilization Fund Assistance Listings Numbers: 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 Findings: Material Weakness, Modified Opinion Condition and Context The School Corporation had not properly designed or implemented a system of internal controls, which would include appropriate segregation of duties, that would likely be effective in preventing, or detecting and correcting, noncompliance related to the purchase of equipment with federal award dollars. A property record or capital asset listing is required to be maintained for all equipment purchased with the School Corporation's Education Stabilization Fund grant award. Equipment to be included in the listing is that which exceeds the School Corporation's capital asset threshold. The School Corporation's capital asset policy identifies a capital asset as an item which cost at or above $5,000. The School Corporation hired a consultant to compile and provide to them a fixed asset report that contained all inventory and assets purchased that exceeded the School Corporation's capitalization threshold through June 30, 2024. The consultant prepared the report; however, the School Corporation did not have any policies or procedures in place to ensure the listing was complete, nor was there any documentation that differences between the compiled asset report and the School Corporation's equipment records were reviewed and resolved. INDIANA STATE BOARD OF ACCOUNTS 26 LA PORTE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) The School Corporation's capital asset listing did not include all the required asset information for assets purchased with federal awards. The following information for each asset was not included in the School Corporation's capital asset listing: the source of funding for the property (including the federal award identification number (FAIN)), percentage of federal participation in the project costs for the federal award under which the property was acquired, and the use and condition of the property. During the audit period, the School Corporation had improvement projects totaling $8,022,149 with Education Stabilization Funds (ESF). These assets were not included on the capital asset listing or physical inventory prepared by the consultant. As such, the School Corporation did not maintain a capital asset listing with the equipment purchased with the ESF; the School Corporation could not have conducted a complete physical inventory biannually as required and could not properly maintain and safeguard the equipment as required. 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.313(d) states in part: ". . . (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. . . ." INDIANA STATE BOARD OF ACCOUNTS 27 LA PORTE COMMUNITY SCHOOL CORPORATION SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause The School Corporation stated it did not include the recent improvements to the HVAC on the capital asset listing as it was waiting to receive an appraisal to determine how much of the project was equipment related rather than the whole contracted amount. Per the School Corporation's Policy 7455, entitled Accounting System for Capital Assets, capital assets are to be "capitalized in accordance with GAAP," which would include the full cost to bring the asset (equipment) to a location and condition for its use such as installation, assembly, freight, etc. Effect Without the proper implementation of an effectively designed system of internal controls, the School Corporation cannot ensure the capital asset purchases are properly accounted for. Not properly accounting for equipment that meets the capital asset threshold does not provide an accurate depiction of the total capital assets maintained by the School Corporation. Questioned Costs There were no questioned costs identified. Recommendation We recommend that management of the School Corporation establish a proper system of internal controls and develop policies and procedures to ensure asset records include all the necessary information, new assets are properly added, and any discrepancies are reconciled. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Categories

Equipment & Real Property Management Internal Control / Segregation of Duties

Other Findings in this Audit

  • 526601 2024-003
    Significant Deficiency Repeat
  • 526602 2024-003
    Significant Deficiency Repeat
  • 526603 2024-004
    Material Weakness
  • 526604 2024-004
    Material Weakness
  • 526605 2024-004
    Material Weakness
  • 526606 2024-004
    Material Weakness
  • 526607 2024-005
    Material Weakness
  • 526608 2024-005
    Material Weakness
  • 526609 2024-005
    Material Weakness
  • 526610 2024-005
    Material Weakness
  • 526611 2024-005
    Material Weakness
  • 526612 2024-005
    Material Weakness
  • 526613 2024-006
    Material Weakness Repeat
  • 526614 2024-006
    Material Weakness Repeat
  • 526615 2024-006
    Material Weakness Repeat
  • 526616 2024-006
    Material Weakness Repeat
  • 526617 2024-006
    Material Weakness Repeat
  • 526618 2024-006
    Material Weakness Repeat
  • 1103043 2024-003
    Significant Deficiency Repeat
  • 1103044 2024-003
    Significant Deficiency Repeat
  • 1103045 2024-004
    Material Weakness
  • 1103046 2024-004
    Material Weakness
  • 1103047 2024-004
    Material Weakness
  • 1103048 2024-004
    Material Weakness
  • 1103049 2024-005
    Material Weakness
  • 1103050 2024-005
    Material Weakness
  • 1103051 2024-005
    Material Weakness
  • 1103053 2024-005
    Material Weakness
  • 1103054 2024-005
    Material Weakness
  • 1103055 2024-006
    Material Weakness Repeat
  • 1103056 2024-006
    Material Weakness Repeat
  • 1103057 2024-006
    Material Weakness Repeat
  • 1103058 2024-006
    Material Weakness Repeat
  • 1103059 2024-006
    Material Weakness Repeat
  • 1103060 2024-006
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
10.555 National School Lunch Program 2024 $3.14M
10.555 National School Lunch Program 2023 $3.07M
84.010 Title I Grants to Local Educational Agencies 2024 $1.33M
84.010 Title I Grants to Local Educational Agencies 2023 $1.28M
10.553 School Breakfast Program 2024 $808,212
10.553 School Breakfast Program 2023 $787,774
93.778 Medical Assistance Program 2023 $380,308
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance 2024 $375,325
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) 2024 $356,799
93.778 Medical Assistance Program 2024 $306,089
84.367 Supporting Effective Instruction State Grants (formerly Improving Teacher Quality State Grants) 2023 $232,004
84.027 Special Education Grants to States 2023 $210,403
84.424 Student Support and Academic Enrichment Program 2024 $185,876
84.027 Special Education Grants to States 2024 $140,261
84.424 Student Support and Academic Enrichment Program 2023 $70,870
84.425 Education Stabilization Fund 2023 $68,576
10.559 Summer Food Service Program for Children 2023 $62,126
10.559 Summer Food Service Program for Children 2024 $46,458
84.365 English Language Acquisition State Grants 2024 $41,649
84.425 Education Stabilization Fund 2024 $35,410
84.365 English Language Acquisition State Grants 2023 $34,595
84.173 Special Education Preschool Grants 2023 $21,074
84.173 Special Education Preschool Grants 2024 $5,103