Finding 1174656 (2024-002)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2024
Accepted
2026-02-19
Audit: 388217
Organization: City of Merced (CA)
Auditor: EIDE BAILLY LLP

AI Summary

  • Core Issue: Misreporting of $7,890,063 in federal expenditures under the wrong assistance listing number (AL #21.019 instead of AL #21.027).
  • Impacted Requirements: Compliance with Title 2 CFR Part 200, which mandates accurate reporting of federal awards.
  • Recommended Follow-up: The City should regularly review updated guidance from the U.S. Department of the Treasury to ensure correct reporting of grant programs.

Finding Text

Program: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing No.: 21.027 Federal Agency: U.S. Department of the Treasury Passed-through: N/A – direct award Award Number and Year: ARPA Compliance Requirement: Other Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) requires that management prepare schedule of expenditures of federal awards (schedule) showing the correct assistance listing (AL) numbers and program names. Condition: During the current year single audit, it was discovered that $7,890,063 in federal expenditures were misreported as AL #21.019. The Compliance and Reporting Guidance, published by the United States Department of the Treasury stipulated that grant awards that had issued under section 9901 of the American Rescue Plan Act should be reported under AL #21.027. Cause: The United States Department of the Treasury initially issued the grant award with AL #21.019 and the City did not review the additional guidance provided by the Department of Treasury that stipulated the AL change. Effect: A significant portion of the Coronavirus State & Local Fiscal Recovery Fund (CSLFRF) expenditures were properly identified as part of the program resulting in an understatement of the program. Questioned Costs: None Reported. Context/Sampling: Misstatement identified while testing SEFA. Repeat Finding from Prior Year: Yes. Recommendation: We recommend that the City review up-to-date guidance on all grant programs that is received to ensure correct reporting. Views of Responsible Officials and Planned Corrective Action: See separate corrective action plan.

Corrective Action Plan

Federal Agency: U.S. Department of the Treasury Program/Cluster: Coronavirus State and Local Fiscal Recovery Funds Federal Assistance Listing Number: 21.027 Pass‐through: n/a – direct award Award No. and Year: ARPA 2021 Compliance Requirement: Other Type of Finding: Material Weakness in Internal Control over Compliance Views of Responsible Officials and Corrective Action Plan: In this instance, the program’s listing number was not updated to reflect the most recent amendment announced by the Federal government. While listing numbers typically remain unchanged once assigned to a program, an exception occurred in this case and was not identified due to prior practices. In response, the Finance Management Team has established new procedures and directed responsible staff to periodically review federal guidelines and implement any necessary updates in the City’s system to ensure compliance and accuracy including changes in the listing numbers. Responsible Individual(s): Kuljit Singh, Deputy Finance Officer Anticipated Completion Date: January 31, 2026

Categories

Reporting

Other Findings in this Audit

  • 1174655 2024-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.019 COVID 19 - CORONAVIRUS RELIEF FUND $7.89M
21.027 COVID 19 - CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $6.20M
20.106 COVID 19 - AIRPORT IMPROVEMENT PROGRAM, INFRASTRUCTURE INVESTMENT AND JOBS ACT PROGRAMS, AND COVID-19 AIRPORTS PROGRAMS $3.13M
97.044 ASSISTANCE TO FIREFIGHTERS GRANT $826,121
97.083 STAFFING FOR ADEQUATE FIRE AND EMERGENCY RESPONSE (SAFER) $685,144
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $292,735
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $69,777
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $46,168
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $38,070
20.205 HIGHWAY PLANNING AND CONSTRUCTION $35,797
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $13,314
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $7,735
20.106 AIRPORT IMPROVEMENT PROGRAM, INFRASTRUCTURE INVESTMENT AND JOBS ACT PROGRAMS, AND COVID-19 AIRPORTS PROGRAMS $1,896