Audit 36352

FY End
2022-06-30
Total Expended
$2.37M
Findings
8
Programs
4
Organization: City of Jurupa Valley (CA)
Year: 2022 Accepted: 2023-03-30
Auditor: Eide Bailly LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
33720 2022-003 Material Weakness - L
33721 2022-003 Material Weakness - L
33722 2022-003 Material Weakness - L
33723 2022-003 Material Weakness - L
610162 2022-003 Material Weakness - L
610163 2022-003 Material Weakness - L
610164 2022-003 Material Weakness - L
610165 2022-003 Material Weakness - L

Contacts

Name Title Type
WCY7YZTBWKN5 Connie Cardenas Auditee
9513326464 Jessica Andersen 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 Jurupa Valley, California (City) under programs of the federal government for the year ended June 30, 2022. The Citys reporting entity is defined in Note 1 of the Citys financial statements. All federal awards received directly from federal agencies as well as federal awards passed through from other government agencies are included on the Schedule of Expenditures of Federal Awards. 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 fund balance, or cash flows of the City. Amounts reported in the accompanying Schedule of Expenditures of Federal Awards agree with the amounts reported in the related federal financial reports. However, certain federal financial reports are filed based on cash expenditures. As such, certain timing differences may exist in the recognition of revenues and expenditures between the Schedule of Expenditures of Federal Awards and the federal financial reports. Funds received under the various grant programs have been recorded within the special revenue funds of the City. The City utilizes the modified accrual basis of accounting for the special revenue funds. 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. De Minimis Rate Used: N Rate Explanation: The City does not draw for indirect administrative expenses and has not elected to use the 10% de minimis cost rate.

Finding Details

Federal Agency: U.S. Department of Housing and Urban Development Federal Financial Assistance Listing: 14.218 Program Name: CDBG Entitlement Grants Cluster Award No. and Year: 2021 B-21-MC-0607 and 2020 B-20-MW-06-0607 Compliance Requirement: Reporting Type of Finding: Material Weakness 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. For direct recipients of grants or cooperative agreements who make first-tier subawards of $30,000 or more are required to register in the Federal Funding Accountability and Transparency Act (FFATA) Subaward Reporting System (FSRS) and report subaward date through FSRS. The City must report the following items: ? All subaward obligations/modifications that have been reported ? Subaward date ? Subrecipient DUNS number ? Amount of subaward ? Subaward obligation/action date ? Date of report submission ? Subaward number Condition: FFATA reporting was not completed through FSRS. Cause: The City?s internal controls did not ensure the FFATA reporting was completed in accordance with governing requirements. Effect: Information was not reported to the federal awarding agency. Questioned Costs: None reported. Context/Sampling: The entire population of one subrecipient who received in excess of $30,000 was selected for testing. Repeat Finding from Prior Year: No Recommendation: We recommend the City enhance internal controls to ensure FFATA reporting is prepared in accordance with program requirements. Views of Responsible Officials: Management agrees. See separately issued Corrective Action Plan.
Federal Agency: U.S. Department of Housing and Urban Development Federal Financial Assistance Listing: 14.218 Program Name: CDBG Entitlement Grants Cluster Award No. and Year: 2021 B-21-MC-0607 and 2020 B-20-MW-06-0607 Compliance Requirement: Reporting Type of Finding: Material Weakness 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. For direct recipients of grants or cooperative agreements who make first-tier subawards of $30,000 or more are required to register in the Federal Funding Accountability and Transparency Act (FFATA) Subaward Reporting System (FSRS) and report subaward date through FSRS. The City must report the following items: ? All subaward obligations/modifications that have been reported ? Subaward date ? Subrecipient DUNS number ? Amount of subaward ? Subaward obligation/action date ? Date of report submission ? Subaward number Condition: FFATA reporting was not completed through FSRS. Cause: The City?s internal controls did not ensure the FFATA reporting was completed in accordance with governing requirements. Effect: Information was not reported to the federal awarding agency. Questioned Costs: None reported. Context/Sampling: The entire population of one subrecipient who received in excess of $30,000 was selected for testing. Repeat Finding from Prior Year: No Recommendation: We recommend the City enhance internal controls to ensure FFATA reporting is prepared in accordance with program requirements. Views of Responsible Officials: Management agrees. See separately issued Corrective Action Plan.
Federal Agency: U.S. Department of Housing and Urban Development Federal Financial Assistance Listing: 14.218 Program Name: CDBG Entitlement Grants Cluster Award No. and Year: 2021 B-21-MC-0607 and 2020 B-20-MW-06-0607 Compliance Requirement: Reporting Type of Finding: Material Weakness 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. For direct recipients of grants or cooperative agreements who make first-tier subawards of $30,000 or more are required to register in the Federal Funding Accountability and Transparency Act (FFATA) Subaward Reporting System (FSRS) and report subaward date through FSRS. The City must report the following items: ? All subaward obligations/modifications that have been reported ? Subaward date ? Subrecipient DUNS number ? Amount of subaward ? Subaward obligation/action date ? Date of report submission ? Subaward number Condition: FFATA reporting was not completed through FSRS. Cause: The City?s internal controls did not ensure the FFATA reporting was completed in accordance with governing requirements. Effect: Information was not reported to the federal awarding agency. Questioned Costs: None reported. Context/Sampling: The entire population of one subrecipient who received in excess of $30,000 was selected for testing. Repeat Finding from Prior Year: No Recommendation: We recommend the City enhance internal controls to ensure FFATA reporting is prepared in accordance with program requirements. Views of Responsible Officials: Management agrees. See separately issued Corrective Action Plan.
Federal Agency: U.S. Department of Housing and Urban Development Federal Financial Assistance Listing: 14.218 Program Name: CDBG Entitlement Grants Cluster Award No. and Year: 2021 B-21-MC-0607 and 2020 B-20-MW-06-0607 Compliance Requirement: Reporting Type of Finding: Material Weakness 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. For direct recipients of grants or cooperative agreements who make first-tier subawards of $30,000 or more are required to register in the Federal Funding Accountability and Transparency Act (FFATA) Subaward Reporting System (FSRS) and report subaward date through FSRS. The City must report the following items: ? All subaward obligations/modifications that have been reported ? Subaward date ? Subrecipient DUNS number ? Amount of subaward ? Subaward obligation/action date ? Date of report submission ? Subaward number Condition: FFATA reporting was not completed through FSRS. Cause: The City?s internal controls did not ensure the FFATA reporting was completed in accordance with governing requirements. Effect: Information was not reported to the federal awarding agency. Questioned Costs: None reported. Context/Sampling: The entire population of one subrecipient who received in excess of $30,000 was selected for testing. Repeat Finding from Prior Year: No Recommendation: We recommend the City enhance internal controls to ensure FFATA reporting is prepared in accordance with program requirements. Views of Responsible Officials: Management agrees. See separately issued Corrective Action Plan.
Federal Agency: U.S. Department of Housing and Urban Development Federal Financial Assistance Listing: 14.218 Program Name: CDBG Entitlement Grants Cluster Award No. and Year: 2021 B-21-MC-0607 and 2020 B-20-MW-06-0607 Compliance Requirement: Reporting Type of Finding: Material Weakness 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. For direct recipients of grants or cooperative agreements who make first-tier subawards of $30,000 or more are required to register in the Federal Funding Accountability and Transparency Act (FFATA) Subaward Reporting System (FSRS) and report subaward date through FSRS. The City must report the following items: ? All subaward obligations/modifications that have been reported ? Subaward date ? Subrecipient DUNS number ? Amount of subaward ? Subaward obligation/action date ? Date of report submission ? Subaward number Condition: FFATA reporting was not completed through FSRS. Cause: The City?s internal controls did not ensure the FFATA reporting was completed in accordance with governing requirements. Effect: Information was not reported to the federal awarding agency. Questioned Costs: None reported. Context/Sampling: The entire population of one subrecipient who received in excess of $30,000 was selected for testing. Repeat Finding from Prior Year: No Recommendation: We recommend the City enhance internal controls to ensure FFATA reporting is prepared in accordance with program requirements. Views of Responsible Officials: Management agrees. See separately issued Corrective Action Plan.
Federal Agency: U.S. Department of Housing and Urban Development Federal Financial Assistance Listing: 14.218 Program Name: CDBG Entitlement Grants Cluster Award No. and Year: 2021 B-21-MC-0607 and 2020 B-20-MW-06-0607 Compliance Requirement: Reporting Type of Finding: Material Weakness 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. For direct recipients of grants or cooperative agreements who make first-tier subawards of $30,000 or more are required to register in the Federal Funding Accountability and Transparency Act (FFATA) Subaward Reporting System (FSRS) and report subaward date through FSRS. The City must report the following items: ? All subaward obligations/modifications that have been reported ? Subaward date ? Subrecipient DUNS number ? Amount of subaward ? Subaward obligation/action date ? Date of report submission ? Subaward number Condition: FFATA reporting was not completed through FSRS. Cause: The City?s internal controls did not ensure the FFATA reporting was completed in accordance with governing requirements. Effect: Information was not reported to the federal awarding agency. Questioned Costs: None reported. Context/Sampling: The entire population of one subrecipient who received in excess of $30,000 was selected for testing. Repeat Finding from Prior Year: No Recommendation: We recommend the City enhance internal controls to ensure FFATA reporting is prepared in accordance with program requirements. Views of Responsible Officials: Management agrees. See separately issued Corrective Action Plan.
Federal Agency: U.S. Department of Housing and Urban Development Federal Financial Assistance Listing: 14.218 Program Name: CDBG Entitlement Grants Cluster Award No. and Year: 2021 B-21-MC-0607 and 2020 B-20-MW-06-0607 Compliance Requirement: Reporting Type of Finding: Material Weakness 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. For direct recipients of grants or cooperative agreements who make first-tier subawards of $30,000 or more are required to register in the Federal Funding Accountability and Transparency Act (FFATA) Subaward Reporting System (FSRS) and report subaward date through FSRS. The City must report the following items: ? All subaward obligations/modifications that have been reported ? Subaward date ? Subrecipient DUNS number ? Amount of subaward ? Subaward obligation/action date ? Date of report submission ? Subaward number Condition: FFATA reporting was not completed through FSRS. Cause: The City?s internal controls did not ensure the FFATA reporting was completed in accordance with governing requirements. Effect: Information was not reported to the federal awarding agency. Questioned Costs: None reported. Context/Sampling: The entire population of one subrecipient who received in excess of $30,000 was selected for testing. Repeat Finding from Prior Year: No Recommendation: We recommend the City enhance internal controls to ensure FFATA reporting is prepared in accordance with program requirements. Views of Responsible Officials: Management agrees. See separately issued Corrective Action Plan.
Federal Agency: U.S. Department of Housing and Urban Development Federal Financial Assistance Listing: 14.218 Program Name: CDBG Entitlement Grants Cluster Award No. and Year: 2021 B-21-MC-0607 and 2020 B-20-MW-06-0607 Compliance Requirement: Reporting Type of Finding: Material Weakness 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. For direct recipients of grants or cooperative agreements who make first-tier subawards of $30,000 or more are required to register in the Federal Funding Accountability and Transparency Act (FFATA) Subaward Reporting System (FSRS) and report subaward date through FSRS. The City must report the following items: ? All subaward obligations/modifications that have been reported ? Subaward date ? Subrecipient DUNS number ? Amount of subaward ? Subaward obligation/action date ? Date of report submission ? Subaward number Condition: FFATA reporting was not completed through FSRS. Cause: The City?s internal controls did not ensure the FFATA reporting was completed in accordance with governing requirements. Effect: Information was not reported to the federal awarding agency. Questioned Costs: None reported. Context/Sampling: The entire population of one subrecipient who received in excess of $30,000 was selected for testing. Repeat Finding from Prior Year: No Recommendation: We recommend the City enhance internal controls to ensure FFATA reporting is prepared in accordance with program requirements. Views of Responsible Officials: Management agrees. See separately issued Corrective Action Plan.