Finding 575129 (2022-006)

Material Weakness
Requirement
F
Questioned Costs
-
Year
2022
Accepted
2025-08-28
Audit: 365226
Organization: City of Davis (CA)

AI Summary

  • Core Issue: The City failed to include the federal funding source in its equipment records, violating 2 CFR 200.313(d)(1).
  • Impacted Requirements: The City did not conduct a required physical inventory of federally funded property as mandated by 2 CFR 200.313(d)(2).
  • Recommended Follow-Up: Implement procedures to ensure federal funding sources are recorded and conduct physical inventories as required.

Finding Text

Finding Reference Number: SA 2022-006 Equipment Management AL Number: 14.218 Assistance Listing Title: CDBG - Entitlement Grants Cluster – Community Development Block Grants/Entitlement Grants COVID-19 - Community Development Block Grants/Entitlement Grants-CV Federal Agency: Department of Housing and Urban Development Federal Award Identification Number: B-14-MC-06-0037, B-15-MC-06-0037, B-16-MC-06-0037, B-17-MC-06-0037, B-18-MC-06-0037, B-19-MC-06-0037, B-20-MC-06-0037, B-20-MW-06-0037, B-21-MC-06-0037 Criteria: 2 CFR 200.313(d)(1) require that property records must include a description of the property, a serial number or another identification number, the source of funding for the property (including the FAIN), the title holder, the acquisition date, the cost of the property, the percentage of the Federal agency contribution towards the original purchase, the location, use and condition of the property, and any disposition data including the date of disposal and sale price of the property. The recipient and subrecipient are responsible for maintaining and updating property records when there is a change in the status of the property. In addition, a physical inventory of the property must be taken and the results reconciled with the property records at least once every two years (2 CFR section 200.313(d)(2)). Condition: During fiscal year 2022, the City purchased equipment in the amount of $97,933, which is reflected in the City’s capital asset records. However, those records do not include an indication that the funding source was a federal grant. The City did not yet perform the physical inventory of the federally funded property, because the purchase occurred during fiscal year 2022. Effect: The City is not in compliance with the property management provisions of 2 CFR 200.313(d)(1). Cause: We understand City staff was not aware of the property records requirement to include the federal funding source. We also understand the capital assets the system has the capability to include such a designation, but it has not been utilized to date. Recommendation: The City should develop procedures to ensure that equipment and other capital assets purchased in whole or in part with federal funds include an identification of the federal funding in compliance with the provisions of 2 CFR 200.313(d)(1). In addition, the City should ensure that procedures are in place meet the physical inventory requirements of 2 CFR section 200.313(d)(2). View of Responsible Officials and Planned Corrective Actions: Please see Corrective Action Plan separately prepared by the City.

Corrective Action Plan

Finding Reference Number: SA 2022-006 Equipment Management AL Number: 14.218 Assistance Listing Title: CDBG - Entitlement Grants Cluster – Community Development Block Grants/Entitlement Grants COVID-19 - Community Development Block Grants/Entitlement Grants-CV Federal Agency: Department of Housing and Urban Development Federal Award Identification Number: B-14-MC-06-0037, B-15-MC-06-0037, B-16-MC-06-0037, B-17-MC-06-0037, B-18-MC-06-0037, B-19-MC-06-0037, B-20-MC-06-0037, B-20-MW-06-0037, B-21-MC-06-0037 • Fiscal Year of Initial Finding: 2022 • Name(s) of the contact person: Jennifer Block, Management Analyst Kiranjeet Sanghera, Finance Manager • Corrective Action Plan: The City will update its capital assets records to specify funding source. Procedures will be developed to meet physical inventory requirements. • Anticipated Completion Date: October 2025

Categories

Equipment & Real Property Management

Other Findings in this Audit

  • 575124 2022-001
    Material Weakness Repeat
  • 575125 2022-002
    Material Weakness Repeat
  • 575126 2022-003
    Material Weakness Repeat
  • 575127 2022-004
    Material Weakness Repeat
  • 575128 2022-005
    Material Weakness
  • 575130 2022-001
    Material Weakness Repeat
  • 575131 2022-002
    Material Weakness Repeat
  • 575132 2022-003
    Material Weakness Repeat
  • 575133 2022-004
    Material Weakness Repeat
  • 575134 2022-005
    Material Weakness
  • 575135 2022-006
    Material Weakness
  • 575136 2022-007
    Significant Deficiency
  • 575137 2022-008
    Significant Deficiency
  • 575138 2022-009
    Significant Deficiency
  • 575139 2022-009
    Significant Deficiency
  • 575140 2022-009
    Significant Deficiency
  • 1151566 2022-001
    Material Weakness Repeat
  • 1151567 2022-002
    Material Weakness Repeat
  • 1151568 2022-003
    Material Weakness Repeat
  • 1151569 2022-004
    Material Weakness Repeat
  • 1151570 2022-005
    Material Weakness
  • 1151571 2022-006
    Material Weakness
  • 1151572 2022-001
    Material Weakness Repeat
  • 1151573 2022-002
    Material Weakness Repeat
  • 1151574 2022-003
    Material Weakness Repeat
  • 1151575 2022-004
    Material Weakness Repeat
  • 1151576 2022-005
    Material Weakness
  • 1151577 2022-006
    Material Weakness
  • 1151578 2022-007
    Significant Deficiency
  • 1151579 2022-008
    Significant Deficiency
  • 1151580 2022-009
    Significant Deficiency
  • 1151581 2022-009
    Significant Deficiency
  • 1151582 2022-009
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $4.08M
20.507 Federal Transit Formula Grants $2.83M
20.205 Highway Planning and Construction $1.57M
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $1.06M
14.218 Community Development Block Grants/entitlement Grants $302,823
14.235 Supportive Housing Program $78,419
93.569 Community Services Block Grant $65,437
14.239 Home Investment Partnerships Program $50,355
97.029 Flood Mitigation Assistance $32,249
59.075 Shuttered Venue Operators Grant Program $9,361
15.904 Historic Preservation Fund Grants-in-Aid $5,000
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $2,112