Finding 575308 (2024-005)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-09-02
Audit: 365342
Organization: Sangamon County, Illinois (IL)

AI Summary

  • Core Issue: The County lacks proper internal controls over compliance, leading to missing documentation for closeout performance reports and discrepancies in financial reporting.
  • Impacted Requirements: Compliance with Uniform Grant Guidance (2 CFR 200.303, 200.328, and 200.329) is at risk, as required documentation and reconciliations are not maintained.
  • Recommended Follow-Up: Implement robust internal controls to ensure documentation retention and reconciliation of reports, with independent reviews to verify accuracy before finalizing financial records.

Finding Text

2024 – 005 Reporting Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Low-Income Home Energy Assistance Program (LIHEAP) Assistance Listing Number: 93.568 Federal Award Identification Number and Year: G-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 Type of Finding: • Material Weakness in Internal Control over Compliance • Other Matters Criteria or Specific Requirement: Uniform Grant Guidance (2 CFR 200.303) requires non-federal entities receiving federal awards establish and maintain internal controls designed to reasonably ensure compliance with federal laws, regulations, and program compliance requirements. Uniform Grant Guidance (2 CFR 200.328 and 2 CFR 200.329)) requires non-federal entities to submit performance and financial reports as required by the pass-through entity award and to ensure that the data accumulated and summarized is in accordance with the required criteria and methodology. Effective internal controls should ensure grant closeout reports are supported by documentation of expenditures that have been incurred. Additionally, grant agreements requiring grant closeout reports should be reconciled to the accounting records. Condition: The County did not retain supporting documentation for closeout performance reports. Accounting records supporting the SEFA did not reconcile to the certified cost reported in the closeout financial reports. There were also instances where federal reimbursements did not align with project accounting code records. Questioned Costs: None Context: 2 of 3 closeout performance reports tested lacked supporting documentation. 2 of 3 closeout financial reports tested did not reconcile to the accounting records supporting the SEFA or to the project accounting code records. Cause: Supporting documentation for closeout performance reports was not retained. Additionally, adjustments made to the project accounting records after submission of the closeout financial reports and reconciliations resulted in discrepancies between reported and actual cost. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 005 Reporting (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-007. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to grant closeout reports and that supporting documentation is retained. A detailed, documented review of all reports should be conducted by someone other than the preparer to ensure completeness and accuracy. No financial activity should be recorded to the project accounting records after grant closeout reports are completed. Views of Responsible Officials: There is no disagreement with the audit finding.

Corrective Action Plan

County department personnel changes have been implemented, which address this deficiency. Additional training from the Auditor’s Office and state grantors has occurred for newer staff in certain departments with large amounts of federal and state awards.

Categories

Reporting Subrecipient Monitoring Cash Management Material Weakness Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 575298 2024-003
    Significant Deficiency Repeat
  • 575299 2024-003
    Significant Deficiency Repeat
  • 575300 2024-003
    Significant Deficiency Repeat
  • 575301 2024-003
    Significant Deficiency Repeat
  • 575302 2024-003
    Significant Deficiency Repeat
  • 575303 2024-004
    Material Weakness Repeat
  • 575304 2024-004
    Material Weakness Repeat
  • 575305 2024-004
    Material Weakness Repeat
  • 575306 2024-004
    Material Weakness Repeat
  • 575307 2024-004
    Material Weakness Repeat
  • 575309 2024-005
    Material Weakness Repeat
  • 575310 2024-005
    Material Weakness Repeat
  • 575311 2024-005
    Material Weakness Repeat
  • 575312 2024-005
    Material Weakness Repeat
  • 1151740 2024-003
    Significant Deficiency Repeat
  • 1151741 2024-003
    Significant Deficiency Repeat
  • 1151742 2024-003
    Significant Deficiency Repeat
  • 1151743 2024-003
    Significant Deficiency Repeat
  • 1151744 2024-003
    Significant Deficiency Repeat
  • 1151745 2024-004
    Material Weakness Repeat
  • 1151746 2024-004
    Material Weakness Repeat
  • 1151747 2024-004
    Material Weakness Repeat
  • 1151748 2024-004
    Material Weakness Repeat
  • 1151749 2024-004
    Material Weakness Repeat
  • 1151750 2024-005
    Material Weakness Repeat
  • 1151751 2024-005
    Material Weakness Repeat
  • 1151752 2024-005
    Material Weakness Repeat
  • 1151753 2024-005
    Material Weakness Repeat
  • 1151754 2024-005
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $12.38M
17.277 Wioa National Dislocated Worker Grants / Wia National Emergency Grants $272,385
93.788 Opioid Str $253,162
16.575 Crime Victim Assistance $244,552
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $228,684
20.205 Highway Planning and Construction $204,500
17.258 Wioa Adult Program $172,969
17.259 Wioa Youth Activities $149,753
93.959 Block Grants for Prevention and Treatment of Substance Abuse $127,737
20.509 Formula Grants for Rural Areas and Tribal Transit Program $124,282
93.568 Low-Income Home Energy Assistance $102,903
17.278 Wioa Dislocated Worker Formula Grants $94,895
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $94,401
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $93,061
81.042 Weatherization Assistance for Low-Income Persons $85,169
93.977 Sexually Transmitted Diseases (std) Prevention and Control Grants $55,343
93.069 Public Health Emergency Preparedness $49,944
93.967 Centers for Disease Control and Prevention Collaboration with Academia to Strengthen Public Health $49,744
16.922 Equitable Sharing Program $31,277
93.667 Social Services Block Grant $24,885
90.404 Hava Election Security Grants $23,373
93.569 Community Services Block Grant $23,333
93.994 Maternal and Child Health Services Block Grant to the States $13,150
20.616 National Priority Safety Programs $11,809
97.042 Emergency Management Performance Grants $10,000
16.738 Edward Byrne Memorial Justice Assistance Grant Program $9,711
93.008 Medical Reserve Corps Small Grant Program $6,444
93.563 Child Support Services $6,431
93.103 Food and Drug Administration Research $5,000
93.268 Immunization Cooperative Agreements $2,500
93.586 State Court Improvement Program $1,941
10.572 Wic Farmers' Market Nutrition Program (fmnp) $1,000
93.940 Hiv Prevention Activities Health Department Based $932
66.605 Performance Partnership Grants $647