Finding 480327 (2022-007)

Material Weakness Repeat Finding
Requirement
C
Questioned Costs
-
Year
2022
Accepted
2024-08-04
Audit: 316559
Organization: City of Manteca (CA)

AI Summary

  • Core Issue: The City failed to submit timely drawdown requests for COVID-19 grant expenditures, leading to mismatched reporting of costs and revenues.
  • Impacted Requirements: Drawdown requests must be made quarterly, and expenditures reported on the SEFA should align with reimbursement requests to avoid inaccuracies.
  • Recommended Follow-Up: The City should establish procedures for regular drawdown requests and ensure accurate reporting of all grant expenditures on the SEFA.

Finding Text

Finding #SA2022-007: Cash Management Assistance Listing Number: 14.218 Assistance Listing Title: COVID-19 - Community Development Block Grants/Entitlement Grants Name of Federal Agency: Department of Housing and Urban Development Pass Through Entity: San Joaquin County Community Development Department Federal Award Identification Number: A-93-916 Criteria: The City should submit drawdown requests to San Joaquin County throughout the fiscal year as costs are incurred. Those drawdown requests should be completed at least quarterly, depending on the volume of program activity, to improve the cash management for the program and to match expenditures with associated revenues throughout the fiscal year. In addition, since the grant is on a reimbursement basis, expenditures should generally be incurred prior to requesting reimbursement from the County, unless specifically authorized by the grantor, and costs reported on the SEFA should be the same as those included in requests for reimbursement. Condition: The City reported expenditures under the COVID-19 - CDBG-CV Program totaling $378,077 in fiscal year 2021. As noted in prior year finding SA2021-005, the City had not requested reimbursement for all of those costs during fiscal year 2021 or subsequent to fiscal year 2021. When we began our work on the fiscal year 2022 single audit, we noted that the COVID-19 - CDBG-CV Program was not included on the SEFA. The grant award was for $400,000 and we inquired about whether the remaining funding of $21,923 had been expended or reimbursed during the fiscal year 2022. In response to that question, City staff provided the grant drawdown information which totaled to $400,000, but only $40,200 of those costs had been included on the prior year SEFA. The remaining costs drawn down from the grant during fiscal year 2022 of $359,800 were different costs than were incurred during fiscal year 2021. Effect: The City is not matching expenditures with associated grant revenues throughout the fiscal year as expenditures are incurred and is at risk of filing a reimbursement request after the filing deadlines of the County. In addition, when the City reports costs on the SEFA that are different from the costs requested for reimbursement from the grantor, it not only misstates the SEFA, but it could also mean ineligible costs are reported. Cause: We understand that the program is currently administrated by different departmental staff than the staff during fiscal year 2022 and staff turnover led to the late preparation of reimbursements and the inclusion of project expenditures on the reimbursement request that were different from those reported on the prior year SEFA. Identification as a repeat finding: Yes, since 2021 Recommendation: The City must develop procedures to ensure that all grant-funded expenditures are included on drawdown requests and those requests should be prepared at least quarterly throughout the fiscal year. In addition, City staff should ensure that program costs incurred are properly reported on the annual SEFA. View of Responsible Officials and Planned Corrective Actions: Please see Corrective Action Plan separately prepared by the City.

Corrective Action Plan

Finding #SA2022-007: Cash Management Assistance Listing Number: 14.218 Assistance Listing Title: COVID-19 - Community Development Block Grants/Entitlement Grants Name of Federal Agency: Department of Housing and Urban Development Pass Through Entity: San Joaquin County Community Development Department Federal Award Identification Number: A-93-916 • Fiscal Year of Initial Finding: 2021 • Name(s) of the contact person: Shay Narayan, Director of Finance; Carmen Gusman, Deputy Director of Finance • Corrective Action Plan: The City will develop procedures to ensure all grant-funded expenditures are included on drawdown request and prepared quarterly. Finance staff plan to have regular check-ins with department staff administering federal grants to obtain status updates on expenditures and drawdowns, and reconcile activities accordingly. • Anticipated Completion Date: 10/30/24

Categories

Cash Management

Other Findings in this Audit

  • 480328 2022-008
    Material Weakness
  • 480329 2022-007
    Material Weakness Repeat
  • 480330 2022-008
    Material Weakness
  • 480331 2022-003
    Material Weakness
  • 480332 2022-004
    Significant Deficiency
  • 480333 2022-005
    Material Weakness
  • 480334 2022-006
    Material Weakness
  • 480335 2022-003
    Material Weakness
  • 480336 2022-004
    Significant Deficiency
  • 480337 2022-005
    Material Weakness
  • 480338 2022-006
    Material Weakness
  • 480339 2022-002
    Significant Deficiency
  • 1056769 2022-007
    Material Weakness Repeat
  • 1056770 2022-008
    Material Weakness
  • 1056771 2022-007
    Material Weakness Repeat
  • 1056772 2022-008
    Material Weakness
  • 1056773 2022-003
    Material Weakness
  • 1056774 2022-004
    Significant Deficiency
  • 1056775 2022-005
    Material Weakness
  • 1056776 2022-006
    Material Weakness
  • 1056777 2022-003
    Material Weakness
  • 1056778 2022-004
    Significant Deficiency
  • 1056779 2022-005
    Material Weakness
  • 1056780 2022-006
    Material Weakness
  • 1056781 2022-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.507 Federal Transit_formula Grants $1.66M
21.027 Coronavirus State and Local Fiscal Recovery Funds $735,218
14.218 Community Development Block Grants/entitlement Grants $359,800
97.083 Staffing for Adequate Fire and Emergency Response (safer) $146,104
20.205 Highway Planning and Construction $64,802
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $56,218
16.034 Coronavirus Emergency Supplemental Funding Program $53,798
20.616 National Priority Safety Programs $40,192
20.600 State and Community Highway Safety $37,825
16.738 Edward Byrne Memorial Justice Assistance Grant Program $29,993
97.044 Assistance to Firefighters Grant $3,091