Audit 40943

FY End
2022-06-30
Total Expended
$3.36M
Findings
2
Programs
2
Organization: City of Rancho Mirage (CA)
Year: 2022 Accepted: 2023-03-22
Auditor: Eide Bailly LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
46604 2022-001 Significant Deficiency - L
623046 2022-001 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $2.22M Yes 1
20.205 Highway Planning and Construction $75,011 - 0

Contacts

Name Title Type
EKCCGNXJK275 Kofi Antobam Auditee
7603244511 Kinnaly Soukhaseum Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedule of expenditures of federal awards (the schedule) includes the federal award activity of the City of Rancho Mirage (City) under programs of the federal government for the year ended June 30, 2022. The information is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the schedule presents only a selected portion of the operations of the City it is not intended to and does not present the financial position, changes in net position, or cash flows of the City. Expenditures reported in the schedule are reported on the modified-accrual basis of accounting. When applicable, such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. No federal financial assistance has been provided to a subrecipient. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10% de minimis cost rate.

Finding Details

Federal Agency: U.S. Department of the Treasury Federal Financial Assistance Listing: 21.027 Program Name: COVID-19: Coronavirus State and Local Fiscal Recovery Funds Compliance Requirement: Reporting Type of Finding: Significant Deficiency in Internal Control over Compliance, Instance of Non-compliance Criteria: 2 CFR 200.329(b) requires that reports submitted to the federal awarding agency include all activity of the reporting period, are supported by applicable accounting or performance records, and are fairly presented in accordance with program requirements. The City of Rancho Mirage (the City) must submit an annual Project and Expenditure Report that contains costs incurred during the covered period. Critical information includes: ? Obligations and Expenditures o Current period obligation o Cumulative obligation o Current period expenditure o Cumulative expenditure ? Subawards ? Detailed information on any loans issued; contracts and grants awarded; transfers made to other government entities; and direct payments made by the recipient that are greater than $50,000. For amounts less than $50,000, the recipient must report in the aggregate for these same categories of loans issued; contracts and grants awarded; transfers made to other government entities and direct payments made by the recipient. Condition: Expenditure information was reported inaccurately. Cause: The City?s control did not ensure the annual Project and Expenditure Report was prepared in accordance with governing requirements. Effect: Inaccurate information was reported to the federal awarding agency. Questioned Costs: None reported. Context/Sampling: The entire population of one annual Project and Expenditure Report submitted during the year was selected for testing. Repeat Finding from Prior Year: No Recommendation: We recommend the City enhance internal controls to ensure Project and Expenditure Reports are prepared in accordance with program requirements. Views of Responsible Officials: Management agrees. See separately issued Corrective Action Plan.
Federal Agency: U.S. Department of the Treasury Federal Financial Assistance Listing: 21.027 Program Name: COVID-19: Coronavirus State and Local Fiscal Recovery Funds Compliance Requirement: Reporting Type of Finding: Significant Deficiency in Internal Control over Compliance, Instance of Non-compliance Criteria: 2 CFR 200.329(b) requires that reports submitted to the federal awarding agency include all activity of the reporting period, are supported by applicable accounting or performance records, and are fairly presented in accordance with program requirements. The City of Rancho Mirage (the City) must submit an annual Project and Expenditure Report that contains costs incurred during the covered period. Critical information includes: ? Obligations and Expenditures o Current period obligation o Cumulative obligation o Current period expenditure o Cumulative expenditure ? Subawards ? Detailed information on any loans issued; contracts and grants awarded; transfers made to other government entities; and direct payments made by the recipient that are greater than $50,000. For amounts less than $50,000, the recipient must report in the aggregate for these same categories of loans issued; contracts and grants awarded; transfers made to other government entities and direct payments made by the recipient. Condition: Expenditure information was reported inaccurately. Cause: The City?s control did not ensure the annual Project and Expenditure Report was prepared in accordance with governing requirements. Effect: Inaccurate information was reported to the federal awarding agency. Questioned Costs: None reported. Context/Sampling: The entire population of one annual Project and Expenditure Report submitted during the year was selected for testing. Repeat Finding from Prior Year: No Recommendation: We recommend the City enhance internal controls to ensure Project and Expenditure Reports are prepared in accordance with program requirements. Views of Responsible Officials: Management agrees. See separately issued Corrective Action Plan.