Audit 300765

FY End
2023-06-30
Total Expended
$7.89M
Findings
2
Programs
3
Organization: City of Coachella (CA)
Year: 2023 Accepted: 2024-03-29

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
389881 2023-001 Material Weakness - L
966323 2023-001 Material Weakness - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $6.05M Yes 1
20.205 Highway Planning and Construction $1.43M Yes 0
14.218 Community Development Block Grants/entitlement Grants $410,386 - 0

Contacts

Name Title Type
DZD1FWED7J53 Ruben Ramirez Auditee
7603983502 Frances J. Kuo Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Basis of Accounting Funds received under the various grant programs have been recorded within the special revenue funds and capital project funds of the City. The City’s governmental fund financial statements are reported using the “current financial resources” measurement focus and the modified accrual basis of accounting. Grant revenues are recognized when meeting all eligibility requirements and are measurable and available, and expenditures are recorded when a liability is incurred. The accompanying Schedule of Expenditures of Federal Awards (the “Schedule”) is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations (“CFR”) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the “Uniform Guidance”). Therefore, some amounts presented in the Schedule may differ from amounts presented in, or used in, the preparation of the City’s basic financial statements. De Minimis Rate Used: N Rate Explanation: The City did not elect to use the 10% de minimis cost rate.

Finding Details

2023-001 – Reporting – Internal Control and Compliance over Reporting Identification of the Federal Program: Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Fund (SLFRF) Federal Agency: Department of the Treasury Pass-Through Entity: None Federal Award Number and Award Year: 2021 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Performance Reporting – Pursuant to the U.S. Department of Treasury 31 CFR Part 35 RIN 1505–AC77 the Supplementary Information of the interim final rule provided initial guidance on the reporting requirements for the SLFRF funds, the City is required to submit one interim report and quarterly Project and Expenditure reports. Condition: During our audit, we noted that the City did not submit the Project and Expenditure on time for all four quarters. Cause: The City experienced staff turnover at the department level and it created the delay in submitting the quarterly reports. Effect or Potential Effect: The delay in submission of the quarter reports may lead to the U.S. Department of Treasury imposing sanctions on the City including withholding future apportionments. Questioned Costs: No questioned costs were reported. Context: See condition above for context of the finding. Identification as a Repeat Finding, If Applicable: It is not a repeat finding. Recommendation: We recommended the City update procedures to improve control activities over the timely submission processes of the reports, including back up training to mitigate the effect of staff turnover. View of Responsible Officials: Management concurs with the finding and agrees to implement necessary corrective procedures.
2023-001 – Reporting – Internal Control and Compliance over Reporting Identification of the Federal Program: Assistance Listing Number: 21.027 Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Fund (SLFRF) Federal Agency: Department of the Treasury Pass-Through Entity: None Federal Award Number and Award Year: 2021 Criteria or Specific Requirement (Including Statutory, Regulatory, or Other Citation): Performance Reporting – Pursuant to the U.S. Department of Treasury 31 CFR Part 35 RIN 1505–AC77 the Supplementary Information of the interim final rule provided initial guidance on the reporting requirements for the SLFRF funds, the City is required to submit one interim report and quarterly Project and Expenditure reports. Condition: During our audit, we noted that the City did not submit the Project and Expenditure on time for all four quarters. Cause: The City experienced staff turnover at the department level and it created the delay in submitting the quarterly reports. Effect or Potential Effect: The delay in submission of the quarter reports may lead to the U.S. Department of Treasury imposing sanctions on the City including withholding future apportionments. Questioned Costs: No questioned costs were reported. Context: See condition above for context of the finding. Identification as a Repeat Finding, If Applicable: It is not a repeat finding. Recommendation: We recommended the City update procedures to improve control activities over the timely submission processes of the reports, including back up training to mitigate the effect of staff turnover. View of Responsible Officials: Management concurs with the finding and agrees to implement necessary corrective procedures.