Finding 538781 (2024-002)

Material Weakness
Requirement
F
Questioned Costs
$1
Year
2024
Accepted
2025-03-28
Audit: 349482
Auditor: Auditor General

AI Summary

  • Core Issue: The District failed to keep proper property records for equipment funded by the ESF Program, leading to questioned costs of $2,186,066.
  • Impacted Requirements: Federal regulations require detailed property records and a physical inventory every two years, which the District did not maintain.
  • Recommended Follow-up: The District should implement a system for maintaining property records, conduct regular inventories, and address unlocated equipment by restoring questioned costs and involving law enforcement if necessary.

Finding Text

FINDING - The District did not comply with Federal regulations by maintaining property records to identify the location of equipment funded by the ESF Program, resulting in questioned costs totaling $2,186,066. CRITERIA - Title 2, Section 200.313(d)(1) and (2), Code of Federal Regulations (CFR), requires that property records for equipment be maintained that include various details, such as a descriptions of the property; an identification number; the source of funding for the property (including the Federal award identification number); the location, use, and condition of the property; and any ultimate disposition data including the date of disposal and sales price of the property. Additionally, a physical inventory of the property must be conducted and the results must be reconciled with the property records at least once every 2 years. Title 2, Section 200.1, CFR, defines equipment as tangible personal property, including information technology systems, having a useful life of more than 1 year and a per-unit acquisition cost which equals or exceeds the lesser of the capitalization threshold established by the District or $5,000. According to Board Policy 7450 - Property Inventory, the Superintendent must maintain an adequate and accurate record of all tangible personal property with a value or cost of $1,500 or more. CONDITION - During the 2020-21 through 2023-24 fiscal years, District ESF Program expenditures totaled $14,293,633, including $2,186,066 for capitalized equipment with a value or cost of $1,500 or more. Although we requested, District personnel could not provide any property records that identified the equipment identification number, source of funding, condition, location, or otherwise properly account for the items. Moreover, the District did not conduct physical inventory procedures during the 2022-23 or 2023-24 fiscal years. CAUSE - According to District personnel, due to staff turnover, the property records were not consistently maintained and the physical inventory was not recently conducted. EFFECT - Without effective accountability over equipment purchased with Federal funds, including the maintenance of appropriate property records and periodic physical inventories, there is an increased risk that the equipment may be used for unauthorized purposes. Absent required property records, ESF Program moneys for equipment acquisitions totaling $2,186,066 represent questioned costs. RECOMMENDATION - The District should establish effective accountability over equipment purchased with Federal funds. Such accountability should include the maintenance of required property records based on Federal equipment acquisitions, the conduct of a physical inventory of the equipment, and a reconciliation of the inventory results with the property records at least once every 2 years. In addition, for any unlocated ESF Program equipment items, the District should restore to the FDOE the related questioned costs and contact applicable law enforcement agencies regarding necessary actions to help recover the unlocated equipment. DISTRICT RESPONSE - The District has designated a team from the finance department and operations/maintenance to review and update procedures to account appropriately for the equipment/inventory. These procedures will include a comprehensive inventory count no less than every two years that will be reconciled to records maintained within the District's financial management software.

Corrective Action Plan

CORRECTIVE ACTION PLAN - Recognizing the need/requirement to maintain property records appropriately, the district is working to schedule/complete a comprehensive physical inventory that should assist in identifying the location of equipment funded by the Education Stabilization Fund (ESF), resulting in questioned costs of $2,186,066 per this finding (in addition to all other equipment carried by the district regardless of funding source). The district plans are to continue to work with NEFEC to enact property records within Skyward to capture accurate information and a base starting point per completion of a physical inventory. All property records will then be maintained in Skyward to capture all information required under Federal funding provisions and a reconciliation to physical inventory counts will be prepared no less than every 2 years. Anticipated Completion Date: June 30, 2025 Responsible Contact Person: Walter Copeland, Interim CFO

Categories

Questioned Costs Equipment & Real Property Management

Other Findings in this Audit

  • 1115223 2024-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.010 Title I Grants to Local Educational Agencies $1.85M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $719,957
10.553 School Breakfast Program $335,449
84.367 Supporting Effective Instruction State Grants $98,346
10.579 Child Nutrition Discretionary Grants Limited Availability $89,771
84.358 Rural Education $71,514
84.196 Education for Homeless Children and Youth $69,933
10.582 Fresh Fruit and Vegetable Program $68,610
84.424 Student Support and Academic Enrichment Program $65,918
10.555 National School Lunch Program $48,246
84.425 Education Stabilization Fund $45,683
10.559 Summer Food Service Program for Children $26,402
84.011 Migrant Education_state Grant Program $19,414
84.027 Special Education_grants to States $18,004
84.048 Career and Technical Education -- Basic Grants to States $13,525
84.173 Special Education_preschool Grants $911