Finding 1229052 (2025-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-09-08
Audit: 410512
Organization: Douglas County (IL)

AI Summary

  • Core Issue: The County lacks adequate controls for tracking and reporting grant income and expenses, leading to potential compliance issues.
  • Impacted Requirements: Reporting requirements for the Schedule of Expenditures of Federal Awards and reconciling with the Consolidated Year End Financial Report are not being met.
  • Recommended Follow-up: Implement a comprehensive grant accounting process, maintain a complete list of grants, and monitor spending to ensure accurate reporting.

Finding Text

2018-005 Inadequate Grant Recordkeeping Condition: The County receives numerous grants that require detailed reporting of income and expenses. The controls and procedures relative to accumulating information, allocating expenses, and preparing reports and financial statements is insufficient to accurately comply with reporting requirements, specifically the Schedule of Expenditures of Federal Awards and reconciling financial records to the Consolidated Year End Financial Report. The County needs to be continually monitoring grant spending and have a better understanding of their reporting requirements and also needs to implement a process of accounting for grants that produces accurate information that can be used to complete the required reports without a significant amount of effort. This includes having a complete list of grants for the entire County as a whole and monitoring that the grants have been spent correctly. Current Status: Currently a finding.

Corrective Action Plan

Inadequate Grant Recordkeeping The County will work to improve grant documentation and will consider having someone review grant reports prior to their submission. In the absence of necessary knowledge and expertise, the County will continue to rely on the auditors to assist with prepration of the Schedule of Expenditures of Federal Awards and reconciling the financial records to the Consolidated Year-End Financial Report.

Categories

Reporting Subrecipient Monitoring

Other Findings in this Audit

  • 1229050 2025-003
    Material Weakness Repeat
  • 1229051 2025-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $1.15M
93.967 CENTERS FOR DISEASE CONTROL AND PREVENTION COLLABORATION WITH ACADEMIA TO STRENGTHEN PUBLIC HEALTH $149,273
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $75,536
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $48,805
20.505 METROPOLITAN TRANSPORTATION PLANNING AND STATE AND NON-METROPOLITAN PLANNING AND RESEARCH $26,127
20.509 FORMULA GRANTS FOR RURAL AREAS AND TRIBAL TRANSIT PROGRAM $23,259
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $18,932
93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $17,700
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $12,641
93.236 GRANTS TO STATES TO SUPPORT ORAL HEALTH WORKFORCE ACTIVITIES $10,782
93.667 SOCIAL SERVICES BLOCK GRANT $7,020
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $6,286
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $5,442
97.039 HAZARD MITIGATION GRANT $4,368
20.703 INTERAGENCY HAZARDOUS MATERIALS PUBLIC SECTOR TRAINING AND PLANNING GRANTS $1,428
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $1,164
93.788 OPIOID STR $613
93.940 HIV PREVENTION AND SURVEILLANCE ACTIVITIES-HEALTH DEPARTMENT BASED $264
66.605 PERFORMANCE PARTNERSHIP GRANTS $125