Finding 21165 (2022-001)

- Repeat Finding
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-08-29
Audit: 20257
Organization: Madison County (IL)
Auditor: Scheffel Boyle

AI Summary

  • Core Issue: The County failed to submit required quarterly reports for the COVID-19 Emergency Rental Assistance Program on time.
  • Impacted Requirements: Timely submission is necessary to comply with federal regulations and grant agreements.
  • Recommended Follow-Up: Implement a project report calendar, set reminders, and ensure all relevant employees are informed to prevent future delays.

Finding Text

Finding 2022-001 Federal Program Name: COVID-19 Emergency Rental Assistance Program AL Number: 21.023 Federal Agency: U.S. Department of the Treasury Pass-Through Grantor: N/A Criteria: Quarterly reports (ERA 1 and ERA 2) are required to be submitted by the 15th of the month following the end of the quarterly reporting period. Statement of Condition: The County did not submit timely reports for the following quarterly reporting periods: October-December 2021 and January-March 2022. Questioned Costs: None Effect of Condition: Failure to submit reports within the required time period puts the grantee in noncompliance with laws, regulations and provisions of contracts or grant agreements. Cause of Condition: Management oversight. Recommendation: The County should schedule the due dates of all project reports in order to avoid late filings. Response: MCCD recognizes the importance of timely filing of quarterly reports for this program and will continue to work to prevent this from occurring in the future. A department wide calendar of report deadlines will be prepared and made available to all departmental employees. Reminders will be set for future submission dates with notifications going to more than one employee. Extensions will be requested as needed and will be well documented and saved on a network drive accessible to all employees. MCCD?s policies and procedures will be updated to include the planned submission dates for future reporting. Please note, the employee charged with completing and submitting these reports is no longer with the County. MCCD will stress the importance of timely filing of these reports to the employee filling this position.

Corrective Action Plan

Finding No.: 2022-001 Condition: Reports are required to be submitted by the due dates with the Reports Deliverable Schedule of each grant agreement and the County did not submit the reports timely for two reporting periods. Plan: The County will schedule due dates of all project reports in order to avoid late filings. Anticipated Date of Completion: Ongoing Analysis Name of Contact Person(s): Christopher P. Otto, Community Development Administrator Management Response: MCCD recognizes the importance of timely filing of quarterly reports for this program and will continue to work to prevent this from occurring in the future. A department-wide calendar of report deadlines will be prepared and made available to all departmental employees. Reminders will be set for future submission dates with notifications going to more than one employee. Extensions will be requested as needed and will be well documented and saved on a network drive accessible to all employees. MCCD?s policies and procedures will be updated to include the planned submission dates for future reporting. Please note, the employee charged with completing and submitting these reports is no longer with the County. MCCD will stress the importance of timely filing of these reports to the employee filling this position. MCCD has put together the following planned submissions due date calendar for the ERA program. Planned Submission Dates of Future ERA Reports: Q2 2023 (April- June 2023) due 8/16/2023 Q3 2023 (July-September 2023) due 11/15/2023 Q4 2023 (October- December 2023) due 2/15/2023 Q1 2024 (January-March 2024) due 2/15/2023

Categories

Reporting Internal Control / Segregation of Duties Special Tests & Provisions

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
93.568 Low-Income Home Energy Assistance $7.44M
21.023 Emergency Rental Assistance Program $5.86M
14.218 Community Development Block Grants/entitlement Grants $3.20M
93.569 Community Services Block Grant $1.24M
17.258 Wia Adult Program $1.21M
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $1.04M
14.239 Home Investment Partnerships Program $815,440
17.259 Wia Youth Activities $649,864
14.231 Emergency Solutions Grant Program $615,404
17.278 Wia Dislocated Worker Formula Grants $547,985
21.019 Coronavirus Relief Fund $541,485
93.268 Immunization Cooperative Agreements $507,700
14.267 Continuum of Care Program $457,229
16.575 Crime Victim Assistance $445,491
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $417,312
93.563 Child Support Enforcement $344,954
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $262,134
81.042 Weatherization Assistance for Low-Income Persons $247,361
93.069 Public Health Emergency Preparedness $232,965
16.585 Drug Court Discretionary Grant Program $120,784
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $112,432
21.016 Equitable Sharing $104,535
16.738 Edward Byrne Memorial Justice Assistance Grant Program $94,882
17.277 Workforce Investment Act (wia) National Emergency Grants $84,208
21.027 Coronavirus State and Local Fiscal Recovery Funds $58,000
16.835 Body Worn Camera Policy and Implementation $53,589
93.586 State Court Improvement Program $50,400
93.669 Child Abuse and Neglect State Grants $45,620
16.034 Coronavirus Emergency Supplemental Funding Program $43,736
16.922 Equitable Sharing Program $36,827
97.042 Emergency Management Performance Grants $34,026
15.226 Payments in Lieu of Taxes $31,047
10.555 National School Lunch Program $29,485
93.136 Injury Prevention and Control Research and State and Community Based Programs $22,669
10.559 Summer Food Service Program for Children $21,150
10.553 School Breakfast Program $17,341
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $16,836
20.600 State and Community Highway Safety $16,266
17.245 Trade Adjustment Assistance $15,708
93.940 Hiv Prevention Activities_health Department Based $15,405
97.067 Homeland Security Grant Program $15,371
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $11,072
66.032 State Indoor Radon Grants $7,371
93.103 Food and Drug Administration_research $5,517
17.285 Apprenticeship USA Grants $1,902
66.605 Performance Partnership Grants $1,159