Finding 1206842 (2025-001)

Material Weakness Repeat Finding
Requirement
F
Questioned Costs
-
Year
2025
Accepted
2026-04-15
Audit: 398846
Organization: Okaloosa County, Florida (FL)

AI Summary

  • Core Issue: The County's fixed asset records for property acquired with federal and state awards are missing key identifying information.
  • Impacted Requirements: Compliance with 2 CFR 200.313(d) and Florida Single Audit Act is not met due to inconsistent implementation of tracking policies.
  • Recommended Follow-Up: Ensure consistent application of the established policy for tracking fixed assets to include all required grant-specific details.

Finding Text

Criteria Section 200.313(d) of the Cost Principles of the Title 2 U.S. Code of Federal Regulations Part 200—Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) and the Florida Single Audit Act, Section 215.97, Florida Statutes, requires an entity to maintain identifying records for property acquired with federal and state awards. Additional equipment and real property requirements are contained in 2 CFR 200.311 and 48 CFR 52.245-1. These requirements state property records must include a description of the property, a serial number or another identification number, the funding source (including the federal or state award identification number), the title holder, the acquisition date, the cost of the property, the percentage of the federal or state agency contribution towards the original purchase, the location, use and condition of the property, and any disposition data including the date of disposal and sale price of the property. Condition The fixed asset listing maintained by the County for assets acquired with federal and state awards did not contain all required elements. Cause The County has an established policy that meets the requirements of the criteria noted above. The policy was not consistently implemented during the period under audit. Effect Equipment, infrastructure, buildings and real property acquired with federal and state awards is not consistently tracked to ensure compliance with federal and state regulations. Questioned Costs None noted Repeat Finding No Context The County tracks property acquisitions using internal property records spreadsheets, which has the capability to retain grant specific identifying information for assets acquired with federal or state awards. However, this information is not entered into the records on a consistent basis. Infrastructure and building additions acquired with federal and state awards are tracked and identified while the project in progress; however, once projects are completed and placed into service, grant specific identifying information is not maintained. As a result, infrastructure and building records do not independently indicate whether an asset was federally or state funded or reference key grant details, such as the funding source or award identification number. Audit testing also identified grant funded equipment purchases that did not include required information within the fixed asset record. Recommendation The County should consistently follow their policy established for tracking and identifying fixed assets acquired with federal and state grant awards. Views of Responsible Officials Okaloosa County Management concurs with the finding and recommendation. While the County maintains a policy for tracking equipment and real property acquired with federal and state awards, we acknowledge that it was not consistently implemented during the audit period, resulting in missing grant-specific information (e.g., funding source, award ID, percentage of contribution) within our fixed asset records and on certain infrastructure/building records.

Corrective Action Plan

CORRECTIVE ACTION PLAN The County respectfully submits the following corrective action plan for the year ended September 30, 2025. Name and address of independent public accounting firm: Warren Averett, LLC 45 Eglin Parkway, N.E., Suite 301, Fort Walton Beach, FL 32548. The finding from the schedule of findings and questioned costs for the year ended September 30, 2025, is discussed below. The finding is numbered consistently with the number assigned in the schedule of findings and questioned costs. Name of Contact Person for Completing Corrective Action Plan: Jane Evans, Grants and RESTORE Manager (850) 651-7521 jevans@myokaloosa.com Expected date of completion is October 1, 2026. FINDING 2025-001 – EQUIPMENT AND REAL PROPERTY MANAGEMENT Managements Response: 1. System Cleanup & Review: The Accounting Director will provide the fixed asset records to the OMB Director. The OMB Director will coordinate with relevant departments (e.g., Public Works, Facilities), to review all equipment, infrastructure, and building assets funded by federal or state awards. Missing data fields, required by 2 CFR 200.313(d) and 2 CFR 200.311 will be populated in the fixed asset records. The County is implementing a new Workday ERP system, which has an integrated fixed asset module. This module will accommodate the tracking of grant-specific information required and provide a better workflow for consistency and compliance. 2. Infrastructure Project Closeout Procedure: The County will revise the policies and closing procedures for CIP (Construction in Progress) projects. Before an asset is moved from CIP to fixed assets, the fixed asset coordinator must provide a completed "Grant-Funded Property Identification Form" detailing the funding source, FAIN (Federal Award Identification Number) or State award number, and percentage of contribution to the Finance Department. 3. Policy Re-training: The OMB Director in collaborative efforts with Finance Department will hold training sessions for all department heads and project managers to reinforce the established fixed asset tracking policy, emphasizing the compliance requirements of the Florida Single Audit Act and Uniform Guidance. 4. Ongoing Monitoring: Internal reviews of the fixed asset listing will be conducted quarterly by the Accounting Director or designee to verify that new assets are properly categorized with necessary grant details.

Categories

Equipment & Real Property Management

Other Findings in this Audit

  • 1206829 2025-001
    Material Weakness Repeat
  • 1206830 2025-001
    Material Weakness Repeat
  • 1206831 2025-001
    Material Weakness Repeat
  • 1206832 2025-001
    Material Weakness Repeat
  • 1206833 2025-001
    Material Weakness Repeat
  • 1206834 2025-001
    Material Weakness Repeat
  • 1206835 2025-001
    Material Weakness Repeat
  • 1206836 2025-001
    Material Weakness Repeat
  • 1206837 2025-001
    Material Weakness Repeat
  • 1206838 2025-001
    Material Weakness Repeat
  • 1206839 2025-001
    Material Weakness Repeat
  • 1206840 2025-001
    Material Weakness Repeat
  • 1206841 2025-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $2.97M
21.015 RESOURCES AND ECOSYSTEMS SUSTAINABILITY, TOURIST OPPORTUNITIES, AND REVIVED ECONOMIES OF THE GULF COAST STATES $1.67M
20.507 FEDERAL TRANSIT FORMULA GRANTS $1.50M
11.473 OFFICE FOR COASTAL MANAGEMENT $1.50M
20.509 FORMULA GRANTS FOR RURAL AREAS AND TRIBAL TRANSIT PROGRAM $446,500
93.563 CHILD SUPPORT SERVICES $392,953
20.526 BUSES AND BUS FACILITIES FORMULA, COMPETITIVE, AND LOW OR NO EMISSIONS PROGRAMS $367,970
20.106 AIRPORT IMPROVEMENT PROGRAM, INFRASTRUCTURE INVESTMENT AND JOBS ACT PROGRAMS, AND COVID-19 AIRPORTS PROGRAMS $191,652
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $138,028
97.067 HOMELAND SECURITY GRANT PROGRAM $100,257
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $72,349
87.052 GULF COAST ECOSYSTEM RESTORATION COUNCIL OIL SPILL IMPACT PROGRAM $66,980
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $54,349
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $49,804
16.922 EQUITABLE SHARING PROGRAM $49,444
97.039 HAZARD MITIGATION GRANT $37,122
15.605 SPORT FISH RESTORATION $31,000
16.606 STATE CRIMINAL ALIEN ASSISTANCE PROGRAM $28,561
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $27,606
20.205 HIGHWAY PLANNING AND CONSTRUCTION $15,030
15.226 PAYMENTS IN LIEU OF TAXES $13,490
90.404 HAVA ELECTION SECURITY GRANTS $9,731
21.032 LOCAL ASSISTANCE AND TRIBAL CONSISTENCY FUND $8,833
10.665 SCHOOLS AND ROADS - GRANTS TO STATES $784