Finding 567911 (2024-001)

Material Weakness
Requirement
H
Questioned Costs
-
Year
2024
Accepted
2025-06-27
Audit: 360257
Organization: City of Livonia, Michigan (MI)

AI Summary

  • Core Issue: The City did not have effective controls to ensure that grant expenditures were made within the required timeframe.
  • Impacted Requirements: Compliance with federal regulations under 2 CFR 200.303 regarding the period of performance.
  • Recommended Follow-up: Strengthen internal controls to verify that all expenditures are reviewed for compliance with the period of performance before reimbursement requests are submitted.

Finding Text

Assistance Listing, Federal Agency, and Program Name COVID 19 21.027, U.S. Department of Treasury, Coronavirus State and Local Fiscal Recovery Fund Federal Award Identification Number and Year N/A Pass through Entity Michigan Department of Health and Human Services Finding Type Material weakness and material noncompliance with laws and regulations Repeat Finding No Criteria The City must establish and maintain effective internal controls to ensure compliance with federal requirements including period of performance as outlined in 2 CFR 200.303. Condition The City lacked adequate controls to verify that expenditures charged to the grant were incurred within the proper period of performance. Transactions were processed without sufficient review or procedures around the period of performance, resulting in expenditures being charged from outside the allowable timeframe. Questioned Costs None If questioned costs are not determinable, description of why known questioned costs were undetermined or otherwise could not be reported N/A Identification of How Questioned Costs Were Computed N/A Context During the year, the City requested reimbursement for $151,621 of expenditures that were not within the period of performance. Cause and Effect The City's control for identifying whether expenditures charged to the grant was not effective as it relied on the date of the vendor's invoice and not the period in which the services were performed. As a result, reports and reimbursement requests improperly included $64,109 of expenditures incurred prior to the period of performance. The City identified the error after year end and appropriately excluded the expenditures from the final SEFA. Later, it was discovered that an additional $87,512 was improperly included on the SEFA. The City removed the additional expenditures discovered from the SEFA as well, thus creating no questioned costs. Recommendation Internal controls should be strengthened to ensure expenditures are being properly reviewed for period of performance before submitting for reimbursement. Views of Responsible Officials and Corrective Action Plan The CIty concurs with this finding and has already implemented controls to look specifically at service period of expenditures when reviewing invoices and submitting reports and reimbursement requests.

Corrective Action Plan

Finding Number: 2024-001 Condition: The City lacked adequate controls to verify that expenditures charged to the grant were incurred within the proper period of performance. Transactions were processed without sufficient review or procedures around the period of performance, resulting in expenditures being charged from outside the allowable timeframe. Planned Corrective Action: The City has worked with the State to identify expenses outside the period of performance. The City has sent the money back to the State that was before the performance start date. All balances are properly stated as of November 30. 2024. Contact person responsible for corrective action: Connie Kumpula Anticipated Completion Date: 5/23/2025

Categories

Cash Management Material Weakness Period of Performance Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1144353 2024-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $1.54M
14.218 Community Development Block Grants/entitlement Grants $280,838
20.205 Highway Planning and Construction $209,285
97.044 Assistance to Firefighters Grant $70,842
16.922 Equitable Sharing Program $65,297
10.569 Emergency Food Assistance Program (food Commodities) $51,341
20.600 State and Community Highway Safety $23,294
16.U01 U.s. Marshals - Detroit Fugitive Apprehension Task Force $21,618
97.042 Emergency Management Performance Grants $13,706
16.U02 Federal Bureau of Investigation - Detroit Major Crimes Task Force $6,802
45.310 Grants to States $2,800
14.218 Covid-19 - Community Development Block Grants/entitlement Grants $2,751
14.239 Home Investment Partnerships Program $921