Finding 975807 (2023-003)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-05-31
Audit: 307847
Organization: Rock Island County, Illinois (IL)

AI Summary

  • Core Issue: Quarterly reports to the Treasury lack independent review, risking errors in submitted data.
  • Impacted Requirements: Failure to comply with CFR section 200.303 regarding effective internal controls over Federal awards.
  • Recommended Follow-up: Establish a formal review process for report submissions to ensure accuracy and compliance.

Finding Text

Assistance Listing Number: 21.027 Program Title: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Federal Agency: United States Department of Treasury Pass-through Entity: N/A Federal Award Identification Number / Year: N/A / 2023 Criteria: Per CFR section 200.303, "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in Standards for Internal Control in the Federal Government issued by the Comptroller General of the United States or the Internal Control Integrated Framework, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO)." Condition: Quarterly reports submitted to the United States Department of Treasury are not reviewed by someone other than the original preparer. Cause: The County has not established a formal process of review around reporting for grants received from the United States Department of Treasury. Effect: Eligible expenditure and other information included in the report submissions may include unidentified errors. Questioned Costs: None noted. Context: This represents a systemic matter as a formalized review process for reporting to the United States Department of Treasury does not exist. The sample of reports tested does not represent a statistically valid sample. Recommendation: We recommend the County implement formal, documented review controls around reports submitted to the United States Department of Treasury by someone other than the original preparer prior to submission. Management Response: Management has reviewed the finding and agrees.

Categories

Subrecipient Monitoring Reporting Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 399365 2023-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $6.53M
17.259 Wia Youth Activities $544,877
17.258 Wia Adult Program $445,916
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $302,547
17.278 Wia Dislocated Worker Formula Grants $204,064
20.205 Highway Planning and Construction $193,446
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $106,419
17.277 Workforce Investment Act (wia) National Emergency Grants $83,035
93.667 Social Services Block Grant $79,236
93.994 Maternal and Child Health Services Block Grant to the States $75,000
93.658 Foster Care_title IV-E $73,165
93.268 Immunization Cooperative Agreements $57,449
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $57,148
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $56,525
97.042 Emergency Management Performance Grants $52,877
93.008 Medical Reserve Corps Small Grant Program $48,750
93.069 Public Health Emergency Preparedness $45,609
97.056 Port Security Grant Program $31,961
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $31,621
93.566 Refugee and Entrant Assistance_state Administered Programs $24,269
20.509 Formula Grants for Rural Areas and Tribal Transit Program $15,821
14.900 Lead-Based Paint Hazard Control in Privately-Owned Housing $15,311
16.606 State Criminal Alien Assistance Program $7,219
93.563 Child Support Enforcement $4,207
16.738 Edward Byrne Memorial Justice Assistance Grant Program $3,769
66.605 Performance Partnership Grants $2,016
10.572 Wic Farmers' Market Nutrition Program (fmnp) $1,000