Finding 960700 (2021-004)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2021
Accepted
2024-03-25
Audit: 297401
Organization: City of Davis (CA)

AI Summary

  • Core Issue: The City failed to report a $198,760 contract in the FSRS, violating FFATA requirements.
  • Impacted Requirements: Compliance with FFATA mandates for reporting first-tier subawards of $30,000 or more.
  • Recommended Follow-Up: Establish procedures to ensure accurate and timely FFATA reporting, including updates for contract amendments.

Finding Text

Finding Reference Number: SA 2021-004 Federal Funding Accountability and Transparency Act (FFATA) Reporting AL Number: 14.218 Assistance Listing Title: COVID-19 - Community Development Block Grants/Entitlement Grants (CDBG) Federal Agency: Department of Housing and Urban Development Federal Award Identification Number: B-14-MC-06-0037, B-18-MC-06-0037, B-19-MC-06-0037, B-20-MC-06-0037, B-20-MW-06-0037 Criteria: Under the requirements of the Federal Funding Accountability and Transparency Act (FFATA) (Pub. L. No. 109-282), as amended by Section 6202 of Public Law 110-252 that are codified in 2 CFR Part 170, direct recipients of grants are required to report first-tier subawards of $30,000 or more to the Federal Funding Accountability and Transparency Act Subaward Reporting System (FSRS). Subawards that are entered into the FSRS System should be maintained so that any amendments to the subawards are also reflected in the system. Condition: We selected three of the City’s subawards for testing of the reporting on the FSRS. The three subawards tested were comprised of two vendor contracts and one subgrant that were all more than $30,000. Although we noted that two of the contracts tested were included in the FSRS, one of the contracts in the amount of $198,760 was not reported in FSRS. We understand the City did not report that contract in the FSRS until March 10, 2024. Effect: The City is not in compliance with the FFATA reporting requirements. Cause: We understand the contract was not included in the FSRS due to City staff oversight. Recommendation: Although the City provided documentation that the FSRS was updated on March 10, 2024 to include the $198,760 contract, the City should develop procedures to ensure that FFATA reporting is accurate at all times and reflects any contract amendments and final subaward funding amounts. View of Responsible Officials and Planned Corrective Actions: Please see Corrective Action Plan separately prepared by the City.

Categories

Subrecipient Monitoring Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 384252 2021-002
    Material Weakness
  • 384253 2021-003
    Material Weakness
  • 384254 2021-004
    Material Weakness
  • 384255 2021-005
    Material Weakness
  • 384256 2021-002
    Material Weakness
  • 384257 2021-003
    Material Weakness
  • 384258 2021-004
    Material Weakness
  • 384259 2021-005
    Material Weakness
  • 384260 2021-003
    Material Weakness
  • 384261 2021-001
    Significant Deficiency
  • 384262 2021-001
    Significant Deficiency
  • 384263 2021-001
    Significant Deficiency
  • 384264 2021-001
    Significant Deficiency
  • 384265 2021-006
    Significant Deficiency
  • 384266 2021-006
    Significant Deficiency
  • 960694 2021-002
    Material Weakness
  • 960695 2021-003
    Material Weakness
  • 960696 2021-004
    Material Weakness
  • 960697 2021-005
    Material Weakness
  • 960698 2021-002
    Material Weakness
  • 960699 2021-003
    Material Weakness
  • 960701 2021-005
    Material Weakness
  • 960702 2021-003
    Material Weakness
  • 960703 2021-001
    Significant Deficiency
  • 960704 2021-001
    Significant Deficiency
  • 960705 2021-001
    Significant Deficiency
  • 960706 2021-001
    Significant Deficiency
  • 960707 2021-006
    Significant Deficiency
  • 960708 2021-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.205 Highway Planning and Construction $2.01M
20.507 Federal Transit_formula Grants $1.15M
21.019 Coronavirus Relief Fund $854,212
14.239 Home Investment Partnerships Program $756,822
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $530,529
14.218 Community Development Block Grants/entitlement Grants $414,828
93.569 Community Services Block Grant $64,721
14.235 Supportive Housing Program $57,891
97.029 Flood Mitigation Assistance $56,766