Finding 4209 (2023-001)

Material Weakness
Requirement
M
Questioned Costs
-
Year
2023
Accepted
2023-12-13
Audit: 6523
Organization: City of Charlotte (NC)

AI Summary

  • Core Issue: The City failed to monitor its subrecipient for the Emergency Rental Assistance Program, lacking a formal plan for fiscal year 2023.
  • Impacted Requirements: Internal controls require proper review and documentation of subrecipient compliance with federal program requirements.
  • Recommended Follow-up: Develop written monitoring plans for each subrecipient program, including risk assessments and timelines, to ensure compliance with 2 CFR 200.332.

Finding Text

Department of Treasury Program Name: Emergency Rental Assistance Program Federal Assistance Listing Number: 21.023 Nonmaterial Noncompliance, Material Weakness – Subrecipient Monitoring Finding 2023-001 Criteria: An effective system of internal control contemplates that management properly review and assess the subrecipient through monitoring procedures and document the results of the procedures performed. This includes ensuring the subrecipient is following all direct and material compliance requirements applicable to each federal program. Condition: It was discovered while testing the program that the City did not monitor the activity of its subrecipient for the Emergency Rental Assistance Program and did not have a plan to complete monitoring for fiscal year 2023. However, the City did properly obtain and review the subrecipients single audit report for fiscal year 2022. Effect: The subrecipient could provide federal funds to ineligible individuals resulting in questioned costs that could go undetected by the City. Questioned Costs: No questioned costs were identified as a result of our procedures. Cause: The City has an overall policy on monitoring subrecipients but individual departments do not have formal policies or guidelines in place for specific monitoring plans on each of their subrecipients/programs. Recommendation: We recommend the City require, as part of their subrecipient policy, that departments have written monitoring plans for each program that utilizes subrecipients that includes, but is not limited to, an annual risk assessment of the subrecipient, timeline for monitoring (monthly, quarterly, semi-annually, annually) to take place and how it will communicate and follow up with any findings identified from the monitoring. Furthermore, management should further utilize 2 CFR 200.332 to ensure all monitoring requirements are met. Views of responsible officials: Management agrees with the finding and is implementing procedures to correct this which is further discussed in the corrective action plan. Corrective Action Plan: See Corrective Action Plan prepared by the City.

Corrective Action Plan

City of Charlotte Material Weakness Finding 2023-001 Corrective Action Plan: Because of the material weakness finding, the following actions have/will be taken: • The Finance Department will propose amendments to the Subrecipient Management policy, consistent with the external auditor’s recommendation. Amendments will include requirements for written monitoring plans to be maintained by departments. • Finance will work with departments with subrecipient arrangements to ensure understanding of the federal requirements, as well as to promote policy compliance. • Housing and Neighborhood Services will develop and implement a plan to perform an annual risk assessment to ensure compliance with the subrecipient management policy. • Any department that currently does not have a written monitoring plans will be required to develop and implement those plans. Each action stated in the corrective action plan will be completed during and by the end of fiscal year 2024. Responsible Parties: Rebecca Hefner, Acting Director Housing and Neighborhood Services Teresa Smith, Chief Financial Officer Finance Department October 31, 2023

Categories

Subrecipient Monitoring

Other Findings in this Audit

  • 4210 2023-001
    Material Weakness
  • 580651 2023-001
    Material Weakness
  • 580652 2023-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $37.60M
20.106 Airport Improvement Program $11.68M
20.507 Federal Transit_formula Grants $10.94M
14.218 Community Development Block Grants/entitlement Grants $5.76M
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $3.72M
66.458 Capitalization Grants for Clean Water State Revolving Funds $3.24M
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $1.72M
14.241 Housing Opportunities for Persons with Aids $1.43M
21.016 Equitable Sharing $1.17M
14.900 Lead-Based Paint Hazard Control in Privately-Owned Housing $829,915
97.U02 Tsa-Credentialing Screening & Intel Division $744,600
14.239 Home Investment Partnerships Program $550,970
97.U01 Tsa-Nedctp $404,000
66.040 State Clean Diesel Grant Program $390,207
14.231 Emergency Solutions Grant Program $327,228
16.741 Dna Backlog Reduction Program $299,983
21.023 Emergency Rental Assistance Program $299,608
16.922 Equitable Sharing Program $231,881
16.609 Project Safe Neighborhoods $172,991
14.913 Healthy Homes Production Program $141,563
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $105,095
97.042 Emergency Management Performance Grants $80,022
14.401 Fair Housing Assistance Program_state and Local $78,600
20.600 State and Community Highway Safety $75,307
16.540 Juvenile Justice and Delinquency Prevention_allocation to States $60,910
97.083 Staffing for Adequate Fire and Emergency Response (safer) $51,948
97.067 Homeland Security Grant Program $39,460
21.019 Coronavirus Relief Fund $39,340
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $31,253
20.525 State of Good Repair Grants Program $27,798
16.738 Edward Byrne Memorial Justice Assistance Grant Program $24,012
16.034 Coronavirus Emergency Supplemental Funding Program $19,147
20.530 Public Transportation Innovation $18,780
20.205 Highway Planning and Construction $18,617
20.500 Federal Transit_capital Investment Grants $16,999
97.044 Assistance to Firefighters Grant $9,161
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $3,079
16.833 National Sexual Assault Kit Initiative $2,825
95.001 High Intensity Drug Trafficking Areas Program $49