Finding 505399 (2023-003)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-11-12
Audit: 328076
Organization: Douglas County (IL)

AI Summary

  • Core Issue: The County failed to report $328,600 in expenses for the ARPA grant, indicating a lack of accurate financial monitoring.
  • Impacted Requirements: Compliance with 2 CFR 200.302, which mandates complete and current accounting records for federal and state grants.
  • Recommended Follow-Up: Implement a review process for grant reports before submission to ensure accuracy and compliance.

Finding Text

2023SA-003 Insufficient Grant Monitoring Federal Agency/Passthrough Agency: US Department of Treasury Program: Coronavirus State and Local Fiscal Recovery Fund- American Rescue Plan Act Federal Award Number: N/A Assistance Listing Number: 21.027 Material Weakness Material Noncompliance – Financial Management Criteria: 2 CFR 200.302 states that the Grantee must have an accounting system that provides accurate, current, and complete disclosure of all financial transactions related to each state and federally funded program. Accounting records must contain information pertaining to state and federal pass-through awards, authorizations, obligations, unobligated balances, assets, outlays, and income. The records must be maintained on a current basis and balances at least quarterly. Condition: The accounting records for the ARPA grant included $328,600 of expenses that were not reported on the annual grant report filed in March 2024. Context: From reviews of the County’s internal control and accounting procedures along with inquiries made, it was indicated that there was a high probability that transactions were not reported correctly. There is no review process in place. Effect: Inaccurate reporting of grant activity. Questioned Costs: None. Cause: There is a systematic problem with lack of adequate documentation and monitoring of expenses paid for with grant funds throughout the County. The County needs to be able to compile a complete list of grants for the entire County and monitor that the grant activity is property reported. The County needs to have a better understanding of grant reporting requirements, grant restrictions, and compliance requirements. Repeated Finding: No Recommendation: The County should have someone review grant reports prior to their submission. Management’s Response: The County will work to improve grant documentation and will consider implementing a review process to ensure the grant records agree to grant reports that are filed.

Corrective Action Plan

Finding 2023SA-003 Insufficient Grant Monitoring Comments on the Finding and Each Recommendation: The County agrees with the finding. Action(s) Taken or Planned on the Finding: The County will work to improve grant documentation and will consider implementing a review process to ensure the grant records agree to grant reports that are filed. Name of Contact Person: Judi Pollock, County Clerk Projected Completion Date: Unknown

Categories

Reporting Subrecipient Monitoring Material Weakness Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1081841 2023-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $876,406
20.509 Formula Grants for Rural Areas and Tribal Transit Program $137,000
93.268 Immunization Cooperative Agreements $96,169
93.994 Maternal and Child Health Services Block Grant to the States $75,000
16.738 Edward Byrne Memorial Justice Assistance Grant Program $51,026
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $39,416
10.559 Summer Food Service Program for Children $34,265
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $28,658
93.332 Cooperative Agreement to Support Navigators in Federally-Facilitated Exchanges $24,585
93.967 Centers for Disease Control and Prevention Collaboration with Academia to Strengthen Public Health $23,734
93.069 Public Health Emergency Preparedness $17,312
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $16,204
93.332 Cdc Partnership: Strengthening Public Health Laboratories $12,154
93.008 Medical Reserve Corps Small Grant Program $10,048
93.667 Social Services Block Grant $7,465
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $7,238
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $5,751
97.042 Emergency Management Performance Grants $4,293
93.788 Opioid Str $2,961
93.940 Hiv Prevention Activities Health Department Based $2,204
66.605 Performance Partnership Grants $138