Finding 578007 (2022-007)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-11-09
Audit: 2802
Organization: Sangamon County, Illinois (IL)

AI Summary

  • Core Issue: There is a material weakness in internal controls over compliance for the LIHEAP program, specifically regarding financial reporting.
  • Impacted Requirements: The lack of supporting documentation for quarterly financial reports violates Uniform Grant Guidance (2 CFR 200.303), which mandates proper internal controls and documentation.
  • Recommended Follow-Up: Implement controls to ensure accounting records align with financial reports and retain all necessary documentation; avoid adjustments after submitting grant close-out reports.

Finding Text

2022 – 007 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: 2102ILLIEA 10/1/2020; 2102ILE5C6 03/22/2021 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 21-221038; 21-274038 Award Period: June 1, 2021 through September 30, 2022 and July 1, 2021 through September 30, 2022 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. Effective internal controls should include ensuring the quarterly financial reporting be supported by documentation of expenditures that have been incurred. In addition, grant agreements requiring grant close-out reports should reconcile to the accounting records. Condition: Supporting documentation for the quarterly financial reporting accounting records were not maintained. There was in instance in which the accounting records did not agree to the grant reconciliation submitted with the grant close-out package. Questioned costs: None Context: 3 of 4 quarterly financial reports tested did not have supporting documentation retained. 1 of 2 financial close out reports tested had accounting records that did not agree to the amounts reported. Cause: Support for the quarterly financial reports could not be provided as it was not retained. Adjustments made to the project accounting records after the close out report package was submitted caused the report to have inaccurate information. Effect: Lack of proper documentation for reported information can lead to an over or under reporting of grant expenditures. Repeat Finding: No Recommendation: We recommend the County design controls to ensure the accounting records reconcile to the quarterly financial reporting and grant close-out reports and documentation be retained. No financial activity should be recorded to the project accounting records after the grant close out report package is completed. Views of responsible officials: There is no disagreement with the audit finding.

Categories

Material Weakness Reporting Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1553 2022-003
    Significant Deficiency Repeat
  • 1554 2022-004
    Significant Deficiency
  • 1555 2022-005
    Material Weakness
  • 1556 2022-006
    Material Weakness
  • 1557 2022-007
    Material Weakness
  • 1558 2022-008
    Significant Deficiency
  • 1559 2022-005
    Material Weakness
  • 1560 2022-006
    Material Weakness
  • 1561 2022-007
    Material Weakness
  • 1562 2022-008
    Significant Deficiency
  • 1563 2022-005
    Material Weakness
  • 1564 2022-006
    Material Weakness
  • 1565 2022-007
    Material Weakness
  • 1566 2022-008
    Significant Deficiency
  • 577995 2022-003
    Significant Deficiency Repeat
  • 577996 2022-004
    Significant Deficiency
  • 577997 2022-005
    Material Weakness
  • 577998 2022-006
    Material Weakness
  • 577999 2022-007
    Material Weakness
  • 578000 2022-008
    Significant Deficiency
  • 578001 2022-005
    Material Weakness
  • 578002 2022-006
    Material Weakness
  • 578003 2022-007
    Material Weakness
  • 578004 2022-008
    Significant Deficiency
  • 578005 2022-005
    Material Weakness
  • 578006 2022-006
    Material Weakness
  • 578008 2022-008
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $2.04M
93.568 Low-Income Home Energy Assistance $1.09M
17.278 Wia Dislocated Worker Formula Grants $433,514
93.788 Opioid Str $325,361
20.509 Formula Grants for Rural Areas and Tribal Transit Program $319,011
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $304,959
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $269,893
17.258 Wia Adult Program $256,434
93.563 Child Support Enforcement $173,669
20.205 Highway Planning and Construction $125,585
81.042 Weatherization Assistance for Low-Income Persons $120,472
93.268 Immunization Cooperative Agreements $117,717
93.569 Community Services Block Grant $97,094
16.922 Equitable Sharing Program $93,959
17.259 Wia Youth Activities $79,946
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $75,493
93.069 Public Health Emergency Preparedness $49,178
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $38,057
16.575 Crime Victim Assistance $35,943
93.667 Social Services Block Grant $34,559
97.039 Hazard Mitigation Grant $31,782
20.616 National Priority Safety Programs $19,980
93.586 State Court Improvement Program $16,754
97.042 Emergency Management Performance Grants $7,411
17.277 Workforce Investment Act (wia) National Emergency Grants $6,617
90.404 2018 Hava Election Security Grants $6,338
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $5,630
16.738 Edward Byrne Memorial Justice Assistance Grant Program $2,246
10.555 National School Lunch Program $1,768
66.605 Performance Partnership Grants $1,508
93.994 Maternal and Child Health Services Block Grant to the States $1,103
10.572 Wic Farmers' Market Nutrition Program (fmnp) $1,000
10.553 School Breakfast Program $598
17.245 Trade Adjustment Assistance $65