Audit 357365

FY End
2024-06-30
Total Expended
$1.70M
Findings
2
Programs
3
Organization: City of Coachella (CA)
Year: 2024 Accepted: 2025-05-28

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
561728 2024-001 Material Weakness Yes L
1138170 2024-001 Material Weakness Yes L

Programs

ALN Program Spent Major Findings
20.205 Highway Planning and Construction $702,754 Yes 0
14.218 Community Development Block Grants/entitlement Grants $616,535 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $383,750 - 1

Contacts

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

Notes to SEFA

Title: Note 1 - Reporting Entity 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. The financial reporting entity, as defined by the Governmental Accounting Standard Board (“GASB”) Codification, consists of the primary government, which is the City of Coachella, California (the “City”), organizations for which the primary government is financially accountable, and other organizations for which the nature and significance of their relationship with the primary government are such that exclusion would cause the City’s financial statements to be misleading or incomplete. The City Council acts as the governing body and is able to impose its will on the following organization, establishing financial accountability: Coachella Sanitary District Coachella Water Authority Coachella Fire Protection District Coachella Financing Authority
Title: Note 2 – Summary of Significant Accounting Policies 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. Basis of Accounting Funds received under the various grant programs have been recorded within the special revenue funds and capital projects 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. Schedule of Expenditures of Federal Awards The accompanying Schedule presents the activity of all federal financial assistance programs of the City. Federal financial assistance passed through the County of Riverside and the State of California Department of Transportation are included in the Schedule. The Schedule was prepared from only the accounts of various grant programs and, therefore, does not present the financial position or results of operations of the City. Indirect Cost Rate The City did not elect to use the 10% de minimis cost rate.

Finding Details

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 two of the 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 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 two of the 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