Audit 6523

FY End
2023-06-30
Total Expended
$237.47M
Findings
4
Programs
39
Organization: City of Charlotte (NC)
Year: 2023 Accepted: 2023-12-13

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
4209 2023-001 Material Weakness - M
4210 2023-001 Material Weakness - M
580651 2023-001 Material Weakness - M
580652 2023-001 Material Weakness - M

Programs

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

Contacts

Name Title Type
Y84GJESBH8W5 Betty Mattos Auditee
7043364940 Daniel Gougherty Auditor
No contacts on file

Notes to SEFA

Title: 1. Basis of Presentation Accounting Policies: Expenditures reported in the SEFSA are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal and State awards (SEFSA) includes the federal and State grant activity of the City of Charlotte, North Carolina (the “City”) under the programs of the federal government and the State of North Carolina for the year ended June 30, 2023. The information in this SEFSA is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards and the State Single Audit Implementation Act. Because the Schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position or cash flows of the City.

Finding Details

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.
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.
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.
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.