Finding 1138324 (2024-005)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-05-29
Audit: 357537
Organization: City of Desert Hot Springs (CA)

AI Summary

  • Core Issue: The City reported incorrect financial data in the Project and Expenditure Report, leading to noncompliance with SLFRF requirements.
  • Impacted Requirements: Annual reporting criteria for SLFRF funding, including accurate cumulative expenditures and obligations.
  • Recommended Follow-Up: Establish a review process, train staff on reporting requirements, and improve internal controls for data validation.

Finding Text

Finding 2024-005 Reporting – Internal Control over Reporting Identification of the Federal Program: Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Federal Agency: U.S. Department of the Treasury Federal Award Identification Number: 1505-0271 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Pursuant to the U.S. Department of the Treasury’s State and Local Fiscal Recovery Funds (SLFRF) requirements, certain recipients must submit an annual Project and Expenditure Report by April 30, covering the reporting period from April 1 to March 31. This requirement applies to: - Tribal governments that are allocated less than $30 million in SLFRF funding. - Metropolitan cities and counties with a population below 250,000 residents that are allocated less than $10 million in SLFRF funding and NEUs that are allocated less than $10 million in SLFRF funding. The Project and Expenditure Report must include: a. Project descriptions detailing major activities funded. b. Financial data, including cumulative and current-period obligations and expenditures. c. Estimated future expenses for obligations incurred by December 31, 2024, but to be spent in 2025 and 2026. d. Project status, categorized as: not started, completed less than 50 percent, completed 50 percent or more, and completed. e. Program income earned and expended, if applicable. f. adopted project budgets (for States, U.S. territories, metropolitan cities and counties with a population that exceeds 250,000 residents only). g. demographic data for Public Health and Negative Economic Impact expenditures. h. Detailed expenditure data for any contracts and grants awarded, loans issued, transfers made to other government entities, interagency agreements entered into, and direct payments made by the recipient that are equal to or greater than $50,000. Condition: During our review of the City's Annual March 2024 Project and Expenditure Report, we identified significant discrepancies in the reported financial data. The City reported total cumulative expenditures of $6,908,231, current period obligations of $6,908,231, and current period expenditures of $6,908,231. However, the correct amounts should have been total cumulative expenditures of $3,104,398, current period obligations of $3,803,833, and current period expenditures of $106,617. Cause: The City does not have internal controls in place to ensure that City employees are adequately trained on the reporting requirements. Effect or Potential Effect: Failure to report correct obligated and expended amounts in the annual report resulted in noncompliance with SLFRF reporting requirements. These misstatements may compromise the accuracy and transparency of financial reporting and expenditure tracking. Questioned Costs: None noted. Context: See condition above for the context of the finding. Identification as a Repeat Finding, If Applicable: No. Recommendation: We recommend the City implement a review and reconciliation process to ensure accurate reporting of expenditures, obligations, and cumulative totals. This includes providing training to staff on the proper reporting period and reconciliation requirements, establishing internal controls for data validation before submission, and enhancing coordination between departments responsible for financial reporting. Views of Responsible Officials: Management concurs with the finding and agrees to implement necessary corrective procedures.

Categories

Reporting Matching / Level of Effort / Earmarking Program Income Internal Control / Segregation of Duties

Other Findings in this Audit

  • 561876 2024-004
    Significant Deficiency
  • 561877 2024-004
    Significant Deficiency
  • 561878 2024-004
    Significant Deficiency
  • 561879 2024-004
    Significant Deficiency
  • 561880 2024-004
    Significant Deficiency
  • 561881 2024-004
    Significant Deficiency
  • 561882 2024-005
    Significant Deficiency
  • 1138318 2024-004
    Significant Deficiency
  • 1138319 2024-004
    Significant Deficiency
  • 1138320 2024-004
    Significant Deficiency
  • 1138321 2024-004
    Significant Deficiency
  • 1138322 2024-004
    Significant Deficiency
  • 1138323 2024-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.205 Highway Planning and Construction $3.29M
14.218 Community Development Block Grants/entitlement Grants $373,043
21.027 Coronavirus State and Local Fiscal Recovery Funds $106,617
97.067 Homeland Security Grant Program $58,324
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $46,246
20.600 State and Community Highway Safety $24,405
16.738 Edward Byrne Memorial Justice Assistance Grant Program $17,990
16.607 Bulletproof Vest Partnership Program $2,002