Audit 43908

FY End
2022-06-30
Total Expended
$10.78M
Findings
4
Programs
5
Organization: City of Rancho Cordova (CA)
Year: 2022 Accepted: 2023-03-30
Auditor: Eide Bailly LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
43611 2022-001 Material Weakness Yes L
43612 2022-001 Material Weakness Yes L
620053 2022-001 Material Weakness Yes L
620054 2022-001 Material Weakness Yes L

Contacts

Name Title Type
ZPFZUH75WCL2 Michelle Mingay Auditee
9168518738 James Ramsey Auditor
No contacts on file

Notes to SEFA

Title: Direct and Indirect (Pass-Through) Federal Awards Accounting Policies: The accompanying schedule of expenditures of federal awards (Schedule) includes the federal award activity of the City of Rancho Cordova, California (City) under programs of the federal government for the year ended June 30, 2022. The information in this Schedule is presented in accordance with the requirements of Title 2 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 on the Schedule are reported on the modified accrual basis of accounting, except for subrecipient expenditures, which are recorded on the cash basis. 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. De Minimis Rate Used: N Rate Explanation: The City has not elected to use the 10-percent de minimis indirect cost rate. Federal awards may be granted directly to the City by a federal granting agency or may be granted to other government agencies which pass-through federal awards to the City. The Schedule includes both of these types of Federal award programs when they occur.

Finding Details

Finding 2022-001 Program/Cluster: CDBG-Entitlement Grants Cluster CFDA Number: 14.218 Federal Agency: U.S. Department of Housing and Urban Development Pass-through: N/A Award No. and Year: B-14-MC-06-0063 (2014), B-18-MC-06-0063 (2018), B-19-MC-06-0063 (2019), B-20-MC-06-0063 (2020), B-21-MC-06-0063 (2021) and COVID ? 19 B-20-MW-06-0063 (2020) Compliance Requirement: Reporting Type of Finding: Material Weakness in Internal Control over Compliance, Instance of Non-Compliance Criteria: 2 CFR Part 170 establishes requirements for recipients? reporting of information on subawards as required by the Federal Funding Accountability and Transparency Act of 2006 (FFATA) to be reported no later than the last day of the month following the month in which the subaward/obligation was made, or the subcontract award was made. Condition: We noted that the City did not report information on subawards as required by FFATA. Transactions Tested Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements 5 - 5 - - Dollar Amount of Tested Transactions Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements $503,366 - $503,366 - - Cause: Management implemented new internal controls after the due date of the applicable reports. Effect: The filings were late. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: We tested five (5) out of five (5) first tier subawards awarded during the fiscal year. Repeat Finding from Prior Year(s): Yes. Recommendation: We recommend that management strengthen their processes and procedures related to the submission of the required FFATA reports to ensure compliance with the program requirements. We also recommend that management establish documented review of the required FFATA reports by an individual other than the preparer prior to submission and retain record of the review and submission. Views of Responsible Officials: Management?s Response: See separate corrective action plan.
Finding 2022-001 Program/Cluster: CDBG-Entitlement Grants Cluster CFDA Number: 14.218 Federal Agency: U.S. Department of Housing and Urban Development Pass-through: N/A Award No. and Year: B-14-MC-06-0063 (2014), B-18-MC-06-0063 (2018), B-19-MC-06-0063 (2019), B-20-MC-06-0063 (2020), B-21-MC-06-0063 (2021) and COVID ? 19 B-20-MW-06-0063 (2020) Compliance Requirement: Reporting Type of Finding: Material Weakness in Internal Control over Compliance, Instance of Non-Compliance Criteria: 2 CFR Part 170 establishes requirements for recipients? reporting of information on subawards as required by the Federal Funding Accountability and Transparency Act of 2006 (FFATA) to be reported no later than the last day of the month following the month in which the subaward/obligation was made, or the subcontract award was made. Condition: We noted that the City did not report information on subawards as required by FFATA. Transactions Tested Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements 5 - 5 - - Dollar Amount of Tested Transactions Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements $503,366 - $503,366 - - Cause: Management implemented new internal controls after the due date of the applicable reports. Effect: The filings were late. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: We tested five (5) out of five (5) first tier subawards awarded during the fiscal year. Repeat Finding from Prior Year(s): Yes. Recommendation: We recommend that management strengthen their processes and procedures related to the submission of the required FFATA reports to ensure compliance with the program requirements. We also recommend that management establish documented review of the required FFATA reports by an individual other than the preparer prior to submission and retain record of the review and submission. Views of Responsible Officials: Management?s Response: See separate corrective action plan.
Finding 2022-001 Program/Cluster: CDBG-Entitlement Grants Cluster CFDA Number: 14.218 Federal Agency: U.S. Department of Housing and Urban Development Pass-through: N/A Award No. and Year: B-14-MC-06-0063 (2014), B-18-MC-06-0063 (2018), B-19-MC-06-0063 (2019), B-20-MC-06-0063 (2020), B-21-MC-06-0063 (2021) and COVID ? 19 B-20-MW-06-0063 (2020) Compliance Requirement: Reporting Type of Finding: Material Weakness in Internal Control over Compliance, Instance of Non-Compliance Criteria: 2 CFR Part 170 establishes requirements for recipients? reporting of information on subawards as required by the Federal Funding Accountability and Transparency Act of 2006 (FFATA) to be reported no later than the last day of the month following the month in which the subaward/obligation was made, or the subcontract award was made. Condition: We noted that the City did not report information on subawards as required by FFATA. Transactions Tested Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements 5 - 5 - - Dollar Amount of Tested Transactions Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements $503,366 - $503,366 - - Cause: Management implemented new internal controls after the due date of the applicable reports. Effect: The filings were late. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: We tested five (5) out of five (5) first tier subawards awarded during the fiscal year. Repeat Finding from Prior Year(s): Yes. Recommendation: We recommend that management strengthen their processes and procedures related to the submission of the required FFATA reports to ensure compliance with the program requirements. We also recommend that management establish documented review of the required FFATA reports by an individual other than the preparer prior to submission and retain record of the review and submission. Views of Responsible Officials: Management?s Response: See separate corrective action plan.
Finding 2022-001 Program/Cluster: CDBG-Entitlement Grants Cluster CFDA Number: 14.218 Federal Agency: U.S. Department of Housing and Urban Development Pass-through: N/A Award No. and Year: B-14-MC-06-0063 (2014), B-18-MC-06-0063 (2018), B-19-MC-06-0063 (2019), B-20-MC-06-0063 (2020), B-21-MC-06-0063 (2021) and COVID ? 19 B-20-MW-06-0063 (2020) Compliance Requirement: Reporting Type of Finding: Material Weakness in Internal Control over Compliance, Instance of Non-Compliance Criteria: 2 CFR Part 170 establishes requirements for recipients? reporting of information on subawards as required by the Federal Funding Accountability and Transparency Act of 2006 (FFATA) to be reported no later than the last day of the month following the month in which the subaward/obligation was made, or the subcontract award was made. Condition: We noted that the City did not report information on subawards as required by FFATA. Transactions Tested Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements 5 - 5 - - Dollar Amount of Tested Transactions Subaward Not Reported Report Not Timely Subaward Amount Incorrect Subaward Missing Key Elements $503,366 - $503,366 - - Cause: Management implemented new internal controls after the due date of the applicable reports. Effect: The filings were late. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: We tested five (5) out of five (5) first tier subawards awarded during the fiscal year. Repeat Finding from Prior Year(s): Yes. Recommendation: We recommend that management strengthen their processes and procedures related to the submission of the required FFATA reports to ensure compliance with the program requirements. We also recommend that management establish documented review of the required FFATA reports by an individual other than the preparer prior to submission and retain record of the review and submission. Views of Responsible Officials: Management?s Response: See separate corrective action plan.