Finding 1169156 (2023-004)

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 monitor and submit required reports accurately and on time for CSLFRF and AIP funding.
  • Impacted Requirements: Annual Project and Expenditure Reports for CSLFRF were submitted but contained discrepancies; SF-425 reports for AIP were not submitted by the deadline.
  • Recommended Follow-Up: Establish a centralized tracking system for grant reporting deadlines and assign specific individuals to ensure compliance and accuracy.

Finding Text

Criteria: Per the Compliance and Reporting Guidance for Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) assistance listing number (AL#) 21.027, all recipients are required to submit Project and Expenditure Reports. Annual reports are required for cities below 250,000 residents that are allocated less than $10 million in CSLFRF funding and must be submitted to the Department of Treasury by April 30. In addition, per the Airport Improvement Program (AIP) handbook for AL# 20.106, grant recipients must submit timely and accurate SF-425 financial reports annually, by December 31, to summarize expenditures and status of project funds. Condition: The City’s internal controls over reporting compliance requirements were not thoroughly monitored and were not timely, and reports were not accurately submitted. Questioned Costs: $0 Cause and Effect: Due to the City not having a centralized reporting requirement schedule, the required annual report for CSLFRF funding was submitted by April 30 deadline however the reported amount $0 did not agree to the amount reported on the SEFA of $297,394. As it relates to the AIP, as of the end of audit field work, the SF-425 report was still pending submission to the Department of Transportation. Recommendation: We recommend the City centrally track its required grant reporting and related deadlines with specific individuals identified by grant program to ensure timely and accurate reporting is achieved. Management Response: We have reviewed current procedures regarding report 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-004 – Reporting Compliance Requirements of Federal Funds Condition: The City’s internal controls over reporting compliance requirements were not thoroughly monitored and were not timely, and reports were not accurately submitted. In conjunction with our FY2023 single audit, please see the City’s corrective action plan below: We have reviewed current procedures regarding report 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

Other Findings in this Audit

  • 1169157 2023-003
    Material Weakness Repeat
  • 1169158 2023-002
    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