Finding 1162584 (2024-006)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-11-18
Audit: 372262
Organization: Douglas County (IL)

AI Summary

  • Core Issue: The County lacks adequate controls for tracking and reporting grant income and expenses.
  • Impacted Requirements: Inaccurate compliance with the Schedule of Expenditures of Federal Awards and financial record reconciliation.
  • Recommended Follow-Up: Improve monitoring of grant spending and establish a comprehensive accounting process for accurate reporting.

Finding Text

2018-005 Inadequate Grant Recordkeeping Condition: The County receives numerous grants that require detail 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

  • 1162578 2024-003
    Material Weakness Repeat
  • 1162579 2024-004
    Material Weakness Repeat
  • 1162580 2024-005
    Material Weakness Repeat
  • 1162581 2024-006
    Material Weakness Repeat
  • 1162582 2024-007
    Material Weakness Repeat
  • 1162583 2024-005
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $424,065
93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $374,746
93.354 PUBLIC HEALTH EMERGENCY RESPONSE: COOPERATIVE AGREEMENT FOR EMERGENCY RESPONSE: PUBLIC HEALTH CRISIS RESPONSE $216,844
20.509 FORMULA GRANTS FOR RURAL AREAS AND TRIBAL TRANSIT PROGRAM $95,375
93.967 CENTERS FOR DISEASE CONTROL AND PREVENTION COLLABORATION WITH ACADEMIA TO STRENGTHEN PUBLIC HEALTH $89,886
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $74,796
97.039 HAZARD MITIGATION GRANT $37,648
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $36,323
20.505 METROPOLITAN TRANSPORTATION PLANNING AND STATE AND NON-METROPOLITAN PLANNING AND RESEARCH $28,313
93.332 COOPERATIVE AGREEMENT TO SUPPORT NAVIGATORS IN FEDERALLY-FACILITATED EXCHANGES $26,671
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $17,675
20.703 INTERAGENCY HAZARDOUS MATERIALS PUBLIC SECTOR TRAINING AND PLANNING GRANTS $16,326
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $15,000
93.008 MEDICAL RESERVE CORPS SMALL GRANT PROGRAM $13,420
93.236 GRANTS TO STATES TO SUPPORT ORAL HEALTH WORKFORCE ACTIVITIES $9,218
93.667 SOCIAL SERVICES BLOCK GRANT $8,254
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $6,254
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $4,813
93.940 HIV PREVENTION ACTIVITIES HEALTH DEPARTMENT BASED $960
66.605 PERFORMANCE PARTNERSHIP GRANTS $113
93.788 OPIOID STR $60