Finding 1165460 (2024-001)

Material Weakness Repeat Finding
Requirement
C
Questioned Costs
-
Year
2024
Accepted
2025-12-18
Audit: 376192
Organization: City of Manteca (CA)

AI Summary

  • Core Issue: The City is not submitting timely reimbursement requests for grant expenditures, leading to discrepancies in Federal Financial Reports.
  • Impacted Requirements: This situation violates 2 CFR Section 200.303, which mandates accurate internal controls and timely matching of expenditures with revenues.
  • Recommended Follow-Up: The City should implement procedures to ensure accurate reporting and timely drawdown requests at least quarterly to comply with grant requirements.

Finding Text

Finding #SA2024-001 Cash Management and Accuracy of Federal Financial Reports Assistance Listing Number: 20.507 Assistance Listing Title: COVID-19 – Federal Transit Formula Grants (Urbanized Area Formula Program) – Federal Transit Cluster Name of Federal Agency: Department of Transportation Federal Award Identification Number: CA-2022-083-00 Criteria: The 2 CFR Section 200.303 requires that non-Federal entities receiving Federal awards establish and maintain internal control designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Related to these requirements, the City should submit drawdown requests to the Department of Transportation throughout the fiscal year as costs are incurred and Federal Financial Reports should agree with those drawdown requests and supporting accounting records. 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 Department of Transportation unless specifically authorized by the grantor, and costs included in the Federal Financial Reports should be the same as those included in requests for reimbursement. Condition: During our review of the Federal Financial Reports related to grant CA-2022-083-00, we noted that for the first quarter of fiscal year 2024, the report included expenditures in the amount of $364,837, but the City only requested reimbursement in the amount of $265,281 during that same time period. In addition to our review of the Federal Financial Reports, we also reviewed the timing of expenditures in relation to the associated reimbursement requests and noted that for both of the grants listed above, the City did not file for and receive reimbursement for the associated grant expenditures until four to over eight months after the activity took place. The grant drawdowns took place as follows: Period of Federal Expenditures Date of Filing for Reimbursement July 1, 2023 to September 30, 2023 May 20, 2024 October 1, 2023 to December 31, 2023 May 20, 2024 January 1, 2024 to March 31, 2024 September 9, 2024 April 1, 2024 to June 30, 2024 November 25, 2024 Cause: We understand that the City fell behind on drawing down grant funds on a timely basis due to employee turnover and this in turn caused the inaccuracies in the Federal Financial Reports. Effect: The City is not in compliance with the internal control requirements of 2 CFR Section 200.303. The City is not matching expenditures with associated grant revenues throughout the fiscal year by filing timely reimbursement requests as expenditures are incurred and is at risk of filing a reimbursement request after the filing deadlines of the grant. In addition, the late filing of reimbursement requests resulted in inaccurate Federal Financial Reporting to the grantor. Recommendation: The City must develop procedures to ensure grant reports are accurate and agree with supporting accounting records prior to being submitted to the grantor. The City must also 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. View of Responsible Officials and Planned Corrective Actions: Please see Corrective Action Plan separately prepared by the City.

Corrective Action Plan

Finding #SA2024-001 Cash Management and Accuracy of Federal Financial Reports Assistance Listing Number: 20.507 Assistance Listing Title: COVID-19 – Federal Transit Formula Grants Name of Federal Agency: Department of Transportation Federal Award Identification Number: CA-2022-083-00 • Name(s) of the contact person: Melissa Munoz, Interim Assistant Finance Director • Corrective Action Plan: Staff recognize that drawdown requests have not been submitted timely and/or accurately in the past. Critical positions that were vacant within the department have been filled, which has helped alleviate some of these issues. Current staff understands the importance of accurate and timely drawdown requests. The City is in the development phase of the grant policy and is actively working with a consultant on the policy. This policy will be partially implemented in Fiscal Year 2026. Additionally, staff will be attending a Grant Management training in Fiscal Year 2026. • Anticipated Completion Date: 06/30/2026

Categories

Cash Management Reporting Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 1165461 2024-002
    Material Weakness Repeat
  • 1165462 2024-003
    Material Weakness Repeat
  • 1165463 2024-004
    Material Weakness Repeat
  • 1165464 2024-002
    Material Weakness Repeat
  • 1165465 2024-003
    Material Weakness Repeat
  • 1165466 2024-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
20.507 FEDERAL TRANSIT FORMULA GRANTS $2.81M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $804,312
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $660,387
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $375,300
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $69,601
20.608 MINIMUM PENALTIES FOR REPEAT OFFENDERS FOR DRIVING WHILE INTOXICATED $52,525
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $18,501
97.083 STAFFING FOR ADEQUATE FIRE AND EMERGENCY RESPONSE (SAFER) $12,229