Finding 1169158 (2023-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2026-01-15
Audit: 382015
Organization: City of Tahlequah (OK)

AI Summary

  • Core Issue: The City failed to accurately report federal expenditures in the Schedule of Expenditures of Federal Awards (SEFA) for fiscal year 2023.
  • Impacted Requirements: Internal controls lacked oversight, leading to the inclusion of $569,000 in improper expenditures, including $430,000 in transfers and $139,000 from prior year costs.
  • Recommended Follow-Up: The City should enhance SEFA preparation procedures and establish timely reconciliation processes for federal revenues and expenditures.

Finding Text

Criteria: The Schedule of Expenditures of Federal Awards (SEFA) should be accurately captured, reconciled, and reviewed by the City. Adequate documentation of procedures performed as well as evidence of thorough reviews should be in place. According to GAAP, expenditures should be recognized in the period services are performed or goods are received. Condition: Internal controls over financial reporting lacked oversight and thorough review of federal expenditures being included within the SEFA during fiscal year 2023. Cause and Effect: As a result, the City improperly included approximately $569,000 in expenditures in the initial SEFA received during audit fieldwork. Of this total, $430,000 was only transfers during the year rather than funds spent during fiscal year 2023. The remaining roughly $139,000 related to expenditures in assistance listing number (AL#) 21.106 which were appropriately recorded for financial statement purposes during fiscal year 2022 but failed to include these costs in the 2022 SEFA. The City then initially reported the approximately $139,000 spending on the 2023 SEFA. Recommendation: We recommend that the City review the current procedures for SEFA preparation and implement the necessary changes to ensure accurate reporting of financial information on the SEFA. We also recommend the City establish procedures to timely reconcile federal revenues to its federal expenditures. Management Response: We have reviewed current procedures regarding SEFA preparation and have implemented necessary changes to ensure accuracy. We have also established procedures to ensure a timely reconciliation of federal revenues and expenses.

Corrective Action Plan

Finding 2023-002 – Financial Reporting of Federal Expenditures Condition: Internal controls over financial reporting lacked oversight and thorough review of federal expenditures being included within the SEFA during fiscal year 2023. In conjunction with our FY2023 single audit, please see the City’s corrective action plan below: We have reviewed current procedures regarding SEFA preparation and have implemented necessary changes to ensure accuracy. We have also established procedures to ensure a timely reconciliation of federal revenues and expenses.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1169156 2023-004
    Material Weakness Repeat
  • 1169157 2023-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $297,394
20.106 AIRPORT IMPROVEMENT PROGRAM $202,422
20.219 RECREATIONAL TRAILS PROGRAM $199,924
14.228 COMMUNITY DEVELOPMENT BLOCK GRANTS/STATE'S PROGRAM AND NON-ENTITLEMENT GRANTS IN HAWAII $122,866
97.039 HAZARD MITIGATION GRANT $112,500
97.073 STATE HOMELAND SECURITY PROGRAM (SHSP) $8,524
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $2,687