Finding 390686 (2023-007)

Material Weakness
Requirement
F
Questioned Costs
-
Year
2023
Accepted
2024-03-31
Audit: 301362
Organization: Wabash City Schools (IN)

AI Summary

  • Core Issue: The School Corporation lacks a proper system of internal controls for managing equipment and real property, leading to incomplete asset records.
  • Impacted Requirements: Compliance with 2 CFR 200.303 and 2 CFR 200.313(d) regarding maintaining detailed property records and effective internal controls.
  • Recommended Follow-Up: Management should develop and implement policies and procedures to ensure all required asset information is accurately recorded and maintained.

Finding Text

FINDING 2023-007 Subject: Special Education Cluster (IDEA) - Equipment and Real Property Management Federal Agency: Department of Education Federal Program: COVID-19 - Special Education Grants to States Assistance Listings Number: 84.027X Federal Award Number and Year (or Other Identifying Number): 22611-054-ARP Pass-Through Entity: Indiana Department of Education Compliance Requirement: Equipment and Real Property Management Audit Findings: Material Weakness, Other Matters Condition and Context A property record or capital asset listing, which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. Upon inquiry of the School Corporation in order to review the procedures in place to ensure equipment is properly added to the asset listing, the School Corporation disclosed there were no policies or procedures in place to ensure assets were added. One piece of equipment in the amount of $75,387 purchased with special education funds was identified. The piece of equipment was selected for testing. Although the piece of equipment was properly added to the asset listing, the listing did not include all the required information. The missing information was as follows: the source of funding for the property (including the FAIN), who holds title, 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. 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: "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: INDIANA STATE BOARD OF ACCOUNTS 28 WABASH CITY SCHOOLS SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) (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. . . ." 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 controls consisting of policies and procedures. Policies reflect the School Corporation's management statements of what should be done to effect internal control, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. As a result, asset records did not include all of the required information. 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 asset records include all the required information. 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-007 Finding Subject: Special Education Cluster - Equipment and Real Property Management Summary of Finding: 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. A property record or capital asset listing which would include a description of the property, a serial number or other identification number, the source of funding for the property (including the federal award identification number (FAIN)), who holds title, the acquisition date, cost of the property, percentage of federal participation in the project costs for the federal award under which the property was acquired, the location, and use and condition of the property is to be maintained for assets purchased that exceed the School Corporation's capitalization threshold. The School Corporation purchased on piece of equipment in the amount of $75,387 with Special Education Funds. The listing did not include all the required elements for the one piece of equipment purchased. The required elements are the 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. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Contact Person Responsible for Corrective Action: Amy K. Sivley Contact Phone Number and Email Address: 260-563-2151; sivleya@apaches.k12.in.us Views of Responsible Officials: We concur with the finding. Explanation and Reasons for Disagreement: n/a Description of Corrective Action Plan: Develop processes and procedures to ensure that purchases made with federal dollars are correctly recorded on capital asset ledger. Anticipated Completion Date: To begin immediately, March 2024

Categories

Equipment & Real Property Management Internal Control / Segregation of Duties Procurement, Suspension & Debarment Material Weakness Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 390664 2023-003
    Material Weakness
  • 390665 2023-003
    Material Weakness
  • 390666 2023-003
    Material Weakness
  • 390667 2023-003
    Material Weakness
  • 390668 2023-003
    Material Weakness
  • 390669 2023-003
    Material Weakness
  • 390670 2023-004
    Material Weakness
  • 390671 2023-004
    Material Weakness
  • 390672 2023-004
    Material Weakness
  • 390673 2023-004
    Material Weakness
  • 390674 2023-004
    Material Weakness
  • 390675 2023-004
    Material Weakness
  • 390676 2023-005
    Material Weakness
  • 390677 2023-005
    Material Weakness
  • 390678 2023-005
    Material Weakness
  • 390679 2023-005
    Material Weakness
  • 390680 2023-005
    Material Weakness
  • 390681 2023-005
    Material Weakness
  • 390682 2023-006
    Material Weakness
  • 390683 2023-006
    Material Weakness
  • 390684 2023-006
    Material Weakness
  • 390685 2023-006
    Material Weakness
  • 390687 2023-007
    Material Weakness
  • 390688 2023-008
    Material Weakness
  • 390689 2023-008
    Material Weakness
  • 390690 2023-009
    Material Weakness
  • 390691 2023-009
    Material Weakness
  • 390692 2023-009
    Material Weakness
  • 390693 2023-010
    Material Weakness
  • 390694 2023-010
    Material Weakness
  • 390695 2023-010
    Material Weakness
  • 390696 2023-010
    Material Weakness
  • 390697 2023-010
    Material Weakness
  • 967106 2023-003
    Material Weakness
  • 967107 2023-003
    Material Weakness
  • 967108 2023-003
    Material Weakness
  • 967109 2023-003
    Material Weakness
  • 967110 2023-003
    Material Weakness
  • 967111 2023-003
    Material Weakness
  • 967112 2023-004
    Material Weakness
  • 967113 2023-004
    Material Weakness
  • 967114 2023-004
    Material Weakness
  • 967115 2023-004
    Material Weakness
  • 967116 2023-004
    Material Weakness
  • 967117 2023-004
    Material Weakness
  • 967118 2023-005
    Material Weakness
  • 967119 2023-005
    Material Weakness
  • 967120 2023-005
    Material Weakness
  • 967121 2023-005
    Material Weakness
  • 967122 2023-005
    Material Weakness
  • 967123 2023-005
    Material Weakness
  • 967124 2023-006
    Material Weakness
  • 967125 2023-006
    Material Weakness
  • 967126 2023-006
    Material Weakness
  • 967127 2023-006
    Material Weakness
  • 967128 2023-007
    Material Weakness
  • 967129 2023-007
    Material Weakness
  • 967130 2023-008
    Material Weakness
  • 967131 2023-008
    Material Weakness
  • 967132 2023-009
    Material Weakness
  • 967133 2023-009
    Material Weakness
  • 967134 2023-009
    Material Weakness
  • 967135 2023-010
    Material Weakness
  • 967136 2023-010
    Material Weakness
  • 967137 2023-010
    Material Weakness
  • 967138 2023-010
    Material Weakness
  • 967139 2023-010
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
10.555 National School Lunch Program 2023 $905,037
10.555 National School Lunch Program 2022 $848,384
84.425 Education Stabilization Fund 2022 $421,047
84.010 Title I Grants to Local Educational Agencies 2022 $338,198
10.553 School Breakfast Program 2022 $270,213
84.425 Education Stabilization Fund 2023 $243,051
84.010 Title I Grants to Local Educational Agencies 2023 $242,951
10.553 School Breakfast Program 2023 $229,205
93.575 Child Care and Development Block Grant 2023 $185,995
93.575 Child Care and Development Block Grant 2022 $114,697
10.559 Summer Food Service Program for Children 2022 $94,721
84.027 Special Education_grants to States 2023 $90,788
93.778 Medical Assistance Program 2023 $66,197
84.367 Improving Teacher Quality State Grants 2022 $57,032
84.411 Investing in Innovation (i3) Fund 2023 $55,714
93.778 Medical Assistance Program 2022 $51,680
84.358 Rural Education 2023 $44,742
84.411 Investing in Innovation (i3) Fund 2022 $40,612
84.424 Student Support and Academic Enrichment Program 2022 $32,095
84.367 Improving Teacher Quality State Grants 2023 $30,747
84.173 Special Education_preschool Grants 2022 $22,907
10.559 Summer Food Service Program for Children 2023 $21,773
84.424 Student Support and Academic Enrichment Program 2023 $20,706
84.358 Rural Education 2022 $16,647
84.173 Special Education_preschool Grants 2023 $6,222
84.027 Special Education_grants to States 2022 $1,674